Flowable service startup error. Can you help why SQLSTATE 08000 error. this service is not starting in release server and the same service is working in the DEV server. Unable to find out why release servcie this service is giving issues and compare all MARIASQL DB parameters it is same as DEV parameter. Kindly help
{“@timestamp”:“2022-10-14T07:04:50.273+00:00”,“message”:“HikariPool-1 - Connection org.mariadb.jdbc.Connection@6d11ceef marked as broken because of SQLSTATE(08000), ErrorCode(-1)”,“logger_name”:“c.z.h.pool.ProxyConnection”,“level”:“WARN”,“stack_trace”:“java.net.SocketException: Broken pipe (Write failed)\n\tat java.net.SocketOutputStream.socketWrite0(SocketOutputStream.java)\n\tat java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)\n\tat java.net.SocketOutputStream.write(SocketOutputStream.java:155)\n\tat o.m.j.c.s.impl.PacketWriter.writeSocket(PacketWriter.java:834)\n\tat o.m.j.c.s.impl.PacketWriter.flush(PacketWriter.java:704)\n\tat o.m.j.m.c.QueryWithParametersPacket.encode(QueryWithParametersPacket.java:74)\n\tat o.m.j.c.impl.StandardClient.sendQuery(StandardClient.java:469)\n\t… 57 common frames omitted\nWrapped by: j.s.SQLNonTransientConnectionException: (conn=235) Socket error\n\tat o.m.j.export.ExceptionFactory.createException(ExceptionFactory.java:291)\n\tat o.m.j.export.ExceptionFactory.create(ExceptionFactory.java:357)\n\tat o.m.j.c.impl.StandardClient.sendQuery(StandardClient.java:489)\n\tat o.m.j.c.impl.StandardClient.execute(StandardClient.java:618)\n\tat o.m.j.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:93)\n\tat o.m.j.ClientPreparedStatement.execute(ClientPreparedStatement.java:256)\n\tat c.z.h.p.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)\n\tat c.z.h.p.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)\n\tat o.a.i.e.s.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\n\tat o.a.i.e.s.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\n\tat o.a.i.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\n\tat o.a.i.executor.BaseExecutor.update(BaseExecutor.java:117)\n\tat o.a.i.executor.CachingExecutor.update(CachingExecutor.java:76)\n\tat o.a.i.s.d.DefaultSqlSession.update(DefaultSqlSession.java:194)\n\tat o.a.i.s.d.DefaultSqlSession.insert(DefaultSqlSession.java:181)\n\t… 45 frames truncated\n”,“applicationName”:“Order Validation Service”}
{“@timestamp”:“2022-10-14T07:04:50.275+00:00”,“message”:“Error while closing command context”,“logger_name”:“o.f.c.e.i.i.CommandContext”,“level”:“ERROR”,“stack_trace”:“java.net.SocketException: Broken pipe (Write failed)\n\tat java.net.SocketOutputStream.socketWrite0(SocketOutputStream.java)\n\tat java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)\n\tat java.net.SocketOutputStream.write(SocketOutputStream.java:155)\n\tat o.m.j.c.s.impl.PacketWriter.writeSocket(PacketWriter.java:834)\n\tat o.m.j.c.s.impl.PacketWriter.flush(PacketWriter.java:704)\n\tat o.m.j.m.c.QueryWithParametersPacket.encode(QueryWithParametersPacket.java:74)\n\tat o.m.j.c.impl.StandardClient.sendQuery(StandardClient.java:469)\n\t… 57 common frames omitted\nWrapped by: j.s.SQLNonTransientConnectionException: (conn=235) Socket error\n\tat o.m.j.export.ExceptionFactory.createException(ExceptionFactory.java:291)\n\tat o.m.j.export.ExceptionFactory.create(ExceptionFactory.java:357)\n\tat o.m.j.c.impl.StandardClient.sendQuery(StandardClient.java:489)\n\tat o.m.j.c.impl.StandardClient.execute(StandardClient.java:618)\n\tat o.m.j.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:93)\n\tat o.m.j.ClientPreparedStatement.execute(ClientPreparedStatement.java:256)\n\tat c.z.h.p.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)\n\tat c.z.h.p.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)\n\tat o.a.i.e.s.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\n\tat o.a.i.e.s.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\n\tat o.a.i.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\n\tat o.a.i.executor.BaseExecutor.update(BaseExecutor.java:117)\n\tat o.a.i.executor.CachingExecutor.update(CachingExecutor.java:76)\n\tat o.a.i.s.d.DefaultSqlSession.update(DefaultSqlSession.java:194)\n\t… 46 common frames omitted\nWrapped by: o.a.i.e.PersistenceException: \n### Error updating database. Cause: java.sql.SQLNonTransientConnectionException: (conn=235) Socket error\n### The error may exist in org/flowable/db/mapping/entity/Resource.xml\n### The error may involve org.flowable.engine.impl.persistence.entity.ResourceEntityImpl.bulkInsertResource-Inline\n### The error occu…”,“applicationName”:“Order Validation Service”}
{“@timestamp”:“2022-10-14T07:04:50.570+00:00”,“message”:“Application exception overridden by rollback exception”,“logger_name”:“o.s.t.s.TransactionTemplate”,“level”:“ERROR”,“stack_trace”:“java.net.SocketException: Broken pipe (Write failed)\n\tat java.net.SocketOutputStream.socketWrite0(SocketOutputStream.java)\n\tat java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)\n\tat java.net.SocketOutputStream.write(SocketOutputStream.java:155)\n\tat o.m.j.c.s.impl.PacketWriter.writeSocket(PacketWriter.java:834)\n\tat o.m.j.c.s.impl.PacketWriter.flush(PacketWriter.java:704)\n\tat o.m.j.m.c.QueryWithParametersPacket.encode(QueryWithParametersPacket.java:74)\n\tat o.m.j.c.impl.StandardClient.sendQuery(StandardClient.java:469)\n\t… 57 common frames omitted\nWrapped by: j.s.SQLNonTransientConnectionException: (conn=235) Socket error\n\tat o.m.j.export.ExceptionFactory.createException(ExceptionFactory.java:291)\n\tat o.m.j.export.ExceptionFactory.create(ExceptionFactory.java:357)\n\tat o.m.j.c.impl.StandardClient.sendQuery(StandardClient.java:489)\n\tat o.m.j.c.impl.StandardClient.execute(StandardClient.java:618)\n\tat o.m.j.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:93)\n\tat o.m.j.ClientPreparedStatement.execute(ClientPreparedStatement.java:256)\n\tat c.z.h.p.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)\n\tat c.z.h.p.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)\n\tat o.a.i.e.s.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\n\tat o.a.i.e.s.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\n\tat o.a.i.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\n\tat o.a.i.executor.BaseExecutor.update(BaseExecutor.java:117)\n\tat o.a.i.executor.CachingExecutor.update(CachingExecutor.java:76)\n\tat o.a.i.s.d.DefaultSqlSession.update(DefaultSqlSession.java:194)\n\t… 46 common frames omitted\nWrapped by: o.a.i.e.PersistenceException: \n### Error updating database. Cause: java.sql.SQLNonTransientConnectionException: (conn=235) Socket error\n### The error may exist in org/flowable/db/mapping/entity/Resource.xml\n### The error may involve org.flowable.engine.impl.persistence.entity.ResourceEntityImpl.bulkInsertResource-Inline\n### The error occu…”,“applicationName”:“Order Validation Service”}
{“@timestamp”:“2022-10-14T07:04:50.571+00:00”,“message”:“Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Failed to start bean ‘springProcessEngineConfiguration’; nested exception is org.springframework.transaction.TransactionSystemException: JDBC rollback failed; nested exception is java.sql.SQLException: Connection is closed”,“logger_name”:“o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext”,“level”:“WARN”,“applicationName”:“Order Validation Service”}