Using n8n.io on Microsoft Azure, it appears the last update we made about a month ago failed (ETA: or it looks like only a week ago, based on the logs? Not sure, memory is fuzzy on this one.) We’re only getting the full-screen text, n8n is starting up. Please wait.
According to the logs:
2023-08-22T00:04:02.309242903Z: [INFO] Last session crashed
2023-08-22T00:04:14.103827365Z: [INFO] n8n ready on 0.0.0.0, port 5678
2023-08-22T00:04:14.161606521Z: [INFO] Migrations in progress, please do NOT stop the process.
2023-08-22T00:04:14.199602826Z: [INFO] Error: There was an error running database migrations
2023-08-22T00:04:14.203774490Z: [INFO] QueryFailedError: Duplicate column name 'tmp_id'
Ending Log Tail of existing logs ---
N/A
N/A
n8n version: Unable to verify.
Database (default: SQLite): MySQL
n8n EXECUTIONS_PROCESS setting (default: own, main): default
Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
Operating system: Linux
Note, I did bother scanning the MySQL database a bit, and did indeed find columns tmp_id. Not sure what to do with them:
mysql> desc tag_entity;
+-----------+-------------+------+-----+----------------------+--------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+----------------------+--------------------------------+
| tmp_id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(24) | NO | UNI | NULL | |
| createdAt | datetime(3) | NO | | current_timestamp(3) | |
| updatedAt | datetime(3) | NO | | current_timestamp(3) | on update current_timestamp(3) |
| id | varchar(36) | NO | MUL | NULL | |
+-----------+-------------+------+-----+----------------------+--------------------------------+
5 rows in set (0.01 sec)
mysql> desc workflow_entity;
+--------------+--------------+------+-----+----------------------+--------------------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+----------------------+--------------------------------+
| tmp_id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(128) | NO | | NULL | |
| active | tinyint(4) | NO | | NULL | |
| nodes | longtext | NO | | NULL | |
| connections | longtext | NO | | NULL | |
| createdAt | datetime(3) | NO | | current_timestamp(3) | |
| updatedAt | datetime(3) | NO | | current_timestamp(3) | on update current_timestamp(3) |
| settings | longtext | YES | | NULL | |
| staticData | longtext | YES | | NULL | |
| pinData | longtext | YES | | NULL | |
| versionId | char(36) | YES | | NULL | |
| triggerCount | int(11) | NO | | 0 | |
| id | varchar(36) | NO | MUL | NULL | |
+--------------+--------------+------+-----+----------------------+--------------------------------+
13 rows in set (0.01 sec)
workflows_tags also had column tmp_workflowId and tmp_tagId. Not sure if those needs fixing, either.
mysql> desc workflows_tags;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| tmp_workflowId | int(11) | NO | MUL | NULL | |
| tmp_tagId | int(11) | NO | MUL | NULL | |
| workflowId | varchar(36) | NO | PRI | NULL | |
| tagId | varchar(36) | NO | PRI | NULL | |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
Hi @japtar10101
Can you set N8N_LOG_LEVEL to debug and restart the container and send over the output? It also may be worth restoring a database backup, and if the database migration didn’t complete the first time, to ensure it fully completes
OK, will take a bit to switch out the log level, but I should be able to do that. Note that since I’m sort of inheriting this setup from someone else, I’m actually not sure if there are any database backups. All I’m aware of is that the “backup to Github” workflow was used and running regularly, so at least it shouldn’t be too difficult to re-import workflows if I need to do a full re-install.
OK, this is all I get with N8N_LOG_LEVEL set to debug:???? in the logs below.)
Logs from 2023-08-31
/home/LogFiles/2023_08_31_lw0sdlwk000093_default_docker.log (https://????.scm.azurewebsites.net/api/vfs/LogFiles/2023_08_31_lw0sdlwk000093_default_docker.log)
2023-08-31T19:57:09.351975641Z Last session crashed
2023-08-31T19:57:22.080134930Z n8n ready on 0.0.0.0, port 5678
2023-08-31T19:57:22.244899670Z Migrations in progress, please do NOT stop the process.
2023-08-31T19:57:22.385220957Z Error: There was an error running database migrations
2023-08-31T19:57:22.386939274Z QueryFailedError: Duplicate column name 'tmp_id'
/home/LogFiles/2023_08_31_lw0sdlwk000093_docker.log (https://????.scm.azurewebsites.net/api/vfs/LogFiles/2023_08_31_lw0sdlwk000093_docker.log)
2023-08-31T19:56:52.153Z INFO - Status: Downloaded newer image for n8nio/n8n:latest
2023-08-31T19:56:52.185Z INFO - Pull Image successful, Time taken: 1 Minutes and 20 Seconds
2023-08-31T19:56:52.856Z INFO - Starting container for site
2023-08-31T19:56:52.856Z INFO - docker run -d --expose=5678 --name ????_0_03cee5d1 -e WEBSITES_ENABLE_APP_SERVICE_STORAGE=true -e WEBSITES_PORT=5678 -e WEBSITE_SITE_NAME=???? -e WEBSITE_AUTH_ENABLED=False -e WEBSITE_ROLE_INSTANCE_ID=0 -e WEBSITE_HOSTNAME=????.azurewebsites.net -e WEBSITE_INSTANCE_ID=98aa93a2b387bfcc2b19d4c86629533064c715af383d916367d432d85ee7b92e -e HTTP_LOGGING_ENABLED=1 -e WEBSITE_USE_DIAGNOSTIC_SERVER=False n8nio/n8n
2023-08-31T19:56:55.161Z INFO - Initiating warmup request to container ????_0_03cee5d1 for site ????
2023-08-31T19:57:11.570Z INFO - Waiting for response to warmup request for container ????_0_03cee5d1. Elapsed time = 16.41565 sec
2023-08-31T19:57:22.791Z INFO - Container ????_0_03cee5d1 for site ???? initialized successfully and is ready to serve requests.
2023-08-31T19:57:27.838Z ERROR - Container for ????_0_03cee5d1 site ???? is unhealthy, Stopping site.
2023-08-31T19:57:27.840Z INFO - Stopping site ???? because it is not healthy.
Ending Log Tail of existing logs ---
Starting Live Log Stream ---
2023-08-31T23:59:25.374Z INFO - Pulling image: n8nio/n8n
2023-08-31T23:59:26.082Z INFO - latest Pulling from n8nio/n8n
2023-08-31T23:59:26.222Z INFO - 31e352740f53 Already exists
2023-08-31T23:59:26.224Z INFO - 560412e561fb Pulling fs layer
2023-08-31T23:59:26.226Z INFO - 02735cb6c78b Pulling fs layer
2023-08-31T23:59:26.228Z INFO - 86d562f7b855 Pulling fs layer
2023-08-31T23:59:26.231Z INFO - 4f4fb700ef54 Pulling fs layer
2023-08-31T23:59:26.248Z INFO - afa00646950d Pulling fs layer
2023-08-31T23:59:26.249Z INFO - 7db65573f45e Pulling fs layer
2023-08-31T23:59:26.252Z INFO - 4391897797c3 Pulling fs layer
2023-08-31T23:59:26.253Z INFO - 862a7a4a561a Pulling fs layer
2023-08-31T23:59:26.255Z INFO - c40d6951024d Pulling fs layer
2023-08-31T23:59:26.346Z INFO - 4f4fb700ef54 Downloading 32B / 32B
2023-08-31T23:59:26.353Z INFO - 4f4fb700ef54 Verifying Checksum
2023-08-31T23:59:26.355Z INFO - 4f4fb700ef54 Download complete
2023-08-31T23:59:26.356Z INFO - 862a7a4a561a Downloading 199B / 199B
2023-08-31T23:59:26.357Z INFO - 862a7a4a561a Verifying Checksum
2023-08-31T23:59:26.359Z INFO - 862a7a4a561a Download complete
2023-08-31T23:59:26.373Z INFO - 86d562f7b855 Downloading 450B / 450B
2023-08-31T23:59:26.375Z INFO - c40d6951024d Downloading 145B / 145B
2023-08-31T23:59:26.385Z INFO - 86d562f7b855 Verifying Checksum
2023-08-31T23:59:26.393Z INFO - 86d562f7b855 Download complete
2023-08-31T23:59:26.394Z INFO - c40d6951024d Verifying Checksum
2023-08-31T23:59:26.395Z INFO - c40d6951024d Download complete
2023-08-31T23:59:26.434Z INFO - afa00646950d Downloading 223B / 223B
2023-08-31T23:59:26.474Z INFO - afa00646950d Verifying Checksum
2023-08-31T23:59:26.476Z INFO - afa00646950d Download complete
2023-08-31T23:59:26.536Z INFO - 4391897797c3 Downloading 523KB / 85MB
2023-08-31T23:59:26.573Z INFO - 7db65573f45e Downloading 2MB / 28MB
2023-08-31T23:59:26.575Z INFO - 02735cb6c78b Downloading 480KB / 2MB
2023-08-31T23:59:26.745Z INFO - 7db65573f45e Downloading 3MB / 28MB
2023-08-31T23:59:26.753Z INFO - 02735cb6c78b Verifying Checksum
2023-08-31T23:59:26.761Z INFO - 02735cb6c78b Download complete
2023-08-31T23:59:26.863Z INFO - 7db65573f45e Downloading 4MB / 28MB
2023-08-31T23:59:26.882Z INFO - 4391897797c3 Downloading 2MB / 85MB
2023-08-31T23:59:26.985Z INFO - 4391897797c3 Downloading 3MB / 85MB
2023-08-31T23:59:27.154Z INFO - 4391897797c3 Downloading 5MB / 85MB
2023-08-31T23:59:27.183Z INFO - 7db65573f45e Downloading 7MB / 28MB
2023-08-31T23:59:27.304Z INFO - 7db65573f45e Downloading 8MB / 28MB
2023-08-31T23:59:27.469Z INFO - 7db65573f45e Downloading 8MB / 28MB
2023-08-31T23:59:27.470Z INFO - 4391897797c3 Downloading 7MB / 85MB
2023-08-31T23:59:27.546Z INFO - 560412e561fb Downloading 11MB / 45MB
2023-08-31T23:59:27.657Z INFO - 7db65573f45e Downloading 9MB / 28MB
2023-08-31T23:59:27.748Z INFO - 7db65573f45e Downloading 10MB / 28MB
2023-08-31T23:59:27.755Z INFO - 560412e561fb Downloading 13MB / 45MB
2023-08-31T23:59:27.884Z INFO - 560412e561fb Downloading 15MB / 45MB
2023-08-31T23:59:27.886Z INFO - 7db65573f45e Downloading 12MB / 28MB
2023-08-31T23:59:28.015Z INFO - 560412e561fb Downloading 17MB / 45MB
2023-08-31T23:59:28.016Z INFO - 4391897797c3 Downloading 14MB / 85MB
2023-08-31T23:59:28.096Z INFO - 7db65573f45e Downloading 12MB / 28MB
2023-08-31T23:59:28.306Z INFO - 4391897797c3 Downloading 17MB / 85MB
2023-08-31T23:59:28.369Z INFO - 7db65573f45e Downloading 15MB / 28MB
2023-08-31T23:59:28.458Z INFO - 4391897797c3 Downloading 19MB / 85MB
2023-08-31T23:59:28.590Z INFO - 560412e561fb Downloading 21MB / 45MB
2023-08-31T23:59:28.799Z INFO - 560412e561fb Downloading 23MB / 45MB
2023-08-31T23:59:28.859Z INFO - 7db65573f45e Downloading 18MB / 28MB
2023-08-31T23:59:28.992Z INFO - 7db65573f45e Downloading 19MB / 28MB
2023-08-31T23:59:29.029Z INFO - 560412e561fb Downloading 24MB / 45MB
2023-08-31T23:59:29.070Z INFO - 7db65573f45e Downloading 19MB / 28MB
2023-08-31T23:59:29.169Z INFO - 4391897797c3 Downloading 22MB / 85MB
2023-08-31T23:59:29.221Z INFO - 7db65573f45e Downloading 21MB / 28MB
2023-08-31T23:59:29.270Z INFO - 4391897797c3 Downloading 24MB / 85MB
2023-08-31T23:59:29.321Z INFO - 7db65573f45e Downloading 23MB / 28MB
2023-08-31T23:59:29.370Z INFO - 4391897797c3 Downloading 26MB / 85MB
2023-08-31T23:59:29.371Z INFO - 560412e561fb Downloading 31MB / 45MB
2023-08-31T23:59:29.440Z INFO - 7db65573f45e Downloading 25MB / 28MB
2023-08-31T23:59:29.481Z INFO - 4391897797c3 Downloading 27MB / 85MB
2023-08-31T23:59:29.482Z INFO - 560412e561fb Downloading 31MB / 45MB
2023-08-31T23:59:29.540Z INFO - 7db65573f45e Downloading 26MB / 28MB
2023-08-31T23:59:29.592Z INFO - 4391897797c3 Downloading 28MB / 85MB
2023-08-31T23:59:29.593Z INFO - 7db65573f45e Verifying Checksum
2023-08-31T23:59:29.601Z INFO - 7db65573f45e Download complete
2023-08-31T23:59:29.724Z INFO - 560412e561fb Downloading 36MB / 45MB
2023-08-31T23:59:29.794Z INFO - 4391897797c3 Downloading 33MB / 85MB
2023-08-31T23:59:29.833Z INFO - 560412e561fb Downloading 39MB / 45MB
2023-08-31T23:59:30.013Z INFO - 560412e561fb Verifying Checksum
2023-08-31T23:59:30.021Z INFO - 560412e561fb Download complete
2023-08-31T23:59:30.033Z INFO - 4391897797c3 Downloading 38MB / 85MB
2023-08-31T23:59:30.309Z INFO - 4391897797c3 Downloading 41MB / 85MB
2023-08-31T23:59:30.804Z INFO - 4391897797c3 Downloading 63MB / 85MB
2023-08-31T23:59:30.924Z INFO - 4391897797c3 Downloading 67MB / 85MB
2023-08-31T23:59:31.023Z INFO - 4391897797c3 Downloading 70MB / 85MB
2023-08-31T23:59:31.116Z INFO - 4391897797c3 Downloading 74MB / 85MB
2023-08-31T23:59:31.436Z INFO - 4391897797c3 Downloading 84MB / 85MB
2023-08-31T23:59:31.481Z INFO - 4391897797c3 Verifying Checksum
2023-08-31T23:59:31.484Z INFO - 4391897797c3 Download complete
2023-08-31T23:59:32.323Z INFO - 560412e561fb Extracting 3MB / 45MB
2023-08-31T23:59:32.465Z INFO - 560412e561fb Extracting 4MB / 45MB
2023-08-31T23:59:32.585Z INFO - 560412e561fb Extracting 5MB / 45MB
2023-08-31T23:59:32.695Z INFO - 560412e561fb Extracting 6MB / 45MB
2023-08-31T23:59:32.797Z INFO - 560412e561fb Extracting 7MB / 45MB
2023-08-31T23:59:32.916Z INFO - 560412e561fb Extracting 8MB / 45MB
2023-08-31T23:59:33.047Z INFO - 560412e561fb Extracting 9MB / 45MB
2023-08-31T23:59:33.160Z INFO - 560412e561fb Extracting 10MB / 45MB
2023-08-31T23:59:33.261Z INFO - 560412e561fb Extracting 11MB / 45MB
2023-08-31T23:59:33.398Z INFO - 560412e561fb Extracting 12MB / 45MB
2023-08-31T23:59:33.502Z INFO - 560412e561fb Extracting 13MB / 45MB
2023-08-31T23:59:33.706Z INFO - 560412e561fb Extracting 14MB / 45MB
2023-08-31T23:59:33.898Z INFO - 560412e561fb Extracting 15MB / 45MB
2023-08-31T23:59:34.169Z INFO - 560412e561fb Extracting 16MB / 45MB
2023-08-31T23:59:34.510Z INFO - 560412e561fb Extracting 17MB / 45MB
2023-08-31T23:59:34.753Z INFO - 560412e561fb Extracting 18MB / 45MB
2023-08-31T23:59:35.042Z INFO - 560412e561fb Extracting 19MB / 45MB
2023-08-31T23:59:35.279Z INFO - 560412e561fb Extracting 20MB / 45MB
2023-08-31T23:59:35.527Z INFO - 560412e561fb Extracting 21MB / 45MB
2023-08-31T23:59:35.699Z INFO - 560412e561fb Extracting 22MB / 45MB
2023-08-31T23:59:35.830Z INFO - 560412e561fb Extracting 22MB / 45MB
2023-08-31T23:59:36.112Z INFO - 560412e561fb Extracting 25MB / 45MB
2023-08-31T23:59:36.383Z INFO - 560412e561fb Extracting 27MB / 45MB
2023-08-31T23:59:36.509Z INFO - 560412e561fb Extracting 28MB / 45MB
2023-08-31T23:59:36.629Z INFO - 560412e561fb Extracting 29MB / 45MB
2023-08-31T23:59:36.821Z INFO - 560412e561fb Extracting 30MB / 45MB
2023-08-31T23:59:36.921Z INFO - 560412e561fb Extracting 30MB / 45MB
2023-08-31T23:59:37.226Z INFO - 560412e561fb Extracting 31MB / 45MB
2023-08-31T23:59:37.893Z INFO - 560412e561fb Extracting 32MB / 45MB
2023-08-31T23:59:38.083Z INFO - 560412e561fb Extracting 33MB / 45MB
2023-08-31T23:59:38.586Z INFO - 560412e561fb Extracting 34MB / 45MB
2023-08-31T23:59:39.167Z INFO - 560412e561fb Extracting 35MB / 45MB
2023-08-31T23:59:39.468Z INFO - 560412e561fb Extracting 36MB / 45MB
2023-08-31T23:59:39.865Z INFO - 560412e561fb Extracting 37MB / 45MB
2023-08-31T23:59:40.228Z INFO - 560412e561fb Extracting 38MB / 45MB
2023-08-31T23:59:40.611Z INFO - 560412e561fb Extracting 39MB / 45MB
2023-08-31T23:59:41.242Z INFO - 560412e561fb Extracting 40MB / 45MB
2023-08-31T23:59:41.638Z INFO - 560412e561fb Extracting 41MB / 45MB
2023-08-31T23:59:42.047Z INFO - 560412e561fb Extracting 42MB / 45MB
2023-08-31T23:59:42.828Z INFO - 560412e561fb Extracting 43MB / 45MB
2023-08-31T23:59:43.376Z INFO - 560412e561fb Extracting 44MB / 45MB
2023-08-31T23:59:43.937Z INFO - 560412e561fb Extracting 45MB / 45MB
2023-08-31T23:59:44.169Z INFO - 560412e561fb Pull complete
2023-08-31T23:59:44.570Z INFO - 02735cb6c78b Extracting 832KB / 2MB
2023-08-31T23:59:44.911Z INFO - 02735cb6c78b Extracting 1MB / 2MB
2023-08-31T23:59:45.003Z INFO - 02735cb6c78b Extracting 2MB / 2MB
2023-08-31T23:59:45.102Z INFO - 02735cb6c78b Pull complete
2023-08-31T23:59:45.121Z INFO - 86d562f7b855 Extracting 450B / 450B
2023-08-31T23:59:45.123Z INFO - 86d562f7b855 Extracting 450B / 450B
2023-08-31T23:59:45.481Z INFO - 86d562f7b855 Pull complete
2023-08-31T23:59:45.503Z INFO - 4f4fb700ef54 Extracting 32B / 32B
2023-08-31T23:59:45.510Z INFO - 4f4fb700ef54 Extracting 32B / 32B
2023-08-31T23:59:45.661Z INFO - 4f4fb700ef54 Pull complete
2023-08-31T23:59:45.672Z INFO - afa00646950d Extracting 223B / 223B
2023-08-31T23:59:45.681Z INFO - afa00646950d Extracting 223B / 223B
2023-08-31T23:59:45.831Z INFO - afa00646950d Pull complete
2023-08-31T23:59:46.253Z INFO - 7db65573f45e Extracting 1MB / 28MB
2023-08-31T23:59:46.506Z INFO - 7db65573f45e Extracting 3MB / 28MB
2023-08-31T23:59:46.657Z INFO - 7db65573f45e Extracting 3MB / 28MB
2023-08-31T23:59:47.217Z INFO - 7db65573f45e Extracting 5MB / 28MB
2023-08-31T23:59:47.449Z INFO - 7db65573f45e Extracting 7MB / 28MB
2023-08-31T23:59:47.568Z INFO - 7db65573f45e Extracting 8MB / 28MB
2023-08-31T23:59:47.840Z INFO - 7db65573f45e Extracting 10MB / 28MB
2023-08-31T23:59:47.949Z INFO - 7db65573f45e Extracting 10MB / 28MB
2023-08-31T23:59:48.590Z INFO - 7db65573f45e Extracting 14MB / 28MB
2023-08-31T23:59:48.894Z INFO - 7db65573f45e Extracting 15MB / 28MB
2023-08-31T23:59:49.014Z INFO - 7db65573f45e Extracting 16MB / 28MB
2023-08-31T23:59:49.115Z INFO - 7db65573f45e Extracting 16MB / 28MB
2023-08-31T23:59:49.525Z INFO - 7db65573f45e Extracting 17MB / 28MB
2023-08-31T23:59:49.946Z INFO - 7db65573f45e Extracting 18MB / 28MB
2023-08-31T23:59:50.762Z INFO - 7db65573f45e Extracting 19MB / 28MB
2023-08-31T23:59:51.061Z INFO - 7db65573f45e Extracting 20MB / 28MB
2023-08-31T23:59:51.251Z INFO - 7db65573f45e Extracting 21MB / 28MB
2023-08-31T23:59:51.356Z INFO - 7db65573f45e Extracting 22MB / 28MB
2023-08-31T23:59:51.494Z INFO - 7db65573f45e Extracting 24MB / 28MB
2023-08-31T23:59:51.622Z INFO - 7db65573f45e Extracting 25MB / 28MB
2023-08-31T23:59:52.668Z INFO - 7db65573f45e Extracting 28MB / 28MB
2023-08-31T23:59:52.909Z INFO - 7db65573f45e Pull complete
2023-08-31T23:59:53.665Z INFO - 4391897797c3 Extracting 544KB / 85MB
2023-08-31T23:59:55.015Z INFO - 4391897797c3 Extracting 2MB / 85MB
2023-08-31T23:59:56.450Z INFO - 4391897797c3 Extracting 3MB / 85MB
2023-08-31T23:59:57.050Z INFO - 4391897797c3 Extracting 5MB / 85MB
2023-08-31T23:59:57.505Z INFO - 4391897797c3 Extracting 6MB / 85MB
2023-08-31T23:59:57.705Z INFO - 4391897797c3 Extracting 7MB / 85MB
2023-08-31T23:59:58.187Z INFO - 4391897797c3 Extracting 9MB / 85MB
2023-08-31T23:59:59.269Z INFO - 4391897797c3 Extracting 10MB / 85MB
2023-08-31T23:59:59.481Z INFO - 4391897797c3 Extracting 11MB / 85MB
2023-09-01T00:00:00.925Z INFO - 4391897797c3 Extracting 12MB / 85MB
2023-09-01T00:00:02.907Z INFO - 4391897797c3 Extracting 12MB / 85MB
2023-09-01T00:00:03.228Z INFO - 4391897797c3 Extracting 13MB / 85MB
2023-09-01T00:00:03.636Z INFO - 4391897797c3 Extracting 14MB / 85MB
2023-09-01T00:00:05.094Z INFO - 4391897797c3 Extracting 15MB / 85MB
2023-09-01T00:00:06.561Z INFO - 4391897797c3 Extracting 17MB / 85MB
2023-09-01T00:00:08.296Z INFO - 4391897797c3 Extracting 19MB / 85MB
2023-09-01T00:00:08.756Z INFO - 4391897797c3 Extracting 19MB / 85MB
2023-09-01T00:00:09.207Z INFO - 4391897797c3 Extracting 20MB / 85MB
2023-09-01T00:00:09.536Z INFO - 4391897797c3 Extracting 21MB / 85MB
2023-09-01T00:00:12.682Z INFO - 4391897797c3 Extracting 22MB / 85MB
2023-09-01T00:00:16.569Z INFO - 4391897797c3 Extracting 24MB / 85MB
2023-09-01T00:00:18.701Z INFO - 4391897797c3 Extracting 26MB / 85MB
2023-09-01T00:00:19.371Z INFO - 4391897797c3 Extracting 26MB / 85MB
2023-09-01T00:00:19.836Z INFO - 4391897797c3 Extracting 27MB / 85MB
2023-09-01T00:00:20.174Z INFO - 4391897797c3 Extracting 28MB / 85MB
2023-09-01T00:00:20.835Z INFO - 4391897797c3 Extracting 29MB / 85MB
2023-09-01T00:00:21.029Z INFO - 4391897797c3 Extracting 29MB / 85MB
2023-09-01T00:00:21.933Z INFO - 4391897797c3 Extracting 31MB / 85MB
2023-09-01T00:00:23.784Z INFO - 4391897797c3 Extracting 32MB / 85MB
2023-09-01T00:00:23.935Z INFO - 4391897797c3 Extracting 33MB / 85MB
2023-09-01T00:00:24.436Z INFO - 4391897797c3 Extracting 34MB / 85MB
2023-09-01T00:00:24.771Z INFO - 4391897797c3 Extracting 35MB / 85MB
2023-09-01T00:00:25.399Z INFO - 4391897797c3 Extracting 36MB / 85MB
2023-09-01T00:00:25.639Z INFO - 4391897797c3 Extracting 36MB / 85MB
2023-09-01T00:00:26.008Z INFO - 4391897797c3 Extracting 38MB / 85MB
2023-09-01T00:00:26.351Z INFO - 4391897797c3 Extracting 39MB / 85MB
2023-09-01T00:00:27.550Z INFO - 4391897797c3 Extracting 41MB / 85MB
2023-09-01T00:00:28.218Z INFO - 4391897797c3 Extracting 41MB / 85MB
2023-09-01T00:00:29.321Z INFO - 4391897797c3 Extracting 43MB / 85MB
2023-09-01T00:00:29.572Z INFO - 4391897797c3 Extracting 43MB / 85MB
2023-09-01T00:00:30.592Z INFO - 4391897797c3 Extracting 48MB / 85MB
2023-09-01T00:00:30.971Z INFO - 4391897797c3 Extracting 48MB / 85MB
2023-09-01T00:00:31.843Z INFO - 4391897797c3 Extracting 49MB / 85MB
2023-09-01T00:00:32.703Z INFO - 4391897797c3 Extracting 50MB / 85MB
2023-09-01T00:00:33.394Z INFO - 4391897797c3 Extracting 51MB / 85MB
2023-09-01T00:00:33.578Z INFO - 4391897797c3 Extracting 52MB / 85MB
2023-09-01T00:00:34.253Z INFO - 4391897797c3 Extracting 53MB / 85MB
2023-09-01T00:00:35.015Z INFO - 4391897797c3 Extracting 55MB / 85MB
2023-09-01T00:00:35.256Z INFO - 4391897797c3 Extracting 55MB / 85MB
2023-09-01T00:00:35.474Z INFO - 4391897797c3 Extracting 56MB / 85MB
2023-09-01T00:00:35.621Z INFO - 4391897797c3 Extracting 57MB / 85MB
2023-09-01T00:00:35.962Z INFO - 4391897797c3 Extracting 58MB / 85MB
2023-09-01T00:00:36.522Z INFO - 4391897797c3 Extracting 60MB / 85MB
2023-09-01T00:00:37.503Z INFO - 4391897797c3 Extracting 62MB / 85MB
2023-09-01T00:00:37.875Z INFO - 4391897797c3 Extracting 63MB / 85MB
2023-09-01T00:00:37.975Z INFO - 4391897797c3 Extracting 64MB / 85MB
2023-09-01T00:00:38.238Z INFO - 4391897797c3 Extracting 65MB / 85MB
2023-09-01T00:00:38.357Z INFO - 4391897797c3 Extracting 65MB / 85MB
2023-09-01T00:00:39.113Z INFO - 4391897797c3 Extracting 69MB / 85MB
2023-09-01T00:00:40.760Z INFO - 4391897797c3 Extracting 70MB / 85MB
2023-09-01T00:00:41.019Z INFO - 4391897797c3 Extracting 71MB / 85MB
2023-09-01T00:00:41.131Z INFO - 4391897797c3 Extracting 74MB / 85MB
2023-09-01T00:00:41.659Z INFO - 4391897797c3 Extracting 75MB / 85MB
2023-09-01T00:00:42.290Z INFO - 4391897797c3 Extracting 77MB / 85MB
2023-09-01T00:00:42.605Z INFO - 4391897797c3 Extracting 78MB / 85MB
2023-09-01T00:00:43.507Z INFO - 4391897797c3 Extracting 79MB / 85MB
2023-09-01T00:00:43.899Z INFO - 4391897797c3 Extracting 79MB / 85MB
2023-09-01T00:00:44.781Z INFO - 4391897797c3 Extracting 80MB / 85MB
2023-09-01T00:00:44.913Z INFO - 4391897797c3 Extracting 81MB / 85MB
2023-09-01T00:00:45.667Z INFO - 4391897797c3 Extracting 82MB / 85MB
2023-09-01T00:00:45.947Z INFO - 4391897797c3 Extracting 84MB / 85MB
2023-09-01T00:00:46.467Z INFO - 4391897797c3 Extracting 85MB / 85MB
2023-09-01T00:00:48.953Z INFO - 4391897797c3 Pull complete
2023-09-01T00:00:49.006Z INFO - 862a7a4a561a Extracting 199B / 199B
2023-09-01T00:00:49.114Z INFO - 862a7a4a561a Extracting 199B / 199B
2023-09-01T00:00:49.316Z INFO - 862a7a4a561a Pull complete
2023-09-01T00:00:49.323Z INFO - c40d6951024d Extracting 145B / 145B
2023-09-01T00:00:49.333Z INFO - c40d6951024d Extracting 145B / 145B
2023-09-01T00:00:49.494Z INFO - c40d6951024d Pull complete
2023-09-01T00:00:49.549Z INFO - Digest: sha256:1b5480d076538a9676e00b5f0d8bb137388727511c058913909074e6157923f8
2023-09-01T00:00:49.554Z INFO - Status: Downloaded newer image for n8nio/n8n:latest
2023-09-01T00:00:49.586Z INFO - Pull Image successful, Time taken: 1 Minutes and 24 Seconds
2023-09-01T00:00:50.307Z INFO - Starting container for site
2023-09-01T00:00:50.309Z INFO - docker run -d --expose=5678 --name ????_0_0f521309 -e WEBSITES_ENABLE_APP_SERVICE_STORAGE=true -e WEBSITES_PORT=5678 -e WEBSITE_SITE_NAME=???? -e WEBSITE_AUTH_ENABLED=False -e WEBSITE_ROLE_INSTANCE_ID=0 -e WEBSITE_HOSTNAME=????.azurewebsites.net -e WEBSITE_INSTANCE_ID=98aa93a2b387bfcc2b19d4c86629533064c715af383d916367d432d85ee7b92e -e HTTP_LOGGING_ENABLED=1 -e WEBSITE_USE_DIAGNOSTIC_SERVER=False n8nio/n8n
2023-09-01T00:00:53.494Z INFO - Initiating warmup request to container ????_0_0f521309 for site ????
2023-09-01T00:01:19.359Z INFO - Container ????_0_0f521309 for site ???? initialized successfully and is ready to serve requests.
2023-09-01T00:01:06.169986010Z 2023-09-01T00:01:06.165Z | e[31merrore[39m | e[31mLast session crashede[39m "{ file: 'CrashJournal.js', function: 'init' }"
2023-09-01T00:01:17.557481764Z 2023-09-01T00:01:17.514Z | e[34mdebuge[39m | e[34mLazy Loading credentials and nodes from n8n-nodes-basee[39m "{\n credentials: 344,\n nodes: 431,\n file: 'DirectoryLoader.js',\n function: 'loadAll'\n}"
2023-09-01T00:01:18.836339883Z n8n ready on 0.0.0.0, port 5678
2023-09-01T00:01:19.008885459Z 2023-09-01T00:01:19.008Z | e[33mwarne[39m | e[33mMigrations in progress, please do NOT stop the process.e[39m "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
2023-09-01T00:01:19.010895992Z 2023-09-01T00:01:19.009Z | e[34mdebuge[39m | e[34mStarting migration MigrateIntegerKeysToString1690000000001e[39m "{ file: 'migrationHelpers.js', function: 'logMigrationStart' }"
2023-09-01T00:01:19.057069736Z 2023-09-01T00:01:19.056Z | e[31merrore[39m | e[31mError: There was an error running database migrationse[39m "{ file: 'ErrorReporterProxy.js', function: 'report' }"
2023-09-01T00:01:19.059185176Z 2023-09-01T00:01:19.057Z | e[31merrore[39m | e[31mQueryFailedError: Duplicate column name 'tmp_id'e[39m "{ file: 'ErrorReporterProxy.js', function: 'report' }"
2023-09-01T00:01:24.562Z ERROR - Container for ????_0_0f521309 site ???? is unhealthy, Stopping site.
2023-09-01T00:01:24.564Z INFO - Stopping site ???? because it is not healthy.
2023-09-01T00:03:12 No new trace in the past 1 min(s).
Jon
September 1, 2023, 11:56am
6
Hey @japtar10101 ,
It looks like the migration might have failed during the upgrade originally or was stopped. Best way to get around this would be to restore an older database backup if you have one then try the upgrade again.
OK, so bad news. It looks like there is backup available, but only up to 7-days prior. Given I know for a fact that our instance was corrupted well before then, thus making this backup useless, what would be the process to do a fresh re-install?
(Aside, is MySQL support going to be deprecated? Maybe it might be a good time to spin up a different database, then.)
Jon
September 4, 2023, 7:40am
8
Hey @japtar10101 ,
MySQL support is already marked as deprecated and will be removed in the future so using Postgres might be a better option. To do a fresh install it would just be a case of pointing n8n to an empty database and it will sort itself out from there you would need to add your workflows, credentials and users again but if you have access to the the workflow and credentials table you might be to work some sql magic to select from one and insert into another.
1 Like
Alright, I’ll give that a shot this week. Thanks for the instructions.
system
September 12, 2023, 5:06am
10
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
Welcome to the community 
