It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible? -- Don't go to bed with no price on your head. -- Baretta
jiva@devware.com wrote:
It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible?
I don't know, I can't reproduce it. OTOH, I may not be doing the same thing you are. What version of Zope are you running? What database/version? What OS/HW/version? Can you provide the SQL methods that demonstrate the problem? Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
Does it actually crash or does it "spin" (consume all resources and not respond for 2-3 minutes)? I've been able to do this with a frameset that has empty frames, and wonder if it is the same sort of thing... At 8:33 PM +0000 12/7/99, Jim Fulton wrote:
jiva@devware.com wrote:
It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible?
I don't know, I can't reproduce it. OTOH, I may not be doing the same thing you are.
What version of Zope are you running? What database/version? What OS/HW/version?
Can you provide the SQL methods that demonstrate the problem?
Jim
# # # _____________________________________________ Joshua Brauer Box 915 http://www.brauer.org Fort Collins, CO 80522 Fax: (419) 793-4120 _____________________________________________ In flying I have learned that carelessness and overconfidence are usually far more dangerous than deliberately accepted risks. -- Wilbur Wright in a letter to his father, September 1900 ____________________________________________________
Jim Fulton wrote:
jiva@devware.com wrote:
It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible?
I don't know, I can't reproduce it. OTOH, I may not be doing the same thing you are.
What version of Zope are you running? What database/version? What OS/HW/version?
Can you provide the SQL methods that demonstrate the problem?
I had something similar when using the ./start as provided (with debug on) and trying to run it in background with & and ZPgSQLDA. The problem was with the DA writing its NOTICE's straight to stdout and thus producing a bad state. ------------------ Hannu
Hannu Krosing wrote:
Jim Fulton wrote:
jiva@devware.com wrote:
It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible?
I don't know, I can't reproduce it. OTOH, I may not be doing the same thing you are.
What version of Zope are you running? What database/version? What OS/HW/version?
Can you provide the SQL methods that demonstrate the problem?
I had something similar when using the ./start as provided (with debug on) and trying to run it in background with & and ZPgSQLDA. The problem was with the DA writing its NOTICE's straight to stdout and thus producing a bad state.
Sounds like a DA bug. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
FYI, turning off the -D flag didn't seem to make a difference. Short of getting my hands dirty with the DA, any other ideas on a solution? How did you ultimately fix it Hannu? On Tue, Dec 07, 1999 at 08:54:43PM +0000, Jim Fulton wrote:
Hannu Krosing wrote:
Jim Fulton wrote:
jiva@devware.com wrote:
It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible?
I don't know, I can't reproduce it. OTOH, I may not be doing the same thing you are.
What version of Zope are you running? What database/version? What OS/HW/version?
Can you provide the SQL methods that demonstrate the problem?
I had something similar when using the ./start as provided (with debug on) and trying to run it in background with & and ZPgSQLDA. The problem was with the DA writing its NOTICE's straight to stdout and thus producing a bad state.
Sounds like a DA bug.
Jim
-- Yow! I'm imagining a surfer van filled with soy sauce!
On second thought, I'll just email the DA author and see if I can help him fix it. Thanks. :) On Tue, Dec 07, 1999 at 08:54:43PM +0000, Jim Fulton wrote:
Hannu Krosing wrote:
Jim Fulton wrote:
jiva@devware.com wrote:
It would appear (and I have tested this on 3 machines now, 2 linux and 1 nt) that if I enter a ZSQL Query and then test it and get no resultset, that I crash the zope server?? How is this possible?
I don't know, I can't reproduce it. OTOH, I may not be doing the same thing you are.
What version of Zope are you running? What database/version? What OS/HW/version?
Can you provide the SQL methods that demonstrate the problem?
I had something similar when using the ./start as provided (with debug on) and trying to run it in background with & and ZPgSQLDA. The problem was with the DA writing its NOTICE's straight to stdout and thus producing a bad state.
Sounds like a DA bug.
Jim
-- When women kiss it always reminds one of prize fighters shaking hands. -- H.L. Mencken, "Sententiae"
On Tue, Dec 07, 1999 at 10:40:00PM +0200, Hannu Krosing wrote:
Jim Fulton wrote:
I had something similar when using the ./start as provided (with debug on) and trying to run it in background with & and ZPgSQLDA. The problem was with the DA writing its NOTICE's straight to stdout and thus producing a bad state.
Hannu
This is exactly the configuration I was using! I will try taking debug off to see if it makes it better. (I assume this is how you fixed it?) I am using Zope 2.1.0 ZPgSQLDA query of type: select * from blah with blah as an empty table. PS: I can't seem to get email from the Zope list unless it is cc'd to me, so if you respond, please cc me directly. -- No one can put you down without your full cooperation.
participants (4)
-
Hannu Krosing -
Jim Fulton -
jiva＠devware.com -
Joshua Brauer