|List:||General Discussion||« Previous MessageNext Message »|
|From:||BAUMEISTER Alexandre||Date:||March 21 2001 1:41pm|
|Subject:||Re: Warning: Got signal 14 from thread X|
|View as plain text|
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. If I had a thread on my daemons which executes a mysql_ping() each 30 secondes and increase net_read_timeout to 60 will it be ok ? Does a mysql_ping() reset net_read and net_write timer ? Alex.