Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Management console 10.1 - Unknown configuration parameter

Hi

Vertica database 11.0.0
Vertica Management Console, 10.1.0

I recently upgrade vertica database from 10.1 to 11.0
After that I have noticed some errors in vertica.log file every day 11 pm and midnight (00) (UTC+3)

Looks like management console still uses vertica 10 syntax. EnableSSL parameter is removed from vertica 11, and it gets an error.

Here you can see that client connected with label MC and the statement.

Also, I am curious is there some scheduler somewhere in MC, looks like something starts every day 11pm and 00. Anyone can tell me what job is this and where can I see it..?

2021-08-27 23:00:00.017 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) set role all
2021-08-27 23:00:00.017 Init Session:0x7f2e8bfff700 [Session] [Query] TX:0(v_mydb_node0001-246244:0x26) set role all
2021-08-27 23:00:00.018 Init Session:0x7f2e8bfff700-a0000000237340 [Txn] Begin Txn: a0000000237340 'read role info'
2021-08-27 23:00:00.018 Init Session:0x7f2e8bfff700-a0000000237340 [Txn] Rollback Txn: a0000000237340 'read role info'
2021-08-27 23:00:00.018 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) set timezone to 'GMT'
2021-08-27 23:00:00.018 Init Session:0x7f2e8bfff700 [Session] [Query] TX:0(v_mydb_node0001-246244:0x26) set timezone to 'GMT'
2021-08-27 23:00:00.019 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) set role all
2021-08-27 23:00:00.019 Init Session:0x7f2e8bfff700 [Session] [Query] TX:0(v_mydb_node0001-246244:0x26) set role all
2021-08-27 23:00:00.019 Init Session:0x7f2e8bfff700-a0000000237341 [Txn] Begin Txn: a0000000237341 'read role info'
2021-08-27 23:00:00.019 Init Session:0x7f2e8bfff700-a0000000237341 [Txn] Rollback Txn: a0000000237341 'read role info'
2021-08-27 23:00:00.019 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) set timezone to 'GMT'
2021-08-27 23:00:00.019 Init Session:0x7f2e8bfff700 [Session] [Query] TX:0(v_mydb_node0001-246244:0x26) set timezone to 'GMT'
2021-08-27 23:00:00.032 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/2705: Connection received: host=10.51.2.82 port=44272 (connCnt 13)
2021-08-27 23:00:00.032 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/4540: Received SSL negotiation startup packet
2021-08-27 23:00:00.032 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/4691: Sending SSL negotiation response 'S'
2021-08-27 23:00:00.042 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/9348: TLS connection from "(anonymous)"
2021-08-27 23:00:00.042 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/4778: SSL initialization success
2021-08-27 23:00:00.044 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/4686: Authentication - sendAuthRequest: user=my_etl database=mydb host=10.51.2.82 authType=66048
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700-a0000000237342 [Txn] Begin Txn: a0000000237342 'check_login_history'
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700-a0000000237342 [Txn] Rollback Txn: a0000000237342 'check_login_history'
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/4686: Authentication - sendAuthRequest: user=my_etl database=mydb host=10.51.2.82 authType=0
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/2703: Connection authenticated: user=my_etl database=mydb host=10.51.2.82
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/2609: Client pid: 1311
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/2608: Client label: MC
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/7400: Current idle session timeout = UNLIMITED
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 @v_mydb_node0001: 00000/8081: Current session grace period: UNLIMITED
2021-08-27 23:00:00.045 Init Session:0x7f2ad7ffe700 [Session] [Query] TX:0(v_mydb_node0001-246244:0xc4c0) set session autocommit to on
2021-08-27 23:00:00.046 Init Session:0x7f2ad7ffe700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0xc4c0) set role all
2021-08-27 23:00:00.046 Init Session:0x7f2ad7ffe700 [Session] [Query] TX:0(v_mydb_node0001-246244:0xc4c0) set role all
2021-08-27 23:00:00.046 Init Session:0x7f2ad7ffe700-a0000000237343 [Txn] Begin Txn: a0000000237343 'read role info'
2021-08-27 23:00:00.046 Init Session:0x7f2ad7ffe700-a0000000237343 [Txn] Rollback Txn: a0000000237343 'read role info'
2021-08-27 23:00:00.047 Init Session:0x7f2ad7ffe700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0xc4c0) set timezone to 'GMT'
2021-08-27 23:00:00.047 Init Session:0x7f2ad7ffe700 [Session] [Query] TX:0(v_mydb_node0001-246244:0xc4c0) set timezone to 'GMT'
2021-08-27 23:00:00.047 Init Session:0x7f2ad7ffe700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0xc4c0) set role all
.....
2021-08-27 23:00:00.066 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) set role all
2021-08-27 23:00:00.066 Init Session:0x7f2e8bfff700 [Session] [Query] TX:0(v_mydb_node0001-246244:0x26) set role all
2021-08-27 23:00:00.066 Init Session:0x7f2e8bfff700-a0000000237346 [Txn] Begin Txn: a0000000237346 'read role info'
2021-08-27 23:00:00.066 Init Session:0x7f2e8bfff700-a0000000237346 [Txn] Rollback Txn: a0000000237346 'read role info'
2021-08-27 23:00:00.067 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) set timezone to 'GMT'
2021-08-27 23:00:00.067 Init Session:0x7f2e8bfff700 [Session] [Query] TX:0(v_mydb_node0001-246244:0x26) set timezone to 'GMT'
2021-08-27 23:00:00.067 Init Session:0x7f2e8bfff700 [Session] [PQuery] TX:0(v_mydb_node0001-246244:0x26) select get_config_parameter('EnableSSL');
2021-08-27 23:00:00.067 Init Session:0x7f2e8bfff700 [Session] [BQuery] TX:0(v_mydb_node0001-246244:0x26) select get_config_parameter('EnableSSL');
2021-08-27 23:00:00.068 Init Session:0x7f2e8bfff700 @v_mydb_node0001: 00000/3316: Executing statement: ' select get_config_parameter('EnableSSL');'
2021-08-27 23:00:00.081 Init Session:0x7f2e8bfff700 @v_mydb_node0001: 42V02/5202: Unknown configuration parameter
LOCATION: get_config_parameter, /data/jenkins/workspace/RE-ReleaseBuilds/RE-Jackhammer_3/server/vertica/Commands/PGCall.cpp:12791

Regards
Raul

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.