Yes the cause is cx_Oracle. I have installed version 4.4 of the module,
that is the last. the code of the method is very simple, and i report it
as well:
### CODE START ###
def getLoS(self, panel_id):
try:
connection = cx_Oracle.connect(self.oracle_vms_dsn)
cursor = connection.cursor()
sql = "select statodiag, diagnosticaled from
pannelli where nome='" + panel_id +"'"
cursor.execute(sql)
r = cursor.fetchall()
cursor.close()
if r[0][0] >= 10000:
return 0.0
else:
tot = len(r[0][1])
ok = r[0][1].count('?')
return float("%1.2f" %
(float(ok)/float(tot)))
except cx_Oracle.Error:
raise Fault(802, 'Database error: ' +
str(sys.exc_info( )[1]))
except Exception, e:
raise Fault(801, 'Exception: ' + e.args[0] )
### CODE END ###
Did you notice something strange in this? Am I makeing some mistakes?
Thanks for your support.
Damiano Morosi ha scritto:
> Hi,
>
> thanks for your suggestions. The only thing prensent in
> /var/log/messages are the following lines:
>
> Jul 9 15:25:14 fe-oracle VMS: failed
> Jul 9 15:25:14 fe-oracle VMS: succeeded
> Jul 9 15:28:53 fe-oracle VMS: failed
> Jul 9 15:28:53 fe-oracle VMS: succeeded
> Jul 9 15:59:47 fe-oracle VMS: failed
> Jul 9 15:59:47 fe-oracle VMS: succeeded
>
> and I don't know what they mean, seems like the service fail and then
> succeed each time. Now I'll try to comment out the oracle module and
> 'fake' the connection to db to determine if this is the cause.
> Thanks for your support, I'll keep you informed!
>
> Ben Parker ha scritto:
>> That looks like the os might have killed the process. Check your syslogs
>> - did you exceed a memory limit?
>>
>> Damiano Morosi wrote on 7/9/08 7:31 AM:
>>> Hi all,
>>>
>>> I'm experimenting webware for the first time to use it in my enterprise.
>>> I've developed an XML-RPC service in Python (obviously!) that connect to
>>> an Oracle db, make some queries and return the results.
>>> Under medium usage (5-10 requests every 5 minutes), the webware app
>>> server kill himself and output the following:
>>>
>>> /home/xxx/yyy/AppServer: line 27: 14440 Killed
>>> $PYTHON$PY_OPTS Launch.py ThreadedAppServer $*
>>>
>>> these are the last lines of the activity log:
>>>
>>> 92.168.200.252,POST,/VMS/2/service.py,0,service,Wed Jul 9 16:10:54
>>> 2008,1.49,False
>>> 192.168.200.252,POST,/VMS/2/service.py,0,service,Wed Jul 9 16:10:54
>>> 2008,2.35,False
>>> 192.168.200.252,POST,/VMS/2/service.py,0,service,Wed Jul 9 16:10:54
>>> 2008,3.19,False
>>> 192.168.200.252,POST,/VMS/2/service.py,0,service,Wed Jul 9 16:10:54
>>> 2008,4.06,False
>>>
>>> while no trace of this error is reported in the errors log. Am I missing
>>> something? Thanks for your help,
>>>
>>>
>> -------------------------------------------------------------------------
>> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>> Studies have shown that voting for your favorite open source project,
>> along with a healthy diet, reduces your potential for chronic lameness
>> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>> _______________________________________________
>> Webware-devel mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/webware-devel
>>
>
--
Dott. Damiano Morosi
Atac S.p.A. - Agenzia per la Mobilità del Comune di Roma
Direzione Sistemi - Area Centrale della Mobilità
Sviluppo funzioni sistemiche della Centrale
00157 Roma - Via Ostiense, 131/L
Tel.: (+39) 0646959361
Mail: [EMAIL PROTECTED]
Skype: damiano.morosi
Web: http://www.atac.roma.it
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Webware-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/webware-devel
