Error updating ghost 5.23.0 to 5.24.0 #355

thiangm · 2022-11-28T17:47:12Z

thiangm
Nov 28, 2022

container log

[2022-11-28 17:39:22] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:39:22] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:22] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:39:22] �[36mINFO�[39m Ghost server started in 3.298s
[2022-11-28 17:39:23] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:39:24] �[36mINFO�[39m Creating database backup
[2022-11-28 17:39:25] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-24.json
[2022-11-28 17:39:25] �[36mINFO�[39m Running migrations.
[2022-11-28 17:39:25] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:39:25] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:39:25] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:25] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:25] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:39:25] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:39:25] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:39:25] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:39:25] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:39:25] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:39:32] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:39:32] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:32] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:39:32] �[36mINFO�[39m Ghost server started in 2.382s
[2022-11-28 17:39:32] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:39:33] �[36mINFO�[39m Creating database backup
[2022-11-28 17:39:34] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-33.json
[2022-11-28 17:39:34] �[36mINFO�[39m Running migrations.
[2022-11-28 17:39:34] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:39:34] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:39:34] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:34] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:34] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:39:34] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:39:34] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:39:34] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:39:34] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:39:34] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:39:40] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:39:40] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:40] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:39:40] �[36mINFO�[39m Ghost server started in 2.23s
[2022-11-28 17:39:41] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:39:42] �[36mINFO�[39m Creating database backup
[2022-11-28 17:39:43] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-42.json
[2022-11-28 17:39:43] �[36mINFO�[39m Running migrations.
[2022-11-28 17:39:43] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:39:43] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:39:43] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:43] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:43] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:39:43] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:39:43] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:39:43] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:39:43] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:39:43] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:39:49] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:39:49] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:49] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:39:49] �[36mINFO�[39m Ghost server started in 2.421s
[2022-11-28 17:39:50] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:39:51] �[36mINFO�[39m Creating database backup
[2022-11-28 17:39:51] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-51.json
[2022-11-28 17:39:51] �[36mINFO�[39m Running migrations.
[2022-11-28 17:39:52] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:39:52] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:39:52] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:52] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:52] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:39:52] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:39:52] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:39:52] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:39:52] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:39:52] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:39:58] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:39:58] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:58] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:39:58] �[36mINFO�[39m Ghost server started in 2.187s
[2022-11-28 17:39:59] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:40:00] �[36mINFO�[39m Creating database backup
[2022-11-28 17:40:00] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-00.json
[2022-11-28 17:40:00] �[36mINFO�[39m Running migrations.
[2022-11-28 17:40:00] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:40:01] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:40:01] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:01] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:01] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:40:01] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:40:01] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:40:01] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:40:01] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:40:01] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:40:07] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:40:07] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:07] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:40:07] �[36mINFO�[39m Ghost server started in 1.882s
[2022-11-28 17:40:08] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:40:09] �[36mINFO�[39m Creating database backup
[2022-11-28 17:40:10] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-09.json
[2022-11-28 17:40:10] �[36mINFO�[39m Running migrations.
[2022-11-28 17:40:10] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:40:10] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:40:10] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:10] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:10] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:40:10] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:40:10] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:40:10] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:40:10] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:40:10] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:40:19] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:40:19] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:19] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:40:19] �[36mINFO�[39m Ghost server started in 2.49s
[2022-11-28 17:40:19] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:40:20] �[36mINFO�[39m Creating database backup
[2022-11-28 17:40:21] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-20.json
[2022-11-28 17:40:21] �[36mINFO�[39m Running migrations.
[2022-11-28 17:40:21] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:40:21] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:40:22] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:22] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:22] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:40:22] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:40:22] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:40:22] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:40:22] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:40:22] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:40:33] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:40:33] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:33] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:40:33] �[36mINFO�[39m Ghost server started in 2.501s
[2022-11-28 17:40:34] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:40:35] �[36mINFO�[39m Creating database backup
[2022-11-28 17:40:35] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-35.json
[2022-11-28 17:40:35] �[36mINFO�[39m Running migrations.
[2022-11-28 17:40:36] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:40:36] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:40:36] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:36] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:36] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:40:36] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:40:36] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:40:36] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:40:36] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:40:36] �[35mWARN�[39m Ghost was running for a few seconds
[2022-11-28 17:40:54] �[36mINFO�[39m Ghost is running in production...
[2022-11-28 17:40:54] �[36mINFO�[39m Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:54] �[36mINFO�[39m Ctrl+C to shut down
[2022-11-28 17:40:54] �[36mINFO�[39m Ghost server started in 2.478s
[2022-11-28 17:40:55] �[35mWARN�[39m Database state requires migration.
[2022-11-28 17:40:56] �[36mINFO�[39m Creating database backup
[2022-11-28 17:40:56] �[36mINFO�[39m Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-56.json
[2022-11-28 17:40:57] �[36mINFO�[39m Running migrations.
[2022-11-28 17:40:57] �[36mINFO�[39m Adding emails.source column
[2022-11-28 17:40:57] �[36mINFO�[39m Rolling back: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine.
[2022-11-28 17:40:57] �[35mWARN�[39m Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:57] �[35mWARN�[39m Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:57] �[36mINFO�[39m Rollback was successful.
[2022-11-28 17:40:57] �[31mERROR�[39m alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
�[31m
�[31malter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine�[39m

�[37m{"config":{"transaction":false},"name":"2022-11-21-09-32-add-source-columns-to-emails-table.js"}�[39m
�[33m"Error occurred while executing the following migration: 2022-11-21-09-32-add-source-columns-to-emails-table.js"�[39m

�[1m�[37mError ID:�[39m�[22m
    �[90m300�[39m

�[1m�[37mError Code: �[39m�[22m
    �[90mER_GET_ERRNO�[39m

�[90m----------------------------------------�[39m

�[90mError: alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine
    at /var/lib/ghost/versions/5.24.1/node_modules/knex-migrator/lib/index.js:1032:19
    at Packet.asError (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Query.execute (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:456:32)
    at PacketParser.onPacket (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:85:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket. (/var/lib/ghost/versions/5.24.1/node_modules/mysql2/lib/connection.js:92:25)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)�[39m
�[39m
[2022-11-28 17:40:57] �[35mWARN�[39m Ghost is shutting down
[2022-11-28 17:40:57] �[35mWARN�[39m Ghost has shut down
[2022-11-28 17:40:57] �[35mWARN�[39m Your site is now offline
[2022-11-28 17:40:57] �[35mWARN�[39m Ghost was running for a few seconds

I stopped the container with the latest version and ran the container with version 5.23.0 and it works normally.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error updating ghost 5.23.0 to 5.24.0 #355

{{title}}

Replies: 0 comments

Select a reply

Error updating ghost 5.23.0 to 5.24.0 #355

thiangm Nov 28, 2022

Replies: 0 comments

thiangm
Nov 28, 2022