[opencms-dev] Strange nested content error - is - corrupt database

[Andrea Puddu]

] Code Create [ Bernd Wolfsegger ha scritto:
> [cut]
>
> Is there anybody out there who experienced something alike, notably DB errors
> regarding corrupt tables?
>
> Kind regards, Bernd
>
>   


Hi Bernd,
We've experienced the same problem recently. (since 7.5.0 for sure...)

I don't know whether the problem is related to the OpenCms version or to 
the size of the DB tables.

In my case the problem occurs on the following tables:

CMS_OFFLINE_STRUCTURE  (about 115Mb  size)

CMS_OFFLINE_RESOURCES   (about 38Mb size)

My DB engine is MySQL 5.0.37


I got this error

Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when 
executing the following query: com.mysql.jdbc.PreparedStatement at 6159e9:
SELECT 
CMS_OFFLINE_STRUCTURE.STRUCTURE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_PATH,CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE,CMS_OFFLINE_STRUCTURE.DATE_RELEASED,CMS_OFFLINE_STRUCTURE.DATE_EXPIRED,CMS_OFFLINE_STRUCTURE.STRUCTURE_VERSION,CMS_OFFLINE_RESOURCES.RESOURCE_ID,CMS_OFFLINE_RESOURCES.RESOURCE_TYPE,CMS_OFFLINE_RESOURCES.RESOURCE_FLAGS,CMS_OFFLINE_RESOURCES.RESOURCE_STATE,CMS_OFFLINE_RESOURCES.DATE_CREATED,CMS_OFFLINE_RESOURCES.DATE_LASTMODIFIED,CMS_OFFLINE_RESOURCES.USER_CREATED,CMS_OFFLINE_RESOURCES.USER_LASTMODIFIED,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED 
AS 
LOCKED_IN_PROJECT,CMS_OFFLINE_RESOURCES.RESOURCE_SIZE,CMS_OFFLINE_RESOURCES.DATE_CONTENT,CMS_OFFLINE_RESOURCES.SIBLING_COUNT,CMS_OFFLINE_RESOURCES.RESOURCE_VERSION,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED 
FROM CMS_OFFLINE_STRUCTURE,CMS_OFFLINE_RESOURCES WHERE 
CMS_OFFLINE_STRUCTURE.RESOURCE_PATH='/sites/mysite/homepage/media/pm/98_beatles.jpg' 
AND CMS_OFFLINE_STRUCTURE.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_ID 
ORDER BY CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE ASC.
        at 
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1942)
        at 
org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6462)
        at org.opencms.lock.CmsLockManager.getLocks(CmsLockManager.java:249)
        at 
org.opencms.db.CmsDriverManager.getLockedResources(CmsDriverManager.java:3752)
        at 
org.opencms.db.CmsSecurityManager.getLockedResources(CmsSecurityManager.java:1914)
        ... 42 more

Caused by: java.sql.SQLException: Got error 134 from storage engine


We fixed it by table repair.

However is not clear why every, let's say 4-5 weeks, I have again a new 
table corruption.
We decided to schedule a table check everyday (during the night) in 
order to avoid maintenance during the work time.

If you need further information, just ask.
Every clue about this subject will be very appreciate.

Regards,
Andrea

---------------------------
Andrea Puddu
docpuddu at tiscali dot it
http://www.linkedin.com/in/andreapuddu
-------------------------------------------