Open Source Document Management System | OpenKM

PostPosted:**Wed Apr 08, 2020 6:21 am**

Good morning everybody,

since yesterday I'm getting these lines in catalina.log:

2020-04-07 23:16:09,841 [http-bio-127.0.0.1-8080-exec-1] ERROR org.hibernate.util.JDBCExceptionReporter- Index OKM_DASHBOARD_ACTIVITY is corrupted

resulting in this message on login:

Code: Select all

OKM-013024(callbackGetLastUploadedDocuments): Datenbankfehler
could not execute query using iterate

OKM-013024(getUserLastDownloadedDocuments): Datenbankfehler
could not execute query

It's bothering, but apart from that, OpenKM appears to be working. Apparently a database problem. Is there a way to fix it, or should I roll back the latest database dump?

Thank you and take care,
Matthias

PostPosted:**Thu Apr 09, 2020 10:22 am**

What database are you using? share OpenKM.cfg
Have table corrupted is not good news, should consider an alert for your current installation because today is the OKM_ACTIVITY table but tomorrow the OKM_NODE_DOCUMENT ... and the level of the issue will raise up.

PostPosted:**Thu Apr 09, 2020 10:30 am**

It's mysql.

Code: Select all

mysqld  Ver 10.1.44-MariaDB-0+deb9u1 for debian-linux-gnu on x86_64 (Debian 9.11)

Is there a way to fix the database?

This is my OpenKM.cfg:

Code: Select all

# OpenKM Hibernate configuration values
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.hbm2ddl=none

# Initial configuration - Linux
system.imagemagick.convert=/usr/bin/convert
system.openoffice.path=/usr/lib/libreoffice
system.swftools.pdf2swf=/opt/openkm/bin/pdf2swf -f -T 9 -t -s storeallcharacters ${fileIn} -o ${fileOut}

Matthias

PostPosted:**Sun Apr 12, 2020 6:47 pm**

Before trying anything I suggest:
1- stop mysql
2- backup all the files into /var/lib/mysql ( keep safe, might be you need to restore )
3- start mysql
4- try to execute a dump ( I suppose will fails, what kind of error is shown )

PostPosted:**Mon Apr 13, 2020 6:45 pm**

jllort wrote: ↑Sun Apr 12, 2020 6:47 pm 4- try to execute a dump ( I suppose will fails, what kind of error is shown )

Code: Select all

~$ mysqldump -p okmdb > okmdb.sql
mysqldump: Error 1712: Index OKM_DASHBOARD_ACTIVITY is corrupted when dumping table `OKM_DASHBOARD_ACTIVITY` at row: 0

The dump results in a file of plausible size.

Matthias

PostPosted:**Thu Apr 16, 2020 7:59 pm**

Search in google for "mysqldump: Error 1712:"
https://logic.edchen.org/how-to-resolve ... corrupted/

Open Source Document Management System | OpenKM

Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted

Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted

Re: Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted

Re: Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted

Re: Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted

Re: Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted

Re: Database error OKM-013024 ndex OKM_DASHBOARD_ACTIVITY is corrupted