Migration to newer version of mariadb does not work


  • Good morning,

    I have attempted migration from:
    centos 7.0 - Mariadb 5.5.56

    To:

    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.

    EXCEPT

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

    search.PNG

    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:
    WebApp:
    5.0.0.13+1895.1
    Kopano Core:
    8.7.5
    Z-Push:
    2.5.2+0-0

    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.