Bug #7289 Test failure: 'warnings' (using '--ps-protocol': server crash)
Submitted: 14 Dec 2004 17:25 Modified: 14 Jan 2005 19:05
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Linux (Linux / Athlon)
Assigned to: Konstantin Osipov CPU Architecture:Any

[14 Dec 2004 17:25] Joerg Bruehe
Description:
Test 'warnings' fails for me in current 5.0, when I run the test suite with '--ps-protocol'.
In a standard run, this test passes.

This is a non-debug build: 'compile-pentium-max'.

Failure report:
=== cut ===
warnings                       [ fail ]

Errors are (from /M50/push-5.0/mysql-test/var/log/mysqltest-time) :
/M50/push-5.0/client/.libs/mysqltest: At line 58: unable to execute statement 'update t1 set d=c': Lost connection to MySQL server during query (mysql_stmt_errno=2013 returned=1)
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

master not cooperating with mysqladmin, will try manual kill
./mysql-test-run: line 1289: kill: (434) - Kein passender Prozess gefunden
master refused to die. Sending SIGKILL
./mysql-test-run: line 1293: kill: (434) - Kein passender Prozess gefunden
Master shutdown finished
Slave shutdown finished
=== cut ===

I tried to get a backtrace, but seem to have hit the wrong target:
(gdb) where
#0  0x4022d691 in kill () from /lib/libc.so.6
#1  0x40153511 in pthread_kill () from /lib/libpthread.so.0
#2  0x08295dcb in write_core (sig=440) at stacktrace.c:220
#3  0x0819ab58 in handle_segfault (sig=440) at mysqld.cc:1904
#4  0x40156895 in __pthread_sighandler () from /lib/libpthread.so.0
#5  <signal handler called>
#6  0x40156b1b in read () from /lib/libpthread.so.0
#7  0xbe3ff997 in ?? ()
#8  0x081928d7 in my_net_read (net=0x8bfa4d4) at net_serv.cc:873
#9  0x081b044e in do_command (thd=0x8bf9df8) at sql_parse.cc:1282
#10 0x081af94c in handle_one_connection (arg=0x8bfa4d4) at sql_parse.cc:1052
#11 0x40150c60 in pthread_start_thread () from /lib/libpthread.so.0
(gdb)

Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
  Fix for bug #7223: information_schema: error in "views"

The error is older, as I got it already yesterday but did not yet report.

How to repeat:
Run the test suite with '--ps-protocol'.
[14 Jan 2005 19:05] Joerg Bruehe
I cannot reproduce it any more, seems to have been corrected (there were corrections for the '--ps-protocol' case).