Database failure after upgrade to 7.11.20

truonganle · 13 August 2021 20:13

After I upgrade to 7.11.20 from 7.10.x, I was able to use the app for a few days. Then it completely crashed. Now I cannot load anything from the database. Attempt at repair said there was a database failure. Can someone please help?

I didn’t know what to look for in the log file so i have some excerpt here.

Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Hook called: ::after_entry_point
Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Including module specific hook file for custom/modules
Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Including Ext hook file for custom/application
Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Hook called: ::after_session_start
Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Unable to find SugarController:: index
Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Hook called: ::server_round_trip
Fri Aug 13 13:10:52 2021 [794021][-none-][DEBUG] Calling MySQLi::disconnect()
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] current_language is: en_us
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCachesMash
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheZend
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheFile
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheMemory
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheMemcached
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheWincache
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheRedis
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheAPC
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Found cache backend SugarCacheMemcache
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Found language file: en_us.lang.php
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Found extended language file: en_us.lang.ext.php
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Found custom language file: en_us.lang.php
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query Execution Time:0.00018405914306641
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query:SELECT category, name, value FROM config
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query Execution Time:0.00015497207641602
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' AND deleted = 0
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query Execution Time:0.00011897087097168
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '5abaae91-b6aa-d680-e6f0-5d1f6cddffed'
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query Execution Time:0.00013494491577148
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Hook called: ::after_entry_point
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Including module specific hook file for custom/modules
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Including Ext hook file for custom/application
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Hook called: ::after_session_start
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Unable to find SugarController:: Login
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Current user is: 
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query:(SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role
				FROM acl_actions
				INNER JOIN acl_roles_users ON acl_roles_users.user_id = '' AND  acl_roles_users.deleted = 0
				LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
				WHERE acl_actions.deleted=0  )

				UNION

				(SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
				FROM acl_actions
				INNER JOIN securitygroups_users ON securitygroups_users.user_id = '' AND  securitygroups_users.deleted = 0
				INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
				LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
				WHERE acl_actions.deleted=0  )

				UNION

				(SELECT acl_actions.*, 0 as access_override, -1 as user_role
				FROM acl_actions
				WHERE acl_actions.deleted = 0 )

				ORDER BY user_role desc, category,name,access_override desc
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query Execution Time:0.040353059768677
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] current_language is: en_us
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Found language file: en_us.lang.php
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Found extended language file: en_us.lang.ext.php
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Found custom language file: en_us.lang.php
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Module:Users using file: Login
Fri Aug 13 13:10:53 2021 [794170][-none-][DEPRECATED] Array
(
)

Fri Aug 13 13:10:53 2021 [794170][-none-][WARN] CSS File Dawn/yui.css not found
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query:SELECT category, name, value FROM config WHERE category = 'captcha'
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] Query Execution Time:0.00095891952514648
Fri Aug 13 13:10:53 2021 [794170][-none-][INFO] [INFO] Captcha Settings are disabled
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Hook called: Users::after_ui_frame
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Including module specific hook file for custom/modules/Users
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Creating new instance of hook class hooks without parameters
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Creating new instance of hook class AssignGroups without parameters
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Hook called: ::after_ui_footer
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Creating new instance of hook class AssignGroups without parameters
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Hook called: ::server_round_trip
Fri Aug 13 13:10:53 2021 [794170][-none-][DEBUG] Calling MySQLi::disconnect()
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] current_language is: en_us
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCachesMash
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheZend
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheFile
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheMemory
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheMemcached
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheWincache
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheRedis
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheAPC
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Found cache backend SugarCacheMemcache
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Found language file: en_us.lang.php
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Found extended language file: en_us.lang.ext.php
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Found custom language file: en_us.lang.php
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query Execution Time:0.00018191337585449
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query:SELECT category, name, value FROM config
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query Execution Time:0.00026202201843262
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' AND deleted = 0
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query Execution Time:0.00014901161193848
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '5abaae91-b6aa-d680-e6f0-5d1f6cddffed'
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Query Execution Time:0.00015902519226074
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Hook called: ::after_entry_point
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Including module specific hook file for custom/modules
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Including Ext hook file for custom/application
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Hook called: ::after_session_start
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Unable to find SugarController:: Authenticate
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Current user is: 
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] current_language is: en_us
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Found language file: en_us.lang.php
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Found extended language file: en_us.lang.ext.php
Fri Aug 13 13:11:01 2021 [794752][-none-][INFO] Found custom language file: en_us.lang.php
Fri Aug 13 13:11:01 2021 [794752][-none-][DEBUG] Module:Users using file: Authenticate
Fri Aug 13 13:11:01 2021 [794752][-none-][DEPRECATED] Array
(
)

Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Hook called: Users::before_login
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Including module specific hook file for custom/modules/Users
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Retrieve User: SELECT users.* FROM users  WHERE user_name = 'anle' AND deleted=0
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Limit Query:SELECT users.* FROM users  WHERE user_name = 'anle' AND deleted=0 Start: 0 count: 1
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query:SELECT users.* FROM users  WHERE user_name = 'anle' AND deleted=0 LIMIT 0,1
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query Execution Time:0.0092649459838867
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY  user_name ASC 
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY  user_name ASC 
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query Execution Time:0.0001981258392334
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query:SELECT u1.first_name, u1.last_name from users  u1, users  u2 where u1.id = u2.reports_to_id AND u2.id = '8bb4fd84-e74a-aabb-bf93-5d1f709c1011' and u1.deleted=0
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query Execution Time:0.0023131370544434
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Hook called: Users::before_retrieve
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Retrieve User : SELECT users.* FROM users  WHERE users.id = '8bb4fd84-e74a-aabb-bf93-5d1f709c1011' AND users.deleted=0
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] Limit Query:SELECT users.* FROM users  WHERE users.id = '8bb4fd84-e74a-aabb-bf93-5d1f709c1011' AND users.deleted=0 Start: 0 count: 1
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query:SELECT users.* FROM users  WHERE users.id = '8bb4fd84-e74a-aabb-bf93-5d1f709c1011' AND users.deleted=0 LIMIT 0,1
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query Execution Time:0.00024509429931641
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query:SELECT u1.first_name, u1.last_name from users  u1, users  u2 where u1.id = u2.reports_to_id AND u2.id = '8bb4fd84-e74a-aabb-bf93-5d1f709c1011' and u1.deleted=0
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query Execution Time:0.00037002563476562
Fri Aug 13 13:11:02 2021 [794752][-none-][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link).
Fri Aug 13 13:11:02 2021 [794752][-none-][INFO] Query:SELECT 
                    ea.email_address,
                    ea.email_address_caps,
                    ea.invalid_email,
                    ea.opt_out,
                    ea.confirm_opt_in,
                    ea.date_created,
                    ea.date_modified,
                    ear.id,
                    ear.email_address_id,
                    ear.bean_id,
                    ear.bean_module,
                    ear.primary_address,
                    ear.reply_to_address,
                    ear.deleted
                FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
                WHERE 
                    ear.bean_module = 'Users'
                    AND ear.bean_id = '8bb4fd84-e74a-aabb-bf93-5d1f709c1011'
                    AND ear.deleted = 0
                ORDER BY ear.reply_to_address, ear.primary_address DESC

anothermouse · 13 August 2021 21:07

There was a database failure? Can you give the exact error message? I’d suggest looking at the database log file if that’s where the error purports to be?
You probably want to be looking for messages in the suiteCRM log that say ‘FATAL’ or ‘ERROR’ or something more severe.

What database are you using?

What operating system?

In order to enable us to help you better, can I recommend having a look through:
https://www.chiark.greenend.org.uk/~sgtatham/bugs.html

Make it easier for us to help, by giving us more information which is accurate and can be used to help diagnose the problem.

truonganle · 16 August 2021 14:36

Hi thank you for the explanation.

This is the error message i got after trying to Repair, or after complete upgrade (confirm layout - see 2nd screenshot)
[https://i.ibb.co/QYdbtGH/Screen-Shot-2021-08-16-at-9-33-59-AM.png)
[https://i.ibb.co/Dth5Npz/Screen-Shot-2021-08-16-at-9-34-24-AM.png)

My server info:
https://i.ibb.co/zXq7kJs/Server-info.png

anothermouse · 16 August 2021 17:03

Awesome - That’s helpful. It helps us to zero in on the problem.

In your case, I believe that the problem is that you’ve entered in the incorrect database credentials, or that there is a connectivity/firewall problem if your database is on a different system.

Therefore:

Can you log into your database directly from the command line using the correct password:

mysql -u dbuser -p

This will then prompt you for the password.

Is the database running? You might have a slightly different setup depending on exact configuration/operating system:

systemctl status mysqld

Could be mariadb or slightly different name. Basically check that the DB is running correctly.