Hi, I recently upgraded our internal Mantis installation from 1.2.19 to 1.3.1.
I only upgraded the Mantis system, not the hosting environment / database server etc. We use a Ubuntu 14.04 LTS server environment, with MySQL, Apache etc, nothing uncommon so far. We sometime attache larger files to the tickets, so I needed to increase $g_max_file_size to 100000000 and also adjusted max_allowed_packet in my.cnf etc. With the old mantis installation, everthings works as expected and we were happy :-) So I very surprised, that with the new installation we encounter the following error, when viewing a bug with some file attachments: Database query failed. Error received from database was #2020: Got packet bigger than 'max_allowed_packet' bytes for the query: SELECT * FROM mantis_bug_file_table WHERE id=357. I googled around, tried to increase max_allowed_packet variable further etc. and also hacked some debugging into mantis code, to prove that my modifications take effect. The follow lines are additional output (from my additions) and show, that the max_allowed_packet setting is set to 512M, before it used to be 128M and this worked with the old version. 2016-09-06 10:26 CEST MAIL_VERBOSE database_api.php:406 db_query() mhei: before db-Execute: 536870912 2016-09-06 10:26 CEST MAIL_VERBOSE database_api.php:411 db_query() Error Got packet bigger than 'max_allowed_packet' bytes 2016-09-06 10:26 CEST MAIL_VERBOSE database_api.php:413 db_query() mhei: after db-Execute So, I'm wondering why the old mantis version works for the very same ticket number, but the new version fails with this error. Again, I've nothing changes on the hosting environment other than increasing the max_allowed_packet setting for test purposes. So, I think this is a regression. Any help/hints to solve this are very appreciated... Mit freundlichen Grüßen / Kind regards Michael Heimpold -- Software Engineer I2SE GmbH Tel: +49 (0) 341 355667-00 Friedrich-Ebert-Str. 61 Fax: +49 (0) 341 355667-02 04109 Leipzig Germany Web: http://www.i2se.com/ Mail: i...@i2se.com VAT No.: DE 811528334 Amtsgericht Leipzig HRB 23784 Geschäftsführer/CEO: Carsten Ziermann *** Diese E-Mail ist allein für den bezeichneten Adressaten bestimmt. Sie kann rechtlich vertrauliche Informationen enthalten. Wenn Sie diese E-Mail irrtümlich erhalten haben, informieren Sie bitte unverzüglich den Absender per E-Mail und löschen Sie diese E-Mail von Ihrem Computer, ohne Kopien anzufertigen. Vielen Dank. *** *** This email is for the exclusive use of the addressee. It may contain legally privileged information. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. Thank you. *** ------------------------------------------------------------------------------ _______________________________________________ mantisbt-help mailing list mantisbt-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mantisbt-help
