Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.23
-
None
-
None
-
Linux 5.10.0-29-amd64 #1 SMP Debian 5.10.216-1 (2024-05-03) x86_64 GNU/Linux
WordPress v. 6.5.3, wpdb version 57155
PHP v. 8.3.7
Server version: 10.5.23-MariaDB-0+deb11u1 Debian 11
Sympl version 11
Description
On my web server there are a handful of WordPress sites, all running the same version and all working properly, except one, which displays the error "Error reconnecting to the database"
The log says that MariaDB receives a signal 11, and that I should report this as a bug. I can't find a related issue, although this is my first attempt to do this so I may well have missed something, in which case I apologise. Here is the output of sudo journalctl -f -u mariadb.service — I've marked the point at which I request the site in question. Requesting any other sites succeeds without anything appearing in the log:
sympl@potto:~$ sudo journalctl -f -u mariadb.service
|
[sudo] password for sympl:
|
-- Journal begins at Wed 2024-05-01 00:47:52 BST. --
|
May 27 11:54:49 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855046]: Upgrading MySQL tables if necessary.
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: Looking for 'mariadb' as: /usr/bin/mariadb
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: Looking for 'mariadb-check' as: /usr/bin/mariadb-check
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: This installation of MariaDB is already upgraded to 10.5.23-MariaDB.
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: There is no need to run mysql_upgrade again for 10.5.23-MariaDB.
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: You can use --force if you still want to run mysql_upgrade
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855049]: Running 'mariadb-check' with connection arguments: --socket='/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock'
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855058]: Checking for insecure root accounts.
|
May 27 11:54:50 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855062]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
|
|
|
[ HERE'S WHERE I REQUEST MY WEB SITE ]
|
|
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: 240527 11:55:20 [ERROR] mysqld got signal 11 ;
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Sorry, we probably made a mistake, and this is a bug.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Your assistance in bug reporting will enable us to fix this for the next release.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: We will try our best to scrape up some info that will hopefully help
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: diagnose the problem, but since we have already crashed,
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: something is definitely wrong and this may fail.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Server version: 10.5.23-MariaDB-0+deb11u1 source revision: 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: key_buffer_size=134217728
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: read_buffer_size=131072
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: max_used_connections=2
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: max_threads=153
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: thread_count=2
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: It is possible that mysqld could use up to
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467891 K bytes of memory
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Hope that's ok; if not, decrease some variables in the equation.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Thread pointer: 0x7f839c0014b8
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Attempting backtrace. You can use the following information to find out
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: where mysqld died. If you see no messages after this, something went
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: terribly wrong...
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: stack_bottom = 0x7f83d0410d78 thread_stack 0x49000
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55ef32db614e]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(handle_fatal_signal+0x475)[0x55ef328ab3b5]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x13140)[0x7f83da252140]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0xcbffbe)[0x55ef32bf8fbe]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0xd730ec)[0x55ef32cac0ec]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0xd79e7c)[0x55ef32cb2e7c]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0xc55265)[0x55ef32b8e265]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_ZN7handler27multi_range_read_info_constEjP15st_range_seq_ifPvjPjS3_P13Cost_estimate+0x273)[0x55ef327d25c3]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_ZN10DsMrr_impl16dsmrr_info_constEjP15st_range_seq_ifPvjPjS3_P13Cost_estimate+0x3f)[0x55ef327d50ef]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0xaa882b)[0x55ef329e182b]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyybbbb+0x7c0)[0x55ef329ef510]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x2b6c)[0x55ef3270ad7c]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xa0)[0x55ef3270bb00]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xb3)[0x55ef3270bbd3]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x138)[0x55ef3270c698]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0x762121)[0x55ef3269b121]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THD+0x3d6c)[0x55ef326a7d1c]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x20b)[0x55ef326a917b]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xdb5)[0x55ef326aaf55]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z10do_commandP3THD+0x120)[0x55ef326acda0]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x2f2)[0x55ef327a2b32]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55ef327a2dad]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /usr/sbin/mariadbd(+0xbb4ceb)[0x55ef32aedceb]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7)[0x7f83da246ea7]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f83d9e4da6f]
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Trying to get some variables.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Some pointers may be invalid and cause the dump to abort.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Query (0x7f839c010d40): SELECT option_name, option_value FROM bpwp_options WHERE autoload = 'yes'
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Connection ID (thread ID): 177
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Status: NOT_KILLED
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: 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,not_null_range_scan=off
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: information that should help you find out what is causing the crash.
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Writing a core file...
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Working directory at /var/lib/mysql
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Resource Limits:
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Limit Soft Limit Hard Limit Units
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max cpu time unlimited unlimited seconds
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max file size unlimited unlimited bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max data size unlimited unlimited bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max stack size 8388608 unlimited bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max core file size 0 unlimited bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max resident set unlimited unlimited bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max processes 11711 11711 processes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max open files 32768 32768 files
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max locked memory 65536 65536 bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max address space unlimited unlimited bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max file locks unlimited unlimited locks
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max pending signals 11711 11711 signals
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max msgqueue size 819200 819200 bytes
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max nice priority 0 0
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max realtime priority 0 0
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Max realtime timeout unlimited unlimited us
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Core pattern: core
|
May 27 11:55:20 potto.home.benpaley.uk0.bigv.io mariadbd[855030]: Kernel version: Linux version 5.10.0-29-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.216-1 (2024-05-03)
|
May 27 11:55:21 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
|
May 27 11:55:21 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Failed with result 'signal'.
|
May 27 11:55:21 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Consumed 2.383s CPU time.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 127.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io systemd[1]: Stopped MariaDB 10.5.23 database server.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Consumed 2.383s CPU time.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io systemd[1]: Starting MariaDB 10.5.23 database server...
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] Starting MariaDB 10.5.23-MariaDB-0+deb11u1 source revision 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb as process 855366
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Uses event mutexes
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Number of pools: 1
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Using generic crc32 instructions
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Using Linux native AIO
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Completed initialization of buffer pool
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=86287474046,86287474046
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Starting final batch to recover 347 pages from redo log.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: 128 rollback segments are active.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: 10.5.23 started; log sequence number 86292685398; transaction id 100330254
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] Plugin 'FEEDBACK' is disabled.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] Server socket created on IP: '127.0.0.1'.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] InnoDB: Buffer pool(s) load completed at 240527 11:55:26
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] Reading of all Master_info entries succeeded
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] Added new Master_info '' to hash table
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 2024-05-27 11:55:26 0 [Note] /usr/sbin/mariadbd: ready for connections.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Version: '10.5.23-MariaDB-0+deb11u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 11
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io systemd[1]: Started MariaDB 10.5.23 database server.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855381]: Upgrading MySQL tables if necessary.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: Looking for 'mariadb' as: /usr/bin/mariadb
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: Looking for 'mariadb-check' as: /usr/bin/mariadb-check
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: This installation of MariaDB is already upgraded to 10.5.23-MariaDB.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: There is no need to run mysql_upgrade again for 10.5.23-MariaDB.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: You can use --force if you still want to run mysql_upgrade
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855384]: Running 'mariadb-check' with connection arguments: --socket='/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock'
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855392]: Checking for insecure root accounts.
|
May 27 11:55:26 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855396]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 240527 11:55:28 [ERROR] mysqld got signal 11 ;
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Sorry, we probably made a mistake, and this is a bug.
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Your assistance in bug reporting will enable us to fix this for the next release.
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: We will try our best to scrape up some info that will hopefully help
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: diagnose the problem, but since we have already crashed,
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: something is definitely wrong and this may fail.
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Server version: 10.5.23-MariaDB-0+deb11u1 source revision: 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: key_buffer_size=134217728
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: read_buffer_size=131072
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: max_used_connections=1
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: max_threads=153
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: thread_count=1
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: It is possible that mysqld could use up to
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467891 K bytes of memory
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Hope that's ok; if not, decrease some variables in the equation.
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Thread pointer: 0x7fae08000c58
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Attempting backtrace. You can use the following information to find out
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: where mysqld died. If you see no messages after this, something went
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: terribly wrong...
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: stack_bottom = 0x7fae4460ed78 thread_stack 0x49000
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x562e7bc2714e]
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(handle_fatal_signal+0x475)[0x562e7b71c3b5]
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x13140)[0x7fae4e405140]
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0xcbffbe)[0x562e7ba69fbe]
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0xd730ec)[0x562e7bb1d0ec]
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0xd79e7c)[0x562e7bb23e7c]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0xc55265)[0x562e7b9ff265]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_ZN7handler27multi_range_read_info_constEjP15st_range_seq_ifPvjPjS3_P13Cost_estimate+0x273)[0x562e7b6435c3]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_ZN10DsMrr_impl16dsmrr_info_constEjP15st_range_seq_ifPvjPjS3_P13Cost_estimate+0x3f)[0x562e7b6460ef]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0xaa882b)[0x562e7b85282b]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyybbbb+0x7c0)[0x562e7b860510]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x2b6c)[0x562e7b57bd7c]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xa0)[0x562e7b57cb00]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xb3)[0x562e7b57cbd3]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x138)[0x562e7b57d698]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0x762121)[0x562e7b50c121]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THD+0x3d6c)[0x562e7b518d1c]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x20b)[0x562e7b51a17b]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xdb5)[0x562e7b51bf55]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z10do_commandP3THD+0x120)[0x562e7b51dda0]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x2f2)[0x562e7b613b32]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x562e7b613dad]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /usr/sbin/mariadbd(+0xbb4ceb)[0x562e7b95eceb]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7)[0x7fae4e3f9ea7]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fae4e000a6f]
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Trying to get some variables.
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Some pointers may be invalid and cause the dump to abort.
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Query (0x7fae0801d690): SELECT option_name, option_value FROM bpwp_options WHERE autoload = 'yes'
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Connection ID (thread ID): 173
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Status: NOT_KILLED
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Failed with result 'signal'.
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: 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,not_null_range_scan=off
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: information that should help you find out what is causing the crash.
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Writing a core file...
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Working directory at /var/lib/mysql
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Resource Limits:
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Limit Soft Limit Hard Limit Units
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max cpu time unlimited unlimited seconds
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max file size unlimited unlimited bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max data size unlimited unlimited bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max stack size 8388608 unlimited bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max core file size 0 unlimited bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max resident set unlimited unlimited bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max processes 11711 11711 processes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max open files 32768 32768 files
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max locked memory 65536 65536 bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max address space unlimited unlimited bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max file locks unlimited unlimited locks
|
May 27 11:55:28 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Consumed 2.214s CPU time.
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max pending signals 11711 11711 signals
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max msgqueue size 819200 819200 bytes
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max nice priority 0 0
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max realtime priority 0 0
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Max realtime timeout unlimited unlimited us
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Core pattern: core
|
May 27 11:55:29 potto.home.benpaley.uk0.bigv.io mariadbd[855366]: Kernel version: Linux version 5.10.0-29-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.216-1 (2024-05-03)
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 128.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io systemd[1]: Stopped MariaDB 10.5.23 database server.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io systemd[1]: mariadb.service: Consumed 2.214s CPU time.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io systemd[1]: Starting MariaDB 10.5.23 database server...
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] Starting MariaDB 10.5.23-MariaDB-0+deb11u1 source revision 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb as process 855634
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Uses event mutexes
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Number of pools: 1
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Using generic crc32 instructions
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Using Linux native AIO
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Completed initialization of buffer pool
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=86287474046,86287474046
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Starting final batch to recover 347 pages from redo log.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: 128 rollback segments are active.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: 10.5.23 started; log sequence number 86292687464; transaction id 100330254
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] Plugin 'FEEDBACK' is disabled.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] Server socket created on IP: '127.0.0.1'.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] InnoDB: Buffer pool(s) load completed at 240527 11:55:34
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] Reading of all Master_info entries succeeded
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] Added new Master_info '' to hash table
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: 2024-05-27 11:55:34 0 [Note] /usr/sbin/mariadbd: ready for connections.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io mariadbd[855634]: Version: '10.5.23-MariaDB-0+deb11u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 11
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io systemd[1]: Started MariaDB 10.5.23 database server.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855650]: Upgrading MySQL tables if necessary.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: Looking for 'mariadb' as: /usr/bin/mariadb
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: Looking for 'mariadb-check' as: /usr/bin/mariadb-check
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: This installation of MariaDB is already upgraded to 10.5.23-MariaDB.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: There is no need to run mysql_upgrade again for 10.5.23-MariaDB.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: You can use --force if you still want to run mysql_upgrade
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855653]: Running 'mariadb-check' with connection arguments: --socket='/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock'
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855661]: Checking for insecure root accounts.
|
May 27 11:55:34 potto.home.benpaley.uk0.bigv.io /etc/mysql/debian-start[855665]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
|
I have recently upgraded the server from Debian 10 to Debian 11, and from MariaDB 10.3.39 to 10.5.23, but this site definitely worked for at least some days before this error began.
Here are the contents of my.cnf (other lines are commented):
[client-server]
|
# Port or socket location where to connect
|
# port = 3306
|
socket = /run/mysqld/mysqld.sock
|
|
|
# Import all .cnf files from configuration directory
|
!includedir /etc/mysql/conf.d/
|
!includedir /etc/mysql/mariadb.conf.d/
|
I can't think of how to reproduce the issue since I have no idea what condition or combination of conditions is responsible.