Does not work with MySQL 5.6 slow log

[kvokka]

Using this command for slowql-replayer

./replayer_linux_amd64 -db rp2 -f /mnt/disks/data/mysql-slow.log -h 10.240.0.39 -u user -password PASS -k mysql

/mnt/disks/data/mysql-slow.log:

Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.6.35-80.0-log (Percona Server (GPL), Release 80.0, Revision f113994f31). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 170213 16:00:33
# User@Host: replaypoker[replaypoker] @  [10.240.0.7]  Id:  2459
# Schema: rp2  Last_errno: 0  Killed: 0
# Query_time: 26.717140  Lock_time: 0.000178  Rows_sent: 0  Rows_examined: 989715  Rows_affected: 989715
# Bytes_sent: 58
use rp2;
SET timestamp=1487001633;
replace into user_ranks(user_id, rank) select u.id as pId, @pRank := @pRank + 1 as curr_rank from users as u join (select @prank:=0) r where u.state='active' order by playfunds desc;

Get in the return with such output (multiple times):

ERRO[0000] time: error converting 170213 to time: parsing time "170213" as "2006-01-02T15:04:05Z07:00": cannot parse "13" as "-"

[leucos]

Thanks for the bug report. Will look into it. https://github.com/devops-works/slowql/blob/main/database/mysql/mysql.go#L72

[kvokka]

Thank you for your quick reaction and attention to this bug!