docker-library / ghost

Docker Official Image packaging for Ghost
https://hub.docker.com/_/ghost
MIT License
720 stars 311 forks source link

Error updating ghost 5.23.0 to 5.24.0 #353

Closed thiangm closed 1 year ago

thiangm commented 1 year ago

container log

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

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:39:25] WARN Ghost is shutting down
[2022-11-28 17:39:25] WARN Ghost has shut down
[2022-11-28 17:39:25] WARN Your site is now offline
[2022-11-28 17:39:25] WARN Ghost was running for a few seconds
[2022-11-28 17:39:32] INFO Ghost is running in production...
[2022-11-28 17:39:32] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:32] INFO Ctrl+C to shut down
[2022-11-28 17:39:32] INFO Ghost server started in 2.382s
[2022-11-28 17:39:32] WARN Database state requires migration.
[2022-11-28 17:39:33] INFO Creating database backup
[2022-11-28 17:39:34] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-33.json
[2022-11-28 17:39:34] INFO Running migrations.
[2022-11-28 17:39:34] INFO Adding emails.source column
[2022-11-28 17:39:34] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:34] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:34] INFO Rollback was successful.
[2022-11-28 17:39:34] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:39:34] WARN Ghost is shutting down
[2022-11-28 17:39:34] WARN Ghost has shut down
[2022-11-28 17:39:34] WARN Your site is now offline
[2022-11-28 17:39:34] WARN Ghost was running for a few seconds
[2022-11-28 17:39:40] INFO Ghost is running in production...
[2022-11-28 17:39:40] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:40] INFO Ctrl+C to shut down
[2022-11-28 17:39:40] INFO Ghost server started in 2.23s
[2022-11-28 17:39:41] WARN Database state requires migration.
[2022-11-28 17:39:42] INFO Creating database backup
[2022-11-28 17:39:43] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-42.json
[2022-11-28 17:39:43] INFO Running migrations.
[2022-11-28 17:39:43] INFO Adding emails.source column
[2022-11-28 17:39:43] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:43] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:43] INFO Rollback was successful.
[2022-11-28 17:39:43] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:39:43] WARN Ghost is shutting down
[2022-11-28 17:39:43] WARN Ghost has shut down
[2022-11-28 17:39:43] WARN Your site is now offline
[2022-11-28 17:39:43] WARN Ghost was running for a few seconds
[2022-11-28 17:39:49] INFO Ghost is running in production...
[2022-11-28 17:39:49] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:49] INFO Ctrl+C to shut down
[2022-11-28 17:39:49] INFO Ghost server started in 2.421s
[2022-11-28 17:39:50] WARN Database state requires migration.
[2022-11-28 17:39:51] INFO Creating database backup
[2022-11-28 17:39:51] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-39-51.json
[2022-11-28 17:39:51] INFO Running migrations.
[2022-11-28 17:39:52] INFO Adding emails.source column
[2022-11-28 17:39:52] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:39:52] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:39:52] INFO Rollback was successful.
[2022-11-28 17:39:52] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:39:52] WARN Ghost is shutting down
[2022-11-28 17:39:52] WARN Ghost has shut down
[2022-11-28 17:39:52] WARN Your site is now offline
[2022-11-28 17:39:52] WARN Ghost was running for a few seconds
[2022-11-28 17:39:58] INFO Ghost is running in production...
[2022-11-28 17:39:58] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:39:58] INFO Ctrl+C to shut down
[2022-11-28 17:39:58] INFO Ghost server started in 2.187s
[2022-11-28 17:39:59] WARN Database state requires migration.
[2022-11-28 17:40:00] INFO Creating database backup
[2022-11-28 17:40:00] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-00.json
[2022-11-28 17:40:00] INFO Running migrations.
[2022-11-28 17:40:00] INFO Adding emails.source column
[2022-11-28 17:40:01] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:01] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:01] INFO Rollback was successful.
[2022-11-28 17:40:01] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:40:01] WARN Ghost is shutting down
[2022-11-28 17:40:01] WARN Ghost has shut down
[2022-11-28 17:40:01] WARN Your site is now offline
[2022-11-28 17:40:01] WARN Ghost was running for a few seconds
[2022-11-28 17:40:07] INFO Ghost is running in production...
[2022-11-28 17:40:07] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:07] INFO Ctrl+C to shut down
[2022-11-28 17:40:07] INFO Ghost server started in 1.882s
[2022-11-28 17:40:08] WARN Database state requires migration.
[2022-11-28 17:40:09] INFO Creating database backup
[2022-11-28 17:40:10] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-09.json
[2022-11-28 17:40:10] INFO Running migrations.
[2022-11-28 17:40:10] INFO Adding emails.source column
[2022-11-28 17:40:10] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:10] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:10] INFO Rollback was successful.
[2022-11-28 17:40:10] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:40:10] WARN Ghost is shutting down
[2022-11-28 17:40:10] WARN Ghost has shut down
[2022-11-28 17:40:10] WARN Your site is now offline
[2022-11-28 17:40:10] WARN Ghost was running for a few seconds
[2022-11-28 17:40:19] INFO Ghost is running in production...
[2022-11-28 17:40:19] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:19] INFO Ctrl+C to shut down
[2022-11-28 17:40:19] INFO Ghost server started in 2.49s
[2022-11-28 17:40:19] WARN Database state requires migration.
[2022-11-28 17:40:20] INFO Creating database backup
[2022-11-28 17:40:21] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-20.json
[2022-11-28 17:40:21] INFO Running migrations.
[2022-11-28 17:40:21] INFO Adding emails.source column
[2022-11-28 17:40:21] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:22] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:22] INFO Rollback was successful.
[2022-11-28 17:40:22] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:40:22] WARN Ghost is shutting down
[2022-11-28 17:40:22] WARN Ghost has shut down
[2022-11-28 17:40:22] WARN Your site is now offline
[2022-11-28 17:40:22] WARN Ghost was running for a few seconds
[2022-11-28 17:40:33] INFO Ghost is running in production...
[2022-11-28 17:40:33] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:33] INFO Ctrl+C to shut down
[2022-11-28 17:40:33] INFO Ghost server started in 2.501s
[2022-11-28 17:40:34] WARN Database state requires migration.
[2022-11-28 17:40:35] INFO Creating database backup
[2022-11-28 17:40:35] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-35.json
[2022-11-28 17:40:35] INFO Running migrations.
[2022-11-28 17:40:36] INFO Adding emails.source column
[2022-11-28 17:40:36] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:36] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:36] INFO Rollback was successful.
[2022-11-28 17:40:36] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:40:36] WARN Ghost is shutting down
[2022-11-28 17:40:36] WARN Ghost has shut down
[2022-11-28 17:40:36] WARN Your site is now offline
[2022-11-28 17:40:36] WARN Ghost was running for a few seconds
[2022-11-28 17:40:54] INFO Ghost is running in production...
[2022-11-28 17:40:54] INFO Your site is now available on https://blog.genki.site/
[2022-11-28 17:40:54] INFO Ctrl+C to shut down
[2022-11-28 17:40:54] INFO Ghost server started in 2.478s
[2022-11-28 17:40:55] WARN Database state requires migration.
[2022-11-28 17:40:56] INFO Creating database backup
[2022-11-28 17:40:56] INFO Database backup written to: /var/lib/ghost/content/data/genki.ghost.2022-11-28-17-40-56.json
[2022-11-28 17:40:57] INFO Running migrations.
[2022-11-28 17:40:57] INFO Adding emails.source column
[2022-11-28 17:40:57] INFO 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] WARN Removing emails.source_type column - skipping as table is correct
[2022-11-28 17:40:57] WARN Removing emails.source column - skipping as table is correct
[2022-11-28 17:40:57] INFO Rollback was successful.
[2022-11-28 17:40:57] ERROR alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

alter table `emails` add `source` longtext null, algorithm=copy - Got error 168 - 'Unknown (generic) error from engine' from storage engine

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

Error ID:
    300

Error Code: 
    ER_GET_ERRNO

----------------------------------------

Error: 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)

[2022-11-28 17:40:57] WARN Ghost is shutting down
[2022-11-28 17:40:57] WARN Ghost has shut down
[2022-11-28 17:40:57] WARN Your site is now offline
[2022-11-28 17:40:57] WARN 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.