This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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.