2019-05-21 08 39 40 245 ERROR --- ntloop-thread-1 nsud kafka UpdateReq

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
2019-05-21 08:39:40.245 ERROR 1 --- [ntloop-thread-1] d.nsud.kafka.UpdateRequestKafkaHandler : Ошибка выполнения запроса [update Permission.permission SET statust='DECLINED' WHERE id=1] с идентификатором [97ac1895-39ba-4f1b-914d-b3f76637d75f]
java.sql.SQLException: Error while preparing statement [update Permission.permission SET statust='DECLINED' WHERE id=1]
at org.apache.calcite.avatica.Helper.createException(Helper.java:56) ~[avatica-core-1.13.0.jar!/:1.13.0]
at org.apache.calcite.avatica.Helper.createException(Helper.java:41) ~[avatica-core-1.13.0.jar!/:1.13.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:218) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:200) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:91) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175) ~[avatica-core-1.13.0.jar!/:1.13.0]
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:567) ~[c3p0-0.9.5.2.jar!/:0.9.5.2]
at dev.nsud.services.impl.QueryExecutorServiceImpl$executeUpdate$1$1.handle(QueryExecutorServiceImpl.kt:49) ~[classes!/:na]
at dev.nsud.services.impl.QueryExecutorServiceImpl$executeUpdate$1$1.handle(QueryExecutorServiceImpl.kt:30) ~[classes!/:na]
at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$2(ContextImpl.java:272) ~[vertx-core-3.6.3.jar!/:3.6.3]
at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[vertx-core-3.6.3.jar!/:3.6.3]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_212]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_212]
at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.33.Final.jar!/:4.1.33.Final]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_212]
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 28: Object 'PERMISSION' not found within 'public.permission'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_212]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_212]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_212]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_212]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:787) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:772) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4788) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:127) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:977) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateUpdate(SqlValidatorImpl.java:4554) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.SqlUpdate.validate(SqlUpdate.java:190) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:928) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:632) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:556) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:265) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:231) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:772) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:636) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:606) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:229) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:211) ~[calcite-core-1.18.0.jar!/:1.18.0]
... 12 common frames omitted
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'PERMISSION' not found within 'public.permission'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_212]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_212]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_212]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_212]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463) ~[calcite-core-1.18.0.jar!/:1.18.0]
at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572) ~[calcite-core-1.18.0.jar!/:1.18.0]
... 31 common frames omitted
2019-05-21 08:39:40.245 INFO 1 --- [ntloop-thread-1] d.nsud.services.impl.PublishServiceImpl : Отправка сообщения с идентификатором [97ac1895-39ba-4f1b-914d-b3f76637d75f] в топик [errorTopic]
2019-05-21 08:39:40.248 INFO 1 --- [ntloop-thread-1] d.nsud.services.impl.PublishServiceImpl : Сообщение с идентификатором [97ac1895-39ba-4f1b-914d-b3f76637d75f] успешно отправлено в топик [errorTopic]
2019-05-21 08:40:51.248 INFO 1 --- [ntloop-thread-0] d.n.d.handler.JdbcQueryResultHandler : Обработка записи с идентификатором 36c5ef5a-f7ce-4c92-9391-0780bedabff5
2019-05-21 08:40:51.251 WARN 1 --- [ntloop-thread-0] d.n.d.s.impl.JdbcQueryServiceImpl : Не найден обработчик для сообщения с id = [36c5ef5a-f7ce-4c92-9391-0780bedabff5]