MySQL Forums
Forum List  »  General

WHY: Same timestamp for two different records from two different sessions
Posted by: Kristijan Marin
Date: January 26, 2019 07:58AM


I have a table of Messages ... When I insert a new message there is a trigger that sets timestamp value so I can sort on it.

To insert new message we use a web service (state-less,session-less)....

So for every message we call web service & then wait for reply in case of an error.

Our DB has master-to-master replication ...

Sometimes ... if I add manualy two messages one after another, I get the same timestamp for both messages.

There is like 3-5sec needed for single message to be inserted

So how is it possible that we get same timestamp ?


Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.