View Issue Details

IDProjectCategoryView StatusLast Update
0005380SymmetricDSBugpublic2023-09-13 17:25
Reportershikhar.srivastava Assigned Tojvanmeter  
Priorityurgent 
Status closedResolutionopen 
Product Version3.13.5 
Summary0005380: [Postgres Data replication fails] java.lang.RuntimeException: Could not convert a value of 2022-07-11 10:54:59.860155 -00:00 for
DescriptionData 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 ReproduceSteps:-
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.
TagsNo tags attached.

Relationships

related to 0005381 closed [Postgres Data replication fails] ERROR: column "address" is of type inet but expression is of type character varying 

Activities

emiller

2022-08-01 14:07

developer   ~0002125

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?

shikhar.srivastava

2022-08-03 05:32

reporter   ~0002138

Attached the details in related ticket https://www.symmetricds.org/issues/view.php?id=5381

jvanmeter

2022-08-10 17:33

developer   ~0002151

Have you set any feature parameters that we need to set in order to reproduce this issue?

Issue History

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