Open kvokka opened 1 year ago
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 "-"
Thanks for the bug report. Will look into it. https://github.com/devops-works/slowql/blob/main/database/mysql/mysql.go#L72
Thank you for your quick reaction and attention to this bug!
Using this command for slowql-replayer
/mnt/disks/data/mysql-slow.log:
Get in the return with such output (multiple times):