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

"mysqld --bootstrap" / mysql_install_db hangs when Spider is installed

    XMLWordPrintable

    Details

      Description

      If Spider is installed, then mysqld --bootstrap will hang when you run mysql_install_db. The hang looks similar to MDEV-20179.

      For example, you can see that Spider is installed:

      $ sudo cat /etc/mysql/mariadb.conf.d/spider.cnf 
      [mariadb]
      plugin-load-add=ha_spider.so
      

      I stop the service and delete the datadir:

      $ sudo systemctl stop mariadb
      $ sudo rm -fr /var/lib/mysql/*
      

      And then I run mysql_install_db:

      $ sudo mysql_install_db --user=mysql --basedir=/usr/ --datadir=/var/lib/mysql/
      

      This hangs with the following output:

      Installing MariaDB/MySQL system tables in '/var/lib/mysql/' ...
      2020-06-22 23:43:17 0 [Warning] Plugin 'SPIDER' is of maturity level gamma while the server is stable
      

      The stacktrace of the hang is:

      Thread 4 (Thread 0x7f2fcc0ac700 (LWP 18846)):
      #0  0x00007f2fd5c6a26c in __GI___sigtimedwait (set=<optimized out>, info=0x7f2fcc0abd30, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:42
      #1  0x00005627f9ac217b in signal_hand ()
      #2  0x00005627f9fc7a0a in ?? ()
      #3  0x00007f2fd694d6db in start_thread (arg=0x7f2fcc0ac700) at pthread_create.c:463
      #4  0x00007f2fd5d4b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 3 (Thread 0x7f2fc7fff700 (LWP 18819)):
      #0  0x00007f2fd69539f3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x5627fadfbd48 <COND_server_started+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88
      #1  __pthread_cond_wait_common (abstime=0x0, mutex=0x5627fadfbd60 <LOCK_server_started>, cond=0x5627fadfbd20 <COND_server_started>) at pthread_cond_wait.c:502
      #2  __pthread_cond_wait (cond=0x5627fadfbd20 <COND_server_started>, mutex=0x5627fadfbd60 <LOCK_server_started>) at pthread_cond_wait.c:655
      #3  0x00007f2fcc39732b in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so
      #4  0x00007f2fd694d6db in start_thread (arg=0x7f2fc7fff700) at pthread_create.c:463
      #5  0x00007f2fd5d4b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 2 (Thread 0x7f2fd80cc700 (LWP 18818)):
      #0  0x00007f2fd6953f85 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f2fd80cbdb0, expected=0, futex_word=0x5627fb6da0ac) at ../sysdeps/unix/sysv/linux/futex-internal.h:205
      #1  __pthread_cond_wait_common (abstime=0x7f2fd80cbdb0, mutex=0x5627fb6da0c0, cond=0x5627fb6da080) at pthread_cond_wait.c:539
      #2  __pthread_cond_timedwait (cond=0x5627fb6da080, mutex=0x5627fb6da0c0, abstime=0x7f2fd80cbdb0) at pthread_cond_wait.c:667
      #3  0x00005627fa3980b2 in ?? ()
      #4  0x00007f2fd694d6db in start_thread (arg=0x7f2fd80cc700) at pthread_create.c:463
      #5  0x00007f2fd5d4b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 1 (Thread 0x7f2fd8247800 (LWP 18815)):
      #0  __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
      #1  0x00007f2fd6950154 in __GI___pthread_mutex_lock (mutex=0x5627fd060680) at ../nptl/pthread_mutex_lock.c:133
      #2  0x00007f2fcc39bbd8 in spider_free_sts_threads(st_spider_thread*) () from /usr/lib/mysql/plugin/ha_spider.so
      #3  0x00007f2fcc39c096 in spider_db_done(void*) () from /usr/lib/mysql/plugin/ha_spider.so
      #4  0x00005627f9d8b800 in ha_finalize_handlerton(st_plugin_int*) ()
      #5  0x00005627f9b98575 in ?? ()
      #6  0x00005627f9b9c47e in ?? ()
      #7  0x00005627f9b9d265 in plugin_shutdown() ()
      #8  0x00005627f9ac1028 in ?? ()
      #9  0x00005627f9ac472a in unireg_abort ()
      #10 0x00005627f9acd1ba in mysqld_main(int, char**) ()
      #11 0x00007f2fd5c4bb97 in __libc_start_main (main=0x5627f9a8e4b0 <main>, argc=12, argv=0x7ffed856ce28, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffed856ce18) at ../csu/libc-start.c:310
      #12 0x00005627f9abfe1a in _start ()
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Kentoku Kentoku Shiba
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated: