DuckCorp » DuckCorp Infrastructure

Feb 02 04:08:01 Toushirou CRON[3015272]: (root) CMD (/usr/local/sbin/adm_mysql_wide_commands optimize >/dev/null)
[...]
Feb 02 04:08:07 Toushirou mariadbd[2219909]: 260202  4:08:07 [ERROR] /usr/sbin/mariadbd got signal 11 ;
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Sorry, we probably made a mistake, and this is a bug.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Your assistance in bug reporting will enable us to fix this for the next release.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
Feb 02 04:08:07 Toushirou mariadbd[2219909]: a bug on https://jira.mariadb.org/.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Please include the information from the server start above, to the end of the
Feb 02 04:08:07 Toushirou mariadbd[2219909]: information below.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Server version: 11.8.3-MariaDB-0+deb13u1 from Debian source revision: b565b3e7e041c480fd8013e3beec6b99544d6bf8
Feb 02 04:08:07 Toushirou mariadbd[2219909]: The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
Feb 02 04:08:07 Toushirou mariadbd[2219909]: contains instructions to obtain a better version of the backtrace below.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Following these instructions will help MariaDB developers provide a fix quicker.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Attempting backtrace. Include this in the bug report.
Feb 02 04:08:07 Toushirou mariadbd[2219909]: (note: Retrieving this information may fail)
Feb 02 04:08:07 Toushirou mariadbd[2219909]: Thread pointer: 0x7f4310000c68
Feb 02 04:08:07 Toushirou mariadbd[2219909]: stack_bottom = 0x7f4354165000 thread_stack 0x49000
Feb 02 04:08:08 Toushirou mariadbd[2219909]: 2026-02-02  4:08:08 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 02 04:08:12 Toushirou mariadbd[2219909]: /usr/sbin/mariadbd(my_print_stacktrace+0x32) [0x55ca6eadbb22]
Feb 02 04:08:17 Toushirou mariadbd[2219909]: /usr/sbin/mariadbd(handle_fatal_signal+0x1a3) [0x55ca6e576f43]
Feb 02 04:08:25 Toushirou mariadbd[2219909]: /lib/x86_64-linux-gnu/libc.so.6(+0x3fdf0) [0x7f436c84adf0]
Feb 02 04:08:28 Toushirou mariadbd[2219909]: 2026-02-02  4:08:28 0 [Warning] /usr/sbin/mariadbd: Thread 168051 (user : 'root') did not exit
Feb 02 04:08:30 Toushirou mariadbd[2219909]: /usr/sbin/mariadbd(+0x102c6b3) [0x55ca6ea4f6b3]
Feb 02 04:08:35 Toushirou mariadbd[2219909]: /usr/sbin/mariadbd(+0x102efe9) [0x55ca6ea51fe9]
Feb 02 04:08:40 Toushirou mariadbd[2219909]: /usr/sbin/mariadbd(+0xf9f12b) [0x55ca6e9c212b]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: include/rem0rec.inl:437(rtr_update_mbr_field(btr_cur_t*, unsigned short*, btr_cur_t*, unsigned char*, rtr_mbr*, unsigned char*, mtr_t*))[0x55ca6e94d308]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: gis/gis0rtree.cc:594(rtr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*, dberr_t*, que_thr_t*))[0x55ca6e9486f3]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: btr/btr0cur.cc:2649(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x55ca6e94bf95]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: row/row0merge.cc:195(spatial_index_info::insert(unsigned long, btr_pcur_t*, bool&, mem_block_info_t*, mtr_t*))[0x55ca6e8b6251]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: row/row0merge.cc:1768(row_merge_read_clustered_index(trx_t*, TABLE*, dict_table_t const*, dict_table_t*, bool, dict_index_t**, dict_index_t*, fts_psort_t*, merge_file_t*, unsigned long const*, unsigned long, dtuple_t const*, dict_add_v_col_t const*, unsigned long const*, unsigned long, ib_sequence_t&, unsigned char*, bool, pfs_os_file_t*, ut_stage_alter_t*, double, unsigned char*, TABLE*, bool, std::map<unsigned int, dict_col_t*, std::less<unsigned int>, std::allocator<std::pair<unsigned int const, dict_coinclude/ut0stage.h:395(row_merge_build_indexes(trx_t*, dict_table_t*, dict_table_t*, bool, dict_index_t**, unsigned long const*, unsigned long, TABLE*, dtuple_t const*, unsigned long const*, unsigned long, ib_sequence_t&, bool, ut_stage_alter_t*, dict_add_v_col_t const*, TABLE*, bool, std::map<unsigned int, dict_col_t*, std::less<unsigned int>, std::allocator<std::pair<unsigned int const, dict_col_t*> > > const*))[0x55ca6e3b2efc]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: handler/handler0alter.cc:8959(ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55ca6e42c1fb]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_table.cc:8276(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, TABLE_LIST*, Recreate_info*, Alter_info*, unsigned int, st_order*, bool, bool))[0x55ca6e42e654]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_table.cc:13144(mysql_recreate_table(THD*, TABLE_LIST*, Recreate_info*, bool))[0x55ca6e430b0e]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_admin.cc:77(admin_recreate_table(THD*, TABLE_LIST*, Recreate_info*, bool))[0x55ca6e2d5ecc]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_admin.cc:1290(mysql_admin_table(THD*, TABLE_LIST*, st_ha_check_opt*, st_mysql_const_lex_string const*, thr_lock_type, bool, bool, unsigned int, int (*)(THD*, TABLE_LIST*, st_ha_check_opt*), int (handler::*)(THD*, st_ha_check_opt*), int (*)(THD*, TABLE_LIST*, st_ha_check_opt*), bool) [clone .constprop.0])[0x55ca6e2da4bb]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_admin.cc:1676(Sql_cmd_optimize_table::execute(THD*))[0x55ca6e2dc2e3]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_parse.cc:5882(mysql_execute_command(THD*, bool))[0x55ca6e2de655]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_class.h:3146(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55ca6e42004d]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_parse.cc:1905(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55ca6e4203fd]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: sql/sql_parse.cc:1416(do_command(THD*, bool))[0x55ca6e7d4a44]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: /lib/x86_64-linux-gnu/libc.so.6(+0x92b7b) [0x7f436c89db7b]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: /lib/x86_64-linux-gnu/libc.so.6(+0x1107b8) [0x7f436c91b7b8]
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Connection ID (thread ID): 168051
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Status: KILL_SERVER
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Query (0x7f4310013460): OPTIMIZE TABLE `memories_planet_geometry`
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Writing a core file...
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Working directory at /var/lib/mysql
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Resource Limits (excludes unlimited resources):
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Limit                     Soft Limit           Hard Limit           Units
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max stack size            8388608              unlimited            bytes
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max core file size        0                    unlimited            bytes
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max processes             255758               255758               processes
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max open files            32768                32768                files
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max locked memory         524288               524288               bytes
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max pending signals       255758               255758               signals
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max msgqueue size         819200               819200               bytes
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max nice priority         0                    0
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Max realtime priority     0                    0
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Core pattern: core
Feb 02 04:08:42 Toushirou mariadbd[2219909]: Kernel version: Linux version 6.12.48+deb13-amd64 (debian-kernel@lists.debian.org) (x86_64-linux-gnu-gcc-14 (Debian 14.2.0-19) 14.2.0, GNU ld (GNU Binutils for Debian) 2.44) #1 SMP PREEMPT_DYNAMIC Debian 6.12.48-1 (2025-09-20)
Feb 02 04:08:42 Toushirou systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Feb 02 04:08:42 Toushirou systemd[1]: mariadb.service: Failed with result 'signal'.
Feb 02 04:08:42 Toushirou systemd[1]: mariadb.service: Consumed 1h 38min 22.360s CPU time, 11.2G memory peak.
Feb 02 04:08:47 Toushirou systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.
Feb 02 04:08:47 Toushirou systemd[1]: Starting mariadb.service - MariaDB 11.8.3 database server...

Since Jan 25, /usr/local/sbin/adm_mysql_wide_commands optimize is run every day at 04:08 am, then mariadb fails. The issue doesn't occur when
- the script is executed manually at another time
- the table memories_planet_geometry isn't optimized (meaning the script ignore this table)