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:
None 
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 9:47] Joerg Bruehe
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 ...
[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!