Erreur lors du chargement de plusieurs fichier
J'ai parfois cette erreur quand j'essaye de charger plusieurs fichiers dans un même projet :
15:20:55,459 ERROR ImportServlet:140 - java.lang.IllegalStateException: Could not execute update: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « norm_nodes_pkey »
Detail: La clé « (id)=(226) » existe déjà.
java.lang.IllegalStateException: Could not execute update: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « norm_nodes_pkey »
Detail: La clé « (id)=(226) » existe déjà.
at fr.inria.cedar.connectionlens.sql.RelationalStructure.executeUpdate(RelationalStructure.java:132)
at fr.inria.cedar.connectionlens.sql.RelationalStructure.executeUpdate(RelationalStructure.java:112)
at fr.inria.cedar.connectionlens.graph.normalization.Normalization.run(Normalization.java:53)
at fr.inria.cedar.connectionlens.sql.schema.NormalizedRelationalGraph.<init>(NormalizedRelationalGraph.java:52)
at fr.inria.cedar.connectionlens.ConnectionLens.createOrLoadNormalizedGraph(ConnectionLens.java:1269)
at fr.inria.cedar.connectionlens.ConnectionLens.register(ConnectionLens.java:412)
at fr.inria.cedar.connectionstudio.webservices.connectionlens.ImportServlet.process(ImportServlet.java:135)
at fr.inria.cedar.connectionstudio.webservices.connectionlens.ImportServlet.doPost(ImportServlet.java:208)
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 fr.inria.cedar.connectionstudio.webservices.connectionlens.util.AppCorsFilter.doFilter(AppCorsFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
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:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
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:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
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:829)
15:20:55,460 ERROR MasterServlet:150 - Could not execute update: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « norm_nodes_pkey »
Detail: La clé « (id)=(226) » existe déjà.
Ces deux fichiers ensembles produisent le bug: