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 12:42:24.565 INFO [SpringApplication:679] - The following profiles are active: dev
- 28.05 12:42:25.795 INFO [GenericScope:295] - BeanFactory id=1ffe271a-3124-37e2-9d1f-96e6265922be
- 28.05 12:42:27.030 INFO [HikariDataSource:110] - DbPool-1559036546417 - Starting...
- 28.05 12:42:27.164 INFO [HikariDataSource:123] - DbPool-1559036546417 - Start completed.
- 28.05 12:42:27.189 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 12:42:27.310 WARN [URLConfigurationSource:121] - No URLs will be polled as dynamic configuration sources.
- 28.05 12:42:27.311 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 12:42:27.324 WARN [URLConfigurationSource:121] - No URLs will be polled as dynamic configuration sources.
- 28.05 12:42:27.325 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 12:42:28.110 INFO [EndpointLinksResolver:59] - Exposing 2 endpoint(s) beneath base path '/actuator'
- 28.05 12:42:28.886 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 12:42:29.125 INFO [NettyWebServer:77] - Netty started on port(s): 8080
- 28.05 12:42:29.128 INFO [StartupInfoLogger:59] - Started DBApiApplication in 5.735 seconds (JVM running for 6.524)
- 28.05 12:43:30.247 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:43:51.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:11.248 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:30.240 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:37.244 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:40.242 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:43.240 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:47.320 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM segments.HTTP_POST_archive_segment('{"Accept-Encoding":"gzip,deflate","Content-Length":"0","Content-Type":"application/json; charset=UTF-8","User-Agent":"Apache-HttpClient/4.5.3 (Java/1.8.0_152)","Accept":"application/json, application/javascript, text/javascript, text/json","Host":"localhost:33289"}','{"id":"Archive_Segments_ID"}')]; 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
- 28.05 12:44:51.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:57.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:44:59.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:45:08.236 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:45:12.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:45:19.239 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:45:32.242 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:45:41.239 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:45:58.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:46:07.502 ERROR [StoredProcedureHandler:100] - Execute http stored procedure error: {}
- org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM segments.HTTP_POST_archive_segment('{"Accept":"*/*","accept-encoding":"gzip, deflate","User-Agent":"PostmanRuntime/7.13.0","Postman-Token":"21a36562-405f-4b3e-8a86-6fb0395c4624","Content-Type":"application/json","Cache-Control":"no-cache","Host":"localhost:33287","content-length":"0"}','{"id":"Archive_Segments_ID"}')]; 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
- 28.05 12:46:45.244 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:46:46.239 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:46:53.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:47:01.240 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:47:10.242 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:47:13.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:47:34.240 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:47:35.242 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:48:19.235 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:48:40.244 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:48:55.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:49:44.238 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:49:57.242 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:50:13.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:50:15.245 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:50:17.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:50:50.240 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:51:13.237 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:51:46.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:52:34.242 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:52:43.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:53:01.237 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:53:36.243 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:53:39.239 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:53:52.240 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:54:00.239 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:54:28.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:54:51.236 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:55:37.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:55:52.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:56:06.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:56:09.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:56:12.241 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:56:21.239 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:57:25.235 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:57:34.235 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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 12:57:40.235 ERROR [Loggers$Slf4JLogger:319] - Operator called default onErrorDropped
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM utils.scheduled_archive_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_archive_segment(jsonb) line 44 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_archive_segment(jsonb) line 44 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement