When I say the process "disappears" it means it cannot be found with ps -aewff | grep service0 - just gone without a trace.
As for the log it is an exact snapshot except for the comment I added to explain how I am able to restart the service soon after. If the log did show something for those 74 second, I would be in a much better situation.
Further to Koala's findings, I have blocked Googlebot and MSNbot and the problem stops. Below is a snippet of the service log - so is there a link between robots and session_id which is killing the process?
Again, this is very specific to one particular service which is affected. The same code on another service does not have this problem ...
----- service log -----
207.46.98.61 - - [16/Nov/2005:18:25:41 +0800] "GET /public/contents/66874 HTTP/1.0" 302 378 "" "msnbot/1.0 (+http://search.msn.com/msnbot
.htm)" -
207.46.98.61 - - [16/Nov/2005:18:25:41 +0800] "GET /public/contents/news?revision%5fid=66863&item%5fid=66862 HTTP/1.0" 200 33535 "" "msnb
ot/1.0 (+http://search.msn.com/msnbot.htm)" -
202.181.201.153 - - [16/Nov/2005:18:25:42 +0800] "GET /forums/message-view?message_id=66170 HTTP/1.0" 500 27436 "" "Mozilla/5.0 (compatib
le; Googlebot/2.1; +http://www.google.com/bot.html)" -
192.168.10.31 - - [16/Nov/2005:18:25:46 +0800] "GET /SYSTEM/dbtest.tcl HTTP/1.0" 200 7 "" "Wget/1.9+cvs-stable (Red Hat modified)" -
192.168.10.31 - - [16/Nov/2005:18:26:01 +0800] "GET /SYSTEM/dbtest.tcl HTTP/1.0" 200 7 "" "Wget/1.9+cvs-stable (Red Hat modified)" -
207.166.200.211 - - [16/Nov/2005:18:26:38 +0800] "GET /public/uptime.html HTTP/1.0" 200 8 "" "AOLserver-Tcl/4.0" -
207.46.98.44 - - [16/Nov/2005:18:26:40 +0800] "GET /robots.txt HTTP/1.0" 200 388 "" "msnbot/1.0 (+http://search.msn.com/msnbot.htm)" -
207.46.98.44 - - [16/Nov/2005:18:26:41 +0800] "GET /public/contents/article?revision%5fid=65132&item%5fid=65131 HTTP/1.0" 200 36558 "" "m
snbot/1.0 (+http://search.msn.com/msnbot.htm)" -
192.168.10.31 - - [16/Nov/2005:18:26:46 +0800] "GET /SYSTEM/dbtest.tcl HTTP/1.0" 200 7 "" "Wget/1.9+cvs-stable (Red Hat modified)" -
202.181.201.153 - - [16/Nov/2005:18:26:46 +0800] "GET /public/contents/my_domain_name/public/contents/12742 HTTP/1.0" 302 410 "
" "Googlebot/2.1 (+http://www.google.com/bot.html)" -
---
[16/Nov/2005:18:26:48][31059.4123126704][-conn:service0::0] Notice: dbinit: sql(localhost:5431:service0): '
select property_value, secure_p
from sec_session_properties
where session_id = '59873219'
and module = 'acs-lang'
and property_name = 'translator_mode_p'
