Bug #26427 Serial Log possible gap: 142463 - 115862 - Duplicate INDEXES.SYSTEM
Submitted: 15 Feb 2007 21:20 Modified: 18 Sep 2007 14:01
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:5.2.4-falcon-alpha-debug OS:Linux (suse 9.3 x86)
Assigned to: CPU Architecture:Any

[15 Feb 2007 21:20] Shane Bester 
Description:
when using many threads to alter the engine of many tables to falcon, myisam, innodb, the error logs start filling up with errors like this:

Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXFIELDS.SYSTEM
Duplicate INDEXES.SYSTEM

until a crash happens at some point.

How to repeat:
will upload a testcase shortly.

Suggested fix:
not sure.
[17 Feb 2007 14:46] MySQL Verification Team 
I'm attaching a bug26427.c file which can be compiled and run against the server to cause the reported errors.

note: you will see alot of errors like 
query failed 'ALTER TABLE `table82` ENGINE=FALCON' : 1025 (Error on rename of './test/table82' to './test/#sql2-3a0c-1e' (errno: -2))

before you actually get this in the error logs:

Duplicate INDEXES.SYSTEM
Duplicate INDEXFIELDS.SYSTEM
Duplicate INDEXES.SYSTEM
Duplicate INDEXES.SYSTEM

leave testcase running for normally 10 - 20 minutes.
[17 Feb 2007 14:47] MySQL Verification Team 
see top of file for build, host, port, user, database variables.

Attachment: bug26427.zip (application/zip, text), 75.06 KiB.
[17 Feb 2007 14:50] MySQL Verification Team 
I need to check whether the message 
"Serial Log possible gap: x - y"
ever appears with this testcase.
[18 Sep 2007 14:01] Hakan Küçükyılmaz 
Can't repeat anymore. Concurrent ALTER TABLES are properly locked now.

query failed 'ALTER TABLE `table3932` ENGINE=FALCON' : 1015 (Can't lock file (errno: 156))
query failed 'ALTER TABLE `table3997` ENGINE=MyISAM' : 1015 (Can't lock file (errno: 156))
query failed 'ALTER TABLE `table3996` ENGINE=MyISAM' : 1015 (Can't lock file (errno: 156))
query failed 'ALTER TABLE `table3978` ENGINE=FALCON' : 1015 (Can't lock file (errno: 156))
[1]+  Done                    emacs bug26427.c

Best regards,

Hakan
[5 Dec 2007 8:45] MySQL Verification Team 
Hakan, I'm quite sure it's a bug that you even get those 156 errors. Also, I've seen 212 errno.  Can you explain the root cause of these two errors, and their origin (OS, falcon, mysql)?