Re: [Webware-devel] Webware killed

2008-07-10 Thread Damiano Morosi
SOLVED: there was a problem in threading. It's been necessary to specify the following in the connection string: connection = cx_Oracle.connect(oracle_dsn, threaded=True) Adding the threaded=True parameter, the service is up & running from 14 hours, against the 5 minutes before. This should be

Re: [Webware-devel] Webware killed

2008-07-10 Thread Christoph Zwerschke
Damiano Morosi schrieb: > maybe a memory leak problem? my configuration is python 2.3.4, GCC > 3.4.6, kernel 2.6.9-67.0.20.EL. The dist is a CentOS, and the machine is > virtualized under VMWare. Compatibility issues? Yes, this looks like a memory allocation problem of cx_oracle; or there is an

Re: [Webware-devel] Webware killed

2008-07-10 Thread Damiano Morosi
OK all done, my script now is absolutely better (thanks for the suggestions), but the problem persists... However, I have another "piece" of the puzzle; when the error occurs, the system says: *** glibc detected *** free(): invalid pointer: 0x089ebc70 *** maybe a memory leak problem? my configu

Re: [Webware-devel] Webware killed

2008-07-10 Thread Christoph Zwerschke
Damiano Morosi schrieb: > Did you notice something strange in this? Am I makeing some mistakes? > Thanks for your support. Nothing that should cause the process to be killed. But there are some things you could improve to make everything more stable and secure: * make the code safe against SQL i

Re: [Webware-devel] Webware killed

2008-07-10 Thread Damiano Morosi
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

Re: [Webware-devel] Webware killed

2008-07-09 Thread Damiano Morosi
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:

Re: [Webware-devel] Webware killed

2008-07-09 Thread Ben Parker
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

Re: [Webware-devel] Webware killed

2008-07-09 Thread Jason Hildebrand
Hi Damiano, It appears that it could be a crash/segfault; I would recommend trying to determine whether that is the cause. In my experience using Webware (7 years), any crashes have been due to extension modules, and not to Webware itself. Make sure you are running current versions of extensio

[Webware-devel] Webware killed

2008-07-09 Thread Damiano Morosi
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 himse