search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.34k stars 2.98k forks source link

Problem with gsheet connector #21325

Closed sotiriskar closed 6 months ago

sotiriskar commented 6 months ago

Hello, I already have set up locally and use trino for Postgres databases through a docker container. I wanted to add a connector for some of my Google Sheets. So the steps I took to the existing trino container were: 1) Added to the catalog the new connector. For testing purposes, I used documentation example sheet-id:

connector.name=gsheets
gsheets.credentials-path=/app/credentials/credentials.json
gsheets.metadata-sheet-id=1Es4HhWALUQjoa-bQh4a8B5HROz7dpGMfq_HbfoaW5LM

2) Then I created credentials.json as documented with a service account that has owner permissions.

3) Created the Image & Container, added credentials folder and it seems to run fine. Trino found the credentials files and got logs that the server started normally.

Problem I used this methodology:

SELECT *
FROM
  TABLE(example.system.sheet(
      id => 'googleSheetIdHere'));

and I get: Query 20240329_153656_00000_iyz2t failed: Error listing tables for catalog gsheets: Failed reading data from sheet: '1Es4HhWALUQjoa-bQh4a8B5HROz7dpGMfq_HbfoaW5LM'

I also tried other sheet-ids and this: show tables from gsheets.default;

still the same error. I Tried using other files and creating table-sheet-mapping shared with my google service account email, but again same error. Any ideas?

nineinchnick commented 6 months ago

Can you include the full stack trace? You can find it in the server logs or when running the query from the Trino CLI with --debug.

sotiriskar commented 6 months ago

Here's the logs:

2024-03-29 18:43:39 + launcher_opts=(--etc-dir /etc/trino)
2024-03-29 18:43:39 + grep -s -q node.id /etc/trino/node.properties
2024-03-29 18:43:40 + exec /usr/lib/trino/bin/launcher run --etc-dir /etc/trino
2024-03-29 18:43:48 Mar 29, 2024 4:43:48 PM io.airlift.log.Logger info
2024-03-29 18:43:48 INFO: Java version: 21.0.2
2024-03-29 18:43:48 2024-03-29T16:43:48.095ZINFOmainio.airlift.log.LoggingLogging to stderr
2024-03-29 18:43:48 2024-03-29T16:43:48.096ZINFOmainBootstrapLoading configuration
2024-03-29 18:43:48 2024-03-29T16:43:48.176ZINFOmainorg.hibernate.validator.internal.util.VersionHV000001: Hibernate Validator 8.0.1.Final
2024-03-29 18:43:48 2024-03-29T16:43:48.339ZINFOmainBootstrapInitializing logging
2024-03-29 18:43:50 2024-03-29T16:43:50.398ZINFOmainBootstrapPROPERTY                                                                                DEFAULT                                                                    RUNTIME                                                                    DESCRIPTION
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdiscovery.uri                                                                           ----                                                                       http://localhost:8080                                                      Discovery service base URI
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapservice-inventory.uri                                                                   ----                                                                       ----                                                                       Service inventory base URI
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapservice-inventory.update-interval                                                       10.00s                                                                     10.00s                                                                     Service inventory update interval
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdiscovery.trino.pool                                                                    general                                                                    general
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdiscovery.max-age                                                                       30.00s                                                                     30.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdiscovery.store-cache-ttl                                                               1.00s                                                                      1.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdynamic.store.gc-interval                                                               1.00h                                                                      1.00h
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdynamic.store.remote.max-batch-size                                                     1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdynamic.store.remote.queue-size                                                         1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdynamic.store.remote.update-interval                                                    5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdynamic.store.remote.replication-interval                                               1.00m                                                                      1.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.399ZINFOmainBootstrapdynamic.store.tombstone-max-age                                                         1.00d                                                                      1.00d
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.https.automatic-shared-secret                                     [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.use-blocking-connect                                              false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.connect-timeout                                                   5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.http2.enabled                                                     false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.http2.session-receive-window-size                                 16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.http2.stream-receive-window-size                                  16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.http2.input-buffer-size                                           8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.http-proxy                                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.https.excluded-cipher                                             [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.https.included-cipher                                             []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.idle-timeout                                                      1.00m                                                                      1.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.keep-alive-interval                                               ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.key-store-password                                                [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.400ZINFOmainBootstrapdiscovery.http-client.key-store-path                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.401ZINFOmainBootstrapdiscovery.http-client.log.buffer-size                                                   1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.401ZINFOmainBootstrapdiscovery.http-client.log.compression.enabled                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.401ZINFOmainBootstrapdiscovery.http-client.log.enabled                                                       false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.401ZINFOmainBootstrapdiscovery.http-client.log.flush-interval                                                10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.log.max-history                                                   15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.log.max-size                                                      1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.log.path                                                          var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.log.queue-size                                                    10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.max-connections-per-server                                        20                                                                         20
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.max-content-length                                                16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.max-requests-queued-per-destination                               1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.max-threads                                                       200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.402ZINFOmainBootstrapdiscovery.http-client.min-threads                                                       8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.record-request-complete                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.request-buffer-size                                               4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.request-timeout                                                   5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.response-buffer-size                                              16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.http-proxy.secure                                                 false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.secure-random-algorithm                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.selector-count                                                    2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.socks-proxy                                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.tcp-keep-alive-idle-time                                          ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.timeout-concurrency                                               1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.timeout-threads                                                   1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.trust-store-password                                              [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.403ZINFOmainBootstrapdiscovery.http-client.trust-store-path                                                  ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdiscovery.http-client.https.hostname-verification                                       true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.https.automatic-shared-secret                                       [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.use-blocking-connect                                                false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.connect-timeout                                                     5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.http2.enabled                                                       false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.http2.session-receive-window-size                                   16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.http2.stream-receive-window-size                                    16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.404ZINFOmainBootstrapdynamic.http-client.http2.input-buffer-size                                             8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.http-proxy                                                          ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.https.excluded-cipher                                               [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.https.included-cipher                                               []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.idle-timeout                                                        1.00m                                                                      1.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.keep-alive-interval                                                 ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.key-store-password                                                  [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.key-store-path                                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.log.buffer-size                                                     1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.log.compression.enabled                                             true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.405ZINFOmainBootstrapdynamic.http-client.log.enabled                                                         false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.log.flush-interval                                                  10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.log.max-history                                                     15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.log.max-size                                                        1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.log.path                                                            var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.log.queue-size                                                      10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.max-connections-per-server                                          20                                                                         20
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.max-content-length                                                  16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.max-requests-queued-per-destination                                 1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.max-threads                                                         200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.min-threads                                                         8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.record-request-complete                                             true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.request-buffer-size                                                 4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.request-timeout                                                     5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.response-buffer-size                                                16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.http-proxy.secure                                                   false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.secure-random-algorithm                                             ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.selector-count                                                      2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.socks-proxy                                                         ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.tcp-keep-alive-idle-time                                            ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.timeout-concurrency                                                 1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.timeout-threads                                                     1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.trust-store-password                                                [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.406ZINFOmainBootstrapdynamic.http-client.trust-store-path                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapdynamic.http-client.https.hostname-verification                                         true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.https.automatic-shared-secret                              [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.use-blocking-connect                                       false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.connect-timeout                                            5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.http2.enabled                                              false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.http2.session-receive-window-size                          16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.http2.stream-receive-window-size                           16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.http2.input-buffer-size                                    8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.http-proxy                                                 ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.https.excluded-cipher                                      [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.https.included-cipher                                      []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.idle-timeout                                               1.00m                                                                      1.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.keep-alive-interval                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.key-store-password                                         [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.key-store-path                                             ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.buffer-size                                            1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.compression.enabled                                    true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.enabled                                                false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.flush-interval                                         10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.max-history                                            15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.max-size                                               1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.path                                                   var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.log.queue-size                                             10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.max-connections-per-server                                 20                                                                         20
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.max-content-length                                         16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.max-requests-queued-per-destination                        1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.max-threads                                                200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.min-threads                                                8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.407ZINFOmainBootstrapfailure-detector.http-client.record-request-complete                                    true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.408ZINFOmainBootstrapfailure-detector.http-client.request-buffer-size                                        4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.request-timeout                                            5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.response-buffer-size                                       16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.http-proxy.secure                                          false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.secure-random-algorithm                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.selector-count                                             2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.socks-proxy                                                ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.410ZINFOmainBootstrapfailure-detector.http-client.tcp-keep-alive-idle-time                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapfailure-detector.http-client.timeout-concurrency                                        1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapfailure-detector.http-client.timeout-threads                                            1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapfailure-detector.http-client.trust-store-password                                       [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapfailure-detector.http-client.trust-store-path                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapfailure-detector.http-client.https.hostname-verification                                true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.https.automatic-shared-secret                                 [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.use-blocking-connect                                          false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.connect-timeout                                               5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.http2.enabled                                                 false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.http2.session-receive-window-size                             16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.http2.stream-receive-window-size                              16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.http2.input-buffer-size                                       8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.http-proxy                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.https.excluded-cipher                                         [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.https.included-cipher                                         []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.idle-timeout                                                  30.00s                                                                     30.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.keep-alive-interval                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.key-store-password                                            [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.411ZINFOmainBootstrapmemoryManager.http-client.key-store-path                                                ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.buffer-size                                               1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.compression.enabled                                       true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.enabled                                                   false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.flush-interval                                            10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.max-history                                               15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.max-size                                                  1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.path                                                      var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.log.queue-size                                                10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.max-connections-per-server                                    20                                                                         20
2024-03-29 18:43:50 2024-03-29T16:43:50.412ZINFOmainBootstrapmemoryManager.http-client.max-content-length                                            16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.max-requests-queued-per-destination                           1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.max-threads                                                   200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.min-threads                                                   8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.record-request-complete                                       true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.request-buffer-size                                           4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.request-timeout                                               10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.response-buffer-size                                          16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.http-proxy.secure                                             false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.secure-random-algorithm                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.selector-count                                                2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.413ZINFOmainBootstrapmemoryManager.http-client.socks-proxy                                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.414ZINFOmainBootstrapmemoryManager.http-client.tcp-keep-alive-idle-time                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapmemoryManager.http-client.timeout-concurrency                                           1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapmemoryManager.http-client.timeout-threads                                               1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapmemoryManager.http-client.trust-store-password                                          [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapmemoryManager.http-client.trust-store-path                                              ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapmemoryManager.http-client.https.hostname-verification                                   true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapnode-manager.http-client.https.automatic-shared-secret                                  [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapnode-manager.http-client.use-blocking-connect                                           false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapnode-manager.http-client.connect-timeout                                                5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapnode-manager.http-client.http2.enabled                                                  false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.415ZINFOmainBootstrapnode-manager.http-client.http2.session-receive-window-size                              16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.http2.stream-receive-window-size                               16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.http2.input-buffer-size                                        8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.http-proxy                                                     ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.https.excluded-cipher                                          [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.https.included-cipher                                          []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.idle-timeout                                                   30.00s                                                                     30.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.keep-alive-interval                                            ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.key-store-password                                             [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.416ZINFOmainBootstrapnode-manager.http-client.key-store-path                                                 ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.417ZINFOmainBootstrapnode-manager.http-client.log.buffer-size                                                1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.417ZINFOmainBootstrapnode-manager.http-client.log.compression.enabled                                        true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.log.enabled                                                    false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.log.flush-interval                                             10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.log.max-history                                                15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.log.max-size                                                   1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.log.path                                                       var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.log.queue-size                                                 10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.max-connections-per-server                                     20                                                                         20
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.max-content-length                                             16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.max-requests-queued-per-destination                            1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.max-threads                                                    200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.min-threads                                                    8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.record-request-complete                                        true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.request-buffer-size                                            4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.request-timeout                                                10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.response-buffer-size                                           16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.418ZINFOmainBootstrapnode-manager.http-client.http-proxy.secure                                              false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.secure-random-algorithm                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.selector-count                                                 2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.socks-proxy                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.tcp-keep-alive-idle-time                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.timeout-concurrency                                            1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.timeout-threads                                                1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.trust-store-password                                           [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.trust-store-path                                               ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapnode-manager.http-client.https.hostname-verification                                    true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.https.automatic-shared-secret                                      [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.use-blocking-connect                                               false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.connect-timeout                                                    5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.http2.enabled                                                      false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.http2.session-receive-window-size                                  16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.http2.stream-receive-window-size                                   16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.http2.input-buffer-size                                            8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.http-proxy                                                         ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.https.excluded-cipher                                              [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.https.included-cipher                                              []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.idle-timeout                                                       30.00s                                                                     30.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.keep-alive-interval                                                ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.419ZINFOmainBootstrapexchange.http-client.key-store-password                                                 [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.key-store-path                                                     ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.buffer-size                                                    1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.compression.enabled                                            true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.enabled                                                        false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.flush-interval                                                 10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.max-history                                                    15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.max-size                                                       1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.path                                                           var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.log.queue-size                                                     10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.max-connections-per-server                                         250                                                                        250
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.max-content-length                                                 32MB                                                                       32MB
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.max-requests-queued-per-destination                                1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.max-threads                                                        200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.min-threads                                                        8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.record-request-complete                                            true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.request-buffer-size                                                4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.request-timeout                                                    10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.420ZINFOmainBootstrapexchange.http-client.response-buffer-size                                               16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.421ZINFOmainBootstrapexchange.http-client.http-proxy.secure                                                  false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.421ZINFOmainBootstrapexchange.http-client.secure-random-algorithm                                            ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.421ZINFOmainBootstrapexchange.http-client.selector-count                                                     2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.422ZINFOmainBootstrapexchange.http-client.socks-proxy                                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.422ZINFOmainBootstrapexchange.http-client.tcp-keep-alive-idle-time                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.422ZINFOmainBootstrapexchange.http-client.timeout-concurrency                                                1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapexchange.http-client.timeout-threads                                                    1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapexchange.http-client.trust-store-password                                               [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapexchange.http-client.trust-store-path                                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapexchange.http-client.https.hostname-verification                                        true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.https.automatic-shared-secret                                     [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.use-blocking-connect                                              false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.connect-timeout                                                   5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.http2.enabled                                                     false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.http2.session-receive-window-size                                 16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.http2.stream-receive-window-size                                  16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.http2.input-buffer-size                                           8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.http-proxy                                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.https.excluded-cipher                                             [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.https.included-cipher                                             []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.idle-timeout                                                      60.00s                                                                     60.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.keep-alive-interval                                               ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.key-store-password                                                [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.key-store-path                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.buffer-size                                                   1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.compression.enabled                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.enabled                                                       false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.flush-interval                                                10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.max-history                                                   15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.max-size                                                      1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.path                                                          var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.log.queue-size                                                    10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.max-connections-per-server                                        250                                                                        250
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.max-content-length                                                16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.max-requests-queued-per-destination                               1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.max-threads                                                       200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.min-threads                                                       8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.record-request-complete                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.request-buffer-size                                               4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.request-timeout                                                   20.00s                                                                     20.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.response-buffer-size                                              16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.http-proxy.secure                                                 false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.secure-random-algorithm                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.selector-count                                                    2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.socks-proxy                                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.tcp-keep-alive-idle-time                                          ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.timeout-concurrency                                               1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.timeout-threads                                                   1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.trust-store-password                                              [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.trust-store-path                                                  ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapscheduler.http-client.https.hostname-verification                                       true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.https.automatic-shared-secret                                    [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.use-blocking-connect                                             false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.connect-timeout                                                  5.00s                                                                      5.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.http2.enabled                                                    false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.http2.session-receive-window-size                                16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.http2.stream-receive-window-size                                 16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.http2.input-buffer-size                                          8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.423ZINFOmainBootstrapworkerInfo.http-client.http-proxy                                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.https.excluded-cipher                                            [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  [^.*_(MD5|SHA|SHA1)$, ^TLS_RSA_.*$, ^SSL_.*$, ^.*_NULL_.*$, ^.*_anon_.*$]  Setting this config property overwrites Jetty's default excluded cipher suites
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.https.included-cipher                                            []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.idle-timeout                                                     1.00m                                                                      1.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.keep-alive-interval                                              ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.key-store-password                                               [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.key-store-path                                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.buffer-size                                                  1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.compression.enabled                                          true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.enabled                                                      false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.flush-interval                                               10.00s                                                                     10.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.max-history                                                  15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.max-size                                                     1GB                                                                        1GB
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.path                                                         var/log/                                                                   var/log/                                                                   The name of the log file will be prefixed with the name of the HTTP client (<client_name>-http-client.log)
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.log.queue-size                                                   10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.max-connections-per-server                                       20                                                                         20
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.max-content-length                                               16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.max-requests-queued-per-destination                              1024                                                                       1024
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.max-threads                                                      200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.min-threads                                                      8                                                                          8
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.record-request-complete                                          true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.request-buffer-size                                              4kB                                                                        4kB
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.request-timeout                                                  5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.response-buffer-size                                             16kB                                                                       16kB
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.http-proxy.secure                                                false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.secure-random-algorithm                                          ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.selector-count                                                   2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.socks-proxy                                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.tcp-keep-alive-idle-time                                         ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.timeout-concurrency                                              1                                                                          1                                                                          Number of concurrent locks for timeout
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.timeout-threads                                                  1                                                                          1                                                                          Total number of timeout threads
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.trust-store-password                                             [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.trust-store-path                                                 ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstrapworkerInfo.http-client.https.hostname-verification                                      true                                                                       true                                                                       Verify that server hostname matches the server certificate
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.admin.enabled                                                               false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.admin.threads.max                                                           200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.admin.threads.min                                                           2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.admin.port                                                                  0                                                                          0
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.http2.session-receive-window-size                                           16MB                                                                       16MB                                                                       Initial size of session's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.http2.stream-receive-window-size                                            16MB                                                                       16MB                                                                       Initial size of stream's flow control receive window for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.424ZINFOmainBootstraphttp-server.http2.input-buffer-size                                                     8kB                                                                        8kB                                                                        Size of the buffer used to read from the network for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.http2.max-concurrent-streams                                                16384                                                                      16384                                                                      Maximum concurrent streams per connection for HTTP/2
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.http2.stream-idle-timeout                                                   15.00s                                                                     15.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.accept-queue-size                                                           8000                                                                       8000
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.http.acceptor-threads                                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.http.enabled                                                                true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.http.port                                                                   8080                                                                       8080
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.http.selector-threads                                                       ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.https.acceptor-threads                                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.https.enabled                                                               false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.https.selector-threads                                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.log.compression.enabled                                                     true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.log.enabled                                                                 true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.log.max-history                                                             15                                                                         15
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.log.max-size                                                                100MB                                                                      100MB
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.log.path                                                                    var/log/http-request.log                                                   var/log/http-request.log
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.log.queue-size                                                              10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.max-request-header-size                                                     2MB                                                                        2MB
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.max-response-header-size                                                    2MB                                                                        2MB
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.threads.max                                                                 200                                                                        200
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.threads.min                                                                 2                                                                          2
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.net.max-idle-time                                                           200.00s                                                                    200.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.process-forwarded                                                           false                                                                      false                                                                      Process Forwarded and X-Forwarded headers (for proxied environments)
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.show-stack-trace                                                            true                                                                       true                                                                       Show the stack trace when generating an error response
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.threads.max-idle-time                                                       1.00m                                                                      1.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstraphttp-server.auth.users-file                                                             ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstrapjmx.rmiregistry.port                                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstrapjmx.rmiserver.port                                                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstrapnode.annotation-file                                                                    ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstrapnode.binary-spec                                                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.425ZINFOmainBootstrapnode.config-spec                                                                        ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.426ZINFOmainBootstrapnode.environment                                                                        ----                                                                       production
2024-03-29 18:43:50 2024-03-29T16:43:50.427ZINFOmainBootstrapnode.internal-address-source                                                            IP                                                                         IP
2024-03-29 18:43:50 2024-03-29T16:43:50.429ZINFOmainBootstrapnode.location                                                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.429ZINFOmainBootstrapnode.bind-ip                                                                            ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.430ZINFOmainBootstrapnode.external-address                                                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapnode.id                                                                                 ----                                                                       ffffffff-ffff-ffff-ffff-ffffffffffff
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapnode.internal-address                                                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapnode.pool                                                                               general                                                                    general
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapopenmetrics.jmx-object-names                                                            []                                                                         []                                                                         JMX object names to include when retrieving all metrics, separated by '|'
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstraptracing.enabled                                                                         false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapaggregation-operator-unspill-memory-limit                                               4MB                                                                        4MB
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapexchange.compression-codec                                                              NONE                                                                       NONE                                                                       Compression codec used for data in exchanges
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapexchange.data-integrity-verification                                                    ABORT                                                                      ABORT
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapfault-tolerant-execution.exchange-encryption-enabled                                    true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapfilter-and-project-min-output-page-row-count                                            256                                                                        256
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapfilter-and-project-min-output-page-size                                                 500kB                                                                      500kB
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapforce-spilling-join-operator                                                            false                                                                      false                                                                      Force spilling join operator in favour of the non-spilling one even when there is no spill
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstraphide-inaccessible-columns                                                               false                                                                      false                                                                      When enabled non-accessible columns are silently filtered from results from SELECT * statements
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapincremental-hash-array-load-factor.enabled                                              true                                                                       true                                                                       Use smaller load factor for small hash arrays in order to improve performance
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstrapdeprecated.legacy-catalog-roles                                                         false                                                                      false                                                                      Enable legacy role management syntax that assumed all roles are catalog scoped
2024-03-29 18:43:50 2024-03-29T16:43:50.431ZINFOmainBootstraplegacy.materialized-view-grace-period                                                   false                                                                      false                                                                      Enable legacy handling of stale materialized views
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapanalyzer.max-grouping-sets                                                              2048                                                                       2048
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapmax-memory-per-partition-writer                                                         256MB                                                                      256MB                                                                      Estimated maximum memory required per partition writer in a single thread
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapmax-recursion-depth                                                                     10                                                                         10                                                                         Maximum recursion depth for recursive common table expression
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapmemory-revoking-target                                                                  0.5                                                                        0.5                                                                        When revoking memory, try to revoke so much that pool is filled below target at the end
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapmemory-revoking-threshold                                                               0.9                                                                        0.9                                                                        Revoke memory when memory pool is filled over threshold
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdeprecated.omit-datetime-type-precision                                                 false                                                                      false                                                                      Enable compatibility mode for legacy clients when rendering datetime type names with default precision
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrappages-index.eager-compaction-enabled                                                    false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapre2j.dfa-retries                                                                        5                                                                          5
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapre2j.dfa-states-limit                                                                   2147483647                                                                 2147483647
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapredistribute-writes                                                                     true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdeprecated.regex-library                                                                JONI                                                                       JONI
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapscale-writers                                                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapspill-enabled                                                                           false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapspiller-max-used-space-threshold                                                        0.9                                                                        0.9
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapspiller-spill-path                                                                      []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapspiller-threads                                                                         4                                                                          4
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapwriter-scaling-min-data-processed                                                       120MB                                                                      120MB                                                                      Minimum amount of uncompressed output data processed by writers before writer scaling can happen
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapcatalog.management                                                                      STATIC                                                                     STATIC
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapcatalog.config-dir                                                                      etc/catalog                                                                etc/catalog
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapcatalog.disabled-catalogs                                                               ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapevent.max-output-stage-size                                                             16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapevent-listener.config-files                                                             []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapenable-coordinator-dynamic-filters-distribution                                         true                                                                       true                                                                       Enable distribution of dynamic filters from coordinator to all workers
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapenable-dynamic-filtering                                                                true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapenable-large-dynamic-filters                                                            false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large.max-distinct-values-per-driver                                  10000                                                                      10000
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large.max-size-per-driver                                             2MB                                                                        2MB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large.max-size-per-filter                                             5MB                                                                        5MB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large.max-size-per-operator                                           5MB                                                                        5MB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large-partitioned.max-distinct-values-per-driver                      1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large-partitioned.max-size-per-driver                                 200kB                                                                      200kB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large-partitioned.max-size-per-operator                               2MB                                                                        2MB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large-partitioned.range-row-limit-per-driver                          2000                                                                       2000
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.large.range-row-limit-per-driver                                      20000                                                                      20000
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.small.max-distinct-values-per-driver                                  1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.small.max-size-per-driver                                             100kB                                                                      100kB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.small.max-size-per-filter                                             5MB                                                                        5MB
2024-03-29 18:43:50 2024-03-29T16:43:50.432ZINFOmainBootstrapdynamic-filtering.small.max-size-per-operator                                           1MB                                                                        1MB
2024-03-29 18:43:50 2024-03-29T16:43:50.434ZINFOmainBootstrapdynamic-filtering.small-partitioned.max-distinct-values-per-driver                      100                                                                        100
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapdynamic-filtering.small-partitioned.max-size-per-driver                                 50kB                                                                       50kB
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapdynamic-filtering.small-partitioned.max-size-per-operator                               500kB                                                                      500kB
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapdynamic-filtering.small-partitioned.range-row-limit-per-driver                          500                                                                        500
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapdynamic-filtering.small.range-row-limit-per-driver                                      2000                                                                       2000
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.client.timeout                                                                    5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.determine-partition-count-for-write-enabled                                       false                                                                      false                                                                      Determine the number of partitions based on amount of data read and processed by the query for write queries
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.remote-task.enable-adaptive-request-size                                          true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-adaptive-query-planning-enabled                                false                                                                      false                                                                      Enable adaptive query planning for the fault tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-compute-task-target-size-growth-factor  1.26                                                                       1.26                                                                       Growth factor for adaptive sizing of non-writer tasks of arbitrary distribution for fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-compute-task-target-size-growth-period  64                                                                         64                                                                         The number of tasks created for any given non-writer stage of arbitrary distribution before task size is increased
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-compute-task-target-size-max            50GB                                                                       50GB                                                                       Max target input size for non-writer task of arbitrary distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-compute-task-target-size-min            512MB                                                                      512MB                                                                      Initial/min target input size for non-writer tasks of arbitrary distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-write-task-target-size-growth-factor    1.26                                                                       1.26                                                                       Growth factor for adaptive sizing of writer tasks of arbitrary distribution for fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-write-task-target-size-growth-period    64                                                                         64                                                                         The number of tasks created for any given writer stage of arbitrary distribution before task size is increased
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-write-task-target-size-max              50GB                                                                       50GB                                                                       Max target input size for writer tasks of arbitrary distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-arbitrary-distribution-write-task-target-size-min              4GB                                                                        4GB                                                                        Initial/min target input size for writer tasks of arbitrary distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-hash-distribution-compute-task-target-size                     512MB                                                                      512MB                                                                      Target input size for non-writer tasks of hash distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-hash-distribution-compute-task-to-node-min-ratio               2.0                                                                        2.0                                                                        Minimal ratio of tasks count vs cluster nodes count for hash distributed compute stage in fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-hash-distribution-write-task-target-max-count                  2000                                                                       2000                                                                       Soft upper bound on number of writer tasks in a stage of hash distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-hash-distribution-write-task-target-size                       4GB                                                                        4GB                                                                        Target input size of writer tasks of hash distribution of fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-hash-distribution-write-task-to-node-min-ratio                 2.0                                                                        2.0                                                                        Minimal ratio of tasks count vs cluster nodes count for hash distributed writer stage in fault-tolerant execution
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-max-partition-count                                            50                                                                         50                                                                         Maximum number of partitions for distributed joins and aggregations executed with fault tolerant execution enabled
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-max-task-split-count                                           256                                                                        256                                                                        Maximal number of splits for a single fault tolerant task (count based)
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-min-partition-count                                            4                                                                          4                                                                          Minimum number of partitions for distributed joins and aggregations executed with fault tolerant execution enabled
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-min-partition-count-for-write                                  50                                                                         50                                                                         Minimum number of partitions for distributed joins and aggregations in write queries executed with fault tolerant execution enabled
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-min-source-stage-progress                                      0.2                                                                        0.2                                                                        Minimal progress of source stage to consider scheduling of parent stage
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-runtime-adaptive-partitioning-enabled                          false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-runtime-adaptive-partitioning-max-task-size                    12GB                                                                       12GB                                                                       Max average task input size when deciding runtime adaptive partitioning
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-runtime-adaptive-partitioning-partition-count                  1000                                                                       1000                                                                       The partition count to use for runtime adaptive partitioning when enabled
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-small-stage-estimation-enabled                                 true                                                                       true                                                                       Enable small stage estimation heuristic, used for more aggresive speculative stage scheduling
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-small-stage-estimation-threshold                               20GB                                                                       20GB                                                                       Threshold until which stage is considered small
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-small-stage-require-no-more-partitions                         false                                                                      false                                                                      Is it required for all stage partitions (tasks) to be enumerated for stage to be used in heuristic to determine if parent stage is small
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-small-stage-source-size-multiplier                             1.2                                                                        1.2                                                                        Multiplier used for heuristic estimation is stage is small; the bigger the more conservative estimation is
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-stage-estimation-for-eager-parent-enabled                      true                                                                       true                                                                       Enable aggressive stage output size estimation heuristic for children of stages to be executed eagerly
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-standard-split-size                                            64MB                                                                       64MB                                                                       Standard split size for a single fault tolerant task (split weight aware)
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapfault-tolerant-execution-task-descriptor-storage-max-memory                             991533466B                                                                 991533466B                                                                 Maximum amount of memory to be used to store task descriptors for fault tolerant queries on coordinator
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-concurrent-queries                                                            1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-hash-partition-count                                                          100                                                                        100                                                                        Maximum number of partitions for distributed joins and aggregations
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-history                                                                       100                                                                        100
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-length                                                                        1000000                                                                    1000000
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-queued-queries                                                                5000                                                                       5000
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.remote-task.max-request-size                                                      8MB                                                                        8MB
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-split-manager-callback-threads                                                100                                                                        100                                                                        The maximum number of threads allowed to run splits generation callbacks concurrently
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-stage-count                                                                   150                                                                        150
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-state-machine-callback-threads                                                5                                                                          5                                                                          The maximum number of threads allowed to run query and stage state machine listener callbacks concurrently for each query
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapmax-tasks-waiting-for-execution-per-query                                               10                                                                         10                                                                         Maximum number of tasks waiting to be scheduled per query. Split enumeration is paused by the scheduler when this threshold is crossed
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapmax-tasks-waiting-for-node-per-stage                                                    5                                                                          5                                                                          Maximum possible number of tasks waiting for node allocation per stage before scheduling of new tasks for stage is paused
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.max-writer-task-count                                                             100                                                                        100                                                                        Maximum number of tasks that will participate in writing data
2024-03-29 18:43:50 2024-03-29T16:43:50.435ZINFOmainBootstrapquery.min-hash-partition-count                                                          4                                                                          4                                                                          Minimum number of partitions for distributed joins and aggregations
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.min-hash-partition-count-for-write                                                50                                                                         50                                                                         Minimum number of partitions for distributed joins and aggregations in write queries
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.min-expire-age                                                                    15.00m                                                                     15.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.min-schedule-split-batch-size                                                     100                                                                        100
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.execution-policy                                                                  phased                                                                     phased
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.executor-pool-size                                                                1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.manager-executor-pool-size                                                        5                                                                          5
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.max-cpu-time                                                                      1000000000.00d                                                             1000000000.00d
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.max-execution-time                                                                100.00d                                                                    100.00d
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.max-planning-time                                                                 10.00m                                                                     10.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.max-run-time                                                                      100.00d                                                                    100.00d
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.max-scan-physical-bytes                                                           ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.reported-rule-stats-limit                                                         10                                                                         10
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery-retry-attempts                                                                    4                                                                          4
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.remote-task.guaranteed-splits-per-task                                            3                                                                          3
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.remote-task.max-callback-threads                                                  1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.remote-task.max-error-duration                                                    5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.remote-task.request-size-headroom                                                 2MB                                                                        2MB
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery-manager.required-workers                                                          1                                                                          1                                                                          Minimum number of active workers that must be available before a query will start
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery-manager.required-workers-max-wait                                                 5.00m                                                                      5.00m                                                                      Maximum time to wait for minimum number of workers before the query is failed
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapretry-delay-scale-factor                                                                2.0                                                                        2.0                                                                        Factor by which retry delay is scaled on subsequent failures
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapretry-initial-delay                                                                     10.00s                                                                     10.00s                                                                     Initial delay before initiating a retry attempt. Delay increases exponentially for each subsequent attempt up to 'retry_max_delay'
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapretry-max-delay                                                                         1.00m                                                                      1.00m                                                                      Maximum delay before initiating a retry attempt. Delay increases exponentially for each subsequent attempt starting from 'retry_initial_delay'
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapretry-policy                                                                            NONE                                                                       NONE
2024-03-29 18:43:50 2024-03-29T16:43:50.436ZINFOmainBootstrapquery.schedule-split-batch-size                                                         1000                                                                       1000
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstrapquery.stage-count-warning-threshold                                                     50                                                                         50                                                                         Emit a warning when stage count exceeds this threshold
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask-retry-attempts-per-task                                                            4                                                                          4
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.client.timeout                                                                     2.00m                                                                      2.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.driver-timeout-threads                                                             5                                                                          5                                                                          Number of threads used for timing out blocked drivers if the timeout is set
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.http-response-threads                                                              100                                                                        100
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.http-timeout-threads                                                               3                                                                          3
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.info.max-age                                                                       15.00m                                                                     15.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.info-update-interval                                                               3.00s                                                                      3.00s                                                                      Interval between updating task data
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.initial-splits-per-node                                                            16                                                                         16
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.interrupt-stuck-split-tasks-detection-interval                                     2.00m                                                                      2.00m                                                                      Interval between detecting stuck split
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.interrupt-stuck-split-tasks-enabled                                                true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.interrupt-stuck-split-tasks-timeout                                                15.00m                                                                     15.00m                                                                     Interrupt task processing thread after this timeout if the thread is stuck in certain external libraries used by Trino functions
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.interrupt-stuck-split-tasks-warning-threshold                                      10.00m                                                                     10.00m                                                                     Print out call stacks and generate JMX metrics for splits running longer than the threshold
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.level-time-multiplier                                                              2                                                                          2                                                                          Factor that determines the target scheduled time for a level relative to the next
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-drivers-per-task                                                               2147483647                                                                 2147483647                                                                 Maximum number of drivers a task can run
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-index-memory                                                                   64MB                                                                       64MB
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-local-exchange-buffer-size                                                     128MB                                                                      128MB
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstrapdriver.max-page-partitioning-buffer-size                                                32MB                                                                       32MB
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-partial-aggregation-memory                                                     16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-partial-top-n-memory                                                           16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-worker-threads                                                                 16                                                                         16
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.max-writer-count                                                                   16                                                                         16                                                                         Maximum number of local parallel table writers per task when either task writer scaling or preferred partitioning is used
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.min-drivers                                                                        32                                                                         32
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.min-drivers-per-task                                                               3                                                                          3                                                                          Minimum number of drivers guaranteed to run per task given there is sufficient work to do
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.min-writer-count                                                                   1                                                                          1                                                                          Minimum number of local parallel table writers per task when preferred partitioning and task writer scaling are not used
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstrapdriver.page-partitioning-buffer-pool-size                                               8                                                                          8                                                                          Maximum number of free buffers in the per task partitioned page buffer pool. Setting this to zero effectively disables the pool
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.per-operator-cpu-timer-enabled                                                     true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.437ZINFOmainBootstraptask.scale-writers.enabled                                                              true                                                                       true                                                                       Scale the number of concurrent table writers per task based on throughput
2024-03-29 18:43:50 2024-03-29T16:43:50.438ZINFOmainBootstraptask.share-index-loading                                                                false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.438ZINFOmainBootstrapsink.max-broadcast-buffer-size                                                          200MB                                                                      200MB
2024-03-29 18:43:50 2024-03-29T16:43:50.439ZINFOmainBootstrapsink.max-buffer-size                                                                    32MB                                                                       32MB
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.split-concurrency-adjustment-interval                                              100.00ms                                                                   100.00ms
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.statistics-cpu-timer-enabled                                                       true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.status-refresh-max-wait                                                            1.00s                                                                      1.00s
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.concurrency                                                                        8                                                                          8                                                                          Default number of local parallel jobs per worker
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.cpu-timer-enabled                                                                  true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.task-notification-threads                                                          5                                                                          5                                                                          Number of threads used for internal task event notifications
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.termination-timeout                                                                1.00m                                                                      1.00m                                                                      Maximum duration to wait for a task to complete termination before failing the task on the coordinator
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.task-yield-threads                                                                 3                                                                          3                                                                          Number of threads used for setting yield signals
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexperimental.thread-per-driver-scheduler-enabled                                        true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.allowed-no-matching-node-period                                          2.00m                                                                      2.00m                                                                      How long scheduler should wait before failing a query for which hard task requirements (e.g. node exposing specific catalog) cannot be satisfied
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.include-coordinator                                                      true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.max-adjusted-pending-splits-per-task                                     2000                                                                       2000
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.max-splits-per-node                                                      256                                                                        256
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.max-unacknowledged-splits-per-task                                       2000                                                                       2000                                                                       Maximum number of leaf splits not yet delivered to a given task
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.min-candidates                                                           10                                                                         10
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.min-pending-splits-per-task                                              16                                                                         16
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.policy                                                                   UNIFORM                                                                    UNIFORM
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.optimized-local-scheduling                                               true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapnode-scheduler.splits-balancing-policy                                                  STAGE                                                                      STAGE                                                                      Strategy for balancing new splits on worker nodes
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapwarning-collector.max-warnings                                                          2147483647                                                                 2147483647
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfailure-detector.enabled                                                                true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfailure-detector.expiration-grace-interval                                              10.00m                                                                     10.00m                                                                     How long to wait before 'forgetting' a service after it disappears from discovery
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfailure-detector.threshold                                                              0.1                                                                        0.1
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfailure-detector.heartbeat-interval                                                     500.00ms                                                                   500.00ms
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfailure-detector.warmup-interval                                                        5.00s                                                                      5.00s                                                                      How long to wait after transitioning to success before considering a service alive
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution-coordinator-task-memory                                        2GB                                                                        2GB                                                                        Estimated amount of memory a single coordinator task will use when task level retries are used; value is used when allocating nodes for tasks execution
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution-eager-speculative-tasks-node_memory-overcommit                 20GB                                                                       20GB
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution.memory-requirement-increase-on-worker-crash-enabled            true                                                                       true                                                                       Increase memory requirement for tasks failed due to a suspected worker crash
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution-task-memory                                                    5GB                                                                        5GB                                                                        Estimated amount of memory a single task will use when task level retries are used; value is used when allocating nodes for tasks execution
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution-task-memory-estimation-quantile                                0.9                                                                        0.9                                                                        What quantile of memory usage of completed tasks to look at when estimating memory usage for upcoming tasks
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution-task-memory-growth-factor                                      3.0                                                                        3.0                                                                        Factor by which estimated task memory is increased if task execution runs out of memory; value is used allocating nodes for tasks execution
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapfault-tolerant-execution-task-runtime-memory-estimation-overhead                        1GB                                                                        1GB                                                                        Extra memory to account for when estimating actual task runtime memory consumption
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapquery.low-memory-killer.delay                                                           5.00m                                                                      5.00m                                                                      Delay between cluster running low on memory and invoking killer
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapquery.low-memory-killer.policy                                                          TOTAL_RESERVATION_ON_BLOCKED_NODES                                         TOTAL_RESERVATION_ON_BLOCKED_NODES
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstraptask.low-memory-killer.policy                                                           TOTAL_RESERVATION_ON_BLOCKED_NODES                                         TOTAL_RESERVATION_ON_BLOCKED_NODES
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapquery.max-memory                                                                        20GB                                                                       20GB
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapquery.max-total-memory                                                                  40GB                                                                       40GB
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapmemory.heap-headroom-per-node                                                           1983066931B                                                                1983066931B                                                                The amount of heap memory to set aside as headroom/buffer (e.g., for untracked allocations)
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapquery.max-memory-per-node                                                               1983066931B                                                                1983066931B
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.acknowledge-pages                                                              true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.client-threads                                                                 25                                                                         25
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.concurrent-request-multiplier                                                  3                                                                          3
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.deduplication-buffer-size                                                      32MB                                                                       32MB
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.max-buffer-size                                                                32MB                                                                       32MB
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.max-error-duration                                                             5.00m                                                                      5.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.440ZINFOmainBootstrapexchange.max-response-size                                                              16MB                                                                       16MB
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapexchange.page-buffer-client.max-callback-threads                                        25                                                                         25
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapaccess-control.config-files                                                             []                                                                         []
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapdiscovery-server.enabled                                                                true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.http2.enabled                                                    false                                                                      false                                                                      Enable the HTTP/2 transport
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.https.required                                                   false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.https.keystore.key                                               [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.https.keystore.path                                              ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.shared-secret                                                    [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.https.truststore.key                                             [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapinternal-communication.https.truststore.path                                            ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapjmx.base-name                                                                           trino                                                                      trino
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapprotocol.v1.alternate-header-name                                                       ----                                                                       ----                                                                       Alternate header name for V1 protocol
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapprotocol.v1.prepared-statement-compression.min-gain                                     512                                                                        512                                                                        Prepared statement compression is not applied if the size gain is less than the configured value
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapprotocol.v1.prepared-statement-compression.length-threshold                             2048                                                                       2048                                                                       Compression is applied to prepared statements longer than the configured value
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapexperimental.concurrent-startup                                                         false                                                                      false                                                                      Parallelize work during server startup
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapcoordinator                                                                             true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapshutdown.grace-period                                                                   2.00m                                                                      2.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstraphttp.include-exception-in-response                                                      true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapquery.info-url-template                                                                 ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapquery-results.compression-enabled                                                       true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapplugin.dir                                                                              plugin                                                                     plugin
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstraphttp-server.authentication.insecure.user-mapping.file                                   ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstraphttp-server.authentication.insecure.user-mapping.pattern                                ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstraphttp-server.authentication.type                                                         [insecure]                                                                 [insecure]                                                                 Ordered list of authentication types
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapmanagement.user                                                                         ----                                                                       ----                                                                       Optional fixed user for all requests to management endpoints
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapmanagement.user.https-enabled                                                           false                                                                      false                                                                      Use fixed management user for secure HTTPS requests
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstraphttp-server.authentication.allow-insecure-over-http                                     true                                                                       true                                                                       Insecure authentication over HTTP (non-secure) enabled
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapweb-ui.session-timeout                                                                  1.00d                                                                      1.00d
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapweb-ui.shared-secret                                                                    [REDACTED]                                                                 [REDACTED]
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapweb-ui.authentication.type                                                              ----                                                                       ----                                                                       Authentication type for the web ui
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapweb-ui.enabled                                                                          true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapmax-spill-per-node                                                                      100GB                                                                      100GB
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapquery-max-spill-per-node                                                                100GB                                                                      100GB
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapspill-compression-codec                                                                 NONE                                                                       NONE                                                                       Compression codec used for data in spills
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapspill-encryption-enabled                                                                false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapsql.default-catalog                                                                     ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapsql.default-function-catalog                                                            ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapsql.default-function-schema                                                             ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapsql.default-schema                                                                      ----                                                                       ----
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapsql.forced-session-time-zone                                                            ----                                                                       ----                                                                       User session time zone overriding value sent by client
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapsql.path
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapcompiler.expression-cache-size                                                          10000                                                                      10000                                                                      Reuse compiled expressions across multiple queries
2024-03-29 18:43:50 2024-03-29T16:43:50.441ZINFOmainBootstrapcompiler.specialized-aggregation-loops                                                  true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapadaptive-partial-aggregation.enabled                                                    true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapadaptive-partial-aggregation.unique-rows-ratio-threshold                                0.8                                                                        0.8                                                                        Ratio between aggregation output and input rows above which partial aggregation might be adaptively turned off
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapcollect-plan-statistics-for-all-queries                                                 false                                                                      false                                                                      Collect plan statistics for non-EXPLAIN queries
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapcolocated-joins-enabled                                                                 true                                                                       true                                                                       Use a colocated join when possible
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.complex-expression-pushdown.enabled                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapcpu-cost-weight                                                                         75.0                                                                       75.0
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.default-filter-factor-enabled                                                 false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.dictionary-aggregation                                                        false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapdistributed-sort                                                                        true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapenable-forced-exchange-below-group-id                                                   true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.enable-intermediate-aggregations                                              false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapenable-stats-calculator                                                                 true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.filter-conjunction-independence-factor                                        0.75                                                                       0.75                                                                       Scales the strength of independence assumption for selectivity estimates of the conjunction of multiple filters
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.force-single-node-output                                                      false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.442ZINFOmainBootstrapoptimizer.ignore-downstream-preferences                                                 false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.443ZINFOmainBootstrapoptimizer.ignore-stats-calculator-failures                                              true                                                                       true                                                                       Ignore statistics calculator failures
2024-03-29 18:43:50 2024-03-29T16:43:50.443ZINFOmainBootstrapiterative-optimizer-timeout                                                             3.00m                                                                      3.00m
2024-03-29 18:43:50 2024-03-29T16:43:50.443ZINFOmainBootstrapjoin-distribution-type                                                                  AUTOMATIC                                                                  AUTOMATIC
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapjoin-max-broadcast-table-size                                                           100MB                                                                      100MB                                                                      Maximum estimated size of a table that can be broadcast when using automatic join type selection
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.join-multi-clause-independence-factor                                         0.25                                                                       0.25                                                                       Scales the strength of independence assumption for selectivity estimates of multi-clause joins
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.join-partitioned-build-min-row-count                                          1000000                                                                    1000000                                                                    Minimum number of join build side rows required to use partitioned join lookup
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.join-reordering-strategy                                                      AUTOMATIC                                                                  AUTOMATIC                                                                  The strategy to use for reordering joins
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.mark-distinct-strategy                                                        AUTOMATIC                                                                  AUTOMATIC                                                                  Strategy to use for distinct aggregations
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.max-reordered-joins                                                           9                                                                          9                                                                          The maximum number of tables to reorder in cost-based join reordering
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapmemory-cost-weight                                                                      10.0                                                                       10.0
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.merge-project-with-values                                                     true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.min-input-rows-per-task                                                       10000000                                                                   10000000                                                                   Minimum input rows required per task. This will help optimizer determine hash partition count for joins and aggregations
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.min-input-size-per-task                                                       5GB                                                                        5GB                                                                        Minimum input data size required per task. This will help optimizer determine hash partition count for joins and aggregations
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapnetwork-cost-weight                                                                     15.0                                                                       15.0
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.non-estimatable-predicate-approximation.enabled                               true                                                                       true                                                                       Approximate the cost of filters which cannot be accurately estimated even with complete statistics
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.optimize-duplicate-insensitive-joins                                          true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.optimize-hash-generation                                                      false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.optimize-metadata-queries                                                     false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.optimize-mixed-distinct-aggregations                                          false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.optimize-top-n-ranking                                                        true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.pre-aggregate-case-aggregations.enabled                                       true                                                                       true                                                                       Pre-aggregate rows before GROUP BY with multiple CASE aggregations on same column
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.predicate-pushdown-use-table-properties                                       true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.prefer-partial-aggregation                                                    true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.push-aggregation-through-outer-join                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.push-partial-aggregation-through-join                                         false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.push-table-write-through-union                                                true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.rewrite-filtering-semi-join-to-inner-join                                     true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.skip-redundant-sort                                                           true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapspatial-joins-enabled                                                                   true                                                                       true                                                                       Use spatial index for spatial joins when possible
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapstatistics-precalculation-for-pushdown.enabled                                          true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.table-scan-node-partitioning-min-bucket-to-task-ratio                         0.5                                                                        0.5                                                                        Min table scan bucket to task ratio for which plan will be adopted to node pre-partitioned tables
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.use-cost-based-partitioning                                                   true                                                                       true                                                                       When enabled the cost based optimizer is used to determine if repartitioning the output of an already partitioned stage is necessary
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.use-exact-partitioning                                                        false                                                                      false                                                                      When enabled this forces data repartitioning unless the partitioning of upstream stage matches exactly what downstream stage expects
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.use-legacy-window-filter-pushdown                                             false                                                                      false
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapuse-preferred-write-partitioning                                                        true                                                                       true
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstrapoptimizer.use-table-scan-node-partitioning                                              true                                                                       true                                                                       Adapt plan to node pre-partitioned tables
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstraptransaction.idle-check-interval                                                         1.00m                                                                      1.00m                                                                      Time interval between idle transactions checks
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstraptransaction.idle-timeout                                                                5.00m                                                                      5.00m                                                                      Amount of time before an inactive transaction is considered expired
2024-03-29 18:43:50 2024-03-29T16:43:50.444ZINFOmainBootstraptransaction.max-finishing-concurrency                                                   1                                                                          1                                                                          Maximum parallelism for committing or aborting a transaction
2024-03-29 18:43:54 2024-03-29T16:43:54.200ZINFOmainorg.eclipse.jetty.server.Serverjetty-12.0.7; built: 2024-02-29T21:19:41.771Z; git: c89aca8fd34083befd79f328a3b8b6ffff04347e; jvm 21.0.2+13-LTS
2024-03-29 18:43:54 2024-03-29T16:43:54.238ZINFOmainorg.eclipse.jetty.server.handler.ContextHandlerStarted oeje10s.ServletContextHandler@4866e0a7{ROOT,/,b=null,a=AVAILABLE,vh=[@http,@https],h=GzipHandler@a1a72d4{STARTED,min=32,inflate=-1}}
2024-03-29 18:43:54 2024-03-29T16:43:54.926ZINFOmainorg.eclipse.jetty.ee10.servlet.ServletContextHandlerStarted oeje10s.ServletContextHandler@4866e0a7{ROOT,/,b=null,a=AVAILABLE,vh=[@http,@https],h=GzipHandler@a1a72d4{STARTED,min=32,inflate=-1}}
2024-03-29 18:43:54 2024-03-29T16:43:54.938ZINFOmainorg.eclipse.jetty.server.AbstractConnectorStarted http@538a90a5{HTTP/1.1, (http/1.1, h2c)}{0.0.0.0:8080}
2024-03-29 18:43:54 2024-03-29T16:43:54.943ZINFOmainorg.eclipse.jetty.server.ServerStarted oejs.Server@903c13{STARTING}[12.0.7,sto=0] @14412ms
2024-03-29 18:43:55 2024-03-29T16:43:55.781ZWARNquery-management-2io.trino.memory.RemoteNodeMemoryMemory info update request to http://172.17.0.3:8080/v1/memory has not returned in 73037.53s
2024-03-29 18:43:57 2024-03-29T16:43:57.804ZINFOmainio.trino.server.ServerTrino version: 443
2024-03-29 18:43:57 2024-03-29T16:43:57.808ZINFOmainio.trino.server.ServerWorking directory: /usr/lib/trino
2024-03-29 18:43:57 2024-03-29T16:43:57.809ZINFOmainio.trino.server.ServerEtc directory: /etc/trino
2024-03-29 18:43:57 2024-03-29T16:43:57.821ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/accumulo --
2024-03-29 18:43:57 2024-03-29T16:43:57.922ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.accumulo.AccumuloPlugin
2024-03-29 18:43:57 2024-03-29T16:43:57.929ZINFOmainio.trino.server.PluginManagerRegistering connector accumulo
2024-03-29 18:43:57 2024-03-29T16:43:57.934ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/accumulo --
2024-03-29 18:43:57 2024-03-29T16:43:57.935ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/atop --
2024-03-29 18:43:57 2024-03-29T16:43:57.953ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.atop.AtopPlugin
2024-03-29 18:43:57 2024-03-29T16:43:57.959ZINFOmainio.trino.server.PluginManagerRegistering connector atop
2024-03-29 18:43:57 2024-03-29T16:43:57.964ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/atop --
2024-03-29 18:43:57 2024-03-29T16:43:57.964ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/bigquery --
2024-03-29 18:43:58 2024-03-29T16:43:58.044ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.bigquery.BigQueryPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.049ZINFOmainio.trino.server.PluginManagerRegistering connector bigquery
2024-03-29 18:43:58 2024-03-29T16:43:58.050ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/bigquery --
2024-03-29 18:43:58 2024-03-29T16:43:58.051ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/blackhole --
2024-03-29 18:43:58 2024-03-29T16:43:58.067ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.blackhole.BlackHolePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.072ZINFOmainio.trino.server.PluginManagerRegistering connector blackhole
2024-03-29 18:43:58 2024-03-29T16:43:58.074ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/blackhole --
2024-03-29 18:43:58 2024-03-29T16:43:58.075ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/cassandra --
2024-03-29 18:43:58 2024-03-29T16:43:58.101ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.cassandra.CassandraPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.106ZINFOmainio.trino.server.PluginManagerRegistering connector cassandra
2024-03-29 18:43:58 2024-03-29T16:43:58.107ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/cassandra --
2024-03-29 18:43:58 2024-03-29T16:43:58.107ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/clickhouse --
2024-03-29 18:43:58 2024-03-29T16:43:58.230ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.clickhouse.ClickHousePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.239ZINFOmainio.trino.server.PluginManagerRegistering connector clickhouse
2024-03-29 18:43:58 2024-03-29T16:43:58.244ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/clickhouse --
2024-03-29 18:43:58 2024-03-29T16:43:58.245ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/delta-lake --
2024-03-29 18:43:58 2024-03-29T16:43:58.375ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.deltalake.DeltaLakePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.386ZINFOmainio.trino.server.PluginManagerRegistering connector delta_lake
2024-03-29 18:43:58 2024-03-29T16:43:58.387ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/delta-lake --
2024-03-29 18:43:58 2024-03-29T16:43:58.387ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/druid --
2024-03-29 18:43:58 2024-03-29T16:43:58.403ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.druid.DruidJdbcPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.412ZINFOmainio.trino.server.PluginManagerRegistering connector druid
2024-03-29 18:43:58 2024-03-29T16:43:58.414ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/druid --
2024-03-29 18:43:58 2024-03-29T16:43:58.414ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/elasticsearch --
2024-03-29 18:43:58 2024-03-29T16:43:58.448ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.elasticsearch.ElasticsearchPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.455ZINFOmainio.trino.server.PluginManagerRegistering connector elasticsearch
2024-03-29 18:43:58 2024-03-29T16:43:58.455ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/elasticsearch --
2024-03-29 18:43:58 2024-03-29T16:43:58.456ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/example-http --
2024-03-29 18:43:58 2024-03-29T16:43:58.463ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.example.ExamplePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.467ZINFOmainio.trino.server.PluginManagerRegistering connector example_http
2024-03-29 18:43:58 2024-03-29T16:43:58.468ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/example-http --
2024-03-29 18:43:58 2024-03-29T16:43:58.468ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/exchange-filesystem --
2024-03-29 18:43:58 2024-03-29T16:43:58.491ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.exchange.filesystem.FileSystemExchangePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.496ZINFOmainio.trino.server.PluginManagerRegistering exchange manager filesystem
2024-03-29 18:43:58 2024-03-29T16:43:58.496ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/exchange-filesystem --
2024-03-29 18:43:58 2024-03-29T16:43:58.497ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/exchange-hdfs --
2024-03-29 18:43:58 2024-03-29T16:43:58.521ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.exchange.hdfs.HdfsExchangePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.526ZINFOmainio.trino.server.PluginManagerRegistering exchange manager hdfs
2024-03-29 18:43:58 2024-03-29T16:43:58.527ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/exchange-hdfs --
2024-03-29 18:43:58 2024-03-29T16:43:58.527ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/geospatial --
2024-03-29 18:43:58 2024-03-29T16:43:58.533ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.geospatial.GeoPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.547ZINFOmainio.trino.server.PluginManagerRegistering type Geometry
2024-03-29 18:43:58 2024-03-29T16:43:58.548ZINFOmainio.trino.server.PluginManagerRegistering type BingTile
2024-03-29 18:43:58 2024-03-29T16:43:58.548ZINFOmainio.trino.server.PluginManagerRegistering type KdbTree
2024-03-29 18:43:58 2024-03-29T16:43:58.548ZINFOmainio.trino.server.PluginManagerRegistering type SphericalGeography
2024-03-29 18:43:58 2024-03-29T16:43:58.555ZINFOmainio.trino.server.PluginManagerRegistering functions from GeoPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.676ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/geospatial --
2024-03-29 18:43:58 2024-03-29T16:43:58.677ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/google-sheets --
2024-03-29 18:43:58 2024-03-29T16:43:58.693ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.google.sheets.SheetsPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.699ZINFOmainio.trino.server.PluginManagerRegistering connector gsheets
2024-03-29 18:43:58 2024-03-29T16:43:58.700ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/google-sheets --
2024-03-29 18:43:58 2024-03-29T16:43:58.700ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/hive --
2024-03-29 18:43:58 2024-03-29T16:43:58.749ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.hive.HivePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.756ZINFOmainio.trino.server.PluginManagerRegistering connector hive
2024-03-29 18:43:58 2024-03-29T16:43:58.757ZINFOmainio.trino.server.PluginManagerRegistering functions from HivePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.760ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/hive --
2024-03-29 18:43:58 2024-03-29T16:43:58.760ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/http-event-listener --
2024-03-29 18:43:58 2024-03-29T16:43:58.767ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.httpquery.HttpEventListenerPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.768ZINFOmainio.trino.server.PluginManagerRegistering event listener http
2024-03-29 18:43:58 2024-03-29T16:43:58.769ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/http-event-listener --
2024-03-29 18:43:58 2024-03-29T16:43:58.769ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/hudi --
2024-03-29 18:43:58 2024-03-29T16:43:58.802ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.hudi.HudiPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.811ZINFOmainio.trino.server.PluginManagerRegistering connector hudi
2024-03-29 18:43:58 2024-03-29T16:43:58.813ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/hudi --
2024-03-29 18:43:58 2024-03-29T16:43:58.814ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/iceberg --
2024-03-29 18:43:58 2024-03-29T16:43:58.860ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.iceberg.IcebergPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.867ZINFOmainio.trino.server.PluginManagerRegistering connector iceberg
2024-03-29 18:43:58 2024-03-29T16:43:58.868ZINFOmainio.trino.server.PluginManagerRegistering functions from IcebergPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.877ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/iceberg --
2024-03-29 18:43:58 2024-03-29T16:43:58.877ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/ignite --
2024-03-29 18:43:58 2024-03-29T16:43:58.889ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.ignite.IgnitePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.894ZINFOmainio.trino.server.PluginManagerRegistering connector ignite
2024-03-29 18:43:58 2024-03-29T16:43:58.894ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/ignite --
2024-03-29 18:43:58 2024-03-29T16:43:58.894ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/jmx --
2024-03-29 18:43:58 2024-03-29T16:43:58.901ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.jmx.JmxPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.905ZINFOmainio.trino.server.PluginManagerRegistering connector jmx
2024-03-29 18:43:58 2024-03-29T16:43:58.906ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/jmx --
2024-03-29 18:43:58 2024-03-29T16:43:58.906ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/kafka --
2024-03-29 18:43:58 2024-03-29T16:43:58.926ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.kafka.KafkaPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.929ZINFOmainio.trino.server.PluginManagerRegistering connector kafka
2024-03-29 18:43:58 2024-03-29T16:43:58.931ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/kafka --
2024-03-29 18:43:58 2024-03-29T16:43:58.931ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/kinesis --
2024-03-29 18:43:58 2024-03-29T16:43:58.945ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.kinesis.KinesisPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.949ZINFOmainio.trino.server.PluginManagerRegistering connector kinesis
2024-03-29 18:43:58 2024-03-29T16:43:58.950ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/kinesis --
2024-03-29 18:43:58 2024-03-29T16:43:58.950ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/kudu --
2024-03-29 18:43:58 2024-03-29T16:43:58.959ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.kudu.KuduPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.963ZINFOmainio.trino.server.PluginManagerRegistering connector kudu
2024-03-29 18:43:58 2024-03-29T16:43:58.963ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/kudu --
2024-03-29 18:43:58 2024-03-29T16:43:58.963ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/local-file --
2024-03-29 18:43:58 2024-03-29T16:43:58.970ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.localfile.LocalFilePlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.974ZINFOmainio.trino.server.PluginManagerRegistering connector localfile
2024-03-29 18:43:58 2024-03-29T16:43:58.975ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/local-file --
2024-03-29 18:43:58 2024-03-29T16:43:58.975ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/mariadb --
2024-03-29 18:43:58 2024-03-29T16:43:58.986ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.mariadb.MariaDbPlugin
2024-03-29 18:43:58 2024-03-29T16:43:58.990ZINFOmainio.trino.server.PluginManagerRegistering connector mariadb
2024-03-29 18:43:58 2024-03-29T16:43:58.991ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/mariadb --
2024-03-29 18:43:58 2024-03-29T16:43:58.991ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/memory --
2024-03-29 18:43:58 2024-03-29T16:43:58.998ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.memory.MemoryPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.002ZINFOmainio.trino.server.PluginManagerRegistering connector memory
2024-03-29 18:43:59 2024-03-29T16:43:59.003ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/memory --
2024-03-29 18:43:59 2024-03-29T16:43:59.003ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/ml --
2024-03-29 18:43:59 2024-03-29T16:43:59.072ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.ml.MLPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.077ZINFOmainio.trino.server.PluginManagerRegistering type Model
2024-03-29 18:43:59 2024-03-29T16:43:59.077ZINFOmainio.trino.server.PluginManagerRegistering type Regressor
2024-03-29 18:43:59 2024-03-29T16:43:59.077ZINFOmainio.trino.server.PluginManagerRegistering parametric type Classifier
2024-03-29 18:43:59 2024-03-29T16:43:59.081ZINFOmainio.trino.server.PluginManagerRegistering functions from MLPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.222ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/ml --
2024-03-29 18:43:59 2024-03-29T16:43:59.222ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/mongodb --
2024-03-29 18:43:59 2024-03-29T16:43:59.231ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.mongodb.MongoPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.235ZINFOmainio.trino.server.PluginManagerRegistering type ObjectId
2024-03-29 18:43:59 2024-03-29T16:43:59.236ZINFOmainio.trino.server.PluginManagerRegistering connector mongodb
2024-03-29 18:43:59 2024-03-29T16:43:59.237ZINFOmainio.trino.server.PluginManagerRegistering functions from MongoPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.250ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/mongodb --
2024-03-29 18:43:59 2024-03-29T16:43:59.250ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/mysql --
2024-03-29 18:43:59 2024-03-29T16:43:59.262ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.mysql.MySqlPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.266ZINFOmainio.trino.server.PluginManagerRegistering connector mysql
2024-03-29 18:43:59 2024-03-29T16:43:59.266ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/mysql --
2024-03-29 18:43:59 2024-03-29T16:43:59.266ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/mysql-event-listener --
2024-03-29 18:43:59 2024-03-29T16:43:59.274ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.eventlistener.mysql.MysqlEventListenerPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.278ZINFOmainio.trino.server.PluginManagerRegistering event listener mysql
2024-03-29 18:43:59 2024-03-29T16:43:59.279ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/mysql-event-listener --
2024-03-29 18:43:59 2024-03-29T16:43:59.279ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/opa --
2024-03-29 18:43:59 2024-03-29T16:43:59.287ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.opa.OpaAccessControlPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.290ZINFOmainio.trino.server.PluginManagerRegistering system access control opa
2024-03-29 18:43:59 2024-03-29T16:43:59.291ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/opa --
2024-03-29 18:43:59 2024-03-29T16:43:59.291ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/opensearch --
2024-03-29 18:43:59 2024-03-29T16:43:59.304ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.opensearch.OpenSearchPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.308ZINFOmainio.trino.server.PluginManagerRegistering connector opensearch
2024-03-29 18:43:59 2024-03-29T16:43:59.308ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/opensearch --
2024-03-29 18:43:59 2024-03-29T16:43:59.309ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/oracle --
2024-03-29 18:43:59 2024-03-29T16:43:59.323ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.oracle.OraclePlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.329ZINFOmainio.trino.server.PluginManagerRegistering connector oracle
2024-03-29 18:43:59 2024-03-29T16:43:59.330ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/oracle --
2024-03-29 18:43:59 2024-03-29T16:43:59.330ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/password-authenticators --
2024-03-29 18:43:59 2024-03-29T16:43:59.338ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.password.PasswordAuthenticatorPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.342ZINFOmainio.trino.server.PluginManagerRegistering group provider file
2024-03-29 18:43:59 2024-03-29T16:43:59.344ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/password-authenticators --
2024-03-29 18:43:59 2024-03-29T16:43:59.344ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/phoenix5 --
2024-03-29 18:43:59 2024-03-29T16:43:59.368ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.phoenix5.PhoenixPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.372ZINFOmainio.trino.server.PluginManagerRegistering connector phoenix5
2024-03-29 18:43:59 2024-03-29T16:43:59.375ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/phoenix5 --
2024-03-29 18:43:59 2024-03-29T16:43:59.375ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/pinot --
2024-03-29 18:43:59 2024-03-29T16:43:59.641ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.pinot.PinotPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.657ZINFOmainio.trino.server.PluginManagerRegistering connector pinot
2024-03-29 18:43:59 2024-03-29T16:43:59.671ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/pinot --
2024-03-29 18:43:59 2024-03-29T16:43:59.672ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/postgresql --
2024-03-29 18:43:59 2024-03-29T16:43:59.711ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.postgresql.PostgreSqlPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.713ZINFOmainio.trino.server.PluginManagerRegistering connector postgresql
2024-03-29 18:43:59 2024-03-29T16:43:59.719ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/postgresql --
2024-03-29 18:43:59 2024-03-29T16:43:59.719ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/prometheus --
2024-03-29 18:43:59 2024-03-29T16:43:59.728ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.prometheus.PrometheusPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.733ZINFOmainio.trino.server.PluginManagerRegistering connector prometheus
2024-03-29 18:43:59 2024-03-29T16:43:59.733ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/prometheus --
2024-03-29 18:43:59 2024-03-29T16:43:59.734ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/raptor-legacy --
2024-03-29 18:43:59 2024-03-29T16:43:59.756ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.raptor.legacy.RaptorPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.759ZINFOmainio.trino.server.PluginManagerRegistering connector raptor_legacy
2024-03-29 18:43:59 2024-03-29T16:43:59.760ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/raptor-legacy --
2024-03-29 18:43:59 2024-03-29T16:43:59.760ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/redis --
2024-03-29 18:43:59 2024-03-29T16:43:59.772ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.redis.RedisPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.777ZINFOmainio.trino.server.PluginManagerRegistering connector redis
2024-03-29 18:43:59 2024-03-29T16:43:59.777ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/redis --
2024-03-29 18:43:59 2024-03-29T16:43:59.777ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/redshift --
2024-03-29 18:43:59 2024-03-29T16:43:59.790ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.redshift.RedshiftPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.794ZINFOmainio.trino.server.PluginManagerRegistering connector redshift
2024-03-29 18:43:59 2024-03-29T16:43:59.795ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/redshift --
2024-03-29 18:43:59 2024-03-29T16:43:59.795ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/resource-group-managers --
2024-03-29 18:43:59 2024-03-29T16:43:59.804ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.resourcegroups.ResourceGroupManagerPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.807ZINFOmainio.trino.server.PluginManagerRegistering resource group configuration manager file
2024-03-29 18:43:59 2024-03-29T16:43:59.807ZINFOmainio.trino.server.PluginManagerRegistering resource group configuration manager db
2024-03-29 18:43:59 2024-03-29T16:43:59.808ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/resource-group-managers --
2024-03-29 18:43:59 2024-03-29T16:43:59.808ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/session-property-managers --
2024-03-29 18:43:59 2024-03-29T16:43:59.815ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.session.SessionPropertyConfigurationManagerPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.819ZINFOmainio.trino.server.PluginManagerRegistering session property configuration manager file
2024-03-29 18:43:59 2024-03-29T16:43:59.819ZINFOmainio.trino.server.PluginManagerRegistering session property configuration manager db
2024-03-29 18:43:59 2024-03-29T16:43:59.819ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/session-property-managers --
2024-03-29 18:43:59 2024-03-29T16:43:59.819ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/singlestore --
2024-03-29 18:43:59 2024-03-29T16:43:59.829ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.singlestore.SingleStorePlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.833ZINFOmainio.trino.server.PluginManagerRegistering connector singlestore
2024-03-29 18:43:59 2024-03-29T16:43:59.833ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/singlestore --
2024-03-29 18:43:59 2024-03-29T16:43:59.833ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/snowflake --
2024-03-29 18:43:59 2024-03-29T16:43:59.850ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.snowflake.SnowflakePlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.855ZINFOmainio.trino.server.PluginManagerRegistering connector snowflake
2024-03-29 18:43:59 2024-03-29T16:43:59.855ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/snowflake --
2024-03-29 18:43:59 2024-03-29T16:43:59.855ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/sqlserver --
2024-03-29 18:43:59 2024-03-29T16:43:59.866ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.sqlserver.SqlServerPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.870ZINFOmainio.trino.server.PluginManagerRegistering connector sqlserver
2024-03-29 18:43:59 2024-03-29T16:43:59.871ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/sqlserver --
2024-03-29 18:43:59 2024-03-29T16:43:59.871ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/teradata-functions --
2024-03-29 18:43:59 2024-03-29T16:43:59.875ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.teradata.functions.TeradataFunctionsPlugin
2024-03-29 18:43:59 2024-03-29T16:43:59.880ZINFOmainio.trino.server.PluginManagerRegistering functions from TeradataFunctionsPlugin
2024-03-29 18:44:00 2024-03-29T16:44:00.062ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/teradata-functions --
2024-03-29 18:44:00 2024-03-29T16:44:00.063ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/thrift --
2024-03-29 18:44:00 2024-03-29T16:44:00.078ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.thrift.ThriftPlugin
2024-03-29 18:44:00 2024-03-29T16:44:00.082ZINFOmainio.trino.server.PluginManagerRegistering connector trino_thrift
2024-03-29 18:44:00 2024-03-29T16:44:00.082ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/thrift --
2024-03-29 18:44:00 2024-03-29T16:44:00.082ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/tpcds --
2024-03-29 18:44:00 2024-03-29T16:44:00.092ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.tpcds.TpcdsPlugin
2024-03-29 18:44:00 2024-03-29T16:44:00.140ZINFOmainio.trino.server.PluginManagerRegistering connector tpcds
2024-03-29 18:44:00 2024-03-29T16:44:00.141ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/tpcds --
2024-03-29 18:44:00 2024-03-29T16:44:00.141ZINFOmainio.trino.server.PluginManager-- Loading plugin /usr/lib/trino/plugin/tpch --
2024-03-29 18:44:00 2024-03-29T16:44:00.148ZINFOmainio.trino.server.PluginManagerInstalling io.trino.plugin.tpch.TpchPlugin
2024-03-29 18:44:00 2024-03-29T16:44:00.153ZINFOmainio.trino.server.PluginManagerRegistering connector tpch
2024-03-29 18:44:00 2024-03-29T16:44:00.154ZINFOmainio.trino.server.PluginManager-- Finished loading plugin /usr/lib/trino/plugin/tpch --
2024-03-29 18:44:00 2024-03-29T16:44:00.170ZINFOmainio.trino.connector.StaticCatalogManager-- Loading catalog tpch --
2024-03-29 18:44:00 2024-03-29T16:44:00.200ZINFOmainio.trino.connector.StaticCatalogManager-- Added catalog tpch using connector tpch --
2024-03-29 18:44:00 2024-03-29T16:44:00.201ZINFOmainio.trino.connector.StaticCatalogManager-- Loading catalog jmx --
2024-03-29 18:44:00 2024-03-29T16:44:00.300ZINFOmainorg.hibernate.validator.internal.util.VersionHV000001: Hibernate Validator 8.0.1.Final
2024-03-29 18:44:00 2024-03-29T16:44:00.523ZINFOmainBootstrapPROPERTY         DEFAULT  RUNTIME  DESCRIPTION
2024-03-29 18:44:00 2024-03-29T16:44:00.523ZINFOmainBootstrapjmx.dump-period  10.00s   10.00s
2024-03-29 18:44:00 2024-03-29T16:44:00.523ZINFOmainBootstrapjmx.dump-tables  []       []
2024-03-29 18:44:00 2024-03-29T16:44:00.523ZINFOmainBootstrapjmx.max-entries  86400    86400
2024-03-29 18:44:00 2024-03-29T16:44:00.614ZINFOmainio.trino.connector.StaticCatalogManager-- Added catalog jmx using connector jmx --
2024-03-29 18:44:00 2024-03-29T16:44:00.614ZINFOmainio.trino.connector.StaticCatalogManager-- Loading catalog memory --
2024-03-29 18:44:00 2024-03-29T16:44:00.981ZINFOmainorg.hibernate.validator.internal.util.VersionHV000001: Hibernate Validator 8.0.1.Final
2024-03-29 18:44:01 2024-03-29T16:44:01.207ZINFOmainBootstrapPROPERTY                              DEFAULT  RUNTIME  DESCRIPTION
2024-03-29 18:44:01 2024-03-29T16:44:01.209ZINFOmainBootstrapmemory.enable-lazy-dynamic-filtering  true     true
2024-03-29 18:44:01 2024-03-29T16:44:01.210ZINFOmainBootstrapmemory.max-data-per-node              128MB    128MB
2024-03-29 18:44:01 2024-03-29T16:44:01.210ZINFOmainBootstrapmemory.splits-per-node                8        8
2024-03-29 18:44:01 2024-03-29T16:44:01.303ZINFOmainio.trino.connector.StaticCatalogManager-- Added catalog memory using connector memory --
2024-03-29 18:44:01 2024-03-29T16:44:01.304ZINFOmainio.trino.connector.StaticCatalogManager-- Loading catalog tpcds --
2024-03-29 18:44:01 2024-03-29T16:44:01.387ZINFOmainorg.hibernate.validator.internal.util.VersionHV000001: Hibernate Validator 8.0.1.Final
2024-03-29 18:44:01 2024-03-29T16:44:01.532ZINFOmainBootstrapPROPERTY               DEFAULT  RUNTIME  DESCRIPTION
2024-03-29 18:44:01 2024-03-29T16:44:01.532ZINFOmainBootstraptpcds.split-count      ----     ----     Number of split to be created. If not specified the number of splits is computed as 'tpcds.splits-per-node * <number of active nodes>'
2024-03-29 18:44:01 2024-03-29T16:44:01.532ZINFOmainBootstraptpcds.splits-per-node  8        4
2024-03-29 18:44:01 2024-03-29T16:44:01.532ZINFOmainBootstraptpcds.with-no-sexism   false    false
2024-03-29 18:44:01 2024-03-29T16:44:01.674ZINFOmainio.trino.connector.StaticCatalogManager-- Added catalog tpcds using connector tpcds --
2024-03-29 18:44:01 2024-03-29T16:44:01.674ZINFOmainio.trino.connector.StaticCatalogManager-- Loading catalog gsheets --
2024-03-29 18:44:01 2024-03-29T16:44:01.727ZINFOmainorg.hibernate.validator.internal.util.VersionHV000001: Hibernate Validator 8.0.1.Final
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapPROPERTY                     DEFAULT     RUNTIME                                       DESCRIPTION
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.connection-timeout   20.00s      20.00s                                        Timeout when connection to Google Sheets API
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.credentials-path     ----        /app/credentials/credentials.json             Credential file path to google service account
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.credentials-key      [REDACTED]  [REDACTED]                                    The base64 encoded credentials key
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.metadata-sheet-id    ----        1Es4HhWALUQjoa-bQh4a8B5HROz7dpGMfq_HbfoaW5LM  Metadata sheet id containing table sheet mapping
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.read-timeout         20.00s      20.00s                                        Timeout when reading from Google Sheets API
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.data-cache-ttl       5.00m       5.00m                                         Sheets data expire after write duration
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.max-data-cache-size  1000        1000                                          Sheet data max cache size
2024-03-29 18:44:02 2024-03-29T16:44:02.047ZINFOmainBootstrapgsheets.write-timeout        20.00s      20.00s                                        Timeout when writing to Google Sheets API
2024-03-29 18:44:02 2024-03-29T16:44:02.427ZINFOmainio.trino.connector.StaticCatalogManager-- Added catalog gsheets using connector gsheets --
2024-03-29 18:44:02 2024-03-29T16:44:02.453ZINFOmainio.trino.security.AccessControlManagerUsing system access control: default
2024-03-29 18:44:02 2024-03-29T16:44:02.551ZINFOmainio.trino.server.ServerServer startup completed in 21.15s
2024-03-29 18:44:02 2024-03-29T16:44:02.551ZINFOmainio.trino.server.Server======== SERVER STARTED ========
2024-03-29 18:46:42 2024-03-29T16:46:42.100ZINFOdispatcher-query-3io.trino.event.QueryMonitorTIMELINE: Query 20240329_164641_00001_ikykj :: FAILED (SHEETS_UNKNOWN_TABLE_ERROR) :: elapsed 546ms :: planning 546ms :: waiting 0ms :: scheduling 0ms :: running 0ms :: finishing 0ms :: begin 2024-03-29T16:46:41.543Z :: end 2024-03-29T16:46:42.089Z
2024-03-29 18:46:48 2024-03-29T16:46:48.441ZINFOdispatcher-query-3io.trino.event.QueryMonitorTIMELINE: Query 20240329_164648_00002_ikykj :: FAILED (SHEETS_UNKNOWN_TABLE_ERROR) :: elapsed 152ms :: planning 152ms :: waiting 0ms :: scheduling 0ms :: running 0ms :: finishing 0ms :: begin 2024-03-29T16:46:48.284Z :: end 2024-03-29T16:46:48.436Z
2024-03-29 18:47:09 2024-03-29T16:47:09.230ZINFOdispatcher-query-2io.trino.event.QueryMonitorTIMELINE: Query 20240329_164706_00003_ikykj :: FAILED (SHEETS_UNKNOWN_TABLE_ERROR) :: elapsed 2413ms :: planning 389ms :: waiting 36ms :: scheduling 1754ms :: running 179ms :: finishing 91ms :: begin 2024-03-29T16:47:06.406Z :: end 2024-03-29T16:47:08.819Z
sotiriskar commented 6 months ago

queries used:

SELECT *
FROM
  TABLE(gsheets.system.sheet(
      id => '1Es4HhWALUQjoa-bQh4a8B5HROz7dpGMfq_HbfoaW5LM'));

and show tables from gsheets.default;

ebyhr commented 6 months ago

@sotiriskar Please share the stacktrace. The above log doesn't contain that. You can get it on query detailed page of webui.

sotiriskar commented 6 months ago

Ok so I checked the stacktrace and saw this: Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

So I guess the problem is that I need to configure Trino with my SSL certifications..I'll check the documentation, sorry for taking your time!