Hi Georgi,<br><br>thanks for the info, that's how I worked around in fact :-)<br><br>How is the status of the jpa-build? Will it be part of the next official release of OpenCms? :-)<br><br>And my last question would be:<br>
<br>Do you have a solution for this issue of mine: <a href="http://permalink.gmane.org/gmane.comp.cms.opencms.devel/34179">http://permalink.gmane.org/gmane.comp.cms.opencms.devel/34179</a> ? :-)<br><br><br>Best regards,<br>
Yves<br><br><div class="gmail_quote">On 4 August 2010 12:13, Georgi Naplatanov <span dir="ltr"><<a href="mailto:gosho@oles.biz">gosho@oles.biz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hello Yves.<br>
<br>
Thank you for this bug report.<br>
<br>
There is workaround. You can use "Context Menu/History" dialog to<br>
restore online version of resource.<br>
<div class="im"><br>
Best regards<br>
Georgi<br>
<br>
Yves Glodt wrote:<br>
</div><div><div></div><div class="h5">> Hi Gerogi,<br>
><br>
> I found a small bug with the jpa-version. I get an exception everytime I<br>
> do "Undo changes", as follows:<br>
><br>
> 26 Jul 2010 23:01:25,128 ERROR [rg.opencms.workplace.CmsDialog:1452] The<br>
> workplace dialog caused an error.<br>
> org.opencms.file.CmsVfsException: Error undoing changes of resource<br>
> "/demo_en/intro.html".<br>
> at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:264)<br>
> at org.opencms.db.jpa.CmsDbContext.report(CmsDbContext.java:107)<br>
> at<br>
> org.opencms.db.CmsSecurityManager.undoChanges(CmsSecurityManager.java:4876)<br>
> at<br>
> org.opencms.file.types.A_CmsResourceType.undoChanges(A_CmsResourceType.java:804)<br>
> at org.opencms.file.CmsObject.undoChanges(CmsObject.java:4189)<br>
> at<br>
> org.opencms.workplace.commons.CmsUndoChanges.performDialogOperation(CmsUndoChanges.java:489)<br>
> at<br>
> org.opencms.workplace.commons.CmsUndoChanges.actionUndoChanges(CmsUndoChanges.java:217)<br>
> at<br>
> org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.undochanges_jsp._jspService(undochanges_jsp.java:137)<br>
> at<br>
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br>
> at<br>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br>
> at<br>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br>
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br>
> at<br>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br>
> at<br>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
> at<br>
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)<br>
> at<br>
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)<br>
> at<br>
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)<br>
> at<br>
> org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)<br>
> at<br>
> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)<br>
> at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:555)<br>
> at<br>
> org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)<br>
> at<br>
> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)<br>
> at<br>
> org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:829)<br>
> at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:512)<br>
> at<br>
> org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1052)<br>
> at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1504)<br>
> at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)<br>
> at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:166)<br>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)<br>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br>
> at<br>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br>
> at<br>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
> at<br>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br>
> at<br>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br>
> at<br>
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br>
> at<br>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br>
> at<br>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br>
> at<br>
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<br>
> at<br>
> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)<br>
> at<br>
> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)<br>
> at<br>
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)<br>
> at java.lang.Thread.run(Thread.java:619)<br>
> Caused by: java.lang.NullPointerException<br>
> at<br>
> org.opencms.db.CmsPublishedResource.<init>(CmsPublishedResource.java:149)<br>
> at<br>
> org.opencms.db.CmsPublishedResource.<init>(CmsPublishedResource.java:138)<br>
> at<br>
> org.opencms.search.CmsSearchManager$CmsSearchOfflineHandler.reIndexResources(CmsSearchManager.java:262)<br>
> at<br>
> org.opencms.search.CmsSearchManager$CmsSearchOfflineHandler.cmsEvent(CmsSearchManager.java:173)<br>
> at<br>
> org.opencms.main.CmsEventManager.fireEventHandler(CmsEventManager.java:203)<br>
> at<br>
> org.opencms.main.CmsEventManager.fireEvent(CmsEventManager.java:126)<br>
> at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:156)<br>
> at<br>
> org.opencms.db.jpa.CmsVfsDriver.createResource(CmsVfsDriver.java:757)<br>
> at<br>
> org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1747)<br>
> at<br>
> org.opencms.db.CmsDriverManager.undoContentChanges(CmsDriverManager.java:9544)<br>
> at<br>
> org.opencms.db.CmsDriverManager.undoChanges(CmsDriverManager.java:7679)<br>
> at<br>
> org.opencms.db.CmsSecurityManager.undoChanges(CmsSecurityManager.java:4874)<br>
><br>
><br>
</div></div><div class="im">> On 26 May 2010 09:45, Yves Glodt <<a href="mailto:yg@mind.lu">yg@mind.lu</a> <mailto:<a href="mailto:yg@mind.lu">yg@mind.lu</a>>> wrote:<br>
><br>
> I think I found an issue in my code.<br>
><br>
> I have a jsp which logs in a user (CmsObject.loginUser()), gets a<br>
> list of image resources, and displays 3 by random.<br>
> Now I can imagine the deadlock comes when several people hit the<br>
> site concurrently.<br>
><br>
> I should find a better way to dislpay random resources I guess.<br>
><br>
> best regards,<br>
> yves<br>
><br>
><br>
</div><div class="im">> On 21 May 2010 09:58, Yves Glodt <<a href="mailto:yg@mind.lu">yg@mind.lu</a> <mailto:<a href="mailto:yg@mind.lu">yg@mind.lu</a>>> wrote:<br>
><br>
> Hi!<br>
><br>
> I think there should be no simultaneous logins... But I can not<br>
> be sure if some people left a browser somewhere open with a<br>
> logged session...<br>
><br>
> Good news about jpa 2.0, I will wait for that. Hopefully I can<br>
> upgrade 7.5.2 by just replacing the relevant jars... :-)<br>
><br>
> yves<br>
><br>
><br>
> On 21 May 2010 09:50, Georgi Naplatanov <<a href="mailto:gosho@oles.biz">gosho@oles.biz</a><br>
</div><div class="im">> <mailto:<a href="mailto:gosho@oles.biz">gosho@oles.biz</a>>> wrote:<br>
><br>
> Hello Yves.<br>
><br>
> In your case if there are not simultaneous logins with the<br>
> same user<br>
> name, it sounds like a bug.<br>
><br>
> These days OpenJPA 2.0 is available and I will build OpenCms<br>
> with this<br>
> version of OpenJPA which contains a lot of bug fixes.<br>
><br>
> Best regards<br>
> Georgi<br>
><br>
> Yves Glodt wrote:<br>
> > Hi Georgi,<br>
> ><br>
> > I use only the workplace here.<br>
> ><br>
> > On 20 May 2010 14:40, Georgi Naplatanov <<a href="mailto:gosho@oles.biz">gosho@oles.biz</a><br>
> <mailto:<a href="mailto:gosho@oles.biz">gosho@oles.biz</a>><br>
</div><div><div></div><div class="h5">> > <mailto:<a href="mailto:gosho@oles.biz">gosho@oles.biz</a> <mailto:<a href="mailto:gosho@oles.biz">gosho@oles.biz</a>>>> wrote:<br>
> ><br>
> > Hello Yves.<br>
> ><br>
> > OpenCms updates user last login when user login on.<br>
> ><br>
> > Do you use cms shell or this exception occurs when<br>
> you use workplace ?<br>
> ><br>
> > Best regards<br>
> > Georgi<br>
> ><br>
> > Yves Glodt wrote:<br>
> > > Hi Georgii,<br>
> > ><br>
> > > I am using the jpa-builds with Firebird 2.1 quite<br>
> intensively, and<br>
> > > frequently see this in the logs:<br>
> > ><br>
> > > SEVERE: Servlet.service() for servlet jsp threw<br>
> exception<br>
> > > org.apache.openjpa.lib.jdbc.ReportingSQLException:<br>
> GDS Exception.<br>
> > > 335544336. deadlock<br>
> > > update conflicts with concurrent update<br>
> > > No message for code 335544878 found.<br>
> > > null {prepstmnt 1344045115 UPDATE CMS_USERS SET<br>
> USER_LASTLOGIN =<br>
> > ? WHERE<br>
> > > USER_ID = ? [params=(long) 1274353716094, (String)<br>
> > > ea551c31-xxxx-yyyy-zzzz-1234567890]}<br>
> [code=335544336, state=HY000]<br>
> > ><br>
> > > Do you have an idea where these deadlocks come from?<br>
> > > If you need more details, let me know!<br>
> > ><br>
> > > best regards,<br>
> > > Yves<br>
> > ><br>
> > > On 21 January 2010 16:17, Achim Westermann<br>
> > <<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a><br>
> <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a>><br>
> <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a><br>
> <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a>>><br>
> > > <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a><br>
> <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a>><br>
> > <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a><br>
> <mailto:<a href="mailto:achim.westermann@questico.de">achim.westermann@questico.de</a>>>>> wrote:<br>
> > ><br>
> > > Hi Georgi,<br>
> > ><br>
> > > that was quick!<br>
> > ><br>
> > > thx for sharing your work.<br>
> > ><br>
> > > Achim<br>
> > ><br>
> > > Georgi Naplatanov wrote:<br>
> > > > binary -<br>
> > > ><br>
> > ><br>
> ><br>
> <a href="http://os.oles.biz/opencms/jpa-driver/opencms_7.5.2-jpa-2010-01-21.zip" target="_blank">http://os.oles.biz/opencms/jpa-driver/opencms_7.5.2-jpa-2010-01-21.zip</a><br>
> > > ><br>
> > > > source code -<br>
> > <a href="https://opencms-jpa.oles.biz/opencmsjpa/branches/7.5.2/" target="_blank">https://opencms-jpa.oles.biz/opencmsjpa/branches/7.5.2/</a><br>
> > > ><br>
> > > > Best regards<br>
> > > > Georgi<br>
> > > ><br>
><br>
><br>
><br>
</div></div>> ------------------------------------------------------------------------<br>
<div><div></div><div class="h5">><br>
><br>
> _______________________________________________<br>
> This mail is sent to you from the opencms-dev mailing list<br>
> To change your list options, or to unsubscribe from the list, please visit<br>
> <a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
<br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</div></div></blockquote></div><br>