[MDEV-31101] spider/bugfix.mdev_29904 fails with "Server shutdown in progress" in CI Created: 2023-04-21 Updated: 2024-01-11 Resolved: 2024-01-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Spider |
| Affects Version/s: | 10.4, 10.5, 10.6 |
| Fix Version/s: | 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3 |
| Type: | Bug | Priority: | Major |
| Reporter: | Yuchen Pei | Assignee: | Yuchen Pei |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| 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:
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 |
| Comments |
| Comment by Yuchen Pei [ 2023-06-07 ] | ||||||||
|
Happened again today locally on a 10.5 patched with commit to
| ||||||||
| Comment by Yuchen Pei [ 2023-06-28 ] | ||||||||
|
I'm going to disable mdev_29904.test until the present issue is no longer blocked by | ||||||||
| Comment by Yuchen Pei [ 2023-11-28 ] | ||||||||
|
I have a patch on top of my current patches for e9ea9353d53 upstream/bb-10.4-mdev-31101 | ||||||||
| Comment by Yuchen Pei [ 2023-12-19 ] | ||||||||
|
Hi holyfoot, ptal this trivial patch, thanks
| ||||||||
| Comment by Alexey Botchkov [ 2024-01-06 ] | ||||||||
|
ok to push. | ||||||||
| Comment by Yuchen Pei [ 2024-01-11 ] | ||||||||
|
pushed d277a63c749bd49c9025da4efdd3008d22180dc0 to 10.4 |