I am new to APE and was able to get everything up and running and accomplished my project. My problem is my server dies over night, every night. I'm thinking it might be a SQL Server slow when its doing its backup, but APE/MySQL doesn't return or display any errors. Here is my log
2011-12-20 01:25:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 01:25:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 01:25:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 01:31:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 01:31:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 01:31:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 01:37:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 01:37:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 01:37:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 01:40:53 - libape-spidermonkey.c:2204 - JavaScript : 7061669 <= Old New => 7061748 2011-12-20 01:43:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 01:43:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 01:43:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 01:49:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 01:49:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 01:49:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 01:55:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 01:55:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 01:55:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 02:01:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 02:01:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 02:01:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 02:07:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 02:07:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 02:07:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 02:11:48 - libape-spidermonkey.c:2204 - JavaScript : 7061748 <= Old New => 7061831 2011-12-20 02:13:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 02:13:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 02:13:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 02:19:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 2011-12-20 02:19:33 - libape-spidermonkey.c:2204 - JavaScript : Fetching => 24 ROWS 2011-12-20 02:19:33 - libape-spidermonkey.c:2204 - JavaScript : SQL completed, calling back to send the new event 2011-12-20 02:25:33 - libape-spidermonkey.c:2204 - JavaScript : Refresh using date => 2011-12-20 I use to run a JETTY - Comet server on the machine so in the past I had to increase my time out on the connections for MYSQL. This machine doesn't do much so having it keep a MySQL connection open for an hour is not a problem. But in my case a MySQL called is made at least every 5 seconds, So I know the connection isn't timing out. I have two threads one is just pumping out events every 15 seconds of the up coming events for my site, in the case above there are 24 events its indexing though, MySQL is called the list is saved in memory and the thread puts out an event every 15 seconds down the channel. My second thread checks a table in the database for updates every 5 seconds, If there have been updates it will send a Raw message down my Update channel. It all works, but sometime during the night APE dies, no message in the log. I'm looking for any more or other debugging I can turn on to locate what the issue is. Thanks Andy -- You received this message because you are subscribed to the Google Groups "APE Project" group. To post to this group, send email to ape-project@googlegroups.com To unsubscribe from this group, send email to ape-project+unsubscr...@googlegroups.com 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/
