MySQL ошибка - Error: Failed while fetching Server version! Could be due to unauthorized access. FATAL ERROR: Upgrade failed


Материал из Wiki - Iphoster - 'the best ever support'

Перейти к: навигация, поиск

Самые выгодные сервера? в рунете


MySQL ошибка - Error: Failed while fetching Server version! Could be due to unauthorized access. FATAL ERROR: Upgrade failed

После обновления mysql через atomic репозиторий при запуске mysql_upgrade возникает ошибка:

# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
*** glibc detected *** /usr/libexec/mysqld: double free or corruption (fasttop): 0x00007f1c98004a60 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x75e66)[0x7f1cbc1f0e66]
/usr/libexec/mysqld(_ZN16Security_context7destroyEv+0xb4)[0x562ba4]
/usr/libexec/mysqld(_ZN3THDD1Ev+0x13d)[0x5667bd]
/usr/libexec/mysqld(_ZN3THDD0Ev+0x9)[0x566b99]
/usr/libexec/mysqld(_Z10unlink_thdP3THD+0xfa)[0x51883a]
/usr/libexec/mysqld(_Z29one_thread_per_connection_endP3THDb+0x16)[0x5188a6]
/usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x139)[0x621af9]
/usr/libexec/mysqld(handle_one_connection+0x5b)[0x621bdb]
/lib64/libpthread.so.0(+0x79d1)[0x7f1cbdd5f9d1]
/lib64/libc.so.6(clone+0x6d)[0x7f1cbc2639dd]
======= Memory map: ========
00400000-00c73000 r-xp 00000000 08:02 16633186                           /usr/libexec/mysqld
00e72000-00f8a000 rw-p 00872000 08:02 16633186                           /usr/libexec/mysqld
00f8a000-0197c000 rw-p 00000000 00:00 0                                  [heap]
7f1c98000000-7f1c98030000 rw-p 00000000 00:00 0
7f1c98030000-7f1c9c000000 ---p 00000000 00:00 0
7f1ca0000000-7f1ca0021000 rw-p 00000000 00:00 0
7f1ca0021000-7f1ca4000000 ---p 00000000 00:00 0
7f1ca5e4a000-7f1ca5e4b000 ---p 00000000 00:00 0
7f1ca5e4b000-7f1ca664b000 rw-p 00000000 00:00 0                          [stack:4415]
7f1ca664b000-7f1ca664c000 ---p 00000000 00:00 0
7f1ca664c000-7f1ca6e4c000 rw-p 00000000 00:00 0                          [stack:4414]
7f1ca6e4c000-7f1ca6e4d000 ---p 00000000 00:00 0
7f1ca6e4d000-7f1ca764d000 rw-p 00000000 00:00 0                          [stack:4413]
7f1ca764d000-7f1ca764e000 ---p 00000000 00:00 0
7f1ca764e000-7f1ca80db000 rw-p 00000000 00:00 0                          [stack:4416]
7f1ca8477000-7f1ca8478000 ---p 00000000 00:00 0
7f1ca8478000-7f1ca84b8000 rw-p 00000000 00:00 0                          [stack:4429]
7f1ca84b8000-7f1ca84b9000 ---p 00000000 00:00 0
7f1ca84b9000-7f1ca84f9000 rw-p 00000000 00:00 0                          [stack:4417]
7f1ca84f9000-7f1ca84fa000 ---p 00000000 00:00 0
7f1ca84fa000-7f1ca8cfa000 rw-p 00000000 00:00 0                          [stack:4411]
7f1ca8cfa000-7f1ca8cfb000 ---p 00000000 00:00 0
7f1ca8cfb000-7f1ca94fb000 rw-p 00000000 00:00 0                          [stack:4410]
7f1ca94fb000-7f1ca94fc000 ---p 00000000 00:00 0
7f1ca94fc000-7f1ca9cfc000 rw-p 00000000 00:00 0                          [stack:4409]
7f1ca9cfc000-7f1ca9cfd000 ---p 00000000 00:00 0
7f1ca9cfd000-7f1caa4fd000 rw-p 00000000 00:00 0                          [stack:4408]
7f1caa4fd000-7f1caa4fe000 ---p 00000000 00:00 0
7f1caa4fe000-7f1caacfe000 rw-p 00000000 00:00 0                          [stack:4407]
7f1caacfe000-7f1caacff000 ---p 00000000 00:00 0
7f1caacff000-7f1cab4ff000 rw-p 00000000 00:00 0                          [stack:4406]
7f1cab4ff000-7f1cab500000 ---p 00000000 00:00 0
7f1cab500000-7f1cb4000000 rw-p 00000000 00:00 0                          [stack:4405]
7f1cb4000000-7f1cb4021000 rw-p 00000000 00:00 0
7f1cb4021000-7f1cb8000000 ---p 00000000 00:00 0
7f1cb803d000-7f1cb803e000 ---p 00000000 00:00 0
7f1cb803e000-7f1cb883e000 rw-p 00000000 00:00 0                          [stack:4404]
7f1cb883e000-7f1cb883f000 ---p 00000000 00:00 0
7f1cb883f000-7f1cba351000 rw-p 00000000 00:00 0                          [stack:4403]
7f1cba351000-7f1cba35d000 r-xp 00000000 08:02 44302436                   /lib64/libnss_files-2.12.so
7f1cba35d000-7f1cba55d000 ---p 0000c000 08:02 44302436                   /lib64/libnss_files-2.12.so
7f1cba55d000-7f1cba55e000 r--p 0000c000 08:02 44302436                   /lib64/libnss_files-2.12.so
7f1cba55e000-7f1cba55f000 rw-p 0000d000 08:02 44302436                   /lib64/libnss_files-2.12.so
7f1cba55f000-7f1cba560000 ---p 00000000 00:00 0
7f1cba560000-7f1cbad60000 rw-p 00000000 00:00 0                          [stack:4402]
7f1cbad60000-7f1cbad7d000 r-xp 00000000 08:02 44302668                   /lib64/libselinux.so.1
7f1cbad7d000-7f1cbaf7c000 ---p 0001d000 08:02 44302668                   /lib64/libselinux.so.1
7f1cbaf7c000-7f1cbaf7d000 r--p 0001c000 08:02 44302668                   /lib64/libselinux.so.1
7f1cbaf7d000-7f1cbaf7e000 rw-p 0001d000 08:02 44302668                   /lib64/libselinux.so.1
7f1cbaf7e000-7f1cbaf7f000 rw-p 00000000 00:00 0
7f1cbaf7f000-7f1cbaf95000 r-xp 00000000 08:02 44302740                   /lib64/libresolv-2.12.so
7f1cbaf95000-7f1cbb195000 ---p 00016000 08:02 44302740                   /lib64/libresolv-2.12.so
7f1cbb195000-7f1cbb196000 r--p 00016000 08:02 44302740                   /lib64/libresolv-2.12.so
7f1cbb196000-7f1cbb197000 rw-p 00017000 08:02 44302740                   /lib64/libresolv-2.12.so
7f1cbb197000-7f1cbb199000 rw-p 00000000 00:00 0
7f1cbb199000-7f1cbb19b000 r-xp 00000000 08:02 44302716                   /lib64/libkeyutils.so.1.3
7f1cbb19b000-7f1cbb39a000 ---p 00002000 08:02 44302716                   /lib64/libkeyutils.so.1.3
7f1cbb39a000-7f1cbb39b000 r--p 00001000 08:02 44302716                   /lib64/libkeyutils.so.1.3
7f1cbb39b000-7f1cbb39c000 rw-p 00002000 08:02 44302716                   /lib64/libkeyutils.so.1.3
7f1cbb39c000-7f1cbb3a6000 r-xp 00000000 08:02 44302741                   /lib64/libkrb5support.so.0.1
7f1cbb3a6000-7f1cbb5a5000 ---p 0000a000 08:02 44302741                   /lib64/libkrb5support.so.0.1
7f1cbb5a5000-7f1cbb5a6000 r--p 00009000 08:02 44302741                   /lib64/libkrb5support.so.0.1
7f1cbb5a6000-7f1cbb5a7000 rw-p 0000a000 08:02 44302741                   /lib64/libkrb5support.so.0.1
7f1cbb5a7000-7f1cbb5d0000 r-xp 00000000 08:02 44302444                   /lib64/libk5crypto.so.3.1
7f1cbb5d0000-7f1cbb7d0000 ---p 00029000 08:02 44302444                   /lib64/libk5crypto.so.3.1
7f1cbb7d0000-7f1cbb7d1000 r--p 00029000 08:02 44302444                   /lib64/libk5crypto.so.3.1
7f1cbb7d1000-7f1cbb7d2000 rw-p 0002a000 08:02 44302444                   /lib64/libk5crypto.so.3.1
7f1cbb7d2000-7f1cbb7d3000 rw-p 00000000 00:00 0
7f1cbb7d3000-7f1cbb7d6000 r-xp 00000000 08:02 44302726                   /lib64/libcom_err.so.2.1
7f1cbb7d6000-7f1cbb9d5000 ---p 00003000 08:02 44302726                   /lib64/libcom_err.so.2.1
7f1cbb9d5000-7f1cbb9d6000 r--p 00002000 08:02 44302726                   /lib64/libcom_err.so.2.1
7f1cbb9d6000-7f1cbb9d7000 rw-p 00003000 08:02 44302726                   /lib64/libcom_err.so.2.1
7f1cbb9d7000-7f1cbbab2000 r-xp 00000000 08:02 44302690                   /lib64/libkrb5.so.3.3
7f1cbbab2000-7f1cbbcb2000 ---p 000db000 08:02 44302690                   /lib64/libkrb5.so.3.3
7f1cbbcb2000-7f1cbbcbc000 r--p 000db000 08:02 44302690                   /lib64/libkrb5.so.3.3
7f1cbbcbc000-7f1cbbcbe000 rw-p 000e5000 08:02 44302690                   /lib64/libkrb5.so.3.3
7f1cbbcbe000-7f1cbbcff000 r-xp 00000000 08:02 44302705                   /lib64/libgssapi_krb5.so.2.2
7f1cbbcff000-7f1cbbeff000 ---p 00041000 08:02 44302705                   /lib64/libgssapi_krb5.so.2.2
7f1cbbeff000-7f1cbbf00000 r--p 00041000 08:02 44302705                   /lib64/libgssapi_krb5.so.2.2
7f1cbbf00000-7f1cbbf02000 rw-p 00042000 08:02 44302705                   /lib64/libgssapi_krb5.so.2.2
7f1cbbf02000-7f1cbbf75000 r-xp 00000000 08:02 44302343                   /lib64/libfreebl3.so
7f1cbbf75000-7f1cbc174000 ---p 00073000 08:02 44302343                   /lib64/libfreebl3.so
7f1cbc174000-7f1cbc176000 r--p 00072000 08:02 44302343                   /lib64/libfreebl3.so
7f1cbc176000-7f1cbc177000 rw-p 00074000 08:02 44302343                   /lib64/libfreebl3.so
7f1cbc177000-7f1cbc17b000 rw-p 00000000 00:00 0
7f1cbc17b000-7f1cbc305000 r-xp 00000000 08:02 44302662                   /lib64/libc-2.12.so
7f1cbc305000-7f1cbc505000 ---p 0018a000 08:02 44302662                   /lib64/libc-2.12.so
7f1cbc505000-7f1cbc509000 r--p 0018a000 08:02 44302662                   /lib64/libc-2.12.so
7f1cbc509000-7f1cbc50a000 rw-p 0018e000 08:02 44302662                   /lib64/libc-2.12.so
7f1cbc50a000-7f1cbc50f000 rw-p 00000000 00:00 0
7f1cbc50f000-7f1cbc525000 r-xp 00000000 08:02 44302685                   /lib64/libgcc_s-4.4.7-20120601.so.1
7f1cbc525000-7f1cbc724000 ---p 00016000 08:02 44302685                   /lib64/libgcc_s-4.4.7-20120601.so.1
7f1cbc724000-7f1cbc725000 rw-p 00015000 08:02 44302685                   /lib64/libgcc_s-4.4.7-20120601.so.1
7f1cbc725000-7f1cbc7a8000 r-xp 00000000 08:02 44302638                   /lib64/libm-2.12.so
7f1cbc7a8000-7f1cbc9a7000 ---p 00083000 08:02 44302638                   /lib64/libm-2.12.so
7f1cbc9a7000-7f1cbc9a8000 r--p 00082000 08:02 44302638                   /lib64/libm-2.12.so
7f1cbc9a8000-7f1cbc9a9000 rw-p 00083000 08:02 44302638                   /lib64/libm-2.12.so
7f1cbc9a9000-7f1cbca91000 r-xp 00000000 08:02 16517046                   /usr/lib64/libstdc++.so.6.0.13
7f1cbca91000-7f1cbcc91000 ---p 000e8000 08:02 16517046                   /usr/lib64/libstdc++.so.6.0.13
7f1cbcc91000-7f1cbcc98000 r--p 000e8000 08:02 16517046                   /usr/lib64/libstdc++.so.6.0.13
7f1cbcc98000-7f1cbcc9a000 rw-p 000ef000 08:02 16517046                   /usr/lib64/libstdc++.so.6.0.13
7f1cbcc9a000-7f1cbccaf000 rw-p 00000000 00:00 0
7f1cbccaf000-7f1cbce68000 r-xp 00000000 08:02 16516989                   /usr/lib64/libcrypto.so.1.0.1e
7f1cbce68000-7f1cbd067000 ---p 001b9000 08:02 16516989                   /usr/lib64/libcrypto.so.1.0.1e
7f1cbd067000-7f1cbd082000 r--p 001b8000 08:02 16516989                   /usr/lib64/libcrypto.so.1.0.1e
7f1cbd082000-7f1cbd08e000 rw-p 001d3000 08:02 16516989                   /usr/lib64/libcrypto.so.1.0.1e
7f1cbd08e000-7f1cbd092000 rw-p 00000000 00:00 0
7f1cbd092000-7f1cbd0f4000 r-xp 00000000 08:02 16517086                   /usr/lib64/libssl.so.1.0.1e
7f1cbd0f4000-7f1cbd2f3000 ---p 00062000 08:02 16517086                   /usr/lib64/libssl.so.1.0.1e
7f1cbd2f3000-7f1cbd2f7000 r--p 00061000 08:02 16517086                   /usr/lib64/libssl.so.1.0.1e
7f1cbd2f7000-7f1cbd2fe000 rw-p 00065000 08:02 16517086                   /usr/lib64/libssl.so.1.0.1e
7f1cbd2fe000-7f1cbd300000 r-xp 00000000 08:02 44302737                   /lib64/libdl-2.12.so
7f1cbd300000-7f1cbd500000 ---p 00002000 08:02 44302737                   /lib64/libdl-2.12.so
7f1cbd500000-7f1cbd501000 r--p 00002000 08:02 44302737                   /lib64/libdl-2.12.so
7f1cbd501000-7f1cbd502000 rw-p 00003000 08:02 44302737                   /lib64/libdl-2.12.so
7f1cbd502000-7f1cbd509000 r-xp 00000000 08:02 44302622                   /lib64/libcrypt-2.12.so
7f1cbd509000-7f1cbd709000 ---p 00007000 08:02 44302622                   /lib64/libcrypt-2.12.so
7f1cbd709000-7f1cbd70a000 r--p 00007000 08:02 44302622                   /lib64/libcrypt-2.12.so
7f1cbd70a000-7f1cbd70b000 rw-p 00008000 08:02 44302622                   /lib64/libcrypt-2.12.so
7f1cbd70b000-7f1cbd739000 rw-p 00000000 00:00 0
7f1cbd739000-7f1cbd740000 r-xp 00000000 08:02 44302634                   /lib64/librt-2.12.so
7f1cbd740000-7f1cbd93f000 ---p 00007000 08:02 44302634                   /lib64/librt-2.12.so
7f1cbd93f000-7f1cbd940000 r--p 00006000 08:02 44302634                   /lib64/librt-2.12.so
7f1cbd940000-7f1cbd941000 rw-p 00007000 08:02 44302634                   /lib64/librt-2.12.so
7f1cbd941000-7f1cbd956000 r-xp 00000000 08:02 44302721                   /lib64/libz.so.1.2.3
7f1cbd956000-7f1cbdb55000 ---p 00015000 08:02 44302721                   /lib64/libz.so.1.2.3
7f1cbdb55000-7f1cbdb56000 r--p 00014000 08:02 44302721                   /lib64/libz.so.1.2.3
7f1cbdb56000-7f1cbdb57000 rw-p 00015000 08:02 44302721                   /lib64/libz.so.1.2.3
7f1cbdb57000-7f1cbdb58000 r-xp 00000000 08:02 44302812                   /lib64/libaio.so.1.0.1
7f1cbdb58000-7f1cbdd57000 ---p 00001000 08:02 44302812                   /lib64/libaio.so.1.0.1
7f1cbdd57000-7f1cbdd58000 rw-p 00000000 08:02 44302812                   /lib64/libaio.so.1.0.1
7f1cbdd58000-7f1cbdd6f000 r-xp 00000000 08:02 44302558                   /lib64/libpthread-2.12.so
7f1cbdd6f000-7f1cbdf6f000 ---p 00017000 08:02 44302558                   /lib64/libpthread-2.12.so
7f1cbdf6f000-7f1cbdf70000 r--p 00017000 08:02 44302558                   /lib64/libpthread-2.12.so
7f1cbdf70000-7f1cbdf71000 rw-p 00018000 08:02 44302558                   /lib64/libpthread-2.12.so
7f1cbdf71000-7f1cbdf75000 rw-p 00000000 00:00 0
7f1cbdf75000-7f1cbdf95000 r-xp 00000000 08:02 44302673                   /lib64/ld-2.12.so
7f1cbdf9b000-7f1cbe18e000 rw-p 00000000 00:00 0
7f1cbe18e000-7f1cbe194000 rw-p 00000000 00:00 0
7f1cbe194000-7f1cbe195000 r--p 0001f000 08:02 44302673                   /lib64/ld-2.12.so
7f1cbe195000-7f1cbe196000 rw-p 00020000 08:02 44302673                   /lib64/ld-2.12.so
7f1cbe196000-7f1cbe197000 rw-p 00000000 00:00 0
7fffdb464000-7fffdb485000 rw-p 00000000 00:00 0                          [stack]
7fffdb5ff000-7fffdb600000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed


Решение - это переставить mysql с remi репозитория:

# yum remove mysql-\*
# yum install mysql mysql-devel mysql-libs mysql-server
# /etc/init.d/mysqld stop
# mysqld_safe --skip-grant-tables &
# mysql_upgrade
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start
Индекс цитирования