You are here
L. Arnold - Tue, 2011/07/05 - 15:26
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
Forum:

Take a look at this thread...
Take a look at this thread, you need to increase the max_allowed_packet value.
Got it! thank you.
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