Hello. I am using prisma 1.34(docker), I am trying...
# orm-help
p
Hello. I am using prisma 1.34(docker), I am trying to make a deploy that includes adding a field to a type that already has 2.000.000 records. For a minute the deploy has the status IN_PROGRESS, after one minute it has status ROLLBACK_SUCCES and the following error is thrown:
["java.sql.SQLNonTransientConnectionException: (conn=10954) Connection timed out\n\tat org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:161)\n\tat org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)\n\tat org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)\n\tat org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)\n\tat org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)\n\tat com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)\n\tat com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)\n\tat slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)\n\tat slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)\n\tat slick.jdbc.Invoker.first(Invoker.scala:30)\n\tat slick.jdbc.Invoker.first$(Invoker.scala:29)\n\tat slick.jdbc.StatementInvoker.first(StatementInvoker.scala:16)\n\tat slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:52)\n\tat slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:51)\n\tat slick.basic.BasicBackend$DatabaseDef$anon$3.liftedTree1$1(BasicBackend.scala:276)\n\tat slick.basic.BasicBackend$DatabaseDef$anon$3.run(BasicBackend.scala:276)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.sql.SQLException: Connection timed out\n\tat org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:142)\n\tat org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)\n\tat org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)\n\t... 15 more\nCaused by: java.sql.SQLException: Could not send query: Read timed out\n\tat org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:1738)\n\tat org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1302)\n\tat org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1281)\n\tat org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:214)\n\t... 16 more\nCaused by: <http://java.net|java.net>.SocketTimeoutException: Read timed out\n\tat <http://java.net|java.net>.SocketInputStream.socketRead0(Native Method)\n\tat <http://java.net|java.net>.SocketInputStream.socketRead(SocketInputStream.java:116)\n\tat java.net.SocketInputStream.read(SocketInputStream.java:171)\n\tat java.net.SocketInputStream.read(SocketInputStream.java:141)\n\tat <http://java.io|java.io>.BufferedInputStream.fill(BufferedInputStream.java:246)\n\tat <http://java.io|java.io>.BufferedInputStream.read1(BufferedInputStream.java:286)\n\tat java.io.BufferedInputStream.read(BufferedInputStream.java:345)\n\tat <http://org.mariadb.jdbc.internal.io|org.mariadb.jdbc.internal.io>.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:238)\n\tat <http://org.mariadb.jdbc.internal.io|org.mariadb.jdbc.internal.io>.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:208)\n\tat org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1300)\n\t... 18 more\n"]
I tried to increase some mysql parameter to increase the timeout: wait_timeout, max_execution_time, but the error is the same. Did someone encountered this or has a clue about how to solve it? Thanks