Elena Stepanova added a comment - 2022-03-14 13:57 Unfortunately (or not), this task fell through the cracks till now. tturenko , I've pushed the patch into bb-10.5-elenst branch, it will build today. Could you please run the tests? Feel free to add any remotely meaningful upgrade combinations on top of what you usually have. Only deb packages, the patch is about them.

Timofey Turenko added a comment - 2022-03-18 11:54 upgrade 10.5.15 -> 10.5.16 (bb-10.5-elenst branch) works (tested with mariadb-plugin-rocksdb package excluded)

Timofey Turenko added a comment - 2022-03-22 12:47 clean install fails on DEB-based distros: apt got stuck when trying to setup mariadb-server-10.5 package, a lot of mysql_install_db processes are running: root 17015 16914 0 11:11 pts/0 00:00:00 sudo -E apt-get -q -o Dpkg::Options::=--force-confold -o Dpkg::Options::=--force-confdef -y --force-yes install mariadb-plugin-gssapi-client mariadb-plugin-s3 mariadb-backup mariadb-plugin-cracklib-password-check mariadb-plugin-gs root 17016 17015 0 11:11 pts/0 00:00:00 apt-get -q -o Dpkg::Options::=--force-confold -o Dpkg::Options::=--force-confdef -y --force-yes install mariadb-plugin-gssapi-client mariadb-plugin-s3 mariadb-backup mariadb-plugin-cracklib-password-check mariadb-plugin-gssapi-ser root 17601 17016 0 11:11 pts/2 00:00:00 /usr/bin/dpkg --force-confold --force-confdef --status-fd 42 --configure --pending root 17637 17601 0 11:11 pts/2 00:00:00 /usr/bin/perl -w /usr/share/debconf/frontend /var/lib/dpkg/info/mariadb-server-10.5.postinst configure root 17642 17637 0 11:11 pts/2 00:00:00 /bin/bash /var/lib/dpkg/info/mariadb-server-10.5.postinst configure root 17667 2 0 11:11 ? 00:00:00 [kworker/u16:3-events_unbound] root 17694 17642 0 11:11 pts/2 00:00:00 bash /usr/bin/mysql_install_db --rpm --cross-bootstrap --user=mysql --disable-log-bin --skip-test-db root 17695 17642 0 11:11 pts/2 00:00:00 logger -p daemon err -t mariadb-server-10.5.postinst -i root 17718 17694 0 11:11 pts/2 00:00:00 bash /usr/bin/mysql_install_db --rpm --cross-bootstrap --user=mysql --disable-log-bin --skip-test-db root 17719 17694 0 11:11 pts/2 00:00:00 bash /usr/bin/mysql_install_db --rpm --cross-bootstrap --user=mysql --disable-log-bin --skip-test-db root 17720 17694 0 11:11 pts/2 00:00:00 bash /usr/bin/mysql_install_db --rpm --cross-bootstrap --user=mysql --disable-log-bin --skip-test-db root 17721 17718 0 11:11 pts/2 00:00:00 cat /usr/share/mysql/mysql_system_tables.sql /usr/share/mysql/mysql_performance_tables.sql /usr/share/mysql/mysql_system_tables_data.sql /usr/share/mysql/fill_help_tables.sql /usr/share/mysql/maria_add_gis_sp_bootstrap.sql root 17722 17719 0 11:11 pts/2 00:00:00 sed -e /@current_hostname/d mysql 17723 17720 10 11:11 pts/2 00:00:07 /usr/sbin/mysqld --lc-messages-dir=/usr/share/mysql/english/.. --bootstrap --silent-startup --basedir=/usr --datadir=/var/lib/mysql --log-warnings=0 --enforce-storage-engine= --plugin-dir=/usr/lib/mysql/plugin --loose-disable-plug

Elena Stepanova added a comment - 2022-03-22 16:07 - edited This is either MDEV-22979 or something very close to it. A stack trace from the hanging server: [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". __lll_lock_wait (futex=futex@entry=0x55efab8384d0, private=0) at lowlevellock.c:52 52 lowlevellock.c: No such file or directory.   Thread 27 (Thread 0x7f07d0195700 (LWP 3168)): #0 0x00007f07df8d1322 in __GI___sigtimedwait (set=0x7f07d0194cb0, info=0x7f07d0194d30, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x000055efa81f62c4 in signal_hand () #2 0x000055efa87403af in ?? () #3 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #4 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 26 (Thread 0x7f077b7fe700 (LWP 3165)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f077b7fdd40, clockid=<optimized out>, expected=0, futex_word=0x55efab906fcc) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f077b7fdd40, clockid=<optimized out>, mutex=0x55efab7d99d0, cond=0x55efab906fa0) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x55efab906fa0, mutex=0x55efab7d99d0, abstime=0x7f077b7fdd40) at pthread_cond_wait.c:656 #3 0x000055efa8a2cbc4 in tpool::thread_pool_generic::wait_for_tasks(std::unique_lock<std::mutex>&, tpool::worker_data*) () #4 0x000055efa8a2cf01 in tpool::thread_pool_generic::get_task(tpool::worker_data*, tpool::task**) () #5 0x000055efa8a2e545 in tpool::thread_pool_generic::worker_main(tpool::worker_data*) () #6 0x00007f07dfca3cb4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #7 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #8 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 25 (Thread 0x7f0783fff700 (LWP 3157)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efa92abf98) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efa92abf00, cond=0x55efa92abf70) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efa92abf70, mutex=0x55efa92abf00) at pthread_cond_wait.c:638 #3 0x000055efa89751dc in ?? () #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 24 (Thread 0x7f07aaffd700 (LWP 3156)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x000055efa8a3024d in tpool::aio_linux::getevent_thread_routine(tpool::aio_linux*) () #2 0x00007f07dfca3cb4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #3 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #4 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 23 (Thread 0x7f07ab7fe700 (LWP 3155)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f07ab7fdd30, clockid=<optimized out>, expected=0, futex_word=0x55efa9b62b28) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f07ab7fdd30, clockid=<optimized out>, mutex=0x55efa9b62b40, cond=0x55efa9b62b00) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x55efa9b62b00, mutex=0x55efa9b62b40, abstime=0x7f07ab7fdd30) at pthread_cond_wait.c:656 #3 0x000055efa86d1fa1 in ?? () #4 0x000055efa86ca1ef in ?? () #5 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #6 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 22 (Thread 0x7f07b8ff9700 (LWP 3154)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab839430) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab839440, cond=0x55efab839408) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab839408, mutex=0x55efab839440) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 21 (Thread 0x7f07b97fa700 (LWP 3153)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab839360) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab839370, cond=0x55efab839338) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab839338, mutex=0x55efab839370) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 20 (Thread 0x7f07b9ffb700 (LWP 3152)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab839290) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab8392a0, cond=0x55efab839268) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab839268, mutex=0x55efab8392a0) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 19 (Thread 0x7f07ba7fc700 (LWP 3151)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab8391c0) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab8391d0, cond=0x55efab839198) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab839198, mutex=0x55efab8391d0) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 18 (Thread 0x7f07baffd700 (LWP 3150)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab8390f0) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab839100, cond=0x55efab8390c8) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab8390c8, mutex=0x55efab839100) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 17 (Thread 0x7f07bb7fe700 (LWP 3149)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab839020) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab839030, cond=0x55efab838ff8) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838ff8, mutex=0x55efab839030) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 16 (Thread 0x7f07bbfff700 (LWP 3148)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838f50) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838f60, cond=0x55efab838f28) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838f28, mutex=0x55efab838f60) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 15 (Thread 0x7f07abfff700 (LWP 3147)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838e80) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838e90, cond=0x55efab838e58) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838e58, mutex=0x55efab838e90) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 14 (Thread 0x7f07c8f57700 (LWP 3146)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838db0) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838dc0, cond=0x55efab838d88) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838d88, mutex=0x55efab838dc0) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 13 (Thread 0x7f07c9ffb700 (LWP 3145)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838ce0) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838cf0, cond=0x55efab838cb8) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838cb8, mutex=0x55efab838cf0) at pthread_cond_wait.c:638 #3 0x00007f07ddd23880 in spider_table_bg_crd_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 12 (Thread 0x7f07ca7fc700 (LWP 3144)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838c10) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838c20, cond=0x55efab838be8) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838be8, mutex=0x55efab838c20) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 11 (Thread 0x7f07caffd700 (LWP 3143)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838b40) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838b50, cond=0x55efab838b18) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838b18, mutex=0x55efab838b50) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 10 (Thread 0x7f07cb7fe700 (LWP 3142)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838a70) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838a80, cond=0x55efab838a48) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838a48, mutex=0x55efab838a80) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 9 (Thread 0x7f07cbfff700 (LWP 3141)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab8389a0) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab8389b0, cond=0x55efab838978) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838978, mutex=0x55efab8389b0) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 8 (Thread 0x7f07d0f57700 (LWP 3140)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab8388d0) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab8388e0, cond=0x55efab8388a8) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab8388a8, mutex=0x55efab8388e0) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 7 (Thread 0x7f07d1758700 (LWP 3139)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838800) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838810, cond=0x55efab8387d8) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab8387d8, mutex=0x55efab838810) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 6 (Thread 0x7f07c9758700 (LWP 3138)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838730) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838740, cond=0x55efab838708) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838708, mutex=0x55efab838740) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 5 (Thread 0x7f07dcc98700 (LWP 3137)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838660) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab838670, cond=0x55efab838638) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838638, mutex=0x55efab838670) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 4 (Thread 0x7f07dd499700 (LWP 3136)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55efab838590) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55efab8385a0, cond=0x55efab838568) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x55efab838568, mutex=0x55efab8385a0) at pthread_cond_wait.c:638 #3 0x00007f07ddd22760 in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 3 (Thread 0x7f07ddc9a700 (LWP 3135)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f07ddc99db0, clockid=<optimized out>, expected=0, futex_word=0x55efa9329828 <COND_server_started+40>) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f07ddc99db0, clockid=<optimized out>, mutex=0x55efa9329840 <LOCK_server_started>, cond=0x55efa9329800 <COND_server_started>) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x55efa9329800 <COND_server_started>, mutex=0x55efa9329840 <LOCK_server_started>, abstime=0x7f07ddc99db0) at pthread_cond_wait.c:656 #3 0x00007f07ddd22aae in spider_table_bg_sts_action(void*) () from /usr/lib/mysql/plugin/ha_spider.so #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 2 (Thread 0x7f07df52c700 (LWP 3134)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f07df52bdb0, clockid=<optimized out>, expected=0, futex_word=0x55efa9c05208) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f07df52bdb0, clockid=<optimized out>, mutex=0x55efa9c05220, cond=0x55efa9c051e0) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x55efa9c051e0, mutex=0x55efa9c05220, abstime=0x7f07df52bdb0) at pthread_cond_wait.c:656 #3 0x000055efa8aa0c52 in ?? () #4 0x00007f07dfdbd609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f07df9ac103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95   Thread 1 (Thread 0x7f07df6f5800 (LWP 3132)): #0 __lll_lock_wait (futex=futex@entry=0x55efab8384d0, private=0) at lowlevellock.c:52 #1 0x00007f07dfdc0235 in __GI___pthread_mutex_lock (mutex=0x55efab8384d0) at ../nptl/pthread_mutex_lock.c:135 #2 0x00007f07ddd0eb30 in spider_create_handler(handlerton*, TABLE_SHARE*, st_mem_root*) () from /usr/lib/mysql/plugin/ha_spider.so #3 0x000055efa84e633e in get_new_handler(TABLE_SHARE*, st_mem_root*, handlerton*) () #4 0x000055efa84e98cb in ?? () #5 0x000055efa84f035c in ha_delete_table(THD*, handlerton*, char const*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, bool) () #6 0x000055efa84f0633 in ?? () #7 0x000055efa82db786 in plugin_foreach_with_mask(THD*, char (*)(THD*, st_plugin_int*, void*), int, unsigned int, void*) () #8 0x000055efa84eec60 in ha_delete_table_force(THD*, char const*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) () #9 0x000055efa8367d73 in mysql_rm_table_no_locks(THD*, TABLE_LIST*, bool, bool, bool, bool, bool, bool) () #10 0x000055efa8368fda in mysql_rm_table(THD*, TABLE_LIST*, bool, bool, bool, bool) () #11 0x000055efa82d27b7 in mysql_execute_command(THD*) () #12 0x000055efa82c0c5f in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) () #13 0x000055efa82cb94c in bootstrap(st_mysql_file*) () #14 0x000055efa81ffd5e in mysqld_main(int, char**) () #15 0x00007f07df8b10b3 in __libc_start_main (main=0x55efa81c3960 <main>, argc=14, argv=0x7ffc2dac1448, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffc2dac1438) at ../csu/libc-start.c:308 #16 0x000055efa81f3cae in _start () serg , Given that it's a deterministic hang, I don't think we can proceed with this packaging change until MDEV-22979 is fixed.

Yuchen Pei added a comment - 2023-11-14 06:37 Is the "upgrade" part of this ticket a duplicate to MDEV-27103 ?

Timofey Turenko added a comment - 2025-02-04 11:14 I will try to reproduce it with the latest versions

Timofey Turenko added a comment - 2025-02-08 00:28 it is not reproducible any more: https://mdbe-buildbot.mariadb.net/#/builders/10/builds/58426 https://mdbe-buildbot.mariadb.net/#/builders/28/builds/36313