eatmoose
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
thanks @Angelelz , i will say this is fixed by switching to pg instead of postgres
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
might be related https://github.com/drizzle-team/drizzle-orm/issues/1704
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
can i dm u the full code
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
without BEGIN and COMMIT statements it gives unexpected behaviors
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
SHARE lock so non transaction reads can come through
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
but i tried serializble , and it give unexpected behavior
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
i need to apply SHARE lock
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
can anyone verify my work around? will this have any bad side effects?
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
i hope my psudo code makes sense, its basically forcing transaction to wait if the table is being read in another transactions. but nothing is working as expected if i dont have BEGIN and COMMIT statements.
without those statements, i get double inserts, inserts not showing in db but return() fine
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
i dont think there is
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
third option?
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
but if i explicitly say BEGIN and COMMIT inside the tx callback at the top and end, it works. but drizze gives warning
'there is no transaction in progress',
'there is already a transaction in progress',
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
transaction behaving weirdly, without explictly saying BEING and COMMIT, sometimes it returns an inserted value, only for it to not show up on the db. updates sometimes just dont work but it returns a updated value but nothing updates in db
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
@Angelelz is this related to ur fix
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
seems like no locks are being respected unless i manually ask for BEGIN and COMMIT
25 replies
DTDrizzle Team
•Created by eatmoose on 1/24/2024 in #help
Transaction not respecting locks
expected the above code to lock and not allow other transactions through until the transaction is comitted
25 replies
DTDrizzle Team
•Created by cody on 4/26/2023 in #help
How to use JSON field in query
installing in monorepo root doesn't help, and it shouldn't have to be
7 replies
DTDrizzle Team
•Created by cody on 4/26/2023 in #help
How to use JSON field in query
2023 bump
7 replies
DTDrizzle Team
•Created by eatmoose on 10/17/2023 in #help
bug: three column unique index no change never detected
bump
5 replies