Bonjour,
nous avons une piste pour une partie du problème. Nous avons constaté des latences importantes sur des actions UI un peu avant 8H00 ce matin.
Les actions duraient plus d’une heure quasi intégralement en WAITING
En poussant plus loin l’investigation, nous avons constaté un souci sur une séquence:
Nous avons 2 appels select nextval qui prennent chacun 34.8 minutes, ce qui fait en tout 1,16H.
On a trouvé les exceptions suivantes :
select nextval(‘mla_file_event_row_id_seq’)
Exception:
org.postgresql.util.PSQLException
Message:
ERROR: could not open relation with OID 11180755
Stacktrace:
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:121)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:121)
com.simplicite.util.engine.DBAccess.query(DBAccess.java:622)
com.simplicite.util.engine.DBAccess.simpleQuery(DBAccess.java:820)
com.simplicite.util.engine.GrantDirect.simpleQuery(GrantDirect.java:123)
com.simplicite.util.Grant.simpleQuery(Grant.java:1104)
com.simplicite.util.tools.SQLTool.getSequenceNextval(SQLTool.java:555)
com.simplicite.util.engine.DBAccess.getNextIdFromDB(DBAccess.java:1371)
com.simplicite.util.engine.DBAccess.getNextIdFromDB(DBAccess.java:1361)
com.simplicite.util.engine.DBAccess.getNextId(DBAccess.java:1342)
com.simplicite.util.engine.ObjectManager.create(ObjectManager.java:1862)
com.simplicite.util.engine.ObjectManager.save(ObjectManager.java:3351)
com.simplicite.util.engine.ObjectDirect.save(ObjectDirect.java:478)
com.simplicite.util.ObjectDB.save(ObjectDB.java:1317)
com.simplicite.util.ObjectDB.save(ObjectDB.java:1304)
com.simplicite.util.tools.BusinessObjectTool.create(BusinessObjectTool.java:759)
com.simplicite.util.tools.BusinessObjectTool.create(BusinessObjectTool.java:739)
com.simplicite.objects.mla_coremodel.MlaFileEvent.saveFileEventDataAsItem(MlaFileEvent.java:29)
select currval(‘mla_file_event_row_id_seq’)
Exception:
org.postgresql.util.PSQLException
Message:
ERROR: relation “mla_file_event_row_id_seq” does not exist Position: 16
Stacktrace:
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:121)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:121)
com.simplicite.util.engine.DBAccess.query(DBAccess.java:622)
com.simplicite.util.engine.DBAccess.simpleQuery(DBAccess.java:820)
com.simplicite.util.engine.GrantDirect.simpleQuery(GrantDirect.java:123)
com.simplicite.util.Grant.simpleQuery(Grant.java:1104)
com.simplicite.util.tools.SQLTool.getSequence(SQLTool.java:488)
com.simplicite.util.tools.SQLTool.getSequenceNextval(SQLTool.java:563)
com.simplicite.util.engine.DBAccess.getNextIdFromDB(DBAccess.java:1371)
com.simplicite.util.engine.DBAccess.getNextIdFromDB(DBAccess.java:1361)
com.simplicite.util.engine.DBAccess.getNextId(DBAccess.java:1342)
com.simplicite.util.engine.ObjectManager.create(ObjectManager.java:1862)
com.simplicite.util.engine.ObjectManager.save(ObjectManager.java:3351)
com.simplicite.util.engine.ObjectDirect.save(ObjectDirect.java:478)
com.simplicite.util.ObjectDB.save(ObjectDB.java:1317)
com.simplicite.util.ObjectDB.save(ObjectDB.java:1304)
com.simplicite.util.tools.BusinessObjectTool.create(BusinessObjectTool.java:759)
com.simplicite.util.tools.BusinessObjectTool.create(BusinessObjectTool.java:739)
com.simplicite.objects.mla_coremodel.MlaFileEvent.saveFileEventDataAsItem(MlaFileEvent.java:29)
CREATE SEQUENCE mla_file_event_row_id_seq
Exception:
org.postgresql.util.PSQLException
Message:
ERROR: relation “mla_file_event_row_id_seq” already exists
Stacktrace:
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:152)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:135)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:135)
com.simplicite.util.engine.DBAccess.update(DBAccess.java:1514)
com.simplicite.util.engine.GrantDirect.update(GrantDirect.java:397)
com.simplicite.util.Grant.update(Grant.java:1843)
com.simplicite.util.tools.SQLTool.getSequence(SQLTool.java:500)
com.simplicite.util.tools.SQLTool.getSequenceNextval(SQLTool.java:563)
com.simplicite.util.engine.DBAccess.getNextIdFromDB(DBAccess.java:1371)
com.simplicite.util.engine.DBAccess.getNextIdFromDB(DBAccess.java:1361)
com.simplicite.util.engine.DBAccess.getNextId(DBAccess.java:1342)
com.simplicite.util.engine.ObjectManager.create(ObjectManager.java:1862)
com.simplicite.util.engine.ObjectManager.save(ObjectManager.java:3351)
com.simplicite.util.engine.ObjectDirect.save(ObjectDirect.java:478)
com.simplicite.util.ObjectDB.save(ObjectDB.java:1317)
com.simplicite.util.ObjectDB.save(ObjectDB.java:1304)
com.simplicite.util.tools.BusinessObjectTool.create(BusinessObjectTool.java:759)
com.simplicite.util.tools.BusinessObjectTool.create(BusinessObjectTool.java:739)
com.simplicite.objects.mla_coremodel.MlaFileEvent.saveFileEventDataAsItem(MlaFileEvent.java:29)
La log est en PJ
downloaded-logs-20230215-164422.csv (335.7 KB)
Avec une séquence de:
CREATE SEQUENCE mla_file_event_row_id_seq
et même ALTER SEQUENCE mla_file_event_row_id_seq RESTART WITH 9161231
Merci par avance