Comment 3 for bug 1123233

Revision history for this message
Dmitry Gribov (grib-d) wrote :

No, nothing simmilar. Sent to your e-mail with my logs.

Also noticed that with the very same table on the 5.2 MySQL (developer PC) query sometimes just hangs forever in "Sending data" on some requiest. Changing datatype `hits` smallint(5) unsigned NOT NULL, to `hits` int(10) unsigned NOT NULL, helps.
This huge tables make lots of trouble, somehow.

And I almost always see errors like "mysqldump: Error 1213: Deadlock found when trying to get lock; try restarting transaction when dumping table `spam_hits` at row: 5696359" while dumping unloaded node with options like this:

--single-transaction --allow-keyword --extended-insert --max-allowed-packet=20M\
 --default-character-set=utf8 --quick

I guess this is something really abnormal since --single-transaction dump is not acquiring any read-locks or whatever. And yet here is the write-error on read-request. Do not understand it.

And yet the databese without the index is stable (exept I can't dump it unless made inconsistent with --skip-lock-tables).