Bug #20400 mysqld got signal 10
Submitted: 12 Jun 2006 15:21 Modified: 15 Jul 2006 16:41
Reporter: [ name withheld ] Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:mysql-standard-5.0.16-osx10.3-powerpc OS:MacOS (Mac OS X 10.3.9)
Assigned to: CPU Architecture:Any

[12 Jun 2006 15:21] [ name withheld ]
Description:
MySql server crashes when creating a webblog with the apache roller software.
My config:

Mac OS X 10.3.9
java version "1.4.2_09"
mysql-connector-java-3.1.10
mysql-standard-5.0.16-osx10.3-powerpc
jakarta-tomcat-5.5.9
Roller 2.1.1 release

There are no probs with mysql using an other program with JDBC.
Note that I have posted this report to http://www.nabble.com/Mac-OS-X-10.3.9%3A-mysql-crashes-t1767105s12275.html , too.

The daemon crashes and reports this:
"mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=3
max_connections=100
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation."

following the first three errors from /jakarta-tomcat-5.5.9/logs/roller.log :
(snip because too long)

In the $Path2Mysql/data/*.err file is no hint for the reason of the crash.

After fixing the $Path2Mysql/data/roller/website table with myisamchk -r I started the mysqld --log with this result:
"
select this_.id as id7_, this_.categoryid as categoryid16_7_, this_.websiteid as websiteid16_7_, this_.userid as userid16_7_, this_.title as title16_7_, this_.text as text16_7_, this_.anchor as anchor16_7_, this_.pubtime as pubtime16_7_, this_.updatetime as updatetime16_7_, this_.status as status16_7_, this_.link as link16_7_, this_.plugins as plugins16_7_, this_.allowcomments as allowco13_16_7_, this_.commentdays as comment14_16_7_, this_.righttoleft as rightto15_16_7_, this_.pinnedtomain as pinnedt16_16_7_, weblogcate3_.id as id0_, weblogcate3_.name as name14_0_, weblogcate3_.description as descript3_14_0_, weblogcate3_.image as image14_0_, weblogcate3_.websiteid as websiteid14_0_, websitedat4_.id as id1_, websitedat4_.handle as handle17_1_, websitedat4_.name as name17_1_, websitedat4_.description as descript4_17_1_, websitedat4_.userid as userid17_1_, websitedat4_.defaultpageid as defaultp6_17_1_, websitedat4_.weblogdayid as weblogda7_17_1_, websitedat4_.enablebloggerapi as enablebl8_17_1_, websitedat4_.bloggercatid as bloggerc9_17_1_, websitedat4_.defaultcatid as default10_17_1_, websitedat4_.editorpage as editorpage17_1_, websitedat4_.blacklist as blacklist17_1_, websitedat4_.allowcomments as allowco13_17_1_, websitedat4_.defaultallowcomments as default14_17_1_, websitedat4_.defaultcommentdays as default15_17_1_, websitedat4_.commentmod as commentmod17_1_, websitedat4_.emailcomments as emailco17_17_1_, websitedat4_.emailfromaddress as emailfr18_17_1_, websitedat4_.emailaddress as emailad19_17_1_, websitedat4_.editortheme as editort20_17_1_, websitedat4_.locale as locale17_1_, websitedat4_.timeZone as timeZone17_1_, websitedat4_.datecreated as datecre23_17_1_, websitedat4_.defaultplugins as default24_17_1_, websitedat4_.isenabled as isenabled17_1_, websitedat4_.displaycnt as displaycnt17_1_, w1_.id as id2_, w1_.handle as handle17_2_, w1_.name as name17_2_, w1_.description as descript4_17_2_, w1_.userid as userid17_2_, w1_.defaultpageid as defaultp6_17_2_, w1_.weblogdayid as weblogda7_17_2_, w1_.enablebloggerapi as enablebl8_17_2_, w1_.bloggercatid as bloggerc9_17_2_, w1_.defaultcatid as default10_17_2_, w1_.editorpage as editorpage17_2_, w1_.blacklist as blacklist17_2_, w1_.allowcomments as allowco13_17_2_, w1_.defaultallowcomments as default14_17_2_, w1_.defaultcommentdays as default15_17_2_, w1_.commentmod as commentmod17_2_, w1_.emailcomments as emailco17_17_2_, w1_.emailfromaddress as emailfr18_17_2_, w1_.emailaddress as emailad19_17_2_, w1_.editortheme as editort20_17_2_, w1_.locale as locale17_2_, w1_.timeZone as timeZone17_2_, w1_.datecreated as datecre23_17_2_, w1_.defaultplugins as default24_17_2_, w1_.isenabled as isenabled17_2_, w1_.displaycnt as displaycnt17_2_, userdata6_.id as id3_, userdata6_.isenabled as isenabled13_3_, userdata6_.username as username13_3_, userdata6_.passphrase as passphrase13_3_, userdata6_.fullname as fullname13_3_, userdata6_.emailaddress as emailadd6_13_3_, userdata6_.datecreated as datecrea7_13_3_, userdata6_.locale as locale13_3_, userdata6_.timeZone as timeZone13_3_, weblogcate7_.id as id4_, weblogcate7_.name as name14_4_, weblogcate7_.description as descript3_14_4_, weblogcate7_.image as image14_4_, weblogcate7_.websiteid as websiteid14_4_, weblogcate8_.id as id5_, weblogcate8_.name as name14_5_, weblogcate8_.description as descript3_14_5_, weblogcate8_.image as image14_5_, weblogcate8_.websiteid as websiteid14_5_, userdata9_.id as id6_, userdata9_.isenabled as isenabled13_6_, userdata9_.username as username13_6_, userdata9_.passphrase as passphrase13_6_, userdata9_.fullname as fullname13_6_, userdata9_.emailaddress as emailadd6_13_6_, userdata9_.datecreated as datecrea7_13_6_, userdata9_.locale as locale13_6_, userdata9_.timeZone as timeZone13_6_ from weblogentry this_ inner join weblogcategory weblogcate3_ on this_.categoryid=weblogcate3_.id left outer join website websitedat4_ on weblogcate3_.websiteid=websitedat4_.id inner join website w1_ on this_.websiteid=w1_.id left outer join rolleruser userdata6_ on w1_.userid=userdata6_.id left outer join weblogcategory weblogcate7_ on w1_.bloggercatid=weblogcate7_.id left outer join weblogcategory weblogcate8_ on w1_.defaultcatid=weblogcate8_.id inner join rolleruser userdata9_ on this_.userid=userdata9_.id where w1_.isenabled='1' and this_.pubtime<='2006-06-12 17:01:27' and this_.pinnedtomain='1' order by this_.pubtime desc limit 5
"
I started mysql from the command line and try to execute the command found in that 'hostname'.log given above - indeed mysqld crashes.

What can I do ?

How to repeat:
Start mysql from the command line and try to execute the command found in that 'hostname'.log given above - indeed mysqld crashes.
[12 Jun 2006 20:12] [ name withheld ]
Note that I recognized that this failure is not only involved with roller, but now also with JForum, so this failure has other causes than the roller-software, I think ! 
Sorry for this bug-report .
[13 Jun 2006 10:49] [ name withheld ]
I figured out that I had no my.cnf at all. I created one and made a mistake during the changing of the my.cnf. Now JForum does work fine again, no signal 10 anymore. The cause for the crash of JForum was the ';' at the end in that row:
innodb_data_file_path=ibdata1:10M:autoextend ;
which i deleted then.
Now I will install the new roller version and will report what happens.
[13 Jun 2006 11:29] Valeriy Kravchuk
> Now I will install the new roller version and will report what happens.

Please, reopen this report when you'll have results of your new test.
[14 Jun 2006 18:46] [ name withheld ]
I installed the new roller 2.3-incubation.
But with same results :-(
Then, after the crash my JForum is no more usable anymore, too.
[14 Jun 2006 19:23] [ name withheld ]
I tried:
../data > mv roller rollerBAK
and created an new roller db.
so if there is a harddisk failure, it would be 'encapsulated'.
But after restarting roller => crash.
I am not really familar with the ibdata and that stuff, so I guess I made a mistake (i.e. configuring the my.cnf AFTER using the the ibdata1 and so on) ?
[15 Jun 2006 16:41] Valeriy Kravchuk
Try to repeat with a newer version of MySQL server, 5.0.22, and inform about the results. Your 5.0.16 is really old.
[15 Jul 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".