[MDEV-700] LP:1021737 - deadlock inside xtradb on DDL operation Created: 2012-07-06  Updated: 2013-03-26  Resolved: 2013-03-26

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Stephane VAROQUI (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1021737.xml    

 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



 Comments   
Comment by Stephane VAROQUI (Inactive) [ 2012-07-06 ]

Re: deadlock inside xtradb on DDL operation
Code used to get the issue

http://pastebin.com/nVh0ZQD2

Looks similar to

https://bugs.launchpad.net/percona-server/+bug/1007268

Need to try to reproduce with

Comment by Rasmus Johansson (Inactive) [ 2012-07-06 ]

Launchpad bug id: 1021737

Comment by Elena Stepanova [ 2013-03-26 ]

The related bug family in XtraDB seems to be fixed by now (LP:1007268, LP:1038225, LP:1040735), so we can presume this issue got fixed along with them until there is evidence of the opposite (it wasn't reproducible with the provided data before, there were missing pieces of information, so the exact scenario can't be checked).

Generated at Thu Feb 08 06:30:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.