TurnKey Linux Virtual Appliance Library

TKLBAM Failure in Magento (how to fix?)

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>
    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


Alon Swartz's picture

Take a look at this thread...

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

L. Arnold's picture

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!

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)