[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-2017) Portal CMS corrupts/loses data

frontline frontline (JIRA) jira-events at lists.jboss.org
Fri May 16 08:25:32 EDT 2008 

Portal CMS corrupts/loses data
------------------------------

                 Key: JBPORTAL-2017
                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-2017
             Project: JBoss Portal
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Portal CMS
    Affects Versions: 2.6.1 Final
            Reporter: frontline frontline
         Assigned To: Sohil Shah


We have noticed that the CMS the portal uses loses data sometimes.
This occurs on server boots because it appears that the cache is in a different state than the database.
For example if I check the child folders for a given folder in the portal, the list may show different entries than the corresponding entry in the database table jbp_cms_wsp_node.

I also checked the integrity of that table, and found many "orphaned" entries where the entry's parent didn't contain the given entry in its child list.
I have not been able to reproduce this on a devel machine, but this happens fairly often on a quite busy production server (lots of cms creates and updates).

Here is an example of the database integrity check for the jbp_cms_wsp_node table.
"Parent children" is a list of the children the parent entry contains (name - id). If there is a "false" after the entry that means that the database does not contain an entry with the given node id.
The other list "Found children" is a list of nodes from the database which have the given parent as their parent. As you can see this list is longer than the parent's child list. (The "4" after these entries is just the node state property)

14:55:00,062 INFO  [STDOUT] Items with parent: af22c468-6d96-431e-b352-4a0f43c4a4e3
14:55:00,062 INFO  [STDOUT] Parent found: af22c468-6d96-431e-b352-4a0f43c4a4e3
14:55:00,062 INFO  [STDOUT] Parent children
14:55:00,062 INFO  [STDOUT] {}Foopage1 - f756ea71-f2a4-4000-b0db-f95838221bba - true
14:55:00,062 INFO  [STDOUT] {}Foopage2 - e0a1f7ab-1c31-4892-9fe5-cdeea0808280 - true
14:55:00,062 INFO  [STDOUT] {}Foopage3 - 9f23209d-e020-45de-8b9f-a61c98ff36c1 - true
14:55:00,062 INFO  [STDOUT] {}Foopage4 - 7ca11793-4d95-4b14-9e68-176553579dca - false
14:55:00,062 INFO  [STDOUT] {}Foopage5 - f1406d76-6f95-4228-b2ec-db910606ede2 - true
14:55:00,062 INFO  [STDOUT] {}Foopage6 - a52030a3-9621-4ce3-8d7c-cd7cb212e412 - true
14:55:00,062 INFO  [STDOUT] {}Foopage7 - e399361e-be98-4ce9-abff-14b57f39d9ae - true
14:55:00,062 INFO  [STDOUT] {}Foopage8 - cbfc7e2e-c166-42a0-863b-16e053904eb5 - true
14:55:00,062 INFO  [STDOUT] {}Foopage9 - eb92997e-13b9-4038-8f71-fe8c28b82830 - true
14:55:00,062 INFO  [STDOUT] {}Foopage10 - 2b817c88-e0eb-4ea7-9f1f-22d41917de92 - true
14:55:00,062 INFO  [STDOUT] {}Foopage11 - dd0a9d82-231b-45e0-96e3-2c12a7d8bb9e - true
14:55:00,062 INFO  [STDOUT] {}Foopage12 - 07902117-4a07-423f-8872-455f76febfec - true
14:55:00,062 INFO  [STDOUT] {}Foopage13 - ca35324b-8efe-45e8-a88d-38d7f57330bb - true
14:55:00,062 INFO  [STDOUT] {}Foopage14 - 57a10ce2-6c6f-4b8d-8e3b-ddb6bb03771c - true
14:55:00,062 INFO  [STDOUT] {}Foopage15 - a310c49b-7378-403a-be5b-e368175d35a3 - true
14:55:00,062 INFO  [STDOUT] {}Foopage16 - 6e192970-6cb4-4425-88f4-6abe10fcdc0f - true
14:55:00,062 INFO  [STDOUT] {}Foopage17 - 29ff2441-40fd-4dca-8b11-0b07d4a41222 - true
14:55:00,062 INFO  [STDOUT] {}Foopage18 - 0a620ecd-fd91-4ef0-b81a-265e8f8b04ad - true
14:55:00,062 INFO  [STDOUT] {}Foopage19 - 48af1d55-20eb-411e-a84e-bd05a42a6c9b - true
14:55:00,062 INFO  [STDOUT] Found children
14:55:00,062 INFO  [STDOUT] Found: 34c90ce9-ff43-442e-8ca8-2096cad1fab2 - 4
14:55:00,062 INFO  [STDOUT] Found: f1406d76-6f95-4228-b2ec-db910606ede2 - 4
14:55:00,062 INFO  [STDOUT] Found: cbfc7e2e-c166-42a0-863b-16e053904eb5 - 4
14:55:00,062 INFO  [STDOUT] Found: a310c49b-7378-403a-be5b-e368175d35a3 - 4
14:55:00,062 INFO  [STDOUT] Found: c8fd9e02-2aa1-4278-bddd-2d9be0b2d6b0 - 4
14:55:00,062 INFO  [STDOUT] Found: 2b817c88-e0eb-4ea7-9f1f-22d41917de92 - 4
14:55:00,062 INFO  [STDOUT] Found: f756ea71-f2a4-4000-b0db-f95838221bba - 4
14:55:00,062 INFO  [STDOUT] Found: 57a10ce2-6c6f-4b8d-8e3b-ddb6bb03771c - 4
14:55:00,062 INFO  [STDOUT] Found: 29ff2441-40fd-4dca-8b11-0b07d4a41222 - 4
14:55:00,062 INFO  [STDOUT] Found: 3896b2bf-35e9-4c02-9333-c16347143c9d - 4
14:55:00,062 INFO  [STDOUT] Found: e399361e-be98-4ce9-abff-14b57f39d9ae - 4
14:55:00,062 INFO  [STDOUT] Found: e8d88a1b-d6c2-48e2-a028-0359d215dea9 - 4
14:55:00,062 INFO  [STDOUT] Found: a52030a3-9621-4ce3-8d7c-cd7cb212e412 - 4
14:55:00,062 INFO  [STDOUT] Found: 48af1d55-20eb-411e-a84e-bd05a42a6c9b - 4
14:55:00,078 INFO  [STDOUT] Found: d0868b64-051e-4b7e-ba11-cf078c63e7a5 - 4
14:55:00,078 INFO  [STDOUT] Found: 9a2ca829-eeb1-4e81-8e03-d1fc6953db81 - 4
14:55:00,078 INFO  [STDOUT] Found: eb92997e-13b9-4038-8f71-fe8c28b82830 - 4
14:55:00,078 INFO  [STDOUT] Found: e0a1f7ab-1c31-4892-9fe5-cdeea0808280 - 4
14:55:00,078 INFO  [STDOUT] Found: ef7eba81-1c18-4a0f-b905-ef8009939c9f - 4
14:55:00,078 INFO  [STDOUT] Found: c7a8ef0d-33f0-44c8-8c0b-fe206288c58d - 4
14:55:00,078 INFO  [STDOUT] Found: 728edcdd-fffb-4a53-8bb4-53d4fefebbc8 - 4
14:55:00,078 INFO  [STDOUT] Found: 37d8253a-c834-4444-b959-87a23629a424 - 4
14:55:00,078 INFO  [STDOUT] Found: 5b9ce6a6-8f12-4a1b-8973-c1efde831798 - 4
14:55:00,078 INFO  [STDOUT] Found: ca35324b-8efe-45e8-a88d-38d7f57330bb - 4
14:55:00,078 INFO  [STDOUT] Found: 9eea7729-0a7a-4828-9259-aec527fb3972 - 4
14:55:00,078 INFO  [STDOUT] Found: 08b7d192-16d6-42fd-aec0-38af242b3db6 - 4
14:55:00,078 INFO  [STDOUT] Found: 0a620ecd-fd91-4ef0-b81a-265e8f8b04ad - 4
14:55:00,078 INFO  [STDOUT] Found: 330f5753-b647-47a8-a4d9-f71a27824a01 - 4
14:55:00,078 INFO  [STDOUT] Found: 6e192970-6cb4-4425-88f4-6abe10fcdc0f - 4
14:55:00,078 INFO  [STDOUT] Found: 9f23209d-e020-45de-8b9f-a61c98ff36c1 - 4
14:55:00,078 INFO  [STDOUT] Found: dd0a9d82-231b-45e0-96e3-2c12a7d8bb9e - 4
14:55:00,078 INFO  [STDOUT] Found: 6575e15c-5ad6-4028-9a93-c647c29283af - 4
14:55:00,078 INFO  [STDOUT] Found: 059ab70a-f3f5-4fa2-ba2c-38779acc4eea - 4
14:55:00,078 INFO  [STDOUT] Found: 582096e8-c3de-4223-b88f-55ee3aeabd0b - 4
14:55:00,078 INFO  [STDOUT] Found: 07902117-4a07-423f-8872-455f76febfec - 4
14:55:00,078 INFO  [STDOUT] Found: 9cbf87be-3512-41da-90cd-c85ad6c53ed8 - 4

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the jboss-jira mailing list