Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Failed Upgrade

Failed Upgrade 3 months 2 weeks ago #75324

  • aeroflyte
  • aeroflyte's Avatar
  • Offline
  • Premium Member
  • Posts: 105
  • Thank you received: 2
  • Karma: 1
I'm running Version 7.10.7
Sugar Version 6.5.25 (Build 344) Windows 10 64 bit Hosted on a shared server at InMotion Hosting.



I have the version that doesn't increment the customer or account page list views and was under the understanding that an upgrade would remedy this.

I began the upgrade process and while it was doing a system check it threw this error:

Warning: Error while sending QUERY packet. PID=3803905 in /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/MysqliManager.php on line 137
Database failure. Please refer to suitecrm.log for details.

Here is the most recent log entry:

402
Fri Dec 7 21:18:21 2018 [3803905][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Fri Dec 7 21:18:21 2018 [3803905][1][FATAL] backtrace:
#0 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)
#2 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/MysqliManager.php(177): DBManager->checkError(' Query Failed: ...', true)
#3 /home/compos24/SuiteCRM1.compositeautomation.com/dir/data/SugarBean.php(5519): MysqliManager->query('SELECT id FROM ...', true)
#4 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(171): SugarBean->build_related_list('SELECT id FROM ...', Object(UpgradeHistory))
#5 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(167): UpgradeHistory->getList('SELECT id FROM ...')
#6 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/UpgradeWizard/index.php(312): UpgradeHistory->getAll()
#7 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(840): include_once('/home/compos24/...')
#8 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile('/home/compos24/...')
#9 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(207): ViewClassic->display()
#10 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(432): SugarView->process()
#11 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/SugarApplication.php(109): SugarController->execute()
#13 /home/compos24/SuiteCRM1.compositeautomation.com/dir/index.php(52): SugarApplication->execute()
#14 {main}
Fri Dec 7 21:18:58 2018 [3810058][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Fri Dec 7 21:23:47 2018 [3837232][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set

I appreciate any help anyone can provide as I am really stuck. Let me know if I can provide more information.

Thank you

John
The administrator has disabled public write access.

Failed Upgrade 3 months 2 weeks ago #75326

  • urdhvatech
  • urdhvatech's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 527
  • Thank you received: 104
  • Karma: 15
Can you check mysql_error.log for the actual reason?
Thanks & Regards,
Team Urdhva Tech
Web : www.urdhva-tech.com
Skype : urdhvatech

- Official code partner
- Official Integration partner
The administrator has disabled public write access.

Failed Upgrade 3 months 1 week ago #75547

  • aeroflyte
  • aeroflyte's Avatar
  • Offline
  • Premium Member
  • Posts: 105
  • Thank you received: 2
  • Karma: 1
Could you direct me to the mysql_error.log? I could not find it manually or in a search.

Thank you!

Upgrade wizard log:

Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - setting session variables...
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] -
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - Upgrade started. At start.php
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - finished!
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - resetting $_SESSION
Thu, 13 Dec 2018 13:27:34 -0500 [UpgradeWizard] - setting session variables...
Thu, 13 Dec 2018 13:27:34 -0500 [UpgradeWizard] - [At systemCheck.php]
Thu, 13 Dec 2018 13:27:34 -0500 [UpgradeWizard] - Starting file permission check...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Finished file permission check.
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Starting database permissions check...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot CREATE TABLE!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot INSERT INTO!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot UPDATE TABLE!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking SELECT permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot SELECT!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot DELETE FROM!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot ADD COLUMN!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot CHANGE COLUMN!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot DROP COLUMN!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot DROP TABLE!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Finished database permissions check.

Suitecrm log

Thu Dec 13 13:27:22 2018 [1133600][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES ('abcdef0123456789abcdef0123456789abcd'): MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: UPDATE temp SET id = '100000000000000000000000000000000000' WHERE id = 'abcdef0123456789abcdef0123456789abcd': MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: SELECT id FROM temp WHERE id='100000000000000000000000000000000000' LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id='100000000000000000000000000000000000': MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: DELETE FROM temp WHERE id = '100000000000000000000000000000000000': MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Exception handling in /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php:402
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] backtrace:
#0 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)
#2 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/MysqliManager.php(177): DBManager->checkError(' Query Failed: ...', true)
#3 /home/compos24/SuiteCRM1.compositeautomation.com/dir/data/SugarBean.php(5519): MysqliManager->query('SELECT id FROM ...', true)
#4 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(171): SugarBean->build_related_list('SELECT id FROM ...', Object(UpgradeHistory))
#5 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(167): UpgradeHistory->getList('SELECT id FROM ...')
#6 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/UpgradeWizard/index.php(312): UpgradeHistory->getAll()
#7 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(840): include_once('/home/compos24/...')
#8 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile('/home/compos24/...')
#9 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(207): ViewClassic->display()
#10 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(432): SugarView->process()
#11 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/SugarApplication.php(109): SugarController->execute()
#13 /home/compos24/SuiteCRM1.compositeautomation.com/dir/index.php(52): SugarApplication->execute()
#14 {main}
The administrator has disabled public write access.

Failed Upgrade 3 months 6 days ago #75648

  • aeroflyte
  • aeroflyte's Avatar
  • Offline
  • Premium Member
  • Posts: 105
  • Thank you received: 2
  • Karma: 1
Bump! Hey all I really need help with this as I can't get it upgraded and there's so much work that I did.

Please. Help!!

Thank you in advance if you can help.

John
The administrator has disabled public write access.

Failed Upgrade 3 months 6 days ago #75657

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 9342
  • Thank you received: 1409
  • Karma: 340
That "MySQL has gone away" is a serious database crash, see here for a list of possible causes:

dev.mysql.com/doc/refman/8.0/en/gone-away.html

If I were you I would skip troubleshooting this and try a MySQL upgrade, as a way to make your installation sane again.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Failed Upgrade 3 months 3 days ago #75803

  • aeroflyte
  • aeroflyte's Avatar
  • Offline
  • Premium Member
  • Posts: 105
  • Thank you received: 2
  • Karma: 1
Update.

So, I upgraded to a VPS host on InMotion because the shared environment would time out on the DB. When I started to get ready to upgrade I did a quick repair and build and got the following:

Processing database and vardef comparison...

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 20480 bytes) in /home/compos24/SuiteCRM1.compositeautomation.com/dir/cache/modules/AOS_Quotes/AOS_Quotesvardefs.php on line 3

Tried again and got:

Processing database and vardef comparison...

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 32768 bytes) in /home/compos24/SuiteCRM1.compositeautomation.com/dir/cache/modules/AOS_Quotes/AOS_Quotesvardefs.php on line 417

Log file is empty.

Appreciate any words of help and or life wisdom!

Merry Christmas!
The administrator has disabled public write access.

Failed Upgrade 3 months 3 days ago #75804

  • aeroflyte
  • aeroflyte's Avatar
  • Offline
  • Premium Member
  • Posts: 105
  • Thank you received: 2
  • Karma: 1
The upgrade seemed to work but it threw this error at the end:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 86016 bytes) in /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Relationships/Relationship.php on line 249

Again, any insight or instruction is deeply appreciated.

Best
john
The administrator has disabled public write access.

Failed Upgrade 3 months 2 days ago #75839

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 9342
  • Thank you received: 1409
  • Karma: 340
That's easy - go in php.ini and increase your memory_limit to 512 MB (or at least 256MB). While you're there, you might want to increase max_execution_time and post_max_size and max_upload_size.

Restart your web server.

Go in Admin / Daignostics, select phpinfo, and check if your changes became effective.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Failed Upgrade 3 months 2 days ago #75841

  • aeroflyte
  • aeroflyte's Avatar
  • Offline
  • Premium Member
  • Posts: 105
  • Thank you received: 2
  • Karma: 1
Thanks for your prompt reply. For some odd reason, I can't seem to locate that file in cpanel's file manager. I see a travis.php.ini.

I have php.ini files in other directories but not visible in the directory where SuiteCRM is installed.

Am I missing something?

Thanks again.

john
The administrator has disabled public write access.

Failed Upgrade 3 months 2 days ago #75846

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 9342
  • Thank you received: 1409
  • Karma: 340
Go in Admin / Diagnostics, select phpinfo, and check the php.ini directory.

It's normal for it to be outside the SuiteCRM directory, it affects your entire web server.

I don't know if you are in a shared hosting, sometimes they don't give you access to the php.ini, or they use some scheme where you place a smaller php.ini in your root folder, and they pick it up and include it. You'll have to ask them.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
Last Edit: 3 months 2 days ago by pgr.
The administrator has disabled public write access.
Time to create page: 0.140 seconds
Powered by Kunena Forum