tubesync icon indicating copy to clipboard operation
tubesync copied to clipboard

Published 20 hours ago • verified publisher icon meeb

What's the 'max_allowed_packet' value for TubeSync?

Open SmartPhoneLover opened this issue 2 years ago • 2 comments

I'm facing a lot of errors in the MYSQL connection (TubeSync terminal log) when TubeSync tries to write to the database, showing the Got a packet bigger than 'max_allowed_packet' bytes error. My database (MariaDB) is configured to accept up to 16MB currently.

Log: https://pastebin.com/Z7Rm5mbN

SmartPhoneLover avatar Jul 09 '22 19:07 SmartPhoneLover

Seems that setting it to a bigger value (100MB in my case) temporarily, fixes it.

SmartPhoneLover avatar Jul 09 '22 19:07 SmartPhoneLover

max_allowed_packet is a MySQL server-side only config option so it's not something I can adjust from TubeSync's database connection parameters. What operation were you attempting to perform where you received the exceeding max_allowed_packet related error? The only thing I can do from the application side is reduce the complexity or data over the wire of a query, if it's possible. However, increasing max_allowed_packet should be a permanent fix.

meeb avatar Jul 10 '22 02:07 meeb