Strange nested content error - is - corrupt database
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
Strange nested content error - is - corrupt database
by ] Code Create [ Bernd Wolfsegger
::
Rate this Message:
Hi List,
the mentioned error has nothing to do with my problem. The problem is, that I have a resource which is not longer accessible. Fehler beim Veröffentlichen der Datei "/system/modules/..../navigation_include.jsp". Fehler org.opencms.file.CmsDataAccessException: Kann die Ressource mit der ID "43fa5e1d-40d7-11dc-a996-000c2911c68b" nicht lesen. at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:1030) at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:144 3) at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5221) at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:197) Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Kann die Ressource mit der ID "43fa5e1d-40d7-11dc-a996-000c2911c68b" nicht lesen. at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1878) at org.opencms.db.generic.CmsProjectDriver.publishDeletedFile(CmsProjectDriver.java :2792) at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:923) ... 3 more It is also not possible to delete and publish the resource. There has been a MySql Database Error too. And I have to say, that there where many Database table errors since the Installation of OpenCms 7.5. Never had these before. I could fix most of them though with the repair command etc. Is there anybody out there who experienced something alike, notably DB errors regarding corrupt tables? Kind regards, Bernd _______________________________________________ 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/mailman/listinfo/opencms-dev |
|
|
Re: Strange nested content error - is - corrupt database
by Eska
::
Rate this Message:
Hi Bernd,
if the problem only occurs in the Online-projekt, just try to touch your resources and republish them. I had such a problem also this week, after performing a database-import, but the touching and republishing did the trick for me. Eska
|
|
|
Re: Strange nested content error - is - corrupt database
by Christian Steinert
::
Rate this Message:
Try to flush you jsp cache and see if that helps
Christian > Hi List, > > the mentioned error has nothing to do with my problem. > > The problem is, that I have a resource which is not longer accessible. > > Fehler beim Veröffentlichen der Datei > "/system/modules/..../navigation_include.jsp". > Fehler org.opencms.file.CmsDataAccessException: Kann die Ressource mit der ID > "43fa5e1d-40d7-11dc-a996-000c2911c68b" nicht lesen. > at > org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:1030) > at > org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:144 > 3) > at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5221) > at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:197) > Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Kann die Ressource > mit der ID "43fa5e1d-40d7-11dc-a996-000c2911c68b" nicht lesen. > at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1878) > at > org.opencms.db.generic.CmsProjectDriver.publishDeletedFile(CmsProjectDriver.java > :2792) > at > org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:923) > ... 3 more > > It is also not possible to delete and publish the resource. > > There has been a MySql Database Error too. > > And I have to say, that there where many Database table errors since the > Installation of OpenCms 7.5. > Never had these before. > I could fix most of them though with the repair command etc. > > Is there anybody out there who experienced something alike, notably DB errors > regarding corrupt tables? > > Kind regards, Bernd > > > _______________________________________________ > 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/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/mailman/listinfo/opencms-dev |
|
|
Re: Strange nested content error - is - corrupt database
by ] Code Create [ Bernd Wolfsegger
::
Rate this Message:
Hi Christian, Eska,
thanx for your answers. But the database table CMS_ONLINE_STRUCTURE was corrupt, so I had to repair it via mysl REPAIR command. Next time though I will try the "touch" and republish thing ... but I don't think it will help, cause this time I couldn't even publish the mentioned resource and neither delete it. After the repair all was o.k. fortunately. Perhaps I have some misconfiguration in my MySql ? Is mysiam preferred over innodb or visversa? Perhaps there is something wrong with transaction management in innodb ? Kind regards, Bernd _______________________________________________ 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/mailman/listinfo/opencms-dev |
|
|
Re: Strange nested content error - is - corrupt database
by Andrea Puddu-2
::
Rate this Message:
] 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@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 ------------------------------------------- _______________________________________________ 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/mailman/listinfo/opencms-dev |
| Free embeddable forum powered by Nabble | Forum Help |
