Hi, just for the record, I solved my issue. The problems was a single letter:
In the database configuration I switched the database driver from "mysql" (old installation) to "mysqli" because everywhere you can read, that the later should be used in new setups. However, it seems that mysqli does not use libmysqlclient for which I adjusted the configuration, but it uses mysqlnd - a (new) php extension. So my adjusted setting does not take effect at all, and the setting I queried in the session seems to be the server side variable, not the client side one. Regards, mhei Am 06.09.2016 um 11:46 schrieb Michael Heimpold: > 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 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
