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

>        Time            Id 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

>        Time            Id 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/

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to