- Zope - Zope lists

"error: release unlocked lock" with Zope/MySQL
by Dennis Allison 07 Aug '05

07 Aug '05

[Reposted with a non-blank Subject field] We've been seeing this problem for some time. Earlier postings to the list were helpful in that we have eliminated possible causes, but the problem has never been resolved. Any assistance in tracking down the problem and fixing it would be greatly appreciated. Our configuration: Athlon dual processor machine RH7.3 Zope 2.7.6 with ZEO Python 2.4.1 (same problem occurs with Python 2.3.5) Mysql-Python 1.21.c3 ZMySQLDA 2.09b3 MySql-4.0.20 This is a fragment from the event log: 2005-06-07T16:06:42 ERROR(200) ZMySQLDA exception during _begin Traceback (most recent call last): File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 349, in _begin self.db.ping() OperationalError: (2013, 'Lost connection to MySQL server during query') ------ 2005-06-07T16:06:42 PANIC(300) ZODB A storage error occurred in the last phase of a two-phase commit. This shouldn't happen. The application will not be allowed to commit until the site/storage is reset by a restart. Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 377, in _finish_many jar.tpc_finish(self) File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 59, in tpc_finish try: self._finish() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 376, in _finish self._tlock.release() error: release unlocked lock ------ 2005-06-07T16:06:42 ERROR(200) ZODB A storage error occured during object abort. This shouldn't happen. Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 412, in _commit_error j.tpc_abort(self) # This should never fail File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 63, in abort try: self._abort() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort self._tlock.release() error: release unlocked lock ------ 2005-06-07T16:06:42 ERROR(200) SiteError http://dev.agilemind.com/logged_in Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZPublisher/Publish.py", line 107, in publish transactions_manager.commit() File "/usr/local/src/zope/Zope2.7/l[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.------ 2005-08-06T20:47:21 ERROR(200) ZMySQLDA exception during _begin Traceback (most recent call last): File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 349, in _begin self.db.ping() OperationalError: (2013, 'Lost connection to MySQL server during query') ------ We get the "release unlocked lock" message occasionally, frequently but not always preceded by the connection lost message. Our my.cnf file for MySQL is [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb set-variable=max_connections=2048 set-variable=long_query_time=1 #log-bin=/var/log/mysql/epaul-bin #log-bin-index=/var/log/mysql/epaul-bin.index #log-slow-queries=/var/log/mysql/epaul-slow.log # change timeouts to close rather than wait # interactive == 1 hour, programs == 5 mins set-variable=interactive_timeout=3600 set-variable=wait_timeout=300 # uncomment to not log connection problems #set-variable=log-warnings=off [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid We use MyISAM tables and the MySQL autocommit mode rather than handling locks and transactions explicitly. >From a user perspective, refreshing the Zope page recovers from the error and allows one to continue working. _______________________________________________ Zope maillist - Zope(a)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 )

1 0

(no subject)
by Dennis Allison 07 Aug '05

07 Aug '05

We've been seeing this problem for some time. Earlier postings to the list were helpful in that we have eliminated possible causes, but the problem has never been resolved. Any assistance in tracking down the problem and fixing it would be greatly appreciated. Our configuration: Athlon dual processor machine RH7.3 Zope 2.7.6 with ZEO Python 2.4.1 (same problem occurs with Python 2.3.5) Mysql-Python 1.21.c3 ZMySQLDA 2.09b3 MySql-4.0.20 This is a fragment from the event log: 2005-06-07T16:06:42 ERROR(200) ZMySQLDA exception during _begin Traceback (most recent call last): File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 349, in _begin self.db.ping() OperationalError: (2013, 'Lost connection to MySQL server during query') ------ 2005-06-07T16:06:42 PANIC(300) ZODB A storage error occurred in the last phase of a two-phase commit. This shouldn't happen. The application will not be allowed to commit until the site/storage is reset by a restart. Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 377, in _finish_many jar.tpc_finish(self) File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 59, in tpc_finish try: self._finish() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 376, in _finish self._tlock.release() error: release unlocked lock ------ 2005-06-07T16:06:42 ERROR(200) ZODB A storage error occured during object abort. This shouldn't happen. Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 412, in _commit_error j.tpc_abort(self) # This should never fail File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 63, in abort try: self._abort() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort self._tlock.release() error: release unlocked lock ------ 2005-06-07T16:06:42 ERROR(200) SiteError http://dev.agilemind.com/logged_in Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZPublisher/Publish.py", line 107, in publish transactions_manager.commit() File "/usr/local/src/zope/Zope2.7/l[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.------ 2005-08-06T20:47:21 ERROR(200) ZMySQLDA exception during _begin Traceback (most recent call last): File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 349, in _begin self.db.ping() OperationalError: (2013, 'Lost connection to MySQL server during query') ------ We get the "release unlocked lock" message occasionally, frequently but not always preceded by the connection lost message. Our my.cnf file for MySQL is [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb set-variable=max_connections=2048 set-variable=long_query_time=1 #log-bin=/var/log/mysql/epaul-bin #log-bin-index=/var/log/mysql/epaul-bin.index #log-slow-queries=/var/log/mysql/epaul-slow.log # change timeouts to close rather than wait # interactive == 1 hour, programs == 5 mins set-variable=interactive_timeout=3600 set-variable=wait_timeout=300 # uncomment to not log connection problems #set-variable=log-warnings=off [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid We use MyISAM tables and the MySQL autocommit mode rather than handling locks and transactions explicitly. >From a user perspective, refreshing the Zope page recovers from the error and allows one to continue working.

1 0

MVC Approach
by Thomas Adams 06 Aug '05

06 Aug '05

Hi all, I'm a newbie to Zope, using version 2.7.3 (okay it is not the newest one) and I want to know if there is something like a MVC approach available for Zope, i.e. Model-View-Controller approach, as it is for instance in Java with the Struts framework from Apache. To be more specific: - The Model consists of several python classes implementing business logic (the pendant to Enterprise Java Beans or simple Java Beans) - The Views producing the visual appearance of the business objects (in java or more specific in Struts these are the custom tag libraries) - The Controller, as a kind of glue between the two above, is controlling the work/process-flow (in java with servlets and in struts with actions classes (as a minimum) ) To transfer this appraoch to Zope, I'm not sure: Views: DTML-Document and/or DTML-Methods? Controller: PythonScripts? Models: I'm absolutely not sure, Pluggable brains? (the Zope book has a example but only as a handling of resultsets) So if has anybody a hint if there are some resources in the web, please post it. P.S: I don't know Zope 3 (Is that apossible answer of my questions?) Thasnks in advance Regards Thomas Adams

4 3

Large file support
by Pascal Peregrina 06 Aug '05

06 Aug '05

Hi, I would like to know the steps to achieve (compilation flags, etc) in order to enable >2G ZODB file support. I use Zope 2.8.0 and python 2.3.5 on linux 2.4 (about to migrate to linux 2.6) Thanks Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

2 1

RE: [Zope] Data.fs Windows to Linux?
by Pascal Peregrina 06 Aug '05

06 Aug '05

I had a similar issue when playing with Data.fs files, and I found that it was a write permission issue on the file. Don't know if it can help you in that case. Pascal -----Original Message----- From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On Behalf Of Marc Schnapp Sent: 06 August 2005 01:14 To: zope(a)zope.org Subject: [Zope] Data.fs Windows to Linux? I thought that I would back up my data.fs by copyting the entire Linux /var directory to a Windows machine with spare disk space and then creating a ZIP file on the Windows machine. There was a problem on the Linux machine, so I figured there'd be no problem by simply copying the data.fs (via a Samba share) back from Windows -> Linux. It seems that when Zope starts back up, it keeps attempting to deal with the "alien" database and then shuts down. The Same Database File Works Perfectly With A Windows Plone/Zope Installation ---------------------------------------------------------------------------- --------------------- I installed a Windows version of Plone (with Zope of course) and that same data.fs file works just fine in the Windows environment. Questions: ------------ 1) Am I without hope of ever running the database under Linux again? 2) What is the reason that the database goes from Linux -> Windows OK but not in the other direction? 3) MOST IMPORTANT: Is there a technique I can use to tweak the database file or recover it so that it is Linux-friendly? _______________________________________________ Zope maillist - Zope(a)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 ) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

1 0

Speed Problems with IE6 on German Version of Windows XP Pro SP2
by Neil Vaidya 05 Aug '05

05 Aug '05

Hello All, Has anyone come across any problems with their site or a site using Zope, specifically with Plone, when browsing using IE6? Whenever someone from our German office tries to access our sites, the localized sites or the main .COM site they are running into a problem where it will take easily 1 minute or more to load the page, this is occuring about 50% of the time when they try to go to a page on our site. They are using the German version of Microsoft Windows XP Pro SP2 with IE6. This problem only seems to occur when using IE6 because they installed Firefox and their was no problem. They tried a Windows 2000 machine then with IE6 and it had no problems at all. It appears that somehow the German version of IE6 on XP Pro SP2 is having some sort of problem. Sites Include: http://www.keithley.com http://www.keithley.de I have tried to replicate the problem or issue here at our main office in Cleveland but on all of our computers installed with the standard US English version of XP Pro SP2, Windows 2000, Windows 98, and Mac OS X I can not come across the same problem. Has anyone seenm heard of this problem before, or have an idea of what the cause or a solution might be? Thanks in advance for any ideas or suggestions! - Neil

2 1

DTML problem
by Phil Beardmore 05 Aug '05

05 Aug '05

I have a problem writing a DTML page. The page will be used to submit data to an SQL database, and the page itself is working great, however I get all of my users to login via an LDAP server using LDAPUserFolder. Once logged in the users can complete a form, click submit and the data is stored (along with their userID and date and time). Problem is, I also want to store the full name (or CN attribute in LDAP tree). I know in ZPT I can use <b tal:condition="cn">Logged in as: </b> <font color=#000000><strong><span tal:replace="cn">replace cn</span></strong></font></span> and this works great but I cannot manage to work it out in DTML. Below is my page code (Hope you can help!) Thanks Phil <dtml-call "REQUEST.set('user',AUTHENTICATED_USER.getUserName())"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" metal:use-macro="here/main_template/macros/master" i18n:domain="plone"> <body> <div metal:fill-slot="main"> <body bgcolor="#FFFFFF"> <table width="100%" border="0"> <td width="80%"><form name="Add_student_modules" method="post" action="add_stu_modules_method" enctype="multipart/form-data"> <input type="hidden" name="userid" value="<dtml-var user>"> <input type="hidden" name="datetime" value="<dtml-var "ZopeTime()" fmt=fCommon>"> <input type="hidden" name="name" value="<dtml-var name>"> <table width="90%" border="0" cellspacing="0" cellpadding="2" align="center"> <tr> <td colspan="2" class="standard" align="center" bgcolor="#D6DBDF"><strong>Submit Module Choices</strong></td> </tr> <tr> <td width="101" bgcolor="#D6DBDF"> </td> <td width="419"> </td></tr> <tr> <td width="101" align="right" bgcolor="#D6DBDF" class="standard"><b>Choice 1</b></td> <td width="419"> <select name="choice1"> <option value="APC101">APC101 - Accounting, Planning and Control</option> <option value="BUS999">BUS999 - Marketing & Business Enterprise</option> <option value="HRM121">HRM121 - Human Resource Management</option> <option value="SIM222">SIM222 - Strategy and International Management</option> <option value="PSY666">PSY666 - Psychology</option> <option value="LAW421">LAW421 - Law</option> <option value="ADM555">ADM555 - Administration</option> <option value="TEC834">TEC834 - Technical</option> </select></td></tr> <tr> <td width="101" align="right" bgcolor="#D6DBDF" class="standard"><b>Choice 2</b></td> <td width="419"> <select name="choice2"> <option value="APC101">APC101 - Accounting, Planning and Control</option> <option value="BUS999">BUS999 - Marketing & Business Enterprise</option> <option value="HRM121">HRM121 - Human Resource Management</option> <option value="SIM222">SIM222 - Strategy and International Management</option> <option value="PSY666">PSY666 - Psychology</option> <option value="LAW421">LAW421 - Law</option> <option value="ADM555">ADM555 - Administration</option> <option value="TEC834">TEC834 - Technical</option> </select></td></tr> <td width="101" bgcolor="#D6DBDF"> </td> <td width="419"> <input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Clear"></td></tr> </table> </form></td> </tr> </table> </div> </body> </html>

2 1

Cannot pass parameters to Externa Method From inside a DTML Method
by Thomas Apostolou 05 Aug '05

05 Aug '05

I have in my "Extensions" folder the file "TestODBCEM.py" witch contains the following code to select and return 40 rows by 8 columns of a query: def TestODBCEM(self, sysDSN="defDSN", usr="defUsr", mypass="defPass", sSQL="SELECT * FROM defTable", xx=40, yy=8): id = self.id import dbi import odbc connection=odbc.odbc(sysDSN+'/'+usr+'/'+mypass) cur=connection.cursor() cur.execute(sSQL) data=cur.fetchall() a="" for x in range(0,int(xx)): for y in range(0,int(yy)): if data[x][y]=="": a=a+"Null"+"---" else: a=a+str(data[x][y])+" --- " a=a+"\n" return data I have used it and created an External Method in my Zope name "TestODBCEM" next i created a DTML Method named "GetQueryParamsDTML" with the following : <html> <head> </head> I will connect using : "<dtml-var id>" System DSN Type the query to execute... <form name="Params" action="./TestODBCEM" method="POST"> <input type="hidden" name="sysDSN:string" value=<dtml-var id>> The SQL Query to be executed against the above DSN connection <input name="sSQL:string"><br> <input type="hidden" name="mypass:string" value=<dtml-var passWD>><br> <input type="hidden" name="usr:string" value=<dtml-var usrID>><br> <input type="submit" value=" Execute "><br> </form> </html> and everything is ok as it returns something like this : [(1, 1054, 1001, '\xc1\xd0\xcf\xd3\xc2', 1001, 101, '\xc1\xd0\xcf\xd3\xc2\xc5\xd3\xc5\xc9\xd3 \xd7\xd1\xc7\xd3\xc7\xd3', None, 1, None, None, None, None, None, 1, 1, 0, None, None, None, None, None, 1054, 1054, 1, 0, 0, 0, None, None, None, 0, None, None, None, 0, None, None, None, 0, 0, 0, None, None, None, 0, 0), (1, 1054, 9001, '\xc1\xd0\xcf\xd..... Now i want to format the results to show them so i change my "GetQueryParamsDTML" as follows: <html> <head> </head> I will connect using : "<dtml-var id>" System DSN Type the query to execute... <form name="Params" action="./ShowResults" method="POST"> <input type="hidden" name="sysDSN:string" value=<dtml-var id>> The SQL Query to be executed against the above DSN connection <input name="sSQL:string"><br> <input type="hidden" name="mypass:string" value=<dtml-var passWD>><br> <input type="hidden" name="usr:string" value=<dtml-var usrID>><br> <input type="submit" value=" Execute "><br> </form> </html> Now it calls another DTML Method named "ShowResults" witch reads like this: <dtml-var standard_html_header> <table border="1"> <dtml-in TestODBCEM> <dtml-if sequence-even> <tr bgcolor="lightgreen"> <dtml-else> <tr> </dtml-if> <dtml-in sequence-item> <td><dtml-var sequence-item></td> </dtml-in> </tr> </dtml-in> <dtml-var standard_html_footer> The problem know is that, althought the params of the GetQueryParamsDTML is passed to ShowResults through the REQUEST, the TestODBCEM does not use them. Instead the code is always using the defValues of its def line. When i was calling ./TestODBC from GetQueryParamsDTML it was using the parameters i was submiting. I tried to change the follong line of ShowResults : <dtml-in TestODBCEM> to: <dtml-in expr="TestODBCEM('<dtml-var sysDSN>', '<dtml-var usr>', '<dtml-var mypass>', '<dtml-var sSQL>')"> but this one gives me an AttributeError ('str' object has no attribute 'id'). Does anyone know what am i doing wrong? I would apreciate it if you could help me. I use Zope 2.7.0 on windows XP PRO, witch i use after installing Plone 2.0.5 executable installer. It uses Python 2.3.3 Thanks in advance. Thomas Apostolou ___________________________________________________________ Χρησιμοποιείτε Yahoo!; Βαρεθήκατε τα ενοχλητικά μηνύματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr

3 3

Zope on IIS 6.0 without using ISAPI re-write tools from Freshlogic or HeliconTech?
by michael nt milne 05 Aug '05

05 Aug '05

Hi I have installed Plone on a Windows Small Business Server running IIS 6.0 and have found that I can't get it to serve pages. The server also runs a separate Exchange webmail service. On doing a bit of research and with help from this list it seems that the problem is with IIS and its inability to send requests to other applications. However this page on Microsoft seems to suggest otherwise. http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B813368 Am I right in thinking that if you include only the ports that you want IIS to listen on in Httpcfg.exe and *leave out* the Zope :8080 port then IIS will re-direct to Zope/Plone etc as it is notin its 'included' list? Has anyone tried this? It would be a lot simpler than using the 'not free' ISAPI re-write tools that exist. Why can't Microsoft just include a good re-write tool in IIS? Thanks

1 0

[Fwd: Re: [Zope] test for the existence of a nodeValue]
by Jon Bowlas 05 Aug '05

05 Aug '05

Thanks Dieter, But I still cant get it to work. I've changed my get_attributes.py script to this: if not attobject: return '' version = attobject.get_viewable() nodes = version.content.documentElement.getElementsByTagName(attname) if not nodes: return '' nodeValue = nodes[0].childNodes[0].nodeValue if not nodeValue: return "none" return nodeValue and my zpt is like this: <span id="section_subheader" tal:define="isadditional python:here.get_uclattribute(attobject, 'ucl_additional_name')" tal:condition="python: isadditional !='none'" tal:attributes="id python:here.get_uclattribute(attobject, 'ucl_additional_name_color')"><span tal:content="python:here.get_uclattribute(attobject, 'ucl_additional_name') or nothing" tal:omit-tag="">Website Subheader</span></span> But I get the following error: Error Type: IndexError error Value: list index is out of range and the traceback says "Module None, line 7 in get_attributes" is the cause. Hope you can help. Jon > Jon Bowlas wrote at 2005-8-2 19:08 +0100: >> ... >>I'm pretty new to python and zope but would like to know how I can adapt this script below to test to see if nodeValue actually contains a value >> and >>if it doesn't then I would like to return a default value I can check for using my zpt that references this script: > > You probably should work through the Python tutorial you will > find on "http://python.org". > >> ... >>if not nodes: >> >> return '' >> >>return nodes[0].childNodes[0].nodeValue > > Try: > > nodeValue = nodes[0].childNodes[0].nodeValue > if not nodeValue: return "someFault" > return nodeValue > > -- > Dieter > >

2 2