[root@ps1 vagrant]# go run myq_status.go cttf
2015/06/17 15:43:40 bufio.Scanner: token too long
exit status 1

[root@ps1 sbtest]# myq_status cttf
panic: runtime error: slice bounds out of range

goroutine 15 [running]:
github.com/jayjanssen/myq-tools/myqlib.parseSamples.func1(0xc8201569be, 0x17, 0x1642, 0xc82010c00a)
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/parse_show.go:40 +0x2c4
github.com/jayjanssen/myq-tools/myqlib.parseSamples.func2(0xc8201569be, 0x1642, 0x1642, 0x2000, 0x1b0, 0x0, 0x0, 0x0, 0x0, 0x0)
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/parse_show.go:75 +0x313
github.com/jayjanssen/myq-tools/myqlib.(*Scanner).Scan(0xc820047ec8, 0xc8200527e0)
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/Scanner.go:126 +0x36c
github.com/jayjanssen/myq-tools/myqlib.parseSamples(0x7f2a454767a8, 0xc82002e0a0, 0xc820019560, 0x3b9aca00)
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/parse_show.go:91 +0x377
github.com/jayjanssen/myq-tools/myqlib.LiveLoader.harvestMySQL.func4(0xc820019560, 0x7f2a454768a8, 0xc82002e0a0, 0x3b9aca00, 0x0, 0x0)
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:313 +0x9a
created by github.com/jayjanssen/myq-tools/myqlib.LiveLoader.harvestMySQL
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:314 +0x5e0

goroutine 1 [runnable]:
main.main()
/home/travis/gopath/src/github.com/jayjanssen/myq-tools/myq_status.go:169 +0x165d

goroutine 5 [syscall]:
os/signal.loop()
/usr/local/go/src/os/signal/signal_unix.go:22 +0x18
created by os/signal.init.1
/usr/local/go/src/os/signal/signal_unix.go:28 +0x37

interval parsing in parse_show.go waits until it has a full sample and then scans back through the sample to find the uptime to decide if the sample should be dropped. Instead it should watch for the uptime as it scans forward and record it once for that sample when found.

when that value goes over 100k

Hello!

Do you see the possibility to re-add the view for the galera statistics to the latest version? We've been using it for monitoring and it was really handy to quickly get the cluster status.

Version 1.x

~# ./myq_status -a -uroot -a "-S /run/mysql.sock" wsrep

galera / node01 (idx: 1) / Galera 25.3.35(r545d0bf)
         Cluster  Node       Outbound      Inbound       FlowC     Conflct Gcache     Appl
    time P cnf  # stat laten msgs data que msgs data que pause snt lcf bfa   ist  idx  %ef
08:58:36 P  61  3 Sync 0.0ns    6 4.3K   0 1.1m 834M   0   0ns   0   0   0  323k    9 100%

Version: 971e478 from main branch

./myq_status -u root -S /run/mysql.sock wsrep
  view wsrep not found
  myq-tools  ()

Thanks in advance,
David

18m59s
19m0s

Still plagued with 'Buffer too large'. Want to explore using the mysql cli instead in --batch mode, which should mean much smaller buffers and much more efficient parsing

panic: runtime error: slice bounds out of range goroutine 7 [running]: github.com/jayjanssen/myq-tools/myqlib.scanMySQLShowLines(0xc208064080, 0xc20800b320) /home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/parse_show.go:52 +0x746 github.com/jayjanssen/myq-tools/myqlib.func·004() /home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:211 +0x8d created by github.com/jayjanssen/myq-tools/myqlib.FileLoader.harvestFile /home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:212 +0x35a goroutine 1 [chan receive]: main.main() /home/travis/gopath/src/github.com/jayjanssen/myq-tools/myq_status.go:146 +0x13db goroutine 5 [syscall]: os/signal.loop() /home/travis/.gimme/versions/go1.4.linux.amd64/src/os/signal/signal_unix.go:21 +0x1f created by os/signal.init·1 /home/travis/.gimme/versions/go1.4.linux.amd64/src/os/signal/signal_unix.go:27 +0x35 goroutine 8 [runnable]: github.com/jayjanssen/myq-tools/myqlib.func·003() /home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:130 +0xda created by github.com/jayjanssen/myq-tools/myqlib.GetState /home/travis/gopath/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:177 +0x3aa

wsrep apply %ef wasn't updating when I changed wsrep_slave_threads

verify this check is made

I've YUM installed GO on Centos 7.2 and tried to deploy myq-tools both by downloading and extracting from ZIP, and by GIT clone. Same results :

myq_status.go:7:2: cannot find package "github.com/jayjanssen/myq-tools/myqlib" in any of:
/usr/lib/golang/src/github.com/jayjanssen/myq-tools/myqlib (from $GOROOT)
/home/golang/src/github.com/jayjanssen/myq-tools/myqlib (from $GOPATH)

The only way I've been able to get this to work is to create the whole expected path by adding in /src/github.com/jayjannsen and moving myq-tools into that location. I then have to CD into that new location to run the tool.

Platform is Centos 7.2.

Steps taken

sudo yum install git
cd /home/golang/
git clone https://github.com/jayjanssen/myq-tools.git
go run myq_status.go
cd myq-tools/
go run myq_status.go

Returns error as above.

Here is my GO env from the server I used

GOARCH="amd64"
GOBIN="/usr/lib/golang/bin"
GOCHAR="6"
GOEXE=""
GOHOSTARCH="amd64"
GOHOSTOS="linux"
GOOS="linux"
GOPATH="/home/golang"
GORACE=""
GOROOT="/usr/lib/golang"
GOTOOLDIR="/usr/lib/golang/pkg/tool/linux_amd64"
CC="gcc"
GOGCCFLAGS="-fPIC -m64 -pthread -fmessage-length=0"
CXX="g++"
CGO_ENABLED="1"

To work around the issue :

mkdir /home/golang/src
mkdir /home/golang/src/github.com
mkdir /home/golang/src/github.com/jayjanssen
mv /home/golang/myq-tools /home/golang/src/github.com/jayjanssen/

Then to run:
cd /home/golang/src/github.com/jayjanssen/myq-tools/
go run myq_status.go
go run myq_status.go wsrep

This all feels a little clunky. Is this expected behavior? Did I do something wrong?

:/code/myq-tools$ git clone https://github.com/jayjanssen/myq-tools.git
Cloning into 'myq-tools'...
remote: Counting objects: 855, done.
remote: Total 855 (delta 0), reused 0 (delta 0), pack-reused 855
Receiving objects: 100% (855/855), 7.84 MiB | 6.36 MiB/s, done.
Resolving deltas: 100% (566/566), done.
Checking connectivity... done.
:/code/myq-tools$ go run myq_status.go
myq_status.go:7:2: cannot find package "github.com/jayjanssen/myq-tools/myqlib" in any of:
/usr/lib/go/src/pkg/github.com/jayjanssen/myq-tools/myqlib (from $GOROOT)
($GOPATH not set)
:/code/myq-tools$ sed -i 's:github.com/jayjanssen/myq-tools/myqlib:../myq-tools/myqlib:g' myq_status.go
:/code/myq-tools$ GOPATH=/home/user/code/ go run myq_status.go

_/home/user/code/myq-tools/myqlib

myqlib/loader.go:313: syntax error: unexpected range, expecting {
myqlib/loader.go:323: non-declaration statement outside function body
myqlib/loader.go:326: non-declaration statement outside function body
myqlib/loader.go:327: syntax error: unexpected }

was from wsrep view

panic: interface conversion: interface is nil, not string

goroutine 16 [running]:
runtime.panic(0x5166e0, 0xc208040fc0)
/usr/lib/golang/src/pkg/runtime/panic.c:279 +0xf5
_/vagrant/myqlib.func·010(0xc20802a2a0, 0xc20800fb80, 0x7fe4faf687a8, 0xc2080e51d0)
/vagrant/myqlib/view_defaults.go:224 +0xa7
_/vagrant/myqlib.FuncCol.Data(0x53bb50, 0x5, 0x553450, 0x1b, 0x5, 0x5746e0, 0xc20802a2a0, 0xc20800fb80)
/vagrant/myqlib/col.go:229 +0x96
_/vagrant/myqlib.(_FuncCol).Data(0xc2080244e0, 0xc20802a2a0, 0xc20800fb80)
:47 +0xa5
_/vagrant/myqlib.NormalView.Data(0xc20804e000, 0x9, 0x9, 0x5494d0, 0x17, 0x5746d8, 0xc20802a2a0, 0xc20800fb80)
/vagrant/myqlib/view.go:78 +0xec
_/vagrant/myqlib.(_NormalView).Data(0xc2080246c0, 0xc20802a2a0, 0xc20800fb80)
:115 +0xa5
main.main()
/vagrant/myq_status.go:152 +0x1207

go run myq_status.go -a "-u test" wsrep

panic: Could not write to MySQL command any longer

goroutine 1 [running]:
github.com/jayjanssen/myq-tools/myqlib.func·005()
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:287 +0xce
github.com/jayjanssen/myq-tools/myqlib.LiveLoader.harvestMySQL(0x3b9aca00, 0x7fff2a7c66cd, 0x7, 0x5c3e10, 0x21, 0x7fb2ba590000, 0x0, 0x0)
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:291 +0x660
github.com/jayjanssen/myq-tools/myqlib.LiveLoader.getStatus(0x3b9aca00, 0x7fff2a7c66cd, 0x7, 0x522000, 0x0, 0x0)
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:322 +0x5c
github.com/jayjanssen/myq-tools/myqlib.(*LiveLoader).getStatus(0xc20801e560, 0xc2080340f8, 0x0, 0x0)
:90 +0xb3
github.com/jayjanssen/myq-tools/myqlib.GetState(0x7fb2ba5a2040, 0xc20801e560, 0x6a2d50, 0x0, 0x0)
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:126 +0x232
main.main()
/vagrant/myq_status.go:143 +0x12f6

goroutine 5 [syscall]:
os/signal.loop()
/usr/lib/golang/src/os/signal/signal_unix.go:21 +0x1f
created by os/signal.init·1
/usr/lib/golang/src/os/signal/signal_unix.go:27 +0x35

goroutine 12 [runnable]:
os/exec.func·004(0xc20801ea00)
/usr/lib/golang/src/os/exec/exec.go:327
created by os/exec.(*Cmd).Start
/usr/lib/golang/src/os/exec/exec.go:329 +0xb6d

goroutine 9 [chan receive]:
github.com/jayjanssen/myq-tools/myqlib.func·006()
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:297 +0xb0
created by github.com/jayjanssen/myq-tools/myqlib.LiveLoader.harvestMySQL
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:300 +0x74d

goroutine 11 [runnable]:
os/exec.(*Cmd).Wait(0xc208058140, 0x0, 0x0)
/usr/lib/golang/src/os/exec/exec.go:369 +0x30b
github.com/jayjanssen/myq-tools/myqlib.func·008()
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:311 +0x36
created by github.com/jayjanssen/myq-tools/myqlib.LiveLoader.harvestMySQL
/go/src/github.com/jayjanssen/myq-tools/myqlib/loader.go:316 +0x8ca
exit status 2

thanks

0.3m -- innodb bp data, would be better as 300k in the same space

probably the precision number