For a moment, while an execution is running, it shows in the Execution List (with live update checked). But after the execution completes, it disappears.
Note, I don’t have any filters active in the Executions view. (it is All Exec and All Statuses)
The only structural change I’ve made is that I moved the n8n database from the sqlite to a postgres backend.
Other than the execution log, everything else seems to working fine.
Any help would be appreciated.
cheers,
Are you running n8n in Docker? If you are can you share the environment options you are setting (removing anything important like hostnames and passwords).
# Folder where data should be saved
DATA_FOLDER=/home/XXXXXX/n8n/
# The top level domain to serve from
DOMAIN_NAME=XXXXXX.com
# The subdomain to serve from
SUBDOMAIN=ZZZZZZZZZ
# DOMAIN_NAME and SUBDOMAIN combined decide where n8n will be reachable from
# above example would result in: https://n8n.example.com
# The user name to use for autentication - IMPORTANT ALWAYS CHANGE!
N8N_BASIC_AUTH_USER=XXXXXX
# The password to use for autentication - IMPORTANT ALWAYS CHANGE!
N8N_BASIC_AUTH_PASSWORD=XXXXXX
# Optional timezone to set which gets used by Cron-Node by default
# If not set New York time will be used
GENERIC_TIMEZONE=America/Vancouver
# The email address to use for the SSL certificate creation
[email protected]
# postgres info
POSTGRES_DB=XXXXXX
POSTGRES_NON_ROOT_USER=XXXXXX
POSTGRES_NON_ROOT_PASSWORD=XXXXXX
POSTGRES_HOST=XX.10.10.2
Ok. I just did a few things, so I’m not sure which of these fixed the issue.
moved .env and docker_compose into the n8n folder I specified in the .env file. and then reloaded n8n from that folder
renamed the sqlite database to database.sqlite.bak
restarted docker, and then reloaded the n8n page. the old executions were still there, so I selected all, and deleted them. When it refreshed, all the recent executions were there.
I’m not sure which of these actions fixed the issue. if it was 3, I suspect a caching issue.
Anyway it is solved now. Thank you for your help @Jon !