[opencms-dev] Problem: Tree view of online project in workplace crashed

[Christian Pöcher]

----- Original Message ----- 
From: "Christian Pöcher" <Poecher at gmx.net>
To: <opencms-dev at opencms.org>
Cc: <felix.engel at schluer.com>
Sent: Monday, June 28, 2004 5:23 PM
Subject: Re: [opencms-dev] Problem: Tree view of online project in workplace crashed


>> It seems that the Online-VFS is ok. The Website is reachable.  

>I didn't check the VFS at DB-level, but I tested an API call via cmsshell - >GetFolderTree or something like that. Everything seemed fine. I also replaced the >whole /system/workplace/ folder, but to no avail.

A co-worker of mine did some more work on this topic and found the reason for this behavior. It seems it comes from inconsistent DB tables.

The tables CMS_RESOURCE and CMS_ONLINE_RESOURCE have a column RESOURCE_ID and PARENT_ID. The folder structure is done by bottom-up referencing and results in a tree:

/myfolder         (RID:10 PID:1)
/myfolder/1.html (RID:11 PID:10)
/myfolder/anotherfolder (RID:12 PID:10) and so on

In CMS_ONLINE_RESOURCES of our DB we found not one tree, but more, with resources that don't have a proper parent. Deleting the orphans fixed the tree and also the tree view in the workplace.

We wonder however, what is the reason for the DB inconstistency. We don't know how to reproduce that error. However, I feel there is a connection to the error described by Jarkko Ketola on 24.06.2004. Both, the tree view error and the error from Jarkko happend on files and folders which our customers tried to delete. Any ideas what would trigger the inconsistency? Maybe atomicity of some VFS operations is not given? Does mysql hande the data unsafe? What would happen, if I shutdown tomcat, while some VFS ops are done?

chris
-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++

SCHLUER CONSULTING
Christian Pöcher
Im Winkel 32
52224 Stolberg
Tel.: +49 (2402) 1029931
Fax: +49 (2402) 1029933
E-Mail: christian.poecher at schluer.com
Website: www.schluer.com

+++++++++++++++++++++++++++++++++++++++++++++++++++
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2761 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040628/ca96c551/attachment.bin>