Error in Kopano search



  • 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…


  • Kopano

    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.



  • 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
    

  • Kopano

    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.



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


  • Kopano

    @mcostan

    For the moment: Every time.


Log in to reply