Bug #19709 rpl_tmporary fails on powermacg5

• Submitted: 11 May 2006 7:47
• Modified: 19 May 2006 11:17
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S2 (Serious)
• Assigned to: Magnus Blåudd
• CPU Architecture: Any

[11 May 2006 7:47] Magnus Blåudd

Description:
When running mysql-test-run.pl in PushBuild the following failure occurs.

rpl_temporary                  [ fail ]

Errors are (from /Users/henry/pb/mysql-5.0/[e-mail]/mysql-5.0.22-standard/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: At line 173: query 'kill @con1_id' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
Result from queries before failure can be found in r/rpl_temporary.log

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests

How to repeat:
rpl_temporary                  [ fail ]

Errors are (from /Users/henry/pb/mysql-5.0/[e-mail]/mysql-5.0.22-standard/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: At line 173: query 'kill @con1_id' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
Result from queries before failure can be found in r/rpl_temporary.log

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests

[11 May 2006 10:27] Magnus Blåudd

T@7    : | query: kill @con1_id
T@7    : | >mysql_parse
T@7    : | | >mysql_init_query
T@7    : | | | >lex_start
T@7    : | | | | >alloc_root
T@7    : | | | | | enter: root: 0x307ba20
T@7    : | | | | | exit: ptr: 0x307f050
T@7    : | | | | <alloc_root
T@7    : | | | <lex_start
T@7    : | | | >mysql_reset_thd_for_next_command
T@7    : | | | <mysql_reset_thd_for_next_command
T@7    : | | <mysql_init_query
T@7    : | | >Query_cache::send_result_to_client
T@7    : | | <Query_cache::send_result_to_client
T@7    : | | >alloc_root
T@7    : | | | enter: root: 0x307ba20
T@7    : | | | exit: ptr: 0x307f058
T@7    
<snip>
T@9    : >dispatch_command
T@9    : | >my_b_flush_io_cache
T@9    : | | >my_write
T@9    : | | | my: Fd: 5  Buffer: 0x3011a00  Count: 22  MyFlags: 20
T@9    : | | <my_write
T@9    : | <my_b_flush_io_cache
T@9    : | >free_root
T@9    : | | enter: root: 0x3088e20  flags: 1
T@9    : | <free_root
T@9    : <dispatch_command
T@9    : >close_connection
T@9    : | enter: fd: socket (37)  error: ''
T@9    : | >vio_close
T@9    : | <vio_close
T@9    : <close_connection
T@9    : >end_thread
T@9    : | >THD::cleanup
T@9    : | | >ha_rollback_trans
T@9    : | | | >push_warning
T@9    : | | | | enter: code: 1196, msg: Some non-transactional changed tables couldn't be rolled back
T@9    : | | | | >mysql_reset_errors
T@9    : | | | | | >free_root
T@9    : | | | | | | enter: root: 0x3089908  flags: 0
T@9    : | | | | | <free_root
T@9    : | | | | <mysql_reset_errors
T@9    : | | | | >query_cache_abort
T@9    : | | | | <query_cache_abort
T@9    : | | | | >alloc_root
T@9    : | | | | | enter: root: 0x3089908
T@9    : | | | | | >my_malloc
T@9    : | | | | | | my: size: 2020  my_flags: 16
T@9    : | | | | | | exit: ptr: 0x3078c00
T@9    : |

[11 May 2006 10:52] Magnus Blåudd

This is related to how the connection to the server is terminated by server. It should be changed to become consistent with the other platforms.

[11 May 2006 11:44] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6247

[12 May 2006 7:14] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6278

[19 May 2006 11:17] Magnus Blåudd

Closing nothing to document