Describe the issue/error/question
I am attempting to install n8n at digital ocean, so I used the n8n-digital-ocean repo.
I am trying to set up queue mode. I have 4 servers, a master, a worker, redis and MySQL.
I created a fresh database, started the n8n master server, and it fails to start.
What is the error message (if any)?
Initializing n8n process
query is slow: CREATE TABLE migrations (id int NOT NULL AUTO_INCREMENT, timestamp bigint NOT NULL, name varchar(255) NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB
execution time: 4522
Migration âCreateUserManagement1646992772331â failed, error: Unknown column âownerâ in âfield listâ
There was an error initializing DB: âUnknown column âownerâ in âfield listââ
Stopping n8nâŠ
Just for kicks I inserted that migration into the table like so
INSERT INTO migrations (`timestamp`,`name`) VALUES (NOW(), 'CreateUserManagement1646992772331');
It then fails with
Migration "CreateUserManagement1646992772331" failed, error: Unknown column 'owner' in 'field list'
There was an error initializing DB: "Unknown column 'owner' in 'field list'"
I stop and start the server, and it fails with
âș Error: There was an error: cannot find configuration param
âș 'userManagement.isInstanceOwnerSetUp'
I think the latest main of n8n-digital-ocean is broken, or I have magically come up with an incompatible set of env vars.
Please share the workflow
There are no yet
Information on your n8n setup
- n8n version:
- Database youâre using (default: SQLite): MYSQL
- Running n8n with the execution process [own(default), main]: Own
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: docker-compose in n8n-digital-ocean repo
Docker-Compose.yml
version: "3.7"
services:
caddy:
container_name: caddy
image: caddy:latest
restart: unless-stopped
ports:
- "80:80"
- "443:443"
volumes:
- ${DATA_FOLDER}/caddy_data:/data
- ${DATA_FOLDER}/caddy_config:/config
- ${DATA_FOLDER}/caddy_config/Caddyfile:/etc/caddy/Caddyfile
n8n:
container_name: n8n
image: n8nio/n8n
restart: always
ports:
- 5678:5678
environment:
- EXECUTIONS_PROCESS=own
- DB_TYPE=mysqldb
- DB_MYSQLDB_DATABASE=n8ndata
- DB_MYSQLDB_HOST=private-n8n-db-mysql-8-REDACTED.db.ondigitalocean.com
- DB_MYSQLDB_PORT=25060
- DB_MYSQLDB_USER=doadmin
- DB_MYSQLDB_PASSWORD=REDACTED
- N8N_BASIC_AUTH_ACTIVE=true
- N8N_BASIC_AUTH_USER=${N8N_BASIC_AUTH_USER}
- N8N_BASIC_AUTH_PASSWORD=${N8N_BASIC_AUTH_PASSWORD}
- N8N_HOST=${SUBDOMAIN}.${DOMAIN_NAME}
- N8N_PORT=5678
- N8N_PROTOCOL=https
- NODE_ENV=production
- WEBHOOK_URL=https://${SUBDOMAIN}.${DOMAIN_NAME}/
- GENERIC_TIMEZONE=${GENERIC_TIMEZONE}
- TZ=${GENERIC_TIMEZONE}
- N8N_ENCRYPTION_KEY="REDACTED^"
- N8N_EMAIL_MODE=${N8N_EMAIL_MODE}
- N8N_SMTP_HOST=${N8N_SMTP_HOST}
- N8N_SMTP_PORT=${N8N_SMTP_PORT}
- N8N_SMTP_USER=${N8N_SMTP_USER}
- N8N_SMPT_PASS=${N8N_SMTP_PASS}
- N8N_SMTP_SENDER=${N8N_SMTP_SENDER}
- N8N_SMTP_SSL=false
- EXECUTIONS_MODE=queue
- EXECUTIONS_DATA_SAVE_ON_ERROR=all
- EXECUTIONS_DATA_SAVE_ON_SUCCESS=none
- EXECUTIONS_DATA_SAVE_ON_PROGRESS=true
- EXECUTIONS_DATA_SAVE_MANUAL_EXECUTIONS=false
- EXECUTIONS_DATA_PRUNE=true
- EXECUTIONS_DATA_MAX_AGE=731
- QUEUE_BULL_REDIS_HOST=10.xxx.xxx.x
- QUEUE_BULL_REDIS_PORT=6379
volumes:
- ${DATA_FOLDER}/.n8n:/home/node/.n8n
- ${DATA_FOLDER}/local_files:/files
volumes:
caddy_data:
external: true
caddy_config: