Hello, We have been running version 7.9.7 since 2017, on Ubuntu 16.04 server as a VirtualBox VM. Up until last week it was rock-solid. Now it crashes every day after a few hours of seemingly running just fine. Any ideas? I did āRepairā in Admin, but it did nothing to stop the crashes.
We never update/upgrade the VM. We do update the host machine, currently running Ubuntu server 24.04 + VirtualBox 7.0.
Did you write any custom code and make any changes to the configuration?
I think it is some setting on your updated server. Check why it is out refreshing or restarting services related to your SuiteCRM.
Check your web server log files for errors!
Hello Greg,
What does a ācrashā look like?
Hi rsp,
Thank you for replying! Iāll take a look at the log files. I set the reporting level to ādebugā with all other logging options checked. Hopefully this will produce some hints.
Iāll keep looking into VirtualBox 7.x settings as well.
Greg
Hi BastianHammar,
Thank you for replying!
It is more of a sudden slow-down & freeze. So far I have not been able to observe it directly as I donāt use CRM myself, and normally I donāt even have the server displaying on my KVM station. The sales folks usually let me know, mostly after the fact.
I could not see anything in the log file. For now I have set the logging from āFatalā to āDebugā+all other options. Iām leaving the process monitor running as well, maybe the frozen screen will show the last process/cpu/memory action.
Iāll post any findings.
Thanks again,
Greg
Sounds like a plan! Wish you all the best 
That sounds like youāve perhaps gone over a freehold in the database in terms of volumes on certain tables based on what your server can handle and then maybe itās getting stuck doing certain queries that maybe build up over time until it crashes. So maybe good to look at the database also
I second what @Daman said.
Run the first query in this post and see if anything catches your eye
Please can you check Apache Web server logs. Please check php logs as well. It could be php-cgi that might be crashing.
By the way, I really hope your CRM is very tightly sealed in your LAN, and isnāt exposed to the Internet. Because if it is, your set up is very insecure with such outdated software.
Hi pgr,
I really appreciate everyone trying to help!
Here is the result of the query. There is one table āNotesā that is quite large. Is this the āovergrown tableā situation? I also noticed that our daily mysqldump backups grow by about 1 MB every day. We only ever create a Contact or two, put some text into Notes, never any graphics, no more then a dozen entries a day.
On the topic of safety, our CRM instance is running in VM, on a LAN server, behind a firewall to ISP, behind ISPās firewall, and ONLY used by staff via LAN PCs, all when in the shop. I never thought about any extra security - do you think this is enough?
oh, how do I attach the screen grab of the query result? here is text cut/paste
Thanks,
Greg
CONCAT(table_schema, '.', table_name) rows DATA idx total_size idxfrac
IGoV_CRM.notes0.062M 0.307G 0.040G 0.347G 0.132
IGoV_CRM.job_queue 0.063M 0.039G 0.036G 0.075G 0.938
IGoV_CRM.aod_indexevent 0.103M 0.038G 0.022G 0.059G 0.572
IGoV_CRM.contacts 0.025M 0.009G 0.016G 0.025G 1.686
IGoV_CRM.contacts_audit 0.027M 0.006G 0.004G 0.011G 0.695
IGoV_CRM.email_addr_bean_rel 0.011M 0.002G 0.005G 0.007G 2.000
IGoV_CRM.tracker 0.006M 0.001G 0.003G 0.004G 2.000
IGoV_CRM.email_addresses 0.011M 0.001G 0.003G 0.004G 2.000
IGoV_CRM.contacts_cstm 0.025M 0.003G 0.000G 0.003G 0.000
mysql.help_topic 0.001M 0.001G 0.000G 0.002G 0.041
Hi pgr,
I also found in Apache error log the following errors, repeating a great many times . I am not quite sure what it all means.
[Thu Mar 06 07:35:42.297465 2025] [:error] [pid 28754] [client 192.168.0.31:45914] PHP Fatal error: Uncaught Exception: Could not connect to the database. Please refer to suitecrm.log for details. in /var/www/html/InuitGalleryOfVancouverCRM/include/utils.php:1758\nStack trace:\n#0 /var/www/html/InuitGalleryOfVancouverCRM/include/database/MysqliManager.php(290): sugar_die(āCould not conneā¦ā)\n#1 /var/www/html/InuitGalleryOfVancouverCRM/include/database/DBManagerFactory.php(147): MysqliManager->connect(Array, true)\n#2 /var/www/html/InuitGalleryOfVancouverCRM/include/entryPoint.php(179): DBManagerFactory::getInstance()\n#3 /var/www/html/InuitGalleryOfVancouverCRM/index.php(47): require_once(ā/var/www/html/Iā¦ā)\n#4 {main}\n thrown in /var/www/html/InuitGalleryOfVancouverCRM/include/utils.php on line 1758, referer: http://192.168.0.65/index.php?module=Users&action=Login&loginErrorMessage=LBL_SESSION_EXPIRED
[Thu Mar 06 08:13:43.567522 2025] [:error] [pid 28754] [client 192.168.0.31:58922] PHP Fatal error: Uncaught Exception: Database failure. Please refer to suitecrm.log for details. in /var/www/html/InuitGalleryOfVancouverCRM/include/utils.php:1758\nStack trace:\n#0 /var/www/html/InuitGalleryOfVancouverCRM/include/database/DBManager.php(353): sugar_die(āDatabase failurā¦ā)\n#1 /var/www/html/InuitGalleryOfVancouverCRM/include/database/DBManager.php(328): DBManager->registerError(ā Query Failed: ā¦ā, ā Query Failed: ā¦ā, true)\n#2 /var/www/html/InuitGalleryOfVancouverCRM/include/database/MysqliManager.php(160): DBManager->checkError(ā Query Failed: ā¦', true)\n#3 /var/www/html/InuitGalleryOfVancouverCRM/include/OutboundEmail/OutboundEmail.php(509): MysqliManager->query(āINSERT INTO outā¦ā, true)\n#4 /var/www/html/InuitGalleryOfVancouverCRM/include/OutboundEmail/OutboundEmail.php(410): OutboundEmail->save()\n#5 /var/www/html/InuitGalleryOfVancouverCRM/modules/Administration/Administration.php(135): OutboundEmail->getSystemMailerSettings()\n#6 /var/www/html/InuitGalleryOfVancouverCRM/include/entryPoint.php(192): Adm in /var/www/html/InuitGalleryOfVancouverCRM/include/utils.php on line 1758, referer: http://192.168.0.65/index.php?module=Users&action=Login&loginErrorMessage=LBL_SESSION_EXPIRED
Please check your web server configuration and restart it if needed.
Hi rsp,
Thanks again for the suggestion.
I looked at phpMyAdmin to see what sort of configurations I might tweak around. I could not see anything that I could set/reset/change. But, for some reason the CRM is running now for a couple of days at a time, and is accessible over LAN, but the VM server (Ubuntu 16.04) interface freezes suddenly and the only way to get it back is to shutdown/reboot in VirtualBox. Any ideas what I should be looking for next? I also googled LBL_SESSION_EXPIRED errors, but could not figure out what is causing them.
Thank you!
Greg
Your system doesnāt look healthyā¦ I am sorry that those errors donāt show complete messages (they are abbreviated with ...), I canāt make much from that.
Is there anything in suitecrm.log at the time of those FATALs?
Hi pgr,
I am at my wits end here. I canāt find anything that would cause the VM interface to freeze while still letting access to DB via LAN.
This is off-topic, and I will gladly repost it, but maybe a quick Y/No answer is possible:
Say I build a new server, likely Ubuntu 24.04, forget VirtualBox/client server VM, install the latest 7.x version of SuiteRM. Could I just import a mysqldump of the old data/structure into it?
Thank you,
Greg
About randomly failing systems: at some point itās better if you donāt waste time figuring things out, just start making changes until something magically solves the issue. Swap RAM, disk, Ethernet card, even the cableā¦ things sometimes get corrupted or malfunction.
If you decide to go for a full server rebuild (I recommend doing it on different hardware), which I agree could be the best approach to create a general renovation, read this