Docker not starting anymore after updating to latest version

Pintjes · 6 يوليو 2023، 10:40ص

Describe the problem/error/question

Ever since updating to the latest version (should be 0.234.1) my docker keeps crashing and won’t start. I have truncated the executions_entity & exectuions_metadata tables as was mentioned in another thread

Note: Jon mentioned in discord it could be a permissions error due to the last line in the error.

What is the error message (if any)?

License manager not initialized
07/06/2023 11:32:44 AM
Last session crashed
07/06/2023 11:32:55 AM
n8n ready on 0.0.0.0, port 5678
07/06/2023 11:32:55 AM
Migrations in progress, please do NOT stop the process.
07/06/2023 11:32:57 AM
ln: /home/node/.n8n: File exists

Information on your n8n setup

n8n version: 0.234.1
Database (default: SQLite): MariaDB
n8n EXECUTIONS_PROCESS setting (default: own, main):
Running n8n via (Docker, npm, n8n cloud, desktop app): docker
Operating system: Unraid

Jon · 6 يوليو 2023، 10:49ص

Hey @Pintjes,

Welcome to the community

When you launch / set up n8n on Unraid is it done through a web interface or do you just use a docker compose / docker command?

Pintjes · 6 يوليو 2023، 11:03ص

Hi Jon,
first of all thanks!
Second: unraid’s docker system is basically a GUI that interacts with docker commands. So I can add a variable just like you would using docker-compose.

Jon · 6 يوليو 2023، 11:06ص

Hey @Pintjes,

Perfect, Can you set N8N_LOG_LEVEL to debug and restart the container and send over the output.

Pintjes · 6 يوليو 2023، 11:18ص

For sure!

This is the output:

07/06/2023 1:17:23 PM
2023-07-06T11:17:23.394Z | warn     | License manager not initialized "{ file: 'License.js', function: 'isFeatureEnabled' }"
07/06/2023 1:17:23 PM
2023-07-06T11:17:23.400Z | error    | Last session crashed "{ file: 'CrashJournal.js', function: 'init' }"
07/06/2023 1:17:33 PM
2023-07-06T11:17:33.691Z | debug    | Lazy Loading credentials and nodes from n8n-nodes-base "{\n  credentials: 317,\n  nodes: 422,\n  file: 'DirectoryLoader.js',\n  function: 'loadAll'\n}"
07/06/2023 1:17:33 PM
2023-07-06T11:17:33.697Z | debug    | Can't enable lazy-loading "{ file: 'DirectoryLoader.js', function: 'loadAll' }"
07/06/2023 1:17:33 PM
2023-07-06T11:17:33.702Z | debug    | No codex available for: SplitInBatchesAdvanced.node.js "{ file: 'DirectoryLoader.js', function: 'addCodex' }"
07/06/2023 1:17:33 PM
2023-07-06T11:17:33.703Z | debug    | Loaded all credentials and nodes from n8n-nodes-splitinbatches-advanced "{\n  credentials: 0,\n  nodes: 1,\n  file: 'DirectoryLoader.js',\n  function: 'loadAll'\n}"
07/06/2023 1:17:33 PM
n8n ready on 0.0.0.0, port 5678
07/06/2023 1:17:33 PM
2023-07-06T11:17:33.963Z | warn     | Migrations in progress, please do NOT stop the process. "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
07/06/2023 1:17:33 PM
2023-07-06T11:17:33.964Z | debug    | Starting migration MigrateIntegerKeysToString1690000000001 "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"

Jon · 6 يوليو 2023، 12:26م

Hey @Pintjes,

That is interesting you are not getting the ln message this time, If it doesn’t start working eventually it could be worth restoring from a database backup.

Pintjes · 6 يوليو 2023، 12:58م

So anything I could actively try right now?

Jon · 6 يوليو 2023، 1:01م

Hey @Pintjes,

Do you have a database backup? Could you also add DEBUG with a value of * and maybe DB_LOGGING_ENABLED to true and DB_LOGGING_OPTIONS to all

Pintjes · 6 يوليو 2023، 1:17م

I had a database backup, but it’s fairly old. I do have all my workflows backup so if needed I guess I can just reinstall.

This is the output with all debug options enabled.

07/06/2023 3:12:30 PM
2023-07-06T13:12:30.499Z @oclif/config reading core plugin /usr/local/lib/node_modules/n8n
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.502Z @oclif/config loadJSON /usr/local/lib/node_modules/n8n/package.json
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.508Z @oclif/config loadJSON /usr/local/lib/node_modules/n8n/oclif.manifest.json
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.509Z @oclif/config:n8n using manifest from /usr/local/lib/node_modules/n8n/oclif.manifest.json
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.511Z @oclif/config reading user plugins pjson /home/node/.local/share/n8n/package.json
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.511Z @oclif/config loadJSON /home/node/.local/share/n8n/package.json
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.512Z @oclif/config config done
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.512Z @oclif/config start init hook
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.513Z @oclif/config init hook done
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.516Z n8n init version: @oclif/command@1.8.30 argv: [ 'start' ]
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.521Z @oclif/config runCommand start []
07/06/2023 3:12:30 PM
2023-07-06T13:12:30.522Z @oclif/config:n8n require /usr/local/lib/node_modules/n8n/dist/commands/start.js
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' <anonymous>
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:workflowId/share'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:workflowId/share'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route put '/:workflowId/share'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route patch '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/run'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/run'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/run'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' <anonymous>
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' router
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/new'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/new'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/new'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/from-url'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/from-url'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/from-url'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route patch '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route delete '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/run'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/run'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/run'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' <anonymous>
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/test'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/test'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/test'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:credentialId/share'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:credentialId/share'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route put '/:credentialId/share'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' <anonymous>
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' router
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/new'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/new'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/new'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/test'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/test'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/test'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route post '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route patch '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route delete '/:id(\\w+)'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router use '/' <anonymous>
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/auth'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/auth'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/auth'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route new '/callback'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/callback'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:route get '/callback'
07/06/2023 3:12:33 PM
Thu, 06 Jul 2023 13:12:33 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id(\\d+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id(\\d+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/:id(\\d+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id/retry'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id/retry'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/:id/retry'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/delete'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/delete'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/delete'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' router
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id(\\d+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id(\\d+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/:id(\\d+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id/retry'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id/retry'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/:id/retry'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/delete'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/delete'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/delete'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id/counts/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id/counts/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/:id/counts/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id/times/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id/times/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/:id/times/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id/data-loaded/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id/data-loaded/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/:id/data-loaded/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/activate'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/activate'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/activate'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/renew'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/renew'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/renew'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route patch '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' router
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' <anonymous>
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router use '/' router
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route post '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route get '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route patch '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:route delete '/:id(\\w+)'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:router:layer new '/'
07/06/2023 3:12:34 PM
2023-07-06T13:12:34.902Z @oclif/config start prerun hook
07/06/2023 3:12:34 PM
2023-07-06T13:12:34.902Z @oclif/config prerun hook done
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "x-powered-by" to true
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "etag" to 'weak'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "etag fn" to [Function: generateETag]
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "env" to 'production'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "query parser" to 'extended'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "query parser fn" to [Function: parseExtendedQueryString]
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "subdomain offset" to 2
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "trust proxy" to false
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "trust proxy fn" to [Function: trustNone]
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application booting in production mode
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "view" to [Function: View]
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "views" to '/data/views'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "jsonp callback name" to 'callback'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "view cache" to true
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "x-powered-by" to false
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "view engine" to 'handlebars'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "views" to '/usr/local/lib/node_modules/n8n/templates'
07/06/2023 3:12:34 PM
2023-07-06T13:12:34.912Z | warn     | License manager not initialized "{ file: 'License.js', function: 'isFeatureEnabled' }"
07/06/2023 3:12:34 PM
2023-07-06T13:12:34.916Z | error    | Last session crashed "{ file: 'CrashJournal.js', function: 'init' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.197Z | debug    | Lazy Loading credentials and nodes from n8n-nodes-base "{\n  credentials: 317,\n  nodes: 422,\n  file: 'DirectoryLoader.js',\n  function: 'loadAll'\n}"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.202Z | debug    | Can't enable lazy-loading "{ file: 'DirectoryLoader.js', function: 'loadAll' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.207Z | debug    | No codex available for: SplitInBatchesAdvanced.node.js "{ file: 'DirectoryLoader.js', function: 'addCodex' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.207Z | debug    | Loaded all credentials and nodes from n8n-nodes-splitinbatches-advanced "{\n  credentials: 0,\n  nodes: 1,\n  file: 'DirectoryLoader.js',\n  function: 'loadAll'\n}"
07/06/2023 3:12:45 PM
query: SELECT VERSION() AS `version`
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router use '/' query
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router use '/' expressInit
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:route new '/healthz'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/healthz'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:route get '/healthz'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router use '/' <anonymous>
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
n8n ready on 0.0.0.0, port 5678
07/06/2023 3:12:45 PM
query: SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = 'n8n' AND `TABLE_NAME` = 'migrations'
07/06/2023 3:12:45 PM
query: SELECT * FROM `n8n`.`migrations` `migrations` ORDER BY `id` DESC
07/06/2023 3:12:45 PM
39 migrations are already loaded in the database.
07/06/2023 3:12:45 PM
42 migrations were found in the source code.
07/06/2023 3:12:45 PM
AddUserActivatedProperty1681134145996 is the last executed migration. It was executed on Mon Apr 10 2023 15:42:25 GMT+0200 (Central European Summer Time).
07/06/2023 3:12:45 PM
3 migrations are new migrations must be executed.
07/06/2023 3:12:45 PM
query: START TRANSACTION
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.536Z | warn     | Migrations in progress, please do NOT stop the process. "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.536Z | debug    | Starting migration MigrateIntegerKeysToString1690000000001 "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
07/06/2023 3:12:45 PM
query: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
query failed: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
error: Error: Duplicate column name 'tmp_id'
07/06/2023 3:12:45 PM
query: ROLLBACK
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "view" to [Function: View]
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "views" to '/data/views'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "jsonp callback name" to 'callback'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "view cache" to true
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "x-powered-by" to false
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "view engine" to 'handlebars'
07/06/2023 3:12:34 PM
Thu, 06 Jul 2023 13:12:34 GMT express:application set "views" to '/usr/local/lib/node_modules/n8n/templates'
07/06/2023 3:12:34 PM
2023-07-06T13:12:34.912Z | warn     | License manager not initialized "{ file: 'License.js', function: 'isFeatureEnabled' }"
07/06/2023 3:12:34 PM
2023-07-06T13:12:34.916Z | error    | Last session crashed "{ file: 'CrashJournal.js', function: 'init' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.197Z | debug    | Lazy Loading credentials and nodes from n8n-nodes-base "{\n  credentials: 317,\n  nodes: 422,\n  file: 'DirectoryLoader.js',\n  function: 'loadAll'\n}"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.202Z | debug    | Can't enable lazy-loading "{ file: 'DirectoryLoader.js', function: 'loadAll' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.207Z | debug    | No codex available for: SplitInBatchesAdvanced.node.js "{ file: 'DirectoryLoader.js', function: 'addCodex' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.207Z | debug    | Loaded all credentials and nodes from n8n-nodes-splitinbatches-advanced "{\n  credentials: 0,\n  nodes: 1,\n  file: 'DirectoryLoader.js',\n  function: 'loadAll'\n}"
07/06/2023 3:12:45 PM
query: SELECT VERSION() AS `version`
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router use '/' query
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router use '/' expressInit
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:route new '/healthz'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/healthz'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:route get '/healthz'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router use '/' <anonymous>
07/06/2023 3:12:45 PM
Thu, 06 Jul 2023 13:12:45 GMT express:router:layer new '/'
07/06/2023 3:12:45 PM
n8n ready on 0.0.0.0, port 5678
07/06/2023 3:12:45 PM
query: SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = 'n8n' AND `TABLE_NAME` = 'migrations'
07/06/2023 3:12:45 PM
query: SELECT * FROM `n8n`.`migrations` `migrations` ORDER BY `id` DESC
07/06/2023 3:12:45 PM
39 migrations are already loaded in the database.
07/06/2023 3:12:45 PM
42 migrations were found in the source code.
07/06/2023 3:12:45 PM
AddUserActivatedProperty1681134145996 is the last executed migration. It was executed on Mon Apr 10 2023 15:42:25 GMT+0200 (Central European Summer Time).
07/06/2023 3:12:45 PM
3 migrations are new migrations must be executed.
07/06/2023 3:12:45 PM
query: START TRANSACTION
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.536Z | warn     | Migrations in progress, please do NOT stop the process. "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
07/06/2023 3:12:45 PM
2023-07-06T13:12:45.536Z | debug    | Starting migration MigrateIntegerKeysToString1690000000001 "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
07/06/2023 3:12:45 PM
query: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
query failed: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
error: Error: Duplicate column name 'tmp_id'
07/06/2023 3:12:45 PM
query: ROLLBACK
07/06/2023 3:12:45 PM
query: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
query failed: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
error: Error: Duplicate column name 'tmp_id'
07/06/2023 3:12:45 PM
query: ROLLBACK
07/06/2023 3:12:45 PM
query: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
query failed: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
07/06/2023 3:12:45 PM
error: Error: Duplicate column name 'tmp_id'
07/06/2023 3:12:45 PM
query: ROLLBACK
07/06/2023 3:12:48 PM
ln: /home/node/.n8n: File exists

Jon · 6 يوليو 2023، 1:25م

Cheers, I am just going to ask someone that might have an idea of what is going on there. If restoring from the backup is an option it could be worth doing.

Pintjes · 6 يوليو 2023، 4:42م

All right, thanks! I will be waiting to see if it’s fixable. If not I’ll just try reinstalling/restoring.

Jon · 7 يوليو 2023، 7:10ص

Hey @Pintjes,

So we have had a look and it looks like a restore from a backup is going to be the way to handle this one. Normally the migration would try to revert itself depending on which one it was but it looks like at some point in the process it could have been stopped which means it is only partially complete and can’t revert itself.

Pintjes · 7 يوليو 2023، 1:28م

Alright, I will try to reinstall next week. Thanks for taking the time to troubleshoot with me

jakevis · 18 يوليو 2023، 8:59م

JFYI I ran into the same issue… the original migration is failing at:

2023-07-18T20:56:13.183Z | warn | Migrations in progress, please do NOT stop the process. “{ file: ‘migrationHelpers.js’, function: ‘logMigrationStart’ }”
2023-07-18T20:56:13.183Z | debug | Starting migration MigrateIntegerKeysToString1690000000001 “{ file: ‘migrationHelpers.js’, function: ‘logMigrationStart’ }”
query: SELECT @@version
query: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
query: ALTER TABLE workflow_entity ADD COLUMN id varchar(36) NOT NULL;
query: UPDATE workflow_entity SET id = CONVERT(tmp_id, CHAR);
query: CREATE INDEX TMP_idx_workflow_entity_id ON workflow_entity (id);
query: ALTER TABLE tag_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
query: ALTER TABLE tag_entity ADD COLUMN id varchar(36) NOT NULL;
query: UPDATE tag_entity SET id = CONVERT(tmp_id, CHAR);
query: CREATE INDEX TMP_idx_tag_entity_id ON tag_entity (id);
query: ALTER TABLE workflows_tags CHANGE workflowId tmp_workflowId int NOT NULL;
query: ALTER TABLE workflows_tags ADD COLUMN workflowId varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
query failed: ALTER TABLE workflows_tags ADD COLUMN workflowId varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
error: Error: Unknown collation: ‘utf8mb4_0900_ai_ci’

This is a mariadb instance - so I expect we just got to the point where that is no longer supported?

A db restore to the same point with the same version of n8n just results in the same… walking the versions back now, I expect this was the 0.234.0 update that broke it… will know shortly

jakevis · 18 يوليو 2023، 9:03م

Yep ‘n8nio/n8n:0.233.1’ is the last version that works…

JanTh · 2 أغسطس 2023، 3:26م

Same issue here. Trying to upgrade to the latest 0. release before targeting 1.0.5:

2023-08-02T15:19:40.733Z | warn     | Migrations in progress, please do NOT stop the process. "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
2023-08-02T15:19:40.734Z | debug    | Starting migration MigrateIntegerKeysToString1690000000001 "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
query: SELECT @@version
query: ALTER TABLE workflow_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
query: ALTER TABLE workflow_entity ADD COLUMN id varchar(36) NOT NULL;
query: UPDATE workflow_entity SET id = CONVERT(tmp_id, CHAR);
query: CREATE INDEX `TMP_idx_workflow_entity_id` ON workflow_entity (`id`);
query: ALTER TABLE tag_entity CHANGE id tmp_id int NOT NULL AUTO_INCREMENT;
query: ALTER TABLE tag_entity ADD COLUMN id varchar(36) NOT NULL;
query: UPDATE tag_entity SET id = CONVERT(tmp_id, CHAR);
query: CREATE INDEX `TMP_idx_tag_entity_id` ON tag_entity (`id`);
query: ALTER TABLE workflows_tags CHANGE workflowId tmp_workflowId int NOT NULL;
query: ALTER TABLE workflows_tags ADD COLUMN `workflowId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
query failed: ALTER TABLE workflows_tags ADD COLUMN `workflowId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
error: Error: Unknown collation: 'utf8mb4_0900_ai_ci'
query: ROLLBACK
query: SELECT 1

Using MariaDB as well.
According to this post, the collation is simply “wrong” for MariaDB:

@Jon Is this something you consider fixing or will MariaDB be cutoff from N8N already due to this?
If there is no fix is there any migration guide / tooling from MariaDB → sqlite?
Postgres is not an option for us.

bartv · 5 أغسطس 2023، 10:11ص

Same for me; updating my docker-compose install to 0.236.3 (from 0.228.2) trashed my instance. It also flooded my n8n log and /var/log folder and completely filled up my disk. Mine also failed at the 'Starting migration MigrateIntegerKeysToString step.

Mulen · 5 أغسطس 2023، 1:37م

Mine too. I gave up. I exported credentials and workflows via cli before the update just in case. Then tried to update. Too many errors. End up spinning a new instance with PostgreSQL and import everything. Now everything seems fine.

Jon · 7 أغسطس 2023، 7:23ص

Hey @bartv,

There was a large migration between 228 and 236 which would take time depending on the database and the size of it. We saw a SQLite database internally take up to 3 hours to complete.

bartv · 13 أغسطس 2023، 8:06ص

To follow up: yes, this was the case + the fact that the migration took up a fair bit of diskspace and my system ran out of storage. Everything is ok now!

الموضوع		الردود	مرات العرض
N8n doesn't start after updating to 0.234.0 Questions deployment	20	2104	26 يوليو 2023
Upgrading n8n.io failed, MySQL migration error, "QueryFailedError: Duplicate column name 'tmp_id'" Questions database-migration	8	1015	5 سبتمبر 2023
N8N not starting after new docker pull Questions core	12	1014	11 مايو 2023
Version 0.236.1 upgrade fail on Docker Compose Questions deployment	16	1089	28 يوليو 2023
I can't start n8n, Error: There was an error running database migrations Questions	3	664	20 مارس 2024

Docker not starting anymore after updating to latest version

Describe the problem/error/question

What is the error message (if any)?

Information on your n8n setup

الموضوعات ذات الصلة