Migration to newer version of mariadb does not work

  • Good morning,

    I have attempted migration from:
    centos 7.0 - Mariadb 5.5.56


    Ubuntu 18.04 - Mariadb 10.1.47

    What I did to migrate is the following:

    • export the database with mysqldump from centos 7
    • reimport the database with the mysql command into ubuntu

    I then restarted kopano-server and everything works perfectly.


    The search, where, when searching on a particular folder, I get this:


    Checking in the search log files I get this:

     File "/usr/lib/python3/dist-packages/kopano/log.py", line 103, in log_exc
        try: yield
      File "/usr/lib/python3/dist-packages/kopano_search/__init__.py", line 189, in main
        docids = plugin.search(server_guid, store_guid, folder_ids, fields_terms, query, config['limit_results'], self.log)
      File "/usr/lib/python3/dist-packages/kopano_search/plugin_xapian.py", line 79, in search
        for match in enquire.get_mset(0, limit_results or db.get_doccount()): # XXX catch exception if database is being updated?
    xapian.DatabaseModifiedError: The revision being read has been discarded - you should call Xapian::Database::reopen() and retry the operation

    The version I have of the software is:
    Kopano Core:

    Am I doing anything wrong?

    Or is this version of mariadb not supported?

    1. try to repair the search folders? Stop kopano server and start it manually with this parameter:
    systemctl stop kopano-server
    /usr/sbin/kopano-server -F --restart-searches

    and let it run for some time.

    1. is kopano-search up and running?

    btw. your kopano version is quite old, why you do not us the current version?

  • Thanks, will let kopano search settle down for a bit.

    I need to upgrade the hardware in chunks before I can upgrade the software, so, after that, I’ll update the kopano back end too.

    Thanks for getting back to me.

  • You write that you use Kopano 8.7.5, on the same hardware the 8.7.16 (the current version) must also run.

  • yes, indeed it would run on the same hardaware.

    But… I am in the middle of moving hardware, so I would like to do a bit at the time.

    I.e. first migrate the database, then migrate a chunk at the time, so that I don’t break too many things at once.