MySQL Forums
Forum List  »  General

Re: WHY: Same timestamp for two different records from two different sessions
Posted by: Kristijan Marin
Date: January 27, 2019 05:42AM


I found it !!

God .... When a new message comes in, it is also inserted into the "dispatch queue" table ...
so that the system can send a notification to users about this new message
I have a flag AlreadyDispathed that "dispatch method " sets to 1 when the message notification is
sent out .... and by setting this flag to 1, triggered an update trigger that was setting lastupdate to
unix_timestamp ....

What I also found out is that unix_timestamp stays the same for the whole session...

and cause this "dispatch" method on the server takes "all" messages at once ...

they are all processed in the same "unix_timestamp" ...

And that's the reason for my problem.

Peter THANK YOU million times for your hints & suggestions that led me to the solution.

Have a great weekend.

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.