Need support for deploy of sparql mobility sync
Closed this issue · 1 comments
RudiThoeni commented
After merging ontopics latest PR on the Sparql i tried a Deploy without luck.
I need some infos + support from Peter to understand what is going on ;)
- Missing Foreign Key (ERROR: constraint "fk_station_meta_data_id_metadata_pk" of relation "station" does not exist)
Now there is a Flyway V3 migration script and this script fails
ontop_1 | ERROR: Migration of schema "intimev2" to version "3 - deferrable constraints" failed! Changes successfully rolled back. ontop_1 | DEBUG: Memory usage: 20 of 250M ontop_1 | ERROR: Unexpected error ontop_1 | org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V3__deferrable_constraints.sql failed
because the foreign key "fk_station_meta_data_id_metadata_pk" on the table stations does not exist
I tried to create it but i got a violate constraint error
SQL Error [23503]: ERROR: insert or update on table "station" violates foreign key constraint "fk_station_meta_data_id_metadata_pk" Detail: Key (meta_data_id)=(2088524) is not present in table "metadata"
Some questions:
- I saw that the table sizes on VirtualKnowledgeGraph/test DB are a lot smaller, i suppose the initial import was not done completely ?
- Also there are some tables missing, i suppose they are not needed on the vkg DB?
- Is it intentional that this foreign key is missing on the vkg db?
RudiThoeni commented
@Piiit we put on hold this issue because next week ontopic & noi will have a meeting to define the future strategy