Regular occurrance of InnoDB: Assertion failure in file ./storage/innobase/pars/pars0pars.cc line 771

journalctl -xeu mariadb.service:

J{{an 24 15:04:27 fr.casper.aero mariadbd[1707853]: 2025-01-24 15:04:27 0 [Note] InnoDB: Buffer pool(s) load completed at 250124 15:04:27

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: 2025-01-24 15:19:18 0x7fb0244b9640  InnoDB: Assertion failure in file ./storage/innobase/pars/pars0pars.cc line 771

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: Failing assertion: sym_node->table != NULL

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: We intentionally generate a memory trap.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: If you get repeated assertion failures or crashes, even

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: immediately after the mariadbd startup, there may be

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: corruption in the InnoDB tablespace. Please refer to

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: InnoDB: about forcing recovery.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: 250124 15:19:18 [ERROR] mysqld got signal 6 ;

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Sorry, we probably made a mistake, and this is a bug.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Your assistance in bug reporting will enable us to fix this for the next release.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: We will try our best to scrape up some info that will hopefully help

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: diagnose the problem, but since we have already crashed,

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: something is definitely wrong and this may fail.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Server version: 10.6.18-MariaDB-0ubuntu0.22.04.1 source revision: 887bb3f73555ff8a50138a580ca8308b9b5c069c

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: key_buffer_size=134217728

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: read_buffer_size=131072

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: max_used_connections=5

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: max_threads=153

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: thread_count=5

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: It is possible that mysqld could use up to

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468009 K  bytes of memory

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Hope that's ok; if not, decrease some variables in the equation.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Thread pointer: 0x7fafd0000c68

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Attempting backtrace. You can use the following information to find out

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: where mysqld died. If you see no messages after this, something went

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: terribly wrong...

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: stack_bottom = 0x7fb0244b8c78 thread_stack 0x49000

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(my_print_stacktrace+0x32)[0x55e82af068e2]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x55e82aa34e38]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7fb027614520]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x12c)[0x7fb0276689fc]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /lib/x86_64-linux-gnu/libc.so.6(raise+0x16)[0x7fb027614476]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7fb0275fa7f3]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0x67cadb)[0x55e82a6c3adb]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0x6690a8)[0x55e82a6b00a8]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xd4a964)[0x55e82ad91964]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xe56bbd)[0x55e82ae9dbbd]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xd4c66b)[0x55e82ad9366b]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xe490b9)[0x55e82ae900b9]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xe3bd84)[0x55e82ae82d84]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xe3d21b)[0x55e82ae8421b]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xe3d375)[0x55e82ae84375]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xd75648)[0x55e82adbc648]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xcdce9d)[0x55e82ad23e9d]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_ZN7handler12ha_write_rowEPKh+0x1a8)[0x55e82aa43938]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z12write_recordP3THDP5TABLEP12st_copy_infoP13select_result+0x1ed)[0x55e82a7c55bd]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesbP13select_result+0>

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x16be)[0x55e82a80141e]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1d8)[0x55e82a8050d8]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xb75)[0x55e82a806c35]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x131)[0x55e82a8088b1]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3af)[0x55e82a91310f]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55e82a91348d]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /usr/sbin/mariadbd(+0xc2e3c6)[0x55e82ac753c6]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7fb027666ac3]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: /lib/x86_64-linux-gnu/libc.so.6(+0x126850)[0x7fb0276f8850]

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Trying to get some variables.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Some pointers may be invalid and cause the dump to abort.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Query (0x7fafd0010a50): INSERT INTO Message(author,content,scope,state,title,type) VALUES ('2','<p><strong>&Agrave; p>

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Connection ID (thread ID): 266

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Status: NOT_KILLED

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_mer>

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: information that should help you find out what is causing the crash.

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Writing a core file...

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Working directory at /var/lib/mysql

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Resource Limits:

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Limit                     Soft Limit           Hard Limit           Units

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max cpu time              unlimited            unlimited            seconds

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max file size             unlimited            unlimited            bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max data size             unlimited            unlimited            bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max stack size            8388608              unlimited            bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max core file size        0                    unlimited            bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max resident set          unlimited            unlimited            bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max processes             63799                63799                processes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max open files            32768                32768                files

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max locked memory         524288               524288               bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max address space         unlimited            unlimited            bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max file locks            unlimited            unlimited            locks

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max pending signals       63799                63799                signals

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max msgqueue size         819200               819200               bytes

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max nice priority         0                    0

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max realtime priority     0                    0

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Max realtime timeout      unlimited            unlimited            us

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -- %E

Jan 24 15:19:18 fr.casper.aero mariadbd[1707853]: Kernel version: Linux version 5.15.0-89-generic (buildd@bos03-amd64-016) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, >

Jan 24 15:19:18 fr.casper.aero systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT

░░ Subject: Unit process exited

░░ Defined-By: systemd

░░ Support: http://www.ubuntu.com/support

░░ 

░░ An ExecStart= process belonging to unit mariadb.service has exited.

░░ 

░░ The process' exit code is 'killed' and its exit status is 6.

Jan 24 15:19:18 fr.casper.aero systemd[1]: mariadb.service: Failed with result 'signal'.

░░ Subject: Unit failed

░░ Defined-By: systemd