mariadb is crashing
Hi, I have tried this a few times on both the 5.2.10 and 5.3.2-beta builds and I get the same end result.
I install the server, create a db, run an sql script to create several hundred tables. Then when I log on to run a "show tables" mysqld crashes. All theses tables are created using the Aria storage engine. The only configuration that I have is (everything else is default):
aria-pagecache-buffer-size=12G
Any pointers in debugging?
This is what I see in the error log:
111208 14:33:36 [Note] ./bin/mysqld: ready for connections. Version: '5.3.2-MariaDB-beta-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 (MariaDB - http://mariadb.com/) 111208 14:34:00 [Warning] Aborted connection 3 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets) 111208 14:34:02 [Warning] Aborted connection 4 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets) 111208 14:35:05 [ERROR] mysqld got signal 11 ; 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=0 read_buffer_size=1048576 max_used_connections=3 max_threads=402 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 442557 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 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 = (nil) thread_stack 0x48000 ./bin/mysqld(my_print_stacktrace+0x2e) [0xa1195e] ./bin/mysqld(handle_segfault+0x3f6) [0x6340a6] /lib64/libpthread.so.0 [0x3248e0eb10] ./bin/mysqld(ma_checkpoint_execute+0x42d) [0x83bead] ./bin/mysqld(ma_checkpoint_background+0x23f) [0x83c9af] /lib64/libpthread.so.0 [0x3248e0673d] /lib64/libc.so.6(clone+0x6d) [0x32482d40cd] 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. 111208 14:35:05 mysqld_safe Number of processes running now: 0 111208 14:35:05 mysqld_safe mysqld restarted
Here is my OS:
$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.6 (Tikanga)
Answer Answered by Elena Stepanova in this comment.
Thank you for providing a repeatable test case, the bug https://bugs.launchpad.net/maria/+bug/902654 is now reproducible in our environment and will hopefully be fixed soon, you can monitor the progress in Launchpad.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.