MariaDB Error Log When Changing Table Engine from MyISAM to InnoDB
2020-12-14 15:14:41 0 [ERROR] [FATAL] InnoDB: fsync() returned 5 | |
201214 15:14:41 [ERROR] mysqld got signal 6 ; | |
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. | |
To report this bug, see https://mariadb.com/kb/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.3.25-MariaDB-0ubuntu0.20.04.1 | |
key_buffer_size=536870912 | |
read_buffer_size=131072 | |
max_used_connections=0 | |
max_threads=12 | |
thread_count=0 | |
It is possible that mysqld could use up to | |
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 550647 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 = 0x0 thread_stack 0x49000 | |
/usr/sbin/mysqld(my_print_stacktrace+0x32)[0x55f107506c52] | |
/usr/sbin/mysqld(handle_fatal_signal+0x55d)[0x55f10700407d] | |
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0)[0x7fed05e223c0] | |
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7fed0593118b] | |
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7fed05910859] | |
/usr/sbin/mysqld(+0x4e7ae7)[0x55f106d24ae7] | |
/usr/sbin/mysqld(+0x4ca702)[0x55f106d07702] | |
/usr/sbin/mysqld(+0xb08b70)[0x55f107345b70] | |
/usr/sbin/mysqld(+0xb0b22d)[0x55f10734822d] | |
/usr/sbin/mysqld(+0x9b5f39)[0x55f1071f2f39] | |
/usr/sbin/mysqld(+0x9b6ade)[0x55f1071f3ade] | |
/usr/sbin/mysqld(+0xa724a1)[0x55f1072af4a1] | |
/usr/sbin/mysqld(+0xa732f3)[0x55f1072b02f3] | |
/usr/sbin/mysqld(+0xa734a7)[0x55f1072b04a7] | |
/usr/sbin/mysqld(+0xafd30e)[0x55f10733a30e] | |
/usr/sbin/mysqld(+0xafe50d)[0x55f10733b50d] | |
/usr/sbin/mysqld(+0xa1800d)[0x55f10725500d] | |
/usr/sbin/mysqld(+0xa1a491)[0x55f107257491] | |
/usr/sbin/mysqld(+0x9bce1e)[0x55f1071f9e1e] | |
/usr/sbin/mysqld(+0x4e0e4d)[0x55f106d1de4d] | |
/usr/sbin/mysqld(+0x95ce08)[0x55f107199e08] | |
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x70)[0x55f1070067c0] | |
/usr/sbin/mysqld(+0x5eea75)[0x55f106e2ba75] | |
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x88e)[0x55f106e2cb8e] | |
/usr/sbin/mysqld(+0x524364)[0x55f106d61364] | |
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x401)[0x55f106d68211] | |
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3)[0x7fed059120b3] | |
/usr/sbin/mysqld(_start+0x2e)[0x55f106d5b1ce] | |
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains | |
information that should help you find out what is causing the crash. | |
Writing a core file... | |
Working directory at /var/lib/mysql | |
Resource Limits: | |
Limit Soft Limit Hard Limit Units | |
Max cpu time unlimited unlimited seconds | |
Max file size unlimited unlimited bytes | |
Max data size unlimited unlimited bytes | |
Max stack size 8388608 unlimited bytes | |
Max core file size 0 unlimited bytes | |
Max resident set unlimited unlimited bytes | |
Max processes 514136 514136 processes | |
Max open files 1048576 1048576 files | |
Max locked memory unlimited unlimited bytes | |
Max address space unlimited unlimited bytes | |
Max file locks unlimited unlimited locks | |
Max pending signals 514136 514136 signals | |
Max msgqueue size 819200 819200 bytes | |
Max nice priority 0 0 | |
Max realtime priority 0 0 | |
Max realtime timeout unlimited unlimited us | |
Core pattern: core | |
2020-12-14 15:15:00 0 [Note] InnoDB: Using Linux native AIO | |
2020-12-14 15:15:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
2020-12-14 15:15:00 0 [Note] InnoDB: Uses event mutexes | |
2020-12-14 15:15:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 | |
2020-12-14 15:15:00 0 [Note] InnoDB: Number of pools: 1 | |
2020-12-14 15:15:00 0 [Note] InnoDB: Using SSE2 crc32 instructions | |
2020-12-14 15:15:00 0 [Note] InnoDB: Initializing buffer pool, total size = 8G, instances = 8, chunk size = 128M | |
2020-12-14 15:15:00 0 [Note] InnoDB: Completed initialization of buffer pool | |
2020-12-14 15:15:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
2020-12-14 15:15:00 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1198558467 | |
2020-12-14 15:15:00 0 [Note] InnoDB: Starting final batch to recover 2750 pages from redo log. | |
2020-12-14 15:15:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active. | |
2020-12-14 15:15:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" | |
2020-12-14 15:15:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
2020-12-14 15:15:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
2020-12-14 15:15:01 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
2020-12-14 15:15:01 0 [Note] InnoDB: Waiting for purge to start | |
2020-12-14 15:15:01 0 [Note] InnoDB: 10.3.25 started; log sequence number 1227677202; transaction id 3463448 | |
2020-12-14 15:15:01 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
2020-12-14 15:15:01 0 [Note] Plugin 'FEEDBACK' is disabled. | |
2020-12-14 15:15:01 0 [Note] Recovering after a crash using tc.log | |
2020-12-14 15:15:01 0 [Note] Starting crash recovery... | |
2020-12-14 15:15:01 0 [Note] Crash recovery finished. | |
2020-12-14 15:15:01 0 [Note] Server socket created on IP: '127.0.0.1'. | |
2020-12-14 15:15:01 0 [Note] Reading of all Master_info entries succeeded | |
2020-12-14 15:15:01 0 [Note] Added new Master_info '' to hash table | |
2020-12-14 15:15:01 0 [Note] /usr/sbin/mysqld: ready for connections. | |
Version: '10.3.25-MariaDB-0ubuntu0.20.04.1' socket: '/run/mysqld/mysqld.sock' port: 3306 Ubuntu 20.04 | |
2020-12-14 15:15:01 0 [Note] InnoDB: Buffer pool(s) load completed at 201214 15:15:01 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment