Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35636

crash on raspberry pi 5

    XMLWordPrintable

Details

    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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            wolfgangg66 Wolfgang Rohdewald
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.