Igor Gaponenko Fritz Mueller Unknown User (npease) John Gates Andy Salnikov Andy Hanushevsky Colin Slater Joanne Bogart
- 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.
Fritz Mueller Igor Gaponenko will continue looking into investigating the origin of the problem to understand its root cause.
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