n8n version: 1.66.0
Datebase: PostgreSQL
n8n EXECUTIONS_PROCESS: set in docker-compose, initially set to own, this caused a startup error, setting to queue allowed the system to start but states that EXECUTIONS_PROCESS is depricated. This still produces a node runtime error.
Running n8n via: Docker - docker-compose
Operating system: Linux
The log file give the following output;
withpostgres-postgres-1 | 2024-11-12 16:22:50.095 UTC [27] LOG: checkpoint starting: time
withpostgres-postgres-1 | 2024-11-12 16:22:52.158 UTC [27] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.822 s, sync=0.052 s, total=2.063 s; sync files=16, longest=0.039 s, average=0.004 s; distance=45 kB, estimate=45 kB; lsn=0/296CB228, redo lsn=0/296CB1F0
withpostgres-n8n-1 | PayloadTooLargeError: request entity too large
withpostgres-n8n-1 | at readStream (/usr/local/lib/node_modules/n8n/node_modules/raw-body/index.js:156:17)
withpostgres-n8n-1 | at executor (/usr/local/lib/node_modules/n8n/node_modules/raw-body/index.js:113:5)
withpostgres-n8n-1 | at new Promise ()
withpostgres-n8n-1 | at getRawBody (/usr/local/lib/node_modules/n8n/node_modules/raw-body/index.js:112:10)
withpostgres-n8n-1 | at IncomingMessage.req.readRawBody (/usr/local/lib/node_modules/n8n/dist/middlewares/body-parser.js:40:56)
withpostgres-n8n-1 | at parseBody (/usr/local/lib/node_modules/n8n/dist/middlewares/body-parser.js:51:15)
withpostgres-n8n-1 | at bodyParser (/usr/local/lib/node_modules/n8n/dist/middlewares/body-parser.js:77:33)
withpostgres-n8n-1 | at newFn (/usr/local/lib/node_modules/n8n/node_modules/express-async-errors/index.js:16:20)
withpostgres-n8n-1 | at Layer.handle [as handle_request] (/usr/local/lib/node_modules/n8n/node_modules/express/lib/router/layer.js:95:5)
withpostgres-n8n-1 | at trim_prefix (/usr/local/lib/node_modules/n8n/node_modules/express/lib/router/index.js:328:13)
docker-compose;
version: ‘3.8’
volumes:
db_storage:
n8n_storage:
services:
postgres:
image: postgres:16
restart: always
environment:
- POSTGRES_USER
- POSTGRES_PASSWORD
- POSTGRES_DB
- POSTGRES_NON_ROOT_USER
- POSTGRES_NON_ROOT_PASSWORD
volumes:
- db_storage:/var/lib/postgresql/data
- ./init-data.sh:/docker-entrypoint-initdb.d/init-data.sh
healthcheck:
test: [‘CMD-SHELL’, ‘pg_isready -h localhost -U ${POSTGRES_USER} -d ${POSTGRES_DB}’]
interval: 5s
timeout: 5s
retries: 10
n8n:
image: docker.n8n.io/n8nio/n8n
restart: always
environment:
- EXECUTIONS_PROCESS=queue
- DB_TYPE=postgresdb
- DB_POSTGRESDB_HOST=postgres
- DB_POSTGRESDB_PORT=5432
- DB_POSTGRESDB_DATABASE=${POSTGRES_DB}
- DB_POSTGRESDB_USER=${POSTGRES_NON_ROOT_USER}
- DB_POSTGRESDB_PASSWORD=${POSTGRES_NON_ROOT_PASSWORD}
- N8N_BASIC_AUTH_ACTIVE=true
- N8N_DIAGNOSTICS_ENABLED=false
- N8N_USER_MANAGEMENT_DISABLED=true
- WEBHOOK_URL=https://xxx.xxx.xxx
ports:
- 5678:5678
links:
- postgres
volumes:
- n8n_storage:/home/node/.n8n
depends_on:
postgres:
condition: service_healthy
The input data is;
In his inaugural address on January 20, 1961, President John F. Kennedy delivered a powerful message emphasizing the celebration of freedom and the responsibilities of a new generation of Americans. He highlighted the challenges of the modern world, including poverty and tyranny, and called for unity in overcoming them. Kennedy pledged support for allies, efforts to assist the oppressed, and a commitment to peace through cooperation. He urged both Americans and global citizens to contribute actively to the common good, famously stating, “ask not what your country can do for you, ask what you can do for your country.” Kennedy concluded with a call for strength, sacrifice, and the pursuit of justice and freedom for all mankind, underscoring the importance of collective responsibility.
