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