Re: [Zope] zope sql_delimiter windows
Andreas Jung wrote:
Please read this:
If there had been anything else to send I would have. I thought the question was quite clear: Is there an issue with sql_delimiter on windows? There is nothing in the error log. There is nothing in the Event log. There is nothing in the Z2 log. Windows event log just says that Python.exe exited abnormally. I was quite clear on which versions of Zope had been tested. I gave the code which caused the crash. I have searched Google and I have searched the mailing list. My last resort is always to ask on this list simply because of the sort of answer you have just given. Regards Garry
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On 24. Dezember 2006 11:55:41 +0000 garry saddington <garry@schoolteachers.co.uk> wrote:
Andreas Jung wrote:
Please read this:
<http://opensource.zopyx.com/helpcenter/misc/writing-smart-and-reasonabl e-postings-or-how-to-use-a-mailinglist/view>
If there had been anything else to send I would have. I thought the question was quite clear: Is there an issue with sql_delimiter on windows?
When you mention a "crash" without given an explanation what "crash" means then it is legitimate to ask for a detailed explanation. A "crash" can mean all and nothing. You must be specific. - -aj -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (Darwin) iD8DBQFFjphkCJIWIbr9KYwRAnRuAJ0e3q0m06dkdNO48T8xM11ENvrp/ACePpMg gD1luXkHkYVuOQQyoEtaoIc= =QsF9 -----END PGP SIGNATURE-----
On Sun, 2006-12-24 at 16:10 +0100, Andreas Jung wrote:
-----BEGIN PGP SIGNED MESSAGE----- OK, sorry for the lack of info. What happens is that Zope stops responding when I fire off a ZSQL method containing a 'sql_delimiter' and then I get the standard Windows message: python.exe has encountered a problem and needs to close........etc. All I can say is that it has something to do with msvcr71.dll which is in the detail of the above error message. There is no other hint in any logs as to what is happening and when I close the above dialogue, Zope comes back to life and the offending ZSQL has not run. Only ZSQL methods which rely on sql_delimiter are affected. I have repeated the error on XP pro sp2 and XP home SP2 with Zope versions 2.8,.2.9 and 2.10 using the Pythons that ship with these versions (ie standard Windows installs). DA is psycopg2 and database is Postgresql. Any Ideas, can I provide any further information? Regards Garry
Only ZSQL methods which rely on sql_delimiter are affected. I have repeated the error on XP pro sp2 and XP home SP2 with Zope versions 2.8,.2.9 and 2.10 using the Pythons that ship with these versions (ie standard Windows installs). DA is psycopg2 and database is Postgresql. Any Ideas, can I provide any further information? Try to execute failing statement directly from python code (without Zope). You should find examples on psycopg pages/docs etc.
Looks for me that this may be a psycopg problem that is not connected with Zope. -- Maciej Wisniowski
I suspect it could have something to do with psycopg2. I remember while I was checking my application (which runs using psycopg1) that I could get a repeated segmentation fault while I run a test which used sql_delimiter. You could try to check on the psycopg2 ml. Regards Marco On 12/24/06, garry saddington <garry@schoolteachers.co.uk> wrote:
On Sun, 2006-12-24 at 16:10 +0100, Andreas Jung wrote:
-----BEGIN PGP SIGNED MESSAGE----- OK, sorry for the lack of info. What happens is that Zope stops responding when I fire off a ZSQL method containing a 'sql_delimiter' and then I get the standard Windows message: python.exe has encountered a problem and needs to close........etc. All I can say is that it has something to do with msvcr71.dll which is in the detail of the above error message. There is no other hint in any logs as to what is happening and when I close the above dialogue, Zope comes back to life and the offending ZSQL has not run. Only ZSQL methods which rely on sql_delimiter are affected. I have repeated the error on XP pro sp2 and XP home SP2 with Zope versions 2.8,.2.9 and 2.10 using the Pythons that ship with these versions (ie standard Windows installs). DA is psycopg2 and database is Postgresql. Any Ideas, can I provide any further information? Regards Garry
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Marco Bizzarri http://iliveinpisa.blogspot.com/
participants (4)
-
Andreas Jung -
garry saddington -
Maciej Wisniowski -
Marco Bizzarri