Migration to newer version of mariadb does not work

mcostan

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:

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?

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.

is kopano-search up and running?

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

mcostan

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.

mcostan

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.