percona-discussion team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

On Thu, May 21, 2009 at 10:53 AM, LCM <lmargulin@xxxxxxxxxx> wrote:
> Vadim,
>   We finally got our gdb issue resolved. Turns out the PowerPC has a 64-bit version of gdb that we needed to use.  Attached is the stack trace generated while the db server was locked up.

Many thread are sleeping in the sync array waiting for the log_sys->mutex.
One thread is sleeping in the sync array waiting for the buffer pool mutex.

srv_lock_timeout_and_monitor_thread, which should wake threads that
missed a wakeup, appears to not be stuck.

On one pass through the stack it isn't obvious whether another thread
holds log_sys->mutex.

>
> Lee
>
> -----Original Message-----
> From: bounces@xxxxxxxxxxxxx [mailto:bounces@xxxxxxxxxxxxx] On Behalf Of Vadim Tkachenko
> Sent: Thursday, May 21, 2009 6:05 AM
> To: Lee Margulin
> Subject: Re: [Bug 378100] Re: Innodb locks up under large INSERT load
>
> Jeremy,
>
> Yes, we use gcc automic builtins, and currently it is the same as
> InnoDB-plugin and MySQL 5.4.
>
> Jeremy Kerr wrote:
>> Vadim,
>>
>> As far as I can see, the xtradb code uses the gcc builtin atomic
>> primitives for the locks, so these should work cross-platform. Is there
>> anything specifically architecture dependent that I should be looking
>> at?
>>
>> Anyone know if the xtradb backend will pass the mysql testsuite on
>> PowerPC? Happy to try it out if not.
>>
>> Jeremy
>>
>
>
> --
> Vadim Tkachenko, CTO
> Percona Inc.
> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
> MySQL Performance Blog - http://www.mysqlperformanceblog.com
> MySQL Consulting http://www.percona.com/
>
> --
> Innodb locks up under large INSERT load
> https://bugs.launchpad.net/bugs/378100
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Percona XtraDB Storage Engine for MySQL: New
>
> Bug description:
> While trying to load a new db on the 5.1.34-xtradb build, the Innodb engine locks up after a few minutes with multiple table loads running.
>
> I can still log into the server, but I don't get any data back from the
> SHOW ENGINE INNODB STATUS command. I also can't kill any of the existing
> INSERT commands. I can reproduce the problem with as few as 3
> simulateous loads (INSERT) occurring.
>
> I am running this on SuSE version 10 with 8 processors and 126GB of RAM.
>
> Can I get some help in troubleshooting this? There are no messages being
> written to the error log.
>
>
> ** Attachment added: "debug.txt"
>   http://launchpadlibrarian.net/27024409/debug.txt
>
> --
> Innodb locks up under large INSERT load
> https://bugs.launchpad.net/bugs/378100
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona-XtraDB.
>
> Status in Percona XtraDB Storage Engine for MySQL: New
>
> Bug description:
> While trying to load a new db on the 5.1.34-xtradb build, the Innodb engine locks up after a few minutes with multiple table loads running.
>
> I can still log into the server, but I don't get any data back from the SHOW ENGINE INNODB STATUS command. I also can't kill any of the existing INSERT commands. I can reproduce the problem with as few as 3 simulateous loads (INSERT) occurring.
>
> I am running this on SuSE version 10 with 8 processors and 126GB of RAM.
>
> Can I get some help in troubleshooting this? There are no messages being written to the error log.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~percona-discussion
> Post to     : percona-discussion@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~percona-discussion
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Mark Callaghan
mdcallag@xxxxxxxxx