Since 020606 mysql has been crashing and then I have to manually
restart.
The error log is below:
020607 00:46:27 mysqld started
/usr/contrib/libexec/mysqld: ready for connections
020607 19:30:58 mysqld restarted
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exists at Fri Jun 7 19:31:14 MDT 2002
A mysqld process already exists at Sat Jun 8 09:00:35 MDT 2002
020608 09:01:30 mysqld started
/usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13)
020608 9:01:31 Could not use doctor.log for logging (error 0)
/usr/contrib/libexec/mysqld: ready for connections
Status information:
Current dir: /usr/contrib/var/
Current locks:
lock: 8a259d4:
lock: 8a5b1d4:
lock: 89e91e0:
lock: 8a1d9d4:
lock: 8a0d1d4:
lock: 8a2e1d4:
lock: 8a039d4:
lock: 8a261d4:
lock: 8a529d4:
lock: 8a32dd4:
lock: 8a739d4:
lock: 8a521d4:
lock: 8a5fdd4:
lock: 8a549d4:
lock: 81e09d4:
lock: 81e1dd4:
lock: 8a731d4:
lock: 8a541d4:
lock: 8a2d9d4:
lock: 8a671d4:
lock: 8a001d4:
lock: 8a311d4:
lock: 8a0a5d4:
lock: 8a359d4:
lock: 89fb9d4:
lock: 8a30de0:
lock: 8a885e0:
lock: 8a151e0:
lock: 89f0de0:
lock: 8a4a9e0:
lock: 8a911e0:
lock: 8a349e0:
lock: 81e01e0:
lock: 8a859e0:
lock: 8a081d4:
lock: 8a8b1d4:
lock: 89fc9d4:
lock: 89fc1d4:
lock: 89e99d4:
lock: 8a5a9d4:
lock: 8a5a1d4:
lock: 8a591d4:
lock: 8a0a9d4:
lock: 8a01dd4:
lock: 8a0a1d4:
lock: 89fe1d4:
lock: 8a689d4:
lock: 8a4e9d4:
lock: 8a8d9d4:
lock: 8a639d4:
lock: 8a459d4:
lock: 8a471d4:
lock: 8a3a9d4:
lock: 8a3d1d4:
lock: 8a7a5d4:
lock: 8a091d4:
lock: 8a3b1d4:
lock: 8a64dd4:
lock: 8a1c5d4:
key_cache status:
blocks used: 990
not flushed: 0
w_requests: 1805
writes: 1704
r_requests: 99548
reads: 973
handler status:
read_key: 2944
read_next: 2843694
read_rnd 340282
read_first: 658
write: 3299360
delete 57
update: 107
Table status:
Opened tables: 510
Open tables: 61
Open files: 120
Open streams: 0
020609 05:28:08 mysqld restarted
/usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13)
020609 5:28:08 Could not use doctor.log for logging (error 0)
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exists at Sun Jun 9 05:28:27 MDT 2002
020609 13:07:46 mysqld restarted
/usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13)
020609 13:07:46 Could not use doctor.log for logging (error 0)
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exists at Sun Jun 9 13:10:23 MDT 2002
Questions and fixes needed. Running mysql 3.23.49
--
contact:
Dave Yadallee NetKnow The Internet Knowledge Company
root@stripped http://www.nl2k.ab.ca
990-3244