Page 1 of 1

APPLICATION ERROR #401: Database query failed. Error received from database was #1153

Posted: 18 Mar 2019, 09:16
by simonyeh
Hi Sirs

The error message from Email Reporting log as following , Could any one give me any guidance to resolve this problem?

APPLICATION ERROR #401: Database query failed. Error received from database was #1153: Got a packet bigger than 'max_allowed_packet' bytes for the query: INSERT INTO mantis_bug_file_table<br />
( bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, user_id, content )<br />
VALUES<br />
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ).

Re: APPLICATION ERROR #401: Database query failed. Error received from database was #1153

Posted: 18 Mar 2019, 20:26
by SL-Gundam
The attachments MantisBT is trying to add to an issue are bigger then your database configuration is able to accept
https://www.mantisbt.org/wiki/doku.php/ ... hment_size

Either lower MantisBT $g_max_file_size or increase your databases max_allowed_packet variable
You can also opt to store attachments on disk instead of in the database

Re: APPLICATION ERROR #401: Database query failed. Error received from database was #1153

Posted: 19 Mar 2019, 06:26
by simonyeh
Thanks , and I decide to use DISK to store my uploaded file . And it is no size limitation, right ?

Re: APPLICATION ERROR #401: Database query failed. Error received from database was #1153

Posted: 19 Mar 2019, 17:32
by SL-Gundam
DISK has not a real size limitation as long as the partition can support it and you have enough free space
https://en.wikipedia.org/wiki/Compariso ... ems#Limits

Still, processing an email also requires memory. Around 6 times the size of the email
So a 10 MB email would require 60 MB of memory

So apply realistic limits for these values so that you don't hog your server resources
https://www.mantisbt.org/wiki/doku.php/ ... hment_size

Re: APPLICATION ERROR #401: Database query failed. Error received from database was #1153

Posted: 20 Mar 2019, 02:22
by simonyeh
Dear Sir
Your information is very useful for me
Thanks for your support