Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector #210

sudmed · 2023-04-14T18:42:04Z

sudmed
Apr 14, 2023

Hi,
i run the docker-compose yaml with sink connector lightweight, but it doesn't work. I get the error Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
tell me please what this error means?

docker-compose.yml

version: "3.4"

# Ubuntu , set this for redpanda to start
# https://sort.veritas.com/public/documents/HSO/2.0/linux/productguides/html/hfo_admin_ubuntu/ch04s03.htm

# Clickhouse Table Schema
# create table test(id int, message String) ENGINE=MergeTree() PRIMARY KEY id;

services:
  postgres:
    image: debezium/postgres:14
    ports:
      - 5432:5432
    healthcheck:
      test: "pg_isready -U root -d salary"
      interval: 2s
      timeout: 20s
      retries: 10
    environment:
      - POSTGRES_USER=root
      - POSTGRES_PASSWORD=root
      - POSTGRES_DB=salary

  clickhouse:
    # clickhouse-client --host=127.0.0.1 --port=9000 --user=root --password=root --database=test
    container_name: clickhouse
    image: clickhouse/clickhouse-server:latest
    restart: "no"
    ports:
      - "8123:8123"
      - "9000:9000"
    environment:
      - CLICKHOUSE_USER=root
      - CLICKHOUSE_PASSWORD=root
      - CLICKHOUSE_DB=test
      - CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=0
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    volumes:
      #- ../sql/init_ch.sql:/docker-entrypoint-initdb.d/init_clickhouse.sql
      - ../clickhouse/users.xml:/etc/clickhouse-server/users.xml
    depends_on:
      zookeeper:
        condition: service_healthy

  zookeeper:
      image: zookeeper:3.6.2
      expose:
        - "2181"
      environment:
        ZOO_TICK_TIME: 500
        ZOO_MY_ID: 1
      healthcheck:
        test: echo stat | nc localhost 2181
        interval: 3s
        timeout: 2s
        retries: 5
        start_period: 2s
      security_opt:
        - label:disable

  debezium-embedded:
    image: registry.gitlab.com/altinity-public/container-images/clickhouse_debezium_embedded:latest
    restart: "no"
    ports:
      - "8083:8083"
    env_file:
      - docker.env
    extra_hosts:
      - "host.docker.internal:host-gateway"

  #### MONITORING ####
  prometheus:
    container_name: prometheus
    image: bitnami/prometheus:2.36.0
    restart: "no"
    ports:
      - "9090:9090"
    volumes:
      - ./config/prometheus.yml:/opt/bitnami/prometheus/conf/prometheus.yml

  grafana:
    build:
      context: ./config/grafana
      args:
        GRAFANA_VERSION: 9.1.1
    #container_name: grafana
    #image: grafana/grafana
    restart: "no"
      #volumes:
      #  - ../config/grafana/dashboards:/etc/grafana/provisioning/dashboards
    ports:
      - "3000:3000"
    environment:
      - DS_PROMETHEUS=prometheus
      - GF_USERS_DEFAULT_THEME=light
      - GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=vertamedia-clickhouse-datasource
      - GF_INSTALL_PLUGINS=vertamedia-clickhouse-datasource
    depends_on:
      - prometheus
    ### END OF MONITORING ###

docker.env

export database.hostname="postgres"
export database.port="5432"
export database.user="root"
export database.password="root"
export snapshot.mode="schema_only"
export connector.class="io.debezium.connector.postgresql.PostgresConnector"
export plugin.name="pgoutput"
export table.include.list="public.tm"
export clickhouse.server.database="test"
export auto.create.tables=true
export replacingmergetree.delete.column="_sign"
export metrics.port=8083
export clickhouse.server.url="clickhouse"
export clickhouse.server.user="root"
export clickhouse.server.pass="root"
export clickhouse.server.port="8123"

docker compose logs

docker-zookeeper-1  | ZooKeeper JMX enabled by default
docker-zookeeper-1  | Using config: /conf/zoo.cfg
docker-zookeeper-1  | 2023-04-14 18:25:56,031 [myid:] - INFO  [main:QuorumPeerConfig@174] - Reading configuration from: /conf/zoo.cfg
docker-zookeeper-1  | 2023-04-14 18:25:56,084 [myid:] - INFO  [main:QuorumPeerConfig@451] - clientPort is not set
docker-zookeeper-1  | 2023-04-14 18:25:56,084 [myid:] - INFO  [main:QuorumPeerConfig@464] - secureClientPort is not set
docker-zookeeper-1  | 2023-04-14 18:25:56,085 [myid:] - INFO  [main:QuorumPeerConfig@480] - observerMasterPort is not set
docker-zookeeper-1  | 2023-04-14 18:25:56,098 [myid:] - INFO  [main:QuorumPeerConfig@497] - metricsProvider.className is org.apache.zookeeper.metrics.impl.DefaultMetricsProvider
docker-zookeeper-1  | 2023-04-14 18:25:56,169 [myid:] - ERROR [main:QuorumPeerConfig@722] - Invalid configuration, only one server specified (ignoring)
docker-zookeeper-1  | 2023-04-14 18:25:56,187 [myid:1] - INFO  [main:DatadirCleanupManager@78] - autopurge.snapRetainCount set to 3
docker-zookeeper-1  | 2023-04-14 18:25:56,187 [myid:1] - INFO  [main:DatadirCleanupManager@79] - autopurge.purgeInterval set to 0
docker-zookeeper-1  | 2023-04-14 18:25:56,188 [myid:1] - INFO  [main:DatadirCleanupManager@101] - Purge task is not scheduled.
docker-zookeeper-1  | 2023-04-14 18:25:56,188 [myid:1] - WARN  [main:QuorumPeerMain@138] - Either no config or no quorum defined in config, running in standalone mode
docker-zookeeper-1  | 2023-04-14 18:25:56,195 [myid:1] - INFO  [main:ManagedUtil@44] - Log4j 1.2 jmx support found and enabled.
docker-zookeeper-1  | 2023-04-14 18:25:56,220 [myid:1] - INFO  [main:QuorumPeerConfig@174] - Reading configuration from: /conf/zoo.cfg
docker-zookeeper-1  | 2023-04-14 18:25:56,224 [myid:1] - INFO  [main:QuorumPeerConfig@451] - clientPort is not set
docker-zookeeper-1  | 2023-04-14 18:25:56,225 [myid:1] - INFO  [main:QuorumPeerConfig@464] - secureClientPort is not set
docker-zookeeper-1  | 2023-04-14 18:25:56,225 [myid:1] - INFO  [main:QuorumPeerConfig@480] - observerMasterPort is not set
docker-zookeeper-1  | 2023-04-14 18:25:56,226 [myid:1] - INFO  [main:QuorumPeerConfig@497] - metricsProvider.className is org.apache.zookeeper.metrics.impl.DefaultMetricsProvider
docker-zookeeper-1  | 2023-04-14 18:25:56,232 [myid:1] - ERROR [main:QuorumPeerConfig@722] - Invalid configuration, only one server specified (ignoring)
docker-zookeeper-1  | 2023-04-14 18:25:56,233 [myid:1] - INFO  [main:ZooKeeperServerMain@122] - Starting server
docker-zookeeper-1  | 2023-04-14 18:25:56,311 [myid:1] - INFO  [main:ServerMetrics@62] - ServerMetrics initialized with provider org.apache.zookeeper.metrics.impl.DefaultMetricsProvider@4de5031f
docker-zookeeper-1  | 2023-04-14 18:25:56,319 [myid:1] - INFO  [main:FileTxnSnapLog@124] - zookeeper.snapshot.trust.empty : false
docker-zookeeper-1  | 2023-04-14 18:25:56,338 [myid:1] - INFO  [main:ZookeeperBanner@42] - 
docker-zookeeper-1  | 2023-04-14 18:25:56,340 [myid:1] - INFO  [main:ZookeeperBanner@42] -   ______                  _                                          
docker-zookeeper-1  | 2023-04-14 18:25:56,341 [myid:1] - INFO  [main:ZookeeperBanner@42] -  |___  /                 | |                                         
docker-zookeeper-1  | 2023-04-14 18:25:56,341 [myid:1] - INFO  [main:ZookeeperBanner@42] -     / /    ___     ___   | | __   ___    ___   _ __     ___   _ __   
docker-zookeeper-1  | 2023-04-14 18:25:56,341 [myid:1] - INFO  [main:ZookeeperBanner@42] -    / /    / _ \   / _ \  | |/ /  / _ \  / _ \ | '_ \   / _ \ | '__|
docker-zookeeper-1  | 2023-04-14 18:25:56,341 [myid:1] - INFO  [main:ZookeeperBanner@42] -   / /__  | (_) | | (_) | |   <  |  __/ |  __/ | |_) | |  __/ | |    
docker-zookeeper-1  | 2023-04-14 18:25:56,342 [myid:1] - INFO  [main:ZookeeperBanner@42] -  /_____|  \___/   \___/  |_|\_\  \___|  \___| | .__/   \___| |_|
docker-zookeeper-1  | 2023-04-14 18:25:56,343 [myid:1] - INFO  [main:ZookeeperBanner@42] -                                               | |                     
docker-zookeeper-1  | 2023-04-14 18:25:56,343 [myid:1] - INFO  [main:ZookeeperBanner@42] -                                               |_|                     
docker-zookeeper-1  | 2023-04-14 18:25:56,343 [myid:1] - INFO  [main:ZookeeperBanner@42] - 
docker-zookeeper-1  | 2023-04-14 18:25:56,345 [myid:1] - INFO  [main:Environment@98] - Server environment:zookeeper.version=3.6.2--803c7f1a12f85978cb049af5e4ef23bd8b688715, built on 09/04/2020 12:44 GMT
docker-zookeeper-1  | 2023-04-14 18:25:56,345 [myid:1] - INFO  [main:Environment@98] - Server environment:host.name=b99df65fbbec
docker-zookeeper-1  | 2023-04-14 18:25:56,345 [myid:1] - INFO  [main:Environment@98] - Server environment:java.version=11.0.11
docker-zookeeper-1  | 2023-04-14 18:25:56,345 [myid:1] - INFO  [main:Environment@98] - Server environment:java.vendor=Oracle Corporation
docker-zookeeper-1  | 2023-04-14 18:25:56,345 [myid:1] - INFO  [main:Environment@98] - Server environment:java.home=/usr/local/openjdk-11
docker-zookeeper-1  | 2023-04-14 18:25:56,346 [myid:1] - INFO  [main:Environment@98] - Server environment:java.class.path=/apache-zookeeper-3.6.2-bin/bin/../zookeeper-server/target/classes:/apache-zookeeper-3.6.2-bin/bin/../build/classes:/apache-zookeeper-3.6.2-bin/bin/../zookeeper-server/target/lib/*.jar:/apache-zookeeper-3.6.2-bin/bin/../build/lib/*.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/zookeeper-prometheus-metrics-3.6.2.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/zookeeper-jute-3.6.2.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/zookeeper-3.6.2.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/snappy-java-1.1.7.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/slf4j-log4j12-1.7.25.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/slf4j-api-1.7.25.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/simpleclient_servlet-0.6.0.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/simpleclient_hotspot-0.6.0.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/simpleclient_common-0.6.0.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/simpleclient-0.6.0.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-transport-native-unix-common-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-transport-native-epoll-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-transport-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-resolver-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-handler-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-common-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-codec-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/netty-buffer-4.1.50.Final.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/metrics-core-3.2.5.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/log4j-1.2.17.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/json-simple-1.1.1.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jline-2.14.6.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jetty-util-9.4.24.v20191120.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jetty-servlet-9.4.24.v20191120.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jetty-server-9.4.24.v20191120.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jetty-security-9.4.24.v20191120.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jetty-io-9.4.24.v20191120.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jetty-http-9.4.24.v20191120.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/javax.servlet-api-3.1.0.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jackson-databind-2.10.3.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jackson-core-2.10.3.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/jackson-annotations-2.10.3.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/commons-lang-2.6.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/commons-cli-1.2.jar:/apache-zookeeper-3.6.2-bin/bin/../lib/audience-annotations-0.5.0.jar:/apache-zookeeper-3.6.2-bin/bin/../zookeeper-*.jar:/apache-zookeeper-3.6.2-bin/bin/../zookeeper-server/src/main/resources/lib/*.jar:/conf:
docker-zookeeper-1  | 2023-04-14 18:25:56,346 [myid:1] - INFO  [main:Environment@98] - Server environment:java.library.path=/usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib
docker-zookeeper-1  | 2023-04-14 18:25:56,347 [myid:1] - INFO  [main:Environment@98] - Server environment:java.io.tmpdir=/tmp
docker-zookeeper-1  | 2023-04-14 18:25:56,348 [myid:1] - INFO  [main:Environment@98] - Server environment:java.compiler=<NA>
docker-zookeeper-1  | 2023-04-14 18:25:56,349 [myid:1] - INFO  [main:Environment@98] - Server environment:os.name=Linux
docker-zookeeper-1  | 2023-04-14 18:25:56,349 [myid:1] - INFO  [main:Environment@98] - Server environment:os.arch=amd64
docker-zookeeper-1  | 2023-04-14 18:25:56,349 [myid:1] - INFO  [main:Environment@98] - Server environment:os.version=5.4.0-42-generic
docker-zookeeper-1  | 2023-04-14 18:25:56,352 [myid:1] - INFO  [main:Environment@98] - Server environment:user.name=zookeeper
docker-zookeeper-1  | 2023-04-14 18:25:56,352 [myid:1] - INFO  [main:Environment@98] - Server environment:user.home=/home/zookeeper
docker-zookeeper-1  | 2023-04-14 18:25:56,352 [myid:1] - INFO  [main:Environment@98] - Server environment:user.dir=/apache-zookeeper-3.6.2-bin
docker-zookeeper-1  | 2023-04-14 18:25:56,353 [myid:1] - INFO  [main:Environment@98] - Server environment:os.memory.free=56MB
docker-zookeeper-1  | 2023-04-14 18:25:56,353 [myid:1] - INFO  [main:Environment@98] - Server environment:os.memory.max=1000MB
docker-zookeeper-1  | 2023-04-14 18:25:56,353 [myid:1] - INFO  [main:Environment@98] - Server environment:os.memory.total=64MB
docker-zookeeper-1  | 2023-04-14 18:25:56,353 [myid:1] - INFO  [main:ZooKeeperServer@129] - zookeeper.enableEagerACLCheck = false
docker-zookeeper-1  | 2023-04-14 18:25:56,353 [myid:1] - INFO  [main:ZooKeeperServer@137] - zookeeper.digest.enabled = true
docker-zookeeper-1  | 2023-04-14 18:25:56,354 [myid:1] - INFO  [main:ZooKeeperServer@141] - zookeeper.closeSessionTxn.enabled = true
docker-zookeeper-1  | 2023-04-14 18:25:56,354 [myid:1] - INFO  [main:ZooKeeperServer@1444] - zookeeper.flushDelay=0
docker-zookeeper-1  | 2023-04-14 18:25:56,354 [myid:1] - INFO  [main:ZooKeeperServer@1453] - zookeeper.maxWriteQueuePollTime=0
docker-zookeeper-1  | 2023-04-14 18:25:56,355 [myid:1] - INFO  [main:ZooKeeperServer@1462] - zookeeper.maxBatchSize=1000
docker-zookeeper-1  | 2023-04-14 18:25:56,355 [myid:1] - INFO  [main:ZooKeeperServer@243] - zookeeper.intBufferStartingSizeBytes = 1024
docker-zookeeper-1  | 2023-04-14 18:25:56,356 [myid:1] - INFO  [main:BlueThrottle@141] - Weighed connection throttling is disabled
docker-zookeeper-1  | 2023-04-14 18:25:56,358 [myid:1] - INFO  [main:ZooKeeperServer@1256] - minSessionTimeout set to 1000
docker-zookeeper-1  | 2023-04-14 18:25:56,358 [myid:1] - INFO  [main:ZooKeeperServer@1265] - maxSessionTimeout set to 10000
docker-zookeeper-1  | 2023-04-14 18:25:56,359 [myid:1] - INFO  [main:ResponseCache@45] - Response cache size is initialized with value 400.
docker-zookeeper-1  | 2023-04-14 18:25:56,360 [myid:1] - INFO  [main:ResponseCache@45] - Response cache size is initialized with value 400.
docker-zookeeper-1  | 2023-04-14 18:25:56,361 [myid:1] - INFO  [main:RequestPathMetricsCollector@111] - zookeeper.pathStats.slotCapacity = 60
docker-zookeeper-1  | 2023-04-14 18:25:56,361 [myid:1] - INFO  [main:RequestPathMetricsCollector@112] - zookeeper.pathStats.slotDuration = 15
docker-zookeeper-1  | 2023-04-14 18:25:56,361 [myid:1] - INFO  [main:RequestPathMetricsCollector@113] - zookeeper.pathStats.maxDepth = 6
docker-zookeeper-1  | 2023-04-14 18:25:56,362 [myid:1] - INFO  [main:RequestPathMetricsCollector@114] - zookeeper.pathStats.initialDelay = 5
docker-zookeeper-1  | 2023-04-14 18:25:56,362 [myid:1] - INFO  [main:RequestPathMetricsCollector@115] - zookeeper.pathStats.delay = 5
docker-zookeeper-1  | 2023-04-14 18:25:56,362 [myid:1] - INFO  [main:RequestPathMetricsCollector@116] - zookeeper.pathStats.enabled = false
docker-zookeeper-1  | 2023-04-14 18:25:56,368 [myid:1] - INFO  [main:ZooKeeperServer@1481] - The max bytes for all large requests are set to 104857600
docker-zookeeper-1  | 2023-04-14 18:25:56,369 [myid:1] - INFO  [main:ZooKeeperServer@1495] - The large request threshold is set to -1
docker-zookeeper-1  | 2023-04-14 18:25:56,369 [myid:1] - INFO  [main:ZooKeeperServer@339] - Created server with tickTime 500 minSessionTimeout 1000 maxSessionTimeout 10000 clientPortListenBacklog -1 datadir /datalog/version-2 snapdir /data/version-2
docker-zookeeper-1  | 2023-04-14 18:25:56,417 [myid:1] - INFO  [main:Log@169] - Logging initialized @2406ms to org.eclipse.jetty.util.log.Slf4jLog
docker-zookeeper-1  | 2023-04-14 18:25:56,608 [myid:1] - WARN  [main:ContextHandler@1520] - o.e.j.s.ServletContextHandler@5b7a5baa{/,null,UNAVAILABLE} contextPath ends with /*
docker-zookeeper-1  | 2023-04-14 18:25:56,611 [myid:1] - WARN  [main:ContextHandler@1531] - Empty contextPath
docker-zookeeper-1  | 2023-04-14 18:25:56,654 [myid:1] - INFO  [main:Server@359] - jetty-9.4.24.v20191120; built: 2019-11-20T21:37:49.771Z; git: 363d5f2df3a8a28de40604320230664b9c793c16; jvm 11.0.11+9
docker-zookeeper-1  | 2023-04-14 18:25:56,737 [myid:1] - INFO  [main:DefaultSessionIdManager@333] - DefaultSessionIdManager workerName=node0
docker-zookeeper-1  | 2023-04-14 18:25:56,737 [myid:1] - INFO  [main:DefaultSessionIdManager@338] - No SessionScavenger set, using defaults
docker-zookeeper-1  | 2023-04-14 18:25:56,741 [myid:1] - INFO  [main:HouseKeeper@140] - node0 Scavenging every 600000ms
docker-zookeeper-1  | 2023-04-14 18:25:56,744 [myid:1] - WARN  [main:ConstraintSecurityHandler@757] - [email protected]@5b7a5baa{/,null,STARTING} has uncovered http methods for path: /*
docker-zookeeper-1  | 2023-04-14 18:25:56,751 [myid:1] - INFO  [main:ContextHandler@825] - Started o.e.j.s.ServletContextHandler@5b7a5baa{/,null,AVAILABLE}
docker-zookeeper-1  | 2023-04-14 18:25:56,766 [myid:1] - INFO  [main:AbstractConnector@330] - Started ServerConnector@79924b{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
docker-zookeeper-1  | 2023-04-14 18:25:56,767 [myid:1] - INFO  [main:Server@399] - Started @2764ms
docker-zookeeper-1  | 2023-04-14 18:25:56,767 [myid:1] - INFO  [main:JettyAdminServer@182] - Started AdminServer on address 0.0.0.0, port 8080 and command URL /commands
docker-zookeeper-1  | 2023-04-14 18:25:56,799 [myid:1] - INFO  [main:ServerCnxnFactory@169] - Using org.apache.zookeeper.server.NIOServerCnxnFactory as server connection factory
docker-zookeeper-1  | 2023-04-14 18:25:56,808 [myid:1] - WARN  [main:ServerCnxnFactory@309] - maxCnxns is not configured, using default value 0.
docker-zookeeper-1  | 2023-04-14 18:25:56,810 [myid:1] - INFO  [main:NIOServerCnxnFactory@666] - Configuring NIO connection handler with 10s sessionless connection timeout, 1 selector thread(s), 4 worker threads, and 64 kB direct buffers.
docker-zookeeper-1  | 2023-04-14 18:25:56,813 [myid:1] - INFO  [main:NIOServerCnxnFactory@674] - binding to port /0.0.0.0:2181
docker-zookeeper-1  | 2023-04-14 18:25:56,848 [myid:1] - INFO  [main:WatchManagerFactory@42] - Using org.apache.zookeeper.server.watch.WatchManager as watch manager
docker-zookeeper-1  | 2023-04-14 18:25:56,849 [myid:1] - INFO  [main:WatchManagerFactory@42] - Using org.apache.zookeeper.server.watch.WatchManager as watch manager
docker-zookeeper-1  | 2023-04-14 18:25:56,852 [myid:1] - INFO  [main:ZKDatabase@132] - zookeeper.snapshotSizeFactor = 0.33
docker-zookeeper-1  | 2023-04-14 18:25:56,853 [myid:1] - INFO  [main:ZKDatabase@152] - zookeeper.commitLogCount=500
docker-zookeeper-1  | 2023-04-14 18:25:56,873 [myid:1] - INFO  [main:SnapStream@61] - zookeeper.snapshot.compression.method = CHECKED
docker-zookeeper-1  | 2023-04-14 18:25:56,874 [myid:1] - INFO  [main:FileTxnSnapLog@470] - Snapshotting: 0x0 to /data/version-2/snapshot.0
docker-zookeeper-1  | 2023-04-14 18:25:56,883 [myid:1] - INFO  [main:ZKDatabase@289] - Snapshot loaded in 30 ms, highest zxid is 0x0, digest is 1371985504
docker-zookeeper-1  | 2023-04-14 18:25:56,892 [myid:1] - INFO  [main:FileTxnSnapLog@470] - Snapshotting: 0x0 to /data/version-2/snapshot.0
docker-zookeeper-1  | 2023-04-14 18:25:56,910 [myid:1] - INFO  [main:ZooKeeperServer@529] - Snapshot taken in 26 ms
docker-zookeeper-1  | 2023-04-14 18:25:56,943 [myid:1] - INFO  [main:RequestThrottler@74] - zookeeper.request_throttler.shutdownTimeout = 10000
docker-zookeeper-1  | 2023-04-14 18:25:56,947 [myid:1] - INFO  [ProcessThread(sid:0 cport:2181)::PrepRequestProcessor@136] - PrepRequestProcessor (sid:0) started, reconfigEnabled=false
docker-zookeeper-1  | 2023-04-14 18:25:57,044 [myid:1] - INFO  [main:ContainerManager@83] - Using checkIntervalMs=60000 maxPerMinute=10000 maxNeverUsedIntervalMs=0
docker-zookeeper-1  | 2023-04-14 18:25:57,048 [myid:1] - INFO  [main:ZKAuditProvider@42] - ZooKeeper audit is disabled.
docker-zookeeper-1  | 2023-04-14 18:25:57,089 [myid:1] - INFO  [NIOWorkerThread-1:FourLetterCommands@223] - The list of known four letter word commands is : [{1936881266=srvr, 1937006964=stat, 2003003491=wchc, 1685417328=dump, 1668445044=crst, 1936880500=srst, 1701738089=envi, 1668247142=conf, -720899=telnet close, 1751217000=hash, 2003003507=wchs, 2003003504=wchp, 1684632179=dirs, 1668247155=cons, 1835955314=mntr, 1769173615=isro, 1920298859=ruok, 1735683435=gtmk, 1937010027=stmk}]
docker-zookeeper-1  | 2023-04-14 18:25:57,099 [myid:1] - INFO  [NIOWorkerThread-1:FourLetterCommands@224] - The list of enabled four letter word commands is : [[srvr]]
clickhouse          | /entrypoint.sh: create new user 'root' instead 'default'
clickhouse          | Processing configuration file '/etc/clickhouse-server/config.xml'.
clickhouse          | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
clickhouse          | Logging trace to /var/log/clickhouse-server/clickhouse-server.log
clickhouse          | Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
clickhouse          | Processing configuration file '/etc/clickhouse-server/config.xml'.
clickhouse          | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
clickhouse          | Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
clickhouse          | Processing configuration file '/etc/clickhouse-server/users.xml'.
clickhouse          | Merging configuration file '/etc/clickhouse-server/users.d/default-user.xml'.
clickhouse          | Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
clickhouse          | 
clickhouse          | /entrypoint.sh: create database 'test'
clickhouse          | Processing configuration file '/etc/clickhouse-server/config.xml'.
clickhouse          | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
clickhouse          | Logging trace to /var/log/clickhouse-server/clickhouse-server.log
clickhouse          | Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
clickhouse          | Processing configuration file '/etc/clickhouse-server/config.xml'.
clickhouse          | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
clickhouse          | Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
clickhouse          | Processing configuration file '/etc/clickhouse-server/users.xml'.
clickhouse          | Merging configuration file '/etc/clickhouse-server/users.d/default-user.xml'.
clickhouse          | Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
docker-debezium-embedded-1  | 0 [main] INFO com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedApplication  - Loading properties
docker-debezium-embedded-1  | 126 [main] INFO com.altinity.clickhouse.sink.connector.ClickHouseSinkConnectorConfig  - ClickHouseSinkConnectorConfig values: 
docker-debezium-embedded-1  | 	auto.create.tables = true
docker-debezium-embedded-1  | 	buffer.count = 100
docker-debezium-embedded-1  | 	buffer.flush.time.ms = 30
docker-debezium-embedded-1  | 	buffer.flush.timeout.ms = 1000
docker-debezium-embedded-1  | 	buffer.max.records = 100000
docker-debezium-embedded-1  | 	clickhouse.server.database = test
docker-debezium-embedded-1  | 	clickhouse.server.pass = root
docker-debezium-embedded-1  | 	clickhouse.server.port = 8123
docker-debezium-embedded-1  | 	clickhouse.server.url = clickhouse
docker-debezium-embedded-1  | 	clickhouse.server.user = root
docker-debezium-embedded-1  | 	clickhouse.topic2table.map = 
docker-debezium-embedded-1  | 	deduplication.policy = OFF
docker-debezium-embedded-1  | 	enable.kafka.offset = false
docker-debezium-embedded-1  | 	kafka.offset.metadata.table = topic_offset_metadata
docker-debezium-embedded-1  | 	metrics.enable = true
docker-debezium-embedded-1  | 	metrics.port = 8083
docker-debezium-embedded-1  | 	provider = UNKNOWN
docker-debezium-embedded-1  | 	replacingmergetree.delete.column = _sign
docker-debezium-embedded-1  | 	schema.evolution = false
docker-debezium-embedded-1  | 	snowflake.id = true
docker-debezium-embedded-1  | 	store.kafka.metadata = false
docker-debezium-embedded-1  | 	store.raw.data = false
docker-debezium-embedded-1  | 	store.raw.data.column = 
docker-debezium-embedded-1  | 	task_id = 0
docker-debezium-embedded-1  | 	thread.pool.size = 10
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 168 [main] INFO com.altinity.clickhouse.sink.connector.common.Metrics  - METRICS enabled: true
docker-debezium-embedded-1  | 194 [main] INFO com.altinity.clickhouse.sink.connector.common.Metrics  - METRICS server started, Port: 8083
docker-debezium-embedded-1  | 394 [main] DEBUG io.micrometer.core.util.internal.logging.InternalLoggerFactory  - Using SLF4J as the default logging framework
docker-debezium-embedded-1  | 1000 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 1621 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 1622 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 1669 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 1669 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 1686 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 1700 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:0
docker-debezium-embedded-1  | 11705 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 11706 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 11706 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 11707 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 11707 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 11707 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 11707 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:1
docker-debezium-embedded-1  | 21709 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 21710 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 21710 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 21711 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 21711 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 21711 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 21711 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:2
docker-debezium-embedded-1  | 31713 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 31713 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 31714 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 31715 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-postgres-1           | The files belonging to this database system will be owned by user "postgres".
docker-postgres-1           | This user must also own the server process.
docker-postgres-1           | 
docker-postgres-1           | The database cluster will be initialized with locale "en_US.utf8".
docker-postgres-1           | The default database encoding has accordingly been set to "UTF8".
docker-postgres-1           | The default text search configuration will be set to "english".
docker-postgres-1           | 
docker-postgres-1           | Data page checksums are disabled.
docker-postgres-1           | 
docker-postgres-1           | fixing permissions on existing directory /var/lib/postgresql/data ... ok
docker-postgres-1           | creating subdirectories ... ok
docker-postgres-1           | selecting dynamic shared memory implementation ... posix
docker-postgres-1           | selecting default max_connections ... 100
docker-postgres-1           | selecting default shared_buffers ... 128MB
docker-postgres-1           | selecting default time zone ... Etc/UTC
docker-postgres-1           | creating configuration files ... ok
docker-postgres-1           | running bootstrap script ... ok
docker-postgres-1           | performing post-bootstrap initialization ... ok
docker-postgres-1           | syncing data to disk ... ok
docker-postgres-1           | 
docker-postgres-1           | 
docker-postgres-1           | Success. You can now start the database server using:
docker-postgres-1           | 
docker-postgres-1           |     pg_ctl -D /var/lib/postgresql/data -l logfile start
docker-postgres-1           | 
docker-postgres-1           | initdb: warning: enabling "trust" authentication for local connections
docker-postgres-1           | You can change this by editing pg_hba.conf or using the option -A, or
docker-postgres-1           | --auth-local and --auth-host, the next time you run initdb.
docker-postgres-1           | waiting for server to start....2023-04-14 18:25:57.101 GMT [54] LOG:  starting PostgreSQL 14.7 (Debian 14.7-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
docker-postgres-1           | 2023-04-14 18:25:57.114 GMT [54] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
docker-postgres-1           | 2023-04-14 18:25:57.129 GMT [55] LOG:  database system was shut down at 2023-04-14 18:25:55 GMT
docker-postgres-1           | 2023-04-14 18:25:57.140 GMT [54] LOG:  database system is ready to accept connections
docker-postgres-1           |  done
docker-postgres-1           | server started
docker-postgres-1           | CREATE DATABASE
docker-postgres-1           | 
docker-postgres-1           | 
docker-postgres-1           | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/init-permissions.sh
docker-postgres-1           | 
docker-postgres-1           | 2023-04-14 18:25:58.227 GMT [54] LOG:  received fast shutdown request
docker-postgres-1           | waiting for server to shut down....2023-04-14 18:25:58.232 GMT [54] LOG:  aborting any active transactions
docker-postgres-1           | 2023-04-14 18:25:58.233 GMT [54] LOG:  background worker "logical replication launcher" (PID 61) exited with exit code 1
docker-postgres-1           | 2023-04-14 18:25:58.236 GMT [56] LOG:  shutting down
docker-postgres-1           | 2023-04-14 18:25:58.272 GMT [54] LOG:  database system is shut down
docker-postgres-1           |  done
docker-postgres-1           | server stopped
docker-postgres-1           | 
docker-postgres-1           | PostgreSQL init process complete; ready for start up.
docker-postgres-1           | 
docker-postgres-1           | 2023-04-14 18:25:58.401 GMT [1] LOG:  starting PostgreSQL 14.7 (Debian 14.7-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
docker-postgres-1           | 2023-04-14 18:25:58.410 GMT [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
docker-postgres-1           | 2023-04-14 18:25:58.410 GMT [1] LOG:  listening on IPv6 address "::", port 5432
docker-postgres-1           | 2023-04-14 18:25:58.419 GMT [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
docker-postgres-1           | 2023-04-14 18:25:58.431 GMT [69] LOG:  database system was shut down at 2023-04-14 18:25:58 GMT
docker-postgres-1           | 2023-04-14 18:25:58.440 GMT [1] LOG:  database system is ready to accept connections
docker-grafana-1            | ✔ Downloaded vertamedia-clickhouse-datasource v2.5.3 zip successfully
docker-grafana-1            | 
docker-grafana-1            | Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.
docker-grafana-1            | 
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861386541Z level=info msg="Starting Grafana" version=9.1.1 commit=9e60a1bff1 branch=HEAD compiled=2022-08-23T09:04:10Z
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.86170051Z level=info msg="Config loaded from" file=/usr/share/grafana/conf/defaults.ini
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.86174347Z level=info msg="Config loaded from" file=/etc/grafana/grafana.ini
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861763437Z level=info msg="Config overridden from command line" arg="default.paths.data=/var/lib/grafana"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861779556Z level=info msg="Config overridden from command line" arg="default.paths.logs=/var/log/grafana"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861796628Z level=info msg="Config overridden from command line" arg="default.paths.plugins=/var/lib/grafana/plugins"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861824279Z level=info msg="Config overridden from command line" arg="default.paths.provisioning=/etc/grafana/provisioning"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861848551Z level=info msg="Config overridden from command line" arg="default.log.mode=console"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.86186756Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_DATA=/var/lib/grafana"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861888303Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_LOGS=/var/log/grafana"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861925275Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_PLUGINS=/var/lib/grafana/plugins"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861965353Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.861990121Z level=info msg="Config overridden from Environment variable" var="GF_USERS_DEFAULT_THEME=light"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862010985Z level=info msg="Config overridden from Environment variable" var="GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=vertamedia-clickhouse-datasource"
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862038688Z level=info msg="Path Home" path=/usr/share/grafana
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862063848Z level=info msg="Path Data" path=/var/lib/grafana
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862215736Z level=info msg="Path Logs" path=/var/log/grafana
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862248076Z level=info msg="Path Plugins" path=/var/lib/grafana/plugins
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862263888Z level=info msg="Path Provisioning" path=/etc/grafana/provisioning
docker-grafana-1            | logger=settings t=2023-04-14T18:25:58.862279058Z level=info msg="App mode production"
docker-grafana-1            | logger=sqlstore t=2023-04-14T18:25:58.862474476Z level=info msg="Connecting to DB" dbtype=sqlite3
docker-grafana-1            | logger=sqlstore t=2023-04-14T18:25:58.8625265Z level=info msg="Creating SQLite database file" path=/var/lib/grafana/grafana.db
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.864828518Z level=info msg="Starting DB migrations"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.865028631Z level=info msg="Executing migration" id="create migration_log table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.881103254Z level=info msg="Executing migration" id="create user table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.897054273Z level=info msg="Executing migration" id="add unique index user.login"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.907718994Z level=info msg="Executing migration" id="add unique index user.email"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.923704714Z level=info msg="Executing migration" id="drop index UQE_user_login - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.933854276Z level=info msg="Executing migration" id="drop index UQE_user_email - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.94117172Z level=info msg="Executing migration" id="Rename table user to user_v1 - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.948287423Z level=info msg="Executing migration" id="create user table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.955329417Z level=info msg="Executing migration" id="create index UQE_user_login - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.962247763Z level=info msg="Executing migration" id="create index UQE_user_email - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.969544752Z level=info msg="Executing migration" id="copy data_source v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.978942775Z level=info msg="Executing migration" id="Drop old table user_v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.985972042Z level=info msg="Executing migration" id="Add column help_flags1 to user table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.993129089Z level=info msg="Executing migration" id="Update user table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:58.999559251Z level=info msg="Executing migration" id="Add last_seen_at column to user"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.004884789Z level=info msg="Executing migration" id="Add missing user data"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.01198346Z level=info msg="Executing migration" id="Add is_disabled column to user"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.017480455Z level=info msg="Executing migration" id="Add index user.login/user.email"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.027002002Z level=info msg="Executing migration" id="Add is_service_account column to user"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.039747891Z level=info msg="Executing migration" id="Update is_service_account column to nullable"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.050951893Z level=info msg="Executing migration" id="create temp user table v1-7"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.064747091Z level=info msg="Executing migration" id="create index IDX_temp_user_email - v1-7"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.078603145Z level=info msg="Executing migration" id="create index IDX_temp_user_org_id - v1-7"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.097780887Z level=info msg="Executing migration" id="create index IDX_temp_user_code - v1-7"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.114903869Z level=info msg="Executing migration" id="create index IDX_temp_user_status - v1-7"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.13359626Z level=info msg="Executing migration" id="Update temp_user table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.152881958Z level=info msg="Executing migration" id="drop index IDX_temp_user_email - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.170726572Z level=info msg="Executing migration" id="drop index IDX_temp_user_org_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.191232498Z level=info msg="Executing migration" id="drop index IDX_temp_user_code - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.211572119Z level=info msg="Executing migration" id="drop index IDX_temp_user_status - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.23095779Z level=info msg="Executing migration" id="Rename table temp_user to temp_user_tmp_qwerty - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.246846899Z level=info msg="Executing migration" id="create temp_user v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.281464441Z level=info msg="Executing migration" id="create index IDX_temp_user_email - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.292045187Z level=info msg="Executing migration" id="create index IDX_temp_user_org_id - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.312639211Z level=info msg="Executing migration" id="create index IDX_temp_user_code - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.32902514Z level=info msg="Executing migration" id="create index IDX_temp_user_status - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.35518631Z level=info msg="Executing migration" id="copy temp_user v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.365535536Z level=info msg="Executing migration" id="drop temp_user_tmp_qwerty"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.381196661Z level=info msg="Executing migration" id="Set created for temp users that will otherwise prematurely expire"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.396563548Z level=info msg="Executing migration" id="create star table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.414908821Z level=info msg="Executing migration" id="add unique index star.user_id_dashboard_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.433369292Z level=info msg="Executing migration" id="create org table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.450741342Z level=info msg="Executing migration" id="create index UQE_org_name - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.4692913Z level=info msg="Executing migration" id="create org_user table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.487677507Z level=info msg="Executing migration" id="create index IDX_org_user_org_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.504969648Z level=info msg="Executing migration" id="create index UQE_org_user_org_id_user_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.519415262Z level=info msg="Executing migration" id="create index IDX_org_user_user_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.536385639Z level=info msg="Executing migration" id="Update org table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.551110762Z level=info msg="Executing migration" id="Update org_user table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.570536919Z level=info msg="Executing migration" id="Migrate all Read Only Viewers to Viewers"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.582931153Z level=info msg="Executing migration" id="create dashboard table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.640525065Z level=info msg="Executing migration" id="add index dashboard.account_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.648633359Z level=info msg="Executing migration" id="add unique index dashboard_account_id_slug"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.656909661Z level=info msg="Executing migration" id="create dashboard_tag table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.664918619Z level=info msg="Executing migration" id="add unique index dashboard_tag.dasboard_id_term"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.672646075Z level=info msg="Executing migration" id="drop index UQE_dashboard_tag_dashboard_id_term - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.698943286Z level=info msg="Executing migration" id="Rename table dashboard to dashboard_v1 - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.720907337Z level=info msg="Executing migration" id="create dashboard v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.743123605Z level=info msg="Executing migration" id="create index IDX_dashboard_org_id - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.77102214Z level=info msg="Executing migration" id="create index UQE_dashboard_org_id_slug - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.792718041Z level=info msg="Executing migration" id="copy dashboard v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.81096892Z level=info msg="Executing migration" id="drop table dashboard_v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.835356311Z level=info msg="Executing migration" id="alter dashboard.data to mediumtext v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.851185469Z level=info msg="Executing migration" id="Add column updated_by in dashboard - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.873537146Z level=info msg="Executing migration" id="Add column created_by in dashboard - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.890991064Z level=info msg="Executing migration" id="Add column gnetId in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.9093759Z level=info msg="Executing migration" id="Add index for gnetId in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.931111243Z level=info msg="Executing migration" id="Add column plugin_id in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.949351651Z level=info msg="Executing migration" id="Add index for plugin_id in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.968960007Z level=info msg="Executing migration" id="Add index for dashboard_id in dashboard_tag"
docker-grafana-1            | logger=migrator t=2023-04-14T18:25:59.989589848Z level=info msg="Executing migration" id="Update dashboard table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.005050213Z level=info msg="Executing migration" id="Update dashboard_tag table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.024110072Z level=info msg="Executing migration" id="Add column folder_id in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.041053992Z level=info msg="Executing migration" id="Add column isFolder in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.059469438Z level=info msg="Executing migration" id="Add column has_acl in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.077022794Z level=info msg="Executing migration" id="Add column uid in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.096016254Z level=info msg="Executing migration" id="Update uid column values in dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.113104481Z level=info msg="Executing migration" id="Add unique index dashboard_org_id_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.131261711Z level=info msg="Executing migration" id="Remove unique index org_id_slug"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.150539503Z level=info msg="Executing migration" id="Update dashboard title length"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.169649303Z level=info msg="Executing migration" id="Add unique index for dashboard_org_id_title_folder_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.189856392Z level=info msg="Executing migration" id="create dashboard_provisioning"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.208787886Z level=info msg="Executing migration" id="Rename table dashboard_provisioning to dashboard_provisioning_tmp_qwerty - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.238835097Z level=info msg="Executing migration" id="create dashboard_provisioning v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.258800878Z level=info msg="Executing migration" id="create index IDX_dashboard_provisioning_dashboard_id - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.284866301Z level=info msg="Executing migration" id="create index IDX_dashboard_provisioning_dashboard_id_name - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.304909722Z level=info msg="Executing migration" id="copy dashboard_provisioning v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.321138921Z level=info msg="Executing migration" id="drop dashboard_provisioning_tmp_qwerty"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.341196753Z level=info msg="Executing migration" id="Add check_sum column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.359319422Z level=info msg="Executing migration" id="Add index for dashboard_title"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.378822226Z level=info msg="Executing migration" id="delete tags for deleted dashboards"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.395479073Z level=info msg="Executing migration" id="delete stars for deleted dashboards"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.411714171Z level=info msg="Executing migration" id="Add index for dashboard_is_folder"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.430599735Z level=info msg="Executing migration" id="Add isPublic for dashboard"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.448981365Z level=info msg="Executing migration" id="create data_source table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.471108673Z level=info msg="Executing migration" id="add index data_source.account_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.4874504Z level=info msg="Executing migration" id="add unique index data_source.account_id_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.504848911Z level=info msg="Executing migration" id="drop index IDX_data_source_account_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.523179875Z level=info msg="Executing migration" id="drop index UQE_data_source_account_id_name - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.540760947Z level=info msg="Executing migration" id="Rename table data_source to data_source_v1 - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.559096145Z level=info msg="Executing migration" id="create data_source table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.576740451Z level=info msg="Executing migration" id="create index IDX_data_source_org_id - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.595196117Z level=info msg="Executing migration" id="create index UQE_data_source_org_id_name - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.614662735Z level=info msg="Executing migration" id="Drop old table data_source_v1 #2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.635396933Z level=info msg="Executing migration" id="Add column with_credentials"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.652829774Z level=info msg="Executing migration" id="Add secure json data column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.671224523Z level=info msg="Executing migration" id="Update data_source table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.687680941Z level=info msg="Executing migration" id="Update initial version to 1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.702884875Z level=info msg="Executing migration" id="Add read_only data column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.72178106Z level=info msg="Executing migration" id="Migrate logging ds to loki ds"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.736755146Z level=info msg="Executing migration" id="Update json_data with nulls"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.753444755Z level=info msg="Executing migration" id="Add uid column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.770977487Z level=info msg="Executing migration" id="Update uid value"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.787510558Z level=info msg="Executing migration" id="Add unique index datasource_org_id_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.807216983Z level=info msg="Executing migration" id="add unique index datasource_org_id_is_default"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.826961881Z level=info msg="Executing migration" id="create api_key table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.849509716Z level=info msg="Executing migration" id="add index api_key.account_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.869207449Z level=info msg="Executing migration" id="add index api_key.key"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.888811662Z level=info msg="Executing migration" id="add index api_key.account_id_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.912424285Z level=info msg="Executing migration" id="drop index IDX_api_key_account_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.930759885Z level=info msg="Executing migration" id="drop index UQE_api_key_key - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.951263616Z level=info msg="Executing migration" id="drop index UQE_api_key_account_id_name - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.971076362Z level=info msg="Executing migration" id="Rename table api_key to api_key_v1 - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:00.988995283Z level=info msg="Executing migration" id="create api_key table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.0151462Z level=info msg="Executing migration" id="create index IDX_api_key_org_id - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.022104406Z level=info msg="Executing migration" id="create index UQE_api_key_key - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.038788257Z level=info msg="Executing migration" id="create index UQE_api_key_org_id_name - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.064513013Z level=info msg="Executing migration" id="copy api_key v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.08296843Z level=info msg="Executing migration" id="Drop old table api_key_v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.107583339Z level=info msg="Executing migration" id="Update api_key table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.133684444Z level=info msg="Executing migration" id="Add expires to api_key table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.143319025Z level=info msg="Executing migration" id="Add service account foreign key"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.156471971Z level=info msg="Executing migration" id="set service account foreign key to nil if 0"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.172961556Z level=info msg="Executing migration" id="Add last_used_at to api_key table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.189342013Z level=info msg="Executing migration" id="create dashboard_snapshot table v4"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.206782117Z level=info msg="Executing migration" id="drop table dashboard_snapshot_v4 #1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.225254454Z level=info msg="Executing migration" id="create dashboard_snapshot table v5 #2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.242655246Z level=info msg="Executing migration" id="create index UQE_dashboard_snapshot_key - v5"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.261208437Z level=info msg="Executing migration" id="create index UQE_dashboard_snapshot_delete_key - v5"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.278691334Z level=info msg="Executing migration" id="create index IDX_dashboard_snapshot_user_id - v5"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.29712401Z level=info msg="Executing migration" id="alter dashboard_snapshot to mediumtext v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.312737482Z level=info msg="Executing migration" id="Update dashboard_snapshot table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.329016181Z level=info msg="Executing migration" id="Add column external_delete_url to dashboard_snapshots table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.345358765Z level=info msg="Executing migration" id="Add encrypted dashboard json column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.360818666Z level=info msg="Executing migration" id="Change dashboard_encrypted column to MEDIUMBLOB"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.377336669Z level=info msg="Executing migration" id="create quota table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.394661174Z level=info msg="Executing migration" id="create index UQE_quota_org_id_user_id_target - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.41309452Z level=info msg="Executing migration" id="Update quota table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.426496307Z level=info msg="Executing migration" id="create plugin_setting table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.445003589Z level=info msg="Executing migration" id="create index UQE_plugin_setting_org_id_plugin_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.464434384Z level=info msg="Executing migration" id="Add column plugin_version to plugin_settings"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.482880871Z level=info msg="Executing migration" id="Update plugin_setting table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.498494695Z level=info msg="Executing migration" id="create session table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.522649396Z level=info msg="Executing migration" id="Drop old table playlist table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.538883739Z level=info msg="Executing migration" id="Drop old table playlist_item table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.554541243Z level=info msg="Executing migration" id="create playlist table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.574656685Z level=info msg="Executing migration" id="create playlist item table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.595188048Z level=info msg="Executing migration" id="Update playlist table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.610572184Z level=info msg="Executing migration" id="Update playlist_item table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.626941332Z level=info msg="Executing migration" id="drop preferences table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.6426777Z level=info msg="Executing migration" id="drop preferences table v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.6588866Z level=info msg="Executing migration" id="create preferences table v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.678382586Z level=info msg="Executing migration" id="Update preferences table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.694946865Z level=info msg="Executing migration" id="Add column team_id in preferences"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.713369842Z level=info msg="Executing migration" id="Update team_id column values in preferences"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.728632684Z level=info msg="Executing migration" id="Add column week_start in preferences"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.747170791Z level=info msg="Executing migration" id="Add column preferences.json_data"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.764592459Z level=info msg="Executing migration" id="alter preferences.json_data to mediumtext v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.781002707Z level=info msg="Executing migration" id="create alert table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.810703633Z level=info msg="Executing migration" id="add index alert org_id & id "
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.836328232Z level=info msg="Executing migration" id="add index alert state"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.862957711Z level=info msg="Executing migration" id="add index alert dashboard_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.886619674Z level=info msg="Executing migration" id="Create alert_rule_tag table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.909315233Z level=info msg="Executing migration" id="Add unique index alert_rule_tag.alert_id_tag_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.92688061Z level=info msg="Executing migration" id="drop index UQE_alert_rule_tag_alert_id_tag_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.945141498Z level=info msg="Executing migration" id="Rename table alert_rule_tag to alert_rule_tag_v1 - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.962532057Z level=info msg="Executing migration" id="Create alert_rule_tag table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:01.987399452Z level=info msg="Executing migration" id="create index UQE_alert_rule_tag_alert_id_tag_id - Add unique index alert_rule_tag.alert_id_tag_id V2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.006907271Z level=info msg="Executing migration" id="copy alert_rule_tag v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.022658297Z level=info msg="Executing migration" id="drop table alert_rule_tag_v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.03866293Z level=info msg="Executing migration" id="create alert_notification table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.05579286Z level=info msg="Executing migration" id="Add column is_default"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.076968465Z level=info msg="Executing migration" id="Add column frequency"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.095367763Z level=info msg="Executing migration" id="Add column send_reminder"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.113146342Z level=info msg="Executing migration" id="Add column disable_resolve_message"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.131241361Z level=info msg="Executing migration" id="add index alert_notification org_id & name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.151059104Z level=info msg="Executing migration" id="Update alert table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.178794835Z level=info msg="Executing migration" id="Update alert_notification table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.187962717Z level=info msg="Executing migration" id="create notification_journal table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.206471265Z level=info msg="Executing migration" id="add index notification_journal org_id & alert_id & notifier_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.223169378Z level=info msg="Executing migration" id="drop alert_notification_journal"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.242848901Z level=info msg="Executing migration" id="create alert_notification_state table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.263358622Z level=info msg="Executing migration" id="add index alert_notification_state org_id & alert_id & notifier_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.282809878Z level=info msg="Executing migration" id="Add for to alert table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.305213568Z level=info msg="Executing migration" id="Add column uid in alert_notification"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.327115659Z level=info msg="Executing migration" id="Update uid column values in alert_notification"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.343076581Z level=info msg="Executing migration" id="Add unique index alert_notification_org_id_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.367754468Z level=info msg="Executing migration" id="Remove unique index org_id_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.39163121Z level=info msg="Executing migration" id="Add column secure_settings in alert_notification"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.408926397Z level=info msg="Executing migration" id="alter alert.settings to mediumtext"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.428763751Z level=info msg="Executing migration" id="Add non-unique index alert_notification_state_alert_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.449277114Z level=info msg="Executing migration" id="Add non-unique index alert_rule_tag_alert_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.472248256Z level=info msg="Executing migration" id="Drop old annotation table v4"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.485610336Z level=info msg="Executing migration" id="create annotation table v5"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.508738787Z level=info msg="Executing migration" id="add index annotation 0 v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.528982689Z level=info msg="Executing migration" id="add index annotation 1 v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.548848053Z level=info msg="Executing migration" id="add index annotation 2 v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.569027971Z level=info msg="Executing migration" id="add index annotation 3 v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.588763397Z level=info msg="Executing migration" id="add index annotation 4 v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.608982213Z level=info msg="Executing migration" id="Update annotation table charset"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.624817071Z level=info msg="Executing migration" id="Add column region_id to annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.643182994Z level=info msg="Executing migration" id="Drop category_id index"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.662841001Z level=info msg="Executing migration" id="Add column tags to annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.681451444Z level=info msg="Executing migration" id="Create annotation_tag table v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.700887605Z level=info msg="Executing migration" id="Add unique index annotation_tag.annotation_id_tag_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.721274939Z level=info msg="Executing migration" id="drop index UQE_annotation_tag_annotation_id_tag_id - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.740681234Z level=info msg="Executing migration" id="Rename table annotation_tag to annotation_tag_v2 - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.759332901Z level=info msg="Executing migration" id="Create annotation_tag table v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.779186543Z level=info msg="Executing migration" id="create index UQE_annotation_tag_annotation_id_tag_id - Add unique index annotation_tag.annotation_id_tag_id V3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.795131175Z level=info msg="Executing migration" id="copy annotation_tag v2 to v3"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.810790411Z level=info msg="Executing migration" id="drop table annotation_tag_v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.831359169Z level=info msg="Executing migration" id="Update alert annotations and set TEXT to empty"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.846940523Z level=info msg="Executing migration" id="Add created time to annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.864881338Z level=info msg="Executing migration" id="Add updated time to annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.883281717Z level=info msg="Executing migration" id="Add index for created in annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.903012334Z level=info msg="Executing migration" id="Add index for updated in annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.925263745Z level=info msg="Executing migration" id="Convert existing annotations from seconds to milliseconds"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.941703529Z level=info msg="Executing migration" id="Add epoch_end column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.959102691Z level=info msg="Executing migration" id="Add index for epoch_end"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.982800626Z level=info msg="Executing migration" id="Make epoch_end the same as epoch"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:02.999231999Z level=info msg="Executing migration" id="Move region to single row"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.015693969Z level=info msg="Executing migration" id="Remove index org_id_epoch from annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.035057737Z level=info msg="Executing migration" id="Remove index org_id_dashboard_id_panel_id_epoch from annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.055131163Z level=info msg="Executing migration" id="Add index for org_id_dashboard_id_epoch_end_epoch on annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.074990564Z level=info msg="Executing migration" id="Add index for org_id_epoch_end_epoch on annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.095196979Z level=info msg="Executing migration" id="Remove index org_id_epoch_epoch_end from annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.113266868Z level=info msg="Executing migration" id="Add index for alert_id on annotation table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.131279031Z level=info msg="Executing migration" id="create test_data table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.14916382Z level=info msg="Executing migration" id="create dashboard_version table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.172761879Z level=info msg="Executing migration" id="add index dashboard_version.dashboard_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.1933044Z level=info msg="Executing migration" id="add unique index dashboard_version.dashboard_id and dashboard_version.version"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.21540423Z level=info msg="Executing migration" id="Set dashboard version to 1 where 0"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.229313804Z level=info msg="Executing migration" id="save existing dashboard data in dashboard_version table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.245616122Z level=info msg="Executing migration" id="alter dashboard_version.data to mediumtext v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.264790486Z level=info msg="Executing migration" id="create team table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.285007701Z level=info msg="Executing migration" id="add index team.org_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.30479003Z level=info msg="Executing migration" id="add unique index team_org_id_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.32696682Z level=info msg="Executing migration" id="create team member table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.348932831Z level=info msg="Executing migration" id="add index team_member.org_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.36922029Z level=info msg="Executing migration" id="add unique index team_member_org_id_team_id_user_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.393117785Z level=info msg="Executing migration" id="add index team_member.team_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.412789739Z level=info msg="Executing migration" id="Add column email to team table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.430992569Z level=info msg="Executing migration" id="Add column external to team_member table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.449223309Z level=info msg="Executing migration" id="Add column permission to team_member table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.467006173Z level=info msg="Executing migration" id="create dashboard acl table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.487136666Z level=info msg="Executing migration" id="add index dashboard_acl_dashboard_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.510728717Z level=info msg="Executing migration" id="add unique index dashboard_acl_dashboard_id_user_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.531033459Z level=info msg="Executing migration" id="add unique index dashboard_acl_dashboard_id_team_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.551002586Z level=info msg="Executing migration" id="add index dashboard_acl_user_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.575355223Z level=info msg="Executing migration" id="add index dashboard_acl_team_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.593808581Z level=info msg="Executing migration" id="add index dashboard_acl_org_id_role"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.61334966Z level=info msg="Executing migration" id="add index dashboard_permission"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.633260568Z level=info msg="Executing migration" id="save default acl rules in dashboard_acl table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.653404162Z level=info msg="Executing migration" id="delete acl rules for deleted dashboards and folders"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.667128607Z level=info msg="Executing migration" id="create tag table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.68525238Z level=info msg="Executing migration" id="add index tag.key_value"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.704948415Z level=info msg="Executing migration" id="create login attempt table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.725219398Z level=info msg="Executing migration" id="add index login_attempt.username"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.745177915Z level=info msg="Executing migration" id="drop index IDX_login_attempt_username - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.767231207Z level=info msg="Executing migration" id="Rename table login_attempt to login_attempt_tmp_qwerty - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.783577406Z level=info msg="Executing migration" id="create login_attempt v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.802921768Z level=info msg="Executing migration" id="create index IDX_login_attempt_username - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.822861475Z level=info msg="Executing migration" id="copy login_attempt v1 to v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.838851258Z level=info msg="Executing migration" id="drop login_attempt_tmp_qwerty"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.859324819Z level=info msg="Executing migration" id="create user auth table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.878848861Z level=info msg="Executing migration" id="create index IDX_user_auth_auth_module_auth_id - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.899374654Z level=info msg="Executing migration" id="alter user_auth.auth_id to length 190"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.914720158Z level=info msg="Executing migration" id="Add OAuth access token to user_auth"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.933000107Z level=info msg="Executing migration" id="Add OAuth refresh token to user_auth"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.950603889Z level=info msg="Executing migration" id="Add OAuth token type to user_auth"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.968929053Z level=info msg="Executing migration" id="Add OAuth expiry to user_auth"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:03.987257278Z level=info msg="Executing migration" id="Add index to user_id column in user_auth"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.006960848Z level=info msg="Executing migration" id="Add OAuth ID token to user_auth"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.024725315Z level=info msg="Executing migration" id="create server_lock table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.044980303Z level=info msg="Executing migration" id="add index server_lock.operation_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.064996954Z level=info msg="Executing migration" id="create user auth token table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.089149773Z level=info msg="Executing migration" id="add unique index user_auth_token.auth_token"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.104780457Z level=info msg="Executing migration" id="add unique index user_auth_token.prev_auth_token"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.123010362Z level=info msg="Executing migration" id="add index user_auth_token.user_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.14254496Z level=info msg="Executing migration" id="Add revoked_at to the user auth token"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.160804775Z level=info msg="Executing migration" id="create cache_data table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.180771936Z level=info msg="Executing migration" id="add unique index cache_data.cache_key"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.200805466Z level=info msg="Executing migration" id="create short_url table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.224898557Z level=info msg="Executing migration" id="add index short_url.org_id-uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.24705026Z level=info msg="Executing migration" id="delete alert_definition table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.261516094Z level=info msg="Executing migration" id="recreate alert_definition table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.285254805Z level=info msg="Executing migration" id="add index in alert_definition on org_id and title columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.303365369Z level=info msg="Executing migration" id="add index in alert_definition on org_id and uid columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.323392939Z level=info msg="Executing migration" id="alter alert_definition table data column to mediumtext in mysql"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.342636256Z level=info msg="Executing migration" id="drop index in alert_definition on org_id and title columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.356936754Z level=info msg="Executing migration" id="drop index in alert_definition on org_id and uid columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.374689212Z level=info msg="Executing migration" id="add unique index in alert_definition on org_id and title columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.393173783Z level=info msg="Executing migration" id="add unique index in alert_definition on org_id and uid columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.411558914Z level=info msg="Executing migration" id="Add column paused in alert_definition"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.428690173Z level=info msg="Executing migration" id="drop alert_definition table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.447277487Z level=info msg="Executing migration" id="delete alert_definition_version table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.462749978Z level=info msg="Executing migration" id="recreate alert_definition_version table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.483129527Z level=info msg="Executing migration" id="add index in alert_definition_version table on alert_definition_id and version columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.497594538Z level=info msg="Executing migration" id="add index in alert_definition_version table on alert_definition_uid and version columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.514845879Z level=info msg="Executing migration" id="alter alert_definition_version table data column to mediumtext in mysql"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.531324593Z level=info msg="Executing migration" id="drop alert_definition_version table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.547507802Z level=info msg="Executing migration" id="create alert_instance table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.562670013Z level=info msg="Executing migration" id="add index in alert_instance table on def_org_id, def_uid and current_state columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.582155963Z level=info msg="Executing migration" id="add index in alert_instance table on def_org_id, current_state columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.600638298Z level=info msg="Executing migration" id="add column current_state_end to alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.618963363Z level=info msg="Executing migration" id="remove index def_org_id, def_uid, current_state on alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.63681698Z level=info msg="Executing migration" id="remove index def_org_id, current_state on alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.65490087Z level=info msg="Executing migration" id="rename def_org_id to rule_org_id in alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.672408027Z level=info msg="Executing migration" id="rename def_uid to rule_uid in alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.69079694Z level=info msg="Executing migration" id="add index rule_org_id, rule_uid, current_state on alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.709340275Z level=info msg="Executing migration" id="add index rule_org_id, current_state on alert_instance"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.7267345Z level=info msg="Executing migration" id="add current_reason column related to current_state"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.745258843Z level=info msg="Executing migration" id="create alert_rule table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.764473898Z level=info msg="Executing migration" id="add index in alert_rule on org_id and title columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.78501985Z level=info msg="Executing migration" id="add index in alert_rule on org_id and uid columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.804580055Z level=info msg="Executing migration" id="add index in alert_rule on org_id, namespace_uid, group_uid columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.825146155Z level=info msg="Executing migration" id="alter alert_rule table data column to mediumtext in mysql"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.839171925Z level=info msg="Executing migration" id="add column for to alert_rule"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.856593465Z level=info msg="Executing migration" id="add column annotations to alert_rule"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.874947551Z level=info msg="Executing migration" id="add column labels to alert_rule"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.892504025Z level=info msg="Executing migration" id="remove unique index from alert_rule on org_id, title columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.912621787Z level=info msg="Executing migration" id="add index in alert_rule on org_id, namespase_uid and title columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.932559008Z level=info msg="Executing migration" id="add dashboard_uid column to alert_rule"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.950987932Z level=info msg="Executing migration" id="add panel_id column to alert_rule"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.9693718Z level=info msg="Executing migration" id="add index in alert_rule on org_id, dashboard_uid and panel_id columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:04.986699685Z level=info msg="Executing migration" id="add rule_group_idx column to alert_rule"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.005173679Z level=info msg="Executing migration" id="create alert_rule_version table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.030235006Z level=info msg="Executing migration" id="add index in alert_rule_version table on rule_org_id, rule_uid and version columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.049838275Z level=info msg="Executing migration" id="add index in alert_rule_version table on rule_org_id, rule_namespace_uid and rule_group columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.068384782Z level=info msg="Executing migration" id="alter alert_rule_version table data column to mediumtext in mysql"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.084675047Z level=info msg="Executing migration" id="add column for to alert_rule_version"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.103148349Z level=info msg="Executing migration" id="add column annotations to alert_rule_version"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.120581552Z level=info msg="Executing migration" id="add column labels to alert_rule_version"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.142941818Z level=info msg="Executing migration" id="add rule_group_idx column to alert_rule_version"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.161408256Z level=info msg="Executing migration" id=create_alert_configuration_table
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.181055332Z level=info msg="Executing migration" id="Add column default in alert_configuration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.198654667Z level=info msg="Executing migration" id="alert alert_configuration alertmanager_configuration column from TEXT to MEDIUMTEXT if mysql"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.215419534Z level=info msg="Executing migration" id="add column org_id in alert_configuration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.232883435Z level=info msg="Executing migration" id="add index in alert_configuration table on org_id column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.253392925Z level=info msg="Executing migration" id="add configuration_hash column to alert_configuration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.268646056Z level=info msg="Executing migration" id=create_ngalert_configuration_table
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.285111926Z level=info msg="Executing migration" id="add index in ngalert_configuration on org_id column"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.303023966Z level=info msg="Executing migration" id="add column send_alerts_to in ngalert_configuration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.318934738Z level=info msg="Executing migration" id="create provenance_type table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.336356013Z level=info msg="Executing migration" id="add index to uniquify (record_key, record_type, org_id) columns"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.358869638Z level=info msg="Executing migration" id="create alert_image table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.377290239Z level=info msg="Executing migration" id="add unique index on token to alert_image table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.396893772Z level=info msg="Executing migration" id="clear migration entry \"remove unified alerting data\""
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.397502884Z level=info msg="Executing migration" id="move dashboard alerts to unified alerting"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.39780014Z level=info msg="alerts found to migrate" alerts=0
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.41928838Z level=info msg="Executing migration" id="create library_element table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.436722881Z level=info msg="Executing migration" id="add index library_element org_id-folder_id-name-kind"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.459250309Z level=info msg="Executing migration" id="create library_element_connection table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.476694376Z level=info msg="Executing migration" id="add index library_element_connection element_id-kind-connection_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.495901837Z level=info msg="Executing migration" id="add unique index library_element org_id_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.513259014Z level=info msg="Executing migration" id="increase max description length to 2048"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.528904615Z level=info msg="Executing migration" id="clone move dashboard alerts to unified alerting"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.545190002Z level=info msg="Executing migration" id="create data_keys table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.566698129Z level=info msg="Executing migration" id="create secrets table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.583078788Z level=info msg="Executing migration" id="rename data_keys name column to id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.600358885Z level=info msg="Executing migration" id="add name column into data_keys"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.618778694Z level=info msg="Executing migration" id="copy data_keys id column values into name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.635104091Z level=info msg="Executing migration" id="rename data_keys name column to label"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.652459762Z level=info msg="Executing migration" id="rename data_keys id column back to name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.670894545Z level=info msg="Executing migration" id="create kv_store table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.692648292Z level=info msg="Executing migration" id="add index kv_store.org_id-namespace-key"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.710858018Z level=info msg="Executing migration" id="update dashboard_uid and panel_id from existing annotations"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.727304808Z level=info msg="Executing migration" id="create permission table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.746749702Z level=info msg="Executing migration" id="add unique index permission.role_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.767238136Z level=info msg="Executing migration" id="add unique index role_id_action_scope"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.786657093Z level=info msg="Executing migration" id="create role table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.80789297Z level=info msg="Executing migration" id="add column display_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.825503444Z level=info msg="Executing migration" id="add column group_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.8433655Z level=info msg="Executing migration" id="add index role.org_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.862809501Z level=info msg="Executing migration" id="add unique index role_org_id_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.883344882Z level=info msg="Executing migration" id="add index role_org_id_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.902809408Z level=info msg="Executing migration" id="create team role table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.923011363Z level=info msg="Executing migration" id="add index team_role.org_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.942520464Z level=info msg="Executing migration" id="add unique index team_role_org_id_team_id_role_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.962798437Z level=info msg="Executing migration" id="add index team_role.team_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:05.98329712Z level=info msg="Executing migration" id="create user role table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.00280761Z level=info msg="Executing migration" id="add index user_role.org_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.027292999Z level=info msg="Executing migration" id="add unique index user_role_org_id_user_id_role_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.04262415Z level=info msg="Executing migration" id="add index user_role.user_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.061014658Z level=info msg="Executing migration" id="create builtin role table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.080721625Z level=info msg="Executing migration" id="add index builtin_role.role_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.101054647Z level=info msg="Executing migration" id="add index builtin_role.name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.124610144Z level=info msg="Executing migration" id="Add column org_id to builtin_role table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.143914493Z level=info msg="Executing migration" id="add index builtin_role.org_id"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.162704235Z level=info msg="Executing migration" id="add unique index builtin_role_org_id_role_id_role"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.182828103Z level=info msg="Executing migration" id="Remove unique index role_org_id_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.203405242Z level=info msg="Executing migration" id="add unique index role.uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.222784213Z level=info msg="Executing migration" id="create seed assignment table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.247366053Z level=info msg="Executing migration" id="add unique index builtin_role_role_name"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.270957057Z level=info msg="Executing migration" id="add column hidden to role table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.289594948Z level=info msg="Executing migration" id="create query_history table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.307422483Z level=info msg="Executing migration" id="add index query_history.org_id-created_by-datasource_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.327175016Z level=info msg="Executing migration" id="teams permissions migration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.343365126Z level=info msg="Executing migration" id="dashboard permissions"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.362782574Z level=info msg="Executing migration" id="dashboard permissions uid scopes"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.383188296Z level=info msg="Executing migration" id="drop managed folder create actions"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.399390558Z level=info msg="Executing migration" id="alerting notification permissions"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.415281512Z level=info msg="Executing migration" id="create query_history_star table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.44688233Z level=info msg="Executing migration" id="add index query_history.user_id-query_uid"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.466748959Z level=info msg="Executing migration" id="add column org_id in query_history_star"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.48485862Z level=info msg="Executing migration" id="create correlation table v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.505239156Z level=info msg="Executing migration" id="create entity_events table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.524819895Z level=info msg="Executing migration" id="create dashboard public config v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.541168084Z level=info msg="Executing migration" id="drop index UQE_dashboard_public_config_uid - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.541519983Z level=warn msg="Skipping migration: Already executed, but not recorded in migration log" id="drop index UQE_dashboard_public_config_uid - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.556383412Z level=info msg="Executing migration" id="drop index IDX_dashboard_public_config_org_id_dashboard_uid - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.556660075Z level=warn msg="Skipping migration: Already executed, but not recorded in migration log" id="drop index IDX_dashboard_public_config_org_id_dashboard_uid - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.57315536Z level=info msg="Executing migration" id="Drop old dashboard public config table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.592476977Z level=info msg="Executing migration" id="recreate dashboard public config v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.609719429Z level=info msg="Executing migration" id="create index UQE_dashboard_public_config_uid - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.62707763Z level=info msg="Executing migration" id="create index IDX_dashboard_public_config_org_id_dashboard_uid - v1"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.650910105Z level=info msg="Executing migration" id="drop index UQE_dashboard_public_config_uid - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.669299862Z level=info msg="Executing migration" id="drop index IDX_dashboard_public_config_org_id_dashboard_uid - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.686887279Z level=info msg="Executing migration" id="Drop public config table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.705318725Z level=info msg="Executing migration" id="Recreate dashboard public config v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.723146632Z level=info msg="Executing migration" id="create index UQE_dashboard_public_config_uid - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.740536761Z level=info msg="Executing migration" id="create index IDX_dashboard_public_config_org_id_dashboard_uid - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.759426992Z level=info msg="Executing migration" id="create index UQE_dashboard_public_config_access_token - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.779126201Z level=info msg="Executing migration" id="Rename table dashboard_public_config to dashboard_public - v2"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.797203671Z level=info msg="Executing migration" id="create default alerting folders"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.812722961Z level=info msg="Executing migration" id="create file table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.833323228Z level=info msg="Executing migration" id="file table idx: path natural pk"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.852768584Z level=info msg="Executing migration" id="file table idx: parent_folder_path_hash fast folder retrieval"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.873537429Z level=info msg="Executing migration" id="create file_meta table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.897119461Z level=info msg="Executing migration" id="file table idx: path key"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.912909131Z level=info msg="Executing migration" id="set path collation in file table"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.928836894Z level=info msg="Executing migration" id="managed permissions migration"
prometheus                  | ts=2023-04-14T18:25:53.962Z caller=main.go:491 level=info msg="No time or size retention was set so using the default time retention" duration=15d
prometheus                  | ts=2023-04-14T18:25:53.962Z caller=main.go:535 level=info msg="Starting Prometheus Server" mode=server version="(version=2.36.0, branch=HEAD, revision=d48f381d9a4e68c83283ce5233844807dfdc5ba5)"
prometheus                  | ts=2023-04-14T18:25:53.962Z caller=main.go:540 level=info build_context="(go=go1.18.2, user=root@b3126bd1c115, date=20220530-13:56:56)"
prometheus                  | ts=2023-04-14T18:25:53.962Z caller=main.go:541 level=info host_details="(Linux 5.4.0-42-generic #46-Ubuntu SMP Fri Jul 10 00:24:02 UTC 2020 x86_64 5c1acf21ab9f (none))"
prometheus                  | ts=2023-04-14T18:25:53.962Z caller=main.go:542 level=info fd_limits="(soft=1048576, hard=1048576)"
prometheus                  | ts=2023-04-14T18:25:53.962Z caller=main.go:543 level=info vm_limits="(soft=unlimited, hard=unlimited)"
prometheus                  | ts=2023-04-14T18:25:53.974Z caller=web.go:553 level=info component=web msg="Start listening for connections" address=0.0.0.0:9090
prometheus                  | ts=2023-04-14T18:25:53.996Z caller=main.go:972 level=info msg="Starting TSDB ..."
prometheus                  | ts=2023-04-14T18:25:54.039Z caller=tls_config.go:195 level=info component=web msg="TLS is disabled." http2=false
prometheus                  | ts=2023-04-14T18:25:54.050Z caller=head.go:493 level=info component=tsdb msg="Replaying on-disk memory mappable chunks if any"
prometheus                  | ts=2023-04-14T18:25:54.050Z caller=head.go:536 level=info component=tsdb msg="On-disk memory mappable chunks replay completed" duration=6.967µs
prometheus                  | ts=2023-04-14T18:25:54.050Z caller=head.go:542 level=info component=tsdb msg="Replaying WAL, this may take a while"
prometheus                  | ts=2023-04-14T18:25:54.054Z caller=head.go:613 level=info component=tsdb msg="WAL segment loaded" segment=0 maxSegment=0
prometheus                  | ts=2023-04-14T18:25:54.054Z caller=head.go:619 level=info component=tsdb msg="WAL replay completed" checkpoint_replay_duration=53.175µs wal_replay_duration=4.006331ms total_replay_duration=4.091471ms
prometheus                  | ts=2023-04-14T18:25:54.063Z caller=main.go:993 level=info fs_type=794c7630
prometheus                  | ts=2023-04-14T18:25:54.063Z caller=main.go:996 level=info msg="TSDB started"
prometheus                  | ts=2023-04-14T18:25:54.063Z caller=main.go:1177 level=info msg="Loading configuration file" filename=/opt/bitnami/prometheus/conf/prometheus.yml
prometheus                  | ts=2023-04-14T18:25:54.070Z caller=main.go:1214 level=info msg="Completed loading of configuration file" filename=/opt/bitnami/prometheus/conf/prometheus.yml totalDuration=7.664342ms db_storage=2.118µs remote_storage=3.772µs web_handler=1.177µs query_engine=1.946µs scrape=6.92091ms scrape_sd=75.037µs notify=6.313µs notify_sd=2.712µs rules=6.699µs tracing=14.975µs
prometheus                  | ts=2023-04-14T18:25:54.070Z caller=main.go:957 level=info msg="Server is ready to receive web requests."
prometheus                  | ts=2023-04-14T18:25:54.070Z caller=manager.go:937 level=info component="rule manager" msg="Starting rule manager..."
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.945314391Z level=info msg="Executing migration" id="managed folder permissions alert actions migration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.961313132Z level=info msg="Executing migration" id="RBAC action name migrator"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.977126443Z level=info msg="Executing migration" id="Add UID column to playlist"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:06.995899667Z level=info msg="Executing migration" id="Update uid column values in playlist"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:07.010921882Z level=info msg="Executing migration" id="Add index for uid in playlist"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:07.028995217Z level=info msg="Executing migration" id="update group index for alert rules"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:07.045867707Z level=info msg="Executing migration" id="managed folder permissions alert actions repeated migration"
docker-grafana-1            | logger=migrator t=2023-04-14T18:26:07.061200599Z level=info msg="migrations completed" performed=446 skipped=0 duration=8.196219547s
docker-grafana-1            | logger=sqlstore t=2023-04-14T18:26:07.076745125Z level=info msg="Created default admin" user=admin
docker-grafana-1            | logger=sqlstore t=2023-04-14T18:26:07.07701611Z level=info msg="Created default organization"
docker-grafana-1            | logger=plugin.manager t=2023-04-14T18:26:07.134442579Z level=info msg="Plugin registered" pluginId=input
docker-grafana-1            | logger=plugin.manager t=2023-04-14T18:26:07.55692378Z level=info msg="Plugin registered" pluginId=vertamedia-clickhouse-datasource
docker-grafana-1            | logger=plugin.vertamedia-clickhouse-datasource t=2023-04-14T18:26:07.56780427Z level=info msg="Starting ClickHouse datasource backend..."
docker-grafana-1            | logger=secrets t=2023-04-14T18:26:07.570243011Z level=info msg="Envelope encryption state" enabled=true currentprovider=secretKey.v1
docker-grafana-1            | logger=query_data t=2023-04-14T18:26:07.573541984Z level=info msg="Query Service initialization"
docker-grafana-1            | logger=live.push_http t=2023-04-14T18:26:07.586546561Z level=info msg="Live Push Gateway initialization"
docker-grafana-1            | logger=ticker t=2023-04-14T18:26:07.605435992Z level=info msg=starting first_tick=2023-04-14T18:26:10Z
docker-grafana-1            | logger=infra.usagestats.collector t=2023-04-14T18:26:07.681472059Z level=info msg="registering usage stat providers" usageStatsProvidersLen=2
docker-grafana-1            | logger=provisioning.datasources t=2023-04-14T18:26:07.708432321Z level=warn msg="[Deprecated] the datasource provisioning config is outdated. please upgrade" filename=/etc/grafana/provisioning/datasources/datasource.yml
docker-grafana-1            | logger=provisioning.datasources t=2023-04-14T18:26:07.709462045Z level=info msg="inserting datasource from configuration " name=prometheus uid=P1809F7CD0C75ACF3
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 31715 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 31716 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 31716 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:3
docker-debezium-embedded-1  | 41721 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 41723 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 41724 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 41724 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 41725 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 41731 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 41731 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:4
docker-debezium-embedded-1  | 51733 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 51733 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 51734 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 51734 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-grafana-1            | logger=provisioning.datasources t=2023-04-14T18:26:07.733776359Z level=info msg="inserting datasource from configuration " name=Clickhouse uid=PDF61E9E97939C7ED
docker-grafana-1            | logger=provisioning.alerting t=2023-04-14T18:26:07.749021604Z level=info msg="starting to provision alerting"
docker-grafana-1            | logger=provisioning.alerting t=2023-04-14T18:26:07.749084247Z level=info msg="finished to provision alerting"
docker-grafana-1            | logger=grafanaStorageLogger t=2023-04-14T18:26:07.752055325Z level=info msg="storage starting"
docker-grafana-1            | logger=http.server t=2023-04-14T18:26:07.756238737Z level=info msg="HTTP Server Listen" address=[::]:3000 protocol=http subUrl= socket=
docker-grafana-1            | logger=ngalert t=2023-04-14T18:26:07.757062107Z level=info msg="warming cache for startup"
docker-grafana-1            | logger=ngalert.multiorg.alertmanager t=2023-04-14T18:26:07.837357006Z level=info msg="starting MultiOrg Alertmanager"
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 51734 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 51735 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 51735 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:5
docker-debezium-embedded-1  | 61737 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumConnectorCallback  - DebeziumConnectorCallback constructor
docker-debezium-embedded-1  | 61739 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = key
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 61739 [main] INFO org.apache.kafka.connect.json.JsonConverterConfig  - JsonConverterConfig values: 
docker-debezium-embedded-1  | 	converter.type = value
docker-debezium-embedded-1  | 	decimal.format = BASE64
docker-debezium-embedded-1  | 	schemas.cache.size = 1000
docker-debezium-embedded-1  | 	schemas.enable = false
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 61740 [main] INFO io.debezium.embedded.EmbeddedEngine$EmbeddedConfig  - EmbeddedConfig values: 
docker-debezium-embedded-1  | 	access.control.allow.methods = 
docker-debezium-embedded-1  | 	access.control.allow.origin = 
docker-debezium-embedded-1  | 	admin.listeners = null
docker-debezium-embedded-1  | 	bootstrap.servers = [localhost:9092]
docker-debezium-embedded-1  | 	client.dns.lookup = use_all_dns_ips
docker-debezium-embedded-1  | 	config.providers = []
docker-debezium-embedded-1  | 	connector.client.config.override.policy = All
docker-debezium-embedded-1  | 	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
docker-debezium-embedded-1  | 	key.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 	listeners = [http://:8083]
docker-debezium-embedded-1  | 	metric.reporters = []
docker-debezium-embedded-1  | 	metrics.num.samples = 2
docker-debezium-embedded-1  | 	metrics.recording.level = INFO
docker-debezium-embedded-1  | 	metrics.sample.window.ms = 30000
docker-debezium-embedded-1  | 	offset.flush.interval.ms = 60000
docker-debezium-embedded-1  | 	offset.flush.timeout.ms = 5000
docker-debezium-embedded-1  | 	offset.storage.file.filename = "/tmp/offsets.dat"
docker-debezium-embedded-1  | 	offset.storage.partitions = null
docker-debezium-embedded-1  | 	offset.storage.replication.factor = null
docker-debezium-embedded-1  | 	offset.storage.topic = 
docker-debezium-embedded-1  | 	plugin.path = null
docker-debezium-embedded-1  | 	response.http.headers.config = 
docker-debezium-embedded-1  | 	rest.advertised.host.name = null
docker-debezium-embedded-1  | 	rest.advertised.listener = null
docker-debezium-embedded-1  | 	rest.advertised.port = null
docker-debezium-embedded-1  | 	rest.extension.classes = []
docker-debezium-embedded-1  | 	ssl.cipher.suites = null
docker-debezium-embedded-1  | 	ssl.client.auth = none
docker-debezium-embedded-1  | 	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
docker-debezium-embedded-1  | 	ssl.endpoint.identification.algorithm = https
docker-debezium-embedded-1  | 	ssl.engine.factory.class = null
docker-debezium-embedded-1  | 	ssl.key.password = null
docker-debezium-embedded-1  | 	ssl.keymanager.algorithm = SunX509
docker-debezium-embedded-1  | 	ssl.keystore.certificate.chain = null
docker-debezium-embedded-1  | 	ssl.keystore.key = null
docker-debezium-embedded-1  | 	ssl.keystore.location = null
docker-debezium-embedded-1  | 	ssl.keystore.password = null
docker-debezium-embedded-1  | 	ssl.keystore.type = JKS
docker-debezium-embedded-1  | 	ssl.protocol = TLSv1.3
docker-debezium-embedded-1  | 	ssl.provider = null
docker-debezium-embedded-1  | 	ssl.secure.random.implementation = null
docker-debezium-embedded-1  | 	ssl.trustmanager.algorithm = PKIX
docker-debezium-embedded-1  | 	ssl.truststore.certificates = null
docker-debezium-embedded-1  | 	ssl.truststore.location = null
docker-debezium-embedded-1  | 	ssl.truststore.password = null
docker-debezium-embedded-1  | 	ssl.truststore.type = JKS
docker-debezium-embedded-1  | 	task.shutdown.graceful.timeout.ms = 5000
docker-debezium-embedded-1  | 	topic.creation.enable = true
docker-debezium-embedded-1  | 	topic.tracking.allow.reset = true
docker-debezium-embedded-1  | 	topic.tracking.enable = true
docker-debezium-embedded-1  | 	value.converter = class org.apache.kafka.connect.json.JsonConverter
docker-debezium-embedded-1  | 
docker-debezium-embedded-1  | 61740 [main] WARN org.apache.kafka.connect.runtime.WorkerConfig  - Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
docker-debezium-embedded-1  | 61740 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector
docker-debezium-embedded-1  | 61740 [main] ERROR com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Retrying - try number:6
docker-debezium-embedded-1  | 61740 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback
docker-debezium-embedded-1  | 61740 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback
docker-debezium-embedded-1  | 61741 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback
docker-debezium-embedded-1  | 61741 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback
docker-debezium-embedded-1  | 61741 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback
docker-debezium-embedded-1  | 61741 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback
docker-debezium-embedded-1  | 61741 [main] INFO com.altinity.clickhouse.debezium.embedded.cdc.DebeziumChangeEventCapture  - Completion callback

subkanthi · 2023-04-17T15:38:01Z

subkanthi
Apr 17, 2023
Maintainer

Hi @sudmed , this issue should be fixed now, can you try the latest image again, also the database.dbname should be added to .env file and the table.include.list should match the tables in the database.
Here is the configuration I have tried and it works.

####clickhouse/users.xml

<?xml version="1.0"?>
<clickhouse>
    <!-- See also the files in users.d directory where the settings can be overridden. -->

    <!-- Profiles of settings. -->
    <profiles>
        <!-- Default settings. -->
        <default>
            <!-- How to choose between replicas during distributed query processing.
                 random - choose random replica from set of replicas with minimum number of errors
                 nearest_hostname - from set of replicas with minimum number of errors, choose replica
                  with minimum number of different symbols between replica's hostname and local hostname
                  (Hamming distance).
                 in_order - first live replica is chosen in specified order.
                 first_or_random - if first replica one has higher number of errors, pick a random one from replicas with minimum number of errors.
            -->
            <allow_experimental_object_type>1</allow_experimental_object_type>
            <load_balancing>random</load_balancing>
        </default>

        <!-- Profile that allows only read queries. -->
        <readonly>
            <readonly>1</readonly>
        </readonly>
    </profiles>

    <!-- Users and ACL. -->
    <users>
        <!-- If user name was not specified, 'default' user is used. -->
        <default>
            <!-- See also the files in users.d directory where the password can be overridden.

                 Password could be specified in plaintext or in SHA256 (in hex format).

                 If you want to specify password in plaintext (not recommended), place it in 'password' element.
                 Example: <password>qwerty</password>.
                 Password could be empty.

                 If you want to specify SHA256, place it in 'password_sha256_hex' element.
                 Example: <password_sha256_hex>65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5</password_sha256_hex>
                 Restrictions of SHA256: impossibility to connect to ClickHouse using MySQL JS client (as of July 2019).

                 If you want to specify double SHA1, place it in 'password_double_sha1_hex' element.
                 Example: <password_double_sha1_hex>e395796d6546b1b65db9d665cd43f0e858dd4303</password_double_sha1_hex>

                 If you want to specify a previously defined LDAP server (see 'ldap_servers' in the main config) for authentication,
                  place its name in 'server' element inside 'ldap' element.
                 Example: <ldap><server>my_ldap_server</server></ldap>

                 If you want to authenticate the user via Kerberos (assuming Kerberos is enabled, see 'kerberos' in the main config),
                  place 'kerberos' element instead of 'password' (and similar) elements.
                 The name part of the canonical principal name of the initiator must match the user name for authentication to succeed.
                 You can also place 'realm' element inside 'kerberos' element to further restrict authentication to only those requests
                  whose initiator's realm matches it.
                 Example: <kerberos />
                 Example: <kerberos><realm>EXAMPLE.COM</realm></kerberos>

                 How to generate decent password:
                 Execute: PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-'
                 In first line will be password and in second - corresponding SHA256.

                 How to generate double SHA1:
                 Execute: PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha1sum | tr -d '-' | xxd -r -p | sha1sum | tr -d '-'
                 In first line will be password and in second - corresponding double SHA1.
            -->
            <!-- <password>root</password> -->

            <!-- List of networks with open access.

                 To open access from everywhere, specify:
                    <ip>::/0</ip>

                 To open access only from localhost, specify:
                    <ip>::1</ip>
                    <ip>127.0.0.1</ip>

                 Each element of list has one of the following forms:
                 <ip> IP-address or network mask. Examples: 213.180.204.3 or 10.0.0.1/8 or 10.0.0.1/255.255.255.0
                     2a02:6b8::3 or 2a02:6b8::3/64 or 2a02:6b8::3/ffff:ffff:ffff:ffff::.
                 <host> Hostname. Example: server01.clickhouse.com.
                     To check access, DNS query is performed, and all received addresses compared to peer address.
                 <host_regexp> Regular expression for host names. Example, ^server\d\d-\d\d-\d\.clickhouse\.com$
                     To check access, DNS PTR query is performed for peer address and then regexp is applied.
                     Then, for result of PTR query, another DNS query is performed and all received addresses compared to peer address.
                     Strongly recommended that regexp is ends with $
                 All results of DNS requests are cached till server restart.
            -->
            <networks>
                <ip>::/0</ip>
            </networks>

            <!-- Settings profile for user. -->
            <profile>default</profile>

            <!-- Quota for user. -->
            <quota>default</quota>

            <!-- User can create other users and grant rights to them. -->
            <!-- <access_management>1</access_management> -->
        </default>
    </users>

    <!-- Quotas. -->
    <quotas>
        <!-- Name of quota. -->
        <default>
            <!-- Limits for time interval. You could specify many intervals with different limits. -->
            <interval>
                <!-- Length of interval. -->
                <duration>3600</duration>

                <!-- No limits. Just calculate resource usage for time interval. -->
                <queries>0</queries>
                <errors>0</errors>
                <result_rows>0</result_rows>
                <read_rows>0</read_rows>
                <execution_time>0</execution_time>
            </interval>
        </default>
    </quotas>
</clickhouse>

####docker.env

export database.hostname="postgres"
export database.port="5432"
export database.user="root"
export database.password="root"
export snapshot.mode="initial"
export database.dbname="public"
export connector.class="io.debezium.connector.postgresql.PostgresConnector"
export plugin.name="pgoutput"
export table.include.list="public.tm"
export auto.create.tables=true
export replacingmergetree.delete.column="_sign"
export metrics.port=8087
export clickhouse.server.url="clickhouse"
export clickhouse.server.user="root"
export clickhouse.server.pass="root"
export clickhouse.server.port="8123"
export clickhouse.server.database="test"
export offset.storage="org.apache.kafka.connect.storage.FileOffsetBackingStore"
export offset.storage.file.filename="/tmp/offsets.dat"
export offset.flush.interval.ms="60000"

####docker-compose.yml

version: "3.4"

# Ubuntu , set this for redpanda to start
# https://sort.veritas.com/public/documents/HSO/2.0/linux/productguides/html/hfo_admin_ubuntu/ch04s03.htm

# Clickhouse Table Schema
# create table test(id int, message String) ENGINE=MergeTree() PRIMARY KEY id;

services:
  postgres:
    image: postgres:latest
    restart: always
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_PASSWORD=root
      - POSTGRES_USER=root
      - POSTGRES_DB=public
    volumes:
      - ../sql/init_postgres.sql:/docker-entrypoint-initdb.d/init_postgres.sql
    command:
      - "postgres"
      - "-c"
      - "wal_level=logical"

#  mysql-master:
#    container_name: mysql-master
#    image: docker.io/bitnami/mysql:latest
#    restart: "no"
#    ports:
#      - "3306:3306"
#    environment:
#      - MYSQL_ROOT_PASSWORD=root
#      - MYSQL_DATABASE=test
#      - MYSQL_REPLICATION_MODE=master
#      - MYSQL_REPLICATION_USER=repl_user
#      - ALLOW_EMPTY_PASSWORD=yes
#    volumes:
#      - ./mysqld.cnf:/opt/bitnami/mysql/conf/my_custom.cnf
#      - ../sql/init_mysql.sql:/docker-entrypoint-initdb.d/init_mysql.sql
#    healthcheck:
#      test: [ 'CMD', '/opt/bitnami/scripts/mysql/healthcheck.sh' ]
#      interval: 15s
#      timeout: 5s
#      retries: 6

  clickhouse:
    # clickhouse-client --host=127.0.0.1 --port=9000 --user=root --password=root --database=test
    container_name: clickhouse
    image: clickhouse/clickhouse-server:latest
    restart: "no"
    ports:
      - "8123:8123"
      - "9000:9000"
    environment:
      - CLICKHOUSE_USER=root
      - CLICKHOUSE_PASSWORD=root
      - CLICKHOUSE_DB=test
      - CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=0
    ulimits:
      nofile:
        soft: "262144"
        hard: "262144"
    volumes:
      #- ../sql/init_ch.sql:/docker-entrypoint-initdb.d/init_clickhouse.sql
      -  ../clickhouse/users.xml:/etc/clickhouse-server/users.xml
    depends_on:
      zookeeper:
        condition: service_healthy

  zookeeper:
      image: zookeeper:3.6.2
      expose:
        - "2181"
      environment:
        ZOO_TICK_TIME: 500
        ZOO_MY_ID: 1
      healthcheck:
        test: echo stat | nc localhost 2181
        interval: 3s
        timeout: 2s
        retries: 5
        start_period: 2s
      security_opt:
        - label:disable

  debezium-embedded:
    image: registry.gitlab.com/altinity-public/container-images/clickhouse_debezium_embedded:latest
    #    build:
#      context: ../
    restart: "no"
    ports:
      - "8083:8083"
#    depends_on:
#      - mysql-master
    env_file:
      - docker_postgres.env
    extra_hosts:
      - "host.docker.internal:host-gateway"


  #### MONITORING ####
#  prometheus:
#    container_name: prometheus
#    image: bitnami/prometheus:2.36.0
#    restart: "no"
#    ports:
#      - "9090:9090"
#    volumes:
#      - ./config/prometheus.yml:/opt/bitnami/prometheus/conf/prometheus.yml
#
#  grafana:
#    build:
#      context: ./config/grafana
#      args:
#        GRAFANA_VERSION: latest
#    #container_name: grafana
#    #image: grafana/grafana
#    restart: "no"
#      #volumes:
#      #  - ../config/grafana/dashboards:/etc/grafana/provisioning/dashboards
#    ports:
#      - "3000:3000"
#    environment:
#      - DS_PROMETHEUS=prometheus
#      - GF_USERS_DEFAULT_THEME=light
#      - GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=vertamedia-clickhouse-datasource,grafana-clickhouse-datasource
#      - GF_INSTALL_PLUGINS=vertamedia-clickhouse-datasource,grafana-clickhouse-datasource
#    depends_on:
#      - prometheus
    ### END OF MONITORING ###

0 replies

sudmed · 2023-04-18T07:06:09Z

sudmed
Apr 18, 2023
Author

Hi @subkanthi, thanks for the answer.
it works! but there is a nuance. I've generated 100k inserts to postgresql db table and only 1-5 entries get into the clickhouse table.
how to troubleshoot it?

inserts examples

INSERT INTO protocol_test VALUES ('1778392', '15563836', 'Henry I voyuer Ellen Holdings LLC 4510 Elsmore viking friendship', '2001-11-17T08:34:48.338Z');
INSERT INTO protocol_test VALUES ('1778393', '17226989', 'Egbert  modify Clothing Stores Inc 6497 Macclesfield Street touched journey', '2006-03-08T14:57:41.217Z');
INSERT INTO protocol_test VALUES ('1778394', '10588494', 'Aethelbert incorrect Configuration Company 0652 Bellhouse Avenue update descending', '1998-06-17T19:56:22.373Z');
INSERT INTO protocol_test VALUES ('1778395', '929854', 'William III roster Proxy Energy  3851 Tamerton Lane operated assault', '1976-04-27T09:57:28.520Z');
INSERT INTO protocol_test VALUES ('1778396', '3802619', 'Edward VI phentermine Intent  2052 Mardale Road apparent negotiation', '1974-11-21T03:13:00.486Z');
INSERT INTO protocol_test VALUES ('1778397', '14180264', 'Oliver Cromwell leaders Levitra Corporation 4607 Blackmore Street ex factor', '2019-01-19T17:07:00.548Z');
INSERT INTO protocol_test VALUES ('1778398', '4694776', 'Edward IV disposition Casa A.G 1014 Windsor Circle noted nervous', '2001-09-04T16:41:35.782Z');
INSERT INTO protocol_test VALUES ('1778399', '17504297', 'George VI personality Infrastructure Stores Pte. Ltd 5416 Isherwood Avenue beastality surgical', '1973-10-31T09:33:52.476Z');
INSERT INTO protocol_test VALUES ('1778400', '1849158', 'Edward III indication Industrial International Inc 5362 Brow programs fountain', '1989-04-24T16:16:17.682Z');
INSERT INTO protocol_test VALUES ('1778401', '11321075', 'Henry III valves People  7759 Ashdale Road pharmaceuticals eddie', '1984-06-24T04:37:33.883Z');
INSERT INTO protocol_test VALUES ('1778402', '14017777', 'Anne matches Pro SIA 8300 Daisygate Lane calibration keno', '1990-05-22T12:08:53.159Z');
INSERT INTO protocol_test VALUES ('1778403', '20704443', 'Offa msn Knee International S.A 4174 Bodmin Road however portions', '2004-06-13T09:51:21.807Z');
INSERT INTO protocol_test VALUES ('1778404', '13219949', 'Edward III domestic Fragrances Mutual A.G 2683 Brewery Avenue business pen', '2013-03-13T19:38:56.313Z');
INSERT INTO protocol_test VALUES ('1778405', '12850499', 'Harthacanut canvas Scoring Mutual  7526 Imperial Avenue broker absent', '2010-12-17T21:41:22.045Z');
INSERT INTO protocol_test VALUES ('1778406', '9028650', 'Harold II jobs Gamespot A.G 5029 Maypool speaker shorter', '2005-03-22T09:04:38.300Z');
INSERT INTO protocol_test VALUES ('1778407', '124999', 'Oliver Cromwell generating Loud Stores Corp 1309 Tennyson Road village lopez', '1971-01-31T00:13:14.868Z');
INSERT INTO protocol_test VALUES ('1778408', '8208132', 'Charles I  pat Requiring Ltd 5633 Fistral Street velvet keep', '1999-09-18T10:31:12.849Z');
INSERT INTO protocol_test VALUES ('1778409', '11043995', 'Charles II objects Estimated Mutual S.A 3911 Ridge Lane distributors exciting', '1994-07-18T19:38:17.970Z');
INSERT INTO protocol_test VALUES ('1778410', '18749480', 'Henry III trail Codes Software Inc 9875 Thomas Circle psi ion', '2006-12-09T21:56:40.567Z');
INSERT INTO protocol_test VALUES ('1778411', '7187805', 'Edward VII kyle Rca Stores B.V 5530 Lesser Road contemporary nr', '2003-03-25T03:34:25.305Z');
INSERT INTO protocol_test VALUES ('1778412', '15110317', 'William IV dishes Para Software GmbH 2986 Fitton Avenue defining turbo', '1981-03-10T07:11:28.227Z');
INSERT INTO protocol_test VALUES ('1778413', '19393663', 'Stephen wax Suggested  8909 Torwood planning committed', '1993-05-22T20:58:55.054Z');
INSERT INTO protocol_test VALUES ('1778414', '7891828', 'Aethelred I schedule Dicke SIA 5202 Hathaway Avenue sets requested', '2002-11-24T11:17:19.723Z');
INSERT INTO protocol_test VALUES ('1778415', '10389394', 'Harthacanut incidence Locally International Pte. Ltd 2172 Ashwood Road end nato', '2017-03-12T01:23:42.442Z');
INSERT INTO protocol_test VALUES ('1778416', '9613139', 'George I weblog Chi Mutual SIA 0947 Dowling Road satin courses', '2019-06-02T10:57:33.557Z');
INSERT INTO protocol_test VALUES ('1778417', '3294112', 'Ethelred II the Unready diversity Adjust S.A 0876 Farmside Circle thumbzilla edge', '1982-04-12T06:21:46.045Z');
INSERT INTO protocol_test VALUES ('1778418', '22868110', 'Aethelbald batch Twenty  4871 Heaton Lane even punch', '2002-07-24T10:39:09.013Z');
INSERT INTO protocol_test VALUES ('1778419', '9784823', 'Charles I  dinner Tracking Stores A.G 1793 Hurst Circle charming proposals', '1991-03-12T16:10:01.117Z');
INSERT INTO protocol_test VALUES ('1778420', '17503042', 'Richard Cromwell journals Lease  7747 Back Road patrick periodically', '1992-12-17T08:25:26.611Z');
INSERT INTO protocol_test VALUES ('1778421', '4105988', 'Egbert  weak Qualifying Stores Corp 1025 Falmer Street plants engines', '1993-02-16T06:50:46.555Z');
INSERT INTO protocol_test VALUES ('1778422', '20367835', 'Edward III layout Opening International Ltd 9873 Stansfield cocktail mails', '1978-09-25T18:43:38.845Z');
INSERT INTO protocol_test VALUES ('1778423', '4133456', 'Richard Cromwell forced Gtk B.V 6057 Brownsville volvo encourages', '1979-08-10T06:13:07.451Z');
INSERT INTO protocol_test VALUES ('1778424', '15763048', 'George III women Part Ltd 2830 Turf Lane ap diseases', '1978-04-24T19:44:06.966Z');
INSERT INTO protocol_test VALUES ('1778425', '13783051', 'George II wagon Express Energy Pte. Ltd 7317 Adair refer producer', '1976-11-04T05:18:23.814Z');
INSERT INTO protocol_test VALUES ('1778426', '5048883', 'Ethelred II the Unready retain Medline Mutual A.G 6841 Cudworth chester mg', '1971-05-23T22:24:10.661Z');
INSERT INTO protocol_test VALUES ('1778427', '19987357', 'James I ireland Salary Industries  9869 Northholt Road vernon reactions', '2023-02-26T00:29:05.151Z');
INSERT INTO protocol_test VALUES ('1778428', '9518612', 'Stephen poly Holmes LLC 9482 Honiton Road participants equations', '1979-08-04T04:31:07.812Z');
INSERT INTO protocol_test VALUES ('1778429', '9288848', 'William IV printers Parker Industries Corporation 3335 Privet Lane null prostate', '1976-03-05T15:27:18.569Z');
INSERT INTO protocol_test VALUES ('1778430', '12041969', 'Henry VII stocks Skin A.G 1983 Affetside Lane shanghai sleeve', '1970-09-28T17:34:52.197Z');
INSERT INTO protocol_test VALUES ('1778431', '1228695', 'Mary I silver Visiting  6041 Caesar Street cameras judge', '1970-11-07T02:49:21.977Z');
INSERT INTO protocol_test VALUES ('1778432', '21481203', 'Edward V  prisoners Peterson Pte. Ltd 2577 Limebank Circle span religious', '1975-02-02T01:13:06.152Z');

Clickhouse table `select` command output during the `insert` process

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: 8529bc8a-7ccf-4129-ae4e-4cc666a1d56a

┌──────id─┬─consultation_id─┬─recomendation──────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1793154 │         4899545 │ Edward V  encyclopedia Identifies Corporation 9085 Northallerton Avenue metric asn │ 1970-04-12 08:27:55.000000 │     1 │ 1681767104984 │
└─────────┴─────────────────┴────────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation───────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1792747 │         7452929 │ Harthacanut vegetation Safety Inc 2713 Lambert form shakespeare │ 1996-03-25 18:55:07.000000 │     1 │ 1681767104129 │
└─────────┴─────────────────┴─────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1793429 │         6103421 │ Edward VIII q Reviewing GmbH 2794 Atherstone Street mardi rc │ 2004-11-07 13:37:07.000000 │     1 │ 1681767105538 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

3 rows in set. Elapsed: 0.005 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: 983ac853-8b30-4545-95b9-b25cbf083f68

┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796085 │         6209926 │ Edward the Confessor  reforms Stat International Pte. Ltd 2293 Borsden Road hu click │ 1970-06-19 18:31:10.000000 │     1 │ 1681767110885 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation──────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795450 │         2200612 │ Edwy oops Prison LLC 8551 Elevator Street iraq divided │ 2001-04-28 19:13:19.000000 │     1 │ 1681767109615 │
└─────────┴─────────────────┴────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796347 │        11512232 │ Alfred the Great run Eagle Holdings S.A 4617 Ingram Circle true johns │ 1972-05-18 21:08:50.000000 │     1 │ 1681767111434 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795818 │        16433878 │ Charles I  spray Navigate Mutual  0281 Callender cross daisy │ 2016-05-19 06:36:36.000000 │     1 │ 1681767110351 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

5 rows in set. Elapsed: 0.006 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: 7941d37d-3dee-4b1a-a7a4-2774e1a65b4b

┌──────id─┬─consultation_id─┬─recomendation──────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795450 │         2200612 │ Edwy oops Prison LLC 8551 Elevator Street iraq divided │ 2001-04-28 19:13:19.000000 │     1 │ 1681767109615 │
└─────────┴─────────────────┴────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796085 │         6209926 │ Edward the Confessor  reforms Stat International Pte. Ltd 2293 Borsden Road hu click │ 1970-06-19 18:31:10.000000 │     1 │ 1681767110885 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795818 │        16433878 │ Charles I  spray Navigate Mutual  0281 Callender cross daisy │ 2016-05-19 06:36:36.000000 │     1 │ 1681767110351 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796347 │        11512232 │ Alfred the Great run Eagle Holdings S.A 4617 Ingram Circle true johns │ 1972-05-18 21:08:50.000000 │     1 │ 1681767111434 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

5 rows in set. Elapsed: 0.005 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: a8099dac-756b-414a-b306-66bf399866c5

┌──────id─┬─consultation_id─┬─recomendation──────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795450 │         2200612 │ Edwy oops Prison LLC 8551 Elevator Street iraq divided │ 2001-04-28 19:13:19.000000 │     1 │ 1681767109615 │
└─────────┴─────────────────┴────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796085 │         6209926 │ Edward the Confessor  reforms Stat International Pte. Ltd 2293 Borsden Road hu click │ 1970-06-19 18:31:10.000000 │     1 │ 1681767110885 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796347 │        11512232 │ Alfred the Great run Eagle Holdings S.A 4617 Ingram Circle true johns │ 1972-05-18 21:08:50.000000 │     1 │ 1681767111434 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795818 │        16433878 │ Charles I  spray Navigate Mutual  0281 Callender cross daisy │ 2016-05-19 06:36:36.000000 │     1 │ 1681767110351 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

5 rows in set. Elapsed: 0.006 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: 7c663043-ed6c-4707-b9e3-0b7480dbebdf

┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796085 │         6209926 │ Edward the Confessor  reforms Stat International Pte. Ltd 2293 Borsden Road hu click │ 1970-06-19 18:31:10.000000 │     1 │ 1681767110885 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation──────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795450 │         2200612 │ Edwy oops Prison LLC 8551 Elevator Street iraq divided │ 2001-04-28 19:13:19.000000 │     1 │ 1681767109615 │
└─────────┴─────────────────┴────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1795818 │        16433878 │ Charles I  spray Navigate Mutual  0281 Callender cross daisy │ 2016-05-19 06:36:36.000000 │     1 │ 1681767110351 │
└─────────┴─────────────────┴──────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘
┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796347 │        11512232 │ Alfred the Great run Eagle Holdings S.A 4617 Ingram Circle true johns │ 1972-05-18 21:08:50.000000 │     1 │ 1681767111434 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

5 rows in set. Elapsed: 0.006 sec.

561a37248405 :) SELECT formatReadableSize(sum(bytes)) FROM system.parts WHERE active AND table = 'protocol_test';

SELECT formatReadableSize(sum(bytes))
FROM system.parts
WHERE active AND (table = 'protocol_test')

Query id: f5ec2fd6-369a-49df-b0c4-39eaadf95d3d

┌─formatReadableSize(sum(bytes_on_disk))─┐
│ 2.30 KiB                               │
└────────────────────────────────────────┘

1 row in set. Elapsed: 0.005 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: a5423bc4-dee4-42e8-b516-82a155e93528

┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

1 row in set. Elapsed: 0.003 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: bccf2029-fd18-4575-900a-6c1b70b41a64

┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

1 row in set. Elapsed: 0.002 sec.

561a37248405 :) SELECT formatReadableSize(sum(bytes)) FROM system.parts WHERE active AND table = 'protocol_test';

SELECT formatReadableSize(sum(bytes))
FROM system.parts
WHERE active AND (table = 'protocol_test')

Query id: 6b2060f1-4fa3-4a08-80e8-10a0edd7cd02

┌─formatReadableSize(sum(bytes_on_disk))─┐
│ 482.00 B                               │
└────────────────────────────────────────┘

1 row in set. Elapsed: 0.003 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: 01b41bfb-604b-4eb4-90d6-cf803322ca43

┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

1 row in set. Elapsed: 0.003 sec.

561a37248405 :) SELECT formatReadableSize(sum(bytes)) FROM system.parts WHERE active AND table = 'protocol_test';

SELECT formatReadableSize(sum(bytes))
FROM system.parts
WHERE active AND (table = 'protocol_test')

Query id: 98b5fabc-929b-4a05-9838-3cea0d225875

┌─formatReadableSize(sum(bytes_on_disk))─┐
│ 482.00 B                               │
└────────────────────────────────────────┘

1 row in set. Elapsed: 0.005 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: bc7ff1b7-19e8-4c30-8cd8-ecc9701e2cf2

┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

1 row in set. Elapsed: 0.003 sec.

561a37248405 :) SELECT formatReadableSize(sum(bytes)) FROM system.parts WHERE active AND table = 'protocol_test';

SELECT formatReadableSize(sum(bytes))
FROM system.parts
WHERE active AND (table = 'protocol_test')

Query id: 199d4444-8a65-460f-a87a-5e01140679af

┌─formatReadableSize(sum(bytes_on_disk))─┐
│ 482.00 B                               │
└────────────────────────────────────────┘

1 row in set. Elapsed: 0.003 sec.

561a37248405 :) select * from protocol_test;

SELECT *
FROM protocol_test

Query id: 6315edd1-1431-498b-971f-079c3525f779

┌──────id─┬─consultation_id─┬─recomendation─────────────────────────────────────────────────────────────────────┬────────────────create_date─┬─_sign─┬──────_version─┐
│ 1796353 │         8977239 │ Alfred the Great ground Sensors Mutual SIA 7173 Tonman Street beautifully fashion │ 2022-11-13 15:18:31.000000 │     1 │ 1681767111449 │
└─────────┴─────────────────┴───────────────────────────────────────────────────────────────────────────────────┴────────────────────────────┴───────┴───────────────┘

1 row in set. Elapsed: 0.002 sec.

561a37248405 :)

Postgres `create` table details

CREATE TABLE protocol_test
(
  id bigserial NOT NULL,
  consultation_id int8 NOT NULL,
  recomendation text NULL,
  create_date timestamptz(0) NOT NULL DEFAULT now(),
  CONSTRAINT protocol_pkey PRIMARY KEY (id)
);

0 replies

subkanthi · 2023-04-19T17:32:55Z

subkanthi
Apr 19, 2023
Maintainer

Hi @sudmed ,
The problem is the auto create table that is created does not have the id column(Primary Key from Postgres), for now you can create the table manually with the ORDER by id and that should fix the problem of ReplacingMergeTree collapsing the wrong rows.

I will create a bug to understand why the CONSTRAINT PRIMARY KEY from postgreSQL is not parsed properly.

Current Implementation.

│ CREATE TABLE public.protocol_test
(
    `id` Int64,
    `consultation_id` Int64,
    `recomendation` Nullable(String),
    `create_date` DateTime64(6),
    `_sign` Int8,
    `_version` UInt64
)
ENGINE = ReplacingMergeTree(_version)
ORDER BY tuple()

Correct version:

│ CREATE TABLE public.protocol_test
(
    `id` Int64,
    `consultation_id` Int64,
    `recomendation` Nullable(String),
    `create_date` DateTime64(6),
    `_sign` Int8,
    `_version` UInt64
)
ENGINE = ReplacingMergeTree(_version)
ORDER BY id

0 replies

sudmed · 2023-04-20T06:43:15Z

sudmed
Apr 20, 2023
Author

@subkanthi Thanks!

0 replies

vaseninm · 2023-04-28T08:01:23Z

vaseninm
Apr 28, 2023

I will create a bug to understand why the CONSTRAINT PRIMARY KEY from postgreSQL is not parsed properly.

Hi @subkanthi,
I have same trouble like @sudmed
Could you message link of this issue? I would like to subscribe to it

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector #210

{{title}}

Replies: 5 comments

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Select a reply

Error starting connectorjava.lang.ClassNotFoundException: io.debezium.connector.postgresql.PostgresConnector #210

sudmed Apr 14, 2023

Replies: 5 comments

subkanthi Apr 17, 2023 Maintainer

sudmed Apr 18, 2023 Author

subkanthi Apr 19, 2023 Maintainer

sudmed Apr 20, 2023 Author

vaseninm Apr 28, 2023

sudmed
Apr 14, 2023

subkanthi
Apr 17, 2023
Maintainer

sudmed
Apr 18, 2023
Author

subkanthi
Apr 19, 2023
Maintainer

sudmed
Apr 20, 2023
Author

vaseninm
Apr 28, 2023