Hmm very puzzling. 0.99.6 - compiled as follows: ./configure --with-postgres-libraries=/usr/lib/pgsql --with-postgres-includes=/usr/include/pgsql --with-python=/usr/bin/python2.1 --with-mxdatetime-includes=../egenix-mx-base-2.0.2/mx/DateTime/mxDateTime BTW - to compile with that version of psycopg and the egenix package: diff -r psycopg-0.99.6/config.h.in psycopg-0.99.6-orig/config.h.in 4c4 < #define MXDATETIME_API_MODULE "mx.DateTime" ---
#define MXDATETIME_API_MODULE "mxDateTime"
Python is: [root@hdb /tmp]# python2 Python 2.1.1 (#1, Aug 20 2001, 14:54:12) [GCC 2.96 20000731 (Red Hat Linux 7.1 2.96-85)] on linux2 Type "copyright", "credits" or "license" for more information. recompiled source RPM from the Python web site. Is it worth me running an --enable-devel version? What overhead is there? Regards, Phil +------------------------------------------+ | Phil Mayers | | Network & Infrastructure Group | | Information & Communication Technologies | | Imperial College | +------------------------------------------+ -----Original Message----- From: Federico Di Gregorio [mailto:fog@mixadlive.com] Sent: 19 September 2001 18:03 To: Mayers, Philip J Cc: 'psycopg@lists.initd.org'; 'zope@zope.org' Subject: Re: [Psycopg] Zope crashing On Wed, 2001-09-19 at 18:59, Mayers, Philip J wrote:
I'm still seeing periodic/sporadic crashes of my Zope installation, and it's getting *REALLY* annoying :o)
I sometimes get a core file (if I'm lucky) whose backtrace normally reads:
Program terminated with signal 11, Segmentation fault. <snip> #0 0x401364fe in __select () from /lib/libc.so.6 (gdb) bt #0 0x401364fe in __select () from /lib/libc.so.6 #1 0x4031708c in __DTOR_END__ () from /usr/lib/libpq.so.2 #2 0x4030ecad in PQgetResult () from /usr/lib/libpq.so.2 #3 0x4030ee1c in PQexec () from /usr/lib/libpq.so.2 #4 0x402f9acb in curs_switch_autocommit () from /usr/lib/python2.1/site-packages/psycopgmodule.so #5 0x402fa0e8 in curs_switch_autocommit () from /usr/lib/python2.1/site-packages/psycopgmodule.so
this is _strange_ because ZPsycopgDA *does* *not* support autocommit and there is no way to enable it while using psycopg with Zope. [snip]
#32 0x8058aef in PyEval_CallObjectWithKeywords () <etc down to 138>
Note the depth of the call stack...
noted.
Is this a problem with psycopg or Zope? Is anyone else seeing it? I'm unable to repro these consistently even under high load, which leads me to think there's an edge case coming into play here - but I don't know what. With -M logging turned on and using requestprofiler, I see:
sincerely i don't know. i am running some SQL Methods right now (with an --enble-devel compiled psycopg) and curs_switch_autocommit() does not get called. what version of zope/psycopg are you using? how have you compiled it? thank you for the report, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org 99.99999999999999999999% still isn't 100% but sometimes suffice. -- Me