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>yves<br><br><div class="gmail_quote">On 21 May 2010 09:58, 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;">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 class="h5"><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>
> > > _______________________________________________<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,<br>
> > 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>
> > _______________________________________________<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,<br>
> please<br>
> > 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>
> ><br>
> ------------------------------------------------------------------------<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,<br>
> 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<br>
> 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>
</div></div>> ------------------------------------------------------------------------<br>
<div><div></div><div>><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>
</div></div></blockquote></div><br>