Hi all,
This morning my server wasn't running. For some reason it had shutdown, which the error log shows, but what's causing it is a riddle to me. I'm now running with --log and --log-update to be able to get some info if it happens again. Any other ideas on how to troubleshoot this or is this a known issue? Some info: I'm running Redhat 9 with the default mysql rpms. The server runs a few very small low traffic databases accessed with Apache::DBI. $ mysql -V mysql Ver 12.22 Distrib 4.0.16, for pc-linux (i686) $ cat /var/lib/mysql/husky.err 031203 05:45:45 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031203 5:45:45 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031203 5:45:48 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031203 5:45:48 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 031203 5:45:50 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 040114 5:17:37 /usr/sbin/mysqld: Normal shutdown 040114 5:17:37 InnoDB: Starting shutdown... 040114 5:17:39 InnoDB: Shutdown completed 040114 5:17:39 /usr/sbin/mysqld: Shutdown Complete 040114 05:17:40 mysqld ended 040114 05:28:11 mysqld started 040114 5:28:14 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Number of processes running now: 0 040320 11:26:34 mysqld restarted 040320 11:45:26 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43902 InnoDB: Doing recovery: scanned up to log sequence number 0 43902 040320 11:52:54 InnoDB: Flushing modified pages from the buffer pool... 040320 11:57:56 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Number of processes running now: 0 040320 12:42:07 mysqld restarted 040320 12:52:02 mysqld ended 040323 12:26:09 mysqld started 040323 12:26:11 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43902 InnoDB: Doing recovery: scanned up to log sequence number 0 43902 040323 12:26:11 InnoDB: Flushing modified pages from the buffer pool... 040323 12:26:11 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 ------------------------------------------------------------------------ ! Robert Friberg 0733-839080 ! Developer/Trainer perl,java,dotnet,linux,xml,uml,sql,c/c++,vb ! Ensofus AB http://www.ensofus.se/ ! Miljö Online AB http://www.miljo-online.se/ ------------------------------------------------------------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
