mysql doesn't start

Xiong Chiamiov · 2009-01-24 00:18:03

After today's upgrades, mysql isn't starting.

pearson ~  $  sudo /etc/rc.d/mysqld restart
:: Stopping MySQL                                                                                                                     [FAIL] 
:: Starting MySQL                                                                                                                     [FAIL] 
pearson ~  $

pearson ~  $  cat /var/log/mysqld.log 
pearson ~  $

pearson ~ $ cat /var/log/pacman.log
...
[2009-01-23 14:41] synchronizing package lists
[2009-01-23 14:41] starting full system upgrade
[2009-01-23 14:42] starting full system upgrade
[2009-01-23 14:43] starting full system upgrade
[2009-01-23 14:53] upgraded asciidoc (8.3.1-1 -> 8.3.4-1)
[2009-01-23 14:53] upgraded initscripts (2008.09-2 -> 2009.01-1)
[2009-01-23 14:53] upgraded libtorrent-rasterbar (0.14-1 -> 0.14.1-1)
[2009-01-23 14:53] upgraded mkinitcpio (0.5.21-1 -> 0.5.23-1)
[2009-01-23 14:53] upgraded mlocate (0.21-1 -> 0.21.1-1)
[2009-01-23 14:53] upgraded mysql (5.0.75-1 -> 5.0.75-2)
pearson ~  $

So, I'm guessing the mysql update did something bad, but I can't seem to find any information about what it is. Is there any other place I can look for information, so I can either fix it or file a bugreport?

Last edited by Xiong Chiamiov (2009-01-29 03:33:13)

Yagi858 · 2009-01-24 23:35:29

Xiong Chiamiov wrote:

After today's upgrades, mysql isn't starting.
So, I'm guessing the mysql update did something bad, but I can't seem to find any information about what it is. Is there any other place I can look for information, so I can either fix it or file a bugreport?

Same problem

Vieira · 2009-01-25 00:16:32

Same problem here. I'm looking for a solution. Will post as soon as I find something.
If you have a workaround please share.

Vieira · 2009-01-25 00:27:07

You can start mysqld with

sudo /usr/bin/mysqld_safe --datadir=/var/lib/mysql

as a workaround.

Last edited by Vieira (2009-01-25 00:27:22)

Vieira · 2009-01-25 00:50:48

Using this version of the file /etc/rc.d/mysqld instead of the latest one solves the problem. Also see the differences that the new revision introduces which brokes the script.
A bug report has been filled.

Last edited by Vieira (2009-01-25 00:55:55)

linreigu · 2009-01-26 01:27:01

Hi Vieira,

Thanks for your great help. The safe mode start seems to work for me. However, the alternative script gives an error:

[root@ringmar ~]# /etc/rc.d/mysqld start
-bash: /etc/rc.d/mysqld: Permission denied

I guess I need to set some permissions somewhere. Any idea?

Happy New Year from Taiwan,

Erik

Xiong Chiamiov · 2009-01-26 01:42:35

linreigu wrote:

Hi Vieira,
Thanks for your great help. The safe mode start seems to work for me. However, the alternative script gives an error:
[root@ringmar ~]# /etc/rc.d/mysqld start
-bash: /etc/rc.d/mysqld: Permission denied
I guess I need to set some permissions somewhere. Any idea?
Happy New Year from Taiwan,
Erik

You have to be root to start or stop daemons:

sudo /etc/rc.d/mysqld start

linreigu · 2009-01-26 01:52:53

Hi Xiong,

OK, now I'm revealing myself as a real newbie: my sudo command doesn't work.

[root@ringmar ~]# sudo /etc/rc.d/mysqld start
-bash: sudo: command not found

I just moved to a Archlinux server from my old Ubuntu one. I never had this issue there. I logged in as root (I though). What should I do?

Erik

leftylink · 2009-01-26 05:43:48

I can help you with that one.
Log in as root (or use the command "su root" to switch to root) and run "pacman -S sudo". You need to install sudo before it will work

As for this thread, I also am having the mysql problems. I will use Vieira's solution for now while waiting for a fix.

u_no_hu · 2009-01-26 05:57:37

@linreigu
i hope you have installed sudo.

[root@ringmar ~]# sudo /etc/rc.d/mysqld start

But it seems you are already root, then why do you need sudo?

linreigu · 2009-01-26 06:14:38

Hi guys,

Apologies. I didn't mean to hijack this thread with my sudo talk. I have now installed sudo and it seems to work.

yours always,

tomauty · 2009-01-27 00:18:50

I've been having problems with mysql as well. How can I get the newer version mentioned in the bug report?

Ranguvar · 2009-01-27 00:24:29

pacman -Syu

If your mirror doesn't have the revision 3 package yet, download directly from ftp://ftp.archlinux.org/ in the extra directory and use pacman -U to install it.

tomauty · 2009-01-27 00:32:44

Hey thanks. I'll edit this in a bit when I find out if it works for me.

Success! Thanks for the help

Last edited by tomauty (2009-01-27 00:40:06)

marxav · 2009-01-29 02:20:20

Ranguvar wrote:

pacman -Syu

If your mirror doesn't have the revision 3 package yet, download directly from ftp://ftp.archlinux.org/ in the extra directory and use pacman -U to install it.

I just upgraded to rev 3, yet it refuses to start from /etc/rc.d/mysql start.
But this works /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql

Xiong Chiamiov · 2009-01-29 03:36:34

marxav wrote:

Ranguvar wrote:
pacman -Syu

If your mirror doesn't have the revision 3 package yet, download directly from ftp://ftp.archlinux.org/ in the extra directory and use pacman -U to install it.
I just upgraded to rev 3, yet it refuses to start from /etc/rc.d/mysql start.
But this works /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql

Yeah, I thought it was working, and it seems still broken to me. There's another person in the bugreport saying they're still having problems as well. I'd suggest posting there if you have any useful information, or perhaps just to let them know it's still not working.

phreique · 2009-01-31 18:33:02

I think that I got it figured out why mysqld wasn't starting. You have to add the following lines to your /etc/my.cnf file:

user = mysql
basedir = /usr/
datadir = /var/lib/mysql

Also check the permissions of /var/lib/mysql. I had to play around with those as well. I set 777 recursively - but I'm sure that there is a better way... I just wanted to get it working again!

-phreique

Xiong Chiamiov · 2009-01-31 18:48:11

phreique wrote:

I think that I got it figured out why mysqld wasn't starting. You have to add the following lines to your /etc/my.cnf file:
user = mysql
basedir = /usr/
datadir = /var/lib/mysql

Also check the permissions of /var/lib/mysql. I had to play around with those as well. I set 777 recursively - but I'm sure that there is a better way... I just wanted to get it working again!
-phreique

A new package release has come out, so I'd recommend going with that, rather than throwing 777 permissions around. I'd suggest you give your information to the package maintainer at the bug report.

marxav · 2009-01-31 21:09:30

Package release 4 is working fine.

jiyunatori · 2009-02-08 13:41:48

EDIT : of course, I look around for one hour, finally post here, and then I find the solution 5 minutes later.

Last edited by jiyunatori (2009-02-08 13:56:08)

marxav · 2009-02-08 13:54:03

If you manually deleted files, you should try to reinstall. I did not have any problem since 5.0.75-4 was released.

jiyunatori · 2009-02-08 13:57:29

hi marxav. actually, I reinstalled several times. but in the end, it was a permission problem. mysql_install_db created everything with root:root permissions. I just had to alter this.

danthux · 2009-02-27 19:10:28

hi guys, i had the same problem from the original post of this thread. i'm just solved by deleting two files:

bash-3.2# rm /var/lib/mysql/ibdata1
bash-3.2# rm /var/lib/mysql/paranoid-android.pid

...where "paranoid-android" is my hostname.

greets.

pd: excuse any error in my english.

Last edited by danthux (2009-02-27 19:14:01)

jakadinho · 2009-02-28 16:54:56

bash-3.2# rm /var/lib/mysql/ibdata1
bash-3.2# rm /var/lib/mysql/paranoid-android.pid

I did soo and i think it was a mistake. How can i fix it ?

when i try sudo /usr/bin/mysqld_safe --datadir=/var/lib/mysql output is

bash-3.2# sudo /usr/bin/mysqld_safe --datadir=/var/lib/mysql
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/jakadinho.pid
090228 17:39:38 mysqld ended

I tried rolling back also but it didnt work. Well mysql does start but i cannot access database with amarok.

brisbin33 · 2009-02-28 23:24:23

i'm at version 5.0.77-1 now and it fails to start.

i've tried the fixes outlined above, removed the data/pid files, added the lines to my.cnf; nothing fixes it.

starting with mysqld_safe --verbose shows nothing aside from jakadinho's output above.

rolling back to 5.0.75 apparently does not fix this.

Arch Linux

#1 2009-01-24 00:18:03

mysql doesn't start

#2 2009-01-24 23:35:29

Re: mysql doesn't start

#3 2009-01-25 00:16:32

Re: mysql doesn't start

#4 2009-01-25 00:27:07

Re: mysql doesn't start

#5 2009-01-25 00:50:48

Re: mysql doesn't start

#6 2009-01-26 01:27:01

Re: mysql doesn't start

#7 2009-01-26 01:42:35

Re: mysql doesn't start

#8 2009-01-26 01:52:53

Re: mysql doesn't start

#9 2009-01-26 05:43:48

Re: mysql doesn't start

#10 2009-01-26 05:57:37

Re: mysql doesn't start

#11 2009-01-26 06:14:38

Re: mysql doesn't start

#12 2009-01-27 00:18:50

Re: mysql doesn't start

#13 2009-01-27 00:24:29

Re: mysql doesn't start

#14 2009-01-27 00:32:44

Re: mysql doesn't start

#15 2009-01-29 02:20:20

Re: mysql doesn't start

#16 2009-01-29 03:36:34

Re: mysql doesn't start

#17 2009-01-31 18:33:02

Re: mysql doesn't start

#18 2009-01-31 18:48:11

Re: mysql doesn't start

#19 2009-01-31 21:09:30

Re: mysql doesn't start

#20 2009-02-08 13:41:48

Re: mysql doesn't start

#21 2009-02-08 13:54:03

Re: mysql doesn't start

#22 2009-02-08 13:57:29

Re: mysql doesn't start

#23 2009-02-27 19:10:28

Re: mysql doesn't start

#24 2009-02-28 16:54:56

Re: mysql doesn't start

#25 2009-02-28 23:24:23

Re: mysql doesn't start

Board footer