R
Railway12mo ago
sactrom

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
Percy
Percy12mo ago
Project ID: 7ef54070-08d2-4928-b280-0fb5dc861ed7,0000313f-fdd1-4449-b8df-fad8843a312d
sactrom
sactrom12mo ago
0ba5f545-361a-4d01-8412-6314384b1774 Project ID:0ba5f545-361a-4d01-8412-6314384b1774
jr
jr12mo ago
Hi @sactrom, what do you mean "f I redeploy the database it is corrected but after a while it comes back"
sactrom
sactrom12mo ago
When I do this the problem is solve, starts to works normally
No description
sactrom
sactrom12mo ago
But maybe in a couple o hours the db show weird logs and start to malcfunction again
jr
jr12mo ago
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
Want results from more Discord servers?
Add your server