Bonjour,
On essaie de faire de simple import csv sur un objet (3 champs). les imports autour de 60 lignes passent; au delà, on a une erreur “Load fault” sans fichier de log ni fichier d’erreur.
Dans la console de logs : voici la première erreur :
2022-11-25 10:34:19,207|SIMPLICITE|ERROR||http://app-ares-int-56dc8658c5-fgzb4:8080||ECOREDB001|system|com.simplicite.util.engine.GrantDirect|updateBlob||Error SQL query: update m_document set dbd_content=? where dbd_path = ‘XMLSupervisor/xsp_log_id/0/86/flow_20221125_103418.log’
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.util.StreamWrapper.(StreamWrapper.java:145)
at org.postgresql.core.v3.SimpleParameterList.setBytea(SimpleParameterList.java:152)
at org.postgresql.jdbc.PgPreparedStatement.setBinaryStream(PgPreparedStatement.java:1537)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setBinaryStream(DelegatingPreparedStatement.java:223)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setBinaryStream(DelegatingPreparedStatement.java:223)
at com.simplicite.util.engine.DBAccess.updateBlob(DBAccess.java:1653)
at com.simplicite.util.engine.GrantDirect.updateBlob(GrantDirect.java:444)
at com.simplicite.util.Grant.updateBlob(Grant.java:1888)
at com.simplicite.util.tools.DocTool.writeFile(DocTool.java:1584)
at com.simplicite.util.tools.DocTool.upload(DocTool.java:673)
at com.simplicite.util.engine.ObjectManager.uploadDocument(ObjectManager.java:2198)
at com.simplicite.util.engine.ObjectManager.uploadDocuments(ObjectManager.java:2139)
at com.simplicite.util.engine.ObjectManager.update(ObjectManager.java:2776)
at com.simplicite.util.engine.ObjectDirect.update(ObjectDirect.java:435)
at com.simplicite.util.ObjectDB.update(ObjectDB.java:1270)
at com.simplicite.util.ObjectDB.update(ObjectDB.java:1259)
at com.simplicite.objects.System.XMLSupervisor.storeAdapterResult(XMLSupervisor.java:128)
at com.simplicite.util.engine.Interface.importData(Interface.java:558)
at com.simplicite.util.engine.Interface.importCSV(Interface.java:1095)
at com.simplicite.util.engine.IntegrationDirect.importCSV(IntegrationDirect.java:243)
at com.simplicite.util.Integration.importCSV(Integration.java:518)
at com.simplicite.webapp.servlets.AbstractIOServlet.doPost(AbstractIOServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.simplicite.webapp.filters.HTTPHeadersFilter.doFilter(HTTPHeadersFilter.java:39)
at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.simplicite.webapp.filters.RewriteFilter.doFilter(RewriteFilter.java:62)
at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.simplicite.webapp.filters.AuthMethodFilter.doFilter(AuthMethodFilter.java:219)
at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:183)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.io.IOException: Read-only file system
at java.base/java.io.UnixFileSystem.createFileExclusively(Native Method)
at java.base/java.io.File.createTempFile(File.java:2170)
at java.base/java.io.File.createTempFile(File.java:2216)
at org.postgresql.util.StreamWrapper.(StreamWrapper.java:54)
… 57 more
L’erreur Read-only file system en cause me parait bizarre vu que certains imports plus petits passent
Ci-dessous notre health check
[Platform]
Status=OK
Version=5.2.6
BuiltOn=2022-06-07 13:52
Git=5.2/473f811f8428d85cf4ef19fcc90ea2b47d774501
Encoding=UTF-8
EndpointIP=198.18.88.29
EndpointURL=http://app-ares-int-56dc8658c5-fgzb4:8080
TimeZone=UTC
SystemDate=2022-11-25 10:36:20
[Application]
ApplicationVersion=1.0.0
ContextPath=
ContextURL=https://ares-int-realestate.dev.echonet
ActiveSessions=4
TotalUsers=20
EnabledUsers=15
LastLoginDate=2022-11-25 09:38:03
[Server]
ServerInfo=Apache Tomcat/9.0.63
ServerType=WEB
ServerActiveSessions=4
ServerSessionTimeout=30
[OS]
Name=Linux
Architecture=amd64
Version=4.15.0-191-generic
DockerImageName=centos7
SystemEncoding=UTF-8
[JavaVM]
Version=17.0.3
Vendor=Eclipse Adoptium
VMName=OpenJDK 64-Bit Server VM
VMVersion=17.0.3+7
ScriptEngine=rhino
ScriptEngineVersion=Rhino 1.7.13 2020 09 02
HeapFree=252996
HeapSize=446464
HeapMaxSize=501760
TotalFreeSize=308292
[Cache]
ObjectCache=207
ObjectCacheMax=10000
ObjectCacheRatio=2
ProcessCache=0
ProcessCacheMax=10000
ProcessCacheRatio=0
APIGrantCache=0
APIGrantCacheMax=1000
APIGrantRatio=0
[Database]
Vendor=3
ProductName=PostgreSQL
ProductVersion=12.11
DriverName=PostgreSQL JDBC Driver
DriverVersion=42.3.6
DBDate=2022-11-25 10:36:20
DBDateOffset=0
DBPatchLevel=5;P02;477f47d75700947c2e36d7bae9353a6e
UsingBLOBs=true
[Healthcheck]
Date=2022-11-25 10:36:21
ElapsedTime=839