noi-techpark/it.bz.opendatahub.sparql

Need support for deploy of sparql mobility sync

Closed this issue · 1 comments

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 ;)

  1. 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?

@Piiit we put on hold this issue because next week ontopic & noi will have a meeting to define the future strategy