restarted
050125 12:14:53 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
050125 12:14:53 InnoDB: Flushing modified pages from the buffer pool...
050125 12:14:53 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23' socket: '/tmp/mysql.sock' port: 3306 Source
distribution
050125 12:41:43 mysqld restarted
050125 12:41:45 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
050125 12:41:45 InnoDB: Flushing modified pages from the buffer pool...
050125 12:41:45 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23' socket: '/tmp/mysql.sock' port: 3306 Source
distribution
050125 12:43:19 mysqld restarted
050125 12:43:19 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
050125 12:43:19 InnoDB: Flushing modified pages from the buffer pool...
050125 12:43:19 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23' socket: '/tmp/mysql.sock' port: 3306 Source
distribution
050125 12:44:00 mysqld restarted
050125 12:44:00 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
050125 12:44:00 InnoDB: Flushing modified pages from the buffer pool...
050125 12:44:00 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23' socket: '/tmp/mysql.sock' port: 3306 Source
distribution
050125 15:58:44 mysqld restarted
050125 15:58:45 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
050125 15:58:45 InnoDB: Flushing modified pages from the buffer pool...
050125 15:58:45 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23' socket: '/tmp/mysql.sock' port: 3306 Source
distribution
Hello.
What's in the error log? Usually it can be found in the data directory, if
another location wasn't specified in the config file or the command line
options. MySQL server was restared by the mysqld_safe script, through the
crash of mysqld process.
Alfredo Reynoso [EMAIL PROTECTED] wrote:
Hi, Im running MySQL 4.0.23 (build from source with skunkware gcc 2.95.2pl1
and a precompiled FSU-pthreads 3.5c) under SCO Openserver 5.0.4.
It runs great by itself, the problem comes when I make a program using the
C API, it restart mysqld the second (sometimes third) time I run my
program, so my program hangs expecting the answer from the already
finished mysqld.
Here is the example (a.out is my program):
# mysqld_safe --user=root --log
448
# Starting mysqld daemon with databases from /usr/local/mysql/var
# ps -u root
448 tty01 00:00:00 mysqld_safe
468 tty01 00:00:01 mysqld
# a.out
# ps -u root
448 tty01 00:00:00 mysqld_safe
468 tty01 00:00:01 mysqld
# a.out
050126 12:19:34 mysqld restarted
//Here it hangs until I press Ctrl + Pause
# ps -u root
448 tty01 00:00:00 mysqld_safe
480 tty01 00:00:01 mysqld
The output in hostname.log is the following:
/usr/local/mysql/libexec/mysqld, Version: 4.0.23-log, started
with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
TimeId Command Argument
050126 12:19:29 1 Connect[EMAIL PROTECTED] on
1 Quit
/usr/local/mysql/libexec/mysqld, Version: 4.0.23-log, started
with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
TimeId Command Argument
As you see, there is no message from the server that explains why does
mysqld restarted.
I've already googled for it, but there is no such case in the internet
material.
Can you help me?
Thanks.
_
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL General