Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Listening for transport dt_socket at address: 8787
- . ____ _ __ _ _
- /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
- ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
- \\/ ___)| |_)| | | | | || (_| | ) ) ) )
- ' |____| .__|_| |_|_| |_\__, | / / / /
- =========|_|==============|___/=/_/_/_/
- :: Spring Boot :: (v2.1.3.RELEASE)
- 28.05 16:13:39.229 INFO [SpringApplication:679] - The following profiles are active: dev
- 28.05 16:13:40.218 INFO [GenericScope:295] - BeanFactory id=1ffe271a-3124-37e2-9d1f-96e6265922be
- 28.05 16:13:41.093 INFO [HikariDataSource:110] - "DbSegmentsPool" - Starting...
- 28.05 16:13:41.324 INFO [HikariDataSource:123] - "DbSegmentsPool" - Start completed.
- 28.05 16:13:41.342 INFO [DatabaseConfiguration:75] - Database "segments" has the following exportable http functions:
- segments.http_get_get_client_segments
- segments.http_get_get_segment
- segments.http_get_get_segment_clients
- segments.http_get_get_segments_by_filter
- utils.http_get_get_status_by_task
- segments.http_post_add_client_to_segment
- segments.http_post_archive_segment
- segments.http_post_count_clients_in_segments
- segments.http_post_create_segment
- segments.http_post_remove_client_from_segment
- utils.http_upload_post_upload_import_clients_to_specific_segment
- utils.http_upload_post_upload_import_segments
- utils.http_upload_post_upload_remove_clients
- utils.http_upload_post_upload_remove_clients_from_specific_segment
- utils.http_upload_pre_upload_import_clients_to_specific_segment
- utils.http_upload_pre_upload_import_segments
- utils.http_upload_pre_upload_remove_clients
- utils.http_upload_pre_upload_remove_clients_from_specific_segment
- 28.05 16:13:41.420 WARN [URLConfigurationSource:121] - No URLs will be polled as dynamic configuration sources.
- 28.05 16:13:41.420 INFO [URLConfigurationSource:122] - To enable URLs as dynamic configuration sources, define System property archaius.configurationSource.additionalUrls or make config.properties available on classpath.
- 28.05 16:13:41.434 WARN [URLConfigurationSource:121] - No URLs will be polled as dynamic configuration sources.
- 28.05 16:13:41.435 INFO [URLConfigurationSource:122] - To enable URLs as dynamic configuration sources, define System property archaius.configurationSource.additionalUrls or make config.properties available on classpath.
- 28.05 16:13:42.028 INFO [EndpointLinksResolver:59] - Exposing 2 endpoint(s) beneath base path '/actuator'
- 28.05 16:13:42.519 WARN [CoreAutoConfiguration:37] - This module is deprecated. It will be removed in the next major release. Please use spring-cloud-netflix-hystrix instead.
- 28.05 16:13:42.730 INFO [NettyWebServer:77] - Netty started on port(s): 8080
- 28.05 16:13:42.732 INFO [StartupInfoLogger:59] - Started DBApiApplication in 4.501 seconds (JVM running for 5.206)
- 28.05 18:12:06.298 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:07.143 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:08.145 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:10.867 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:10.870 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:11.230 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:19.527 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:20.557 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:49.970 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:50.811 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:12:50.838 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:07.576 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:12.759 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:13.485 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:15.546 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:51.389 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:51.570 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:52.558 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:53.556 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:54.641 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:56.334 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:57.366 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:58.271 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:13:59.756 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:39.124 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:40.143 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:41.136 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:41.960 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:42.995 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:51.290 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:52.207 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:14:53.239 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:15:11.376 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_import_clients_segment('{}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.scheduled_import_clients_segment(jsonb) line 67 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callStoredProcedure(JdbcStoredProcedureRepository.java:190)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeStoredProcedure$1(JdbcStoredProcedureRepository.java:66)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.scheduled_import_clients_segment(jsonb) line 67 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:16:30.176 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:16:30.839 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"2"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:16:31.624 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:16:32.238 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:16:58.626 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:16:59.656 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:17:13.708 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:17:14.741 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:17:15.791 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.HTTP_GET_get_status_by_task('{"Accept-Encoding":"gzip,deflate","Host":"172.29.16.173:8090","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_121)","Content-Type":"application/json"}','{"id":"3"}')]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bigint
- Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
- Where: PL/pgSQL function utils.http_get_get_status_by_task(jsonb,jsonb) line 13 at SQL statement
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
- 28.05 18:18:39.190 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM segments.HTTP_POST_archive_segment('{"Accept":"*/*","Postman-Token":"4bd2dd6a-e8b5-4294-b282-b9c55bb039f0","accept-encoding":"gzip, deflate","User-Agent":"PostmanRuntime/7.13.0","Content-Type":"application/json","Cache-Control":"no-cache","Host":"localhost:8090","content-length":"0"}','{"id":"SET1554719144989"}')]; ERROR: array must have even number of elements
- Where: SQL statement "SELECT jsonb_object('{result, -3, message, Cannot archive segment, quantity limit reached}'), 404"
- PL/pgSQL function segments.http_post_archive_segment(jsonb,jsonb) line 46 at RETURN QUERY; nested exception is org.postgresql.util.PSQLException: ERROR: array must have even number of elements
- Where: SQL statement "SELECT jsonb_object('{result, -3, message, Cannot archive segment, quantity limit reached}'), 404"
- PL/pgSQL function segments.http_post_archive_segment(jsonb,jsonb) line 46 at RETURN QUERY
- at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.callHttpStoredProcedure(JdbcStoredProcedureRepository.java:177)
- at ru.crystals.dbapi.service.database.repository.JdbcStoredProcedureRepository.lambda$executeHttpStoredProcedure$0(JdbcStoredProcedureRepository.java:58)
- at reactor.core.publisher.MonoCallable.call(MonoCallable.java:91)
- at reactor.core.publisher.FluxSubscribeOnCallable$CallableSubscribeOnSubscription.run(FluxSubscribeOnCallable.java:225)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
- at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: org.postgresql.util.PSQLException: ERROR: array must have even number of elements
- Where: SQL statement "SELECT jsonb_object('{result, -3, message, Cannot archive segment, quantity limit reached}'), 404"
- PL/pgSQL function segments.http_post_archive_segment(jsonb,jsonb) line 46 at RETURN QUERY
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
- at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
- at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
- at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
- ... 11 common frames omitted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement