[vz-users] Datenbankfehler nach vergrößern der Partition

Sa Mär 28 14:40:22 CET 2020

Ja korrekt, mysql läuft nicht:

systemctl status mysql
● mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Sat 2020-03-28 13:32:58 CET; 1h 2min ago
  Process: 672 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 531 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && sys
  Process: 493 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 452 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 672 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Mar 28 13:32:52 keller systemd[1]: Starting MariaDB database server...
Mar 28 13:32:54 keller mysqld[672]: 2020-03-28 13:32:54 1988587520 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1) starting as pr
Mar 28 13:32:58 keller systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 28 13:32:58 keller systemd[1]: Failed to start MariaDB database server.
Mar 28 13:32:58 keller systemd[1]: mariadb.service: Unit entered failed state.
Mar 28 13:32:58 keller systemd[1]: mariadb.service: Failed with result 'exit-code‘.

ein Versuch es zu starten bringt das: 

sudo systemctl start mysql
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

die Ausgabe von journalctl -xe

journalctl -xe
Mar 28 14:36:01 keller CRON[3047]: (pi) CMD (php /var/www/volkszaehler.org/misc/tools/aggregate.php run -m delta -l minute >/dev/null)
Mar 28 14:36:01 keller CRON[3038]: (CRON) info (No MTA installed, discarding output)
Mar 28 14:36:01 keller CRON[3038]: pam_unix(cron:session): session closed for user pi
Mar 28 14:36:03 keller CRON[3037]: pam_unix(cron:session): session closed for user pi
Mar 28 14:36:03 keller Node-RED[348]: 28 Mar 14:36:03 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:36:19 keller Node-RED[348]: 28 Mar 14:36:19 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:36:20 keller sudo[3087]:       pi : TTY=pts/0 ; PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl start mysql
Mar 28 14:36:20 keller sudo[3087]: pam_unix(sudo:session): session opened for user root by pi(uid=0)
Mar 28 14:36:20 keller systemd[1]: Starting MariaDB database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
-- 
-- Unit mariadb.service has begun starting up.
Mar 28 14:36:21 keller mysqld[3189]: 2020-03-28 14:36:21 1988857856 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1) starting as p
Mar 28 14:36:25 keller systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 28 14:36:25 keller systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
-- 
-- Unit mariadb.service has failed.
-- 
-- The result is failed.
Mar 28 14:36:25 keller systemd[1]: mariadb.service: Unit entered failed state.
Mar 28 14:36:25 keller systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mar 28 14:36:25 keller sudo[3087]: pam_unix(sudo:session): session closed for user root
Mar 28 14:36:34 keller Node-RED[348]: 28 Mar 14:36:34 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:36:49 keller Node-RED[348]: 28 Mar 14:36:49 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:37:01 keller CRON[3223]: pam_unix(cron:session): session opened for user pi by (uid=0)
Mar 28 14:37:01 keller CRON[3227]: (pi) CMD (php /var/www/volkszaehler.org/misc/tools/aggregate.php run -m delta -l minute >/dev/null)
Mar 28 14:37:02 keller CRON[3223]: (CRON) info (No MTA installed, discarding output)
Mar 28 14:37:02 keller CRON[3223]: pam_unix(cron:session): session closed for user pi
Mar 28 14:37:04 keller Node-RED[348]: 28 Mar 14:37:04 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:37:19 keller Node-RED[348]: 28 Mar 14:37:19 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:37:34 keller Node-RED[348]: 28 Mar 14:37:34 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:37:49 keller Node-RED[348]: 28 Mar 14:37:49 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
Mar 28 14:38:01 keller CRON[3239]: pam_unix(cron:session): session opened for user pi by (uid=0)
Mar 28 14:38:01 keller CRON[3240]: pam_unix(cron:session): session opened for user pi by (uid=0)
Mar 28 14:38:01 keller CRON[3248]: (pi) CMD (php /var/www/volkszaehler.org/misc/tools/aggregate.php run -m delta -l minute >/dev/null)
Mar 28 14:38:01 keller CRON[3247]: (pi) CMD (/home/pi/scripts/sbfspot2vz.sh > /dev/null)
Mar 28 14:38:01 keller CRON[3240]: (CRON) info (No MTA installed, discarding output)
Mar 28 14:38:01 keller CRON[3240]: pam_unix(cron:session): session closed for user pi
Mar 28 14:38:03 keller CRON[3239]: pam_unix(cron:session): session closed for user pi
Mar 28 14:38:04 keller Node-RED[348]: 28 Mar 14:38:04 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: mqtt://192.168.178.34
lines 1859-1903/1903 (END)

mir sagt das leider gar nichts, ausser das mariadb nicht läuft, aber nicht warum es nicht läuft

Gruß Tobias

> Am 28.03.2020 um 14:17 schrieb Daniel Lauckner <vz at jahp.de>:
> 
> Hallo,
> 
> 
> am Samstag, 28. März 2020 um 13:45 hat Tobias Lehr geschrieben:
>> middleware.php/entity/XXXXX-53f0-11ea-a672-d170a1ac49e8.json?unique=1585399348516
>> <http://192.168.178.34/middleware.php/entity/7d4fc860-53f0-11ea-a672-d170a1ac49e8.json?unique=1585399348516>:
> 
>> An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory
> 
> Hm.
> 
>> Ich vermute mal das die Datenbank nicht läuft
> 
> Was kommt bei:
> systemctl status mysql
> 
>> oder nicht gefunden werden kann.
> 
> Da würde ich eine andere Meldung erwarten.
> 
>> Wenn ich mich per ssh einlogge,
> 
> Mal an der ssh-Console über den lokalen Client auf der Datenbank eingeloggt?
> 
> 
> mfg Daniel
> 

-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-users/attachments/20200328/b76243c8/attachment-0001.html>