-
Bug
-
Resolution: Unresolved
-
Highest
-
None
-
None
We recently deleted and created our ONAP stack and are having issues with a missing table, tosca_csar, and some columns not being present/renamed in the services table of the mso_catalog database. We pulled down the code from Gerrit and found SQL scripts with these changes and were able to make some manually to get around the issue. However, we get a CSAR file not found after the workaround.
20:00:49,208 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-13-thread-1) Table 'mso_catalog.tosca_csar' doesn't exist
Query is: select toscacsar0_.ARTIFACT_UUID as ARTIFACT1_18_, toscacsar0_.NAME as NAME2_18_, toscacsar0_.VERSION as VERSION3_18_, toscacsar0_.ARTIFACT_CHECKSUM as ARTIFACT4_18_, toscacsar0_.URL as URL5_18_, toscacsar0_.DESCRIPTION as DESCRIPT6_18_, toscacsar0_.CREATION_TIMESTAMP as CREATION7_18_ from TOSCA_CSAR toscacsar0_ where toscacsar0_.ARTIFACT_CHECKSUM=?, parameters ['ZGYzMWJhMGY5YjAwOTVjODVhNmM4MDM0M2YxOWI3MWY=']
The sql script in the SO repository was found in
packages/root-pack-extras/config-resources/mysql/db-sql-scripts/upgrade/MariaDB-upgrade-1707.40_drop1_to_1707.41_drop1.sql. After creating that we needed to run a few updates on the mso_catalog.service table as well. This did not fix the issue, though.