Hello, I am trying to deploy daptin with docker compose, and my device is raspberrypi

Try out the daptin/daptin:arm64 tag ( <a href="https:

Try out the daptin/daptin:arm64 tag ( <a

[Deploy Question]Could the official image in docker hub provide arm64 branch?,about daptin/daptin

Comments (8)

artpar commented on May 24, 2024 1

Sure that should be easy. I will create and push the arm64 docker image that do docker hub.

from daptin.

artpar commented on May 24, 2024

Try out the daptin/daptin:arm64 tag ( https://hub.docker.com/layers/daptin/daptin/arm64/images/sha256-5ffb4b22f8329cf624ef8c89697b6204e2163aa38bbe63a2c7f75c145e09c66a?context=repo )

Also, you can actually run the arm64 binary directly (the docker images are just the binaries wrapped in the docker images and nothing extra). Checkout the binaries from the latest release here

https://github.com/daptin/daptin/releases/tag/v0.9.10

from daptin.

Curious-r commented on May 24, 2024

Try out the daptin/daptin:arm64 tag ( https://hub.docker.com/layers/daptin/daptin/arm64/images/sha256-5ffb4b22f8329cf624ef8c89697b6204e2163aa38bbe63a2c7f75c145e09c66a?context=repo )

Also, you can actually run the arm64 binary directly (the docker images are just the binaries wrapped in the docker images and nothing extra). Checkout the binaries from the latest release here

https://github.com/daptin/daptin/releases/tag/v0.9.10

Thanks a lot!
The reason I use Docker Compose is that the other services are in there, which is convenient for backup and migration.

from daptin.

Curious-r commented on May 24, 2024

Ran into an issue with initialization failure, I tried to solve it without success..
Logs:

homeserver-daptin-1  | INFO[2023-03-09 19:38:08] Setting timezone to UTC since no TZ env variable set
homeserver-daptin-1  |
homeserver-daptin-1  |    GitCommit:
homeserver-daptin-1  |    GitBranch:
homeserver-daptin-1  |     GitState:
homeserver-daptin-1  |   GitSummary:
homeserver-daptin-1  |    BuildDate:
homeserver-daptin-1  |      Version:
homeserver-daptin-1  | INFO[2023-03-09 19:38:08] Runtime is release
homeserver-daptin-1  | INFO[2023-03-09 19:38:08] Database connection using: [postgres] [host=postgres-daptin port=5432 user=daptin password=testpassword1 dbname=daptin sslmode=disable]
homeserver-daptin-1  | INFO[2023-03-09 19:38:08] Database Connection Params: Max Idle Connections: [10], Max Open Connections: [50] , Max Connection Life time: [1m0s] , Max Idle Connection life time: [1m0s]
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Connection acquired from database [postgres]
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Olric bind port is: 5336
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] olric peers: []
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Olric member name: 0.0.0.0:5336 => 5336
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Olric membership address: 0.0.0.0:5336
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Load config files
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Found files to load: []
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] loading existing tables config from database
homeserver-daptin-1  |
homeserver-daptin-1  |
homeserver-daptin-1  | ===================================
homeserver-daptin-1  | ===================================
homeserver-daptin-1  |
homeserver-daptin-1  |  ____    _    ____ _____ ___ _   _
homeserver-daptin-1  | |  _ \  / \  |  _ |_   _|_ _| \ | |
homeserver-daptin-1  | | | | |/ _ \ | |_) || |  | ||  \| |
homeserver-daptin-1  | | |_| / ___ \|  __/ | |  | || |\  |
homeserver-daptin-1  | |____/_/   \_|_|    |_| |___|_| \_|
homeserver-daptin-1  |
homeserver-daptin-1  | ===================================
homeserver-daptin-1  | ===================================
homeserver-daptin-1  |
homeserver-daptin-1  |
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] [106] failed to prepare statment: pq: relation "world" does not exist
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] db resource initialise:
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] 0 state tables on base entities
homeserver-daptin-1  | +------------------+------------+--------------+---------------------+-----------------+
homeserver-daptin-1  | | Subject          | Relation   | Object       | Subject Name        | Object Name     |
homeserver-daptin-1  | +------------------+------------+--------------+---------------------+-----------------+
homeserver-daptin-1  | | document         | belongs_to | user_account | document_id         | user_account_id |
homeserver-daptin-1  | | document         | has_many   | usergroup    | document_id         | usergroup_id    |
homeserver-daptin-1  | | calendar         | belongs_to | user_account | calendar_id         | user_account_id |
homeserver-daptin-1  | | calendar         | has_many   | usergroup    | calendar_id         | usergroup_id    |
homeserver-daptin-1  | | collection       | belongs_to | user_account | collection_id       | user_account_id |
homeserver-daptin-1  | | collection       | has_many   | usergroup    | collection_id       | usergroup_id    |
homeserver-daptin-1  | | certificate      | belongs_to | user_account | certificate_id      | user_account_id |
homeserver-daptin-1  | | certificate      | has_many   | usergroup    | certificate_id      | usergroup_id    |
homeserver-daptin-1  | | feed             | belongs_to | user_account | feed_id             | user_account_id |
homeserver-daptin-1  | | feed             | has_many   | usergroup    | feed_id             | usergroup_id    |
homeserver-daptin-1  | | integration      | belongs_to | user_account | integration_id      | user_account_id |
homeserver-daptin-1  | | integration      | has_many   | usergroup    | integration_id      | usergroup_id    |
homeserver-daptin-1  | | task             | belongs_to | user_account | task_id             | user_account_id |
homeserver-daptin-1  | | task             | has_many   | usergroup    | task_id             | usergroup_id    |
homeserver-daptin-1  | | json_schema      | belongs_to | user_account | json_schema_id      | user_account_id |
homeserver-daptin-1  | | json_schema      | has_many   | usergroup    | json_schema_id      | usergroup_id    |
homeserver-daptin-1  | | timeline         | belongs_to | user_account | timeline_id         | user_account_id |
homeserver-daptin-1  | | timeline         | has_many   | usergroup    | timeline_id         | usergroup_id    |
homeserver-daptin-1  | | world            | belongs_to | user_account | world_id            | user_account_id |
homeserver-daptin-1  | | world            | has_many   | usergroup    | world_id            | usergroup_id    |
homeserver-daptin-1  | | stream           | belongs_to | user_account | stream_id           | user_account_id |
homeserver-daptin-1  | | stream           | has_many   | usergroup    | stream_id           | usergroup_id    |
homeserver-daptin-1  | | user_otp_account | belongs_to | user_account | user_otp_account_id | user_account_id |
homeserver-daptin-1  | | user_otp_account | has_many   | usergroup    | user_otp_account_id | usergroup_id    |
homeserver-daptin-1  | | user_account     | belongs_to | user_account | user_account_id     | user_account_id |
homeserver-daptin-1  | | user_account     | has_many   | usergroup    | user_account_id     | usergroup_id    |
homeserver-daptin-1  | | action           | belongs_to | user_account | action_id           | user_account_id |
homeserver-daptin-1  | | action           | has_many   | usergroup    | action_id           | usergroup_id    |
homeserver-daptin-1  | | smd              | belongs_to | user_account | smd_id              | user_account_id |
homeserver-daptin-1  | | smd              | has_many   | usergroup    | smd_id              | usergroup_id    |
homeserver-daptin-1  | | oauth_connect    | belongs_to | user_account | oauth_connect_id    | user_account_id |
homeserver-daptin-1  | | oauth_connect    | has_many   | usergroup    | oauth_connect_id    | usergroup_id    |
homeserver-daptin-1  | | data_exchange    | belongs_to | user_account | data_exchange_id    | user_account_id |
homeserver-daptin-1  | | data_exchange    | has_many   | usergroup    | data_exchange_id    | usergroup_id    |
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] 0 Audit tables are new
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] 0 Audit tables are updated
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] 0 Translation tables are new
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] 0 Translation tables are updated
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Check table document
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] create table sql: create table document (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   document_name varchar(100) not null,
homeserver-daptin-1  |   document_path varchar(2000) not null,
homeserver-daptin-1  |   document_extension varchar(50) not null,
homeserver-daptin-1  |   mime_type varchar(50) not null,
homeserver-daptin-1  |   document_content bytea not null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] [718] Failed to create table [document]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | | oauth_token      | belongs_to | user_account | oauth_token_id      | user_account_id |
homeserver-daptin-1  | | oauth_token      | has_many   | usergroup    | oauth_token_id      | usergroup_id    |
homeserver-daptin-1  | | cloud_store      | belongs_to | user_account | cloud_store_id      | user_account_id |
homeserver-daptin-1  | | cloud_store      | has_many   | usergroup    | cloud_store_id      | usergroup_id    |
homeserver-daptin-1  | | site             | belongs_to | user_account | site_id             | user_account_id |
homeserver-daptin-1  | | site             | has_many   | usergroup    | site_id             | usergroup_id    |
homeserver-daptin-1  | | mail_server      | belongs_to | user_account | mail_server_id      | user_account_id |
homeserver-daptin-1  | | mail_server      | has_many   | usergroup    | mail_server_id      | usergroup_id    |
homeserver-daptin-1  | | mail_account     | belongs_to | user_account | mail_account_id     | user_account_id |
homeserver-daptin-1  | | mail_account     | has_many   | usergroup    | mail_account_id     | usergroup_id    |
homeserver-daptin-1  | | mail_box         | belongs_to | user_account | mail_box_id         | user_account_id |
homeserver-daptin-1  | | mail_box         | has_many   | usergroup    | mail_box_id         | usergroup_id    |
homeserver-daptin-1  | | mail             | belongs_to | user_account | mail_id             | user_account_id |
homeserver-daptin-1  | | mail             | has_many   | usergroup    | mail_id             | usergroup_id    |
homeserver-daptin-1  | | outbox           | belongs_to | user_account | outbox_id           | user_account_id |
homeserver-daptin-1  | | outbox           | has_many   | usergroup    | outbox_id           | usergroup_id    |
homeserver-daptin-1  | +------------------+------------+--------------+---------------------+-----------------+
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Check table calendar
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] create table sql: create table calendar (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   rpath varchar(500) not null,
homeserver-daptin-1  |   content bytea not null,
homeserver-daptin-1  |   user_account_id INTEGER null,
homeserver-daptin-1  |   collection_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] [718] Failed to create table [calendar]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Check table collection
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] create table sql: create table collection (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   name varchar(500) not null,
homeserver-daptin-1  |   description text not null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] [718] Failed to create table [collection]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Check table certificate
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] create table sql: create table certificate (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   hostname varchar(100) not null,
homeserver-daptin-1  |   issuer varchar(100) not null default 'self',
homeserver-daptin-1  |   generated_at timestamp null,
homeserver-daptin-1  |   certificate_pem text null,
homeserver-daptin-1  |   root_certificate text null,
homeserver-daptin-1  |   private_key_pem text null,
homeserver-daptin-1  |   public_key_pem text null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] [718] Failed to create table [certificate]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-09 19:38:09] Check table feed
homeserver-daptin-1  | ERRO[2023-03-09 19:38:09] create table sql: create table feed (

My compose.yaml:

  postgres-daptin:
    image: postgres:alpine
    restart: unless-stopped
    volumes:
      - ./postgres-daptin/data/:/var/lib/postgresql/data/:rw
    environment:
      POSTGRES_USER: daptin
      POSTGRES_DB: daptin
      POSTGRES_PASSWORD: testpassword1
    networks:
      - daptin
  daptin:
    image: daptin/daptin:arm64
    restart: unless-stopped
    environment:
      DAPTIN_PORT: 8080
      DAPTIN_DB_TYPE: postgres
      DAPTIN_DB_CONNECTION_STRING: 'host=postgres-daptin port=5432 user=daptin password=testpassword1 dbname=daptin sslmode=disable'
    networks:
      - daptin
    depends_on:
      - postgres-daptin

Is this question related to TIMEZONE?
I tried setting the environment variable TZ: Asia/Shanghai, but the log says it's not a valid time zone..UTC+8 results are the same.

from daptin.

artpar commented on May 24, 2024

Can you try running it after setting the following ENV varaibles (along with the ones you have already set)

DAPTIN_SKIP_CONFIG_FROM_DATABASE: true
DAPTIN_LOG_LEVEL: trace

You wouldn't need to set this if it starts up fine. From the logs what I can understand is that first it tried to query existing tables from the database and failed there and then later on failed to create the required tables ( current transaction is aborted )

The first env variable will skip checking for existing db tables.
The second env variable will add more logs to the output (debug/trace level)

from daptin.

Curious-r commented on May 24, 2024

Can you try running it after setting the following ENV varaibles (along with the ones you have already set)
DAPTIN_SKIP_CONFIG_FROM_DATABASE: true
DAPTIN_LOG_LEVEL: trace
You wouldn't need to set this if it starts up fine. From the logs what I can understand is that first it tried to query existing tables from the database and failed there and then later on failed to create the required tables ( current transaction is aborted )

The first env variable will skip checking for existing db tables. The second env variable will add more logs to the output (debug/trace level)

The error still seems to be there, is there a problem with my database configuration?
Each test is done after the database file is purged.
New compose.yaml:

  postgres-daptin:
    image: postgres:alpine
    restart: unless-stopped
    volumes:
      - ./postgres-daptin/data/:/var/lib/postgresql/data/:rw
    environment:
      POSTGRES_USER: daptin
      POSTGRES_DB: daptin
      POSTGRES_PASSWORD: testpassword1
    networks:
      - daptin
  daptin:
    image: daptin/daptin:arm64
    restart: unless-stopped
    environment:
      DAPTIN_PORT: 8080
      DAPTIN_SKIP_CONFIG_FROM_DATABASE: true
      DAPTIN_LOG_LEVEL: trace
      DAPTIN_DB_TYPE: postgres
      DAPTIN_DB_CONNECTION_STRING: 'host=postgres-daptin port=5432 user=daptin password=testpassword1 dbname=daptin sslmode=disable'
    networks:
      - daptin
    depends_on:
      - postgres-daptin

Logs:

homeserver-daptin-1  | INFO[2023-03-10 05:54:47] Setting timezone to UTC since no TZ env variable set
homeserver-daptin-1  | INFO[2023-03-10 05:54:47] Runtime is release
homeserver-daptin-1  | INFO[2023-03-10 05:54:47] Database connection using: [postgres] [host=postgres-daptin port=5432 user=daptin password=testpassword1 dbname=daptin sslmode=disable]
homeserver-daptin-1  | INFO[2023-03-10 05:54:47] Database Connection Params: Max Idle Connections: [10], Max Open Connections: [50] , Max Connection Life time: [1m0s] , Max Idle Connection life time: [1m0s]
homeserver-daptin-1  |
homeserver-daptin-1  |    GitCommit:
homeserver-daptin-1  |    GitBranch:
homeserver-daptin-1  |     GitState:
homeserver-daptin-1  |   GitSummary:
homeserver-daptin-1  |    BuildDate:
homeserver-daptin-1  |      Version:
homeserver-daptin-1  | panic: dial tcp 172.20.0.2:5432: connect: connection refused
homeserver-daptin-1  |
homeserver-daptin-1  | goroutine 1 [running]:
homeserver-daptin-1  | github.com/jmoiron/sqlx.(*DB).MustBegin(...)
homeserver-daptin-1  |  /go/pkg/mod/github.com/jmoiron/[email protected]/sqlx.go:332
homeserver-daptin-1  | main.main()
homeserver-daptin-1  |  /source/main.go:301 +0x28a0
homeserver-daptin-1  |  INFO[2023-03-10 05:54:58] Setting timezone to UTC since no TZ env variable set
homeserver-daptin-1  |
homeserver-daptin-1  |    GitCommit:
homeserver-daptin-1  | INFO[2023-03-10 05:54:58] Runtime is release
homeserver-daptin-1  |    GitBranch:
homeserver-daptin-1  |     GitState:
homeserver-daptin-1  |   GitSummary:
homeserver-daptin-1  |    BuildDate:
homeserver-daptin-1  |      Version:
homeserver-daptin-1  | INFO[2023-03-10 05:54:58] Database connection using: [postgres] [host=postgres-daptin port=5432 user=daptin password=testpassword1 dbname=daptin sslmode=disable]
homeserver-daptin-1  | INFO[2023-03-10 05:54:58] Database Connection Params: Max Idle Connections: [10], Max Open Connections: [50] , Max Connection Life time: [1m0s] , Max Idle Connection life time: [1m0s]
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Connection acquired from database [postgres]
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Olric bind port is: 5336
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] olric peers: []
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Olric member name: 0.0.0.0:5336 => 5336
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Olric membership address: 0.0.0.0:5336
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Load config files
homeserver-daptin-1  |
homeserver-daptin-1  |
homeserver-daptin-1  | ===================================
homeserver-daptin-1  | ===================================
homeserver-daptin-1  |
homeserver-daptin-1  |  ____    _    ____ _____ ___ _   _
homeserver-daptin-1  | |  _ \  / \  |  _ |_   _|_ _| \ | |
homeserver-daptin-1  | | | | |/ _ \ | |_) || |  | ||  \| |
homeserver-daptin-1  | | |_| / ___ \|  __/ | |  | || |\  |
homeserver-daptin-1  | |____/_/   \_|_|    |_| |___|_| \_|
homeserver-daptin-1  |
homeserver-daptin-1  | ===================================
homeserver-daptin-1  | ===================================
homeserver-daptin-1  |
homeserver-daptin-1  |
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Found files to load: []
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] skip loading existing tables config from database
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] db resource initialise:
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] 0 state tables on base entities
homeserver-daptin-1  | +------------------+------------+--------------+---------------------+-----------------+
homeserver-daptin-1  | | Subject          | Relation   | Object       | Subject Name        | Object Name     |
homeserver-daptin-1  | +------------------+------------+--------------+---------------------+-----------------+
homeserver-daptin-1  | | document         | belongs_to | user_account | document_id         | user_account_id |
homeserver-daptin-1  | | document         | has_many   | usergroup    | document_id         | usergroup_id    |
homeserver-daptin-1  | | calendar         | belongs_to | user_account | calendar_id         | user_account_id |
homeserver-daptin-1  | | calendar         | has_many   | usergroup    | calendar_id         | usergroup_id    |
homeserver-daptin-1  | | collection       | belongs_to | user_account | collection_id       | user_account_id |
homeserver-daptin-1  | | collection       | has_many   | usergroup    | collection_id       | usergroup_id    |
homeserver-daptin-1  | | certificate      | belongs_to | user_account | certificate_id      | user_account_id |
homeserver-daptin-1  | | certificate      | has_many   | usergroup    | certificate_id      | usergroup_id    |
homeserver-daptin-1  | | feed             | belongs_to | user_account | feed_id             | user_account_id |
homeserver-daptin-1  | | feed             | has_many   | usergroup    | feed_id             | usergroup_id    |
homeserver-daptin-1  | | integration      | belongs_to | user_account | integration_id      | user_account_id |
homeserver-daptin-1  | | integration      | has_many   | usergroup    | integration_id      | usergroup_id    |
homeserver-daptin-1  | | task             | belongs_to | user_account | task_id             | user_account_id |
homeserver-daptin-1  | | task             | has_many   | usergroup    | task_id             | usergroup_id    |
homeserver-daptin-1  | | json_schema      | belongs_to | user_account | json_schema_id      | user_account_id |
homeserver-daptin-1  | | json_schema      | has_many   | usergroup    | json_schema_id      | usergroup_id    |
homeserver-daptin-1  | | timeline         | belongs_to | user_account | timeline_id         | user_account_id |
homeserver-daptin-1  | | timeline         | has_many   | usergroup    | timeline_id         | usergroup_id    |
homeserver-daptin-1  | | world            | belongs_to | user_account | world_id            | user_account_id |
homeserver-daptin-1  | | world            | has_many   | usergroup    | world_id            | usergroup_id    |
homeserver-daptin-1  | | stream           | belongs_to | user_account | stream_id           | user_account_id |
homeserver-daptin-1  | | stream           | has_many   | usergroup    | stream_id           | usergroup_id    |
homeserver-daptin-1  | | user_otp_account | belongs_to | user_account | user_otp_account_id | user_account_id |
homeserver-daptin-1  | | user_otp_account | has_many   | usergroup    | user_otp_account_id | usergroup_id    |
homeserver-daptin-1  | | user_account     | belongs_to | user_account | user_account_id     | user_account_id |
homeserver-daptin-1  | | user_account     | has_many   | usergroup    | user_account_id     | usergroup_id    |
homeserver-daptin-1  | | action           | belongs_to | user_account | action_id           | user_account_id |
homeserver-daptin-1  | | action           | has_many   | usergroup    | action_id           | usergroup_id    |
homeserver-daptin-1  | | smd              | belongs_to | user_account | smd_id              | user_account_id |
homeserver-daptin-1  | | smd              | has_many   | usergroup    | smd_id              | usergroup_id    |
homeserver-daptin-1  | | oauth_connect    | belongs_to | user_account | oauth_connect_id    | user_account_id |
homeserver-daptin-1  | | oauth_connect    | has_many   | usergroup    | oauth_connect_id    | usergroup_id    |
homeserver-daptin-1  | | data_exchange    | belongs_to | user_account | data_exchange_id    | user_account_id |
homeserver-daptin-1  | | data_exchange    | has_many   | usergroup    | data_exchange_id    | usergroup_id    |
homeserver-daptin-1  | | oauth_token      | belongs_to | user_account | oauth_token_id      | user_account_id |
homeserver-daptin-1  | | oauth_token      | has_many   | usergroup    | oauth_token_id      | usergroup_id    |
homeserver-daptin-1  | | cloud_store      | belongs_to | user_account | cloud_store_id      | user_account_id |
homeserver-daptin-1  | | cloud_store      | has_many   | usergroup    | cloud_store_id      | usergroup_id    |
homeserver-daptin-1  | | site             | belongs_to | user_account | site_id             | user_account_id |
homeserver-daptin-1  | | site             | has_many   | usergroup    | site_id             | usergroup_id    |
homeserver-daptin-1  | | mail_server      | belongs_to | user_account | mail_server_id      | user_account_id |
homeserver-daptin-1  | | mail_server      | has_many   | usergroup    | mail_server_id      | usergroup_id    |
homeserver-daptin-1  | | mail_account     | belongs_to | user_account | mail_account_id     | user_account_id |
homeserver-daptin-1  | | mail_account     | has_many   | usergroup    | mail_account_id     | usergroup_id    |
homeserver-daptin-1  | | mail_box         | belongs_to | user_account | mail_box_id         | user_account_id |
homeserver-daptin-1  | | mail_box         | has_many   | usergroup    | mail_box_id         | usergroup_id    |
homeserver-daptin-1  | | mail             | belongs_to | user_account | mail_id             | user_account_id |
homeserver-daptin-1  | | mail             | has_many   | usergroup    | mail_id             | usergroup_id    |
homeserver-daptin-1  | | outbox           | belongs_to | user_account | outbox_id           | user_account_id |
homeserver-daptin-1  | | outbox           | has_many   | usergroup    | outbox_id           | usergroup_id    |
homeserver-daptin-1  | +------------------+------------+--------------+---------------------+-----------------+
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] 0 Audit tables are new
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] 0 Audit tables are updated
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] 0 Translation tables are new
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] 0 Translation tables are updated
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Check table document
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Sql: select * from document limit 1
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Prepared Sql: select * from document limit 1
homeserver-daptin-1  | TRAC[2023-03-10 05:54:59] Failed to select * from document: pq: relation "document" does not exist
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Create table query: document
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] create table document (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   document_name varchar(100) not null,
homeserver-daptin-1  |   document_path varchar(2000) not null,
homeserver-daptin-1  |   document_extension varchar(50) not null,
homeserver-daptin-1  |   mime_type varchar(50) not null,
homeserver-daptin-1  |   document_content bytea not null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] create table sql: create table document (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   document_name varchar(100) not null,
homeserver-daptin-1  |   document_path varchar(2000) not null,
homeserver-daptin-1  |   document_extension varchar(50) not null,
homeserver-daptin-1  |   mime_type varchar(50) not null,
homeserver-daptin-1  |   document_content bytea not null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] [718] Failed to create table [document]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Check table calendar
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Sql: select * from calendar limit 1
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Prepared Sql: select * from calendar limit 1
homeserver-daptin-1  | TRAC[2023-03-10 05:54:59] Failed to select * from calendar: pq: relation "calendar" does not exist
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Create table query: calendar
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] create table calendar (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   rpath varchar(500) not null,
homeserver-daptin-1  |   content bytea not null,
homeserver-daptin-1  |   user_account_id INTEGER null,
homeserver-daptin-1  |   collection_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] create table sql: create table calendar (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   rpath varchar(500) not null,
homeserver-daptin-1  |   content bytea not null,
homeserver-daptin-1  |   user_account_id INTEGER null,
homeserver-daptin-1  |   collection_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] [718] Failed to create table [calendar]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Check table collection
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Sql: select * from collection limit 1
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Prepared Sql: select * from collection limit 1
homeserver-daptin-1  | TRAC[2023-03-10 05:54:59] Failed to select * from collection: pq: relation "collection" does not exist
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Create table query: collection
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] create table collection (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   name varchar(500) not null,
homeserver-daptin-1  |   description text not null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] create table sql: create table collection (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   name varchar(500) not null,
homeserver-daptin-1  |   description text not null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] [718] Failed to create table [collection]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Check table certificate
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Sql: select * from certificate limit 1
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Prepared Sql: select * from certificate limit 1
homeserver-daptin-1  | TRAC[2023-03-10 05:54:59] Failed to select * from certificate: pq: relation "certificate" does not exist
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Create table query: certificate
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] create table certificate (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   hostname varchar(100) not null,
homeserver-daptin-1  |   issuer varchar(100) not null default 'self',
homeserver-daptin-1  |   generated_at timestamp null,
homeserver-daptin-1  |   certificate_pem text null,
homeserver-daptin-1  |   root_certificate text null,
homeserver-daptin-1  |   private_key_pem text null,
homeserver-daptin-1  |   public_key_pem text null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] create table sql: create table certificate (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   hostname varchar(100) not null,
homeserver-daptin-1  |   issuer varchar(100) not null default 'self',
homeserver-daptin-1  |   generated_at timestamp null,
homeserver-daptin-1  |   certificate_pem text null,
homeserver-daptin-1  |   root_certificate text null,
homeserver-daptin-1  |   private_key_pem text null,
homeserver-daptin-1  |   public_key_pem text null,
homeserver-daptin-1  |   user_account_id INTEGER null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] [718] Failed to create table [certificate]: pq: current transaction is aborted, commands ignored until end of transaction block
homeserver-daptin-1  | INFO[2023-03-10 05:54:59] Check table feed
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Sql: select * from feed limit 1
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Prepared Sql: select * from feed limit 1
homeserver-daptin-1  | TRAC[2023-03-10 05:54:59] Failed to select * from feed: pq: relation "feed" does not exist
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] Create table query: feed
homeserver-daptin-1  | DEBU[2023-03-10 05:54:59] create table feed (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   feed_name varchar(100) not null,
homeserver-daptin-1  |   title varchar(500) not null default '',
homeserver-daptin-1  |   description text not null,
homeserver-daptin-1  |   link varchar(1000) not null default '',
homeserver-daptin-1  |   author_name varchar(500) not null default '',
homeserver-daptin-1  |   author_email varchar(500) not null default '',
homeserver-daptin-1  |   enable bool not null default false,
homeserver-daptin-1  |   enable_atom bool not null default true,
homeserver-daptin-1  |   enable_json bool not null default true,
homeserver-daptin-1  |   enable_rss bool not null default true,
homeserver-daptin-1  |   page_size INTEGER not null default 1000,
homeserver-daptin-1  |   user_account_id INTEGER null,
homeserver-daptin-1  |   stream_id INTEGER not null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] create table sql: create table feed (
homeserver-daptin-1  | id SERIAL PRIMARY KEY,
homeserver-daptin-1  |   version INTEGER not null default 1,
homeserver-daptin-1  |   created_at timestamp not null default current_timestamp,
homeserver-daptin-1  |   updated_at timestamp null,
homeserver-daptin-1  |   reference_id char(36) not null,
homeserver-daptin-1  |   permission INTEGER not null,
homeserver-daptin-1  |   feed_name varchar(100) not null,
homeserver-daptin-1  |   title varchar(500) not null default '',
homeserver-daptin-1  |   description text not null,
homeserver-daptin-1  |   link varchar(1000) not null default '',
homeserver-daptin-1  |   author_name varchar(500) not null default '',
homeserver-daptin-1  |   author_email varchar(500) not null default '',
homeserver-daptin-1  |   enable bool not null default false,
homeserver-daptin-1  |   enable_atom bool not null default true,
homeserver-daptin-1  |   enable_json bool not null default true,
homeserver-daptin-1  |   enable_rss bool not null default true,
homeserver-daptin-1  |   page_size INTEGER not null default 1000,
homeserver-daptin-1  |   user_account_id INTEGER null,
homeserver-daptin-1  |   stream_id INTEGER not null)
homeserver-daptin-1  | ERRO[2023-03-10 05:54:59] [718] Failed to create table [feed]: pq: current transaction is aborted, commands ignored until end of transaction block

from daptin.

artpar commented on May 24, 2024

Seems like a introduced a regression in the last few commits.

Have fixed it and pushed a new docker arm image on docker hub.

from daptin.

Curious-r commented on May 24, 2024

Seems like a introduced a regression in the last few commits.

Have fixed it and pushed a new docker arm image on docker hub.

It works after new image pulled, thanks for the help!

from daptin.

[Deploy Question]Could the official image in docker hub provide arm64 branch? about daptin HOT 8 CLOSED

Comments (8)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent