hey, we're using prisma.executeRaw for db migratio...
# prisma-migratej
jknr
10/13/2020, 11:02 AMhey, we're using prisma.executeRaw for db migrations, but it seems that long running db queries can time out?! does prisma have a timeout for queries? and can we increase it somehow? cheers
jknr
10/13/2020, 11:11 AMhm. maybe it's better we just place the queries in a sql file and run next to prisma
jknr
10/13/2020, 11:27 AMit might be related to https://github.com/prisma/prisma/issues/3892
a
Alberto Perdomo
10/14/2020, 4:51 PM
If you are interested in using raw SQL/DDL statements in migrations, we may have something of your interest coming up in migrate pretty soon. Would you be interested in validating it and providing feedback?
If yes, can you please let me know the best way to contact you? Slack, email? 🙂
j
jknr
10/16/2020, 2:17 PM@Alberto Perdomo slack is fine! we're actually not interested in raw sql but it is the only option when you're transitioning to p2. We ran the prisma-upgrade queries in a migration script (via umzug). The problem that came up was that a larger UPDATE query to update types on about 10k rows from text to jsonb made our migrate script blow up half way through (due to timeout in
$executeRaw5 Views