[CWB] Upgrade of CQPweb server

[Stefan Fischer]

Hi Stephanie,

> Our CQPweb server runs on Ubuntu 24.04.3. As far as I can remember, we didn't have any major issues during the OS upgrade. However, …

Thanks for looking up the release number. That's already reassuring.

> … we're still on CQPweb v3.2.44 because 3.3 is still considered unstable / incomplete and we didn't have the courage to upgrade. Did you upgrade your server from 3.2 to 3.3 at some point? And if so, did you have major issues due to the upgrade?

The earliest CQPweb version mentioned in our documentation is 3.2.31. So, I guess that we upgraded successfully from 3.2 to 3.3. However, that happened before I took over administration of the server. I found a short note that installing r1826 caused an issue related to "php upgrade-database.php". Apparently, this was fixed by removing some "saved_catqueries" for the corpus with id=0. I hope that helps.

After you mentioned upgrade issues, I had a closer look at our database. Luckily, all upgrade steps in upgrade-database.php were applied successfully. However, I noted that there are still some MyISAM tables. I guess, before any other upgrades, we should fix this by calling force-innodb.php?

> You could also simply install CWB from the .deb-package and cwb-perl from CPAN. Though it's always best to use the latest and least buggy versions from SVN, of course.

Thanks for mentioning the .deb and CPAN packages. I'd actually prefer these to a manual installation. However, r1826 (2022-10-15) seems to be a couple of months newer than the available .deb and CPAN versions. Could that downgrade cause any issues with a newer version CQPweb? That is, does the unstable version of CQPweb depend on minor bug fixes?

Best,
Stefan