MySQL auto-increment problem

[Anon]

Everything was going fine and dandy, and now all of a sudden, the "next autoindex" value on one of my tables skyrocketed from 305174 to 576460752303722115. And from what I've heard, PHP has some problem handling integers that size. Something like this has happened twice tonight. Anybody have a clue what might be wrong? Or, more importantly, how to fix it?

[Anon]

oh my god u prick!!!!!!!!!!!
y r1 u obsesed by a fucking data base that has gon wrong?!!!!
what you need 2 find out is...................
how 2 get a life!!!!!!!!!!!!!!
oh by the way what do u make a data base on?
luv me xxxxxx

[brandonschnell]

i'd have mysql check the integrity of the database. the mysql table file containing the next auto_increment value may be screwed up.

if that doesn't work simplify your code and table to the minimum to recreate the problem then post the code here.

[[deleted]]

Indeed, run myisamchk to fix the tables.

[[deleted]]

uhm... you suck.

[Anon]

Hallo Geordie,

How old are you? To say some thing, choose Place, Condition and Time.

This forum is allowed only for educational purpose. If you are interested to have such type of conversation, there are so many sites on the Internet so look at it.

Please be a person of responsility. Consider Professional ethics...

OK?

Thank you

[Anon]

I am able to repair the problems... but then they happen again. And it is at random times. as I mentioned, I got 300,000 records before I ever encountered any problem, then it happened twice, and it hasn't happened since. All that, with no change in code.

I read something on the MySQL site about random table corrruption associated with the 2.2.14 linux kernel. Something about the I/O implementation. maybe upgrading to a new kernel will help my problem.

[Anon]

...and it just happened again.

it's a quick fix. but I have to delete all the rows which have the high IDs, which isn't something that appeals to me.