Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 538046 - dev-db/mysql-5.6.22: crashed - mysqld got signal 11 on /usr/sbin/mysqld(_Z9get_fieldP11st_mem_rootP5Field+0x30)
Summary: dev-db/mysql-5.6.22: crashed - mysqld got signal 11 on /usr/sbin/mysqld(_Z9ge...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL: http://bugs.mysql.com/bug.php?id=67319
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-28 14:37 UTC by cilly
Modified: 2015-01-29 18:40 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
emerge --info (emerge-info.txt,5.65 KB, text/plain)
2015-01-28 14:37 UTC, cilly
Details
mysql.err crash log (mysqld-crash.txt,2.59 KB, text/plain)
2015-01-28 14:38 UTC, cilly
Details

Note You need to log in before you can comment on or make changes to this bug.
Description cilly 2015-01-28 14:37:50 UTC
Created attachment 395052 [details]
emerge --info

dev-db/mysql-5.6.22: crashed - mysqld got signal 11
Comment 1 cilly 2015-01-28 14:38:21 UTC
Created attachment 395054 [details]
mysql.err crash log
Comment 2 cilly 2015-01-28 14:39:06 UTC
downgraded to version: 5.5.40, no crash
Comment 3 Tomáš Mózes 2015-01-28 14:57:53 UTC
Did this happen after upgrading or during normal operation?
Comment 4 Brian Evans (RETIRED) gentoo-dev 2015-01-28 15:10:33 UTC
I would like to see the mysqld.err log starting from the first startup of 5.6.22.

Was mysql_upgrade run?
Comment 5 Brian Evans (RETIRED) gentoo-dev 2015-01-28 15:14:07 UTC
Also post my.cnf as well.
Comment 6 Brian Evans (RETIRED) gentoo-dev 2015-01-29 15:01:48 UTC
Did you happen to skip running mysql_upgrade on 5.5.40?

http://bugs.mysql.com/bug.php?id=67319 seems relevant.
Comment 7 cilly 2015-01-29 16:15:37 UTC
(In reply to Tomas Mozes from comment #3)
> Did this happen after upgrading or during normal operation?

This happened after upgrading from 5.5.40.
Comment 8 cilly 2015-01-29 16:16:36 UTC
(In reply to Brian Evans from comment #5)
> Also post my.cnf as well.

my.cnf is default, updated with etc-update
Comment 9 Brian Evans (RETIRED) gentoo-dev 2015-01-29 16:30:05 UTC
From #gentoo:

11:20:12 AM - grknight: cilly: mysql_upgrade works similar to the mysql cli client.. needs user and password
11:20:51 AM - cilly: grknight: never used it
11:21:05 AM - cilly: grknight: just created my tables once and thats it
11:21:11 AM - grknight: cilly: it is critical to use for each major/minor update
11:21:48 AM - grknight: cilly: 5.1 -> 5.5 is critical to use as well
11:23:04 AM - cilly: grknight: I had no issues until 5.6
11:23:11 AM - cilly: grknight: everything worked flawlessly
11:24:00 AM - grknight: cilly: really depends on what is used, but 5.6 looks for an index and crashes when mysql_upgrade is not run on a 5.5 install

The mysql_upgrade script must be run on each major.minor update or problems may occur.  Upstream does not support jumping versions without it as noted in ${URL}
Comment 10 cilly 2015-01-29 17:24:36 UTC
After running `mysql_upgrade -u root -p` on version 5.5.40, then reinstalled 5.6.22. It works now. Thx to Brian Evans.