Loading...

Type: Bug
Resolution: Done
Priority: Blocker
Fix Version/s: quay-v3.13.0
Affects Version/s: quay-v3.13.0
Component/s: quay-operator
Labels:
- triaged

Blocked:
False
Blocked Reason:
None
Ready:
False
Intelligence Requested:
Market:

SFDC Cases Links:
SFDC Cases Counter:
SFDC Cases Open:

Description:

This is an issue found in Quay 3.13 upgrade from Quay 3.12, in Quay 3.12 Quay was deployed with managed Clair and Clairpostgres Components, then upgrade to Quay 3.13 the Clair upgrade job completed successfully, but found the old clair postgres database POD was not removed, checked the DB size of Clair new Database, the Data was not migrated successfully, before upgrade the DB size of Clair postgres is 18GB, after upgrade to Quay 3.13, the DB size is only 4GB, pls review this issue, attached the Quay 3.13 operator logs Quay313_operator_pod.logs

Quay: quay-operator-bundle-container-v3.13.0-43

Before upgrade to Quay 3.13 the Clair database is 18GB:

postgres=# \l+
                                                                   List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   |  Size   | Tablespace |                Descri
ption                 
-----------+----------+----------+------------+------------+-----------------------+---------+------------+----------------------
----------------------
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 |                       | 18 GB   | pg_default | default administrativ
e connection database
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +| 7753 kB | pg_default | unmodifiable empty da
tabase
           |          |          |            |            | postgres=CTc/postgres |         |            | 
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +| 7753 kB | pg_default | default template for 
new databases
           |          |          |            |            | postgres=CTc/postgres |         |            | 
(3 rows)

After upgrade to Quay 3.13:

Quay 3.13 upgrade from Quay 3.12:

oc get pod
NAME                                      READY   STATUS      RESTARTS      AGE
quay-clair-app-f8b8898b9-jhsl6            1/1     Running     0             52m
quay-clair-app-f8b8898b9-knq4s            1/1     Running     0             58m
quay-clair-postgres-57b57d7fbf-9wvn9      1/1     Running     0             58m
quay-clair-postgres-old-6f77c5b65-vntmr   1/1     Running     1 (58m ago)   59m
quay-clair-postgres-upgrade-rwx49         0/1     Completed   2             59m
quay-operator.v3.13.0-6b6bc7dcfc-wj755    1/1     Running     0             59m
quay-quay-app-cfb4f678-45zpp              1/1     Running     0             58m
quay-quay-app-cfb4f678-hfrks              1/1     Running     0             58m
quay-quay-app-upgrade-sg8cn               0/1     Completed   1             58m
quay-quay-database-8cb5b8c8-mvjxk         1/1     Running     0             58m
quay-quay-mirror-7d9f97c684-9pnjb         1/1     Running     0             58m
quay-quay-mirror-7d9f97c684-v74v5         1/1     Running     0             58m
quay-quay-redis-ccb4c4c9c-cssfc           1/1     Running     0             59m