Skip to content

Instantly share code, notes, and snippets.

@jaraddowning
Created May 5, 2021 19:15
Show Gist options
  • Save jaraddowning/0afa403c8841a9b0c573307a9dfc1d04 to your computer and use it in GitHub Desktop.
Save jaraddowning/0afa403c8841a9b0c573307a9dfc1d04 to your computer and use it in GitHub Desktop.
Ghost upgrade woes....
The `ghost run` command is used by the configured Ghost process manager and for debugging. If you're not running this to debug something, you should run `ghost start` instead.
+ sudo node current/index.js
[2021-05-05 19:09:16] INFO Ghost is running in production...
[2021-05-05 19:09:16] INFO Your site is now available on https://whatsgnu.today/
[2021-05-05 19:09:16] INFO Ctrl+C to shut down
[2021-05-05 19:09:16] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:09:16] WARN Tries: 0
[2021-05-05 19:09:16] WARN Retrying...
[2021-05-05 19:09:16] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:09:16] WARN Tries: 1
[2021-05-05 19:09:16] WARN Retrying...
[2021-05-05 19:09:16] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:09:16] WARN Tries: 2
[2021-05-05 19:09:16] WARN Retrying...
[2021-05-05 19:09:17] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:09:17] INFO Ghost server started in 1.402s
[2021-05-05 19:09:17] WARN Database state requires migration.
[2021-05-05 19:09:18] INFO Creating database backup
[2021-05-05 19:09:18] INFO Database backup written to: /var/www/ghost/content/data/whats-gnu-today.ghost.2021-05-05-19-09-18.json
[2021-05-05 19:09:18] INFO Adding posts.email_recipient_filter column
[2021-05-05 19:09:18] INFO Skipping rollback of members_signup_access setting. Does not exist.
[2021-05-05 19:09:18] INFO Resetting stripe_price_id column to empty in stripe customer subscriptions table
[2021-05-05 19:09:18] ERROR update `members_stripe_customers_subscriptions` set `stripe_price_id` = '' - ER_BAD_FIELD_ERROR: Unknown column 'stripe_price_id' in 'field list'
update `members_stripe_customers_subscriptions` set `stripe_price_id` = '' - ER_BAD_FIELD_ERROR: Unknown column 'stripe_price_id' in 'field list'
"OuterError: alter table `posts` add `email_recipient_filter` varchar(50) not null default 'none' - ER_TOO_BIG_ROWSIZE: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"
Error ID:
400
Error Code:
ER_BAD_FIELD_ERROR
----------------------------------------
RollbackError: update `members_stripe_customers_subscriptions` set `stripe_price_id` = '' - ER_BAD_FIELD_ERROR: Unknown column 'stripe_price_id' in 'field list'
at RollbackError.KnexMigrateError (/var/www/ghost/versions/4.4.0/node_modules/knex-migrator/lib/errors.js:7:26)
at new RollbackError (/var/www/ghost/versions/4.4.0/node_modules/knex-migrator/lib/errors.js:31:26)
at /var/www/ghost/versions/4.4.0/node_modules/knex-migrator/lib/index.js:440:23
at tryCatcher (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:547:31)
at Promise._settlePromise (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:604:18)
at Promise._settlePromise0 (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:649:10)
at Promise._settlePromises (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:725:18)
at _drainQueueStep (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:93:12)
at _drainQueue (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:86:9)
at Async._drainQueues (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:102:5)
at Immediate.Async.drainQueues [as _onImmediate] (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:15:14)
at processImmediate (internal/timers.js:461:21)
Error: ER_BAD_FIELD_ERROR: Unknown column 'stripe_price_id' in 'field list'
at Query.Sequence._packetToError (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:315:20)
at addChunk (internal/streams/readable.js:309:12)
at readableAddChunk (internal/streams/readable.js:284:9)
at Socket.Readable.push (internal/streams/readable.js:223:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
--------------------
at Protocol._enqueue (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/var/www/ghost/versions/4.4.0/node_modules/mysql/lib/Connection.js:198:25)
at /var/www/ghost/versions/4.4.0/node_modules/knex/lib/dialects/mysql/index.js:134:18
at new Promise (<anonymous>)
at Client_MySQL._query (/var/www/ghost/versions/4.4.0/node_modules/knex/lib/dialects/mysql/index.js:128:12)
at Client_MySQL.query (/var/www/ghost/versions/4.4.0/node_modules/knex/lib/client.js:168:17)
at /var/www/ghost/versions/4.4.0/node_modules/knex/lib/transaction.js:325:24
at new Promise (<anonymous>)
at Client_MySQL.trxClient.query (/var/www/ghost/versions/4.4.0/node_modules/knex/lib/transaction.js:320:12)
at Runner.query (/var/www/ghost/versions/4.4.0/node_modules/knex/lib/runner.js:151:36)
at /var/www/ghost/versions/4.4.0/node_modules/knex/lib/runner.js:40:23
at /var/www/ghost/versions/4.4.0/node_modules/knex/lib/runner.js:277:24
at processTicksAndRejections (internal/process/task_queues.js:93:5)
at async down (/var/www/ghost/versions/4.4.0/core/server/data/migrations/versions/4.3/10-populate-stripe-price-id-in-subscriptions.js:15:9)
at async Object.down (/var/www/ghost/versions/4.4.0/core/server/data/migrations/utils.js:281:13)
[2021-05-05 19:09:18] WARN Ghost is shutting down
[2021-05-05 19:09:18] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:09:18] WARN Tries: 0
[2021-05-05 19:09:18] WARN Retrying...
[2021-05-05 19:09:18] WARN Ghost has shut down
[2021-05-05 19:09:18] WARN Your site is now offline
[2021-05-05 19:09:18] WARN Ghost was running for a few seconds
The `ghost run` command is used by the configured Ghost process manager and for debugging. If you're not running this to debug something, you should run `ghost start` instead.
+ sudo node current/index.js
[2021-05-05 19:05:58] INFO Ghost is running in production...
[2021-05-05 19:05:58] INFO Your site is now available on https://whatsgnu.today/
[2021-05-05 19:05:58] INFO Ctrl+C to shut down
[2021-05-05 19:05:58] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:05:58] WARN Tries: 0
[2021-05-05 19:05:58] WARN Retrying...
[2021-05-05 19:05:59] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:05:59] WARN Tries: 1
[2021-05-05 19:05:59] WARN Retrying...
[2021-05-05 19:05:59] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:05:59] WARN Tries: 2
[2021-05-05 19:05:59] WARN Retrying...
[2021-05-05 19:05:59] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:05:59] INFO Ghost server started in 1.445s
[2021-05-05 19:05:59] WARN Database state requires migration.
[2021-05-05 19:06:00] INFO Creating database backup
[2021-05-05 19:06:00] INFO Database backup written to: /var/www/ghost/content/data/whats-gnu-today.ghost.2021-05-05-19-06-00.json
[2021-05-05 19:06:00] INFO Adding posts.email_recipient_filter column
[2021-05-05 19:06:00] INFO Skipping rollback of members_signup_access setting. Does not exist.
[2021-05-05 19:06:00] INFO Resetting stripe_price_id column to empty in stripe customer subscriptions table
[2021-05-05 19:06:00] INFO Removing members_stripe_customers_subscriptions.stripe_price_id column
[2021-05-05 19:06:00] WARN Could not find setting `members_signup_access`, skipping rollback of `members_allow_free_signup` setting
[2021-05-05 19:06:00] ERROR Cannot remove permission(Delete Products) from role(Administrator) - permission does not exist
Cannot remove permission(Delete Products) from role(Administrator) - permission does not exist
"OuterError: alter table `posts` add `email_recipient_filter` varchar(50) not null default 'none' - ER_TOO_BIG_ROWSIZE: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"
Error ID:
400
----------------------------------------
RollbackError: Cannot remove permission(Delete Products) from role(Administrator) - permission does not exist
at RollbackError.KnexMigrateError (/var/www/ghost/versions/4.4.0/node_modules/knex-migrator/lib/errors.js:7:26)
at new RollbackError (/var/www/ghost/versions/4.4.0/node_modules/knex-migrator/lib/errors.js:31:26)
at /var/www/ghost/versions/4.4.0/node_modules/knex-migrator/lib/index.js:440:23
at tryCatcher (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:547:31)
at Promise._settlePromise (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:604:18)
at Promise._settlePromise0 (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:649:10)
at Promise._settlePromises (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/promise.js:725:18)
at _drainQueueStep (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:93:12)
at _drainQueue (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:86:9)
at Async._drainQueues (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:102:5)
at Immediate.Async.drainQueues [as _onImmediate] (/var/www/ghost/versions/4.4.0/node_modules/bluebird/js/release/async.js:15:14)
at processImmediate (internal/timers.js:461:21)
Error: Cannot remove permission(Delete Products) from role(Administrator) - permission does not exist
at down (/var/www/ghost/versions/4.4.0/core/server/data/migrations/utils.js:174:23)
at processTicksAndRejections (internal/process/task_queues.js:93:5)
at async Object.down (/var/www/ghost/versions/4.4.0/core/server/data/migrations/utils.js:281:13)
at async Object.down (/var/www/ghost/versions/4.4.0/core/server/data/migrations/utils.js:305:17)
at async Object.down (/var/www/ghost/versions/4.4.0/core/server/data/migrations/utils.js:305:17)
[2021-05-05 19:06:00] WARN Ghost is shutting down
[2021-05-05 19:06:00] WARN Can't connect to the bootstrap socket (localhost 8000) ECONNREFUSED.
[2021-05-05 19:06:00] WARN Tries: 0
[2021-05-05 19:06:00] WARN Retrying...
[2021-05-05 19:06:00] WARN Ghost has shut down
[2021-05-05 19:06:00] WARN Your site is now offline
[2021-05-05 19:06:00] WARN Ghost was running for a few seconds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment