ERROR: relation "persons" does not exist Position #1542
Description
Describe the bug
Hello I have an issues and maybe it's your wrapper problem.
I have: EKS AWS, RDS
once upon a time in this month I had a problem with lost tables in different database. issue that is was resolving themself after few min or faster.
ERROR: relation "persons" does not exist Position: 349 | 2025-09-03 | 81056 | cif-core
datasource:
driver-class-name: software.amazon.jdbc.Driver
username: cifcore
password: ${DATABASE_PASS}
url: jdbc:aws-wrapper:postgresql://decision-making-system-rds-aurora-pg.cluster-XXXXXXX.ap-southeast-1.rds.amazonaws.com:5432/cifcore
hikari:
maximum-pool-size: 30
schema: cif
transaction-isolation: TRANSACTION_READ_COMMITTED
data-source-properties:
wrapperPlugins: failover,efm,auroraConnectionTracker
failoverClusterTopologyRefreshRateMs: 1000
reWriteBatchedInserts: true
assumeMinServerVersion: 17.0
exception-override-class-name: software.amazon.jdbc.util.HikariCPSQLException
Expected Behavior
no errors
What plugins are used? What other connection properties were set?
software.amazon.jdbc.Driver
Current Behavior
| ERROR: relation "persons" does not exist Position: 349 | 2025-09-03 | 81056 | cif-core | decision-making-system-rds-aurora-pg |
|---|---|---|---|---|
| ERROR: relation "public.motivation_periods" does not exist Position: 175 | 2025-09-22 | 6 | agent-api | confirmations-rds-aurora-pg |
| ERROR: relation "customer" does not exist Position: 63 | 2025-09-03 | 1000 | pg-template-service | payment-gate-rds-aurora-pg |
| ERROR: relation "portraits" does not exist Position: 920 | 2025-09-03 | 357 | biometrics-service | decision-making-system-rds-aurora-pg |
| ERROR: relation "document_type_dictionary" does not exist Position: 57 | 9/22/25 | 213 | Agent-api | confirmations-rds-aurora-pg |
| ERROR: relation "documents_scans" does not exist Position: 1490 | 2025-09-03 | 120 | biometrics-service | decision-making-system-rds-aurora-pg |
| ERROR: relation "template_auto_payment" does not exist Position: 246 | 2025-07-15 | 22 | pg-template-service | payment-gate-rds-aurora-pg |
| ERROR: relation "template_auto_payment" does not exist Position: 246 | 2025-08-19 | 142 | pg-template-service | payment-gate-rds-aurora-pg |
| ERROR: relation "template_auto_payment" does not exist Position: 246 | 2025-09-03 | 90 | pg-template-service | payment-gate-rds-aurora-pg |
81056, 6, 1000, 142 etc it's amount errors
Reproduction Steps
there is no Reproduction Steps available
The problem is appears only than schema is not public
Possible Solution
No response
Additional Information/Context
No response
The AWS Advanced JDBC Driver version used
2.3.6
JDK version used
21
Operating System and version
Amazon Linux 2023