Docker not starting anymore after updating to latest version

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

Hey @Pintjes,

Welcome to the community :raised_hands:

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?

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.

Hey @Pintjes,

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

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' }"

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.

So anything I could actively try right now?

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

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/[email protected] 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

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.

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

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.

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

1 Like

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

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

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.

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.

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.

1 Like

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.

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!

1 Like