Error in table OKM_NODE_DOCUMENT_VERSION

[ancker]

Hi All,

When I try to insert a document this error appears and I can not send the document.

Code: Select all

2013-06-25 17:31:06,038 [ajp-bio-8009-exec-14] INFO  com.openkm.servlet.frontend.FileUploadServlet - Filename: 'RELAÇÃO DE CONTRIBUIÇÃO DE FGTS.pdf'
2013-06-25 17:31:06,038 [ajp-bio-8009-exec-14] INFO  com.openkm.servlet.frontend.FileUploadServlet - Upload file 'RELAÇÃO DE CONTRIBUIÇÃO DE FGTS.pdf' into '/okm:root/PESSOAL/GEFIP/Ampla (3.8 KB)'
2013-06-25 17:31:06,038 [ajp-bio-8009-exec-14] INFO  com.openkm.servlet.frontend.FileUploadServlet - Wizard: {path=, showWizardCategories=false, showWizardKeywords=false, groupsList=[], workflowList=[], hasAutomation=false, error=, digitalSignature=false}
2013-06-25 17:31:06,108 [ajp-bio-8009-exec-14] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 145, SQLState: HY000
2013-06-25 17:31:06,108 [ajp-bio-8009-exec-14] ERROR org.hibernate.util.JDBCExceptionReporter - Table './okmdb/OKM_NODE_DOCUMENT_VERSION' is marked as crashed and should be repaired
2013-06-25 17:31:06,109 [ajp-bio-8009-exec-14] ERROR com.openkm.servlet.frontend.FileUploadServlet - Could not execute JDBC batch update
com.openkm.core.DatabaseException: Could not execute JDBC batch update
        at com.openkm.dao.NodeDocumentDAO.create(NodeDocumentDAO.java:144)
        at com.openkm.module.db.base.BaseDocumentModule.create(BaseDocumentModule.java:156)
        at com.openkm.module.db.DbDocumentModule.create(DbDocumentModule.java:221)
        at com.openkm.servlet.frontend.FileUploadServlet.doPost(FileUploadServlet.java:314)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

How to solve this? My version is 6.2.4-DEV (8075)

[jllort]

Have you read it:
2013-06-25 17:31:06,108 [ajp-bio-8009-exec-14] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 145, SQLState: HY000
2013-06-25 17:31:06,108 [ajp-bio-8009-exec-14] ERROR org.hibernate.util.JDBCExceptionReporter - Table './okmdb/OKM_NODE_DOCUMENT_VERSION' is marked as crashed and should be repaired

Have you done some update from older openkm version ? or you have closed openkm incorrectly ( some hardware incorrectly stop etc... ? )

I suggest go to Administration / utilities -> check repository

[ancker]

There was no update.
Had a lack of energy.
Restored the backup and everything is ok but there would be another way to fix this?

Thanks.

[jllort]

Which database are you using, Mysql or which comes by default with openkm hsql ? hsql is a very sensitive database when stops system incorrectly and can easilly be affected and corrupt by it. I suggest move to mysql with full repository migration if this is your case.

[ancker]

I use mysql.
I restored the backup and all is ok again.
Thank you.