L. Arnold's picture

I have been trying to get a Magento Restore and have gotten this error going back at least 7 sessions.
How do I get in and "remove or flag" the 'max allowed packet'?  The Database Restore Fails on this event.
thank you for any and all help.
L. Arnold

table: magento/catalog_product_index_eav_decimal
table: magento/log_visitor_info
table: magento/catalog_product_flat_1
ERROR 1153 (08S01) at line 29734: Got a packet bigger than 'max_allowed_packet' bytes
Traceback (most recent call last):
  File "/usr/bin/tklbam-restore", line 313, in <module>
  File "/usr/bin/tklbam-restore", line 301, in main
  File "/usr/lib/tklbam/restore.py", line 106, in database
    limits=self.limits.db, callback=mysql.cb_print())
  File "/usr/lib/tklbam/mysql.py", line 402, in restore
    fs2mysql(mysql(), myfs, **kws)
  File "/usr/lib/tklbam/mysql.py", line 365, in fs2mysql
    MyFS_Reader(myfs, limits, skip_extended_insert, add_drop_database).tofile(fh, callback)
  File "/usr/lib/tklbam/mysql.py", line 359, in tofile
    database.tofile(fh, callback)
  File "/usr/lib/tklbam/mysql.py", line 252, in tofile
  File "/usr/lib/tklbam/mysql.py", line 308, in tofile
    fh.write("(%s)" % row)
IOError: [Errno 32] Broken pipe

Alon Swartz's picture

Take a look at this thread, you need to increase the max_allowed_packet value.

L. Arnold's picture

I posted Jeremy's code and it got the Restore to take.  The trick also with Magento is to go into

/var/www/magento/var/cache and /var/session  and

rm -R *

to clear the temp files. 

Wonderful system.  Thank you!

Add new comment