Description:
050628 17:29:14 mysqld started
050628 17:29:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050628 17:29:14 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
050628 17:29:14 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 3
5 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7
5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
99
InnoDB: Apply batch completed
050628 17:29:14 InnoDB: Started; log sequence number 0 43655
050628 17:29:14 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
050628 17:29:14 [ERROR] Can't start server: can't create PID file: No
such file or directory
050628 17:29:14 mysqld ended
How-To-Repeat:
[EMAIL PROTECTED] log]# cd /usr/local/mysql
[EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050628 17:53:10 mysqld ended
Fix:
I wish I knew
#I have verified (chgrp, chown) that mysql is the owner and group of
/usr/local/mysql/*
[EMAIL PROTECTED] lib]# ll -d /var/lib/mysql
drwx-- 4 mysql mysql 4096 Jun 28 17:53 /var/lib/mysql
[EMAIL PROTECTED] mysql]# pwd
/var/lib/mysql
[EMAIL PROTECTED] mysql]# ll
total 20532
-rw-rw 1 mysql root 2368 Jun 28 17:53 antest1.err
-rw-rw 1 mysql mysql 10485760 Jun 28 14:03 ibdata1
-rw-rw 1 mysql mysql 5242880 Jun 28 17:53 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Jun 28 14:03 ib_logfile1
drwx-- 2 mysql mysql 4096 Jun 28 14:00 mysql
srwxrwxrwx 1 mysql mysql0 Jun 28 17:53 mysql.sock
drwx-- 2 mysql mysql 4096 Jun 28 14:00 test
[EMAIL PROTECTED] run]# pwd
/var/run
[EMAIL PROTECTED] run]# ll -d mysql
drwxrwxrwx 2 mysql mysql 4096 Jun 28 16:58 mysql
NOTE ***
/var/run/mysql is empty. I tried creating the mysqld.pid
file (with mysql as owner and group) but still get the same problem.
Submitter-Id: submitter ID
Originator:Ralph J. Jackson 407.381.7797x568
Organization:
JHT, Inc.
MySQL support: none
Synopsis: mysqld refuses to continue to run.
Severity: critical
Priority: medium | high
Category: mysql
Class: support
Release: mysql-3.23.58 (Source distribution)
Environment:
machine, os, target, libraries (multiple lines)
System: Linux antest1 2.6.11-1.35_FC3 #1 Mon Jun 13 00:52:08 EDT 2005
i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.3/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checking --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-java-awt=gtk
--host=i386-redhat-linux
Thread model: posix
gcc version 3.4.3 20050227 (Red Hat 3.4.3-22.fc3)
Compilation info: CC='i386-redhat-linux-gcc' CFLAGS='-O2 -g -pipe -m32
-march=i386 -mtune=pentium4 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE' CXX='i386-redhat-linux-g++' CXXFLAGS='-O2 -g
-pipe -m32 -march=i386 -mtune=pentium4 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 24 10:23 /lib/libc.so.6 - libc-2.3.5.so
-rwxr-xr-x 1 root root 1505808 Apr 7 06:58 /lib/libc-2.3.5.so
-rw-r--r-- 1 root root 2409956 Apr 7 06:03 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 Apr 7 05:29 /usr/lib/libc.so
Configure command: ./configure '--build=i386-redhat-linux'
'--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu'
'--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr'
'--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc'
'--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib'
'--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--without-readline' '--without-debug'
'--enable-shared' '--with-extra-charsets=complex' '--with-bench'
'--localstatedir=/var/lib/mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb'
'--enable-local-infile' '--enable-large-files=yes'
'--enable-largefile=yes' '--with-berkeley-db'
'--enable-thread-safe-client' 'CFLAGS=-O2 -g -pipe -m32 -march=i386
-mtune=pentium4 -D_GNU_SOURCE
