Guacamole unexpected internal error - mysqld stopped

NethServer Version: 7.6.1810 (final)
Module: Guacamole/mysqld

Hi Everyone,

I have the issue that guacamole stopped working.
THe webpage opens, but logging in it gives the error:
Unexpected Internal Error

I checked the services, and “mysqld” is stopped.

Restarting the mysqld from the GUI does nothing.
Opened an SSH and ran “systemctl start mysqld mariadb” is seems to sayed started for a few minutes, and then stopps.

Everything else seems to work (SOGo, Nextcloud, Zoneminder, Websites…)
I don’t know which logs to look at.
Any help appretiated.

Please stop mariadb and just start mysqld (mysqld points to mariadb):

systemctl stop mariadb
systemctl start mysqld

Can you connect to mariadb ?

mysql

Are the databases shown?

show databases;

Logfiles to check:

/var/log/messages
/var/log/mariadb/mariadb.log

Hi Markus,

Thanks for the reply.
I did what you said.

I was able to connect, and the databases are shown.

The mariadb.log show:
190731 19:48:46 mysqld_safe Number of processes running now: 1
190731 19:48:46 mysqld_safe mysqld process hanging, pid 12983 - killed
190731 19:48:46 mysqld_safe mysqld restarted
190731 19:48:46 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 13373 …
190731 19:48:46 [ERROR] mysqld: Can’t lock aria control file ‘/var/lib/mysql/aria_log_control’ for exclusive use, error: 11. Will retry for 30 seconds
190731 19:48:46 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
190731 19:48:47 InnoDB: The InnoDB memory heap is disabled
190731 19:48:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190731 19:48:47 InnoDB: Compressed tables use zlib 1.2.7
190731 19:48:47 InnoDB: Using Linux native AIO
190731 19:48:47 InnoDB: Initializing buffer pool, size = 128.0M
190731 19:48:47 InnoDB: Completed initialization of buffer pool
190731 19:48:47 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…
190731 19:48:47 InnoDB: Waiting for the background threads to start
190731 19:48:48 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 12097789665
190731 19:48:48 [Note] Plugin ‘FEEDBACK’ is disabled.
190731 19:48:48 [Note] Server socket created on IP: ‘0.0.0.0’.
190731 19:48:48 [ERROR] Cannot open mysql.event
190731 19:48:48 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
190731 19:48:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.5.60-MariaDB’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server

I have to check message log.

Are there more mysqld processes running?

Please check by listing all mysqld processes:

ps -ef | grep mysqld

Did you already try to reboot the server?

This is what i found in message log:

Jul 31 19:48:08 srv server: 19:48:08.281 [http-bio-8080-exec-1] ERROR o.a.g.rest.RESTExceptionWrapper - Unexpected internal error: Could not initialize class sun.security.ssl.SSLContextImpl$DefaultSSLContext
Jul 31 19:48:08 srv server: Jul 31, 2019 7:48:08 PM com.sun.jersey.spi.container.ContainerResponse logException
Jul 31 19:48:08 srv server: SEVERE: Mapped exception to response: 500 (Internal Server Error)
Jul 31 19:48:08 srv server: org.apache.guacamole.rest.APIException
Jul 31 19:48:08 srv server: at org.apache.guacamole.rest.RESTExceptionWrapper.invoke(RESTExceptionWrapper.java:202)
Jul 31 19:48:08 srv server: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Jul 31 19:48:08 srv server: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
Jul 31 19:48:08 srv server: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Jul 31 19:48:08 srv server: at java.lang.reflect.Method.invoke(Method.java:606)
Jul 31 19:48:08 srv server: at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
Jul 31 19:48:08 srv server: at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)

I did run updates 1-2 days ago and rebooted after, though i did not use guacamole until now.
Am rebooting now.

Just rebooted, and it works :stuck_out_tongue:
Dont know what this was. The Mysqld is still stopped though.

Thanks Markus :slight_smile:

1 Like