I just recrete my k8s cluster and deploy all our s...
# talk-keto
a
I just recrete my k8s cluster and deploy all our service including Keto, but now when I try to insert/update values in Keto, I have this kind of error:
Copy code
Keto Delete team: team=0070c83f-4214-4a95-a88a-5aa99e7dcfdc tenant=0c64fa2d-2c4b-4a8d-adaa-7dc15af64bfd status=error message=2 UNKNOWN: failed to close prepared statement: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02): ERROR: insert or update on table "keto_relation_tuples" violates foreign key constraint "keto_relation_tuples_nid_fk" (SQLSTATE 23503)
ⅹ tenant deletion failed (2 UNKNOWN: failed to close prepared statement: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02): ERROR: insert or update on table "keto_relation_tuples" violates foreign key constraint "keto_relation_tuples_nid_fk" (SQLSTATE 23503))
Not sure how the networks entry are generated in keto, when I try to list the tuples Keto return nothing, but my
keto_relation_tuples
contains more then 14'000 entries
s
are you sure you loaded a full backup of all tables?
do you have the logs of the initial start? or migration job?
a
I boot up keto on an empty database, then apply the backup, no errors from psql. I double check my backup today But out of curiosity what’s the network table in Keto DB ? And as usual @steep-lamp-91158 thanks for the support
s
yes that is the problem, you need to first restore the backup before starting Keto
we use the network ID for service quality assurance, so that we can identify a cluster of instances instead of single instances across updates
see the
--sqa-opt-out
flag
but if there is no network ID, keto creates a new one on start-up
thats why first backup, then start 😉
a
Ok thanks a lots for the clarification