Hi Gerogi,<br><br>I found a small bug with the jpa-version. I get an exception everytime I do "Undo changes", as follows:<br><br>26 Jul 2010 23:01:25,128 ERROR [rg.opencms.workplace.CmsDialog:1452] The workplace dialog caused an error.<br>
org.opencms.file.CmsVfsException: Error undoing changes of resource "/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 org.opencms.db.CmsSecurityManager.undoChanges(CmsSecurityManager.java:4876)<br> at org.opencms.file.types.A_CmsResourceType.undoChanges(A_CmsResourceType.java:804)<br> at org.opencms.file.CmsObject.undoChanges(CmsObject.java:4189)<br>
at org.opencms.workplace.commons.CmsUndoChanges.performDialogOperation(CmsUndoChanges.java:489)<br> at org.opencms.workplace.commons.CmsUndoChanges.actionUndoChanges(CmsUndoChanges.java:217)<br> at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.undochanges_jsp._jspService(undochanges_jsp.java:137)<br>
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br>
at 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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)<br>
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)<br> at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)<br> at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)<br>
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)<br> at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:555)<br> at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)<br>
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)<br> at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:829)<br> at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:512)<br>
at 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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br>
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br>
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<br> at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)<br>
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)<br> at 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 org.opencms.db.CmsPublishedResource.<init>(CmsPublishedResource.java:149)<br> at org.opencms.db.CmsPublishedResource.<init>(CmsPublishedResource.java:138)<br>
at org.opencms.search.CmsSearchManager$CmsSearchOfflineHandler.reIndexResources(CmsSearchManager.java:262)<br> at org.opencms.search.CmsSearchManager$CmsSearchOfflineHandler.cmsEvent(CmsSearchManager.java:173)<br>
at org.opencms.main.CmsEventManager.fireEventHandler(CmsEventManager.java:203)<br> at org.opencms.main.CmsEventManager.fireEvent(CmsEventManager.java:126)<br> at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:156)<br>
at org.opencms.db.jpa.CmsVfsDriver.createResource(CmsVfsDriver.java:757)<br> at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1747)<br> at org.opencms.db.CmsDriverManager.undoContentChanges(CmsDriverManager.java:9544)<br>
at org.opencms.db.CmsDriverManager.undoChanges(CmsDriverManager.java:7679)<br> at org.opencms.db.CmsSecurityManager.undoChanges(CmsSecurityManager.java:4874)<br><br><br><div class="gmail_quote">On 26 May 2010 09:45, Yves Glodt <span dir="ltr"><<a href="mailto:yg@mind.lu">yg@mind.lu</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;">I think I found an issue in my code.<br><br>I have a jsp which logs in a user (CmsObject.loginUser()), gets a list of image resources, and displays 3 by random.<br>
Now I can imagine the deadlock comes when several people hit the site concurrently.<br>
<br>I should find a better way to dislpay random resources I guess.<br><br>best regards,<br><font color="#888888">yves</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On 21 May 2010 09:58, Yves Glodt <span dir="ltr"><<a href="mailto:yg@mind.lu" target="_blank">yg@mind.lu</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;">Hi!<br><br>I think there should be no simultaneous logins... But I can not be sure if some people left a browser somewhere open with a logged session...<br>
<br>Good news about jpa 2.0, I will wait for that. Hopefully I can upgrade 7.5.2 by just replacing the relevant jars... :-)<br><font color="#888888">
<br>yves</font><div><div></div><div><br><br><div class="gmail_quote">On 21 May 2010 09:50, Georgi Naplatanov <span dir="ltr"><<a href="mailto:gosho@oles.biz" target="_blank">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>
In your case if there are not simultaneous logins with the same user<br>
name, it sounds like a bug.<br>
<br>
These days OpenJPA 2.0 is available and I will build OpenCms with this<br>
version of OpenJPA which contains a lot of bug fixes.<br>
<div><br>
Best regards<br>
Georgi<br>
<br>
Yves Glodt wrote:<br>
</div><div>> 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" target="_blank">gosho@oles.biz</a><br>
</div><div><div></div><div>> <mailto:<a href="mailto:gosho@oles.biz" target="_blank">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 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 intensively, and<br>
> > frequently see this in the logs:<br>
> ><br>
> > SEVERE: Servlet.service() for servlet jsp threw exception<br>
> > org.apache.openjpa.lib.jdbc.ReportingSQLException: 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 USER_LASTLOGIN =<br>
> ? WHERE<br>
> > USER_ID = ? [params=(long) 1274353716094, (String)<br>
> > ea551c31-xxxx-yyyy-zzzz-1234567890]} [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" target="_blank">achim.westermann@questico.de</a> <mailto:<a href="mailto:achim.westermann@questico.de" target="_blank">achim.westermann@questico.de</a>><br>
> > <mailto:<a href="mailto:achim.westermann@questico.de" target="_blank">achim.westermann@questico.de</a><br>
> <mailto:<a href="mailto:achim.westermann@questico.de" target="_blank">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>
> <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></div></div></blockquote></div></div></div></blockquote></div></div></div></blockquote></div><br>