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: Feb 05, 2018 2:08 am

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

Post by simonyeh » Mar 18, 2019 4:16 am

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: 576
Joined: Jul 06, 2011 9:17 am

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

Post by SL-Gundam » Mar 18, 2019 3:26 pm

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: Feb 05, 2018 2:08 am

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

Post by simonyeh » Mar 19, 2019 1:26 am

Thanks , and I decide to use DISK to store my uploaded file . And it is no size limitation, right ?

SL-Gundam
Posts: 576
Joined: Jul 06, 2011 9:17 am

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

Post by SL-Gundam » Mar 19, 2019 12:32 pm

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: Feb 05, 2018 2:08 am

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

Post by simonyeh » Mar 19, 2019 9:22 pm

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

Post Reply