Error in Kopano search

mcostan

I noticed that the search functionality wasn’t working properly, i.e. the results weren’t updated.

So I looked at the logs and I can see these ones:

2018-04-10 18:46:40,156 - index0 - WARNING - Received a MAPI error or timeout (error=0x8004010f, retry=0/5)
2018-04-10 18:46:40,683 - index0 - WARNING - Received a MAPI error or timeout (error=0x8004010f, retry=1/5)
2018-04-10 18:46:41,517 - index0 - WARNING - Received a MAPI error or timeout (error=0x8004010f, retry=2/5)
2018-04-10 18:46:43,160 - index0 - WARNING - Received a MAPI error or timeout (error=0x8004010f, retry=3/5)
2018-04-10 18:46:46,401 - index0 - WARNING - Received a MAPI error or timeout (error=0x8004010f, retry=4/5)
2018-04-10 18:46:52,844 - index0 - WARNING - Received a MAPI error or timeout (error=0x8004010f, retry=5/5)
2018-04-10 18:46:59,252 - index0 - ERROR - Too many retries, skipping change

I have never seen this before and it always worked fine.

Versions:

WebApp:
3.4.11.1344+766.1
Kopano Core:
8.5.5
Z-Push:
2.4.0+0-0

Correction: after a while the indices did appear correct in Kopano Webapp but the warnings and errors persist continuosly in the log file.

I can see what’s happening.

If I go to the server.log I can see:

Tue Apr 10 18:50:26 2018: [error ] K-1562: cannot open attachment “/zarafaAttachments/zarafa_attachments/9/6/17869.gz”: No such file or directory
Tue Apr 10 18:50:26 2018: [error ] SerializeObject failed with error code 0x80000002 for object 79214

SO the question is: how do I fix this? I am not aware of any attachments missing…

fbartels

That is a known issue in 8.5.x, that will be fixed in 8.5.6. Pm me on Mattermost if you’re willing to test packages.

mcostan

Tried the upgrade to the package you gave but I get the following:

Thu Apr 12 18:48:44 2018: [error  ] SQL [00179235] Failed: Table 'mysql.information_schema' doesn't exist, Query Size: 104, Query: "SELECT `AUTO_INCREMENT` FROM mysql.information_schema WHERE table_schema="zarafa" AND table_name="names""
Thu Apr 12 18:48:44 2018: [error  ] KDatabase::DoSelect(): query failed: "Table 'mysql.information_schema' doesn't exist", query: SELECT `AUTO_INCREMENT` FROM mysql.information_schema WHERE table_schema="zarafa" AND table_name="names"
Thu Apr 12 18:48:44 2018: [error  ] K-1217: Table fill level is indeterminate.
Thu Apr 12 18:48:44 2018: [error  ] K-1219: K-1216 may have already caused a loss of data in other tables.
Thu Apr 12 18:48:44 2018: [error  ] K-1221: Proceeding with --ignore-da and ignoring the schema update is technically possible, but data corruption may happen sooner or later.
Thu Apr 12 18:48:44 2018: [error  ] Can't update the database: Unable to upgrade database from version 8.5.6.2153119744.68 to 8.5.6.2153119744.70

fbartels

Thanks for the feedback. Please start the server with the --ignore-da parameter for the moment. We have a script to “repair” the database in the works, which will be rolled out with the actual release.

mcostan

thanks Felix. Do I need to start it every time with the --ignore-da parameter or only the first time?

mkromer

@mcostan

For the moment: Every time.