Database failure

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi!
Got a problem with database. Everywhere in crm got this message “Database failure. Please refer to suitecrm.log for details.”
Even after backing up database, problem still occurs.

Quick Repair and Rebuild:

Clearing Vardefs from cache...done
Clearing language files from cache...done
Clearing Template files from cache...done
Clearing JS files from cache...done
Clearing Vardefs from cache...done
Clearing JS Language files from cache...done
Clearing language files from cache...done
Clearing SuiteCRM Dashlet files from cache...done
Clearing SuiteCRM Feed Cache...done
Clearing Smarty templates from cache...done
Clearing Theme Cache...done
Clearing XML files from cache...done
Clearing Unified Search Cache...done
Clearing External API Cache File...done
Rebuilding Extensions...
Rebuilding Include...
Rebuilding Language...en_us
Rebuilding ActionViewMap...
Rebuilding ActionFileMap...
Rebuilding ActionReMap...
Rebuilding Administration...
Rebuilding EntryPointRegistry...
Rebuilding Extensions...
Rebuilding FileAccessControlMap...
Rebuilding Layoutdefs...
Rebuilding GlobalLinks...
Rebuilding LogicHooks...
Rebuilding Menus...
Rebuilding Include...
Rebuilding ScheduledTasks...
Rebuilding UserPage...
Rebuilding Utils...
Rebuilding Vardefs...
Rebuilding JSGroupings...
Rebuilding Actions...
Rebuilding DC Actions...
Rebuilding RelationshipsDatabase failure. Please refer to suitecrm.log for details.

Suitecrm.log:

Mon Oct 14 15:48:00 2019 [12711][1][FATAL] Mysqli_query failed.
Mon Oct 14 15:48:00 2019 [12711][1][FATAL] Error inserting into table: job_queue: Query Failed: INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
					VALUES ('1','6a056df4-cd26-87b2-a584-5da47c68bcd5','Process Workflow Tasks',0,'2019-10-14 13:48:00','2019-10-14 13:48:00','584e3118-781e-a87b-4054-5d87a84070ea','2019-10-14 13:48:00','queued','queued','function::processAOW_Workflow',0,0,''): MySQL error 1142: INSERT command denied to user 'db100043145'@'193.218.152.105' for table 'job_queue'
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Mysqli_query failed.
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Error updating table: email_addresses: Query Failed: UPDATE email_addresses
					SET `email_address`='miloscwobrazie@gmail.com',`email_address_caps`='MILOSCWOBRAZIE@GMAIL.COM',`invalid_email`=0,`opt_out`=0,`confirm_opt_in`='confirmed-opt-in',`confirm_opt_in_date`=NULL,`confirm_opt_in_sent_date`=NULL,`confirm_opt_in_fail_date`=NULL,`confirm_opt_in_token`=NULL,`date_created`='2019-09-20 15:28:00',`date_modified`='2019-10-14 13:48:07'
					 WHERE  email_addresses.id = '419fa91b-6312-5ccc-9f49-5d84f0104ac1' AND deleted=0: MySQL error 1142: UPDATE command denied to user 'db100043145'@'193.218.152.105' for table 'email_addresses'
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Exception handling in /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php:400
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] backtrace:
#0 /www/crm.toto-foto.pl/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /www/crm.toto-foto.pl/include/database/DBManager.php(328): DBManager->registerError('Error updating ...', 'Error updating ...', true)
#2 /www/crm.toto-foto.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error updating ...', true)
#3 /www/crm.toto-foto.pl/include/database/DBManager.php(600): MysqliManager->query('UPDATE email_ad...', true, 'Error updating ...')
#4 /www/crm.toto-foto.pl/data/SugarBean.php(2409): DBManager->update(Object(EmailAddress))
#5 /www/crm.toto-foto.pl/include/SugarEmailAddress/SugarEmailAddress.php(2032): SugarBean->save()
#6 /www/crm.toto-foto.pl/include/SugarObjects/templates/basic/Basic.php(106): SugarEmailAddress->setConfirmedOptInState('confirmed-opt-i...')
#7 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(644): Basic->getEmailAddressFromEmailField('email1')
#8 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(531): EmailUI->getEmailAddressConfirmOptInTick(Object(Lead), 'email1')
#9 /www/crm.toto-foto.pl/modules/Users/User.php(1909): EmailUI->populateComposeViewFields(Object(Lead))
#10 /www/crm.toto-foto.pl/include/SugarObjects/templates/person/Person.php(261): User->getEmailLink('email1', Object(Lead), '', '', 'ListView')
#11 /www/crm.toto-foto.pl/modules/Leads/Lead.php(317): Person->get_list_view_data()
#12 /www/crm.toto-foto.pl/include/ListView/ListViewData.php(456): Lead->get_list_view_data(Array)
#13 /www/crm.toto-foto.pl/include/ListView/ListViewDisplay.php(183): ListViewData->getListViewData(Object(Lead), '(leads.assigned...', 0, '5', Array, Array, 'id', true, NULL)
#14 /www/crm.toto-foto.pl/include/Dashlets/DashletGeneric.php(488): ListViewDisplay->setup(Object(Lead), 'include/Dashlet...', '(leads.assigned...', Array, 0, '5', Array, 'id', NULL)
#15 /www/crm.toto-foto.pl/modules/Home/index.php(244): DashletGeneric->process(Array)
#16 /www/crm.toto-foto.pl/modules/Home/views/view.list.php(54): include('/www/crm.toto-f...')
#17 /www/crm.toto-foto.pl/include/MVC/View/SugarView.php(226): HomeViewList->display()
#18 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#19 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#20 /www/crm.toto-foto.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#21 /www/crm.toto-foto.pl/index.php(52): SugarApplication->execute()
#22 {main}
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Mysqli_query failed.
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Error updating table: email_addresses: Query Failed: UPDATE email_addresses
					SET `email_address`='miloscwobrazie@gmail.com',`email_address_caps`='MILOSCWOBRAZIE@GMAIL.COM',`invalid_email`=0,`opt_out`=0,`confirm_opt_in`='confirmed-opt-in',`confirm_opt_in_date`=NULL,`confirm_opt_in_sent_date`=NULL,`confirm_opt_in_fail_date`=NULL,`confirm_opt_in_token`=NULL,`date_created`='2019-09-20 15:28:00',`date_modified`='2019-10-14 13:48:10'
					 WHERE  email_addresses.id = '419fa91b-6312-5ccc-9f49-5d84f0104ac1' AND deleted=0: MySQL error 1142: UPDATE command denied to user 'db100043145'@'193.218.152.105' for table 'email_addresses'
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Exception handling in /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php:400
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] backtrace:
#0 /www/crm.toto-foto.pl/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /www/crm.toto-foto.pl/include/database/DBManager.php(328): DBManager->registerError('Error updating ...', 'Error updating ...', true)
#2 /www/crm.toto-foto.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error updating ...', true)
#3 /www/crm.toto-foto.pl/include/database/DBManager.php(600): MysqliManager->query('UPDATE email_ad...', true, 'Error updating ...')
#4 /www/crm.toto-foto.pl/data/SugarBean.php(2409): DBManager->update(Object(EmailAddress))
#5 /www/crm.toto-foto.pl/include/SugarEmailAddress/SugarEmailAddress.php(2032): SugarBean->save()
#6 /www/crm.toto-foto.pl/include/SugarObjects/templates/basic/Basic.php(106): SugarEmailAddress->setConfirmedOptInState('confirmed-opt-i...')
#7 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(644): Basic->getEmailAddressFromEmailField('email1')
#8 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(531): EmailUI->getEmailAddressConfirmOptInTick(Object(Lead), 'email1')
#9 /www/crm.toto-foto.pl/modules/Users/User.php(1909): EmailUI->populateComposeViewFields(Object(Lead))
#10 /www/crm.toto-foto.pl/include/SugarObjects/templates/person/Person.php(261): User->getEmailLink('email1', Object(Lead), '', '', 'ListView')
#11 /www/crm.toto-foto.pl/modules/Leads/Lead.php(317): Person->get_list_view_data()
#12 /www/crm.toto-foto.pl/include/ListView/ListViewData.php(456): Lead->get_list_view_data(Array)
#13 /www/crm.toto-foto.pl/include/ListView/ListViewDisplay.php(183): ListViewData->getListViewData(Object(Lead), '(leads.assigned...', 0, '5', Array, Array, 'id', true, NULL)
#14 /www/crm.toto-foto.pl/include/Dashlets/DashletGeneric.php(488): ListViewDisplay->setup(Object(Lead), 'include/Dashlet...', '(leads.assigned...', Array, 0, '5', Array, 'id', NULL)
#15 /www/crm.toto-foto.pl/modules/Home/index.php(244): DashletGeneric->process(Array)
#16 /www/crm.toto-foto.pl/modules/Home/views/view.list.php(54): include('/www/crm.toto-f...')
#17 /www/crm.toto-foto.pl/include/MVC/View/SugarView.php(226): HomeViewList->display()
#18 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#19 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#20 /www/crm.toto-foto.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#21 /www/crm.toto-foto.pl/index.php(52): SugarApplication->execute()
#22 {main}
2

In config.php, you have the DB credentials you specified when you installed SuiteCRM, in the “dbconfig” key.

Make sure that the user you have specified there has full rights in your database.

3

Config.php and data under dbconfig is all good. I found out that I run out of data on db. Is it normal for suitecrm to have database that large? atm it’s 1544mb and I got 3 contacts and 3 accounts. 3 PDF templates.

4

Run the query at the top of this post to see the largest tables

https://pgorod.github.io/Database-tables-size/

Is this shared hosting? Is there any limit on the size of the database, other than disk space?

5

Hi!
Yes, that a shared hosting with a limit of a database to 2048mb. This is what I got after running a query (attachment)

6

Search these forums for people with overgrown job_queue and folders_rel tables.

job_queue is easy to clean up, folders_rel depends on how much email you have in connected mailboxes…

Maybe you need a larger database, that seems very small…