We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica Console 12.0.2 issue - no info from graphs — Vertica Forum

Vertica Console 12.0.2 issue - no info from graphs

raulk89raulk89 Community Edition User ✭
in General Discussion

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 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 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 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 Administrator

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...