Bug #8647 Replication prob 31 builds: rpl_insert_id, rpl_insert_ignore, rpl_relayrotate
Submitted: 21 Feb 2005 13:00 Modified: 24 Feb 2005 9:31
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.3-pre OS:Various Unix
Assigned to: Guilhem Bichot CPU Architecture:Any

[21 Feb 2005 13:00] Joerg Bruehe
Description:
Weekend build based on 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

In 31 cases, these three tests failed together:
 rpl_insert_id, rpl_insert_ignore, rpl_relayrotate
Failures were independent of product (standard, max, pro), depend only on machine.
These tests were skipped in classic; debug and cluster were not tried.

Messages:
=== quote start (using 'butch' as an example) ===
rpl_insert_id                  [ fail ]

Errors are (from...) :
.../mysqltest: line 37: failed in select master_pos_wait('master-bin.000001', 2007): 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
slave not cooperating with mysqladmin, will try manual kill
./mysql-test-run: kill: no such process
slave refused to die. Sending SIGKILL
./mysql-test-run: kill: no such process
Slave shutdown finished
rpl_insert_ignore              [ fail ]

Errors are (...) :
.../mysqltest: At line 14: query 'drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9' failed: 1217: Cannot delete or update a parent row: a foreign key constraint fails
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
rpl_loaddata                   [ pass ]
...
rpl_redirect                   [ pass ]
rpl_relayrotate                [ fail ]

Errors are (...) :
.../mysqltest: At line 58: query 'select max(a) from t1' failed: 1146: Table 'test.t1' doesn't exist
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
rpl_relayspace                 [ pass ]
=== quote end ===

This happens on:
butch, hp3750, hp3750-64bit, hpita2-64bit, hpux11-64bit, octane2, octane2-64bit, powermacg4, powermacg5, sunfire100c, sunfire100c-64bit.
On both powermacg4 + powermacg5, these tests get into a hang and do not terminate unless killed manually.

How to repeat:
Try a release build + test.
[24 Feb 2005 9:31] Guilhem Bichot
This bug was filed on 21st.  As several problems have been fixed on 23st (by Serg and me), which affected replication tests, I'm going to wait for the new bunch of test reports from the new 5.0.3 build, to first see if these 31 failures still exist (and I doubt they do). So as agreed with Jörg I'm closing the bug report, and Jörg will make a new one if needs be, with the updated test results.