Forum archive
TKLBAM Failure in Magento (how to fix?)
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>
main()
File "/usr/bin/tklbam-restore", line 301, in main
restore.database()
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
table.tofile(fh)
File "/usr/lib/tklbam/mysql.py", line 308, in tofile
fh.write("(%s)" % row)
IOError: [Errno 32] Broken pipe
Take a look at this thread, you need to increase the max_allowed_packet value.