mysql fails to start

English Applications
1

openSUSE 12.2 stable

Application:
Repository: openSUSE-12.2-OSS
Name: mysql-community-server
Version: 5.5.25a-1.2.1

when starting mysqld from command line

rcmysql start

it respond with

Job failed. See system journal and 'systemctl status' for details.

and when running status it gives:

rcmysql status

redirecting to systemctl
mysql.service - LSB: Start the MySQL database server
          Loaded: loaded (/etc/init.d/mysql)
          Active: failed (Result: exit-code) since Sun, 23 Sep 2012 15:29:04 +0400; 25s ago
         Process: 6087 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
          CGroup: name=systemd:/system/mysql.service


Sep 23 15:28:33 linux-mkzk mysql[6087]: /etc/rc.status: line 57: /dev/stderr: No such device or address
Sep 23 15:28:34 linux-mkzk mysql[6087]: Will update MySQL now, if you encounter any problems, please read following file:
Sep 23 15:28:34 linux-mkzk mysql[6087]: /usr/share/doc/packages/mysql-community-server/README.SuSE
Sep 23 15:28:34 linux-mkzk mysql[6087]: Running protected MySQL...
Sep 23 15:29:04 linux-mkzk mysql[6087]: error: /var/tmp/mysql-protected.eUAF9G/mysql.sock file didn't appeared...
Sep 23 15:29:04 linux-mkzk mysql[6087]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"...

Any help will be much appreciated

2

On 2012-09-23 13:36, rafisv wrote:

> Code:
> --------------------
> Sep 23 15:29:04 linux-mkzk mysql[6087]: Try checking “/var/log/mysql/mysqld-upgrade-run.log”…
>
> --------------------

–
Cheers / Saludos,

Carlos E. R.
(from 12.1 x86_64 “Asparagus” at Telcontar)

3

it says

120923  1:53:06 InnoDB: 1.1.8 started; log sequence number 1595675
./usr/sbin/mysqld: File './mysql-bin.000006' not found (Errcode: 13)
120923  1:53:06 [ERROR] Failed to open log (file './mysql-bin.000006', errno 13)
120923  1:53:06 [ERROR] Could not open log file
120923  1:53:06 [ERROR] Can't init tc log
120923  1:53:06 [ERROR] Aborting

mysql-bin.000006 exists and the size is ~1Gb

4

the file may exist, but it’s not in the place mysql is looking for it. Check you /etc/my.cnf for the datadir.

All this brings me to the question: was this a clean install? Or upgrade from a previous openSUSE version?

5

On 2012-09-23 15:36, rafisv wrote:
>
> it says
>
> Code:
> --------------------
> 120923 1:53:06 InnoDB: 1.1.8 started; log sequence number 1595675
> ./usr/sbin/mysqld: File ‘./mysql-bin.000006’ not found (Errcode: 13)
> 120923 1:53:06 [ERROR] Failed to open log (file ‘./mysql-bin.000006’, errno 13)
> 120923 1:53:06 [ERROR] Could not open log file
> 120923 1:53:06 [ERROR] Can’t init tc log
> 120923 1:53:06 [ERROR] Aborting
> --------------------
>
>
> mysql-bin.000006 exists and the size is ~1Gb

Well, that’s the problem, but I do not know how to handle it.

–
Cheers / Saludos,

Carlos E. R.
(from 12.1 x86_64 “Asparagus” at Telcontar)

6

this was upgrade from 12.1
/etc/my.cnf says

datadir = /var/lib/mysql
7

permissions in datadir = /var/lib/mysql were root for some files and dirs, changed to mysql:mysql and that fixed the issue