Skip to content

Error updating ghost 5.23.0 to 5.24.0 #353

New issue
New issue
Closed
Closed
Error updating ghost 5.23.0 to 5.24.0#353
@thiangm

Description

@thiangm
thiangm
opened on 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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions