Internal Server Error by Browser

Wookie · September 6, 2022, 8:08pm

Hello all,

i have a problem.
My Space was full at my Nextcloud Server
I have fixed it , but my Nextcloud doenst start.

Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

i checked my config and find a error in Mariadb ?

wookie@cloud:/var/www/nextcloud/config$ sudo systemctl status mariadb
● mariadb.service - MariaDB 10.1.48 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Tue 2022-09-06 19:56:23 UTC; 4min 15s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 27917 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 27842 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSI
  Process: 27833 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 27821 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 27917 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Sep 06 19:56:20 cloud systemd[1]: Starting MariaDB 10.1.48 database server...
Sep 06 19:56:21 cloud mysqld[27917]: 2022-09-06 19:56:21 140129416137856 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 27917 ...
Sep 06 19:56:23 cloud systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 06 19:56:23 cloud systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 06 19:56:23 cloud systemd[1]: Failed to start MariaDB 10.1.48 database server.

/var/www/nextcloud/config$ my_print_defaults --mysqld
--user=mysql
--pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock
--port=3306
--basedir=/usr
--datadir=/var/lib/mysql
--tmpdir=/tmp
--lc-messages-dir=/usr/share/mysql
--skip-external-locking
--bind-address=127.0.0.1
--key_buffer_size=16M
--max_allowed_packet=16M
--thread_stack=192K
--thread_cache_size=8
--myisam_recover_options=BACKUP
--query_cache_limit=1M
--query_cache_size=16M
--log_error=/var/log/mysql/error.log
--expire_logs_days=10
--max_binlog_size=100M
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci

:/var/www/nextcloud/config$ journalctl -xe
Sep 06 19:49:02 cloud systemd-timesyncd[29345]: Synchronized to time server 185.125.190.57:123 (ntp.ubuntu.com).
Sep 06 19:49:02 cloud dockerd[25215]: time="2022-09-06T19:49:02.752054472Z" level=info msg="Loading containers: done."
Sep 06 19:49:02 cloud dockerd[25215]: time="2022-09-06T19:49:02.805207009Z" level=info msg="Docker daemon" commit="20.10.7-0ubuntu5~18.04.3" graphdriver(s)=overlay2 version=20.10.7
Sep 06 19:49:02 cloud dockerd[25215]: time="2022-09-06T19:49:02.805768255Z" level=info msg="Daemon has completed initialization"
Sep 06 19:49:02 cloud systemd[1]: Started Docker Application Container Engine.
-- Subject: Unit docker.service has finished start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit docker.service has finished starting up.
--
-- The start-up result is RESULT.
Sep 06 19:49:02 cloud dockerd[25215]: time="2022-09-06T19:49:02.886719728Z" level=info msg="API listen on /var/run/docker.sock"
Sep 06 19:49:02 cloud systemd[1]: Reloading.
Sep 06 19:49:10 cloud sudo[24373]: pam_unix(sudo:session): session closed for user root
Sep 06 19:49:37 cloud sudo[26803]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/usr/bin/docker logs -f nextclouddb
Sep 06 19:49:37 cloud sudo[26803]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 19:49:37 cloud sudo[26803]: pam_unix(sudo:session): session closed for user root
Sep 06 19:49:43 cloud sudo[26822]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/usr/bin/docker logs -f nextcloud
Sep 06 19:49:43 cloud sudo[26822]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 19:49:43 cloud sudo[26822]: pam_unix(sudo:session): session closed for user root
Sep 06 19:49:55 cloud sudo[26857]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/usr/bin/docker exec -it nextclouddb bash
Sep 06 19:49:55 cloud sudo[26857]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 19:49:56 cloud sudo[26857]: pam_unix(sudo:session): session closed for user root
Sep 06 19:50:50 cloud sudo[26977]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/usr/sbin/service mysql restart
Sep 06 19:50:50 cloud sudo[26977]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 19:50:50 cloud systemd[1]: Starting MariaDB 10.1.48 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has begun starting up.
Sep 06 19:50:51 cloud mysqld[27081]: 2022-09-06 19:50:51 140221419904128 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 27081 ...
Sep 06 19:50:54 cloud systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 06 19:50:54 cloud systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 06 19:50:54 cloud systemd[1]: Failed to start MariaDB 10.1.48 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.
--
-- The result is RESULT.
Sep 06 19:50:54 cloud sudo[26977]: pam_unix(sudo:session): session closed for user root
Sep 06 19:56:19 cloud sudo[27787]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/usr/sbin/service mysql start
Sep 06 19:56:19 cloud sudo[27787]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 19:56:20 cloud systemd[1]: Starting MariaDB 10.1.48 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has begun starting up.
Sep 06 19:56:21 cloud mysqld[27917]: 2022-09-06 19:56:21 140129416137856 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 27917 ...
Sep 06 19:56:23 cloud systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 06 19:56:23 cloud systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 06 19:56:23 cloud systemd[1]: Failed to start MariaDB 10.1.48 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.
--
-- The result is RESULT.
Sep 06 19:56:23 cloud sudo[27787]: pam_unix(sudo:session): session closed for user root
Sep 06 19:59:27 cloud sudo[28351]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/usr/bin/mc
Sep 06 19:59:27 cloud sudo[28351]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 20:00:37 cloud sudo[28351]: pam_unix(sudo:session): session closed for user root
Sep 06 20:00:38 cloud sudo[28526]:   wookie : TTY=pts/1 ; PWD=/var/www/nextcloud/config ; USER=root ; COMMAND=/bin/systemctl status mariadb
Sep 06 20:00:38 cloud sudo[28526]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 06 20:03:47 cloud sudo[28526]: pam_unix(sudo:session): session closed for user root

Wookie · September 6, 2022, 8:48pm

More informations:

mariadb --version
mariadb  Ver 15.1 Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Wookie · September 9, 2022, 1:49pm

df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           395M  1.4M  394M   1% /run
/dev/sda2       688G  469G  189G  72% /
tmpfs           2.0G     0  2.0G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           2.0G     0  2.0G   0% /sys/fs/cgroup
/dev/loop0       56M   56M     0 100% /snap/core18/2560
/dev/loop1       56M   56M     0 100% /snap/core18/2538
/dev/loop2      114M  114M     0 100% /snap/core/13425
/dev/loop3      114M  114M     0 100% /snap/core/13308
/dev/loop4      253M  253M     0 100% /snap/nextcloud/24018
/dev/loop5      274M  274M     0 100% /snap/nextcloud/24051
tmpfs           395M     0  395M   0% /run/user/1000

Wookie · September 9, 2022, 1:50pm

cat config.php
<?php
$CONFIG = array (
  'instanceid' => ''******',
  'passwordsalt' => '******',
  'secret' => ''******',
'trusted_domains' =>
   [
    ''******',
    '192.168.0.88',
  ],
  'datadirectory' => '/var/www/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '20.0.14.2',
  'overwrite.cli.url' => '******',
  'overwriteprotocol' => 'https',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextclouduser',
  'dbpassword' => '******',
  'installed' => true,
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'nextcloud',
  'mail_domain' => ''******',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'smtp.strato.de',
  'mail_smtpport' => '465',
  'mail_smtpname' => ''******',
  'mail_smtppassword' => '******',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 0,
);

Wookie · September 9, 2022, 2:34pm

journalctl -xe"
> ^C
wookie@cloud:/var/log/mysql$ journalctl -xe
Sep 09 14:08:22 cloud sudo[19127]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 09 14:08:41 cloud sudo[19127]: pam_unix(sudo:session): session closed for user root
Sep 09 14:08:46 cloud sudo[19178]:   wookie : TTY=pts/0 ; PWD=/etc/init.d ; USER=root ; COMMAND=/usr/bin/apt update
Sep 09 14:08:46 cloud sudo[19178]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 09 14:08:49 cloud sudo[19178]: pam_unix(sudo:session): session closed for user root
Sep 09 14:09:01 cloud CRON[19549]: pam_unix(cron:session): session opened for user root by (uid=0)
Sep 09 14:09:01 cloud CRON[19550]: (root) CMD (  [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Sep 09 14:09:01 cloud CRON[19549]: pam_unix(cron:session): session closed for user root
Sep 09 14:09:04 cloud systemd[1]: Starting Clean php session files...
-- Subject: Unit phpsessionclean.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit phpsessionclean.service has begun starting up.
Sep 09 14:09:05 cloud systemd[1]: Started Clean php session files.
-- Subject: Unit phpsessionclean.service has finished start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit phpsessionclean.service has finished starting up.
--
-- The start-up result is RESULT.
Sep 09 14:17:01 cloud CRON[20584]: pam_unix(cron:session): session opened for user root by (uid=0)
Sep 09 14:17:01 cloud CRON[20585]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
Sep 09 14:17:01 cloud CRON[20584]: pam_unix(cron:session): session closed for user root
Sep 09 14:29:48 cloud sudo[22264]:   wookie : TTY=pts/0 ; PWD=/var/log/mysql ; USER=root ; ENV=MYSQL_PWD= ; COMMAND=/usr/bin/mysql_upgrade -uadmin
Sep 09 14:29:48 cloud sudo[22264]: pam_unix(sudo:session): session opened for user root by wookie(uid=0)
Sep 09 14:29:48 cloud sudo[22264]: pam_unix(sudo:session): session closed for user root
Sep 09 14:33:57 cloud polkitd(authority=local)[1040]: Registered Authentication Agent for unix-process:22792:35285270 (system bus name :1.131 [/usr/bin/pkttyagent --notify-fd
Sep 09 14:34:00 cloud polkitd(authority=local)[1040]: Operator of unix-process:22792:35285270 successfully authenticated as unix-user:wookie to gain ONE-SHOT authorization for
Sep 09 14:34:00 cloud systemd[1]: Starting MariaDB 10.1.48 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has begun starting up.
Sep 09 14:34:01 cloud mysqld[22901]: 2022-09-09 14:34:01 139849372773504 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 22901 ...
Sep 09 14:34:04 cloud systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 09 14:34:04 cloud systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 09 14:34:04 cloud systemd[1]: Failed to start MariaDB 10.1.48 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.
--
-- The result is RESULT.
Sep 09 14:34:04 cloud polkitd(authority=local)[1040]: Unregistered Authentication Agent for unix-process:22792:35285270 (system bus name :1.131, object path /org/freedesktop/P

2022-09-09 14:34:01 139849372773504 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to$

2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: The InnoDB memory heap is disabled
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Using Linux native AIO
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Using SSE crc32 instructions
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Completed initialization of buffer pool
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: 128 rollback segment(s) are active.
2022-09-09 14:34:01 139849372773504 [Note] InnoDB: Waiting for purge to start
2022-09-09 14:34:01 139849372773504 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 12860209058
2022-09-09 14:34:01 139849372773504 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-09 14:34:01 139848715331328 [Note] InnoDB: Dumping buffer pool(s) not yet started
2022-09-09 14:34:01 139849372773504 [Note] Recovering after a crash using tc.log
2022-09-09 14:34:01 139849372773504 [ERROR] Can't init tc log
2022-09-09 14:34:01 139849372773504 [ERROR] Aborting