search

qwat / qwat-data-model

TEKSI Water module (project QWAT) - PostgreSQL / postgis Datamodel
https://www.teksi.ch
23 stars 25 forks source link

Pum tries to apply an old delta #341

Closed ponceta closed 3 years ago

ponceta commented 3 years ago

When trying to update from 1.3.3 to 1.3.5 I face an error in the delta application 👍

1.3.3_015 tries to apply again even if it is already applied to the database.

image

image

Why?

ponceta commented 3 years ago

I fixed the checksum of delta files using

md5sum delta/delta_1.3.3_015_add_fk_protection_somo_comments.sql

and copying values into qwat_sys.info table

image

Now I still have

image

Which should be solved by fixing the sequence :

image

ponceta commented 3 years ago

Should be fine!

image

Some testing still required on my side but solved it anyway.

Checksum is a good hint to verify that original deltas were applied (which was not the case on my side since I had altered these),