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