[MDEV-27321] test cross- and upgrades on debian with spider being in mariadb-server-10.5 Created: 2021-12-20  Updated: 2023-12-07

Status: Stalled
Project: MariaDB Server
Component/s: Tests, Upgrades
Fix Version/s: 10.5

Type: Task Priority: Critical
Reporter: Sergei Golubchik Assignee: Timofey Turenko
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-22979 "mysqld --bootstrap" / mysql_install_... Closed

 Description   

in pr #1608 spider is moved from mariadb-plugin-spider package to mariadb-server-10.5

need to test that it doesn't break cross- and upgrades in various scenarios

 Comments   
Comment by Elena Stepanova [ 2022-03-14 ]

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.

Comment by Timofey Turenko [ 2022-03-18 ]

upgrade 10.5.15 -> 10.5.16 (bb-10.5-elenst branch) works (tested with mariadb-plugin-rocksdb package excluded)

Comment by Timofey Turenko [ 2022-03-22 ]

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

Comment by Elena Stepanova [ 2022-03-22 ]

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.

Comment by Yuchen Pei [ 2023-11-14 ]

Is the "upgrade" part of this ticket a duplicate to MDEV-27103?

Generated at Thu Feb 08 09:52:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.