Question Server Error 500 Plesk\Exception\Database

[Carlos Nog]

Server operating system version

Ubuntu 22.05

Plesk version and microupdate number

18.0.56

help me please. I sent the capture there.

 

[Carlos Nog]

This gave me the result using ssh root: # grep mariadb /var/log/syslog

Dec 15 00:08:03 pensive-kilby mariadbd[5328]: 2023-12-15 0:08:03 12279 [Warning] Aborted connection 12279 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Dec 15 00:09:01 pensive-kilby mariadbd[5328]: 2023-12-15 0:09:01 8992 [Warning] Aborted connection 8992 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
Dec 15 00:09:01 pensive-kilby mariadbd[5328]: 2023-12-15 0:09:01 8993 [Warning] Aborted connection 8993 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
Dec 15 14:44:38 pensive-kilby mariadbd[5328]: 2023-12-15 14:44:38 14683 [Warning] Aborted connection 14683 to db: 'psa' user: 'admin' host: 'localhost' (Got an error writing communication packets)
Dec 15 14:52:26 pensive-kilby kernel: [167564.196722] [ 5328] 113 5328 386102 90094 974848 0 0 mariadbd
Dec 15 14:52:26 pensive-kilby kernel: [167564.196902] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=init.scope,mems_allowed=0,global_oom,task_memcg=/system.slice/mariadb.service,task=mariadbd,pid=5328,uid=113
Dec 15 14:52:26 pensive-kilby kernel: [167564.196956] Out of memory: Killed process 5328 (mariadbd) total-vm:1544408kB, anon-rss:360376kB, file-rss:0kB, shmem-rss:0kB, UID:113 pgtables:952kB oom_score_adj:0
Dec 15 14:52:28 pensive-kilby systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
Dec 15 14:52:28 pensive-kilby systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
Dec 15 14:52:28 pensive-kilby systemd[1]: mariadb.service: Failed with result 'oom-kill'.
Dec 15 14:52:28 pensive-kilby systemd[1]: mariadb.service: Consumed 3min 38.982s CPU time.

 

[Carlos Nog]

This gave me the result using ssh root: # free -h

total used free shared buff/cache available
Mem: 1,8Gi 665Mi 419Mi 257Mi 792Mi 788Mi
Swap: 0B 0B 0B

 

[WebHostingAce]

Please try to add under [mysqld] in my.cnf,

innodb_buffer_pool_size = 256M

and restart the MariaDB.

 

[Peter Debik]

OOM = out of memory
Your server and MariaDB on it requires more RAM.

 

[Carlos Nog]

OOM = out of memory
Your server and MariaDB on it requires more RAM.

Could I create swap memory?

It is advisable?

I have: 2 vcores 2Gb RAM and 80GB SSD.

 

[Carlos Nog]

OOM = out of memory
Your server and MariaDB on it requires more RAM.

I have 5 wordpress sites. with little traffic.

If it is advisable, then, could you give me a tutorial link to create swap memory. please.

 

[WebHostingAce]

How to Add Swap Space on Ubuntu | DigitalOcean

Add swap space on Ubuntu 20.04 and 22.04 with a swapfile. Covers fallocate, dd, fstab, swappiness, vfs_cache_pressure, and troubleshooting.

www.digitalocean.com

 

[Peter Debik]

It is advisable?

No, it is not recommended. Swap should only be used in the exceptionally rare case of memory usage spikes. Swap creates a very high number of disk i/o transactions, thus it will slow down your server considerably and noticeably.

 

[Carlos Nog]

How to Add Swap Space on Ubuntu | DigitalOcean

Add swap space on Ubuntu 20.04 and 22.04 with a swapfile. Covers fallocate, dd, fstab, swappiness, vfs_cache_pressure, and troubleshooting.

www.digitalocean.com

thanks you

 

[Carlos Nog]

No, it is not recommended. Swap should only be used in the exceptionally rare case of memory usage spikes. Swap creates a very high number of disk i/o transactions, thus it will slow down your server considerably and noticeably.

thanks you