Koozali.org: home of the SME Server

Contribs.org Forums => Koozali SME Server 10.x => Topic started by: HACKERSOFT2011 on June 25, 2021, 03:50:07 AM

Title: Service Unavailable
Post by: HACKERSOFT2011 on June 25, 2021, 03:50:07 AM

Hi! I'm receiving this message from time to time when I access the web apps.

Code: [Select]

Service Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later
Here's the MariaDB Logs:

Code: [Select]

210624 14:12:08 [ERROR] Error in accept: Too many open files
210624 14:16:24 [ERROR] Error in accept: Too many open files
210624 14:20:40 [ERROR] Error in accept: Too many open files
210624 14:24:56 [ERROR] Error in accept: Too many open files
210624 14:29:12 [ERROR] Error in accept: Too many open files
210624 14:33:28 [ERROR] Error in accept: Too many open files
210624 14:37:44 [ERROR] Error in accept: Too many open files
210624 14:42:00 [ERROR] Error in accept: Too many open files
210624 14:46:16 [ERROR] Error in accept: Too many open files
210624 14:50:32 [ERROR] Error in accept: Too many open files
210624 14:54:48 [ERROR] Error in accept: Too many open files
210624 14:59:04 [ERROR] Error in accept: Too many open files
210624 15:03:20 [ERROR] Error in accept: Too many open files
210624 15:07:36 [ERROR] Error in accept: Too many open files
210624 15:11:52 [ERROR] Error in accept: Too many open files
210624 15:16:08 [ERROR] Error in accept: Too many open files
210624 15:20:24 [ERROR] Error in accept: Too many open files
210624 15:24:40 [ERROR] Error in accept: Too many open files
210624 15:28:56 [ERROR] Error in accept: Too many open files
210624 15:33:12 [ERROR] Error in accept: Too many open files
210624 15:37:28 [ERROR] Error in accept: Too many open files
210624 15:41:44 [ERROR] Error in accept: Too many open files
210624 15:46:00 [ERROR] Error in accept: Too many open files
210624 15:50:16 [ERROR] Error in accept: Too many open files
210624 15:54:32 [ERROR] Error in accept: Too many open files
210624 15:58:48 [ERROR] Error in accept: Too many open files
210624 16:03:04 [ERROR] Error in accept: Too many open files
210624 16:07:20 [ERROR] Error in accept: Too many open files
210624 16:11:36 [ERROR] Error in accept: Too many open files
210624 16:15:52 [ERROR] Error in accept: Too many open files
210624 16:20:08 [ERROR] Error in accept: Too many open files
210624 16:24:24 [ERROR] Error in accept: Too many open files
210624 16:28:40 [ERROR] Error in accept: Too many open files
210624 16:32:56 [ERROR] Error in accept: Too many open files
210624 16:37:12 [ERROR] Error in accept: Too many open files
210624 16:41:28 [ERROR] Error in accept: Too many open files
210624 16:45:44 [ERROR] Error in accept: Too many open files
210624 16:50:00 [ERROR] Error in accept: Too many open files
210624 16:54:16 [ERROR] Error in accept: Too many open files
210624 16:58:32 [ERROR] Error in accept: Too many open files
210625  8:42:08 InnoDB: The InnoDB memory heap is disabled
210625  8:42:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
210625  8:42:08 InnoDB: Compressed tables use zlib 1.2.7
210625  8:42:08 InnoDB: Using Linux native AIO
210625  8:42:08 InnoDB: Initializing buffer pool, size = 128.0M
210625  8:42:08 InnoDB: Completed initialization of buffer pool
210625  8:42:08 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
210625  8:42:09  InnoDB: Waiting for the background threads to start
210625  8:42:10 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3280542791
210625  8:42:10 [Note] Plugin 'FEEDBACK' is disabled.
210625  8:42:10 [Warning] 'user' entry 'livezilladbadmin@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'moodleuser@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'mituser@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'server-monitor@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'fusiondev@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'pma@localhost' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'aimskorat@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'aimsmoodle@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'wpuser@localhost' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'gibbon@localhost' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'rfid@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10 [Warning] 'user' entry 'aims_alpha@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:10  InnoDB: Starting shutdown...
210625  8:42:14  InnoDB: Shutdown completed; log sequence number 3280542791
210625  8:42:14 InnoDB: The InnoDB memory heap is disabled
210625  8:42:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
210625  8:42:14 InnoDB: Compressed tables use zlib 1.2.7
210625  8:42:14 InnoDB: Using Linux native AIO
210625  8:42:14 InnoDB: Initializing buffer pool, size = 128.0M
210625  8:42:14 InnoDB: Completed initialization of buffer pool
210625  8:42:14 InnoDB: highest supported file format is Barracuda.
210625  8:42:14  InnoDB: Waiting for the background threads to start
210625  8:42:15 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3280542791
210625  8:42:15 [Note] Plugin 'FEEDBACK' is disabled.
210625  8:42:15 [Note] Server socket created on IP: '0.0.0.0'.
210625  8:42:15 [Warning] 'user' entry 'livezilladbadmin@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'moodleuser@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'mituser@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'server-monitor@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'fusiondev@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'pma@localhost' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'aimskorat@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'aimsmoodle@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'wpuser@localhost' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'gibbon@localhost' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'rfid@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Warning] 'user' entry 'aims_alpha@%' has both a password and an authentication plugin specified. The password will be ignored.
210625  8:42:15 [Note] Event Scheduler: Loaded 0 events
210625  8:42:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.68-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

My virtual server is running on ESXI with 32G RAM, 8vCPUs, 700G SSD storage, and 10G network.

I'm not sure if this is related or may affect the performance of smeserver installed on an ESXI host. One thing I've noticed is that even though I've installed the open-vm-tools, it stills show not running and not installed on the esxi dashboard.

Anyone who has experienced the same?

Code: [Select]

[root@sme1 ~]# ps ax|grep vmware
 3209 pts/0    S+     0:00 grep --color=auto vmware


Title: Re: Service Unavailable
Post by: Jean-Philippe Pialasse on June 25, 2021, 10:00:43 AM

have you setup dedicated ram or ballooning is enabled ?

not sure for centos7 but with centos6 there was some issues.

have you done a web search for this mariadb error?

Title: Re: Service Unavailable
Post by: ReetP on June 25, 2021, 07:56:16 PM

Assuming this is happening on the actual v10 server, not the ESX host.

Quote

Server socket created on IP: '0.0.0.0'.

Is that correct?

Do a web search on:

Quote

mariadb Error in accept: Too many open files

Look at say Max open files

https://blogs.reliablepenguin.com/2015/08/28/mariadb-on-centos-7-error-in-accept-too-many-open-files

Ask yourself what webapps you have installed and why this might happen?

And perhaps tell us too.