Comment 10 for bug 1372501

Revision history for this message
Muhammad Irfan (muhammad-irfan) wrote :

I replicated by using provided table definitions, trigger and my.cnf. I tried with 3 node cluster and all machines running NTP and time is synchronized on all nodes. I noticed stamp value for TIMESTAMP column inserted properly on my test case on all nodes of the cluster.

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE '%version%';
+-------------------------+-----------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------+
| innodb_version | 5.6.22-72.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 10.0.17-MariaDB-wsrep |
| version_comment | MariaDB Server, wsrep_25.10.r4144 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_malloc_library | bundled jemalloc |
+-------------------------+-----------------------------------+
8 rows in set (0.00 sec)

[root@centos1 ~]# mysqlslap --concurrency=500 --iterations=100 --no-drop --create-schema=test --query="INSERT INTO estadisticos_ws ( tx, msisdn, nodo, stamp, duracion, wsid, error ) VALUES ('0xc70748a05bb2', 56988659040,47, now(), 1, 2, 0);" --verbose

MariaDB [test]> SELECT * FROM estadisticos_ws;
+------------+----------------+-------------+------+---------------------+----------+-------+------+
| id | tx | msisdn | nodo | stamp | duracion | error | wsid |
+------------+----------------+-------------+------+---------------------+----------+-------+------+
| 4546612239 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612242 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612245 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612248 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612251 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612254 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612257 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612260 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612263 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
| 4546612266 | 0xc70748a05bb2 | 56988659040 | 47 | 2015-05-21 05:53:08 | 1 | 0 | 2 |
+------------+----------------+-------------+------+---------------------+----------+-------+------+

We would need repeatable test case to try to reproduce it.