Crash!!!
Squirrel
squirrel at mail.isot.com
Wed Mar 18 17:17:02 PDT 2009
And if it's a file permission problem, why is it able to write *.err file on same directory?
I've set:
innodb_force_recovery = 6
And now the PANIC (fatal error) is gone, but still got this permission denied:
090318 19:09:53 mysqld started
InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on
InnoDB: Skipping log redo
090318 19:09:54 InnoDB: Started; log sequence number 0 0
InnoDB: !!! innodb_force_recovery is set to 6 !!!
090318 19:09:54 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/home/mysql/mysqld.pid' (Errcode: 13)
090318 19:09:54 [ERROR] Can't start server: can't create PID file: Permission denied
090318 19:09:54 mysqld ended
Please help...
-----Original message-----
From: Squirrel squirrel at mail.isot.com
Date: Wed, 18 Mar 2009 23:45:49 -0600
To: freebsd-stable freebsd-stable at freebsd.org
Subject: Re: Crash!!!
> Another thing, why is the error log shows bdb? Isn't that Berkerly DB? I didn't think I was using it. I went ahead and removed it, but rebooted the server. Only thing I can think is that I've installed virtualmin few days ago before this problem started.
>
> These are my file premissions:
>
> /home/
> drwxrwxrwx 33 mysql mysql 1024 Mar 18 17:18 mysql
> ..
>
> /home/mysql/
> [root at webserver /home/mysql]# ls -la
> total 143848
> drwxrwxrwx 33 mysql mysql 1024 Mar 18 17:18 .
> drw-r--r-- 71 felix felix 1536 Mar 18 16:44 ..
> drwxrw-rw- 2 mysql mysql 2560 Nov 21 2007 centexhomes
> drwxrw-rw- 2 mysql mysql 2560 Oct 31 2007 centexrealtors
> drwxrw-rw- 2 mysql mysql 18432 Mar 9 15:08 devildates
> drwxrw-rw- 2 mysql mysql 14848 Feb 10 2008 dolphin
> drwxrw-rw- 2 mysql mysql 2048 Mar 3 2008 drugal2
> drwxrw-rw- 2 mysql mysql 13824 Feb 28 2008 drup
> ...
> drwxrw-rw- 2 mysql mysql 1024 Oct 31 2007 treasure
> -rw-rw---- 1 mysql mysql 3785 Mar 18 17:18 webserver.isot.com.err
> -rwxrw-rw- 1 mysql mysql 83676 Mar 18 16:30 webserver.isot.com.err.bak
> -rwxrw-rw- 1 mysql mysql 5 Mar 17 11:27 webserver.isot.com.pid.bak
> drwxrw-rw- 2 mysql mysql 7168 Jun 11 2008 yourshows
> drwxrw-rw- 2 mysql mysql 2048 Mar 28 2008 yourshows_g2
>
>
>
> -----Original message-----
> From: Squirrel squirrel at mail.isot.com
> Date: Wed, 18 Mar 2009 23:22:50 -0600
> To: freebsd-stable freebsd-stable at freebsd.org
> Subject: Crash!!!
>
> > My webserver was working just fine on FreeBSD 6.2 Apache 2.2.11, MySQL 5.0.27. All of sudden MySQL quit and won't start. At the same time when logged in using SSH, it's looking for .bash_login and .bash_logout which it never did before, and will not chroot to user's home.
> >
> > Trying to manual start mysql causes:
> >
> > 090318 17:09:52 mysqld started
> > 090318 17:09:52 InnoDB: Started; log sequence number 2 2195718579
> > 090318 17:09:52 [ERROR] bdb: /home/mysql: Permission denied
> > 090318 17:09:52 [ERROR] bdb: /home/mysql/log.0000000001: Permission denied
> > 090318 17:09:52 [ERROR] bdb: PANIC: Permission denied
> > 090318 17:09:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
> > 090318 17:09:52 [ERROR] bdb: fatal region error detected; run recovery
> > 090318 17:09:52 [ERROR] bdb: /home/mysql: Permission denied
> > 090318 17:09:52 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/home/mysql/webserver.isot.com.pid' (Errcode: 13)
> > 090318 17:09:52 [ERROR] Can't start server: can't create PID file: Permission denied
> > 090318 17:09:52 mysqld ended
> >
> > I tried db_recover, but it's not found. HELP!!!
> > _______________________________________________
> > freebsd-stable at freebsd.org mailing list
> > http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> > To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"
> >
> _______________________________________________
> freebsd-stable at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"
>
More information about the freebsd-stable
mailing list