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!
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.060 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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 ...