Collector 27.005 breaks MySQL v5 monitoring

Locked

Discussion interactions are currently paused.

Today we were upgraded to collector version 27.005 and our MySQL monitoring is now broken. I tried to downgrade to 27.000 but the downgrade does not appear to be actioned, even though I can choose the option in Settings > Collectors. Can we please have our MySQL 5 monitoring back, or can you suggest what we need to do. Thanks.


Unknown system variable 'system_time_zone'
Query is : SELECT @@max_allowed_packet , @@system_time_zone, @@time_zone, @@sql_mode

@Ali Holmes

@Sarah Terry

Mosh

Posted 7 years ago·Last reply 7 years ago

3 comments

Mosh

OP7 years ago

Thanks @Michael Rodrigues

Mike Moniz

·7 years ago

Just to throw it out there, the error kinda looks like a known bug in MySQL pre 5.0.24. Although I wouldn't expect a collector upgrade to trigger it. I don't monitor MySQL to test myself.

https://bugs.mysql.com/bug.php?id=15455

Michael Rodrigues

·7 years ago

Hey @Mosh, sorry you had to deal with this. I didn't see a support ticket from you, but you should hear from them or your CSM shortly.

We're looking at this on our end, I'll update this ticket when I know more.

1	SUYASH GAIKWAD
2	PJ Pankaj Jain
3	KT Kyle Taylor
4	KV karthikeyan VG
5	ME Mir Ehtesham Ali
6	SN Sangeetha Nataraj