Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.11.6
-
Debian Bookworm
Description
using nextcloud 30.0.2, two processes inserting data in parallel:
- occ fulltextsearch:index
- occ memories:places-setup
Raspberry Pi 5, 8G RAM, M.2 nvme
Dec 10 13:42:43 cloudpi mariadbd[915]: 2024-12-10 13:42:43 14433 [Warning] Aborted connection 14433 to db: 'nextcloud' user: 'oc_admin' host: 'localhost' (Got an error reading communication packets) |
Dec 12 20:58:36 cloudpi mariadbd[915]: 241212 20:58:36 [ERROR] mysqld got signal 11 ; |
Dec 12 20:58:36 cloudpi mariadbd[915]: Sorry, we probably made a mistake, and this is a bug. |
Dec 12 20:58:36 cloudpi mariadbd[915]: Your assistance in bug reporting will enable us to fix this for the next release. |
Dec 12 20:58:36 cloudpi mariadbd[915]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs |
Dec 12 20:58:36 cloudpi mariadbd[915]: We will try our best to scrape up some info that will hopefully help |
Dec 12 20:58:36 cloudpi mariadbd[915]: diagnose the problem, but since we have already crashed, |
Dec 12 20:58:36 cloudpi mariadbd[915]: something is definitely wrong and this may fail. |
Dec 12 20:58:36 cloudpi mariadbd[915]: Server version: 10.11.6-MariaDB-0+deb12u1 source revision: |
Dec 12 20:58:36 cloudpi mariadbd[915]: key_buffer_size=134217728 |
Dec 12 20:58:36 cloudpi mariadbd[915]: read_buffer_size=131072 |
Dec 12 20:58:36 cloudpi mariadbd[915]: max_used_connections=7 |
Dec 12 20:58:36 cloudpi mariadbd[915]: max_threads=153 |
Dec 12 20:58:36 cloudpi mariadbd[915]: thread_count=6 |
Dec 12 20:58:36 cloudpi mariadbd[915]: It is possible that mysqld could use up to |
Dec 12 20:58:36 cloudpi mariadbd[915]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468066 K bytes of memory |
Dec 12 20:58:36 cloudpi mariadbd[915]: Hope that's ok; if not, decrease some variables in the equation. |
Dec 12 20:58:36 cloudpi mariadbd[915]: Thread pointer: 0x7ffeb40a65d8 |
Dec 12 20:58:36 cloudpi mariadbd[915]: Attempting backtrace. You can use the following information to find out |
Dec 12 20:58:36 cloudpi mariadbd[915]: where mysqld died. If you see no messages after this, something went |
Dec 12 20:58:36 cloudpi mariadbd[915]: terribly wrong... |
Dec 12 20:58:36 cloudpi mariadbd[915]: stack_bottom = 0x7ffec0ddb6c8 thread_stack 0x49000 |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(my_print_stacktrace+0x30)[0x55559b4eb7b0] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(handle_fatal_signal+0x3b4)[0x55559b07b1b4] |
Dec 12 20:58:36 cloudpi mariadbd[909898]: addr2line: 'linux-vdso.so.1': No such file |
Dec 12 20:58:36 cloudpi mariadbd[915]: linux-vdso.so.1(__kernel_rt_sigreturn+0x0)[0x7ffee5f547b0] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xd9ec00)[0x55559b47ec00] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xda0870)[0x55559b480870] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xd18278)[0x55559b3f8278] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xca5ae4)[0x55559b385ae4] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xca80c0)[0x55559b3880c0] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xca8634)[0x55559b388634] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xcb7c90)[0x55559b397c90] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xc195a8)[0x55559b2f95a8] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_ZN7handler12ha_write_rowEPKh+0xd0)[0x55559b088d00] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z12write_recordP3THDP5TABLEP12st_copy_infoP13select_result+0x1d4)[0x55559ae451f4] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesbP13select_result+0xd84)[0x55559ae4b824] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x10e8)[0x55559ae7764c] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1b4)[0x55559ae7ac24] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xb40)[0x55559ae7c500] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x10c)[0x55559ae7da5c] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3dc)[0x55559af6ed6c] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(handle_one_connection+0x60)[0x55559af6f110] |
Dec 12 20:58:36 cloudpi mariadbd[915]: /usr/sbin/mariadbd(+0xb7b0b8)[0x55559b25b0b8] |
Dec 12 20:58:36 cloudpi mariadbd[915]: nptl/pthread_create.c:442(start_thread)[0x7ffee52fee90] |
Dec 12 20:58:36 cloudpi mariadbd[915]: aarch64/clone.S:82(thread_start)[0x7ffee5367b1c] |
Dec 12 20:58:36 cloudpi mariadbd[915]: Trying to get some variables. |
Dec 12 20:58:36 cloudpi mariadbd[915]: Some pointers may be invalid and cause the dump to abort. |
Dec 12 20:58:36 cloudpi mariadbd[915]: Query (0x7ffeb40b51c0): INSERT INTO `memories_planet_geometry` (`id`, `poly_id`, `type_id`, `osm_id`, `geometry`) VALUES('14250062_0', '14250062_0', '1', '14250062', ST_GeomFromT> |
Dec 12 20:58:36 cloudpi mariadbd[915]: Connection ID (thread ID): 27979 |
Dec 12 20:58:36 cloudpi mariadbd[915]: Status: NOT_KILLED |
Dec 12 20:58:36 cloudpi mariadbd[915]: 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_> |
Dec 12 20:58:36 cloudpi mariadbd[915]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains |
Dec 12 20:58:36 cloudpi mariadbd[915]: information that should help you find out what is causing the crash. |
Dec 12 20:58:36 cloudpi mariadbd[915]: Writing a core file... |
Dec 12 20:58:36 cloudpi mariadbd[915]: Working directory at /var/lib/mysql |
Dec 12 20:58:36 cloudpi mariadbd[915]: Resource Limits: |
Dec 12 20:58:36 cloudpi mariadbd[915]: Limit Soft Limit Hard Limit Units |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max cpu time unlimited unlimited seconds |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max file size unlimited unlimited bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max data size unlimited unlimited bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max stack size 8388608 unlimited bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max core file size 0 unlimited bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max resident set unlimited unlimited bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max processes 31891 31891 processes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max open files 32768 32768 files |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max locked memory 524288 524288 bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max address space unlimited unlimited bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max file locks unlimited unlimited locks |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max pending signals 31891 31891 signals |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max msgqueue size 819200 819200 bytes |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max nice priority 0 0 |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max realtime priority 0 0 |
Dec 12 20:58:36 cloudpi mariadbd[915]: Max realtime timeout unlimited unlimited us |
Dec 12 20:58:36 cloudpi mariadbd[915]: Core pattern: core |
Dec 12 20:58:36 cloudpi mariadbd[915]: Kernel version: Linux version 6.6.62+rpt-rpi-2712 (serge@raspberrypi.com) (gcc-12 (Debian 12.2.0-14) 12.2.0, GNU ld (GNU Binutils for Debian) 2.40) #1 SMP PREEMPT Debian 1:6.6.62> |
Dec 12 20:58:36 cloudpi systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV |