Migration to newer version of mariadb does not work
mcostan last edited by mcostan
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:
Am I doing anything wrong?
Or is this version of mariadb not supported?
WalterHof last edited by WalterHof
- 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 last edited by
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.
WalterHof last edited by
You write that you use Kopano 8.7.5, on the same hardware the 8.7.16 (the current version) must also run.
mcostan last edited by
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.