Skip to content
This repository has been archived by the owner on Oct 11, 2018. It is now read-only.

main.max_statement_time test not stable on loaded machines, upstream fixes should be backported #31

Open
laurynas-biveinis opened this issue Aug 25, 2015 · 0 comments

Comments

@laurynas-biveinis
Copy link

For example, an ASan build (which is slower but the test is not skipped, unlike with Valgrind) may fail with:

main.max_statement_time                  w4 [ fail ]
        Test ended at 2015-08-19 23:52:08

CURRENT_TEST: main.max_statement_time
mysqltest: At line 498: query 'SELECT 1 AS STATUS FROM INFORMATION_SCHEMA.GLOBAL_STATUS
WHERE VARIABLE_NAME = 'Qcache_hits'
        AND CONVERT(VARIABLE_VALUE, UNSIGNED) > @qc_hits' failed: 1886: Query execution was interrupted, max_statement_time exceeded

This particular failure could be avoided by resetting max_statement_time for INFORMATION_SCHEMA queries, which shouldn't be subject to timeouts here.

This has been fixed in upstream at 4a4f248. It also has at least one other stability fix (before the feature implementation diverged): a53f8bd. Still the current upstream test case (for the diverged implementation) has at least one instability bug report open: http://bugs.mysql.com/bug.php?id=77959

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant