API tools faq
paste
Advertisement
fedorm

Untitled

fedorm
Mar 27th, 2019
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 24.90 KB | None | 0 0
raw download clone embed print report
  1. dbapi-service  |
  2. dbapi-service  |   .   ____          _            __ _ _
  3. dbapi-service  |  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
  4. dbapi-service  | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  5. dbapi-service  |  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  6. dbapi-service  |   '  |____| .__|_| |_|_| |_\__, | / / / /
  7. dbapi-service  |  =========|_|==============|___/=/_/_/_/
  8. dbapi-service  |  :: Spring Boot ::        (v2.1.3.RELEASE)
  9. dbapi-service  |
  10. dbapi-service  | 27.03 18:45:57.203 INFO [SpringApplication:679] - The following profiles are active: dev
  11. dbapi-service  | 27.03 18:45:58.061 INFO [GenericScope:295] - BeanFactory id=33f4793b-c415-39d7-8bbd-0e7f26d61578
  12. dbapi-service  | 27.03 18:45:58.551 INFO [HikariDataSource:110] - "DbSegmentsPool" - Starting...
  13. dbapi-service  | 27.03 18:45:58.724 INFO [HikariDataSource:123] - "DbSegmentsPool" - Start completed.
  14. dbapi-service  | 27.03 18:45:58.738 INFO [DatabaseConfiguration:60] - Database "segments" has the following exportable http functions:
  15. dbapi-service  | http_get_get_client_segments
  16. dbapi-service  | http_get_get_segment
  17. dbapi-service  | http_get_get_segment_clients
  18. dbapi-service  | http_get_get_status_by_task
  19. dbapi-service  | http_post_add_client_to_segment
  20. dbapi-service  | http_post_count_clients_in_segments
  21. dbapi-service  | http_post_create_segment
  22. dbapi-service  | http_post_remove_client_from_segment
  23. dbapi-service  | http_upload_post_upload_import_segments
  24. dbapi-service  | http_upload_post_upload_remove_clients
  25. dbapi-service  | http_upload_pre_upload_import_segments
  26. dbapi-service  | http_upload_pre_upload_remove_clients
  27. dbapi-service  | 27.03 18:45:58.835 WARN [URLConfigurationSource:121] - No URLs will be polled as dynamic configuration sources.
  28. dbapi-service  | 27.03 18:45:58.835 INFO [URLConfigurationSource:122] - To enable URLs as dynamic configuration sources, define System property archaius.configurationSource.additionalUrls or make config.properties available on classpath.
  29. dbapi-service  | 27.03 18:45:58.842 WARN [URLConfigurationSource:121] - No URLs will be polled as dynamic configuration sources.
  30. dbapi-service  | 27.03 18:45:58.843 INFO [URLConfigurationSource:122] - To enable URLs as dynamic configuration sources, define System property archaius.configurationSource.additionalUrls or make config.properties available on classpath.
  31. dbapi-service  | 27.03 18:45:59.291 INFO [EndpointLinksResolver:59] - Exposing 2 endpoint(s) beneath base path '/actuator'
  32. dbapi-service  | 27.03 18:45:59.980 WARN [CoreAutoConfiguration:37] - This module is deprecated. It will be removed in the next major release. Please use spring-cloud-netflix-hystrix instead.
  33. dbapi-service  | 27.03 18:46:00.263 INFO [NettyWebServer:77] - Netty started on port(s): 8080
  34. dbapi-service  | 27.03 18:46:00.265 INFO [StartupInfoLogger:59] - Started DBApiApplication in 4.117 seconds (JVM running for 4.852)
  35. dbapi-service  | 27.03 18:46:51.536 ERROR [StoredProcedureHandler:123] - Execute http stored procedure error: {}
  36. dbapi-service  | org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM segments.HTTP_POST_create_segment('{"Accept-Encoding":"gzip,deflate","Content-Length":"164","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"body":{"id":"SET1553701606354","name":"ььь","description":" ттиьиь","date_created":"2019-03-27T18:46:51","date_changed":"2019-03-27T18:46:51","author":"manager"}}')]; ERROR: value too long for type character varying(15)
  37. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  38. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  39. dbapi-service  |    ) ON CONFLICT (id) DO
  40. dbapi-service  |    UPDATE SET
  41. dbapi-service  |        name = P_NAME,
  42. dbapi-service  |        description = P_DESCRIPTION,
  43. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  44. dbapi-service  |        date_end = P_END_DATE,
  45. dbapi-service  |        count_clients = 0,
  46. dbapi-service  |        author = P_AUTHOR"
  47. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  48. dbapi-service  | SQL statement "SELECT segments.create_segment(
  49. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  50. dbapi-service  |        (params->'body')->>'name',
  51. dbapi-service  |        (params->'body')->>'description',
  52. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  53. dbapi-service  |        (params->'body')->>'author')"
  54. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM; nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(15)
  55. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  56. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  57. dbapi-service  |    ) ON CONFLICT (id) DO
  58. dbapi-service  |    UPDATE SET
  59. dbapi-service  |        name = P_NAME,
  60. dbapi-service  |        description = P_DESCRIPTION,
  61. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  62. dbapi-service  |        date_end = P_END_DATE,
  63. dbapi-service  |        count_clients = 0,
  64. dbapi-service  |        author = P_AUTHOR"
  65. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  66. dbapi-service  | SQL statement "SELECT segments.create_segment(
  67. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  68. dbapi-service  |        (params->'body')->>'name',
  69. dbapi-service  |        (params->'body')->>'description',
  70. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  71. dbapi-service  |        (params->'body')->>'author')"
  72. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM
  73. dbapi-service  |    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
  74. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  75. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  76. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  77. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
  78. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
  79. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
  80. dbapi-service  |    at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$1(JdbcStoredProcedureRepository.java:36)
  81. dbapi-service  |    at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
  82. dbapi-service  |    at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
  83. dbapi-service  |    at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
  84. dbapi-service  |    at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
  85. dbapi-service  |    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  86. dbapi-service  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  87. dbapi-service  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  88. dbapi-service  |    at java.lang.Thread.run(Thread.java:748)
  89. dbapi-service  | Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(15)
  90. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  91. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  92. dbapi-service  |    ) ON CONFLICT (id) DO
  93. dbapi-service  |    UPDATE SET
  94. dbapi-service  |        name = P_NAME,
  95. dbapi-service  |        description = P_DESCRIPTION,
  96. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  97. dbapi-service  |        date_end = P_END_DATE,
  98. dbapi-service  |        count_clients = 0,
  99. dbapi-service  |        author = P_AUTHOR"
  100. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  101. dbapi-service  | SQL statement "SELECT segments.create_segment(
  102. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  103. dbapi-service  |        (params->'body')->>'name',
  104. dbapi-service  |        (params->'body')->>'description',
  105. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  106. dbapi-service  |        (params->'body')->>'author')"
  107. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM
  108. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  109. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  110. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  111. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  112. dbapi-service  |    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  113. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
  114. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
  115. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
  116. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
  117. dbapi-service  |    at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
  118. dbapi-service  |    at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
  119. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
  120. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
  121. dbapi-service  |    ... 10 common frames omitted
  122. dbapi-service  | 27.03 18:46:57.752 ERROR [StoredProcedureHandler:123] - Execute http stored procedure error: {}
  123. dbapi-service  | org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM segments.HTTP_POST_create_segment('{"Accept-Encoding":"gzip,deflate","Content-Length":"164","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"body":{"id":"SET1553701606354","name":"ььь","description":" ттиьиь","date_created":"2019-03-27T18:46:57","date_changed":"2019-03-27T18:46:57","author":"manager"}}')]; ERROR: value too long for type character varying(15)
  124. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  125. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  126. dbapi-service  |    ) ON CONFLICT (id) DO
  127. dbapi-service  |    UPDATE SET
  128. dbapi-service  |        name = P_NAME,
  129. dbapi-service  |        description = P_DESCRIPTION,
  130. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  131. dbapi-service  |        date_end = P_END_DATE,
  132. dbapi-service  |        count_clients = 0,
  133. dbapi-service  |        author = P_AUTHOR"
  134. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  135. dbapi-service  | SQL statement "SELECT segments.create_segment(
  136. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  137. dbapi-service  |        (params->'body')->>'name',
  138. dbapi-service  |        (params->'body')->>'description',
  139. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  140. dbapi-service  |        (params->'body')->>'author')"
  141. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM; nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(15)
  142. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  143. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  144. dbapi-service  |    ) ON CONFLICT (id) DO
  145. dbapi-service  |    UPDATE SET
  146. dbapi-service  |        name = P_NAME,
  147. dbapi-service  |        description = P_DESCRIPTION,
  148. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  149. dbapi-service  |        date_end = P_END_DATE,
  150. dbapi-service  |        count_clients = 0,
  151. dbapi-service  |        author = P_AUTHOR"
  152. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  153. dbapi-service  | SQL statement "SELECT segments.create_segment(
  154. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  155. dbapi-service  |        (params->'body')->>'name',
  156. dbapi-service  |        (params->'body')->>'description',
  157. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  158. dbapi-service  |        (params->'body')->>'author')"
  159. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM
  160. dbapi-service  |    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
  161. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  162. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  163. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  164. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
  165. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
  166. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
  167. dbapi-service  |    at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$1(JdbcStoredProcedureRepository.java:36)
  168. dbapi-service  |    at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
  169. dbapi-service  |    at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
  170. dbapi-service  |    at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
  171. dbapi-service  |    at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
  172. dbapi-service  |    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  173. dbapi-service  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  174. dbapi-service  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  175. dbapi-service  |    at java.lang.Thread.run(Thread.java:748)
  176. dbapi-service  | Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(15)
  177. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  178. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  179. dbapi-service  |    ) ON CONFLICT (id) DO
  180. dbapi-service  |    UPDATE SET
  181. dbapi-service  |        name = P_NAME,
  182. dbapi-service  |        description = P_DESCRIPTION,
  183. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  184. dbapi-service  |        date_end = P_END_DATE,
  185. dbapi-service  |        count_clients = 0,
  186. dbapi-service  |        author = P_AUTHOR"
  187. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  188. dbapi-service  | SQL statement "SELECT segments.create_segment(
  189. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  190. dbapi-service  |        (params->'body')->>'name',
  191. dbapi-service  |        (params->'body')->>'description',
  192. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  193. dbapi-service  |        (params->'body')->>'author')"
  194. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM
  195. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  196. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  197. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  198. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  199. dbapi-service  |    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  200. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
  201. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
  202. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
  203. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
  204. dbapi-service  |    at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
  205. dbapi-service  |    at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
  206. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
  207. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
  208. dbapi-service  |    ... 10 common frames omitted
  209. dbapi-service  | 27.03 18:47:26.230 ERROR [StoredProcedureHandler:123] - Execute http stored procedure error: {}
  210. dbapi-service  | org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM segments.HTTP_POST_create_segment('{"Accept-Encoding":"gzip,deflate","Content-Length":"164","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"body":{"id":"SET1553701606354","name":"ььь","description":" ттиьиь","date_created":"2019-03-27T18:47:20","date_changed":"2019-03-27T18:47:20","author":"manager"}}')]; ERROR: value too long for type character varying(15)
  211. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  212. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  213. dbapi-service  |    ) ON CONFLICT (id) DO
  214. dbapi-service  |    UPDATE SET
  215. dbapi-service  |        name = P_NAME,
  216. dbapi-service  |        description = P_DESCRIPTION,
  217. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  218. dbapi-service  |        date_end = P_END_DATE,
  219. dbapi-service  |        count_clients = 0,
  220. dbapi-service  |        author = P_AUTHOR"
  221. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  222. dbapi-service  | SQL statement "SELECT segments.create_segment(
  223. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  224. dbapi-service  |        (params->'body')->>'name',
  225. dbapi-service  |        (params->'body')->>'description',
  226. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  227. dbapi-service  |        (params->'body')->>'author')"
  228. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM; nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(15)
  229. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  230. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  231. dbapi-service  |    ) ON CONFLICT (id) DO
  232. dbapi-service  |    UPDATE SET
  233. dbapi-service  |        name = P_NAME,
  234. dbapi-service  |        description = P_DESCRIPTION,
  235. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  236. dbapi-service  |        date_end = P_END_DATE,
  237. dbapi-service  |        count_clients = 0,
  238. dbapi-service  |        author = P_AUTHOR"
  239. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  240. dbapi-service  | SQL statement "SELECT segments.create_segment(
  241. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  242. dbapi-service  |        (params->'body')->>'name',
  243. dbapi-service  |        (params->'body')->>'description',
  244. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  245. dbapi-service  |        (params->'body')->>'author')"
  246. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM
  247. dbapi-service  |    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
  248. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  249. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  250. dbapi-service  |    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  251. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
  252. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
  253. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
  254. dbapi-service  |    at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$1(JdbcStoredProcedureRepository.java:36)
  255. dbapi-service  |    at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
  256. dbapi-service  |    at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
  257. dbapi-service  |    at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
  258. dbapi-service  |    at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
  259. dbapi-service  |    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  260. dbapi-service  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  261. dbapi-service  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  262. dbapi-service  |    at java.lang.Thread.run(Thread.java:748)
  263. dbapi-service  | Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(15)
  264. dbapi-service  |   Where: SQL statement "INSERT INTO segments.segments (id, name, description, date_created, date_end, count_clients, author) VALUES (
  265. dbapi-service  |        P_ID, P_NAME, P_DESCRIPTION, CURRENT_TIMESTAMP, P_END_DATE, 0, P_AUTHOR
  266. dbapi-service  |    ) ON CONFLICT (id) DO
  267. dbapi-service  |    UPDATE SET
  268. dbapi-service  |        name = P_NAME,
  269. dbapi-service  |        description = P_DESCRIPTION,
  270. dbapi-service  |        date_changed = CURRENT_TIMESTAMP,
  271. dbapi-service  |        date_end = P_END_DATE,
  272. dbapi-service  |        count_clients = 0,
  273. dbapi-service  |        author = P_AUTHOR"
  274. dbapi-service  | PL/pgSQL function segments.create_segment(character varying,text,text,timestamp without time zone,text) line 3 at SQL statement
  275. dbapi-service  | SQL statement "SELECT segments.create_segment(
  276. dbapi-service  |         ((params->'body')->>'id')::VARCHAR,
  277. dbapi-service  |        (params->'body')->>'name',
  278. dbapi-service  |        (params->'body')->>'description',
  279. dbapi-service  |        ((params->'body')->>'end_date')::TIMESTAMP,
  280. dbapi-service  |        (params->'body')->>'author')"
  281. dbapi-service  | PL/pgSQL function segments.http_post_create_segment(jsonb,json) line 13 at PERFORM
  282. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  283. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  284. dbapi-service  |    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  285. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  286. dbapi-service  |    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  287. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
  288. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
  289. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
  290. dbapi-service  |    at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
  291. dbapi-service  |    at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
  292. dbapi-service  |    at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
  293. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
  294. dbapi-service  |    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
  295. dbapi-service  |    ... 10 common frames omitted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!