Bug #8696 Replication problems on Mac OS X
Submitted: 22 Feb 2005 16:52 Modified: 23 Feb 2005 18:12
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3-pre OS:MacOS (OS X 10.2 + 10.3)
Assigned to: Sergei Golubchik CPU Architecture:Any

[22 Feb 2005 16:52] Joerg Bruehe
Description:
Affected tests are: 'rpl_auto_increment', 'rpl_commit_after_flush', 'rpl_insert_id', 'rpl_insert_ignore', and 'rpl_relayrotate'. Until now, this has been observed only in 'debug' on OS X.

This sequence of failures occurs with identical symptoms on both Mac OS X build hosts.
The build is based on changeset
  1.1880 05/02/21 20:41:48 monty@mysql.com +8 -0
  Generate warning in ha_delete_table() if files is missing in handler

Output is:

rpl_auto_increment             [ fail ]

Errors are (from...) :
.../mysqltest: line 59: failed in select master_pos_wait('master-bin.000001', 2875): 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
./mysql-test-run: kill: (20473) - No such process
master refused to die. Sending SIGKILL
./mysql-test-run: kill: (20473) - No such process
Master shutdown finished
slave not cooperating with mysqladmin, will try manual kill
./mysql-test-run: kill: (20434) - No such process
slave refused to die. Sending SIGKILL
./mysql-test-run: kill: (20434) - No such process
Slave shutdown finished
rpl_chain_temp_table           [ skipped ]
rpl_change_master              [ pass ]
rpl_charset                    [ pass ]
rpl_commit_after_flush         [ fail ]

Errors are (from ...) :
.../mysqltest: line 10: failed in select master_pos_wait('master-bin.000001', 381): 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
./mysql-test-run: kill: (23485) - No such process
master refused to die. Sending SIGKILL
./mysql-test-run: kill: (23485) - No such process
Master shutdown finished
slave not cooperating with mysqladmin, will try manual kill
./mysql-test-run: kill: (23493) - No such process
slave refused to die. Sending SIGKILL
./mysql-test-run: kill: (23493) - No such process
Slave shutdown finished
rpl_create_database            [ pass ]
....
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 not cooperating with mysqladmin, will try manual kill
./mysql-test-run: kill: (24343) - No such process
master refused to die. Sending SIGKILL
./mysql-test-run: kill: (24343) - No such process
Master shutdown finished
slave not cooperating with mysqladmin, will try manual kill
./mysql-test-run: kill: (24516) - No such process
slave refused to die. Sending SIGKILL
./mysql-test-run: kill: (24516) - No such process
Slave shutdown finished
rpl_insert_ignore              [ fail ]

Errors are (from ...) :
.../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_relayrotate                [ fail ]

Errors are (from ...) :
.../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 ]

How to repeat:
Build + test there.

Generated binaries + used sources can be provided, but a tree could not be saved.
[22 Feb 2005 17:05] Joerg Bruehe
I forgot to add:  Notoriously, some of these tests cause the machine to hang in the failure, and only a manual kill of the 'mysqld' server processes lets it continue. As a single 'kill' often has no effect, I got used to immediately call 'kill -9' on these hangs.
[23 Feb 2005 14:36] Guilhem Bichot
Found 3 issues (Xid_log_event::exec_event() wrong, Xid_log_event::end_log_pos wrong and Xid=0 wrong in the output of mysqlbinlog) and passed to Serg with his agreement.
[23 Feb 2005 18:12] Sergei Golubchik
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html