Two wordpress site error establishing a database connection multisite vertual min

strong text****strong text| SYSTEM INFORMATION||
|------------------------------|-------------------------------|
| OS type and version | Ubuntu 20.4 |
| Webmin version | Latest |
| Virtualmin version | Latest
Hello i am using vertualmin on digital ocean 6$ 1 Gb 25Gb droppet

I created 2 wordpress site on vertualmin both sites are working fine but suddenly getting error establishing a database connection

After restart droplet works fine and after some time this error i am getting please help me what should i do
and sorry for my bad english

Check log files for the errors, and post, very hard to know what wrong with little info.
I’ve run WP sites with no issues.

Steve

1 Like

To me it smells like something which would be caused by the OOM reaper. From the server specs you have mentioned, it seems you are running out of memory at some random point in time and the MySQL process is being killed. On a Virtualmin system, 1 GB of RAM should be enough. On low memory systems I disable antivirus. Fail2ban is also notorious for triggering OOM.

Have you seen Virtualmin on Low Memory Systems – Virtualmin ?

But @stefan1959 is correct. The logs will tell you exactly what is wrong.

1 Like

Sir i checked logs of one of my website in vertualmin

[Wed Mar 09 15:48:56.498628 2022] [fcgid:warn] [pid 912:tid 140467844937472] [client 27.62.232.255:41277] mod_fcgid: stderr: WordPress database error Unknown column ‘autoload’ in ‘field list’ for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (’_transient_doing_cron’, ‘1646840935.3423678874969482421875’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, _wp_cron, spawn_cron, set_transient, add_option, referer: https://wp-admin/admin.php?page=wp-dbmanager/database-optimize.php

[Wed Mar 09 15:50:14.901734 2022] [fcgid:warn] [pid 913:tid 140467735832320] [client 27.62.232.255:34140] mod_fcgid: stderr: WordPress database error Unknown column ‘autoload’ in ‘field list’ for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (’_transient_doing_cron’, ‘1646841014.7707140445709228515625’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, _wp_cron, spawn_cron, set_transient, add_option, referer:/wp-admin/edit.php

[Wed Mar 09 15:50:16.088942 2022] [fcgid:warn] [pid 912:tid 140467777795840] [client 27.62.232.255:40230] mod_fcgid: stderr: WordPress database error Unknown column ‘autoload’ in ‘field list’ for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (’_transient_doing_cron’, ‘1646841015.9687240123748779296875’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, _wp_cron, spawn_cron, set_transient, add_option, referer:/wp-admin/upload.php

[Wed Mar 09 16:53:56.539317 2022] [fcgid:warn] [pid 912:tid 140467811366656] (70007)The timeout specified has expired: [client 117.201.202.46:59574] mod_fcgid: can’t get data from http client

[Thu Mar 10 02:23:20.143626 2022] [core:error] [pid 47399:tid 140467761010432] [client 161.35.86.181:39298] AH00126: Invalid URI in request GET /cgi-bin/…/…/…/…/…/…/…/…/…/etc/hosts HTTP/1.1

[Thu Mar 10 02:28:58.486916 2022] [fcgid:warn] [pid 47399:tid 140467844937472] (70007)The timeout specified has expired: [client 49.143.32.6:1191] mod_fcgid: can’t get data from http client

But i resized my digital ocean plan 6$ to 10$ 2Gb,50Gb now my websites working fine
And you said 1 Gb is enough for these 2 websites both has 0 traffic new website so i want to pay 6$ only because of my budget is that possible please check error logs and help me

Oh sorry i checked websites right now and they showing error again on 10$ droplet

The best tip I can give you is to disable antivirus. Please confirm that this has been done and you have read the low memory system page.

1 Like

Thanks for helping sir
Recently I increased size of swap now both of my website are working fine default swap size was 279 MB i mkswap 2 Gb both site working fine

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.