View Issue Details

IDProjectCategoryView StatusLast Update
0004210SymmetricDSBugpublic2022-08-02 15:04
Reportersh Assigned Toelong  
Priorityhigh 
Status closedResolutionno change required 
Product Version3.11.2 
Summary0004210: Incorrect time stamp inserted into MySQL database
DescriptionWhen I look at the incoming batches being sent to mysql database from the sybase-origin. I can see the insert statements in the file e.g.
insert,62129,"2012-09-10 14:57:05.673"

But when I check the MySQL database all other columns have correct data but the date column, is 1 hour apart.
62129 | 2012-09-10 13:57:05.673

Some rows have their date correctly copied over and some don't. I do not know how they could be inconstancy there. I've noticed the purge job is also not clearing out the files on the incoming jobs. When I read the file to see what sql statements were to be done and check it on the mysql. It appears to have copied over successfully, so I do not understand why the purge job isn't clearing out those files. I have the purge job set to run every 5minutes, but files are still kept. The purge job is successfully clearing files from the outgoing job on the sending node. But not clearing files from the incoming job on the receiving node.
TagsNo tags attached.

Activities

elong

2022-08-02 15:04

developer   ~0002135

The issue tracker is for bugs and features. Please use forums for questions and troubleshooting. Timestamps are converted using local time zone. Set the timezone with -Duser.timezone=GMT in bin/sym and conf/sym_service.conf.

Issue History

Date Modified Username Field Change
2019-12-18 10:20 sh New Issue
2022-08-02 15:04 elong Assigned To => elong
2022-08-02 15:04 elong Status new => closed
2022-08-02 15:04 elong Resolution open => no change required
2022-08-02 15:04 elong Note Added: 0002135