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 >> Webware-devel@lists.sourceforge.net >> 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 Webware-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-devel