Mysql update crashes

Support/Development for MySQL, MariaDB, and other database systems
DarkF@der
Forum Regular
Forum Regular
Posts: 313
Joined: Thu May 07, 2009 12:46 pm

Mysql update crashes

Unread post by DarkF@der »

Hello,

Why everytime when there is a new update out of mysql it crash?

Code: Select all

*** glibc detected *** /usr/libexec/mysqld: double free or corruption (fasttop): 0x000000000ec2eb00 ***
======= Backtrace: =========
/lib64/libc.so.6[0x319947174f]
/lib64/libc.so.6(cfree+0x4b)[0x3199475a4b]
/usr/libexec/mysqld(_ZN16Security_context7destroyEv+0x14e)[0x553e0e]
/usr/libexec/mysqld(_ZN3THDD0Ev+0x147)[0x556927]
/usr/libexec/mysqld(_Z10unlink_thdP3THD+0x92)[0x5086f2]
/usr/libexec/mysqld(_Z29one_thread_per_connection_endP3THDb+0x28)[0x508758]
/usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0xbf)[0x61af8f]
/usr/libexec/mysqld(handle_one_connection+0x5e)[0x61b0de]
/lib64/libpthread.so.0[0x3199c0683d]
/lib64/libc.so.6(clone+0x6d)[0x31994d526d]
======= Memory map: ========
00400000-00c8c000 r-xp 00000000 08:02 113647628                          /usr/libexec/mysqld
00e8b000-00fa3000 rw-p 0088b000 08:02 113647628                          /usr/libexec/mysqld
00fa3000-00fcc000 rw-p 00000000 00:00 0
018e6000-0ed2f000 rw-p 00000000 00:00 0                                  [heap]
3199000000-319901c000 r-xp 00000000 08:02 113824324                      /lib64/ld-2.5.so
319921c000-319921d000 r--p 0001c000 08:02 113824324                      /lib64/ld-2.5.so
319921d000-319921e000 rw-p 0001d000 08:02 113824324                      /lib64/ld-2.5.so
3199400000-319954f000 r-xp 00000000 08:02 113824325                      /lib64/libc-2.5.so
319954f000-319974f000 ---p 0014f000 08:02 113824325                      /lib64/libc-2.5.so
319974f000-3199753000 r--p 0014f000 08:02 113824325                      /lib64/libc-2.5.so
3199753000-3199754000 rw-p 00153000 08:02 113824325                      /lib64/libc-2.5.so
3199754000-3199759000 rw-p 00000000 00:00 0
3199800000-3199802000 r-xp 00000000 08:02 113824330                      /lib64/libdl-2.5.so
3199802000-3199a02000 ---p 00002000 08:02 113824330                      /lib64/libdl-2.5.so
3199a02000-3199a03000 r--p 00002000 08:02 113824330                      /lib64/libdl-2.5.so
3199a03000-3199a04000 rw-p 00003000 08:02 113824330                      /lib64/libdl-2.5.so
3199c00000-3199c16000 r-xp 00000000 08:02 113824328                      /lib64/libpthread-2.5.so
3199c16000-3199e16000 ---p 00016000 08:02 113824328                      /lib64/libpthread-2.5.so
3199e16000-3199e17000 r--p 00016000 08:02 113824328                      /lib64/libpthread-2.5.so
3199e17000-3199e18000 rw-p 00017000 08:02 113824328                      /lib64/libpthread-2.5.so
3199e18000-3199e1c000 rw-p 00000000 00:00 0
319a000000-319a014000 r-xp 00000000 08:02 113824327                      /lib64/libz.so.1.2.3
319a014000-319a213000 ---p 00014000 08:02 113824327                      /lib64/libz.so.1.2.3
319a213000-319a214000 rw-p 00013000 08:02 113824327                      /lib64/libz.so.1.2.3
319a400000-319a482000 r-xp 00000000 08:02 113824332                      /lib64/libm-2.5.so
319a482000-319a681000 ---p 00082000 08:02 113824332                      /lib64/libm-2.5.so
319a681000-319a682000 r--p 00081000 08:02 113824332                      /lib64/libm-2.5.so
319a682000-319a683000 rw-p 00082000 08:02 113824332                      /lib64/libm-2.5.so
319a800000-319a839000 r-xp 00000000 08:02 113824347                      /lib64/libsepol.so.1
319a839000-319aa39000 ---p 00039000 08:02 113824347                      /lib64/libsepol.so.1
319aa39000-319aa3a000 rw-p 00039000 08:02 113824347                      /lib64/libsepol.so.1
319ac00000-319ac15000 r-xp 00000000 08:02 113824352                      /lib64/libselinux.so.1
319ac15000-319ae15000 ---p 00015000 08:02 113824352                      /lib64/libselinux.so.1
319ae15000-319ae17000 rw-p 00015000 08:02 113824352                      /lib64/libselinux.so.1
319ae17000-319ae18000 rw-p 00000000 00:00 0
319b000000-319b009000 r-xp 00000000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b009000-319b208000 ---p 00009000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b208000-319b209000 r--p 00008000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b209000-319b20a000 rw-p 00009000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b20a000-319b238000 rw-p 00000000 00:00 0
319b400000-319b407000 r-xp 00000000 08:02 113824336                      /lib64/librt-2.5.so
319b407000-319b607000 ---p 00007000 08:02 113824336                      /lib64/librt-2.5.so
319b607000-319b608000 r--p 00007000 08:02 113824336                      /lib64/librt-2.5.so
319b608000-319b609000 rw-p 00008000 08:02 113824336                      /lib64/librt-2.5.so
319b800000-319b811000 r-xp 00000000 08:02 113770971                      /lib64/libresolv-2.5.so
319b811000-319ba11000 ---p 00011000 08:02 113770971                      /lib64/libresolv-2.5.so
319ba11000-319ba12000 r--p 00011000 08:02 113770971                      /lib64/libresolv-2.5.so
319ba12000-319ba13000 rw-p 00012000 08:02 113770971                      /lib64/libresolv-2.5.so
319ba13000-319ba15000 rw-p 00000000 00:00 0
319c000000-319c002000 r-xp 00000000 08:02 113824380                      /lib64/libcom_err.so.2.1
319c002000-319c201000 ---p 00002000 08:02 113824380                      /lib64/libcom_err.so.2.1
319c201000-319c202000 rw-p 00001000 08:02 113824380                      /lib64/libcom_err.so.2.1
319c400000-319c40d000 r-xp 00000000 08:02 113824334                      /lib64/libgcc_s-4.1.2-20080825.so.1
319c40d000-319c60d000 ---p 0000d000 08:02 113824334                      /lib64/libgcc_s-4.1.2-20080825.so.1
319c60d000-319c60e000 rw-p 0000d000 08:02 113824334                      /lib64/libgcc_s-4.1.2-20080825.so.1
319c800000-319c802000 r-xp 00000000 08:02 113824346                      /lib64/libkeyutils-1.2.so
319c802000-319ca01000 ---p 00002000 08:02 113824346                      /lib64/libkeyutils-1.2.so
319ca01000-319ca02000 rw-p 00001000 08:02 113824346                      /lib64/libkeyutils-1.2.so
319d000000-319d008000 r-xp 00000000 08:02 113648151                      /usr/lib64/libkrb5support.so.0.1
319d008000-319d207000 ---p 00008000 08:02 113648151                      /usr/lib64/libkrb5support.so.0.1
319d207000-319d208000 rw-p 00007000 08:02 113648151                      /usr/lib64/libkrb5support.so.0.1
319d400000-319d491000 r-xp 00000000 08:02 113649450                      /usr/lib64/libkrb5.so.3.3
319d491000-319d691000 ---p 00091000 08:02 113649450                      /usr/lib64/libkrb5.so.3.3
319d691000-319d695000 rw-p 00091000 08:02 113649450                      /usr/lib64/libkrb5.so.3.3
319d800000-319d82c000 r-xp 00000000 08:02 113656962                      /usr/lib64/libgssapi_krb5.so.2.2
319d82c000-319da2c000 ---p 0002c000 08:02 113656962                      /usr/lib64/libgssapi_krb5.so.2.2
319da2c000-319da2e000 rw-p 0002c000 08:02 113656962                      /usr/lib64/libgssapi_krb5.so.2.2
319dc00000-319dc24000 r-xp 00000000 08:02 113649436                      /usr/lib64/libk5crypto.so.3.1*** glibc detected *** /usr/libexec/mysqld: double free or corruption (fasttop): 0x000000000f304da0 ***
======= Backtrace: =========
/lib64/libc.so.6[0x319947174f]
/lib64/libc.so.6(cfree+0x4b)[0x3199475a4b]
/usr/libexec/mysqld(_ZN16Security_context7destroyEv+0x14e)[0x553e0e]
/usr/libexec/mysqld(_ZN3THDD0Ev+0x147)[0x556927]
/usr/libexec/mysqld(_Z10unlink_thdP3THD+0x92)[0x5086f2]
/usr/libexec/mysqld(_Z29one_thread_per_connection_endP3THDb+0x28)[0x508758]
/usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0xbf)[0x61af8f]
/usr/libexec/mysqld(handle_one_connection+0x5e)[0x61b0de]
/lib64/libpthread.so.0[0x3199c0683d]
/lib64/libc.so.6(clone+0x6d)[0x31994d526d]
======= Memory map: ========
00400000-00c8c000 r-xp 00000000 08:02 113647628                          /usr/libexec/mysqld
00e8b000-00fa3000 rw-p 0088b000 08:02 113647628                          /usr/libexec/mysqld
00fa3000-00fcc000 rw-p 00000000 00:00 0
01fbc000-0f6d2000 rw-p 00000000 00:00 0                                  [heap]
3199000000-319901c000 r-xp 00000000 08:02 113824324                      /lib64/ld-2.5.so
319921c000-319921d000 r--p 0001c000 08:02 113824324                      /lib64/ld-2.5.so
319921d000-319921e000 rw-p 0001d000 08:02 113824324                      /lib64/ld-2.5.so
3199400000-319954f000 r-xp 00000000 08:02 113824325                      /lib64/libc-2.5.so
319954f000-319974f000 ---p 0014f000 08:02 113824325                      /lib64/libc-2.5.so
319974f000-3199753000 r--p 0014f000 08:02 113824325                      /lib64/libc-2.5.so
3199753000-3199754000 rw-p 00153000 08:02 113824325                      /lib64/libc-2.5.so
3199754000-3199759000 rw-p 00000000 00:00 0
3199800000-3199802000 r-xp 00000000 08:02 113824330                      /lib64/libdl-2.5.so
3199802000-3199a02000 ---p 00002000 08:02 113824330                      /lib64/libdl-2.5.so
3199a02000-3199a03000 r--p 00002000 08:02 113824330                      /lib64/libdl-2.5.so
3199a03000-3199a04000 rw-p 00003000 08:02 113824330                      /lib64/libdl-2.5.so
3199c00000-3199c16000 r-xp 00000000 08:02 113824328                      /lib64/libpthread-2.5.so
3199c16000-3199e16000 ---p 00016000 08:02 113824328                      /lib64/libpthread-2.5.so
3199e16000-3199e17000 r--p 00016000 08:02 113824328                      /lib64/libpthread-2.5.so
3199e17000-3199e18000 rw-p 00017000 08:02 113824328                      /lib64/libpthread-2.5.so
3199e18000-3199e1c000 rw-p 00000000 00:00 0
319a000000-319a014000 r-xp 00000000 08:02 113824327                      /lib64/libz.so.1.2.3
319a014000-319a213000 ---p 00014000 08:02 113824327                      /lib64/libz.so.1.2.3
319a213000-319a214000 rw-p 00013000 08:02 113824327                      /lib64/libz.so.1.2.3
319a400000-319a482000 r-xp 00000000 08:02 113824332                      /lib64/libm-2.5.so
319a482000-319a681000 ---p 00082000 08:02 113824332                      /lib64/libm-2.5.so
319a681000-319a682000 r--p 00081000 08:02 113824332                      /lib64/libm-2.5.so
319a682000-319a683000 rw-p 00082000 08:02 113824332                      /lib64/libm-2.5.so
319a800000-319a839000 r-xp 00000000 08:02 113824347                      /lib64/libsepol.so.1
319a839000-319aa39000 ---p 00039000 08:02 113824347                      /lib64/libsepol.so.1
319aa39000-319aa3a000 rw-p 00039000 08:02 113824347                      /lib64/libsepol.so.1
319ac00000-319ac15000 r-xp 00000000 08:02 113824352                      /lib64/libselinux.so.1
319ac15000-319ae15000 ---p 00015000 08:02 113824352                      /lib64/libselinux.so.1
319ae15000-319ae17000 rw-p 00015000 08:02 113824352                      /lib64/libselinux.so.1
319ae17000-319ae18000 rw-p 00000000 00:00 0
319b000000-319b009000 r-xp 00000000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b009000-319b208000 ---p 00009000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b208000-319b209000 r--p 00008000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b209000-319b20a000 rw-p 00009000 08:02 113824344                      /lib64/libcrypt-2.5.so
319b20a000-319b238000 rw-p 00000000 00:00 0
319b400000-319b407000 r-xp 00000000 08:02 113824336                      /lib64/librt-2.5.so
319b407000-319b607000 ---p 00007000 08:02 113824336                      /lib64/librt-2.5.so
319b607000-319b608000 r--p 00007000 08:02 113824336                      /lib64/librt-2.5.so
319b608000-319b609000 rw-p 00008000 08:02 113824336                      /lib64/librt-2.5.so
319b800000-319b811000 r-xp 00000000 08:02 113770971                      /lib64/libresolv-2.5.so
319b811000-319ba11000 ---p 00011000 08:02 113770971                      /lib64/libresolv-2.5.so
319ba11000-319ba12000 r--p 00011000 08:02 113770971                      /lib64/libresolv-2.5.so
319ba12000-319ba13000 rw-p 00012000 08:02 113770971                      /lib64/libresolv-2.5.so
319ba13000-319ba15000 rw-p 00000000 00:00 0
319c000000-319c002000 r-xp 00000000 08:02 113824380                      /lib64/libcom_err.so.2.1
319c002000-319c201000 ---p 00002000 08:02 113824380                      /lib64/libcom_err.so.2.1
319c201000-319c202000 rw-p 00001000 08:02 113824380                      /lib64/libcom_err.so.2.1
319c400000-319c40d000 r-xp 00000000 08:02 113824334                      /lib64/libgcc_s-4.1.2-20080825.so.1
319c40d000-319c60d000 ---p 0000d000 08:02 113824334                      /lib64/libgcc_s-4.1.2-20080825.so.1
319c60d000-319c60e000 rw-p 0000d000 08:02 113824334                      /lib64/libgcc_s-4.1.2-20080825.so.1
319c800000-319c802000 r-xp 00000000 08:02 113824346                      /lib64/libkeyutils-1.2.so
319c802000-319ca01000 ---p 00002000 08:02 113824346                      /lib64/libkeyutils-1.2.so
319ca01000-319ca02000 rw-p 00001000 08:02 113824346                      /lib64/libkeyutils-1.2.so
319d000000-319d008000 r-xp 00000000 08:02 113648151                      /usr/lib64/libkrb5support.so.0.1
319d008000-319d207000 ---p 00008000 08:02 113648151                      /usr/lib64/libkrb5support.so.0.1
319d207000-319d208000 rw-p 00007000 08:02 113648151                      /usr/lib64/libkrb5support.so.0.1
319d400000-319d491000 r-xp 00000000 08:02 113649450                      /usr/lib64/libkrb5.so.3.3
319d491000-319d691000 ---p 00091000 08:02 113649450                      /usr/lib64/libkrb5.so.3.3
319d691000-319d695000 rw-p 00091000 08:02 113649450                      /usr/lib64/libkrb5.so.3.3
319d800000-319d82c000 r-xp 00000000 08:02 113656962                      /usr/lib64/libgssapi_krb5.so.2.2
319d82c000-319da2c000 ---p 0002c000 08:02 113656962                      /usr/lib64/libgssapi_krb5.so.2.2
319da2c000-319da2e000 rw-p 0002c000 08:02 113656962                      /usr/lib64/libgssapi_krb5.so.2.2
319dc00000-319dc24000 r-xp 00000000 08:02 113649436                      /usr/lib64/libk5crypto.so.3.1
Normaly it will not happen but the last 2 -3 update this happen. (on all of my machines).



Greets
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql update crashes

Unread post by scott »

Are you running a plesk system by any chance?
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: Mysql update crashes

Unread post by faris »

Happened on all my systems too. A reboot resolves it. Yes, Plesk.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
DarkF@der
Forum Regular
Forum Regular
Posts: 313
Joined: Thu May 07, 2009 12:46 pm

Re: Mysql update crashes

Unread post by DarkF@der »

scott wrote:Are you running a plesk system by any chance?
Thank you for the reply.
Yes i'm running plesk on all machines.

@faris you don't need to reboot! Just stop mysql and start it again.
spaceout
Forum Regular
Forum Regular
Posts: 112
Joined: Wed Mar 19, 2008 10:22 pm

Re: Mysql update crashes

Unread post by spaceout »

This is happening on my system as well. Plesk 11.5.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql update crashes

Unread post by scott »

So theres a special routine Parallels asked me to add in there, and I wonder if that is the culprit. Theres a way to skip it during the upgrade, if you set the variable ATOMIC_SKIP:

export ATOMIC_SKIP=1

so you could try that before an upgrade and see if the error changes. Or you could just try it on a system that doesnt have plesk on it and see if that changes anything.
prupert
Forum Regular
Forum Regular
Posts: 573
Joined: Tue Aug 01, 2006 2:45 pm
Location: Netherlands

Re: Mysql update crashes

Unread post by prupert »

scott wrote:So theres a special routine Parallels asked me to add in there, and I wonder if that is the culprit. Theres a way to skip it during the upgrade, if you set the variable ATOMIC_SKIP:

export ATOMIC_SKIP=1

so you could try that before an upgrade and see if the error changes. Or you could just try it on a system that doesnt have plesk on it and see if that changes anything.
What is this special routine?

We haven't seen the issues on non-Plesk machines. On all Plesk machines though, troubles. Nothing a MySQL restart can't fix though. The 5.5.36 update from February caused the same issues, as reported in https://www.atomicorp.com/forum/viewtop ... f=3&t=7501
Lemonbit Internet Dedicated Server Management
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql update crashes

Unread post by scott »

Its an upgrade routine: http://fpaste.org/93963/39742946/
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: Mysql update crashes

Unread post by faris »

heck, if that breaks in the wrong place it has the potential to hose a system.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: Mysql update crashes

Unread post by faris »

Well, I tried

export ATOMIC_SKIP=1

before upgrading MySQL just now, and I still got all that debug stuff on the screen every time I restart MySQL.

Rebooting resolved the problem.

Might I be doing something wrong? I put the export command in a script, after which I then upgrade MySQL. Is the exported variable limited to the contents of the script (and since there's nothing in the script except the export it gets lost?)?
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql update crashes

Unread post by scott »

Yeah that was just a guess on my part. I dont think thats it
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: Mysql update crashes

Unread post by faris »

No crash on any of my systems after the latest mysql update. Yay!

What's changed?

Thanks for fixing it, whatever it was.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql update crashes

Unread post by scott »

I think its something core, nothing in the pre/post installation operations have changed.
Post Reply