From mboxrd@z Thu Jan  1 00:00:00 1970
From: Joao Martins <joao.m.martins@oracle.com>
Subject: Re: BUG: NOW() seems to (sometimes) go backwards!
Date: Wed, 8 Jun 2016 21:36:50 +0100
Message-ID: <575881E2.1080605@oracle.com>
References: <1465314895.15816.165.camel@citrix.com>
 <575812BD02000078000F2F82@prv-mh.provo.novell.com>
 <1465393417.15816.206.camel@citrix.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
Return-path: <xen-devel-bounces@lists.xen.org>
Received: from mail6.bemta3.messagelabs.com ([195.245.230.39])
 by lists.xenproject.org with esmtp (Exim 4.84_2)
 (envelope-from <joao.m.martins@oracle.com>) id 1bAkDB-0004mW-UW
 for xen-devel@lists.xenproject.org; Wed, 08 Jun 2016 20:36:26 +0000
In-Reply-To: <1465393417.15816.206.camel@citrix.com>
List-Unsubscribe: <http://lists.xen.org/cgi-bin/mailman/options/xen-devel>,
 <mailto:xen-devel-request@lists.xen.org?subject=unsubscribe>
List-Post: <mailto:xen-devel@lists.xen.org>
List-Help: <mailto:xen-devel-request@lists.xen.org?subject=help>
List-Subscribe: <http://lists.xen.org/cgi-bin/mailman/listinfo/xen-devel>,
 <mailto:xen-devel-request@lists.xen.org?subject=subscribe>
Errors-To: xen-devel-bounces@lists.xen.org
Sender: "Xen-devel" <xen-devel-bounces@lists.xen.org>
To: Dario Faggioli <dario.faggioli@citrix.com>
Cc: Andrew Cooper <andrew.cooper3@citrix.com>, Tim Deegan <tim@xen.org>, George Dunlap <george.dunlap@citrix.com>, Jan Beulich <JBeulich@suse.com>, "xen-devel@lists.xenproject.org" <xen-devel@lists.xenproject.org>
List-Id: xen-devel@lists.xenproject.org

T24gMDYvMDgvMjAxNiAwMjo0MyBQTSwgRGFyaW8gRmFnZ2lvbGkgd3JvdGU6Cj4gT24gV2VkLCAy
MDE2LTA2LTA4IGF0IDA0OjQyIC0wNjAwLCBKYW4gQmV1bGljaCB3cm90ZToKPj4+Pj4gT24gMDcu
MDYuMTYgYXQgMTc6NTQsIDxkYXJpby5mYWdnaW9saUBjaXRyaXguY29tPiB3cm90ZToKPj4+IFNv
LCBpdCBsb29rcyB0byBtZSB0aGF0IHRoZSBUU0MgaXMgYWN0dWFsbHkgb2ssIGFuZCBpdCBjb3Vs
ZCBiZSB0aGUKPj4+IGxvY2FsX3RzY19zdGFtcCBhbmQgc2NhbGVfZGVsdGEoKSBtYWdpYyBkb25l
IGluIGdldF9zX3RpbWVfZml4ZWQoKQo+Pj4gKHdoaWNoLCBBRkFJQ1VJLCBpcyB0aGVyZSB0byBj
b252ZXJ0IGN5Y2xlcyB0byB0aW1lKSB0aGF0IGRvZXMgbm90Cj4+PiBndWFyYW50ZWUgdGhlIHJl
c3VsdCB0byBiZSBtb25vdG9uaWMsIGV2ZW4gaWYgdGhlIGlucHV0IGlzLi4uCj4+PiBUaG91Z2h0
cz8KPj4gSW5kZWVkIHRoaXMgc21lbGxzIGxpa2UgYW4gaXNzdWUgaW4gdGhlIHNjYWxpbmcuIEhv
d2V2ZXIsIHRoZSBzY2FsaW5nCj4+IHZhbHVlcyB2YXJ5IG9ubHkgd2hlbiAhQ09OU1RBTlRfVFND
LiBDYW4geW91IGNoZWNrIHRoYXQgdGhpcwo+PiBmbGFnIGlzIGFjdHVhbGx5IHNldCBvbiB0aGF0
IHN5c3RlbT8gCj4+Cj4gQ2hlY2tlZC4gSSBkbyBoYXZlIGl0LiBJIGluc3RydW1lbnRlZCB0aGUg
Y29kZSB0byBwcmludCBzdHVmZiBpZiBpdAo+IGZpbmRzIGl0LCBhbmQgaXQgcHJpbnRzLgo+IAo+
IEFsc286Cj4gcm9vdEBaaGFtYW46fiMgeGwgZGVidWcta2V5cyBzCj4gKFhFTikgWyAgNDA2Ljcx
OTQ2NF0gVFNDIG1hcmtlZCBhcyByZWxpYWJsZSwgd2FycCA9IDAgKGNvdW50PTMpCj4gKFhFTikg
WyAgNDA2LjcxOTQ2N10gZG9tMShodm0pOiBtb2RlPTAsb2ZzPTB4ZmZmZmQ5Mjc5NzE2YzI3Nixr
aHo9MjM5NDA2OSxpbmM9NCx2dHNjIGNvdW50OiAxOTUzNjcga2VybmVsLCAwIHVzZXIKPiAKPj4g
KEkgaG9wZSB5b3UncmUgbm90IHJ1bm5pbmcgYQo+PiBzdHJhbmdlIERvbTAgc2V0dXAgd2l0aCBG
UkVRQ1RMX2RvbTBfa2VybmVsIGluIGVmZmVjdC4pIAo+Pgo+IEkndmUgbm8gaWRlYSB3aGF0IHRo
aXMgaXMuIEkndmUgYmVlbiBydW5uaW5nIDQuMS4wLCBidWlsdCBteXNlbGYsIGFuZAo+IHN0b2Nr
IERlYmlhbiB1bnN0YWJsZSA0LjUuMCwgYW5kIEknbSBzZWVpbmcgdGhlIGlzc3VlIGluIGJvdGgg
Y2FzZXMuCj4gCj4gTG9va2luZyBGUkVRQ1RMX2RvbTBfa2VybmVsIHVwLCBJIGd1ZXNzIHlvdSBt
ZWFuIHdoYXQgaGFwcGVucyB3aGVuIG9uZQo+IHBhc3NlcyBjcHVmcmVxPSJkb20wLWtlcm5lbCIg
dG8geGVuIG9uIGJvb3QgY29tbWFuZCBsaW5lLiBJbiB3aGljaAo+IGNhc2UsIG5vLCBJJ20gbm90
IGRvaW5nIHRoYXQuCj4gCj4+IEFuZAo+PiBhdCB0aGUgc2FtZSB0aW1lIHRoYXQgaXQncyB0aW1l
X2NhbGlicmF0aW9uX3RzY19yZW5kZXp2b3VzKCkgdGhhdAo+PiBpcyBpbiB1c2U/Cj4+Cj4gVGhl
IGNvZGUgeW91J3JlIHJlZmVycmluZyB0byBzaG91bGQgYmUgdGhpczoKPiAKPiAgICAgLyogSWYg
d2UgaGF2ZSBjb25zdGFudC1yYXRlIFRTQ3MgdGhlbiBzY2FsZSBmYWN0b3IgY2FuIGJlIHNoYXJl
ZC4gKi8KPiAgICAgaWYgKCBib290X2NwdV9oYXMoWDg2X0ZFQVRVUkVfQ09OU1RBTlRfVFNDKSAp
Cj4gICAgIHsKPiAgICAgICAgIC8qIElmIFRTQ3MgYXJlIG5vdCBtYXJrZWQgYXMgJ3JlbGlhYmxl
JywgcmUtc3luYyBkdXJpbmcgcmVuZGV6dm91cy4gKi8KPiAgICAgICAgIGlmICggIWJvb3RfY3B1
X2hhcyhYODZfRkVBVFVSRV9UU0NfUkVMSUFCTEUpICkKPiAgICAgICAgICAgICB0aW1lX2NhbGli
cmF0aW9uX3JlbmRlenZvdXNfZm4gPSB0aW1lX2NhbGlicmF0aW9uX3RzY19yZW5kZXp2b3VzOwo+
ICAgICB9Cj4gCj4gQW5kIEkgaGF2ZSBib3RoIFg4Nl9GRUFUVVJFX0NPTlNUQU5UX1RTQyBhbmQg
WDg2X0ZFQVRVUkVfVFNDX1JFTElBQkxFLgo+IAo+IEkndmUgYWdhaW4gaW5zdHJ1bWVudGVkIHRo
ZSBjb2RlIGluIG9yZGVyIHRvIGNoZWNrIHdoZXRoZXIgaXQgaXMKPiB0aW1lX2NhbGlicmF0aW9u
X3RzY19yZW5kZXp2b3VzKCkgb3IgdGltZV9jYWxpYnJhdGlvbl9zdGRfcmVuZGV6dm91cygpCj4g
dGhhdCBpcyBiZWluZyB1c2VkLCBhbmQgaXQncyB0aGUgbGF0dGVyOgo+IAo+IChYRU4pIFsgICAg
MS43OTU5MTZdIFRTQyByZWxpYWJsZS4gWWF5ISEgVXNpbmcgZmZmZjgyZDA4MDE5ODM2MiBmb3Ig
cmVuZGV2b3VzZXoKPiAKPiBbZGFyaW9AU29sYWNlIHhlbi5naXRdICQgb2JqZHVtcCAtRCB4ZW4v
eGVuLXN5bXMgfGdyZXAgZmZmZjgyZDA4MDE5ODM2Mgo+IGZmZmY4MmQwODAxOTgzNjIgPHRpbWVf
Y2FsaWJyYXRpb25fc3RkX3JlbmRlenZvdXM+Ogo+IAo+IHdoaWNoIGxvb2tzIGNvcnJlY3QgdG8g
bWUuClByb2JhYmx5IG9uZSBvdGhlciBjb2RlcGF0aCB0aGF0IHlvdSB3b3VsZCBiZSBpbnRlcmVz
dGVkIGlzIG9uCmxvY2FsX3RpbWVfY2FsaWJyYXRpb24oKSBjb21tZW50aW5nIHRoZSBjaHVuayBv
biB0aGlzIGNvbmRpdGlvbmFsOgoKaWYgKCBib290X2NwdV9oYXMoWDg2X0ZFQVRVUkVfQ09OU1RB
TlRfVFNDICkKewouLi4KfQoKQW5kIHdpdGggdGhhdCB5b3UgcmFyZWx5IHNlZSB0aW1lIGdvaW5n
IGJhY2t3YXJkcyBzaW5jZSB0aGUgc2NhbGluZyB3b3VsZCBiZQphZGp1c3RlZCB0byBlYWNoIGNw
dSBjYWxpYnJhdGlvbiBlcnJvciAtIGJ1dCBpdCB3b3VsZCBiZSBhICh2ZXJ5IHZlcnkgY2xvc2Up
CmFwcHJveGltYXRpb24gb24gc29mdHdhcmUgbm90IGV4YWN0bHkgZ3VhcmFudGVlZCBhcyBoYXJk
d2FyZSBUU0MuIEJ1dCB0cnlpbmcgdGhpcyBvdXQKd291bGQgYmUganVzdCBmb3IgZXhwZXJpbWVu
dGF0aW9uIC0gZG9lc24ndCBsb29rIHRvIGJlIGEgY29ycmVjdCB3YXkgb2YgYWRkcmVzc2luZyB0
aGlzLgoKPiAKPj4gWWV0IHdoZW4gdGhlIHNjYWxpbmcgdmFsdWVzIGdldCBzZXQgb25seSBvbmNl
IGF0IGJvb3QsIG1vbm90b25pYwo+PiAoY3Jvc3MtQ1BVKSBUU0MgbWVhbnMgbW9ub3RvbmljIChj
cm9zcy1DUFUpIHJldHVybnMgZnJvbSBOT1coKS4KPj4KPiBZZXAuIEFuZCBhdCB0aGlzIHBvaW50
LCB0aGlzIGlzIHdoYXQgbmVlZHMgdG8gYmUgdmVyaWZpZWQsIEkgZ3Vlc3MuLi4KSSB0aGluayBn
ZXRfc190aW1lX2ZpeGVkIGRvZXNuJ3QgZ3VhcmFudGVlIG1vbm90b25pY2l0eSBhY3Jvc3MgQ1BV
cyBiZWluZyBpdApkaWZmZXJlbnQgc29ja2V0IG9yIChTTVQpIHNpYmxpbmdzLiBsb2NhbF90c2Nf
c3RhbXAgaXMgc2VlZGVkIGRpZmZlcmVudGx5IG9uIGVhY2ggQ1BVCmkuZS4gcmR0c2MoKSByaWdo
dCBhZnRlciBkb2luZyB0aGUgcGxhdGZvcm0gdGltZSByZWFkIG9uIHRoZSBjYWxpYnJhdGlvbiBy
ZW5kZXp2b3VzLgpQbHVzIHN0aW1lX2xvY2FsX3N0YW1wIGlzIHNlZWRlZCB3aXRoIHZhbHVlcyB0
YWtlbiBmcm9tIHBsYXRmb3JtIHRpbWVyIChIUEVULCBBQ1BJLApQSVQpIG9uIGxvY2FsX3RpbWVf
Y2FsaWJyYXRpb24gd2hpY2ggbWVhbnMgdGhhdCBnZXRfc190aW1lIGlzbid0IHNvbGVseSBiYXNl
ZCBvbiBUU0MKYW5kIHRoYXQgdGhlcmUgd2lsbCBhbHdheXMgYmUgYSBnYXAgYmV0d2VlbiBzdGlt
ZV9sb2NhbF9zdGFtcCBhbmQgbG9jYWxfdHNjX3N0YW1wLgpUU0MgaXMgaW5kZWVkIG1vbm90b25p
YyBvbiBhIFRTQyBpbnZhcmlhbnQgYm94LCBidXQgdGhlIGRlbHRhIHRoYXQgaXMgY29tcHV0ZWQK
ZGlmZmVycyBmcm9tIGNwdSB0byBjcHUgYWNjb3JkaW5nIHRvIHdoZW4gdGltZSBjYWxpYnJhdGlv
biBoYXBwZW5zIG9uIGVhY2ggQ1BVIC0gdGh1cwpub3QgZ3VhcmFudGVlaW5nIHRoZSBkZXNpcmVk
IG1vbm90b25pY2l0eSBwcm9wZXJ0eS4gSGF2aW5nIHN0aW1lX2xvY2FsX3N0YW1wIGJlIGJhc2Vk
Cm9uIHRoZSBzYW1lIHRpbWVzdGFtcCB0aGF0IG9mIHRoZSBsb2NhbF90c2Nfc3RhbXAgcGx1cyBo
YXZpbmcgYSBzaW5nbGUKbG9jYWxfdHNjX3N0YW1wIGFzIHJlZmVyZW5jZSB3b3VsZCBhZGRyZXNz
IHRoaXMgYmVoYXZpb3VyIC0gc2VlIGFsc28gYmVsb3cuCgo+IAo+PiBJbiBhbnkgZXZlbnQgLSBj
b3VsZCB5b3UgdHJ5IHRvIGV4Y2x1ZGUgQy0gYW5kIFAtc3RhdGUgZWZmZWN0cz8gT2YKPj4gY291
cnNlIHRoYXQgbWFrZXMgc2Vuc2Ugb25seSBpZiB5b3UgY2FuIHJlYXNvbmFibHkgcmVwcm8gdGhl
Cj4+IHByb2JsZW0gc2l0dWF0aW9uIChhbmQgaGVuY2UgY2FuIHRlbGwgZnJvbSBpdHMgYWJzZW5j
ZSBvdmVyIGEgY2VydGFpbgo+PiBwZXJpb2Qgb2YgdGltZSB0aGF0IHdoYXRldmVyIGNoYW5nZSB3
YXMgZG9uZSBkaWQgaGF2ZSBzb21lCj4+IHBvc2l0aXZlIGVmZmVjdCkuCj4+Cj4gSXQncyBhY3R1
YWxseSBxdWl0ZSBoYXJkICpOT1QqIHRvIHJlcHJvZHVjZSB0aGUgcHJvYmxlbS4uLiBpdCBoYXBw
ZW5zCj4gYWxsIHRoZSB0aW1lLCBhbmQgaWYgdGhlIGxvYWQgaXMgaGlnaCBlbm91Z2gsIEkgc2Vl
IHRoZSAiVGltZSB3ZW50Cj4gYmFja3dhcmRzPyIgcHJpbnRrIHNldmVyYWwgdGltZXMgcGVyIHNl
Y29uZCEKPiAKPiBTbywgdHJ5aW5nIHRvIGRvIHdoYXQgeW91IHN1Z2dlc3QgaW4gYW4gb25saW5l
IGZhc2hpb24sIGkuZS4sIGlzc3VlaW5nOgo+IAo+ICAjIHhlbnBtIHNldC1tYXgtY3N0YXRlIDAK
PiAgIyB4ZW5wbSBzZXQtc2NhbGluZy1nb3Zlcm5vciBhbGwgcGVyZm9ybWFuY2UKPiAKPiBkaWQg
bm90IGNoYW5nZSB0aGUgc2l0dWF0aW9uIChJIHN0aWxsIHNlZSB0aGUgcHJpbnRrcykuCj4gCj4g
SSd2ZSB0aGVuIHRyaWVkIHBhc3NpbmcgYm90aCBjcHVmcmVxPSJub25lIiBhbmQgbWF4X2NzdGF0
ZT0wIHRvIHhlbiBhdAo+IGJvb3QsIGJ1dCB0aGV5IG1hZGUgbm8gZGlmZmVyZW5jZSBhdCBhbGwg
ZWl0aGVyLgo+IAo+IE1vc3Qgb2YgdGhlIHRpbWUsIHdlJ3JlIHNwZWFraW5nIG9mIHZlcnkgc21h
bGwgc2tld3MsIGUuZy46Cj4gCj4gKFhFTikgWyAgIDU5Ljk5OTk1OV0gV0FSTklORzogX191cGRh
dGVfcnVucV9sb2FkOiBUaW1lIHdlbnQgYmFja3dhcmRzPyBub3cgNTk5OTk5NDYwNzkgbGx1IDU5
OTk5OTQ2MDg1Cj4gKFhFTikgWyAgMTE3LjU5NTUwOF0gV0FSTklORzogX191cGRhdGVfcnVucV9s
b2FkOiBUaW1lIHdlbnQgYmFja3dhcmRzPyBub3cgMTE3NTk1NDk1Mjk1IGxsdSAxMTc1OTU0OTUz
MTAKPiAKPiBpLmUuLCA2IG5hbm9zZWNvbmRzIG9yIDE1IG5hbm9zZWNvbmRzIQo+IAo+IFRoZW4g
dGhlcmUgYXJlIGluc3RhbmNlcyB3aGVyZSB0aGUgZGlmZmVyZW5jZSBpcyBiaWdnZXIgKG1pY3Jv
c2Vjb25kcwo+IHRpbWUgc2NhbGUsIGxpa2UgaW4gdGhlIGZpcnN0IGVtYWlsIG9mIHRoZSB0aHJl
YWQpLgpJdCBkb2VzIHNvdW5kIHNpbWlsYXIgdG8gdGhlIGNyb3NzIGNwdSBjYWxpYnJhdGlvbiBl
cnJvciBJIHdhcyBvYnNlcnZpbmcgYnV0IG9uIGEKcGxhY2Ugb3RoZXIgdGhhbiBndWVzdHMgcHYg
dGltZSBpbmZvcyB1cGRhdGVzLiBNeSBwdmNsb2NrIFRTQyBzdGFibGUgYml0IHNlcmllcyBjb3Vs
ZAphZGRyZXNzIHlvdXIgaXNzdWUgLSBidXQgb25seSBmb3IgY2xvY2tzb3VyY2U9dHNjIGFkZGVk
IHRoZXJlLCB0aG91Z2ggaXQgd291bGQgYmUKcXVpdGUgbGltaXRhdGl2ZSBmb3IgdGhlIG90aGVy
IGNhc2VzIGkuZS4gY2xvY2tzb3VyY2U9aHBldHxhY3BpfGV0Yy4KCk9uZSBwYXRjaCBpbiB0aGUg
UkZDIG9mIHRoYXQgc2VyaWVzLCBjb3VsZCBmaXggeW91ciBpc3N1ZSBidXQgaXQgd2FzIG1vcmUg
b2YgYSBoYWNreQpwYXRjaCBmb3IgZGlzY3Vzc2lvbiBbMF0uIEl0IGNvbnZlcnRzIGEgdmFsdWUg
cmV0dXJuZWQgZnJvbSB0aGUgcGxhdGZvcm0gdGltZXIgKHdoaWNoCm1vbm90b25pY2FsbHkgaW5j
cmVhc2VzKSBhbmQgc2NhbGVzIGl0IHRvIHRoZSBlcXVpdmFsZW50IGluIFRTQywgYXNzdW1pbmcg
dGhlIFRTQyBpcwphbHdheXMgYWhlYWQgb2YgdGhlIG90aGVyIGNsb2Nrc291cmNlcy4gQnV0IHBy
b2JhYmx5IHRoZSBjb3JyZWN0IGZpeCB3b3VsZCBiZSB0byBkbwphcyBsaW51eCBkb2VzIHdpdGgg
cHZjbG9jaz8gTGludXgga2VlcHMgYW4gYWNjdW11bGF0b3IgcmVwcmVzZW50aW5nIHRoZSBsYXRl
c3Qgc3lzdGVtCnRpbWUgYWNyb3NzIENQVXMgYW5kIGF0b21pY2FsbHkgdXBkYXRlIGl0IGlmIG5v
dyA+IGxhc3QuIFRodXMgYWx3YXlzIHJldHVybmluZyB0aGUKbW9zdCB1cC10by1kYXRlIHZhbHVl
LiBCdXQgdGhlbiBOT1coKSB3b3VsZCB0YWtlIGEgaGl0IGluIHBlcmZvcm1hbmNlLgoKWzBdIGh0
dHA6Ly9saXN0cy54ZW5wcm9qZWN0Lm9yZy9hcmNoaXZlcy9odG1sL3hlbi1kZXZlbC8yMDE1LTEy
L21zZzAyODMyLmh0bWwKCkNoZWVycywKSm9hbwoKX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX18KWGVuLWRldmVsIG1haWxpbmcgbGlzdApYZW4tZGV2ZWxAbGlz
dHMueGVuLm9yZwpodHRwOi8vbGlzdHMueGVuLm9yZy94ZW4tZGV2ZWwK