Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
The vertica dba tools for session manager is not bring up the session info, sql exception thrown.
|
|
112 KB
|
|
143 KB
Vertica appears to have made system table modifications from version 7.1 to 7.2. The session extraction queries use the v_monitor.sessions table. The column JVM_MEMORY_KB has been renamed to EXTERNAL_MEMORY_KB. The definition of this column is still "Amount of memory consumed by the Java Virtual Machines associated with the session." I have been unable to find any mention of this in there change logs.
I have made the needed changes to the extraction queries. Sessions manager will now show sessions correctly again.
Verified in ADS 17.0.4-8.
Connect to Vertica 7.2.2
Go to DBA Tools menu & select Vertica->Session Manager option.
Session Manager opens & session manager details are displayed.
Refer attached screenshot(14435_v17.png)
Verified in ADS 17.0.4-8.
Connect to Vertica 7.2.2
Go to DBA Tools menu & select Vertica->Session Manager option.
Session Manager opens & session manager details are displayed.
Refer attached screenshot(14435_v17.png)
Issue #14435 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v17.0.4-8 |
| No time estimate |
Vertica appears to have made system table modifications from version 7.1 to 7.2. The session extraction queries use the v_monitor.sessions table. The column JVM_MEMORY_KB has been renamed to EXTERNAL_MEMORY_KB. The definition of this column is still "Amount of memory consumed by the Java Virtual Machines associated with the session." I have been unable to find any mention of this in there change logs.
I have made the needed changes to the extraction queries. Sessions manager will now show sessions correctly again.