View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004210 | SymmetricDS | Bug | public | 2019-12-18 10:20 | 2022-08-02 15:04 |
Reporter | sh | Assigned To | elong | ||
Priority | high | ||||
Status | closed | Resolution | no change required | ||
Product Version | 3.11.2 | ||||
Summary | 0004210: Incorrect time stamp inserted into MySQL database | ||||
Description | When 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. | ||||
Tags | No tags attached. | ||||