Vertica Console 12.0.2 issue - no info from graphs

raulk89raulk89 Community Edition User

Hi

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

Comments

  • raulk89raulk89 Community Edition User

    Before I was at 11.1.1
    Everything worked fine.

    Raul

  • SruthiASruthiA Vertica Employee Administrator
    edited December 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

  • raulk89raulk89 Community Edition User
    Strange.
    Are you using ssl connection to vertica database?
    Mine is encrypted, both, data and connections.

    Raul
  • raulk89raulk89 Community Edition User

  • raulk89raulk89 Community Edition User
    edited January 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

  • SruthiASruthiA Vertica Employee Administrator

    @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: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

  • raulk89raulk89 Community Edition User

    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

  • SruthiASruthiA Vertica Employee Administrator

    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

  • raulk89raulk89 Community Edition User

    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)

  • raulk89raulk89 Community Edition User

    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

  • SruthiASruthiA Vertica Employee Administrator

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file