Maria DB fail

[zeke]

I upgraded from MGA 2 to 3 and MySQL.service failed to start.

Code: Select all

$ systemctl status mysql
mysql.service
          Loaded: error (Reason: No such file or directory)
          Active: inactive (dead)



Code: Select all

# urpmi mariadb
Package mariadb-5.5.28-13.mga3.x86_64 is already installed
Marking mariadb as manually installed, it won't be auto-orphaned
writing /var/lib/rpm/installed-through-deps.list


not sure what I am missing here.

[Latte]

the service is called mysqld:

Code: Select all

[root@Rechner marc]# systemctl status mysqld
mysqld.service - MySQL database server
          Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
          Active: active (running) since Wed, 2013-08-28 18:45:31 CEST; 2s ago
         Process: 4988 ExecStartPost=/usr/sbin/mysqld-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
         Process: 4631 ExecStart=/usr/bin/mysqld_safe --nowatch (code=exited, status=0/SUCCESS)
         Process: 4611 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
        Main PID: 4987 (mysqld)
          CGroup: name=systemd:/system/mysqld.service
                  └ 4987 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mys...

Aug 28 18:45:29 Rechner systemd[1]: Starting MySQL database server...
Aug 28 18:45:29 Rechner mysqld_safe[4631]: 130828 18:45:29 mysqld_safe Logging ...'.
Aug 28 18:45:29 Rechner mysqld_safe[4631]: 130828 18:45:29 mysqld_safe Starting...ql
Aug 28 18:45:31 Rechner systemd[1]: Started MySQL database server.

[zeke]

Thanks:

Code: Select all

# systemctl status mysqld
mysqld.service - MySQL database server
          Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
          Active: failed (Result: start-limit) since Wed, 2013-08-28 12:21:15 CDT; 30min ago
         Process: 4522 ExecStartPost=/usr/sbin/mysqld-wait-ready $MAINPID (code=exited, status=1/FAILURE)
         Process: 4164 ExecStart=/usr/bin/mysqld_safe --nowatch (code=exited, status=0/SUCCESS)
         Process: 4144 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
        Main PID: 4118 (code=exited, status=1/FAILURE)
          CGroup: name=systemd:/system/mysqld.service

Aug 28 12:21:15 localhost systemd[1]: Failed to start MySQL database server.
Aug 28 12:21:15 localhost systemd[1]: Unit mysqld.service entered failed state
Aug 28 12:21:15 localhost systemd[1]: Stopping MySQL database server...
Aug 28 12:21:15 localhost systemd[1]: Starting MySQL database server...
Aug 28 12:21:15 localhost systemd[1]: Failed to start MySQL database server.
Aug 28 12:21:15 localhost systemd[1]: Unit mysqld.service entered failed state


[doktor5000]

Please have a look at the existing threads first:
viewtopic.php?f=7&t=2648
viewtopic.php?f=7&t=4329

[zeke]

Very frustrating.

I found a suggestion on another forum about starting it in safe mode in the foreground manually and logging errors to a specified file.

I had lots of InnoDB errors that I resolved by either rm logfiles or commenting parts of my.cnf relevant to innodb.

Now, I can start it manually with no errors with the command:

Code: Select all

 mysqld_safe --log-error=/var/log/mysql.err


This allows me to run mysql
I can see my databases and the tables in them, but if I try a query I get "Table 'x.x' doesn't exist....even though I see it with the show tables command!?!?

If I try to start the system service, I get this error:

Code: Select all

systemctl start mysqld
Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -n' for details.
[root@localhost multi-user.target.wants]# systemctl status mysqld.service
mysqld.service - MySQL database server
          Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
          Active: failed (Result: start-limit) since Thu, 2013-10-17 14:27:35 CDT; 5s ago
         Process: 3334 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=1/FAILURE)
          CGroup: name=systemd:/system/mysqld.service

Oct 17 14:27:35 localhost systemd[1]: Failed to start MySQL database server.
Oct 17 14:27:35 localhost systemd[1]: Unit mysqld.service entered failed state
Oct 17 14:27:35 localhost mysqld-prepare-db-dir[3334]: chown: changing ownership of ‘/home/brett/...ed
Oct 17 14:27:35 localhost mysqld-prepare-db-dir[3334]: chown: changing ownership of ‘/home/brett/...ed
Oct 17 14:27:35 localhost mysqld-prepare-db-dir[3334]: chown: changing ownership of ‘/home/brett/...ed
Oct 17 14:27:35 localhost mysqld-prepare-db-dir[3334]: chown: changing ownership of ‘/home/brett/...ed
Oct 17 14:27:35 localhost systemd[1]: Stopping MySQL database server...
Oct 17 14:27:35 localhost systemd[1]: Starting MySQL database server...
Oct 17 14:27:35 localhost systemd[1]: Failed to start MySQL database server.
Oct 17 14:27:35 localhost systemd[1]: Unit mysqld.service entered failed state


This is killing me because this is a production machine and I need mysql for some work I am doing.