Dear Peter!
I searched the group based your suggestion, and I found some information about ping the mysql server repetitive but no information about closing a connection. Also looked the documentation and no information about closing the connection. I tryed sql.close() => sql.close is not a function and sql.disconnect() the result the same. How can I close the mysql connection? I tested, if I remove all the script which is related to mysql, then the app is ok, so you right! Thank you for your help, Sándor 2015. április 28., kedd 4:32:19 UTC+2 időpontban [email protected] a következőt írta: > > Hi Sa'ndor > > I think that this is caused by a mysql timeout. > > Alternative you could: > * use setInterval with a dummy statement to keep the connection alive. > There is a thread on the newsgroup 'somewhere'. > * connect and close the connection with every CMD that needs it > * use onError event and/or the errorNumber parameter in the query > callback to reconnect > * set the mysql timeout for idle connections in my.cnf to something > higher. > > I hope this helps. > > Peter > > Sándor Volenszki schreef op 2015-04-27 22:47: > > Hi again! > > > > I finished the rewrite of my code, now operte only with APE and MYSQL > > from server side JS (no AJAX to PHP). It works like a charm! > > > > But now, after a few (aprox.: 20-25 request.send) everything stops to > > work, and in the log i can see this: > > > > 2015-04-27 22:39:23 - src/sock.c:293 - events_poll() : Interrupted > > system call > > 2015-04-27 22:39:33 - src/entry.c:188 - APE starting up - pid : 8102 > > 2015-04-27 22:39:33 - src/entry.c:251 - Starting daemon > > > > After this nothing works until a sudo /etc/init.d/ape-server restart > > > > What do you think is it an APE server effect, or caused by my code? > > > > Thanx in advice, > > Sándor > > > > -- > > -- > > You received this message because you are subscribed to the Google > > Groups "APE Project" group. > > To post to this group, send email to [email protected] > <javascript:> > > To unsubscribe from this group, send email to > > [email protected] <javascript:> > > For more options, visit this group at > > http://groups.google.com/group/ape-project?hl=en [1] > > --- > > APE Project (Ajax Push Engine) > > Official website : http://www.ape-project.org/ [2] > > Git Hub : http://github.com/APE-Project/ [3] > > > > --- > > You received this message because you are subscribed to the Google > > Groups "APE Project" group. > > To unsubscribe from this group and stop receiving emails from it, > > send an email to [email protected] <javascript:> [4]. > > For more options, visit https://groups.google.com/d/optout [5]. > > > > > > Links: > > ------ > > [1] http://groups.google.com/group/ape-project?hl=en > > [2] http://www.ape-project.org/ > > [3] http://github.com/APE-Project/ > > [4] mailto:[email protected] <javascript:> > > [5] https://groups.google.com/d/optout > > -- -- You received this message because you are subscribed to the Google Groups "APE Project" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/ape-project?hl=en --- APE Project (Ajax Push Engine) Official website : http://www.ape-project.org/ Git Hub : http://github.com/APE-Project/ --- You received this message because you are subscribed to the Google Groups "APE Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
