Jan 4 14:25:53 vmi223751 mysqld[6174]: 2020-01-04 14:25:53 0 [Note] /usr/sbin/mysqld: Shutdown complete Jan 4 14:25:53 vmi223751 systemd[1]: Stopped MariaDB 10.4.11 database server. Jan 4 14:28:44 vmi223751 systemd[1]: Starting MariaDB 10.4.11 database server... Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic-log) starting as process 6439 ... Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Using Linux native AIO Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Uses event mutexes Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Number of pools: 1 Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jan 4 14:28:44 vmi223751 mysqld[6439]: 2020-01-04 14:28:44 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: Completed initialization of buffer pool Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: 10.4.11 started; log sequence number 1130005; transaction id 1501 Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [ERROR] /usr/sbin/mysqld: unknown variable 'innpdb_purge_threads=0' Jan 4 14:28:45 vmi223751 mysqld[6439]: 2020-01-04 14:28:45 0 [ERROR] Aborting Jan 4 14:28:47 vmi223751 systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING Jan 4 14:28:47 vmi223751 systemd[1]: mariadb.service: Failed with result 'exit-code'. Jan 4 14:28:47 vmi223751 systemd[1]: Failed to start MariaDB 10.4.11 database server. Jan 4 14:29:43 vmi223751 systemd[1]: Starting MariaDB 10.4.11 database server... Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic-log) starting as process 6637 ... Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Using Linux native AIO Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Uses event mutexes Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Number of pools: 1 Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: Completed initialization of buffer pool Jan 4 14:29:43 vmi223751 mysqld[6637]: 2020-01-04 14:29:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: 10.4.11 started; log sequence number 1130014; transaction id 1501 Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [ERROR] /usr/sbin/mysqld: unknown variable 'innpdb_purge_threads=0' Jan 4 14:29:44 vmi223751 mysqld[6637]: 2020-01-04 14:29:44 0 [ERROR] Aborting Jan 4 14:29:47 vmi223751 systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING Jan 4 14:29:47 vmi223751 systemd[1]: mariadb.service: Failed with result 'exit-code'. Jan 4 14:29:47 vmi223751 systemd[1]: Failed to start MariaDB 10.4.11 database server. Jan 4 14:30:23 vmi223751 systemd[1]: Starting MariaDB 10.4.11 database server... Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic-log) starting as process 6831 ... Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1 Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Using Linux native AIO Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Uses event mutexes Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Number of pools: 1 Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jan 4 14:30:23 vmi223751 mysqld[6831]: 2020-01-04 14:30:23 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: Completed initialization of buffer pool Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: 10.4.11 started; log sequence number 1130023; transaction id 1501 Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] Server socket created on IP: '127.0.0.1'. Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] Reading of all Master_info entries succeeded Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] Added new Master_info '' to hash table Jan 4 14:30:24 vmi223751 mysqld[6831]: 2020-01-04 14:30:24 0 [Note] /usr/sbin/mysqld: ready for connections. Jan 4 14:30:24 vmi223751 mysqld[6831]: Version: '10.4.11-MariaDB-1:10.4.11+maria~bionic-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Jan 4 14:30:24 vmi223751 systemd[1]: Started MariaDB 10.4.11 database server. Jan 4 14:30:24 vmi223751 /etc/mysql/debian-start[6863]: Upgrading MySQL tables if necessary. Jan 4 14:30:24 vmi223751 /etc/mysql/debian-start[6866]: Looking for 'mysql' as: /usr/bin/mysql Jan 4 14:30:24 vmi223751 /etc/mysql/debian-start[6866]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Jan 4 14:30:24 vmi223751 /etc/mysql/debian-start[6866]: This installation of MariaDB is already upgraded to 10.4.11-MariaDB, use --force if you still need to run mysql_upgrade Jan 4 14:30:24 vmi223751 /etc/mysql/debian-start[6874]: Checking for insecure root accounts. Jan 4 14:30:24 vmi223751 /etc/mysql/debian-start[6878]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables Jan 4 14:30:25 vmi223751 mysqld[6831]: 2020-01-04 14:30:25 0 [Note] InnoDB: Buffer pool(s) load completed at 200104 14:30:25 Jan 4 14:35:18 vmi223751 mysqld[6831]: 2020-01-04 14:35:18 0x7f811413d700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.4.11/storage/innobase/btr/btr0btr.cc line 204 Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: Failing assertion: mach_read_from_4(seg_header + FSEG_HDR_SPACE) == space Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: We intentionally generate a memory trap. Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: If you get repeated assertion failures or crashes, even Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: immediately after the mysqld startup, there may be Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: corruption in the InnoDB tablespace. Please refer to Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ Jan 4 14:35:18 vmi223751 mysqld[6831]: InnoDB: about forcing recovery. Jan 4 14:35:18 vmi223751 mysqld[6831]: 200104 14:35:18 [ERROR] mysqld got signal 6 ; Jan 4 14:35:18 vmi223751 mysqld[6831]: This could be because you hit a bug. It is also possible that this binary Jan 4 14:35:18 vmi223751 mysqld[6831]: or one of the libraries it was linked against is corrupt, improperly built, Jan 4 14:35:18 vmi223751 mysqld[6831]: or misconfigured. This error can also be caused by malfunctioning hardware. Jan 4 14:35:18 vmi223751 mysqld[6831]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Jan 4 14:35:18 vmi223751 mysqld[6831]: We will try our best to scrape up some info that will hopefully help Jan 4 14:35:18 vmi223751 mysqld[6831]: diagnose the problem, but since we have already crashed, Jan 4 14:35:18 vmi223751 mysqld[6831]: something is definitely wrong and this may fail. Jan 4 14:35:18 vmi223751 mysqld[6831]: Server version: 10.4.11-MariaDB-1:10.4.11+maria~bionic-log Jan 4 14:35:18 vmi223751 mysqld[6831]: key_buffer_size=134217728 Jan 4 14:35:18 vmi223751 mysqld[6831]: read_buffer_size=2097152 Jan 4 14:35:18 vmi223751 mysqld[6831]: max_used_connections=1 Jan 4 14:35:18 vmi223751 mysqld[6831]: max_threads=102 Jan 4 14:35:18 vmi223751 mysqld[6831]: thread_count=4 Jan 4 14:35:18 vmi223751 mysqld[6831]: It is possible that mysqld could use up to Jan 4 14:35:18 vmi223751 mysqld[6831]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760249 K bytes of memory Jan 4 14:35:18 vmi223751 mysqld[6831]: Hope that's ok; if not, decrease some variables in the equation. Jan 4 14:35:18 vmi223751 mysqld[6831]: Thread pointer: 0x7f7eec000c08 Jan 4 14:35:18 vmi223751 mysqld[6831]: Attempting backtrace. You can use the following information to find out Jan 4 14:35:18 vmi223751 mysqld[6831]: where mysqld died. If you see no messages after this, something went Jan 4 14:35:18 vmi223751 mysqld[6831]: terribly wrong... Jan 4 14:35:18 vmi223751 mysqld[6831]: stack_bottom = 0x7f811413cdd8 thread_stack 0x49000 Jan 4 14:35:18 vmi223751 mysqld[6831]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5620fc6eb1de] Jan 4 14:35:18 vmi223751 mysqld[6831]: /usr/sbin/mysqld(handle_fatal_signal+0x515)[0x5620fc1602f5] Jan 4 14:35:18 vmi223751 mysqld[6831]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f811de35890] Jan 4 14:35:19 vmi223751 mysqld[6831]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7f811c768e97] Jan 4 14:35:19 vmi223751 mysqld[6831]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7f811c76a801] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0x56b69a)[0x5620fbe6769a] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xb5a600)[0x5620fc456600] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xb5be00)[0x5620fc457e00] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xb5bf01)[0x5620fc457f01] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0x56bf8e)[0x5620fbe67f8e] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xbdc7a9)[0x5620fc4d87a9] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xbdcfe1)[0x5620fc4d8fe1] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xbcddb3)[0x5620fc4c9db3] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0xa16262)[0x5620fc312262] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x4a)[0x5620fc164dda] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPK25st_mysql_const_lex_stringjjjP5TABLEbP4ListI6StringE+0x8fc)[0x5620fc00956c] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xc60)[0x5620fbeeb5d0] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xc13)[0x5620fbeee753] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x33)[0x5620fbeef383] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0x7432e8)[0x5620fc03f2e8] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(+0x74412b)[0x5620fc04012b] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_ZN19Sql_cmd_check_table7executeEP3THD+0x82)[0x5620fc041e42] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1f2b)[0x5620fbf4d87b] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x5620fbf5447a] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x13a1)[0x5620fbf56a01] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x148)[0x5620fbf582d8] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25e)[0x5620fc0342ae] Jan 4 14:35:19 vmi223751 mysqld[6831]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5620fc03436d] Jan 4 14:35:19 vmi223751 mysqld[6831]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f811de2a6db] Jan 4 14:35:19 vmi223751 mysqld[6831]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f811c84b88f] Jan 4 14:35:19 vmi223751 mysqld[6831]: Trying to get some variables. Jan 4 14:35:19 vmi223751 mysqld[6831]: Some pointers may be invalid and cause the dump to abort. Jan 4 14:35:19 vmi223751 mysqld[6831]: Query (0x7f7eec013340): CHECK TABLE `CANhistoriacenseriale` Jan 4 14:35:19 vmi223751 mysqld[6831]: Connection ID (thread ID): 32 Jan 4 14:35:19 vmi223751 mysqld[6831]: Status: NOT_KILLED Jan 4 14:35:19 vmi223751 mysqld[6831]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on Jan 4 14:35:19 vmi223751 mysqld[6831]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Jan 4 14:35:19 vmi223751 mysqld[6831]: information that should help you find out what is causing the crash. Jan 4 14:35:19 vmi223751 mysqld[6831]: Writing a core file... Jan 4 14:35:19 vmi223751 mysqld[6831]: Working directory at /var/lib/mysql Jan 4 14:35:19 vmi223751 mysqld[6831]: Resource Limits: Jan 4 14:35:19 vmi223751 mysqld[6831]: Limit Soft Limit Hard Limit Units Jan 4 14:35:19 vmi223751 mysqld[6831]: Max cpu time unlimited unlimited seconds Jan 4 14:35:19 vmi223751 mysqld[6831]: Max file size unlimited unlimited bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max data size unlimited unlimited bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max stack size 8388608 unlimited bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max core file size 0 unlimited bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max resident set unlimited unlimited bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max processes 31730 31730 processes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max open files 16364 16364 files Jan 4 14:35:19 vmi223751 mysqld[6831]: Max locked memory 16777216 16777216 bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max address space unlimited unlimited bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max file locks unlimited unlimited locks Jan 4 14:35:19 vmi223751 mysqld[6831]: Max pending signals 31730 31730 signals Jan 4 14:35:19 vmi223751 mysqld[6831]: Max msgqueue size 819200 819200 bytes Jan 4 14:35:19 vmi223751 mysqld[6831]: Max nice priority 0 0 Jan 4 14:35:19 vmi223751 mysqld[6831]: Max realtime priority 0 0 Jan 4 14:35:19 vmi223751 mysqld[6831]: Max realtime timeout unlimited unlimited us Jan 4 14:35:19 vmi223751 mysqld[6831]: Core pattern: core Jan 4 14:35:19 vmi223751 systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT Jan 4 14:35:19 vmi223751 systemd[1]: mariadb.service: Failed with result 'signal'. Jan 4 14:35:24 vmi223751 systemd[1]: mariadb.service: Service hold-off time over, scheduling restart. Jan 4 14:35:24 vmi223751 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1. Jan 4 14:35:24 vmi223751 systemd[1]: Stopped MariaDB 10.4.11 database server. Jan 4 14:35:24 vmi223751 systemd[1]: Starting MariaDB 10.4.11 database server... Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic-log) starting as process 7161 ... Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1 Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Using Linux native AIO Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Uses event mutexes Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Number of pools: 1 Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jan 4 14:35:24 vmi223751 mysqld[7161]: 2020-01-04 14:35:24 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M Jan 4 14:35:25 vmi223751 mysqld[7161]: 2020-01-04 14:35:25 0 [Note] InnoDB: Completed initialization of buffer pool Jan 4 14:35:25 vmi223751 mysqld[7161]: 2020-01-04 14:35:25 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1130023 Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: 10.4.11 started; log sequence number 1130032; transaction id 1501 Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Recovering after a crash using /var/log/mysql/mariadb-bin Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Starting crash recovery... Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Crash recovery finished. Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Server socket created on IP: '127.0.0.1'. Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Reading of all Master_info entries succeeded Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] Added new Master_info '' to hash table Jan 4 14:35:26 vmi223751 mysqld[7161]: 2020-01-04 14:35:26 0 [Note] /usr/sbin/mysqld: ready for connections. Jan 4 14:35:26 vmi223751 mysqld[7161]: Version: '10.4.11-MariaDB-1:10.4.11+maria~bionic-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Jan 4 14:35:26 vmi223751 systemd[1]: Started MariaDB 10.4.11 database server. Jan 4 14:35:26 vmi223751 /etc/mysql/debian-start[7194]: Upgrading MySQL tables if necessary. Jan 4 14:35:26 vmi223751 /etc/mysql/debian-start[7197]: Looking for 'mysql' as: /usr/bin/mysql Jan 4 14:35:26 vmi223751 /etc/mysql/debian-start[7197]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Jan 4 14:35:26 vmi223751 /etc/mysql/debian-start[7197]: This installation of MariaDB is already upgraded to 10.4.11-MariaDB, use --force if you still need to run mysql_upgrade Jan 4 14:35:26 vmi223751 /etc/mysql/debian-start[7205]: Checking for insecure root accounts. Jan 4 14:35:26 vmi223751 /etc/mysql/debian-start[7209]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables Jan 4 14:35:28 vmi223751 mysqld[7161]: 2020-01-04 14:35:28 0 [Note] InnoDB: Buffer pool(s) load completed at 200104 14:35:28 Jan 4 14:36:26 vmi223751 systemd[1]: Stopping MariaDB 10.4.11 database server... Jan 4 14:36:26 vmi223751 mysqld[7161]: 2020-01-04 14:36:26 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown Jan 4 14:36:26 vmi223751 mysqld[7161]: 2020-01-04 14:36:26 0 [Note] Event Scheduler: Purging the queue. 0 events Jan 4 14:36:26 vmi223751 mysqld[7161]: 2020-01-04 14:36:26 0 [Note] InnoDB: Starting shutdown... Jan 4 14:36:26 vmi223751 mysqld[7161]: 2020-01-04 14:36:26 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool Jan 4 14:36:26 vmi223751 mysqld[7161]: 2020-01-04 14:36:26 0 [Note] InnoDB: Buffer pool(s) dump completed at 200104 14:36:26 Jan 4 14:36:29 vmi223751 mysqld[7161]: 2020-01-04 14:36:29 0 [Note] InnoDB: Shutdown completed; log sequence number 1130041; transaction id 1502 Jan 4 14:36:29 vmi223751 mysqld[7161]: 2020-01-04 14:36:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Jan 4 14:36:29 vmi223751 mysqld[7161]: 2020-01-04 14:36:29 0 [Note] /usr/sbin/mysqld: Shutdown complete Jan 4 14:36:29 vmi223751 systemd[1]: Stopped MariaDB 10.4.11 database server. Jan 4 14:39:01 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 14:39:01 vmi223751 systemd[1]: Started Clean php session files. Jan 4 14:39:02 vmi223751 CRON[7358]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 14:39:08 vmi223751 systemd-resolved[464]: Server returned error NXDOMAIN, mitigating potential DNS violation DVE-2018-0001, retrying transaction with reduced feature level UDP. Jan 4 14:39:51 vmi223751 systemd[1]: Starting MariaDB 10.4.11 database server... Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic-log) starting as process 7587 ... Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1 Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Using Linux native AIO Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Uses event mutexes Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Number of pools: 1 Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jan 4 14:39:51 vmi223751 mysqld[7587]: 2020-01-04 14:39:51 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: Completed initialization of buffer pool Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: 10.4.11 started; log sequence number 1130041; transaction id 1501 Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] Server socket created on IP: '127.0.0.1'. Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] Reading of all Master_info entries succeeded Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] Added new Master_info '' to hash table Jan 4 14:39:52 vmi223751 mysqld[7587]: 2020-01-04 14:39:52 0 [Note] /usr/sbin/mysqld: ready for connections. Jan 4 14:39:52 vmi223751 mysqld[7587]: Version: '10.4.11-MariaDB-1:10.4.11+maria~bionic-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Jan 4 14:39:52 vmi223751 systemd[1]: Started MariaDB 10.4.11 database server. Jan 4 14:39:52 vmi223751 /etc/mysql/debian-start[7619]: Upgrading MySQL tables if necessary. Jan 4 14:39:52 vmi223751 /etc/mysql/debian-start[7622]: Looking for 'mysql' as: /usr/bin/mysql Jan 4 14:39:52 vmi223751 /etc/mysql/debian-start[7622]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Jan 4 14:39:52 vmi223751 /etc/mysql/debian-start[7622]: This installation of MariaDB is already upgraded to 10.4.11-MariaDB, use --force if you still need to run mysql_upgrade Jan 4 14:39:52 vmi223751 /etc/mysql/debian-start[7630]: Checking for insecure root accounts. Jan 4 14:39:52 vmi223751 /etc/mysql/debian-start[7634]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables Jan 4 14:39:53 vmi223751 mysqld[7587]: 2020-01-04 14:39:53 0 [Note] InnoDB: Buffer pool(s) load completed at 200104 14:39:53 Jan 4 14:41:51 vmi223751 mysqld[7587]: 2020-01-04 14:41:51 0x7f99344f7700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.4.11/storage/innobase/btr/btr0btr.cc line 204 Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: Failing assertion: mach_read_from_4(seg_header + FSEG_HDR_SPACE) == space Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: We intentionally generate a memory trap. Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: If you get repeated assertion failures or crashes, even Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: immediately after the mysqld startup, there may be Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: corruption in the InnoDB tablespace. Please refer to Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ Jan 4 14:41:51 vmi223751 mysqld[7587]: InnoDB: about forcing recovery. Jan 4 14:41:51 vmi223751 mysqld[7587]: 200104 14:41:51 [ERROR] mysqld got signal 6 ; Jan 4 14:41:51 vmi223751 mysqld[7587]: This could be because you hit a bug. It is also possible that this binary Jan 4 14:41:51 vmi223751 mysqld[7587]: or one of the libraries it was linked against is corrupt, improperly built, Jan 4 14:41:51 vmi223751 mysqld[7587]: or misconfigured. This error can also be caused by malfunctioning hardware. Jan 4 14:41:51 vmi223751 mysqld[7587]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Jan 4 14:41:51 vmi223751 mysqld[7587]: We will try our best to scrape up some info that will hopefully help Jan 4 14:41:51 vmi223751 mysqld[7587]: diagnose the problem, but since we have already crashed, Jan 4 14:41:51 vmi223751 mysqld[7587]: something is definitely wrong and this may fail. Jan 4 14:41:51 vmi223751 mysqld[7587]: Server version: 10.4.11-MariaDB-1:10.4.11+maria~bionic-log Jan 4 14:41:51 vmi223751 mysqld[7587]: key_buffer_size=134217728 Jan 4 14:41:51 vmi223751 mysqld[7587]: read_buffer_size=2097152 Jan 4 14:41:51 vmi223751 mysqld[7587]: max_used_connections=1 Jan 4 14:41:51 vmi223751 mysqld[7587]: max_threads=102 Jan 4 14:41:51 vmi223751 mysqld[7587]: thread_count=4 Jan 4 14:41:51 vmi223751 mysqld[7587]: It is possible that mysqld could use up to Jan 4 14:41:51 vmi223751 mysqld[7587]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760249 K bytes of memory Jan 4 14:41:51 vmi223751 mysqld[7587]: Hope that's ok; if not, decrease some variables in the equation. Jan 4 14:41:51 vmi223751 mysqld[7587]: Thread pointer: 0x7f9718000c08 Jan 4 14:41:51 vmi223751 mysqld[7587]: Attempting backtrace. You can use the following information to find out Jan 4 14:41:51 vmi223751 mysqld[7587]: where mysqld died. If you see no messages after this, something went Jan 4 14:41:51 vmi223751 mysqld[7587]: terribly wrong... Jan 4 14:41:51 vmi223751 mysqld[7587]: stack_bottom = 0x7f99344f6dd8 thread_stack 0x49000 Jan 4 14:41:51 vmi223751 mysqld[7587]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5617a8ca01de] Jan 4 14:41:51 vmi223751 mysqld[7587]: /usr/sbin/mysqld(handle_fatal_signal+0x515)[0x5617a87152f5] Jan 4 14:41:51 vmi223751 mysqld[7587]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f993ee18890] Jan 4 14:41:52 vmi223751 mysqld[7587]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7f993d74be97] Jan 4 14:41:52 vmi223751 mysqld[7587]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7f993d74d801] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0x56b69a)[0x5617a841c69a] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xb5a600)[0x5617a8a0b600] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xb5be00)[0x5617a8a0ce00] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xb5bf01)[0x5617a8a0cf01] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0x56bf8e)[0x5617a841cf8e] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xbdc7a9)[0x5617a8a8d7a9] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xbdcfe1)[0x5617a8a8dfe1] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xbcddb3)[0x5617a8a7edb3] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0xa16262)[0x5617a88c7262] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x4a)[0x5617a8719dda] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPK25st_mysql_const_lex_stringjjjP5TABLEbP4ListI6StringE+0x8fc)[0x5617a85be56c] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xc60)[0x5617a84a05d0] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xc13)[0x5617a84a3753] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x33)[0x5617a84a4383] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0x7432e8)[0x5617a85f42e8] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(+0x74412b)[0x5617a85f512b] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_ZN19Sql_cmd_check_table7executeEP3THD+0x82)[0x5617a85f6e42] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1f2b)[0x5617a850287b] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x5617a850947a] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x13a1)[0x5617a850ba01] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x148)[0x5617a850d2d8] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25e)[0x5617a85e92ae] Jan 4 14:41:52 vmi223751 mysqld[7587]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5617a85e936d] Jan 4 14:41:52 vmi223751 mysqld[7587]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f993ee0d6db] Jan 4 14:41:52 vmi223751 mysqld[7587]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f993d82e88f] Jan 4 14:41:52 vmi223751 mysqld[7587]: Trying to get some variables. Jan 4 14:41:52 vmi223751 mysqld[7587]: Some pointers may be invalid and cause the dump to abort. Jan 4 14:41:52 vmi223751 mysqld[7587]: Query (0x7f9718013340): CHECK TABLE `CANhistoriacenseriale` Jan 4 14:41:52 vmi223751 mysqld[7587]: Connection ID (thread ID): 32 Jan 4 14:41:52 vmi223751 mysqld[7587]: Status: NOT_KILLED Jan 4 14:41:52 vmi223751 mysqld[7587]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on Jan 4 14:41:52 vmi223751 mysqld[7587]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Jan 4 14:41:52 vmi223751 mysqld[7587]: information that should help you find out what is causing the crash. Jan 4 14:41:52 vmi223751 mysqld[7587]: Writing a core file... Jan 4 14:41:52 vmi223751 mysqld[7587]: Working directory at /var/lib/mysql Jan 4 14:41:52 vmi223751 mysqld[7587]: Resource Limits: Jan 4 14:41:52 vmi223751 mysqld[7587]: Limit Soft Limit Hard Limit Units Jan 4 14:41:52 vmi223751 mysqld[7587]: Max cpu time unlimited unlimited seconds Jan 4 14:41:52 vmi223751 mysqld[7587]: Max file size unlimited unlimited bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max data size unlimited unlimited bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max stack size 8388608 unlimited bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max core file size 0 unlimited bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max resident set unlimited unlimited bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max processes 31730 31730 processes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max open files 16364 16364 files Jan 4 14:41:52 vmi223751 mysqld[7587]: Max locked memory 16777216 16777216 bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max address space unlimited unlimited bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max file locks unlimited unlimited locks Jan 4 14:41:52 vmi223751 mysqld[7587]: Max pending signals 31730 31730 signals Jan 4 14:41:52 vmi223751 mysqld[7587]: Max msgqueue size 819200 819200 bytes Jan 4 14:41:52 vmi223751 mysqld[7587]: Max nice priority 0 0 Jan 4 14:41:52 vmi223751 mysqld[7587]: Max realtime priority 0 0 Jan 4 14:41:52 vmi223751 mysqld[7587]: Max realtime timeout unlimited unlimited us Jan 4 14:41:52 vmi223751 mysqld[7587]: Core pattern: core Jan 4 14:41:52 vmi223751 systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT Jan 4 14:41:52 vmi223751 systemd[1]: mariadb.service: Failed with result 'signal'. Jan 4 14:41:57 vmi223751 systemd[1]: mariadb.service: Service hold-off time over, scheduling restart. Jan 4 14:41:57 vmi223751 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1. Jan 4 14:41:57 vmi223751 systemd[1]: Stopped MariaDB 10.4.11 database server. Jan 4 14:41:57 vmi223751 systemd[1]: Starting MariaDB 10.4.11 database server... Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic-log) starting as process 7840 ... Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1 Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Using Linux native AIO Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Uses event mutexes Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Number of pools: 1 Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jan 4 14:41:57 vmi223751 mysqld[7840]: 2020-01-04 14:41:57 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: Completed initialization of buffer pool Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1130041 Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: 10.4.11 started; log sequence number 1130050; transaction id 1501 Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Recovering after a crash using /var/log/mysql/mariadb-bin Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Starting crash recovery... Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Crash recovery finished. Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Server socket created on IP: '127.0.0.1'. Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Reading of all Master_info entries succeeded Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] Added new Master_info '' to hash table Jan 4 14:41:58 vmi223751 mysqld[7840]: 2020-01-04 14:41:58 0 [Note] /usr/sbin/mysqld: ready for connections. Jan 4 14:41:58 vmi223751 mysqld[7840]: Version: '10.4.11-MariaDB-1:10.4.11+maria~bionic-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Jan 4 14:41:58 vmi223751 systemd[1]: Started MariaDB 10.4.11 database server. Jan 4 14:41:58 vmi223751 /etc/mysql/debian-start[7873]: Upgrading MySQL tables if necessary. Jan 4 14:41:58 vmi223751 /etc/mysql/debian-start[7876]: Looking for 'mysql' as: /usr/bin/mysql Jan 4 14:41:58 vmi223751 /etc/mysql/debian-start[7876]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Jan 4 14:41:58 vmi223751 /etc/mysql/debian-start[7876]: This installation of MariaDB is already upgraded to 10.4.11-MariaDB, use --force if you still need to run mysql_upgrade Jan 4 14:41:58 vmi223751 /etc/mysql/debian-start[7884]: Checking for insecure root accounts. Jan 4 14:41:58 vmi223751 /etc/mysql/debian-start[7888]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables Jan 4 14:41:59 vmi223751 mysqld[7840]: 2020-01-04 14:41:59 0 [Note] InnoDB: Buffer pool(s) load completed at 200104 14:41:59 Jan 4 14:42:01 vmi223751 CRON[7919]: (root) CMD (sync; echo 3 > /proc/sys/vm/drop_caches) Jan 4 14:42:01 vmi223751 kernel: [423017.307397] sh (7919): drop_caches: 3 Jan 4 14:57:06 vmi223751 systemd[1]: Started Session 515 of user sebastian. Jan 4 15:03:44 vmi223751 systemd[1]: Stopping MariaDB 10.4.11 database server... Jan 4 15:03:44 vmi223751 mysqld[7840]: 2020-01-04 15:03:44 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown Jan 4 15:03:44 vmi223751 mysqld[7840]: 2020-01-04 15:03:44 0 [Note] Event Scheduler: Purging the queue. 0 events Jan 4 15:03:44 vmi223751 mysqld[7840]: 2020-01-04 15:03:44 0 [Note] InnoDB: Starting shutdown... Jan 4 15:03:44 vmi223751 mysqld[7840]: 2020-01-04 15:03:44 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool Jan 4 15:03:44 vmi223751 mysqld[7840]: 2020-01-04 15:03:44 0 [Note] InnoDB: Buffer pool(s) dump completed at 200104 15:03:44 Jan 4 15:03:47 vmi223751 mysqld[7840]: 2020-01-04 15:03:47 0 [Note] InnoDB: Shutdown completed; log sequence number 1130059; transaction id 1502 Jan 4 15:03:47 vmi223751 mysqld[7840]: 2020-01-04 15:03:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Jan 4 15:03:47 vmi223751 mysqld[7840]: 2020-01-04 15:03:47 0 [Note] /usr/sbin/mysqld: Shutdown complete Jan 4 15:03:47 vmi223751 systemd[1]: Stopped MariaDB 10.4.11 database server. Jan 4 15:05:01 vmi223751 systemd[1]: Stopping User Manager for UID 1000... Jan 4 15:05:01 vmi223751 systemd[24165]: Stopped target Default. Jan 4 15:05:01 vmi223751 systemd[24165]: Stopped target Basic System. Jan 4 15:05:01 vmi223751 systemd[24165]: Stopped target Sockets. Jan 4 15:05:01 vmi223751 systemd[24165]: Closed GnuPG cryptographic agent and passphrase cache. Jan 4 15:05:01 vmi223751 systemd[24165]: Closed GnuPG cryptographic agent and passphrase cache (access for web browsers). Jan 4 15:05:01 vmi223751 systemd[24165]: Closed GnuPG cryptographic agent (ssh-agent emulation). Jan 4 15:05:01 vmi223751 systemd[24165]: Closed GnuPG network certificate management daemon. Jan 4 15:05:01 vmi223751 systemd[24165]: Closed REST API socket for snapd user session agent. Jan 4 15:05:01 vmi223751 systemd[24165]: Stopped target Paths. Jan 4 15:05:01 vmi223751 systemd[24165]: Stopped target Timers. Jan 4 15:05:01 vmi223751 systemd[24165]: Closed GnuPG cryptographic agent and passphrase cache (restricted). Jan 4 15:05:01 vmi223751 systemd[24165]: Reached target Shutdown. Jan 4 15:05:01 vmi223751 systemd[24165]: Starting Exit the Session... Jan 4 15:05:01 vmi223751 systemd[24165]: Received SIGRTMIN+24 from PID 7999 (kill). Jan 4 15:05:01 vmi223751 systemd[1]: Stopped User Manager for UID 1000. Jan 4 15:05:01 vmi223751 systemd[1]: Removed slice User Slice of sebastian. Jan 4 15:09:01 vmi223751 CRON[8004]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 15:09:01 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 15:09:02 vmi223751 systemd[1]: Started Clean php session files. Jan 4 15:17:01 vmi223751 CRON[8083]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Jan 4 15:37:14 vmi223751 systemd[1]: Created slice User Slice of sebastian. Jan 4 15:37:14 vmi223751 systemd[1]: Starting User Manager for UID 1000... Jan 4 15:37:14 vmi223751 systemd[1]: Started Session 518 of user sebastian. Jan 4 15:37:14 vmi223751 systemd[8088]: Listening on GnuPG cryptographic agent (ssh-agent emulation). Jan 4 15:37:14 vmi223751 systemd[8088]: Reached target Paths. Jan 4 15:37:14 vmi223751 systemd[8088]: Reached target Timers. Jan 4 15:37:14 vmi223751 systemd[8088]: Listening on REST API socket for snapd user session agent. Jan 4 15:37:14 vmi223751 systemd[8088]: Listening on GnuPG cryptographic agent and passphrase cache (access for web browsers). Jan 4 15:37:14 vmi223751 systemd[8088]: Listening on GnuPG network certificate management daemon. Jan 4 15:37:14 vmi223751 systemd[8088]: Listening on GnuPG cryptographic agent and passphrase cache. Jan 4 15:37:14 vmi223751 systemd[8088]: Listening on GnuPG cryptographic agent and passphrase cache (restricted). Jan 4 15:37:14 vmi223751 systemd[8088]: Reached target Sockets. Jan 4 15:37:14 vmi223751 systemd[8088]: Reached target Basic System. Jan 4 15:37:14 vmi223751 systemd[8088]: Reached target Default. Jan 4 15:37:14 vmi223751 systemd[8088]: Startup finished in 73ms. Jan 4 15:37:14 vmi223751 systemd[1]: Started User Manager for UID 1000. Jan 4 15:39:01 vmi223751 CRON[8235]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 15:39:01 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 15:39:01 vmi223751 systemd[1]: Started Clean php session files. Jan 4 15:42:01 vmi223751 CRON[8313]: (root) CMD (sync; echo 3 > /proc/sys/vm/drop_caches) Jan 4 15:42:02 vmi223751 kernel: [426618.594182] sh (8313): drop_caches: 3 Jan 4 16:09:01 vmi223751 CRON[8322]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 16:09:01 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 16:09:02 vmi223751 systemd[1]: Started Clean php session files. Jan 4 16:17:01 vmi223751 CRON[8401]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Jan 4 16:39:01 vmi223751 CRON[8406]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 16:39:02 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 16:39:02 vmi223751 systemd[1]: Started Clean php session files. Jan 4 16:42:01 vmi223751 CRON[8487]: (root) CMD (sync; echo 3 > /proc/sys/vm/drop_caches) Jan 4 16:42:02 vmi223751 kernel: [430218.895933] sh (8487): drop_caches: 3 Jan 4 17:09:01 vmi223751 CRON[8492]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 17:09:02 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 17:09:02 vmi223751 systemd[1]: Started Clean php session files. Jan 4 17:17:01 vmi223751 CRON[8571]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Jan 4 17:18:12 vmi223751 systemd[1]: Starting Daily apt download activities... Jan 4 17:18:42 vmi223751 systemd-networkd-wait-online[8575]: Event loop failed: Connection timed out Jan 4 17:18:42 vmi223751 apt-helper[8573]: E: Sub-process /lib/systemd/systemd-networkd-wait-online returned an error code (1) Jan 4 17:18:43 vmi223751 systemd[1]: Started Daily apt download activities. Jan 4 17:27:04 vmi223751 systemd[1]: Starting Cleanup of Temporary Directories... Jan 4 17:27:04 vmi223751 systemd[1]: Started Cleanup of Temporary Directories. Jan 4 17:39:02 vmi223751 CRON[8630]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 17:39:02 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 17:39:02 vmi223751 systemd[1]: Started Clean php session files. Jan 4 17:42:01 vmi223751 CRON[8708]: (root) CMD (sync; echo 3 > /proc/sys/vm/drop_caches) Jan 4 17:42:01 vmi223751 kernel: [433818.048076] sh (8708): drop_caches: 3 Jan 4 18:09:01 vmi223751 CRON[8712]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 18:09:02 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 18:09:03 vmi223751 systemd[1]: Started Clean php session files. Jan 4 18:17:01 vmi223751 CRON[8797]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Jan 4 18:39:01 vmi223751 CRON[8801]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 18:39:02 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 18:39:03 vmi223751 systemd[1]: Started Clean php session files. Jan 4 18:42:01 vmi223751 CRON[8881]: (root) CMD (sync; echo 3 > /proc/sys/vm/drop_caches) Jan 4 18:42:01 vmi223751 kernel: [437418.205861] sh (8881): drop_caches: 3 Jan 4 19:09:01 vmi223751 CRON[8886]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi) Jan 4 19:09:03 vmi223751 systemd[1]: Starting Clean php session files... Jan 4 19:09:03 vmi223751 systemd[1]: Started Clean php session files. Jan 4 19:11:13 vmi223751 systemd[1]: Started Session 535 of user sebastian. Jan 4 19:14:13 vmi223751 systemd[1]: Starting Daily apt download activities... Jan 4 19:14:36 vmi223751 systemd[1]: Started Session 536 of user sebastian. Jan 4 19:14:39 vmi223751 systemd[1]: Started Session 537 of user sebastian. Jan 4 19:14:43 vmi223751 systemd-networkd-wait-online[9115]: Event loop failed: Connection timed out Jan 4 19:14:43 vmi223751 apt-helper[9113]: E: Sub-process /lib/systemd/systemd-networkd-wait-online returned an error code (1) Jan 4 19:14:44 vmi223751 systemd[1]: Started Daily apt download activities.