----- Original Message ----- From: <tonylabarbara at aol.com> To: <zope at zope.org> Sent: Saturday, July 14, 2007 5:43 PM Subject: [Zope] Problem w/ ZMySQLDA
Hi; ? I just built out a new server and transfered my databases. I use Zope to server my web sites and ZMySQLDA to interface between the two. Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this?
You should have a MySQL_database_connection object in a folder somewhere (in the ZMI).? The "Status" for this object should say "The database connection is open".? There is a "Test" tab for this object in which you can enter an sql query. If this query works ok, then the next step is to test your Z SQL Method(s).
Thanks. That clarified a lot. The MySQL query comes back fine. I'm troubleshooting a complex shop I had a programmer who worked for me build...so it's not my code...and it's complex ;) I went into the shopkeeper's side and was able to successfully query the database. I was, for example, able to display the "cotton" products for editing. However, when I do essentially_the_same_thing TTW with the following code snippet, it hangs! <tal:block metal:define-macro="content" ?????????? define="dummy python:request.set('category', 5)"> ? <tal:block metal:use-macro="here/Store/Main_frame_content/macros/content" /> </tal:block> Furthermore, mytop shows the user is hanging: ???? 30 mysqluser?????? localhost mrtableclo?????? 473? Sleep What should I do next to troubleshoot this? TIA, Tony ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.
----- Original Message ----- From: <tonylabarbara@aol.com> To: <zope@zope.org> Sent: Monday, July 16, 2007 8:55 AM Subject: [Zope] Problem w/ ZMySQLDA
----- Original Message ----- From: <tonylabarbara at aol.com> To: <zope at zope.org> Sent: Saturday, July 14, 2007 5:43 PM Subject: [Zope] Problem w/ ZMySQLDA
Hi; ? I just built out a new server and transfered my databases. I use Zope to server my web sites and ZMySQLDA to interface between the two. Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this?
You should have a MySQL_database_connection object in a folder somewhere (in the ZMI).? The "Status" for this object should say "The database connection is open".? There is a "Test" tab for this object in which you can enter an sql query. If this query works ok, then the next step is to test your Z SQL Method(s).
Thanks. That clarified a lot. The MySQL query comes back fine. I'm troubleshooting a complex shop I had a programmer who worked for me build...so it's not my code...and it's complex ;) I went into the shopkeeper's side and was able to successfully query the database. I was, for example, able to display the "cotton" products for editing. However, when I do essentially_the_same_thing TTW with the following code snippet, it hangs!
<tal:block metal:define-macro="content" ?????????? define="dummy python:request.set('category', 5)">
? <tal:block metal:use-macro="here/Store/Main_frame_content/macros/content" />
</tal:block>
Furthermore, mytop shows the user is hanging: ???? 30 mysqluser?????? localhost mrtableclo?????? 473? Sleep
What should I do next to troubleshoot this?
I would test the code outside of tal. Just execute (test) the routine by itself to see what it is returning. A couple of things to check: (i) is the routine receiving the correct input parameters, (ii) is the routine returning what you are expecting. Jonathan
Forgive my ignorance, but not quite sure how to do that. Nonetheless... 1) There was no problem with any of this on the old server until the server crashed. 2) My backups were?taken from a time when the old server was was working fine. 3) This problem occurs with *all* my shopping carts, not just this one. Consequently, I have a hard time believing this is a code error. There *must* be something more fundamental at play here. I had some problems with the python-eggs, but I don't imagine that's it, since the connection works, I can query the database, etc. TIA, Tony -----Original Message----- From: Jonathan <dev101@magma.ca> To: zope@zope.org; tonylabarbara@aol.com Sent: Mon, 16 Jul 2007 9:12 am Subject: Re: [Zope] Problem w/ ZMySQLDA ----- Original Message ----- From: <tonylabarbara@aol.com>? To: <zope@zope.org>? Sent: Monday, July 16, 2007 8:55 AM? Subject: [Zope] Problem w/ ZMySQLDA? ?
? ----- Original Message ----- > From: <tonylabarbara at aol.com>? To: <zope at zope.org>? Sent: Saturday, July 14, 2007 5:43 PM? Subject: [Zope] Problem w/ ZMySQLDA? ? ?
Hi;? ? I just built out a new server and transfered my databases. I use Zope >> > to? server my web sites and ZMySQLDA to interface between the two. >> > Everything? seems? to be fine. I can see the databases, the tables, the columns in the? tables, the? permissions are correct, etc. I hook up ZMySQLDA and that seems to be? fine. It? connects to the database. However, when I go to look at the pages from? served? the database, the browser hangs. Any ideas how to troubleshoot this?? ? You should have a MySQL_database_connection object in a folder somewhere >> (in? the ZMI).? The "Status" for this object should say "The database >> connection? is open".? There is a "Test" tab for this object in which you can enter >> an? sql query. If this query works ok, then the next step is to test your Z >> SQL? Method(s).? ? Thanks. That clarified a lot. The MySQL query comes back fine. I'm > troubleshooting a complex shop I had a programmer who worked for me > build...so it's not my code...and it's complex ;) I went into the > shopkeeper's side and was able to successfully query the database. I was, > for example, able to display the "cotton" products for editing. However, > when I do essentially_the_same_thing TTW with the following code snippet, > it hangs!? ? <tal:block metal:define-macro="content"? ?????????? define="dummy python:request.set('category', 5)">? ? ? <tal:block > metal:use-macro="here/Store/Main_frame_content/macros/content" />? ? </tal:block>? ? Furthermore, mytop shows the user is hanging:? ???? 30 mysqluser?????? localhost mrtableclo?????? 473? Sleep? ? What should I do next to troubleshoot this?? ? I would test the code outside of tal. Just execute (test) the routine by itself to see what it is returning. A couple of things to check: (i) is the routine receiving the correct input parameters, (ii) is the routine returning what you are expecting.? ? Jonathan ?
________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.
tonylabarbara@aol.com wrote:
Forgive my ignorance, but not quite sure how to do that. Nonetheless... 1) There was no problem with any of this on the old server until the server crashed. 2) My backups were taken from a time when the old server was was working fine. 3) This problem occurs with *all* my shopping carts, not just this one. Consequently, I have a hard time believing this is a code error. There *must* be something more fundamental at play here.
Code and configuration often interact. You may find that one or the other was fragile. --jcc
I had some problems with the python-eggs, but I don't imagine that's it, since the connection works, I can query the database, etc. TIA, Tony
-----Original Message----- From: Jonathan <dev101@magma.ca> To: zope@zope.org; tonylabarbara@aol.com Sent: Mon, 16 Jul 2007 9:12 am Subject: Re: [Zope] Problem w/ ZMySQLDA
----- Original Message ----- From: <tonylabarbara@aol.com <mailto:tonylabarbara@aol.com>> To: <zope@zope.org <mailto:zope@zope.org>> Sent: Monday, July 16, 2007 8:55 AM Subject: [Zope] Problem w/ ZMySQLDA
----- Original Message ----- > From: <tonylabarbara at aol.com> To: <zope at zope.org> Sent: Saturday, July 14, 2007 5:43 PM Subject: [Zope] Problem w/ ZMySQLDA
Hi; ? I just built out a new server and transfered my databases. I use
Zope >> > to
server my web sites and ZMySQLDA to interface between the two. >> Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this?
You should have a MySQL_database_connection object in a folder somewhere >> (in the ZMI).? The "Status" for this object should say "The database >> connection is open".? There is a "Test" tab for this object in which you can enter >> an sql query. If this query works ok, then the next step is to test your Z >> SQL Method(s).
Thanks. That clarified a lot. The MySQL query comes back fine. I'm > troubleshooting a complex shop I had a programmer who worked for me > build...so it's not my code...and it's complex ;) I went into the > shopkeeper's side and was able to successfully query the database. I was, > for example, able to display the "cotton" products for editing. However, > when I do essentially_the_same_thing TTW with the following code snippet, > it hangs!
<tal:block metal:define-macro="content" ?????????? define="dummy python:request.set('category', 5)">
? <tal:block > metal:use-macro="here/Store/Main_frame_content/macros/content" />
</tal:block>
Furthermore, mytop shows the user is hanging: ???? 30 mysqluser?????? localhost mrtableclo?????? 473? Sleep
What should I do next to troubleshoot this?
I would test the code outside of tal. Just execute (test) the routine by itself to see what it is returning. A couple of things to check: (i) is the routine receiving the correct input parameters, (ii) is the routine returning what you are expecting.
-- Connexions http://cnx.org "Building Websites with Plone" http://plonebook.packtpub.com
tonylabarbara@aol.com wrote:
Forgive my ignorance, but not quite sure how to do that. Nonetheless... 1) There was no problem with any of this on the old server until the server crashed. 2) My backups were taken from a time when the old server was was working fine.
Did you ever check these backups? We are talking mySQL here which has a lot of nasty bugs regarding reliability.
3) This problem occurs with *all* my shopping carts, not just this one. Consequently, I have a hard time believing this is a code error. There *must* be something more fundamental at play here.
From what you wrote further down it looks like a threading issue with the mysqlda. You would have to write a test case to isolate it. Easiest if you set thread number in zope to 1 and test. This should work similar to single threaded application. Regards Tino
participants (5)
-
J Cameron Cooper -
Jonathan -
Maciej Wisniowski -
Tino Wildenhain -
tonylabarbara＠aol.com