[opencms-dev] Severe Problem - Publish Queue is not processed anymore OpenCms 7.5.3

Tobias Herrmann t.herrmann at alkacon.com
Thu Jan 26 10:00:23 CET 2012 

Hi Tobias,

the exception you saw in your log files hints to an inconsistency within the CMS_RESOURCE_LOCKS table. If the problem reoccurs you could delete all entries from this table loosing only the lock state information, but nothing else.
Can you recall what led to this problem? We haven't had any issues with lock state consistency and I'm curious what went wrong.

Greetings, Tobias

--

Alkacon Software GmbH - The OpenCms Experts

http://www.alkacon.com  --  http://www.opencms.org



Am 25.01.2012 19:45, schrieb Tobias Mantsch:
>
> Thank you for your hint, but we are running on PostgreSQL J
>
> Mit freundlichen Grüßen
>
> Tobias Mantsch
> Software Development
>
> Tel.: +49 (0) 221 789 883-92 / Fax: +49 (0) 221 / 789 883-84
> t.mantsch at easysport.de, www.easysport.de
>
>
> http://www.easysport.de/logos/logo_signatur.gif <http://www.easysport.de/?espcmp=SEO-Backlinks3207>
>
> e-sports GmbH, Bachemstraße 8, 50676 Köln
> Geschäftsführer: Robert Ragge
> Amtsgericht Köln HRB 62205, Ust. ldNr. DE 258794922
>
> http://www.easysport.de/logos/Facebook_EASYSPORT.png <http://www.facebook.com/EASYSPORT?sk=app_179017185480451>
>
> *Von:*opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] *Im Auftrag von *Joseph ABENA
> *Gesendet:* Mittwoch, 25. Januar 2012 19:35
> *An:* The OpenCms mailing list
> *Betreff:* Re: [opencms-dev] Severe Problem - Publish Queue is not processed anymore OpenCms 7.5.3
>
> Hello,
>
> we had a similar problem in 7.5.3 (files in publish queue but cannot publish with a look message for all publish job) and they was no solution after restarting tomcat or try to publish 100 times ;)
>
> For our case this was due to a problem to the database, especialy some errors with the (physical) file system of our database host server.  This problem was definetly fixed after running a repairing process on our mysql database files. You may look on this way also.
>
> Hope this can help you.
>
> Regards
>
> Joseph
> www.abena09.com/joseph <http://www.abena09.com/joseph>
> www.4gafrica.com <http://www.4gafrica.com>
>
>
> Le 1/25/2012 5:40 PM, Deiverson Silveira a écrit :
>
> Hi,
>
> The problemonly happens on that page?
>
> /sites/default/easysport/sport/badminton/hannover/angebote/index.html
>
> Or all pages your project?
>
> Regards,
>
> Deiverson
>
> 2012/1/19 Tobias Mantsch <t.mantsch at easysport.de <mailto:t.mantsch at easysport.de>>
>
> Hello again,
>
> does anybody have  a solution or a hint?
>
> The problem is pretty severe, restarting the server didn't help and all content types are affected by this issue.
>
> Mit freundlichen Grüßen
>
> Tobias Mantsch
> Software Development
>
> Tel.: +49 (0) 221 789 883-92 <tel:%2B49%20%280%29%20221%20789%20883-92> / Fax: +49 (0) 221 / 789 883-84 <tel:%2B49%20%280%29%20221%20%2F%20789%20883-84>
> t.mantsch at easysport.de <mailto:t.mantsch at easysport.de>, www.easysport.de <http://www.easysport.de>
>
>
> *Fehler! Es wurde kein Dateiname angegeben.* <http://www.easysport.de/?espcmp=SEO-Backlinks3207>
>
> e-sports GmbH, Bachemstraße 8, 50676 Köln
> Geschäftsführer: Robert Ragge
> Amtsgericht Köln HRB 62205, Ust. ldNr. DE 258794922
>
> *Fehler! Es wurde kein Dateiname angegeben.* <http://www.facebook.com/EASYSPORT?sk=app_179017185480451>
>
> *Von:*opencms-dev-bounces at opencms.org <mailto:opencms-dev-bounces at opencms.org> [mailto:opencms-dev-bounces at opencms.org <mailto:opencms-dev-bounces at opencms.org>] *Im Auftrag von *Tobias Mantsch
> *Gesendet:* Dienstag, 17. Januar 2012 12:08
> *An:* The OpenCms mailing list
> *Betreff:* [opencms-dev] Publish Queue is not processed anymore OpenCms 7.5.3
>
> Hi everyone,
>
> we've run into a severe issue on our server where the publish queue is not processed any longer. Publish jobs are put into the queue but they stay there.
>
> We discovered the following Exception in the log, which might be related:
>
> 17 Jan 2012 11:53:27,724 ERROR [  org.opencms.main.OpenCmsCore:1798] Failed to read the locks from database. Locks from previous runs are lost.
>
> org.opencms.lock.CmsLockException: Current lock [CmsLock: resource: /sites/default/easysport/sport/badminton/hannover/angebote/index.html, type: exclusive, project: 694d2212-32ca-11e0-961d-6bd0001ced6f, user
>
> : c300ba5c-01e8-3727-b305-5dcc9ccae1ee, related lock: system unlocked] is not compatible with the new lock [CmsLock: resource: /sites/default/easysport/sport/badminton/hannover/angebote/index.html, type: exc
>
> lusive, project: 694d2212-32ca-11e0-961d-6bd0001ced6f, user: 502a7828-53c8-11e0-8403-6bd0001ced6f, related lock: system unlocked] to set.
>
>         at org.opencms.lock.CmsLockManager.internalLockResource(CmsLockManager.java:741)
>
>         at org.opencms.lock.CmsLockManager.readLocks(CmsLockManager.java:366)
>
>         at org.opencms.db.CmsDriverManager.readLocks(CmsDriverManager.java:6089)
>
>         at org.opencms.db.CmsSecurityManager.readLocks(CmsSecurityManager.java:3574)
>
>         at org.opencms.main.OpenCmsCore.afterUpgradeRunlevel(OpenCmsCore.java:1792)
>
>         at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1744)
>
>         at org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:87)
>
>         at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
>
>         at org.apache.catalina.core.StandardContext.start(StandardContext.java:4212)
>
>         at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
>
>         at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
>
>         at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
>
>         at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:975)
>
>         at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:938)
>
>         at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
>
>         at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1193)
>
>         at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
>
>         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
>
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
>
>         at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
>
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
>
>         at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>
>         at org.apache.catalina.core.StandardService.start(StandardService.java:448)
>
>         at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
>
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
>         at java.lang.reflect.Method.invoke(Method.java:616)
>
>         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
>
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
>
> How can this be fixed again?
>
> Mit freundlichen Grüßen
>
> Tobias Mantsch
> Software Development
>
> Tel.: +49 (0) 221 789 883-92 <tel:%2B49%20%280%29%20221%20789%20883-92> / Fax: +49 (0) 221 / 789 883-84 <tel:%2B49%20%280%29%20221%20%2F%20789%20883-84>
> t.mantsch at easysport.de <mailto:t.mantsch at easysport.de>, www.easysport.de <http://www.easysport.de>
>
>
> *Fehler! Es wurde kein Dateiname angegeben.* <http://www.easysport.de/?espcmp=SEO-Backlinks3207>
>
> e-sports GmbH, Bachemstraße 8, 50676 Köln
> Geschäftsführer: Robert Ragge
> Amtsgericht Köln HRB 62205, Ust. ldNr. DE 258794922
>
> *Fehler! Es wurde kein Dateiname angegeben.* <http://www.facebook.com/EASYSPORT?sk=app_179017185480451>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
>
>
> -- //
>
> /www.solutioncms.com <http://www.solutioncms.com>/
>
> /The Brazilian /
>
> /Official Provider OpenCms/
>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>   
>   
>   
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20120126/c6364839/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 2156 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20120126/c6364839/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4874 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20120126/c6364839/attachment.png>

More information about the opencms-dev mailing list