[MDEV-31586] The test spider/bugfix.mdev_31463 has non-deterministic error codes Created: 2023-06-30  Updated: 2023-09-12  Resolved: 2023-08-18

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider, Tests
Affects Version/s: 11.0, 11.1
Fix Version/s: 11.0.4, 11.1.2, 11.2.1

Type: Bug Priority: Critical
Reporter: Yuchen Pei Assignee: Yuchen Pei
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-31463 SIGSEGV in server_mysql_send_query | ... Closed
Relates
relates to MDEV-32046 Spider test instability caused by ER_... Stalled

 Description   

The error code is non-deterministic, presumably due to some race
condition from the SLEEP statement above. The correct error should
be 12701 ER_SPIDER_REMOTE_SERVER_GONE_AWAY_NUM as it is the last
failure. Nevertheless, this contrived test is needed to cover the
error reporting when setting lock wait timeout, until we find a
better test case and/or fixing the non-deterministic error reporting

 Comments   
Comment by Elena Stepanova [ 2023-07-28 ]

Please fix it or disable it, we have lots of failures in buildbot.

Comment by Yuchen Pei [ 2023-07-31 ]

Hi holyfoot, ptal thanks

https://github.com/MariaDB/server/commit/15b3f795cd0

Comment by Yuchen Pei [ 2023-07-31 ]

Sorry about the problem elenst, I have raised the prio and sent a patch for review (see my previous comment)

Comment by Alexey Botchkov [ 2023-08-16 ]

ok to push.

Comment by Yuchen Pei [ 2023-08-18 ]

pushed 0254eb9307f58409f856517a90109d37ef9e10c4 to 11.0

Generated at Thu Feb 08 10:24:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.