View Issue Details

IDProjectCategoryView StatusLast Update
0022414mantisbtattachmentspublic2017-03-08 04:09
ReporterRetroLaszlo Assigned Todregad  
PrioritynormalSeveritytweakReproducibilityalways
Status closedResolutionno change required 
Product Version2.0.0 
Summary0022414: Error "2006: MySQL server has gone away" when uploading attachments
Description

Original issue title: requesting reopening of 0020547

Hi! I have a relatively (1 month) new mantis BT on a Centos 7 x64 VM.

Now I am trying to upload a file as attachment the first time and I am getting:


APPLICATION ERROR 0000401
Sikertelen adatbázis-lekérdezés. Az adatbázis hibaüzenete: 2006: MySQL server has gone away a következő lekérdezéshez: INSERT INTO mantis_bug_file_table
( bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, user_id, content )
VALUES
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Kérjük, használja a böngészője "Vissza" gombját az előző oldalhoz való visszatéréshez. Ott kijavíthatja az imént felismert hibákat, vagy más műveletet választhat. A menüből szintén választhat egy pontot, ha közvetlenül az adott funkcióhoz szeretne jutni.


Db is MariaDB as per deafult Centos 7 install.

Any guess what I could do to remedy?

TagsNo tags attached.

Activities

dregad

dregad

2017-02-23 10:32

developer   ~0055766

I fail to see the relationship or the need to reopen 0020547, that was fixed in the code, and furthermore it is not the same error message you're reporting (2006: MySQL server has gone away).

That is usually caused by some sort of timeout, so likely not a MantisBT issue. Try a google search on this error message, and see if one of the numerous answers fixes the issue for you.

RetroLaszlo

RetroLaszlo

2017-02-24 07:51

reporter   ~0055773

If you take a look at the query the MantisBT is sending the MariaDB server, the problem is with the ?-s.

The same query error as with the previous 0020547 bug. The very same error as with the ms sql bug https://www.mantisbt.org/forums/viewtopic.php?f=2&t=23590

So I am guessing that there is a setting I am not aware of, or the bug that got fixed in this issue, somehow reappeared.

RetroLaszlo

RetroLaszlo

2017-02-24 07:52

reporter   ~0055774

The database reacts to every other function of mantis immediately, so it is not a server issue I guess.

dregad

dregad

2017-02-24 09:09

developer   ~0055775

I am not getting any errors here (although I'm on Ubuntu/MySQL, not CentOS/MariaDB). Is this consistently reproducible on your end ?

the problem is with the ?-s.

What makes you say that, and what do you think the problem is with those query parameters ?

RetroLaszlo

RetroLaszlo

2017-02-24 10:38

reporter   ~0055778

Wait, I ll do an in depth test with different case ids and different files on the weekend and I ll report back monday.

RetroLaszlo

RetroLaszlo

2017-02-27 09:07

reporter   ~0055793

Ok, Sorry, entirely my fault. Not Mantis's fault!

After checking the php ini max_post_size, and upload_max_filesize

and checking the $g_max_file_size

I thought that i had everything covered.

in mariadb, /etc/my.conf.d folder i had to add a max_allowed_packet=<WHATIWANT>M;

and after restarting services, it worked likea charm.

dregad

dregad

2017-02-27 09:38

developer   ~0055794

Glad to hear you resolved your problem, thanks for letting us know.