|
1
|
|
-[]
|
|
|
\ No newline at end of file |
|
|
1
|
+[
|
|
|
2
|
+ {
|
|
|
3
|
+ "id": 24314624,
|
|
|
4
|
+ "iid": 1374,
|
|
|
5
|
+ "projectId": 2722779,
|
|
|
6
|
+ "title": "[SYNCHRO AVANCEE] Une requête SQL échoue sur mise à jour d\u0027une espèce",
|
|
|
7
|
+ "description": "Connecté à 2 bases centrales en mode serveur (même serveur Tomcat, même serveur PG), la seule différence entre ces 2 bases (clone l\u0027une de l\u0027autre) est la mise à jour d\u0027un paramètre sur une espèce (YTL).\n\nEn voulant mettre à jour cette espèce dans la base cible :\n\n```\n30-Aug-2019 10:03:09.879 SEVERE [ajp-nio-8009-exec-26] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [default] in context with path [/observeweb] threw exception\n org.debux.webmotion.server.WebMotionException: Error during invoke method for action fr.ird.observe.server.controller.v1.actions.synchro.referential.ng.ReferentialSynchronizeServiceRestApi on method executeSqlsRequests\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.processAction(ExecutorMethodInvokerHandler.java:283)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.handle(ExecutorMethodInvokerHandler.java:225)\n\tat org.debux.webmotion.server.WebMotionFilter.doProcess(WebMotionFilter.java:73)\n\tat org.debux.webmotion.server.WebMotionFilter.doProcess(WebMotionFilter.java:61)\n\tat fr.ird.observe.server.ObserveWebMotionFilter.inject(ObserveWebMotionFilter.java:68)\n\tat sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.processFilter(ExecutorMethodInvokerHandler.java:310)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.handle(ExecutorMethodInvokerHandler.java:222)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler.handle(ExecutorMethodInvokerHandler.java:120)\n\tat org.debux.webmotion.server.WebMotionMainHandler.chainHandlers(WebMotionMainHandler.java:270)\n\tat org.debux.webmotion.server.WebMotionMainHandler.handleExecutors(WebMotionMainHandler.java:260)\n\tat org.debux.webmotion.server.WebMotionMainHandler.handle(WebMotionMainHandler.java:196)\n\tat org.debux.webmotion.server.WebMotionServer.doAction(WebMotionServer.java:159)\n\tat org.debux.webmotion.server.WebMotionServer.doFilter(WebMotionServer.java:136)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\n\tat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)\n\tat org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)\n\tat org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)\n\tat org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\n\tat org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:836)\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1747)\n\tat org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.lang.reflect.InvocationTargetException\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.processAction(ExecutorMethodInvokerHandler.java:255)\n\t... 34 more\nCaused by: org.nuiton.topia.persistence.TopiaException: Could not execute sql code\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport.doSqlWork(HibernateTopiaSqlSupport.java:168)\n\tat fr.ird.observe.persistence.ObserveTopiaPersistenceContext.executeSqlScript(ObserveTopiaPersistenceContext.java:179)\n\tat fr.ird.observe.persistence.ObserveTopiaPersistenceContext.executeSqlScripts(ObserveTopiaPersistenceContext.java:192)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.ng.ReferentialSynchronizeServiceLocal.executeSqlsRequests(ReferentialSynchronizeServiceLocal.java:66)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethod(ObserveServiceFactoryLocal.java:242)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethodWithTransaction(ObserveServiceFactoryLocal.java:263)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invoke(ObserveServiceFactoryLocal.java:230)\n\tat com.sun.proxy.$Proxy200.executeSqlsRequests(Unknown Source)\n\tat fr.ird.observe.server.controller.v1.actions.synchro.referential.ng.GeneratedReferentialSynchronizeServiceRestApi.executeSqlsRequests(GeneratedReferentialSynchronizeServiceRestApi.java:45)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.processAction(ExecutorMethodInvokerHandler.java:255)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.handle(ExecutorMethodInvokerHandler.java:225)\n\tat org.debux.webmotion.server.WebMotionFilter.doProcess(WebMotionFilter.java:73)\n\tat org.debux.webmotion.server.WebMotionFilter.doProcess(WebMotionFilter.java:61)\n\tat fr.ird.observe.server.ObserveWebMotionFilter.inject(ObserveWebMotionFilter.java:68)\n\t... 27 more\nCaused by: org.hibernate.exception.SQLGrammarException: error executing work\n\tat org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)\n\tat org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:325)\n\tat org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2462)\n\tat org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2447)\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport.doSqlWork(HibernateTopiaSqlSupport.java:166)\n\tat fr.ird.observe.persistence.ObserveTopiaPersistenceContext.executeSqlScript(ObserveTopiaPersistenceContext.java:179)\n\tat fr.ird.observe.persistence.ObserveTopiaPersistenceContext.executeSqlScripts(ObserveTopiaPersistenceContext.java:192)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.ng.ReferentialSynchronizeServiceLocal.executeSqlsRequests(ReferentialSynchronizeServiceLocal.java:66)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethod(ObserveServiceFactoryLocal.java:242)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethodWithTransaction(ObserveServiceFactoryLocal.java:263)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invoke(ObserveServiceFactoryLocal.java:230)\n\tat com.sun.proxy.$Proxy200.executeSqlsRequests(Unknown Source)\n\tat fr.ird.observe.server.controller.v1.actions.synchro.referential.ng.GeneratedReferentialSynchronizeServiceRestApi.executeSqlsRequests(GeneratedReferentialSynchronizeServiceRestApi.java:45)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.processAction(ExecutorMethodInvokerHandler.java:255)\n\tat org.debux.webmotion.server.handler.ExecutorMethodInvokerHandler$RunnableHandler.handle(ExecutorMethodInvokerHandler.java:225)\n\tat org.debux.webmotion.server.WebMotionFilter.doProcess(WebMotionFilter.java:73)\n\tat org.debux.webmotion.server.WebMotionFilter.doProcess(WebMotionFilter.java:61)\n\tat fr.ird.observe.server.ObserveWebMotionFilter.inject(ObserveWebMotionFilter.java:68)\n\tat sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\t... 27 more\nCaused by: org.postgresql.util.PSQLException: Unterminated dollar quote started at position 0 in SQL $$_DELETE FROM OBSERVE_COMMON.ocean_species WHERE ocean \u003d \u0027fr.ird.observe.entities.referentiel.Species#1239832684892#0.9272035028442585\u0027;. Expected terminating $$\n\tat org.postgresql.core.Parser.checkParsePosition(Parser.java:1273)\n\tat org.postgresql.core.Parser.parseSql(Parser.java:1173)\n\tat org.postgresql.core.Parser.replaceProcessing(Parser.java:1125)\n\tat org.postgresql.core.CachedQueryCreateAction.create(CachedQueryCreateAction.java:40)\n\tat org.postgresql.core.QueryExecutorBase.createQueryByKey(QueryExecutorBase.java:314)\n\tat org.postgresql.core.QueryExecutorBase.createQuery(QueryExecutorBase.java:325)\n\tat org.postgresql.jdbc.PgConnection.createQuery(PgConnection.java:161)\n\tat org.postgresql.jdbc.PgStatement.addBatch(PgStatement.java:723)\n\tat com.zaxxer.hikari.pool.HikariProxyStatement.addBatch(HikariProxyStatement.java)\n\tat org.nuiton.topia.persistence.script.SqlScriptConsumer.executeByBatch(SqlScriptConsumer.java:198)\n\tat org.nuiton.topia.persistence.script.SqlScriptConsumer.execute(SqlScriptConsumer.java:138)\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport$HibernateTopiaSqlWork.execute(HibernateTopiaSqlSupport.java:91)\n\tat org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)\n\tat org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2443)\n\tat org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2440)\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:320)\n\t... 54 more\n\n\n```",
|
|
|
8
|
+ "labels": [
|
|
|
9
|
+ "Anomalie",
|
|
|
10
|
+ "Immédiat",
|
|
|
11
|
+ "À corriger"
|
|
|
12
|
+ ],
|
|
|
13
|
+ "milestone": {
|
|
|
14
|
+ "id": 958566,
|
|
|
15
|
+ "iid": 148,
|
|
|
16
|
+ "projectId": 2722779,
|
|
|
17
|
+ "groupId": 0,
|
|
|
18
|
+ "title": "7.1.1",
|
|
|
19
|
+ "dueDate": "Sep 12, 2019 2:00:00 AM",
|
|
|
20
|
+ "startDate": "Aug 2, 2019 2:00:00 AM",
|
|
|
21
|
+ "state": "closed"
|
|
|
22
|
+ },
|
|
|
23
|
+ "assignees": [
|
|
|
24
|
+ {
|
|
|
25
|
+ "_id": 166231,
|
|
|
26
|
+ "_username": "tchemit",
|
|
|
27
|
+ "_name": "Tony CHEMIT",
|
|
|
28
|
+ "_state": "active",
|
|
|
29
|
+ "_external": false,
|
|
|
30
|
+ "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"
|
|
|
31
|
+ }
|
|
|
32
|
+ ],
|
|
|
33
|
+ "assignee": {
|
|
|
34
|
+ "_id": 166231,
|
|
|
35
|
+ "_username": "tchemit",
|
|
|
36
|
+ "_name": "Tony CHEMIT",
|
|
|
37
|
+ "_state": "active",
|
|
|
38
|
+ "_external": false,
|
|
|
39
|
+ "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"
|
|
|
40
|
+ },
|
|
|
41
|
+ "author": {
|
|
|
42
|
+ "_id": 1111318,
|
|
|
43
|
+ "_username": "pcauquil",
|
|
|
44
|
+ "_name": "Pascal Cauquil",
|
|
|
45
|
+ "_state": "active",
|
|
|
46
|
+ "_external": false,
|
|
|
47
|
+ "_avatarUrl": "https://secure.gravatar.com/avatar/b4ae117bd93e10d96298fa4d885208ea?s\u003d80\u0026d\u003didenticon"
|
|
|
48
|
+ },
|
|
|
49
|
+ "userNotesCount": 5,
|
|
|
50
|
+ "upVotes": 0,
|
|
|
51
|
+ "downVotes": 0,
|
|
|
52
|
+ "confidential": false,
|
|
|
53
|
+ "timeStats": {
|
|
|
54
|
+ "timeEstimate": 0,
|
|
|
55
|
+ "totalTimeSpent": 0
|
|
|
56
|
+ },
|
|
|
57
|
+ "state": "closed",
|
|
|
58
|
+ "updatedAt": "Sep 12, 2019 12:47:48 PM",
|
|
|
59
|
+ "createdAt": "Aug 30, 2019 10:08:24 AM",
|
|
|
60
|
+ "closedAt": "Sep 12, 2019 12:47:43 PM",
|
|
|
61
|
+ "webUrl": "https://gitlab.com/ultreiaio/ird-observe/issues/1374"
|
|
|
62
|
+ },
|
|
|
63
|
+ {
|
|
|
64
|
+ "id": 24172420,
|
|
|
65
|
+ "iid": 1373,
|
|
|
66
|
+ "projectId": 2722779,
|
|
|
67
|
+ "title": "[LL] Une marée provoque un dépassement mémoire et/ou a un souci de commentaires trop longs",
|
|
|
68
|
+ "description": "En mode serveur, cette marée ne peut pas être insérée en base centrale car elle semble provoquer un dépassement mémoire.\n\nMarée : [obstuna-local-2019-06-11--15-28-31-vf.sql.gz](/uploads/3b3498860d332631f3899d508e1786df/obstuna-local-2019-06-11--15-28-31-vf.sql.gz)\n\nLog serveur : [catalina.out](/uploads/8bc861905549457149f82689be503b3b/catalina.out)",
|
|
|
69
|
+ "labels": [
|
|
|
70
|
+ "Anomalie",
|
|
|
71
|
+ "Haut",
|
|
|
72
|
+ "Palangre"
|
|
|
73
|
+ ],
|
|
|
74
|
+ "milestone": {
|
|
|
75
|
+ "id": 958566,
|
|
|
76
|
+ "iid": 148,
|
|
|
77
|
+ "projectId": 2722779,
|
|
|
78
|
+ "groupId": 0,
|
|
|
79
|
+ "title": "7.1.1",
|
|
|
80
|
+ "dueDate": "Sep 12, 2019 2:00:00 AM",
|
|
|
81
|
+ "startDate": "Aug 2, 2019 2:00:00 AM",
|
|
|
82
|
+ "state": "closed"
|
|
|
83
|
+ },
|
|
|
84
|
+ "assignees": [
|
|
|
85
|
+ {
|
|
|
86
|
+ "_id": 166231,
|
|
|
87
|
+ "_username": "tchemit",
|
|
|
88
|
+ "_name": "Tony CHEMIT",
|
|
|
89
|
+ "_state": "active",
|
|
|
90
|
+ "_external": false,
|
|
|
91
|
+ "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"
|
|
|
92
|
+ }
|
|
|
93
|
+ ],
|
|
|
94
|
+ "assignee": {
|
|
|
95
|
+ "_id": 166231,
|
|
|
96
|
+ "_username": "tchemit",
|
|
|
97
|
+ "_name": "Tony CHEMIT",
|
|
|
98
|
+ "_state": "active",
|
|
|
99
|
+ "_external": false,
|
|
|
100
|
+ "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"
|
|
|
101
|
+ },
|
|
|
102
|
+ "author": {
|
|
|
103
|
+ "_id": 1111318,
|
|
|
104
|
+ "_username": "pcauquil",
|
|
|
105
|
+ "_name": "Pascal Cauquil",
|
|
|
106
|
+ "_state": "active",
|
|
|
107
|
+ "_external": false,
|
|
|
108
|
+ "_avatarUrl": "https://secure.gravatar.com/avatar/b4ae117bd93e10d96298fa4d885208ea?s\u003d80\u0026d\u003didenticon"
|
|
|
109
|
+ },
|
|
|
110
|
+ "userNotesCount": 5,
|
|
|
111
|
+ "upVotes": 0,
|
|
|
112
|
+ "downVotes": 0,
|
|
|
113
|
+ "confidential": true,
|
|
|
114
|
+ "discussionLocked": true,
|
|
|
115
|
+ "timeStats": {
|
|
|
116
|
+ "timeEstimate": 0,
|
|
|
117
|
+ "totalTimeSpent": 0
|
|
|
118
|
+ },
|
|
|
119
|
+ "state": "closed",
|
|
|
120
|
+ "updatedAt": "Sep 12, 2019 12:48:43 PM",
|
|
|
121
|
+ "createdAt": "Aug 26, 2019 6:00:15 PM",
|
|
|
122
|
+ "closedAt": "Sep 12, 2019 12:19:00 PM",
|
|
|
123
|
+ "webUrl": "https://gitlab.com/ultreiaio/ird-observe/issues/1373"
|
|
|
124
|
+ }
|
|
|
125
|
+]
|
|
|
\ No newline at end of file |