Forum Replies Created
-
AuthorPosts
-
mitchnMember
It has been installed and Processlist works again for those servers. Thank you for your assistance!
Regards,
Mitch
mitchnMember'sandhya.r' wrote:Issue Confirmed.
The problem was with “Id” column. It is fixed now.
We will provide you a special build to verify this bug fix. Please tell which MONyog build you are using(Windows/Linux32/LInux64)?
The version installed is the latest windows stable version: Stable 4.1.2-0.
Thanks,
Mitch
mitchnMember'sandhya.r' wrote:Can you please
1) Attach the output of the query “SHOW FULL PROCESSLIST”.
2) Make a duplicate connection of the problematic server and try whether it is reproducible with that server or not.
1) Attached.
2) Creation of a new connection for the same server does not address the issue. I have 2 replica servers, and the issue remains for both these two servers. The other servers that are monitored don't have this issue.
mitchnMember'Mahesh' wrote:We have tried migration from v3.75 to v4.12 but could not able to reproduce this scenario.
Can you please tell us certain information mentioned below:
1) Attach a MONyog.log file
2) Attach a screenshot showing processlist page of problematic server?
Also what does other MySQL client returns on execution of:
SHOW FULL PROCESSLIST;
Also please paste the result of this query here itself.
3) MySQL server version?
1) Attached.
2) Also attached. 'SHOW FULL PROCESSLIST' works fine within SQLyog and all other MySQL clients.
3) MySQL Version is 5.0.51a_Community. Any Monyog version below 4.0 works fine.
To answer the other 3 questions:
1) The user privilege (in this case it is the Root user) is fine, as it can query 'SHOW FULL PROCESSLIST' without issue in query browsers.
2) It's root user, with no modifications made so it is the super_user.
3) Server has been active in production since a clean install back in February 2008, so it's been running a while (no upgrade has been performed as yet).
-
AuthorPosts