Vertica Console 12.0.2 issue - no info from graphs

Forum|Forum|3 years ago
December 30, 2022
11 replies
5 views

raulk89
Participating Frequently

I just upgraded vertia console to 12.0.2
The web UI shows databases are up and running.
But I do not see any data from overview page graphics.

There is this message:
Unable to retrieve chart data
Database .... is down!

Log file is full of this.

/opt/vconsole/log/mc/mconsole.log

...
30 Dec 2022 09:27:30,300 [qtp1262822392-113] DatabaseConnectionPoolService INFO - Trying to get JDBC connection to host - x.x.x.x
30 Dec 2022 09:27:30,309 [qtp1262822392-113] DatabaseConnectionPoolService ERROR - Error while creating connection. Input byte array has incorrect ending byte at 24

...

Raul

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
December 30, 2022

Before I was at 11.1.1
Everything worked fine.

Raul

SruthiA
Participating Frequently
Forum|Forum|3 years ago
December 30, 2022

@raulk89 I just tried to reproduce the issue locally and it works fine.. I used MC 12.0.2 and imported database version is also 12.0.2.

30 Dec 2022 14:56:57,867 [Thread-31] DatabaseConnectionPoolService INFO - Trying to get JDBC connection to host - x.x.x.81
30 Dec 2022 14:56:57,870 [Thread-31] PropertiesConfiguration INFO - Reloading configuration. URL is file:/opt/vconsole/config/console.properties
30 Dec 2022 14:56:58,254 [Thread-31] DatabaseConnectionPoolService INFO - ==================================================
30 Dec 2022 14:56:58,277 [Thread-31] DatabaseConnectionPoolService INFO - jdbc driver version for eonv1202u: 12.00.0200
30 Dec 2022 14:56:58,277 [Thread-31] DatabaseConnectionPoolService INFO - ==================================================

30 Dec 2022 14:57:53,353 [qtp1262822392-24] VuiUtils INFO - executeCommand>> command: rpm -q vertica-console --queryformat=%{VERSION}-%{RELEASE}
30 Dec 2022 14:57:53,391 [qtp1262822392-123] SystemInfoServiceImpl INFO - getBuildInfo>> commandOutput: 12.0.2-0

30 Dec 2022 14:57:53,415 [qtp1262822392-24] SystemInfoServiceImpl INFO - getBuildInfo>> commandOutput: 12.0.2-0

30 Dec 2022 14:58:08,117 [qtp1262822392-35] PropertiesConfiguration INFO - Reloading configuration. URL is file:/opt/vconsole/config/console.properties
30 Dec 2022 14:58:09,852 [generalScheduler_Worker-9] VerticaAgentPingingJob INFO - Starting task: VerticaAgentPingingJob
30 Dec 2022 14:58:09,899 [generalScheduler_Worker-9] AgentCommands INFO - agentapi=GET, https://x.x.x.81:5444/
30 Dec 2022 14:58:10,394 [generalScheduler_Worker-9] PropertiesConfiguration INFO - Reloading configuration. URL is file:/opt/vconsole/config/console.properties
30 Dec 2022 14:58:10,440 [generalScheduler_Worker-9] AgentCommands INFO - agentapi=GET, https://x.x.x.82:5444/
30 Dec 2022 14:58:10,659 [qtp1262822392-30] I18NController INFO - /resources/i18n/lang - Full path =/opt/vconsole/temp/webapp/resources/i18n/lang
30 Dec 2022 14:58:10,668 [MCThread-1672430197890] SystemInfoServiceImpl INFO - Is this a Debian system? false
30 Dec 2022 14:58:10,668 [MCThread-1672430197890] VuiUtils INFO - executeCommand>> command: rpm -q vertica-console --queryformat=%{VERSION}-%{RELEASE}
30 Dec 2022 14:58:10,761 [MCThread-1672430197890] SystemInfoServiceImpl INFO - getBuildInfo>> commandOutput: 12.0.2-0

30 Dec 2022 14:58:10,867 [generalScheduler_Worker-9] AgentCommands INFO - agentapi=GET, https://x.x.x.83:5444/
30 Dec 2022 14:58:10,951 [qtp1262822392-89] ChartGetterService INFO - Retrieving overview-summary-cpumemusage.xml
30 Dec 2022 14:58:10,981 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-nodestate.xml
30 Dec 2022 14:58:10,981 [qtp1262822392-89] ChartFactory INFO - Creating chart overview-summary-cpumemusage
30 Dec 2022 14:58:10,983 [qtp1262822392-89] ChartGetterService INFO - Retrieving overview-summary-resourcepools.xml
30 Dec 2022 14:58:10,985 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-nodestate
30 Dec 2022 14:58:10,986 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-query-processing.xml
30 Dec 2022 14:58:10,987 [qtp1262822392-89] ChartFactory INFO - Creating chart overview-summary-resourcepools
30 Dec 2022 14:58:10,989 [qtp1262822392-89] ChartGetterService INFO - Retrieving overview-summary-threshold-notifications.xml
30 Dec 2022 14:58:10,991 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-query-processing
30 Dec 2022 14:58:10,992 [qtp1262822392-89] ChartFactory INFO - Creating chart overview-summary-threshold-notifications
30 Dec 2022 14:58:10,992 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-projections.xml
30 Dec 2022 14:58:10,994 [qtp1262822392-89] ChartGetterService INFO - Retrieving overview-summary-queryactivity.xml
30 Dec 2022 14:58:10,997 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-projections
30 Dec 2022 14:58:10,998 [qtp1262822392-89] ChartFactory INFO - Creating chart overview-summary-queryactivity
30 Dec 2022 14:58:10,998 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-low-disk-space.xml
30 Dec 2022 14:58:11,002 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-low-disk-space
30 Dec 2022 14:58:11,003 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-wla.xml
30 Dec 2022 14:58:11,008 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-wla
30 Dec 2022 14:58:11,009 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-io-wait.xml
30 Dec 2022 14:58:11,012 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-io-wait
30 Dec 2022 14:58:11,014 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-licenses.xml
30 Dec 2022 14:58:11,017 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-licenses
30 Dec 2022 14:58:11,018 [qtp1262822392-33] ChartGetterService INFO - Retrieving quick-stat-messages.xml
30 Dec 2022 14:58:11,022 [qtp1262822392-33] ChartFactory INFO - Creating chart quick-stat-messages

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
January 1, 2023

Strange.
Are you using ssl connection to vertica database?
Mine is encrypted, both, data and connections.

Raul

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
January 2, 2023

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
January 2, 2023

Well, it is broken for me.
Also tried previous version again, 11.1.1 works perfectly fine.
This is not due to database version. I have different database versions installed 11.1.1 and 12.0.2
With previous MC - everything worked.
With current MC version - nothing works.

Did you try only 12.0.2 or you did upgrade to that version from previous version..?
Bear in mind we do not install new version on scratch each time - we upgrade previous version to a new version.

Also, try SSL etc..

Raul

SruthiA
Participating Frequently
Forum|Forum|3 years ago
January 3, 2023

@raulk89 Yes. it was 11.1.1-4 and then I upgraded to 12.0.2. I am using non TLS. Is TLS enabled for database or MC or both?

30 Dec 2022 14:52:28,451 [qtp661672156-37] VuiUtils INFO - executeCommand>> command: rpm -q vertica-console --queryformat=%{VERSION}-%{RELEASE}
30 Dec 2022 14:52:28,470 [qtp661672156-31] SystemInfoServiceImpl INFO - getBuildInfo>> commandOutput: 11.1.1-4

30 Dec 2022 14:52:28,503 [qtp661672156-37] SystemInfoServiceImpl INFO - getBuildInfo>> commandOutput: 11.1.1-4

30 Dec 2022 14:52:40,212 [qtp661672156-27] PropertiesConfiguration INFO - Reloading configuration. URL is file:/opt/vconsole/config/console.properties

30 Dec 2022 14:57:53,415 [qtp1262822392-24] SystemInfoServiceImpl INFO - getBuildInfo>> commandOutput: 12.0.2-0

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
January 3, 2023

Hmm.
For database - Yes.

But for MC, what do you mean by that ?
I mean, if database is with SSL, then MC also must connect via SSL, otherwise it would not work.

Raul

SruthiA
Participating Frequently
Forum|Forum|3 years ago
January 3, 2023

Thank you for confirming. For database is TLS enabled in server mode or mutual mode? Could you please open a support case and share logs etc ? it may require WebEx to review this issue

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
January 3, 2023

Server mode.

dbadmin=> SELECT SECURITY_CONFIG_CHECK('NETWORK');

Spread security details:

EncryptSpreadComm = [vertica]
Spread encryption is enabled
It is now safe to set/change other security knobs

Data Channel security details:
TLS Configuration 'data_channel' TLSMODE is VERIFY_CA
TLS on the data channel is enabled

Client-Server network security details:

TLS Configuration 'server' TLSMODE is ENABLE
TLS Configuration 'server' has a certificate set
Client-Server TLS is enabled

(1 row)

raulk89
Author
Participating Frequently
Forum|Forum|3 years ago
January 23, 2023

I managed to get MC verion 12.0.3 (vertica-console-12.0.3-0.x86_64.RHEL6.rpm)
It is fixed in that version.

Regards
Raul Kaubi

SruthiA
Participating Frequently
Forum|Forum|3 years ago
January 30, 2023

@hercules : Please open a support case and share the logs.

Sign up

Please log in or register:

Welcome to the Rocket Forum!

Please log in or register: