Heikki,

  I hope Sinisa will be able to find out the problem :)

  I   noticed   that  it  there  were 2 connections to the server. But
  I'm  sure  that  I've no process of my own connecting to the server.
  And another strange thing is that it's always the same connections:

==========================================================================
/usr/local/mysql/libexec/mysqld, Version: 3.23.35-debug-log, started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
010320 19:40:24       1 Connect     root@localhost on
                      1 Statistics
                      1 Quit
                      2 Connect     root@localhost on
                      2 Statistics
                      2 Quit
   < then crash >
==========================================================================

  Each  time  I  run  Mysql  and  wait  for  a while, I have these two
  connections and then crash.

  But as I said, I've no program of my own connecting to the server. I
  suppose these connections are from Mysql itself ...

  Sinisa ?

  Regards,
  Alex.

HT> I looked at the new debug log you sent and obviously some client is
HT> making connections to your server. This cannot come from
HT> Innobase, there must be some client process running on your machine.

HT> From the debug log I find the following:
HT> ...............................
HT> T@11   : info: handle_one_connection called by thread 1
HT> T@11   : info: check_connections called by thread 1

HT> ...<snip>........

T@11   : >>vio_read
HT> T@11   : | enter: sd=10, buf=5a48230, size=4
HT> T@11   : | error: Got error 11 during read
HT> T@11   : | exit: -1
HT> T@11   : <vio_read
HT> T@11   : info: vio_read returned -1,  errno: 11
T@11   : >>thr_alarm
HT> T@11   : | enter: thread: T@11  sec: 5
HT> T@11   : | info: reschedule
HT> T@11   : <thr_alarm
T@11   : >>vio_is_blocking
T@10   : | >>process_alarm
HT> T@10   : | | info: sig: 14 active alarms: 1
HT> T@11   : | exit: 0
HT> ...............................

HT> Obviously vio_read fails on an error 11, and then mysqld calls
HT> thr_alarm to produce signal 14.

HT> From /usr/include/sys/errno.h I find:

HT> #define EAGAIN  11      /* Resource temporarily unavailable     */

HT> Probably Sinisa can find out what is the problem here.

HT> Regards,

HT> Heikki




-----------------------------------------------------------------------
Alexandre BAUMEISTER                        Standard : +333-83-36-58-67
Email : [EMAIL PROTECTED]                Fax:       +333-83-36-69-44

FINANCE NET - 1,rue St Dizier 54000 NANCY - FRANCE (www.finance-net.fr)
-----------------------------------------------------------------------



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to