Hallo, und plötzlich will der mysql nicht mehr...
Im Log steht nach einem /etc/init.d/mysql restart folgendes:
/tmp gehört root und Gruppe root, und auch das sticky bit ist gesetzt, chmod 1777 trotzdem ausgeführt.
Ist da vielleicht eine Reparatur einer Tabelle notwendig?
Mit mysql -u root -p kann ich mich ja anmelden. Wie gehts dann weiter? Andere Ideen was es sein könnte?
Im Log steht nach einem /etc/init.d/mysql restart folgendes:
Code:
Jun 9 11:56:12 jxxxxxx systemd[1]: Stopping LSB: Start and stop the mysql database server daemon...
Jun 9 11:56:12 jxxxxxx mysqld: 160609 11:56:12 [Note] /usr/sbin/mysqld: Normal shutdown
Jun 9 11:56:12 jxxxxxx mysqld:
Jun 9 11:56:12 jxxxxxx mysqld: 160609 11:56:12 [Note] Event Scheduler: Purging the queue. 0 events
Jun 9 11:56:12 jxxxxxx mysqld: 160609 11:56:12 [Note] InnoDB: FTS optimize thread exiting.
Jun 9 11:56:12 jxxxxxx mysqld: 160609 11:56:12 [Note] InnoDB: Starting shutdown...
Jun 9 11:56:14 jxxxxxx mysqld: 160609 11:56:14 [Note] InnoDB: Shutdown completed; log sequence number 221971392
Jun 9 11:56:14 jxxxxxx mysqld: 160609 11:56:14 [Note] /usr/sbin/mysqld: Shutdown complete
Jun 9 11:56:14 jxxxxxx mysqld:
Jun 9 11:56:14 jxxxxxx mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jun 9 11:56:14 jxxxxxx mysql[3236]: Stopping MariaDB database server: mysqld.
Jun 9 11:56:14 jxxxxxx systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Jun 9 11:56:15 jxxxxxx mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] /usr/sbin/mysqld (mysqld 10.0.25-MariaDB-0+deb8u1) starting as process 3434 ...
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: The InnoDB memory heap is disabled
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Memory barrier is not used
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Compressed tables use zlib 1.2.8
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Using Linux native AIO
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Using CPU crc32 instructions
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Completed initialization of buffer pool
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Highest supported file format is Barracuda.
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: 128 rollback segment(s) are active.
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Waiting for purge to start
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 221971392
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] Plugin 'FEEDBACK' is disabled.
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] Server socket created on IP: '127.0.0.1'.
Jun 9 11:56:15 jxxxxxx mysqld: 160609 11:56:15 [Note] /usr/sbin/mysqld: ready for connections.
Jun 9 11:56:15 jxxxxxx mysqld: Version: '10.0.25-MariaDB-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Jun 9 11:56:15 jxxxxxx mysql[3269]: Starting MariaDB database server: mysqld.
Jun 9 11:56:15 jxxxxxx systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Jun 9 11:56:15 jxxxxxx /etc/mysql/debian-start[3484]: Upgrading MySQL tables if necessary.
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: #007/usr/bin/mysql_upgrade: Can't create/write to file '/tmp/mysql_upgrade-UBSq1F' (Errcode: 28 "No space left on device")
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: Looking for 'mysql' as: /usr/bin/mysql
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: #007/usr/bin/mysql_upgrade: Can't create/write to file '/tmp/sqlsTlSp1' (Errcode: 28 "No space left on device")
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: FATAL ERROR: Failed to create temporary file for defaults
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3488]: #007/usr/bin/mysql_upgrade: Error on delete of '/tmp/mysql_upgrade-UBSq1F' (Errcode: 2 "No such file or directory")
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3501]: Checking for insecure root accounts.
Jun 9 11:56:16 jxxxxxx /etc/mysql/debian-start[3510]: Triggering myisam-recover for all MyISAM tables
Jun 9 11:56:16 jxxxxxx mysql[3269]: open: No space left on device
/tmp gehört root und Gruppe root, und auch das sticky bit ist gesetzt, chmod 1777 trotzdem ausgeführt.
Ist da vielleicht eine Reparatur einer Tabelle notwendig?
Mit mysql -u root -p kann ich mich ja anmelden. Wie gehts dann weiter? Andere Ideen was es sein könnte?