Summary: | dev-db/mariadb-10.0.12 with sys-devel/gcc-4.9.0 - mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... ' | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Cănărău Constantin <canarauc> |
Component: | [OLD] Server | Assignee: | Gentoo Toolchain Maintainers <toolchain> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | candrews, eugene.shalygin, mysql-bugs, tdalman |
Priority: | Normal | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | Linux | ||
URL: | http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/4314 | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- | |
Bug Depends on: | |||
Bug Blocks: | 495124 |
Description
Cănărău Constantin
2014-07-30 12:03:51 UTC
I want to mention: This is happening on default config. Increasing wait_timeout and connect_timeout ten times (288000) does not help. The error also occured on large databases restore. With or without altering max_allowed_packet value in my.cnf And it's also reproductible on different machine - it does not look like a simple my.cnf missconfiguration. /var/lib/mysql is on SSD and, as emerge --info says, there are plenty of RAM available. The culprit is sys-devel/gcc-4.9.0. I belive it generate wrong code. I tested with gcc-4.8.1 to 4.8.3 and no problem. I changed the bug title according. This issue may actually be https://bugzilla.redhat.com/show_bug.cgi?id=1094975 - does Gentoo include that patch to GCC? Mariadb works fine when compiled with: gcc (Gentoo 4.8.3 p1.1, pie-0.5.9) 4.8.3 Copyright (C) 2013 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. But fails in this way with: gcc-4.9.0 (Gentoo 4.9.0 p1.0, pie-0.6.0) 4.9.0 Copyright (C) 2014 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Here's the error information logged in /var/log/mysqld.error when compiled with the aforementioned version of GCC: To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 10.0.12-MariaDB key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=0 max_threads=153 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 137032 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 /usr/sbin/mysqld(my_print_stacktrace+0x3c)[0xb0982c] /usr/sbin/mysqld(handle_fatal_signal+0x3a0)[0x6d9760] /lib64/libpthread.so.0(+0xfd20)[0x7fc661c4bd20] /usr/sbin/mysqld[0x9b1a9c] /usr/sbin/mysqld[0x9b2a35] /usr/sbin/mysqld[0x92f959] /usr/sbin/mysqld[0x886255] /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x57)[0x6db9e7] /usr/sbin/mysqld[0x5adc76] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x4b8)[0x5ae878] /usr/sbin/mysqld[0x527700] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x474)[0x52b824] /lib64/libc.so.6(__libc_start_main+0xf0)[0x7fc66083e010] /usr/sbin/mysqld[0x5213b5] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. If this is the same as https://bugzilla.redhat.com/show_bug.cgi?id=1094975 I believe it will be fixed by 4.9.1. It still crash sometimes. Not as often as before, once or two per day, so there is still a problem. Compiled it with gcc-4.8.3 and I'll test it for ~ 24 hours to see if it's still gcc-4.9* problem or is something wrong at my end. After two days, there are no problems with gcc-4.8.3. Solved in 10.0.13. http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/4314 should be fixed with gcc-4.9.2. please re-open if it isn't. |