Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

 
Reply to this topicStart new topic
> Debian nie moge odpalić MySQL dziwna awaria.
zmorajlb
post 19.10.2018, 13:47:30
Post #1





Grupa: Zarejestrowani
Postów: 20
Pomógł: 0
Dołączył: 16.11.2015

Ostrzeżenie: (0%)
-----


Witam, na moim serwerze było 100% zajetosci dysku df -h więc usunąłem stare backupy,
nagle padła mi cała baza, nie mogę odpalić mysql.

service restart mysql

zwraca mi błąd:

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


service mysql status
  1.  
  2. ● mariadb.service - MariaDB database server
  3. Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  4. Drop-In: /etc/systemd/system/mysql.service.d
  5. └─limits.conf
  6. Active: failed (Result: exit-code) since Fri 2018-10-19 14:20:50 CEST; 13s ago
  7. Process: 19029 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  8. Process: 18940 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR |
  9. Process: 18938 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  10. Process: 18934 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  11. Main PID: 19029 (code=exited, status=1/FAILURE)
  12. Status: "MariaDB server is down"
  13.  
  14. Oct 19 14:20:47 rekin2 systemd[1]: Starting MariaDB database server...
  15. Oct 19 14:20:48 rekin2 mysqld[19029]: 2018-10-19 14:20:48 140115641451072 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 19029 ...
  16. Oct 19 14:20:50 rekin2 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
  17. Oct 19 14:20:50 rekin2 systemd[1]: Failed to start MariaDB database server.
  18. Oct 19 14:20:50 rekin2 systemd[1]: mariadb.service: Unit entered failed state.
  19. Oct 19 14:20:50 rekin2 systemd[1]: mariadb.service: Failed with result 'exit-code'.



systemctl status mariadb.service
  1. ● mariadb.service - MariaDB database server
  2. Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  3. Drop-In: /etc/systemd/system/mysql.service.d
  4. └─limits.conf
  5. Active: failed (Result: exit-code) since Fri 2018-10-19 14:31:08 CEST; 7s ago
  6. Process: 22148 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  7. Process: 22059 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR |
  8. Process: 22056 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  9. Process: 22052 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  10. Main PID: 22148 (code=exited, status=1/FAILURE)
  11. Status: "MariaDB server is down"
  12.  
  13. Oct 19 14:31:05 rekin2 systemd[1]: Starting MariaDB database server...
  14. Oct 19 14:31:05 rekin2 mysqld[22148]: 2018-10-19 14:31:05 139731825349184 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 22148 ...
  15. Oct 19 14:31:08 rekin2 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
  16. Oct 19 14:31:08 rekin2 systemd[1]: Failed to start MariaDB database server.
  17. Oct 19 14:31:08 rekin2 systemd[1]: mariadb.service: Unit entered failed state.
  18. Oct 19 14:31:08 rekin2 systemd[1]: mariadb.service: Failed with result 'exit-code'.


prosze o jakąś wskazówkę jak to naprawić :/

usunięcie pliku log: /var/lib/mysql/tc.log naprawiło problem, serwer ruszył.

pozdrawiam

Ten post edytował zmorajlb 19.10.2018, 13:31:49
Go to the top of the page
+Quote Post
Pyton_000
post 19.10.2018, 13:51:31
Post #2





Grupa: Zarejestrowani
Postów: 8 068
Pomógł: 1414
Dołączył: 26.10.2005

Ostrzeżenie: (0%)
-----


Zobacz w /var/log/mysql

ale obstawiam że został plik procesu w /var/run/mysql.pid
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 Użytkowników czyta ten temat (1 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Wersja Lo-Fi Aktualny czas: 28.03.2024 - 23:05