Sinisa,
SM> > These are daemon programs ... not exiting. I've about 10 programs
SM> > initialising a connection and then looping, doing some updates on
SM> > table while receiving data from another input.
SM> >
SM> > The schema is :
SM> >
SM> > 1. Connecting to Mysql
SM> > 2. reading data (from a file for example)
SM> > 3. updating Mysql table
SM> > 4. if any error, do a mysql_ping() in order to re-connect if
SM> > disconnected
SM> > 5. loop to 2.
SM> >
SM> > SM> Also, please try our 2.7 binary, just to rule out build problmes.
SM> >
SM> > I will try now.
SM> >
SM> > Alex.
SM> >
SM> >
SM> >
SM> Well, the above provides some more light !
SM> Increase wait timeout to some HUGE value. Same for net_read_timeout
SM> and net_write_timeout.
SM> Also, if signal 14 happens again check if the corresponding daemon is
SM> still running.
I incremented net_read_timeout and net_write_timeout each to 600 :
> mysqladmin var
...
| net_buffer_length | 16384 |
| net_read_timeout | 600 |
| net_retry_count | 10 |
...
But I still have some signal 14 just 7 seconds after Mysql is run.
As timeouts are set to 600, the first messages should appear after
at least 600 seconds isn't it ? (is net timeouts are the pb).
010321 14:40:46 mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
010321 14:40:53 Warning: Got signal 14 from thread 8
010321 14:40:55 Warning: Got signal 14 from thread 5
010321 14:40:57 Warning: Got signal 14 from thread 4
010321 14:41:03 Warning: Got signal 14 from thread 8
010321 14:41:05 Warning: Got signal 14 from thread 5
010321 14:41:07 Warning: Got signal 14 from thread 8
010321 14:41:09 Warning: Got signal 14 from thread 4
010321 14:41:11 Warning: Got signal 14 from thread 5
010321 14:41:13 Warning: Got signal 14 from thread 4
010321 14:41:15 Warning: Got signal 14 from thread 5
010321 14:41:17 Warning: Got signal 14 from thread 4
010321 14:41:19 Warning: Got signal 14 from thread 4
010321 14:41:25 Warning: Got signal 14 from thread 5
010321 14:41:27 Warning: Got signal 14 from thread 8
Alex.
---------------------------------------------------------------------
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
