🐛 Solved - Bug: Altering database throws error when upgrading to 0.301.0 · Issue #12840 · nocodb/nocodb · GitHub
Skip to content

🐛 Solved - Bug: Altering database throws error when upgrading to 0.301.0 #12840

@WeT-Klb

Description

@WeT-Klb

Please confirm that the bug report does not already exist

  • I confirm there is no existing issue for this bug.

Steps to reproduce

After upgrading my docker installation I get the following errors:

Desired Behavior

Everything should work

Project Details

NocoDB Docker on MariaDB

Attachments

[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [NestFactory] Starting Nest application...
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] AppModule dependencies initialized +6ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] PassportModule dependencies initialized +0ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +0ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] MulterModule dependencies initialized +0ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] NotFoundHandlerModule dependencies initialized +0ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] ConfigHostModule dependencies initialized +0ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] DiscoveryModule dependencies initialized +1ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] ConfigModule dependencies initialized +2ms
[Nest] 7 - 01/13/2026, 8:05:29 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +0ms
[Nest] 7 - 01/13/2026, 8:05:29 PM ERROR [ExceptionHandler] alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
Error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:740:17)
at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:508:34)
at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:93:12)
at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket. (/usr/src/app/node_modules/mysql2/lib/base/connection.js:100:25)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
[nc_092_composite_pk] Starting composite primary key migration...
[nc_092_composite_pk] Adding version column to PROJECT table...
migration file "nc_092_composite_pk" failed
migration failed with error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [NestFactory] Starting Nest application...
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] AppModule dependencies initialized +5ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] PassportModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] MulterModule dependencies initialized +3ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] NotFoundHandlerModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] ConfigHostModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] DiscoveryModule dependencies initialized +2ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] ConfigModule dependencies initialized +2ms
[Nest] 8 - 01/13/2026, 8:06:59 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +3ms
[Nest] 8 - 01/13/2026, 8:06:59 PM ERROR [ExceptionHandler] alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
Error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:740:17)
at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:508:34)
at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:93:12)
at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket. (/usr/src/app/node_modules/mysql2/lib/base/connection.js:100:25)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
[nc_092_composite_pk] Starting composite primary key migration...
[nc_092_composite_pk] Adding version column to PROJECT table...
migration file "nc_092_composite_pk" failed
migration failed with error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [NestFactory] Starting Nest application...
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] AppModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] PassportModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] MulterModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] NotFoundHandlerModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] ConfigHostModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] DiscoveryModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] ConfigModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:08:12 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +3ms
[Nest] 8 - 01/13/2026, 8:08:12 PM ERROR [ExceptionHandler] alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
Error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:740:17)
at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:508:34)
at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:93:12)
at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket. (/usr/src/app/node_modules/mysql2/lib/base/connection.js:100:25)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
[nc_092_composite_pk] Starting composite primary key migration...
[nc_092_composite_pk] Adding version column to PROJECT table...
migration file "nc_092_composite_pk" failed
migration failed with error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [NestFactory] Starting Nest application...
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] AppModule dependencies initialized +20ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] PassportModule dependencies initialized +5ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +5ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] MulterModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] NotFoundHandlerModule dependencies initialized +0ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] ConfigHostModule dependencies initialized +2ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] DiscoveryModule dependencies initialized +1ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] ConfigModule dependencies initialized +3ms
[Nest] 8 - 01/13/2026, 8:09:31 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +2ms
[Nest] 8 - 01/13/2026, 8:09:31 PM ERROR [ExceptionHandler] alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
Error: alter table nc_bases_v2 add version smallint unsigned default '2' - Duplicate column name 'version'
at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:740:17)
at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:508:34)
at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/base/connection.js:93:12)
at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket. (/usr/src/app/node_modules/mysql2/lib/base/connection.js:100:25)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5

Metadata

Metadata

Assignees

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