Trying to upgrade from
Version 7.8.2
Sugar Version 6.5.24 (Build 509)
to the latest version I got to the point where I uploaded the zip file and the preflight check started.
And I get the below error.
Warning: Error while sending QUERY packet. PID=974563 in /home/compos24/public_html/SuiteCRM/dir/include/database/MysqliManager.php on line 135
Appreciate any help.
John
Don’t update to 7.9 (too buggy), wait for 7.9.1, it should be out any day now.
That is a strange error, your database seems to be failing. Is it only failing for the upgrade, or for other queries also? And are you sure that’s the error you see in the logs at the time you attempted the upgrade?
Maybe you just need to increase memory_limit or max_execution_time in your php.ini…
Here are the entries on the log during the upgrade:
Tue Jun 13 13:58:06 2017 [559731][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [320721][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [328676][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [333584][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [376743][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [377154][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [399188][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [398916][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [374703][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [392340][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [380927][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [337568][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [380737][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [334880][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [376218][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 17:05:59 2017 [383399][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:41:56 2017 [951122][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tue Jun 13 18:46:39 2017 [974563][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Tue Jun 13 18:46:39 2017 [974563][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Once again, I am thankful for any insight anyone can provide. I’ll wait until the next upgrade as well.
Regards,
John
Well you sure seem to have a problem with MySQL… maybe it’s just a matter of restarting the database server?
Or trying that query from phpMyAdmin to see if it takes too long and times out for some reason?
Or adjust timeouts in MySQL?