| Bug #8640 | Server crash due to 'flush status' in various tests | ||
|---|---|---|---|
| Submitted: | 21 Feb 2005 9:47 | Modified: | 24 Feb 2005 13:53 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.3-pre | OS: | some Unix 64-bit |
| Assigned to: | Jani Tolonen | CPU Architecture: | Any |
[21 Feb 2005 17:56]
Joerg Bruehe
As the symptom is the same, I add this in the hope it may help in finding the bug: Similar symptom in 'count_distinct2', here quoted from hp3750-64bit, but also on hpita2-64bit, hpux11-64bit, octane2-64bit, sunfire100c-64bit count_distinct2 [ fail ] Errors are (from...) : .../mysqltest: At line 62: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon master not cooperating with mysqladmin, will try manual kill kill: 16299: The specified process does not exist. master refused to die. Sending SIGKILL kill: 16299: The specified process does not exist. Master shutdown finished Slave shutdown finished count_distinct3 [ pass ]
[21 Feb 2005 18:24]
Joerg Bruehe
Same effect in tests 'grant_cache', 'preload', on the same platforms ... grant_cache [ fail ] Errors are (from /var/tmp/hpita2-64bit/.../mysqltest-time) : .../mysqltest: At line 12: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) preload [ fail ] Errors are (from /home/mysqldev/hp3750-64bit/test/mysql-classic-5.0.3-alpha-hp-hpux11.00-hppa2.0w-64bit/mysql-test/var/log/mysqltest-time) : .../mysqltest: At line 56: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) query_cache [ fail ] Errors are (from /home/mysqldev/hp3750-64bit/test/mysql-classic-5.0.3-alpha-hp-hpux11.00-hppa2.0w-64bit/mysql-test/var/log/mysqltest-time) : .../mysqltest: At line 13: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) status [ fail ] Errors are (from ...) : .../mysqltest: At line 14: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) temp_table [ fail ] Errors are (from...) : .../mysqltest: At line 88: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) union [ fail ] Errors are (from ...) : .../mysqltest: At line 492: query 'FLUSH STATUS' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) view_query_cache [ fail ] Errors are (from /var/tmp/hpita2-64bit/.../mysqltest-time) : /var/tmp/hpita2-64bit/.../mysqltest: At line 6: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon master not cooperating with mysqladmin, will try manual kill kill: 10050: The specified process does not exist. master refused to die. Sending SIGKILL kill: 10050: The specified process does not exist. Master shutdown finished Slave shutdown finished view_skip_grants [ pass ] (This last case is an example of a hanging test which needed a manual kill to get the suite to continue.)
[24 Feb 2005 13:53]
Lenz Grimmer
Did not occur in the recent test build anymore (after the fix was pushed). Closing!
Description: Server crash in test 'sp', symptom: Errors are (from /home/mysqldev/hp3750-64bit/test/mysql-classic-5.0.3-alpha-hp-hpux11.00-hppa2.0w-64bit/mysql-test/var/log/mysqltest-time) : /home/mysqldev/hp3750-64bit/test/mysql-classic-5.0.3-alpha-hp-hpux11.00-hppa2.0w-64bit/bin/mysqltest: At line 2425: query 'flush status' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) This happens only on hp3750-64bit, hpita2-64bit, hpux11-64bit, octane2-64bit, and sunfire100c-64bit. It does _not_ happen on aix52-64bit, barney (Alpha), Most recent changesets: ChangeSet 1.1862 05/02/18 17:46:30 pem@mysql.com +1 -0 Merge mysql.com:/usr/local/bk/mysql-5.0 into mysql.com:/home/pem/work/mysql-5.0 ChangeSet 1.1856.1.1 05/02/18 17:39:32 pem@mysql.comhem.se +3 -0 Fixed... BUG#6642: Stored procedure crash if expression with set function BUG#7013: Stored procedure crash if group by ... with rollup BUG#7743: 'Lost connection to MySQL server during query' on Stored Procedure BUG#7992: SELECT .. INTO variable .. within Stored Procedure crashes the server BUG#8116: calling simple stored procedure twice in a row results in server crash Rolling back the item change list after each substatement in a procedure fixed the failing assert(). How to repeat: Build and run the tests ...