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

This plugin allows you to report an issue in MantisBT by sending an email to a particular mail account

Moderators: Developer, Contributor

Post Reply
simonyeh
Posts: 9
Joined: 05 Feb 2018, 07:08

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

Post 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 />
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ).
SL-Gundam
Posts: 722
Joined: 06 Jul 2011, 14:17

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

Post 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
simonyeh
Posts: 9
Joined: 05 Feb 2018, 07:08

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

Post by simonyeh »

Thanks , and I decide to use DISK to store my uploaded file . And it is no size limitation, right ?
SL-Gundam
Posts: 722
Joined: 06 Jul 2011, 14:17

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

Post 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
simonyeh
Posts: 9
Joined: 05 Feb 2018, 07:08

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

Post by simonyeh »

Dear Sir
Your information is very useful for me
Thanks for your support
Post Reply