broker容器启动问题 #385

Repo-Zhuang · 2024-10-29T03:18:13Z

在虚拟机Ubuntu上执行docker compose up -d后，broker的服务启动不起来

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS                          PORTS                 NAMES
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   47 minutes ago   Restarting (1) 57 seconds ago                         p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   47 minutes ago   Up 47 minutes                                         p2p-tutorial-engine_alice-1
6b6be3b21a48   mysql:latest             "docker-entrypoint.s…"   47 minutes ago   Up 47 minutes (healthy)         3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   47 minutes ago   Up 47 minutes                                         p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   47 minutes ago   Restarting (1) 58 seconds ago                         p2p-tutorial-broker_bob-1

docker-compose.yml文件如下

version: '3.8'
services:
  broker_alice:
    image: ${SCQL_IMAGE:-secretflow/scql:latest}
    command:
      - /home/admin/bin/broker
      - -config=/home/admin/configs/config.yml
    restart: always
    ports:
      - mode: host
        protocol: tcp
        published: ${ALICE_PORT:-8081}
        target: 8080
    volumes:
      - ./broker/alice/conf/:/home/admin/configs/
      - ./tls/root-ca.crt:/etc/ssl/certs/root-ca.crt
      - ./tls/broker_alice-ca.crt:/home/admin/tls/cert.crt
      - ./tls/broker_alice-ca.key:/home/admin/tls/key.key
  broker_bob:
    image: ${SCQL_IMAGE:-secretflow/scql:latest}
    command:
      - /home/admin/bin/broker
      - -config=/home/admin/configs/config.yml
    restart: always
    ports:
      - mode: host
        protocol: tcp
        published: ${BOB_PORT:-8082}
        target: 8080
    volumes:
      - ./broker/bob/conf/:/home/admin/configs/
      - ./tls/root-ca.crt:/etc/ssl/certs/root-ca.crt
      - ./tls/broker_bob-ca.crt:/home/admin/tls/cert.crt
      - ./tls/broker_bob-ca.key:/home/admin/tls/key.key
  engine_alice:
    cap_add:
      - NET_ADMIN
    command:
      - /home/admin/bin/scqlengine
      - --flagfile=/home/admin/engine/conf/gflags.conf
    image: ${SCQL_IMAGE:-secretflow/scql:latest}
    volumes:
      - ./engine/alice/conf/gflags.conf:/home/admin/engine/conf/gflags.conf
      - ./tls/engine_alice-ca.crt:/home/admin/engine/conf/cert.crt
      - ./tls/engine_alice-ca.key:/home/admin/engine/conf/key.key
  engine_bob:
    cap_add:
      - NET_ADMIN
    command:
      - /home/admin/bin/scqlengine
      - --flagfile=/home/admin/engine/conf/gflags.conf
    image: ${SCQL_IMAGE:-secretflow/scql:latest}
    volumes:
      - ./engine/bob/conf/gflags.conf:/home/admin/engine/conf/gflags.conf
      - ./tls/engine_alice-ca.crt:/home/admin/engine/conf/cert.crt
      - ./tls/engine_alice-ca.key:/home/admin/engine/conf/key.key
  mysql:
    image: mysql:latest
    environment:
      - MYSQL_ROOT_PASSWORD=ewKhgJF5MwGyO
      - TZ=Asia/Shanghai
    healthcheck:
      retries: 10
      test:
        - CMD
        - mysqladmin
        - ping
        - -h
        - mysql
      timeout: 20s
    expose:
      - "3306"
    restart: always
    volumes:
      - ./mysql/initdb:/docker-entrypoint-initdb.d

The text was updated successfully, but these errors were encountered:

wangzul · 2024-10-29T03:21:32Z

2个broker_bob的docker日志提供一下？docker logs xxx
SCQL的使用版本文档版本分别是什么。

Repo-Zhuang · 2024-10-29T03:33:00Z

scql下载的版本是vldb2024那条分支，文档版本是0.9.1b1

两个broker的错误好像都是权限的问题

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker logs cd6b71dd4a25
2024-10-29 02:28:21.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:21.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:21.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:23.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:23.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233

[0.310ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:10:36.09','2024-10-28 03:10:36.089',101)
2024-10-29 03:10:36.10293 ERROR storage.go:146 failed to check distributed lock for owner cd6b71dd4a25:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:10:36.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:11:36.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:11:36.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'

[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:26:44.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:27:45.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml

wangzul · 2024-10-29T03:42:12Z

scql下载的版本是vldb2024那条分支，文档版本是0.9.1b1

两个broker的错误好像都是权限的问题

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker logs cd6b71dd4a25
2024-10-29 02:28:21.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:21.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:21.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:23.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:23.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233

[0.310ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:10:36.09','2024-10-28 03:10:36.089',101)
2024-10-29 03:10:36.10293 ERROR storage.go:146 failed to check distributed lock for owner cd6b71dd4a25:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:10:36.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:11:36.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:11:36.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'

[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:26:44.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:27:45.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml

日志给最新的或者完整的，不要拆开给。

Repo-Zhuang · 2024-10-29T03:45:02Z

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED             STATUS                                  PORTS                 NAMES
c58cb3f70cd2   mysql:latest             "docker-entrypoint.s…"   29 seconds ago      Up 27 seconds (health: starting)        3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   About an hour ago   Restarting (1) 58 seconds ago                                 p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   About an hour ago   Up About an hour                                              p2p-tutorial-engine_alice-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   About an hour ago   Up About an hour                                              p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   About an hour ago   Restarting (1) Less than a second ago                         p2p-tutorial-broker_bob-1
root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker logs 4f1913ed5b2b
2024-10-29 02:28:21.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:21.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:21.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:23.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:23.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:23.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:25.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:25.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:25.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:26.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:26.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:26.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:28.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:28.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:28.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:30.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:30.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:30.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:34.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:34.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:34.10292 FATAL main.go:157 Failed to create broker db: dial tcp 172.18.0.6:3306: connect: connection refused
2024-10-29 02:28:41.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:42.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[2.131ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:28:42.035','2024-10-28 02:28:42.025',101)
2024-10-29 02:28:42.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:28:42.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:28:55.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:28:55.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.683ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:28:55.474','2024-10-28 02:28:55.473',101)
2024-10-29 02:28:55.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:28:55.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:29:21.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:29:21.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.176ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:29:21.731','2024-10-28 02:29:21.73',101)
2024-10-29 02:29:21.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:29:21.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:30:13.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:30:13.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.135ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:30:13.57','2024-10-28 02:30:13.569',101)
2024-10-29 02:30:13.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:30:13.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:31:14.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:31:14.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.277ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:31:14.058','2024-10-28 02:31:14.057',101)
2024-10-29 02:31:14.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:31:14.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:32:14.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:32:14.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.389ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:32:14.579','2024-10-28 02:32:14.578',101)
2024-10-29 02:32:14.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:32:14.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:33:15.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:33:15.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.169ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:33:15.053','2024-10-28 02:33:15.052',101)
2024-10-29 02:33:15.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:33:15.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:34:15.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:34:15.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.349ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:34:15.682','2024-10-28 02:34:15.681',101)
2024-10-29 02:34:15.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:34:15.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:35:16.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:35:16.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.766ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:35:16.218','2024-10-28 02:35:16.217',101)
2024-10-29 02:35:16.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:35:16.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:36:16.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:36:16.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.222ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:36:16.747','2024-10-28 02:36:16.746',101)
2024-10-29 02:36:16.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:36:16.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:37:17.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:37:17.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.302ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:37:17.217','2024-10-28 02:37:17.216',101)
2024-10-29 02:37:17.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:37:17.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:38:17.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:38:17.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.272ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:38:17.786','2024-10-28 02:38:17.785',101)
2024-10-29 02:38:17.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:38:17.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:39:18.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:39:18.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.471ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:39:18.329','2024-10-28 02:39:18.328',101)
2024-10-29 02:39:18.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:39:18.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:40:18.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:40:18.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.131ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:40:18.895','2024-10-28 02:40:18.894',101)
2024-10-29 02:40:18.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:40:18.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:41:19.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:41:19.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.334ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:41:19.369','2024-10-28 02:41:19.368',101)
2024-10-29 02:41:19.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:41:19.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:42:19.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:42:19.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.396ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:42:19.861','2024-10-28 02:42:19.86',101)
2024-10-29 02:42:19.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:42:19.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:43:20.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:43:20.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.343ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:43:20.452','2024-10-28 02:43:20.451',101)
2024-10-29 02:43:20.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:43:20.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:44:20.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:44:21.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.141ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:44:21.007','2024-10-28 02:44:21.007',101)
2024-10-29 02:44:21.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:44:21.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:45:21.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:45:21.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.367ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:45:21.501','2024-10-28 02:45:21.5',101)
2024-10-29 02:45:21.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:45:21.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:46:21.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:46:21.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.250ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:46:21.977','2024-10-28 02:46:21.976',101)
2024-10-29 02:46:21.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:46:21.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:47:22.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:47:22.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.457ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:47:22.544','2024-10-28 02:47:22.543',101)
2024-10-29 02:47:22.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:47:22.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:48:23.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:48:23.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.227ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:48:23.118','2024-10-28 02:48:23.117',101)
2024-10-29 02:48:23.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:48:23.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:49:23.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:49:23.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.242ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:49:23.6','2024-10-28 02:49:23.599',101)
2024-10-29 02:49:23.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:49:23.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:50:24.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:50:24.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.412ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:50:24.259','2024-10-28 02:50:24.258',101)
2024-10-29 02:50:24.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:50:24.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:51:24.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:51:24.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.353ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:51:24.767','2024-10-28 02:51:24.766',101)
2024-10-29 02:51:24.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:51:24.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:52:25.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:52:25.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.456ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:52:25.252','2024-10-28 02:52:25.251',101)
2024-10-29 02:52:25.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:52:25.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:53:25.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:53:25.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.218ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:53:25.745','2024-10-28 02:53:25.744',101)
2024-10-29 02:53:25.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:53:25.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:54:26.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:54:26.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.424ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:54:26.195','2024-10-28 02:54:26.194',101)
2024-10-29 02:54:26.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:54:26.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:55:26.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:55:26.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.245ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:55:26.778','2024-10-28 02:55:26.777',101)
2024-10-29 02:55:26.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:55:26.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:56:27.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:56:27.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.303ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:56:27.264','2024-10-28 02:56:27.263',101)
2024-10-29 02:56:27.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:56:27.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:57:27.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:57:27.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.199ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:57:27.728','2024-10-28 02:57:27.728',101)
2024-10-29 02:57:27.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:57:27.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:58:28.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:58:28.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.347ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:58:28.289','2024-10-28 02:58:28.288',101)
2024-10-29 02:58:28.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:58:28.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:59:28.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 02:59:28.10292 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.329ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 02:59:28.851','2024-10-28 02:59:28.849',101)
2024-10-29 02:59:28.10292 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 02:59:28.10292 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:00:29.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:00:29.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.300ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:00:29.355','2024-10-28 03:00:29.354',101)
2024-10-29 03:00:29.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:00:29.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:01:29.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:01:29.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.276ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:01:29.834','2024-10-28 03:01:29.833',101)
2024-10-29 03:01:29.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:01:29.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:02:30.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:02:30.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.333ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:02:30.402','2024-10-28 03:02:30.401',101)
2024-10-29 03:02:30.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:02:30.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:03:30.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:03:30.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.358ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:03:30.888','2024-10-28 03:03:30.887',101)
2024-10-29 03:03:30.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:03:30.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:04:31.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:04:31.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.279ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:04:31.466','2024-10-28 03:04:31.465',101)
2024-10-29 03:04:31.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:04:31.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:05:31.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:05:31.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.281ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:05:31.928','2024-10-28 03:05:31.927',101)
2024-10-29 03:05:31.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:05:31.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:06:32.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:06:32.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.344ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:06:32.473','2024-10-28 03:06:32.472',101)
2024-10-29 03:06:32.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:06:32.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:07:32.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:07:32.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.281ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:07:32.96','2024-10-28 03:07:32.959',101)
2024-10-29 03:07:32.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:07:32.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:08:33.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:08:33.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.284ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:08:33.425','2024-10-28 03:08:33.424',101)
2024-10-29 03:08:33.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:08:33.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:09:34.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:09:34.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.330ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:09:34.078','2024-10-28 03:09:34.077',101)
2024-10-29 03:09:34.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:09:34.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:10:34.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:10:34.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.311ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:10:34.711','2024-10-28 03:10:34.71',101)
2024-10-29 03:10:34.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:10:34.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:11:35.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:11:35.10293 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.421ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-29 03:11:35.363','2024-10-28 03:11:35.362',101)
2024-10-29 03:11:35.10293 ERROR storage.go:146 failed to check distributed lock for owner 4f1913ed5b2b:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:11:35.10293 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-29 03:12:35.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:12:35.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:12:35.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:13:36.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:13:36.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:13:36.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:14:36.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:14:36.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:14:36.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:15:37.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:15:37.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:15:37.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:16:37.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:16:37.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:16:37.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:17:38.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:17:38.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:17:38.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:18:38.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:18:38.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:18:38.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:19:39.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:19:39.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:19:39.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:20:39.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:20:39.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:20:39.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:21:40.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:21:40.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:21:40.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:22:40.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:22:40.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:22:40.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:23:41.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:23:41.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:23:41.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:24:41.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:24:41.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:24:41.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:25:42.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:25:42.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:25:42.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:26:42.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:26:42.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:26:42.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:27:43.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:27:43.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:27:43.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:28:43.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:28:43.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:28:43.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:29:44.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:29:44.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:29:44.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:30:44.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:30:44.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:30:44.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:31:45.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:31:45.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:31:45.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:32:45.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:32:45.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:32:45.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:33:46.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:33:46.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:33:46.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:34:46.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:34:46.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:34:46.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:35:47.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:35:47.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:35:47.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:36:47.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:36:47.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:36:47.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:37:48.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:37:48.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:37:48.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:38:48.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:38:48.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:38:48.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:39:49.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:39:49.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:39:49.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:40:49.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:40:49.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:40:49.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:41:50.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:41:50.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:41:50.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:42:50.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:42:50.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:42:50.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.2' (using password: YES)
2024-10-29 03:43:51.10293 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 03:43:51.10293 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.5' (using password: YES)
2024-10-29 03:43:51.10293 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.5' (using password: YES)

wangzul · 2024-10-29T03:49:45Z

你尝试访问一下mysql是否能够正常访问。

Repo-Zhuang · 2024-10-29T03:55:50Z

是指本机的mysql吗

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.39-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL>

wangzul · 2024-10-29T03:58:18Z

是指本机的mysql吗

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.39-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL>

SCQLBroker配置文件中配置的mysql。

Repo-Zhuang · 2024-10-29T04:09:57Z

p2p-tutorial-mysql容器是可以访问的，但是mysql用不了，我用的是docker-compose.yml里MYSQL_ROOT_PASSWORD=ewKhgJF5MwGyO的密码

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker exec -it p2p-tutorial-mysql-1 bash
bash-5.1# mysql -u root -pewKhgJF5MwGyO
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
bash-5.1#

wangzul · 2024-10-29T06:41:25Z

p2p-tutorial-mysql容器是可以访问的，但是mysql用不了，我用的是docker-compose.yml里MYSQL_ROOT_PASSWORD=ewKhgJF5MwGyO的密码

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker exec -it p2p-tutorial-mysql-1 bash
bash-5.1# mysql -u root -pewKhgJF5MwGyO
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
bash-5.1#

mysql -u root -p 不要输入密码，等待提示输入密码时再输入。

Repo-Zhuang · 2024-10-29T06:47:32Z

等待提示输入密码时再输入ewKhgJF5MwGyO也不行

CONTAINER ID   IMAGE                    COMMAND                   CREATED       STATUS                            PORTS                 NAMES
c58cb3f70cd2   mysql:latest             "docker-entrypoint.s…"   3 hours ago   Up 6 seconds (health: starting)   3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   4 hours ago   Restarting (1) 4 seconds ago                            p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   4 hours ago   Up 4 hours                                              p2p-tutorial-engine_alice-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   4 hours ago   Up 4 hours                                              p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   4 hours ago   Restarting (1) 8 seconds ago                            p2p-tutorial-broker_bob-1
root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker exec -it p2p-tutorial-mysql-1 bash
bash-5.1# mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
bash-5.1# mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
bash-5.1#

wangzul · 2024-10-29T06:52:47Z

docker logs p2p-tutorial-mysql-1 看一下日志

Repo-Zhuang · 2024-10-29T06:54:17Z

root@zhuang-virtual-machine:/home/zhuang/workplace/scql/examples/p2p-tutorial# docker logs p2p-tutorial-mysql-1
2024-10-29 11:43:25+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
2024-10-29 11:43:25+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-10-29 11:43:25+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-10-29T03:43:25.782567Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-10-29T03:43:26.086484Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.1.0) starting as process 1
2024-10-29T03:43:26.093714Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-29T03:43:26.599526Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-29T03:43:27.001858Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-10-29T03:43:27.001896Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-10-29T03:43:27.006290Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-10-29T03:43:27.095039Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.1.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2024-10-29T03:43:27.095098Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-10-29T06:45:29.481835Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 9.1.0).
2024-10-29T06:45:30.368834Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.1.0)  MySQL Community Server - GPL.
2024-10-29T06:45:30.368911Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-10-29 14:45:30+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
2024-10-29 14:45:31+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-10-29 14:45:31+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-10-29T06:45:31.671738Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-10-29T06:45:31.969634Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.1.0) starting as process 1
2024-10-29T06:45:31.977150Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-29T06:45:32.398808Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-29T06:45:32.769419Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-10-29T06:45:32.769492Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-10-29T06:45:32.774754Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-10-29T06:45:32.836901Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-10-29T06:45:32.837082Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.1.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.

wangzul · 2024-10-29T07:10:12Z

尝试删除已有的mysql docker rm -f p2p-tutorial-mysql-1使用方向命令重新创建一个数据库
docker run --name p2p-tutorial-mysql-1 --restart unless-stopped -p 3306:3306 -v /xxxx/绝对路径/mysql/initdb:/docker-entrypoint-initdb.d -e MYSQL_ROOT_PASSWORD=ewKhgJF5MwGyO -d mysql

Repo-Zhuang · 2024-10-29T07:28:53Z

谢谢，现在可以连接mysql了。重启broker后也能进去了

root@zhuang-virtual-machine:/home/zhuang/workplace/scql# docker exec -it  p2p-tutorial-mysql-1 bash
bash-5.1# mysql -uroot -pewKhgJF5MwGyO
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 9.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Repo-Zhuang · 2024-10-29T07:43:17Z

现在broker会自动重启且不能重启正确,需要我手动重启。

root@zhuang-virtual-machine:/home/zhuang/workplace/scql# docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS          PORTS                               NAMES
91455421dff0   mysql                    "docker-entrypoint.s…"   13 minutes ago   Up 13 minutes   0.0.0.0:3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Up 6 seconds    0.0.0.0:8081->8080/tcp              p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                          p2p-tutorial-engine_alice-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                          p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Up 8 seconds    0.0.0.0:8082->8080/tcp              p2p-tutorial-broker_bob-1
root@zhuang-virtual-machine:/home/zhuang/workplace/scql# docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS                        PORTS                               NAMES
91455421dff0   mysql                    "docker-entrypoint.s…"   13 minutes ago   Up 13 minutes                 0.0.0.0:3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Up 8 seconds                  0.0.0.0:8081->8080/tcp              p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                                        p2p-tutorial-engine_alice-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                                        p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Restarting (1) 1 second ago                                       p2p-tutorial-broker_bob-1
root@zhuang-virtual-machine:/home/zhuang/workplace/scql# docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS                          PORTS                               NAMES
91455421dff0   mysql                    "docker-entrypoint.s…"   14 minutes ago   Up 14 minutes                   0.0.0.0:3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Restarting (1) 7 seconds ago                                        p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                                          p2p-tutorial-engine_alice-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                                          p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Restarting (1) 26 seconds ago                                       p2p-tutorial-broker_bob-1
root@zhuang-virtual-machine:/home/zhuang/workplace/scql# docker restart p2p-tutorial-broker_alice-1
^[[Ap2p-tutorial-broker_alice-1
root@zhuang-virtual-machine:/home/zhuang/workplace/scql# docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS                          PORTS                               NAMES
91455421dff0   mysql                    "docker-entrypoint.s…"   16 minutes ago   Up 16 minutes                   0.0.0.0:3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
cd6b71dd4a25   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Up 2 seconds                    0.0.0.0:8081->8080/tcp              p2p-tutorial-broker_alice-1
c0655683d42c   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                                          p2p-tutorial-engine_alice-1
d90e6abaee72   secretflow/scql:latest   "/home/admin/bin/scq…"   5 hours ago      Up 5 hours                                                          p2p-tutorial-engine_bob-1
4f1913ed5b2b   secretflow/scql:latest   "/home/admin/bin/bro…"   5 hours ago      Restarting (1) 57 seconds ago

另外我在接着执行./brokerctl create project --project-id "demo" --host http://localhost:8081时会出现如下错误。我是在一台虚拟机上执行 P2P 部署的。

Error: CreateProject: failed to call creating project service: Post "http://localhost:8081/intra/project/create": read tcp 127.0.0.1:54674->127.0.0.1:8081: read: connection reset by peer

wangzul · 2024-10-29T07:50:13Z

配置文件我看一下gflags.conf config.yml 双方的。

Repo-Zhuang · 2024-10-29T13:41:56Z

alice gflags.conf

--listen_port=8003
--enable_separate_link_port=true
--link_port=8004
--datasource_router=embed
--enable_driver_authorization=false
--embed_router_conf={"datasources":[{"id":"ds001","name":"mysql db","kind":"MYSQL","connection_str":"db=alice;user=root;password=fJlDNMk60WnPV;host=mysql;auto-reconnect=true"}],"rules":[{"db":"*","table":"*","datasource_id":"ds001"}]}
# party authentication flags
--enable_self_auth=false
--enable_peer_auth=false
# https flags
--server_enable_ssl=true
--server_ssl_certificate=/home/admin/engine/conf/cert.crt
--server_ssl_private_key=/home/admin/engine/conf/key.key
# set peer_engine_enable_ssl_as_client to true when peer SCQLEngine has https enabled
--peer_engine_enable_ssl_as_client=true
# set false when SCQLBroker IntraServer not enable https
--driver_enable_ssl_as_client=false

bob gflags.conf

--listen_port=8003
--enable_separate_link_port=true
--link_port=8004
--datasource_router=embed
--enable_driver_authorization=false
--embed_router_conf={"datasources":[{"id":"ds001","name":"mysql db","kind":"MYSQL","connection_str":"db=bob;user=root;password=fJlDNMk60WnPV;host=mysql;auto-reconnect=true"}],"rules":[{"db":"*","table":"*","datasource_id":"ds001"}]}
# party authentication flags
--enable_self_auth=false
--enable_peer_auth=false
# https flags
--server_enable_ssl=true
--server_ssl_certificate=/home/admin/engine/conf/cert.crt
--server_ssl_private_key=/home/admin/engine/conf/key.key
# set peer_engine_enable_ssl_as_client to true when peer SCQLEngine has https enabled
--peer_engine_enable_ssl_as_client=true
# set false when SCQLBroker IntraServer not enable https
--driver_enable_ssl_as_client=false

alice config.yml

intra_server:
  protocol: http
  host: 0.0.0.0
  port: 8080
inter_server:
  port: 8081
  protocol: https
  cert_file: "/home/admin/tls/cert.crt"
  key_file: "/home/admin/tls/key.key"
log_level: debug
party_code: alice
party_info_file: "/home/admin/configs/party_info.json"
private_key_path: "/home/admin/configs/private_key.pem"
intra_host: broker_alice:8080
engine:
  timeout: 120s
  protocol: https
  content_type: application/json
  uris:
    - for_peer: engine_alice:8004
      for_self: engine_alice:8003
storage:
  type: mysql
  conn_str: "root:fJlDNMk60WnPV@tcp(mysql:3306)/brokeralice?charset=utf8mb4&parseTime=True&loc=Local&interpolateParams=true"
  max_idle_conns: 10
  max_open_conns: 100
  conn_max_idle_time: 2m
  conn_max_lifetime: 5m

bob config.yml

intra_server:
  protocol: http
  host: 0.0.0.0
  port: 8080
inter_server:
  port: 8081
  protocol: https
  cert_file: "/home/admin/tls/cert.crt"
  key_file: "/home/admin/tls/key.key"
log_level: debug
party_code: bob
party_info_file: "/home/admin/configs/party_info.json"
private_key_path: "/home/admin/configs/private_key.pem"
intra_host: broker_bob:8080
engine:
  timeout: 120s
  protocol: https
  content_type: application/json
  uris:
    - for_peer: engine_bob:8004
      for_self: engine_bob:8003
storage:
  type: mysql
  conn_str: "root:fJlDNMk60WnPV@tcp(mysql:3306)/brokerbob?charset=utf8mb4&parseTime=True&loc=Local&interpolateParams=true"
  max_idle_conns: 10
  max_open_conns: 100
  conn_max_idle_time: 2m
  conn_max_lifetime: 5m

查看broker的logs有access的错误

[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.18.0.5' (using password: YES)
2024-10-29 14:05:27.10292 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.18.0.5' (using password: YES)
2024-10-29 14:06:28.10292 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-29 14:06:36.10292 INFO logger.go:148 /root/project/cmd/broker/main.go:233

wangzul · 2024-10-30T05:42:24Z

做以下修改后重启docker容器
宿主机ifconfig etho获取ip
[gflags.conf]
connection_str 中host=mysql 修改为host=宿主机IP

[config.yml]
conn_str中@tcp(mysql:3306)修改为@tcp(宿主机IP:3306)

Repo-Zhuang · 2024-10-30T07:09:30Z

你好，我是在VmWare上的Ubuntu上运行，地址用的是ens33显示的192.168.133.128

修改后我删除容器重新docker compse up -d,还是不行，查看日志显示如下：

zhuang@zhuang-virtual-machine:~/workplace/scql/examples/p2p-tutorial$ ifconfig 
br-e34961e665fa: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 172.18.0.1  netmask 255.255.0.0  broadcast 172.18.255.255
        inet6 fe80::42:ceff:fe09:7ab4  prefixlen 64  scopeid 0x20<link>
        ether 02:42:ce:09:7a:b4  txqueuelen 0  (以太网)
        RX packets 498  bytes 32216 (32.2 KB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 406  bytes 50668 (50.6 KB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

docker0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 172.17.0.1  netmask 255.255.0.0  broadcast 172.17.255.255
        ether 02:42:dc:35:3f:e5  txqueuelen 0  (以太网)
        RX packets 31244  bytes 1821820 (1.8 MB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 39357  bytes 183232585 (183.2 MB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.133.128  netmask 255.255.255.0  broadcast 192.168.133.255
        inet6 fe80::b771:8523:f6cf:f461  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:99:a3:a9  txqueuelen 1000  (以太网)
        RX packets 1761479  bytes 2490681581 (2.4 GB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 417879  bytes 50525537 (50.5 MB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
        inet 127.0.0.1  netmask 255.0.0.0
        inet6 ::1  prefixlen 128  scopeid 0x10<host>
        loop  txqueuelen 1000  (本地环回)
        RX packets 226027  bytes 95390845 (95.3 MB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 226027  bytes 95390845 (95.3 MB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

veth595b98a: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet6 fe80::7846:7eff:fea7:8d2  prefixlen 64  scopeid 0x20<link>
        ether 7a:46:7e:a7:08:d2  txqueuelen 0  (以太网)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 401  bytes 28398 (28.3 KB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

veth6b28397: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet6 fe80::9428:6aff:fe7a:3f34  prefixlen 64  scopeid 0x20<link>
        ether 96:28:6a:7a:3f:34  txqueuelen 0  (以太网)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 403  bytes 28618 (28.6 KB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

vethed84d1a: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet6 fe80::64b4:23ff:fef8:c476  prefixlen 64  scopeid 0x20<link>
        ether 66:b4:23:f8:c4:76  txqueuelen 0  (以太网)
        RX packets 50  bytes 7020 (7.0 KB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 73  bytes 9386 (9.3 KB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

zhuang@zhuang-virtual-machine:~/workplace/scql/examples/p2p-tutorial$ docker logs p2p-tutorial-broker_alice-1 
2024-10-30 06:59:54.10306 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 06:59:54.10306 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:54.10306 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:55.10306 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 06:59:55.10306 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:55.10306 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:56.10306 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 06:59:56.10306 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:56.10306 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:58.10306 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 06:59:58.10306 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:58.10306 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:59.10306 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 06:59:59.10306 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 06:59:59.10306 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:01.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:00:01.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:01.10307 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:05.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:00:05.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:05.10307 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:12.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:00:12.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:12.10307 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:25.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:00:25.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:25.10307 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:51.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:00:51.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:00:51.10307 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 07:01:43.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:01:43.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 07:01:43.10307 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 07:02:44.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:02:44.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 07:02:44.10307 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 07:03:44.10307 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 07:03:44.10307 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 07:03:44.10307 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)

wangzul · 2024-10-30T07:23:24Z

检查mysql数据库密码是否正确。
登陆mysql后
#授权
GRANT ALL PRIVILEGES ON . TO 'root'@'你的ip' IDENTIFIED BY '密码' WITH GRANT OPTION;
#刷新权限；
FLUSH PRIVILEGES;

然后重试

Repo-Zhuang · 2024-10-30T08:21:32Z

我修改了config.yml里
conn_str: "root:D6fWp6cC6wO6q@tcp(192.168.133.128:3306)/brokerbob?charset=utf8mb4&parseTime=True&loc=Local&interpolateParams=true"里的D6fWp6cC6wO6q改成ewKhgJF5MwGyO，重启后好像就没有连接问题了，错误变成了

zhuang@zhuang-virtual-machine:~/workplace/scql/examples/p2p-tutorial$ docker logs p2p-tutorial-broker_alice-1 
2024-10-30 08:02:35.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:35.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:35.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:37.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:37.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:37.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:38.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:38.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:38.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:39.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:39.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:39.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:41.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:41.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:41.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:43.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:43.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:43.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:47.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:47.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:47.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:55.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:02:55.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:02:55.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:03:08.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:03:08.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:03:08.10308 FATAL main.go:157 Failed to create broker db: dial tcp 192.168.133.128:3306: connect: connection refused
2024-10-30 08:03:34.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
[mysql] 2024/10/30 08:03:34 packets.go:37: unexpected EOF
[mysql] 2024/10/30 08:03:34 packets.go:37: unexpected EOF
2024-10-30 08:03:34.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error driver: bad connection
2024-10-30 08:03:34.10308 FATAL main.go:157 Failed to create broker db: driver: bad connection
[mysql] 2024/10/30 08:03:34 packets.go:37: unexpected EOF
2024-10-30 08:04:06.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:06.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.504ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:06.688','2024-10-29 08:04:06.678',101)
2024-10-30 08:04:06.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:06.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:07.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:07.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.238ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:07.277','2024-10-29 08:04:07.276',101)
2024-10-30 08:04:07.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:07.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:08.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:08.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.738ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:08.053','2024-10-29 08:04:08.052',101)
2024-10-30 08:04:08.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:08.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:08.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:08.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.619ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:08.944','2024-10-29 08:04:08.942',101)
2024-10-30 08:04:08.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:08.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:10.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:10.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.705ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:10.27','2024-10-29 08:04:10.268',101)
2024-10-30 08:04:10.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:10.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:12.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:12.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.544ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:12.335','2024-10-29 08:04:12.334',101)
2024-10-30 08:04:12.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:12.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:15.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:16.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.276ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:16.011','2024-10-29 08:04:16.01',101)
2024-10-30 08:04:16.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:16.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:22.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:22.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.815ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:22.89','2024-10-29 08:04:22.889',101)
2024-10-30 08:04:22.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:22.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:36.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:04:36.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.595ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:04:36.148','2024-10-29 08:04:36.147',101)
2024-10-30 08:04:36.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:04:36.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:02.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:02.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.832ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:02.244','2024-10-29 08:05:02.242',101)
2024-10-30 08:05:02.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:02.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:23.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:23.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.362ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:23.572','2024-10-29 08:05:23.571',101)
2024-10-30 08:05:23.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:23.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:24.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:24.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.273ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:24.106','2024-10-29 08:05:24.105',101)
2024-10-30 08:05:24.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:24.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:24.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:24.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[1.014ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:24.753','2024-10-29 08:05:24.752',101)
2024-10-30 08:05:24.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:24.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:25.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:25.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.528ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:25.651','2024-10-29 08:05:25.65',101)
2024-10-30 08:05:25.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:25.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:27.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:27.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.275ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:27.224','2024-10-29 08:05:27.223',101)
2024-10-30 08:05:27.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:27.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:29.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:29.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.553ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:29.273','2024-10-29 08:05:29.271',101)
2024-10-30 08:05:29.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:29.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:32.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:32.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.555ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:32.964','2024-10-29 08:05:32.962',101)
2024-10-30 08:05:32.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:32.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:39.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:39.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.584ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:39.789','2024-10-29 08:05:39.788',101)
2024-10-30 08:05:39.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:39.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:53.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:05:53.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.368ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:05:53.114','2024-10-29 08:05:53.113',101)
2024-10-30 08:05:53.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:05:53.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:19.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:19.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.708ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:19.193','2024-10-29 08:06:19.192',101)
2024-10-30 08:06:19.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:19.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:26.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:26.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:26.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:26.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:26.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:26.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:27.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:27.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:27.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:28.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:28.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:28.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:29.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:29.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:29.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:31.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:31.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:31.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:35.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:35.10308 INFO logger.go:148 /root/project/cmd/broker/main.go:233
[error] failed to initialize database, got error Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:35.10308 FATAL main.go:157 Failed to create broker db: Error 1045: Access denied for user 'root'@'172.17.0.1' (using password: YES)
2024-10-30 08:06:42.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:43.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.267ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:43.018','2024-10-29 08:06:43.017',101)
2024-10-30 08:06:43.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:43.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:43.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:43.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.688ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:43.653','2024-10-29 08:06:43.652',101)
2024-10-30 08:06:43.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:43.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:44.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:44.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.512ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:44.324','2024-10-29 08:06:44.323',101)
2024-10-30 08:06:44.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:44.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:45.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:45.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.378ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:45.228','2024-10-29 08:06:45.227',101)
2024-10-30 08:06:45.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:45.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:46.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:46.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[1.132ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:46.487','2024-10-29 08:06:46.486',101)
2024-10-30 08:06:46.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:46.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:48.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:48.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.533ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:48.56','2024-10-29 08:06:48.559',101)
2024-10-30 08:06:48.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:48.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:52.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:52.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.492ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:52.316','2024-10-29 08:06:52.315',101)
2024-10-30 08:06:52.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:52.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:59.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:06:59.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.529ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:06:59.193','2024-10-29 08:06:59.192',101)
2024-10-30 08:06:59.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:06:59.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:12.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:12.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.620ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:12.443','2024-10-29 08:07:12.442',101)
2024-10-30 08:07:12.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:12.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:38.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:38.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.608ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:38.553','2024-10-29 08:07:38.552',101)
2024-10-30 08:07:38.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:38.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:50.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:50.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.637ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:50.783','2024-10-29 08:07:50.782',101)
2024-10-30 08:07:50.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:50.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:51.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:51.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.410ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:51.391','2024-10-29 08:07:51.39',101)
2024-10-30 08:07:51.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:51.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:52.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:52.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.732ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:52.08','2024-10-29 08:07:52.079',101)
2024-10-30 08:07:52.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:52.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:52.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:52.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.770ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:52.955','2024-10-29 08:07:52.953',101)
2024-10-30 08:07:52.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:52.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:54.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:54.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.574ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:54.272','2024-10-29 08:07:54.271',101)
2024-10-30 08:07:54.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:54.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:56.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:07:56.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.465ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:07:56.394','2024-10-29 08:07:56.393',101)
2024-10-30 08:07:56.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:07:56.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:00.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:08:00.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.671ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:08:00.134','2024-10-29 08:08:00.133',101)
2024-10-30 08:08:00.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:00.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:07.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:08:07.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[2.038ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:08:07.086','2024-10-29 08:08:07.085',101)
2024-10-30 08:08:07.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:07.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:20.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:08:20.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.823ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:08:20.381','2024-10-29 08:08:20.38',101)
2024-10-30 08:08:20.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:20.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:46.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:08:46.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.503ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:08:46.428','2024-10-29 08:08:46.427',101)
2024-10-30 08:08:46.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:08:46.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:09:38.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:09:38.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.394ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:09:38.11','2024-10-29 08:09:38.109',101)
2024-10-30 08:09:38.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:09:38.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:19.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:19.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.326ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:19.825','2024-10-29 08:10:19.824',101)
2024-10-30 08:10:19.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:19.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:20.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:20.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.963ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:20.468','2024-10-29 08:10:20.467',101)
2024-10-30 08:10:20.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:20.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:21.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:21.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.827ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:21.241','2024-10-29 08:10:21.24',101)
2024-10-30 08:10:21.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:21.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:22.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:22.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.475ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:22.185','2024-10-29 08:10:22.184',101)
2024-10-30 08:10:22.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:22.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:23.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:23.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.888ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:23.495','2024-10-29 08:10:23.493',101)
2024-10-30 08:10:23.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:23.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:25.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:25.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.403ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:25.574','2024-10-29 08:10:25.572',101)
2024-10-30 08:10:25.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:25.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:29.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:29.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.843ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:29.264','2024-10-29 08:10:29.262',101)
2024-10-30 08:10:29.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:29.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:36.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:36.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.528ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:36.237','2024-10-29 08:10:36.235',101)
2024-10-30 08:10:36.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:36.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:42.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:42.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.832ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:42.385','2024-10-29 08:10:42.383',101)
2024-10-30 08:10:42.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:42.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:43.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:43.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.509ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:43.103','2024-10-29 08:10:43.101',101)
2024-10-30 08:10:43.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:43.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:43.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:43.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.489ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:43.791','2024-10-29 08:10:43.79',101)
2024-10-30 08:10:43.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:43.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:44.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:44.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.925ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:44.767','2024-10-29 08:10:44.766',101)
2024-10-30 08:10:44.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:44.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:45.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:46.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[1.706ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:46.026','2024-10-29 08:10:46.025',101)
2024-10-30 08:10:46.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:46.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:48.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:48.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[1.266ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:48.181','2024-10-29 08:10:48.179',101)
2024-10-30 08:10:48.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:48.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:51.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:51.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.182ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:51.864','2024-10-29 08:10:51.864',101)
2024-10-30 08:10:51.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:51.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:58.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:10:58.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.662ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:10:58.759','2024-10-29 08:10:58.758',101)
2024-10-30 08:10:58.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:10:58.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:11:12.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:11:12.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.490ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:11:12.162','2024-10-29 08:11:12.161',101)
2024-10-30 08:11:12.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:11:12.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:11:38.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:11:38.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.658ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:11:38.418','2024-10-29 08:11:38.417',101)
2024-10-30 08:11:38.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:11:38.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:12:30.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:12:30.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.503ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:12:30.095','2024-10-29 08:12:30.094',101)
2024-10-30 08:12:30.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:12:30.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:13:30.10308 INFO main.go:98 Starting to read config file: /home/admin/configs/config.yml
2024-10-30 08:13:30.10308 INFO logger.go:167 /root/project/pkg/broker/storage/session.go:116 Error 1054: Unknown column 'expired_at' in 'field list'
[0.476ms] [rows:0] INSERT INTO `locks` (`owner`,`updated_at`,`expired_at`,`id`) VALUES ('','2024-10-30 08:13:30.56','2024-10-29 08:13:30.559',101)
2024-10-30 08:13:30.10308 ERROR storage.go:146 failed to check distributed lock for owner 6f9358094161:Error 1054: Unknown column 'expired_at' in 'field list'
2024-10-30 08:13:30.10308 FATAL main.go:175 Failed to create app: failed to create jobwatcher: fail to start scheduled jobs: fail to create distributed elector: fail to create distributed locker 101: failed to check distributed lock:Error 1054: Unknown column 'expired_at' in 'field list'

下面是我登陆mysql后进行授权的过程

mysql> SELECT user, host FROM mysql.user WHERE user='root';
+------+-----------+
| user | host      |
+------+-----------+
| root | %         |
| root | localhost |
+------+-----------+
2 rows in set (0.00 sec)

mysql> CREATE USER 'root'@'192.168.133.128';
Query OK, 0 rows affected (0.02 sec)

mysql> ALTER USER 'root'@'192.168.133.128' IDENTIFIED BY 'ewKhgJF5MwGyO';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.133.128' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT user, host FROM mysql.user WHERE user='root';
+------+-----------------+
| user | host            |
+------+-----------------+
| root | %               |
| root | 192.168.133.128 |
| root | localhost       |
+------+-----------------+
3 rows in set (0.00 sec)

重启broker后马上就掉了

zhuang@zhuang-virtual-machine:~/workplace/scql/examples/p2p-tutorial$ docker restart p2p-tutorial-broker_alice-1 
p2p-tutorial-broker_alice-1
zhuang@zhuang-virtual-machine:~/workplace/scql/examples/p2p-tutorial$ docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS                          PORTS                                                  NAMES
d98106383f43   mysql                    "docker-entrypoint.s…"   15 minutes ago   Up 15 minutes                   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
6f9358094161   secretflow/scql:latest   "/home/admin/bin/bro…"   25 minutes ago   Up Less than a second           0.0.0.0:8081->8080/tcp, [::]:8081->8080/tcp            p2p-tutorial-broker_alice-1
4c47d79e30e0   secretflow/scql:latest   "/home/admin/bin/bro…"   25 minutes ago   Restarting (1) 47 seconds ago                                                          p2p-tutorial-broker_bob-1
8fa3b494efc1   secretflow/scql:latest   "/home/admin/bin/scq…"   20 hours ago     Up 8 minutes                                                                           p2p-tutorial-engine_alice-1
b06d42443412   secretflow/scql:latest   "/home/admin/bin/scq…"   20 hours ago     Up 20 hours                                                                            p2p-tutorial-engine_bob-1
zhuang@zhuang-virtual-machine:~/workplace/scql/examples/p2p-tutorial$ docker ps
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS                                  PORTS                                                  NAMES
d98106383f43   mysql                    "docker-entrypoint.s…"   15 minutes ago   Up 15 minutes                           0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
6f9358094161   secretflow/scql:latest   "/home/admin/bin/bro…"   25 minutes ago   Restarting (1) Less than a second ago                                                          p2p-tutorial-broker_alice-1
4c47d79e30e0   secretflow/scql:latest   "/home/admin/bin/bro…"   25 minutes ago   Restarting (1) 49 seconds ago                                                                  p2p-tutorial-broker_bob-1
8fa3b494efc1   secretflow/scql:latest   "/home/admin/bin/scq…"   20 hours ago     Up 8 minutes                                                                                   p2p-tutorial-engine_alice-1
b06d42443412   secretflow/scql:latest   "/home/admin/bin/scq…"   20 hours ago     Up 20 hours

wangzul · 2024-10-31T03:00:29Z

初始化数据这一步做了吗

Repo-Zhuang · 2024-10-31T08:03:11Z

你好，我是在一台机器上部署的，参考的是 https://www.secretflow.org.cn/zh-CN/docs/scql/0.9.1b1/intro/p2p-tutorial 里的教程。没有执行多机部署给出的步骤。这两个对应的sql文件我看都在/home/zhuang/workplace/scql/examples/p2p-tutorial/mysql/initdb/alice_init.sql下有。

wangzul · 2024-10-31T08:23:18Z

你好，我是在一台机器上部署的，参考的是 https://www.secretflow.org.cn/zh-CN/docs/scql/0.9.1b1/intro/p2p-tutorial 里的教程。没有执行多机部署给出的步骤。这两个对应的sql文件我看都在/home/zhuang/workplace/scql/examples/p2p-tutorial/mysql/initdb/alice_init.sql下有。

你查一下brokeralice & brokerabob 中的locks表结构
SHOW COLUMNS FROM locks

Repo-Zhuang · 2024-10-31T08:44:31Z

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| alice              |
| bob                |
| brokeralice        |
| brokerbob          |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
8 rows in set (0.00 sec)

mysql> SHOW COLUMNS FROM brokeralice.locks;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | tinyint     | NO   | PRI | NULL    | auto_increment |
| owner      | varchar(64) | YES  |     | NULL    |                |
| updated_at | datetime(3) | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> SHOW COLUMNS FROM brokerbob.locks;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | tinyint     | NO   | PRI | NULL    | auto_increment |
| owner      | varchar(64) | YES  |     | NULL    |                |
| updated_at | datetime(3) | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

wangzul · 2024-10-31T09:01:28Z

你的镜像版本和代码版本不一致https://github.com/secretflow/scql/blob/0.9.1b1/examples/p2p-tutorial/mysql/initdb/broker_init_alice.sql
你参照这几个sql文件修改一下数据库表的配置

Repo-Zhuang · 2024-10-31T12:02:55Z

感谢~，我修改了sql文件，现在容器可以正常启动了，我按着接教程继续执行到./brokerctl get project --host http://localhost:8081时报错了，好像protobuf版本不一致导致的。这是不是也是因为镜像版本和代码版本不一致导致的。。。我下载的代码版本是vldb2024那条分支的。我改修改哪里呢

zhuang@zhuang-virtual-machine:~/workplace/scql$ docker ps 
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS          PORTS                                                  NAMES
9679f61d5e31   mysql                    "docker-entrypoint.s…"   20 minutes ago   Up 20 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
328ea787231c   secretflow/scql:latest   "/home/admin/bin/scq…"   20 minutes ago   Up 20 minutes                                                          p2p-tutorial-engine_bob-1
eb007098a0d3   secretflow/scql:latest   "/home/admin/bin/bro…"   20 minutes ago   Up 19 minutes   0.0.0.0:8082->8080/tcp, [::]:8082->8080/tcp            p2p-tutorial-broker_bob-1
7fe1fc1d6af5   secretflow/scql:latest   "/home/admin/bin/scq…"   20 minutes ago   Up 20 minutes                                                          p2p-tutorial-engine_alice-1
03799f100b98   secretflow/scql:latest   "/home/admin/bin/bro…"   20 minutes ago   Up 19 minutes   0.0.0.0:8081->8080/tcp, [::]:8081->8080/tcp            p2p-tutorial-broker_alice-1
zhuang@zhuang-virtual-machine:~/workplace/scql$ ./brokerctl get project --host http://localhost:8081
Error: GetProject: failed to call listing project service: got unexpected error="proto: (line 1:1411): unknown field "group_by_threshold"" while unmarshal proto from content={"status":{"code":0, "message":"list projects succeed", "details":[]}, "projects":[{"project_id":"demo", "name":"", "description":"", "conf":{"spu_runtime_cfg":{"protocol":"SEMI2K", "field":"FM64", "fxp_fraction_bits":"0", "max_concurrency":0, "enable_action_trace":false, "enable_type_checker":false, "enable_pphlo_trace":false, "enable_runtime_snapshot":false, "snapshot_dump_dir":"", "enable_pphlo_profile":false, "enable_hal_profile":false, "public_random_seed":"0", "share_max_chunk_size":"0", "fxp_div_goldschmidt_iters":"0", "fxp_exp_mode":"EXP_DEFAULT", "fxp_exp_iters":"0", "fxp_log_mode":"LOG_DEFAULT", "fxp_log_iters":"0", "fxp_log_orders":"0", "sigmoid_mode":"SIGMOID_DEFAULT", "enable_lower_accuracy_rsqrt":false, "sine_cosine_iters":"0", "beaver_type":"TrustedFirstParty", "ttp_beaver_config":null, "cheetah_2pc_config":null, "trunc_allow_msb_error":false, "experimental_disable_mmul_split":false, "experimental_enable_inter_op_par":false, "experimental_enable_intra_op_par":false, "exp
Usage:
  brokerctl get {project|table [NAME1 [,NAME2]]|ccl|invitation|result} [flags]

Flags:
  -h, --help             help for get
      --job-id string    when get result, you must specify the job-id obtained after successfully creating the job
      --parties string   when get ccl, you can specify parties in format 'NAME [, NAME]', e.g: 'alice, bob'
      --tables string    when get ccl, you can specify tables in format 'NAME [, NAME]', e.g: 'ta, tb'

Global Flags:
      --host string         host to access broker, e.g: http://localhost:8080
      --project-id string   unique identifier for project
      --timeout int         timeout seconds for http requests to broker (default 1)

wangzul · 2024-11-01T02:57:31Z

感谢~，我修改了sql文件，现在容器可以正常启动了，我按着接教程继续执行到./brokerctl get project --host http://localhost:8081时报错了，好像protobuf版本不一致导致的。这是不是也是因为镜像版本和代码版本不一致导致的。。。我下载的代码版本是vldb2024那条分支的。我改修改哪里呢

zhuang@zhuang-virtual-machine:~/workplace/scql$ docker ps 
CONTAINER ID   IMAGE                    COMMAND                   CREATED          STATUS          PORTS                                                  NAMES
9679f61d5e31   mysql                    "docker-entrypoint.s…"   20 minutes ago   Up 20 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   p2p-tutorial-mysql-1
328ea787231c   secretflow/scql:latest   "/home/admin/bin/scq…"   20 minutes ago   Up 20 minutes                                                          p2p-tutorial-engine_bob-1
eb007098a0d3   secretflow/scql:latest   "/home/admin/bin/bro…"   20 minutes ago   Up 19 minutes   0.0.0.0:8082->8080/tcp, [::]:8082->8080/tcp            p2p-tutorial-broker_bob-1
7fe1fc1d6af5   secretflow/scql:latest   "/home/admin/bin/scq…"   20 minutes ago   Up 20 minutes                                                          p2p-tutorial-engine_alice-1
03799f100b98   secretflow/scql:latest   "/home/admin/bin/bro…"   20 minutes ago   Up 19 minutes   0.0.0.0:8081->8080/tcp, [::]:8081->8080/tcp            p2p-tutorial-broker_alice-1
zhuang@zhuang-virtual-machine:~/workplace/scql$ ./brokerctl get project --host http://localhost:8081
Error: GetProject: failed to call listing project service: got unexpected error="proto: (line 1:1411): unknown field "group_by_threshold"" while unmarshal proto from content={"status":{"code":0, "message":"list projects succeed", "details":[]}, "projects":[{"project_id":"demo", "name":"", "description":"", "conf":{"spu_runtime_cfg":{"protocol":"SEMI2K", "field":"FM64", "fxp_fraction_bits":"0", "max_concurrency":0, "enable_action_trace":false, "enable_type_checker":false, "enable_pphlo_trace":false, "enable_runtime_snapshot":false, "snapshot_dump_dir":"", "enable_pphlo_profile":false, "enable_hal_profile":false, "public_random_seed":"0", "share_max_chunk_size":"0", "fxp_div_goldschmidt_iters":"0", "fxp_exp_mode":"EXP_DEFAULT", "fxp_exp_iters":"0", "fxp_log_mode":"LOG_DEFAULT", "fxp_log_iters":"0", "fxp_log_orders":"0", "sigmoid_mode":"SIGMOID_DEFAULT", "enable_lower_accuracy_rsqrt":false, "sine_cosine_iters":"0", "beaver_type":"TrustedFirstParty", "ttp_beaver_config":null, "cheetah_2pc_config":null, "trunc_allow_msb_error":false, "experimental_disable_mmul_split":false, "experimental_enable_inter_op_par":false, "experimental_enable_intra_op_par":false, "exp
Usage:
  brokerctl get {project|table [NAME1 [,NAME2]]|ccl|invitation|result} [flags]

Flags:
  -h, --help             help for get
      --job-id string    when get result, you must specify the job-id obtained after successfully creating the job
      --parties string   when get ccl, you can specify parties in format 'NAME [, NAME]', e.g: 'alice, bob'
      --tables string    when get ccl, you can specify tables in format 'NAME [, NAME]', e.g: 'ta, tb'

Global Flags:
      --host string         host to access broker, e.g: http://localhost:8080
      --project-id string   unique identifier for project
      --timeout int         timeout seconds for http requests to broker (default 1)

建议使用tag版本和文档版本一致即可。

Repo-Zhuang closed this as completed Nov 5, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

broker容器启动问题 #385

broker容器启动问题 #385

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024 •

edited

Loading

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024 •

edited

Loading

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024 •

edited

Loading

wangzul commented Oct 30, 2024

Repo-Zhuang commented Oct 30, 2024

wangzul commented Oct 30, 2024

Repo-Zhuang commented Oct 30, 2024

wangzul commented Oct 31, 2024

Repo-Zhuang commented Oct 31, 2024

wangzul commented Oct 31, 2024

Repo-Zhuang commented Oct 31, 2024

wangzul commented Oct 31, 2024

Repo-Zhuang commented Oct 31, 2024

wangzul commented Nov 1, 2024

broker容器启动问题 #385

broker容器启动问题 #385

Comments

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024 • edited Loading

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024 • edited Loading

Repo-Zhuang commented Oct 29, 2024

wangzul commented Oct 29, 2024

Repo-Zhuang commented Oct 29, 2024 • edited Loading

wangzul commented Oct 30, 2024

Repo-Zhuang commented Oct 30, 2024

wangzul commented Oct 30, 2024

Repo-Zhuang commented Oct 30, 2024

wangzul commented Oct 31, 2024

Repo-Zhuang commented Oct 31, 2024

wangzul commented Oct 31, 2024

Repo-Zhuang commented Oct 31, 2024

wangzul commented Oct 31, 2024

Repo-Zhuang commented Oct 31, 2024

wangzul commented Nov 1, 2024

Repo-Zhuang commented Oct 29, 2024 •

edited

Loading

Repo-Zhuang commented Oct 29, 2024 •

edited

Loading

Repo-Zhuang commented Oct 29, 2024 •

edited

Loading