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
Project ID:
15d8591f-5471-4e24-83c9-eb0a09e84b1315d8591f-5471-4e24-83c9-eb0a09e84b13
Also πhello! as for the timeouts, do you have a legacy database involved in this project?
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
does your mysql client support the version of mysql that railway is running?
good q. maybe it doesn't for transactions, will check.