Yes, thanks for mentioning that Frederico. I _should_ have said thats what I used in PoPy. I dont use it anymore with your product. : ), but that doesnt mean I'm any wiser for this. But *magic* is a highly used term in programming these days, so I'm not worried too much. At least I dont have unhappy customers anymore. Paz -----Original Message----- From: Federico Di Gregorio [mailto:fog@mixadlive.com] Sent: Thursday, July 12, 2001 3:30 PM To: Paul Zwarts Cc: Andre Schubert; steve@spvi.com; zope Subject: RE: [Zope-dev] Curiously Zope Hanging On 12 Jul 2001 15:20:16 +0200, Paul Zwarts wrote:
I've had this problem as well, although I changed from ZPopPy to psycopg0.99.4 which solved the problem. What I found in REdhat Linux 7.1, where the ps -ef command now queries more info from its children, I finally saw the status of my dbms threads. The Zope hanging maybe wasnt zope directly. It still translated requests BUT I saw in ps -ef:
postgresql db01 UPDATE waiting.....
This is where the hang is. Several emails from Dieter just confused me more. Something about Zope not having imlicit commits on transactions, so you had to make sure a <dtml-call transaction().commit()> was placed somehwere. This seemed to solve some problems at the time for me although I got alot of :
Warning: COMMIT, No transacion in progress
never, never, never do that with psycopg. psycopg cooperates with zope (that *does* commit on transactions) and has real transaction control. with zope+psycopg you'll get a commit (or abort) just at the end of the requested page. ciao, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org All'inizio ho scritto un programma proprietario, in esclusiva per il cliente; e mi ha succhiato un pezzo di anima. -- Alessandro Rubini