Out of the blue mariabd will not restart...

Been running fine for months but today it stopped, nothing looks out of the ordinary. Rebooted didn't help. At a loss…

> mysqld –debug

131104 17:04:34 [Warning] Using unique option prefix keybuffer instead of keybuffer_size is deprecated and will be removed in a future release. Please use the full name instead.

131104 17:04:34 [Warning] 'debug' is disabled in this build

131104 17:04:34 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

131104 17:04:34 InnoDB: The InnoDB memory heap is disabled

131104 17:04:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins

131104 17:04:34 InnoDB: Compressed tables use zlib 1.2.7

131104 17:04:34 InnoDB: Using Linux native AIO

131104 17:04:34 [ERROR] mysqld: Can't create/write to file '/tmp/ibGA9fI4' (Errcode: 13)

131104 17:04:34 InnoDB: Error: unable to create temporary file; errno: 13

131104 17:04:34 [ERROR] Plugin 'InnoDB' init function returned error.

131104 17:04:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

131104 17:04:34 [Note] Plugin 'FEEDBACK' is disabled.

131104 17:04:34 [ERROR] Unknown/unsupported storage engine: InnoDB

131104 17:04:34 [ERROR] Aborting

Also

'ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' 
ls -l /var/run/mysqld/mysqld.sock
-rw-r--r-- 1 mysql mysql 0 Nov  4 16:57 /var/run/mysqld/mysqld.sock

1 Reply

Shoot, just remembered, I accidentally deleted the /tmp folder and had to manually recreate it.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct