percona-discussion team mailing list archive

[LCM <lmargulin@xxxxxxxxxx>]

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.

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.