View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005380 | SymmetricDS | Bug | public | 2022-07-28 10:01 | 2023-09-13 17:25 |
| Reporter | shikhar.srivastava | Assigned To | jvanmeter | ||
| Priority | urgent | ||||
| Status | closed | Resolution | open | ||
| Product Version | 3.13.5 | ||||
| Summary | 0005380: [Postgres Data replication fails] java.lang.RuntimeException: Could not convert a value of 2022-07-11 10:54:59.860155 -00:00 for | ||||
| Description | Data replication fails for Postgres hosted in multiple clusters. Issue occurs over multiple tables. Failed sql was: insert into "ABCD"."IPADDRESS_TABLE" ("id", "created", "last_updated", "address") values (?,?,cast(? as timestamp with time zone),?) on conflict do nothing Failed row data was: "10000001","2022-07-20 10:01:55.534884 -00:00","2022-07-20 10:01:55.534903 -00:00","10.4.3.23/24" java.lang.RuntimeException: Could not convert a value of 2022-07-20 10:01:55.534884 -00:00 for column created of mapped type DATE jdbc type date (91) 2022-07-20 13:54:41,017 INFO [cluster-b] [DefaultDatabaseWriter] [cluster-b-dataloader-539] Failed to process insert event in batch cluster-a-1044 on channel 'siteplanner_object_data'. Failed sql was: insert into "siteplanner"."virtualization_cluster" ("id", "created", "last_updated", "name", "comments", "group_id", "type_id") values (?,?,cast(? as timestamp with time zone),?,?,?,?) on conflict do nothing Failed row data was: "2","2022-07-11 10:54:59.860155 -00:00","2022-07-11 10:54:59.860178 -00:00","Test-Cluster-2","","1","1","1",,"{}" java.lang.RuntimeException: Could not convert a value of 2022-07-11 10:54:59.860155 -00:00 for column created of mapped type DATE jdbc type date (91) | ||||
| Steps To Reproduce | Steps:- 1. 3 clusters with postgres and symmetricds responsible for data replication. 2. Create a table with records as mentioned in the error logs above. 3. Received the error and data replication stops. 4. Works fine with `string`, `bigint` etc. | ||||
| Tags | No tags attached. | ||||
| related to | 0005381 | closed | [Postgres Data replication fails] ERROR: column "address" is of type inet but expression is of type character varying |
|
|
I attempted to reproduce this issue and issue 0005381 using the same columns and values from IPADDRESS_TABLE and I did not run into any errors. I used Postgres 13 and ran the following create and insert statements: create table ipaddress_table (id int primary key, created date, last_updated date, address inet); insert into ipaddress_table values ('10000001', '2022-07-20 10:01:55.534884 -00:00', '2022-07-20 10:01:55.534903 -00:00', '10.4.3.23/24'); What version of Postgres are you using? Also, can you provide the table definition for IPADDRESS_TABLE? |
|
|
Attached the details in related ticket https://www.symmetricds.org/issues/view.php?id=5381 |
|
|
Have you set any feature parameters that we need to set in order to reproduce this issue? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-07-28 10:01 | shikhar.srivastava | New Issue | |
| 2022-07-28 10:09 | shikhar.srivastava | Issue cloned: 0005381 | |
| 2022-07-28 10:09 | shikhar.srivastava | Relationship added | related to 0005381 |
| 2022-08-01 14:07 | emiller | Note Added: 0002125 | |
| 2022-08-01 14:08 | emiller | Status | new => feedback |
| 2022-08-02 17:04 | emiller | Status | feedback => new |
| 2022-08-03 05:32 | shikhar.srivastava | Note Added: 0002138 | |
| 2022-08-10 17:33 | jvanmeter | Note Added: 0002151 | |
| 2022-08-17 17:44 | elong | Assigned To | => jvanmeter |
| 2022-08-17 17:44 | elong | Status | new => feedback |
| 2023-09-13 17:25 | emiller | Status | feedback => closed |