MySQL Bugs: #30728: rpl_packet fails in ps-mode with out-of-memory in slave.err

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:	None
Category:	MySQL Server: Row Based Replication ( RBR )	Severity:	S3 (Non-critical)
Version:	5.1.22	OS:	Solaris
Assigned to:	Sveta Smirnova	CPU Architecture:	Any

Description:
xref can provide several links like
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.1-target-5.1.22&entry=tu...

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.

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.