R
Railwayβ€’9mo ago
coryw

MySQL + transaction support (node process)

Hey folks -- noticed that I'm getting regular timeouts from my node process if I attempt to run transactions against a MySQL db deployed on Railway (using sequelize.) When I remove the transactional bit, things work just fine. Is this a me problem or a limitation in the platform? Also πŸ‘‹ -- this is my first message in this community so if I've got things wrong/need to provide more information/data/whatever, let me know!
6 Replies
Percy
Percyβ€’9mo ago
Project ID: 15d8591f-5471-4e24-83c9-eb0a09e84b13
coryw
corywβ€’9mo ago
15d8591f-5471-4e24-83c9-eb0a09e84b13
Brody
Brodyβ€’9mo ago
Also πŸ‘‹
hello! as for the timeouts, do you have a legacy database involved in this project?
coryw
corywβ€’9mo ago
hey brody! i don't. things work just fine with every other bit of db access...just times out on awaits on a transaction. if i remove the tx code, things work as expected. in this case i'm trying to wrap multiple db interactions in a single tx and then rollback if i hit an exception... or commit if all is clear
Brody
Brodyβ€’9mo ago
does your mysql client support the version of mysql that railway is running?
coryw
corywβ€’9mo ago
good q. maybe it doesn't for transactions, will check.
Want results from more Discord servers?
Add your server