View Issue Details

IDProjectCategoryView StatusLast Update
0004210SymmetricDSBugpublic2019-12-18 10:20
Reportersh Assigned To 
Priorityhigh 
Status newResolutionopen 
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

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-18 10:20 sh New Issue