database postgres failed
I am presenting a bug with the V2 database in this case postgres, I have several projects deployed where I use the version before the update of BD and one with the new one, it turns out that the new one at the moment of receiving a SQL instruction of update updates all the records of the table example: UPDATE "public". "policies" SET "statusId" = '7ef54070-08d2-4928-b280-0fb5dc861ed7' WHERE "policyId" = '0000313f-fdd1-4449-b8df-fad8843a312d'; it updates all the records in the policies table and if I redeploy the database it is corrected but after a while it comes back and this happens and this is quite a big problem, how can I go back to using the first version of DB or deploy a minor version of psotgres because I see they use an img with postgres 16
6 Replies
Project ID:
7ef54070-08d2-4928-b280-0fb5dc861ed7,0000313f-fdd1-4449-b8df-fad8843a312d0ba5f545-361a-4d01-8412-6314384b1774
Project ID:0ba5f545-361a-4d01-8412-6314384b1774
Hi @sactrom, what do you mean "f I redeploy the database it is corrected but after a while it comes back"
When I do this the problem is solve, starts to works normally
But maybe in a couple o hours the db show weird logs and start to malcfunction again
So the data reverts back? I am very confused by this. Do you have a minimum reproducible example? I suspect this has something to do with the application itself as I don't know how the database would revert back rows after an update