Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Fixed
-
None
-
None
-
None
Description
mysql Ver 15.1 Distrib 5.5.25-MariaDB, for Linux (x86_64) using readline 5.1
|
Id User Host db Command Time State Info Progress
|
711 root 127.0.0.1:52513 NULL Query 270 executing SHOW /*!50002 GLOBAL*/ STATUS 0.000
|
712 root 127.0.0.1:52514 NULL Sleep 0 NULL 0.000
|
4843 root localhost NULL Query 539 NULL SHOW /*innotop*/ ENGINE INNODB STATUS 0.000
|
5514 root localhost egw_amnesty_be Query 543 Opening tables optimize table egw_amnesty_be.egw_sitemgr_pages_lang 0.000
|
5562 root localhost egw_apartment91_ Query 543 Opening tables optimize table egw_apartment91_.egw_sitemgr_blocks 0.000
|
5565 root localhost egw_apd_egroupwa Query 543 rename result table optimize table egw_apd_egroupwa.egw_wiki_rate 0.000
|
5575 root localhost egw_aquisys Query 543 Opening tables optimize table egw_aquisys.egw_nextid 0.000
|
5581 root localhost egw_ara_egroupwa Query 543 After create optimize table egw_ara_egroupwa.egw_accounts 0.000
|
5586 root localhost egw_arbora_klett Query 541 creating table alter table egw_arbora_klett.egw_access_log engine=innodb 0.000
|
5587 root localhost NULL Query 541 NULL drop database `egw_arbora` 0.000
|
5639 observium localhost NULL Query 488 executing SHOW /*!50002 GLOBAL */ STATUS 0.000
|
5936 observium localhost NULL Sleep 189 NULL 0.000
|
61
|
The deadlock occurred during a migration job doing things in parallel restauring dababase myisam tables from dump
Selecting from information_schema
Alter some table to innobb
Optimizing table
At least tables 150 tables * 1000 schema
Reproduce deadlock with in-house script
cnf , error log and 2 stack traces in http://pastebin.com/xtQ6v6yJ
Contact Ralf Becker <email address hidden> on top of skysql consulting