Hooligancat's questions

We have a MySQL table that has an auto-incrementing field set as an INT (11). This table pretty much stores a list of jobs that are running in an application. At any given moment during the lifetime of the application, the table could well contain thousands of entries or be completely empty (i.e. everything has finished).

The field is not foreign-keyed to anything else.

The auto-increment seems to randomly reset itself to zero, although we have never actually been able to trap the reset.

The problem becomes evident because we see the auto-increment field get up to, say, 600,000 records or so and then a while later the auto-increment field seems to be running in the low 1000's.

It is almost as if the auto-increment resets itself if the table is empty.

Is this possible and if it is, how do I turn it off or change the manner in which it resets?

If it isn't, does anyone have an explanation of why it might be doing this?

Thanks!

My Windows Vista and Windows 7 clients are having problems maintaining access to SMB shares on a Mac server. The initial connection to the server appears to be OK, as the Windows clients can see all of the server share points. However, the client randomly drops a couple of the server share points although the clients can still see the server.

For example. If I have the following share points on the Mac server:

Share A
Share B
Share C
Share D
Share E

The Windows client can see these shares most of the time and can access them most of the time. But randomly a couple of the shares will just get dropped or go missing from the Windows client's ability to view them so I end up with something like:

Share B
Share D
Share E

All the share points are established int the same way with the same permission settings. My Mac OSX Server is set up with the following for SMB:

SMB sharing enabled
Standalone Server
Workgroup of `CORPORATE`
Allow Guest Access = YES
Client connections limit = 100
Authentication: NTLMv2 & Kerberos and NTLM
Code Page is Latin US (437)
This is a workgroup master browser
WINS registration is set to Enable WINS server (tried with setting off)
Enable virtual share points for homes YES

I noticed in my SMB file service log that the clients appear to connect OK, but I get the following error which implies a reset by either the server or the client:

/SourceCache/samba/samba-187.9/samba/source/lib/util_sock.c:read_data(534)
   read_data: read failure for 4 bytes to client 192.168.0.99. 
   = Connection reset by peer

I am a bit stumped as to a direction to turn to try and get this to resolve. Continued attempts to access the server from the client will reconnect to the share points, but they inevitably get dropped again in the near future.

Any and all help much appreciated.