Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6
-
None
Description
E.g. https://buildbot.mariadb.net/buildbot/builders/kvm-asan/builds/10208/steps/mtr_nm/logs/stdio
I am not sure why this happens and I cannot reproduce it at the same commit. Here is the complete test:
--echo #
|
--echo # MDEV-29904 SPIDER plugin initialization fails upon startup
|
--echo #
|
|
--let $restart_parameters=--plugin-load-add=ha_spider
|
--source include/restart_mysqld.inc |
According to [1] the error message means some query is still running while the server is shutting down. Maybe mtr tries to shutdown the server after --source include/restart_mysqld.inc while the spider init queries are still running in another thread? In that case perhaps we need to introduce a wait at the end of the test
[1] https://www.percona.com/blog/error-mysqld-sort-aborted-server-shutdown-in-progress/
To add a wait condition perhaps we could use include/wait_condition.inc, but that would require a sql statement to determine the completion, but looking at at spd_init_query.h, I don't see which statement can achieve this, so maybe we'll need to add an init query that signals completion.
On the other hand, if spider init queries are no longer running in a background thread, then this bug may be fixed automatically, so let's block this ticket with the init bug ticket MDEV-22979 where we are considering such change.
Attachments
Issue Links
- is blocked by
-
MDEV-22979 "mysqld --bootstrap" / mysql_install_db hangs when Spider is installed
-
- Closed
-
-
MDEV-29870 Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service
-
- Closed
-
- is caused by
-
MDEV-30581 Add a testcase for MDEV-29904
-
- Closed
-
Happened again today locally on a 10.5 patched with commit to
MDEV-30435and running multiple tests with parallel=auto (mtr chose 8)./mysql-test/mtr --parallel=auto --force --max-test-fail=0 spider/handler.direct_aggregate_part spider/handler.spider_fixes spider.direct_aggregate_part spider/bugfix.mdev_29904 spider.direct_aggregate spider.direct_aggregate_part spider.checksum_table_with_quick_mode_3 spider.basic_sql spider.basic_sql_part spider.auto_increment