Bug #30728 rpl_packet fails in ps-mode with out-of-memory in slave.err
Submitted: 30 Aug 2007 18:25 Modified: 3 Sep 2007 18:58
Reporter: Andrei Elkin Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S3 (Non-critical)
Version:5.1.22 OS:Solaris
Assigned to: Sveta Smirnova CPU Architecture:Any

[30 Aug 2007 18:25] Andrei Elkin
xref can provide several links like

rpl.rpl_packet                 [ fail ]

Errors are (from /tmp/var-ps_row-101/log/mysqltest-time) :
mysqltest: At line 29: could not sync with master ('select master_pos_wait('master-bin.000001', 1814)' returned NULL)
Last_Error	Error in Write_rows event: error during transaction execution on table DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________.t1. Out of memory (Needed 3691185152 bytes)

There were several failures all in ps_row mode. 

How to repeat:
Needs solaris, patience, and
./mysql-test-run.pl rpl_packet

Suggested fix:
Consider how max_allowed_packet affect execution of row-events on slave threads.
Keep in mind that the name of db is chosen to be the max possible on purpose and
that seems to be fine with stmt mode execution.
[3 Sep 2007 18:32] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior on Solaris 10 SPARC with current BK sources.

Please indicate accurate version of Solaris you use and if error is repeatable all time.