Jump to content
linuxserver.io

[Support] Linuxserver.io - MariaDB

280 posts in this topic Last Reply

Recommended Posts

I have had Nextcloud running for a good 8 months.  The other day it stopped working, the apps wouldnt connect.  I cannot bring up the web-gui either.

I started looking at the logs withing the dockers of unraid and the maria db is full of these:

 

190802 07:57:50 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:51 mysqld_safe Logging to syslog.
190802 07:57:51 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:56 mysqld_safe Logging to syslog.
190802 07:57:56 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:57 mysqld_safe Logging to syslog.
190802 07:57:57 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:58 mysqld_safe Logging to syslog.
190802 07:57:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:58:03 mysqld_safe Logging to syslog.
190802 07:58:03 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:58:04 mysqld_safe Logging to syslog.
190802 07:58:04 mysqld_safe Starting mysqld daemon with databases from /config/databases

 

over and over, and the nextcloud log has this:

 

 

-------------------------------------
_ ()
| | ___ _ __
| | / __| | | / \
| | \__ \ | | | () |
|_| |___/ |_| \__/


Brought to you by linuxserver.io
We gratefully accept donations at:
https://www.linuxserver.io/donate/
-------------------------------------
GID/UID
-------------------------------------

User uid: 99
User gid: 100
-------------------------------------

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 20-config: executing...
[cont-init.d] 20-config: exited 0.
[cont-init.d] 30-keygen: executing...
using keys found in /config/keys
[cont-init.d] 30-keygen: exited 0.
[cont-init.d] 40-config: executing...
[cont-init.d] 40-config: exited 0.
[cont-init.d] 50-install: executing...
[cont-init.d] 50-install: exited 0.
[cont-init.d] 60-memcache: executing...
[cont-init.d] 60-memcache: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2006] MySQL server has gone away in /config/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /config/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver in /config/www/nextcloud/lib/private/DB/Connection.php on line 64
PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2006] MySQL server has gone away in /config/www/nextcloud/lib/private/DB/Connection.php:64

over and over......

 

I restarted the containers, no improvement.

I did notice that my 256 Gb SSD cache drive was mostly full and had 410Mb free.. so I invoked the Move Now and now have 215Gb free

but stopping and restarting the containers still yields still doesnt help and the log files look the same.

 

The system has a fair amount of data on it and I'd like to get it going without having to start over.

Any help is greatly appreciated,

 

Thanks, 

 

George

Share this post


Link to post
On 8/2/2019 at 8:08 AM, GTM said:

I have had Nextcloud running for a good 8 months.  The other day it stopped working, the apps wouldnt connect.  I cannot bring up the web-gui either.

I started looking at the logs withing the dockers of unraid and the maria db is full of these:

 

190802 07:57:50 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:51 mysqld_safe Logging to syslog.
190802 07:57:51 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:56 mysqld_safe Logging to syslog.
190802 07:57:56 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:57 mysqld_safe Logging to syslog.
190802 07:57:57 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:57:58 mysqld_safe Logging to syslog.
190802 07:57:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:58:03 mysqld_safe Logging to syslog.
190802 07:58:03 mysqld_safe Starting mysqld daemon with databases from /config/databases
190802 07:58:04 mysqld_safe Logging to syslog.
190802 07:58:04 mysqld_safe Starting mysqld daemon with databases from /config/databases

 

over and over, and the nextcloud log has this:

 

 

-------------------------------------
_ ()
| | ___ _ __
| | / __| | | / \
| | \__ \ | | | () |
|_| |___/ |_| \__/


Brought to you by linuxserver.io
We gratefully accept donations at:
https://www.linuxserver.io/donate/
-------------------------------------
GID/UID
-------------------------------------

User uid: 99
User gid: 100
-------------------------------------

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 20-config: executing...
[cont-init.d] 20-config: exited 0.
[cont-init.d] 30-keygen: executing...
using keys found in /config/keys
[cont-init.d] 30-keygen: exited 0.
[cont-init.d] 40-config: executing...
[cont-init.d] 40-config: exited 0.
[cont-init.d] 50-install: executing...
[cont-init.d] 50-install: exited 0.
[cont-init.d] 60-memcache: executing...
[cont-init.d] 60-memcache: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2006] MySQL server has gone away in /config/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /config/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver in /config/www/nextcloud/lib/private/DB/Connection.php on line 64
PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2006] MySQL server has gone away in /config/www/nextcloud/lib/private/DB/Connection.php:64

over and over......

 

I restarted the containers, no improvement.

I did notice that my 256 Gb SSD cache drive was mostly full and had 410Mb free.. so I invoked the Move Now and now have 215Gb free

but stopping and restarting the containers still yields still doesnt help and the log files look the same.

 

The system has a fair amount of data on it and I'd like to get it going without having to start over.

Any help is greatly appreciated,

 

Thanks, 

 

George

Bumping this topic cause I'm having this issue. 

 

Updated Nextcloud and when I went to run the update, mariadb has "gone away" while trying to update the db.

 

Restarting the docker does nothing. 

 

I logged into the docker via command line and noticed mariadb was stopped.  Trying to start the docker produces a fail. 

 

Any idea what could be wrong?

 

Thanks, 

EDS

 

 

 

Share this post


Link to post

Hey Ed,

 

No idea what is going on with your particular situation, but even though different, it has a similarity. I think the problem is the upkeep of the docker containers. I gave up on the PHP problem with nextcloud docker, and installed nextcloud onto a  virtual machine within unraid via an Ubuntu server dedicated to serving nextcloud. I used the chris titus nextcloud video on youtube which uses a snap install, along with mapped a share on the unraid aray where the nextcloud-ubuntu could store the files. its working great and I don't have to worry about unraid bumping the PHP up to high out of reach of my current docker container any more.   THAT SUCKED and who ever is in charge of the containers (keeping things compatible) should have put a PHP version in the container or something like that to prevent incompatibilities like that.

 

if you need any pointers on how to do what I was able to accomplish, let me know.  george dot t dot miller at preventionit dot com is my email addy.

 

keep smiling and good luck,

 

George

Share this post


Link to post
1 hour ago, GTM said:

Hey Ed,

 

No idea what is going on with your particular situation, but even though different, it has a similarity. I think the problem is the upkeep of the docker containers. I gave up on the PHP problem with nextcloud docker, and installed nextcloud onto a  virtual machine within unraid via an Ubuntu server dedicated to serving nextcloud. I used the chris titus nextcloud video on youtube which uses a snap install, along with mapped a share on the unraid aray where the nextcloud-ubuntu could store the files. its working great and I don't have to worry about unraid bumping the PHP up to high out of reach of my current docker container any more.   THAT SUCKED and who ever is in charge of the containers (keeping things compatible) should have put a PHP version in the container or something like that to prevent incompatibilities like that.

 

if you need any pointers on how to do what I was able to accomplish, let me know.  george dot t dot miller at preventionit dot com is my email addy.

 

keep smiling and good luck,

 

George

George. 

 

Thanks for your reply. 

 

After a good 24 hours of messing with the docker I was finally able to figure it out.  Basically the nextcloud update "broke" one of the nextcloud tables which then caused mysql to run a mysql_safe boot loop.  

 

The fix was to backup the nextcloud db, delete the old db and then create it anew from the backup. 

 

Regards, 

EDS

Share this post


Link to post
18 hours ago, GTM said:

Hey Ed,

 

No idea what is going on with your particular situation, but even though different, it has a similarity. I think the problem is the upkeep of the docker containers. I gave up on the PHP problem with nextcloud docker, and installed nextcloud onto a  virtual machine within unraid via an Ubuntu server dedicated to serving nextcloud. I used the chris titus nextcloud video on youtube which uses a snap install, along with mapped a share on the unraid aray where the nextcloud-ubuntu could store the files. its working great and I don't have to worry about unraid bumping the PHP up to high out of reach of my current docker container any more.   THAT SUCKED and who ever is in charge of the containers (keeping things compatible) should have put a PHP version in the container or something like that to prevent incompatibilities like that.

 

if you need any pointers on how to do what I was able to accomplish, let me know.  george dot t dot miller at preventionit dot com is my email addy.

 

keep smiling and good luck,

 

George

I'm not sure what you are talking about regarding nextcloud, php and unraid version of php. If you are talking of our nextcloud container, php is built in to the container, but if you don't keep nextcloud updated, you will get a problem when the php version in the container is too new for the Nextcloud version you are using.

 

Updating nextcloud is a manually process, either through the Webui or command line.

 

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.