HandlerSocket-Plugin-for-MySQL icon indicating copy to clipboard operation
HandlerSocket-Plugin-for-MySQL copied to clipboard

The binlog execute time is wrong

Open rj03hou opened this issue 14 years ago • 1 comments

at 3739797

#700101 8:00:00 server id 211603306 end_log_pos 3739693 Delete_rows: table id 46 flags: STMT_END_F

BINLOG ' AAAAABNqz5wMLQAAAAcQOQAAAC4AAAAAAAEABHRlc3QABXRlc3QyAAIDAwAA AAAAABlqz5wMJgAAAC0QOQAAAC4AAAAAAAEAAv/8DicAAAIAAAA= '/!/;

DELETE FROM test.test2

WHERE

@1=9998 /* INT meta=0 nullable=0 is_null=0 */

@2=2 /* INT meta=0 nullable=0 is_null=0 */

at 574

#700101 8:00:00 server id 211603306 end_log_pos 574 Table_map: test.ctest mapped to number 33 #700101 8:00:00 server id 211603306 end_log_pos 620 Write_rows: table id 33 flags: STMT_END_F

BINLOG ' AAAAABNqz5wMLgAAAD4CAAAAACEAAAAAAAEABHRlc3QABWN0ZXN0AAMIAwMAAA== AAAAABdqz5wMLgAAAGwCAAAAACEAAAAAAAEAA//4UiHtMAAAAAABAAAAAgAAAA== '/!/;

INSERT INTO test.ctest

SET

@1=820846930 /* LONGINT meta=0 nullable=0 is_null=0 */

@2=1 /* INT meta=0 nullable=0 is_null=0 */

@3=2 /* INT meta=0 nullable=0 is_null=0 */

at 620

the time of the execute is always "700101 8:00:00"

client:python,perl server:Percona 5.5.17-55 5.5.17-55 compile handlersocket version:1.0.6-97-g0986a75

rj03hou avatar Feb 22 '12 11:02 rj03hou

Becaues handlersocket didn't set THD's start_time,so the binlog event's when is 0. so .......

zephyrleaves avatar Feb 24 '12 06:02 zephyrleaves