- Please, register the topics below
|Progress on topics discussed at the previous meeting Database Meeting 2022-03-23||team|
Igor Gaponenko will look at converting Parquet files of the additional metadata tables and get them ingested into Qserv. (Note a discussion on handling date/time types during the conversion into CSV).
Colin Slater will finalize the Felis schema for the new tables.
|Upgrade "small" Qserv at NCSA to the latest version|
Igor Gaponenko will do it tomorrow during the weekly upgrade
|Problems at IDF after MariaDB upgrade|
Fritz Mueller, team
MariaDB posted complaints:
These were reported by both Qserv worker databases and the Replication system's database service.
Fritz Mueller will disable rolling upgrades in qserv-prod as a short-term solution. Then we'll keep monitoring both prod and int to see if that will make any difference.
In the long term, we need to find a solution to this situation (of the rolling upgrades). And we do need to develop a policy for MariaDB version upgrades.
The worst-case scenario would be to recreate Qserv and to reingest data.
Unknown User (npease) will redeploy the Watcher service at IDF to allow seeing problems with Qserv earlier.
|Qserv modality and status in Kubernetes|
One option mentioned at the meeting was to allow mounting of the same PV in two pods: as read-only PVC in Qserv workers and read-write