Bug: Focalboard database error after upgrade 0.16.0 to 7.2.1

[fraschm1998]

Steps to reproduce the behavior

Mattermost updated from docker hub (mattermost/focalboard:7.2.1)

Expected behavior

For the update to work

Edition and Platform

• Edition: Personal Server
• Version: mattermost/focalboard:7.2.1
• Browser and OS: Brave/Firefox

Additional context (optional)

Error:

Attaching to focalboard
�[36mfocalboard         |�[0m 2022/08/24 15:36:49 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:36:49 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:49.627 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:49.628 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.634 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.635 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.635 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.635 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.635 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.636 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.636 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m 2022/08/24 15:36:49 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.636 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:49.637 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:36:49.637 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:36:49.637 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:36:50 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:36:50 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:50.574 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:50.575 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.580 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.582 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.582 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.585 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.585 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.585 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.585 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.586 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m 2022/08/24 15:36:50 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:50.587 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:36:50.587 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:36:50.587 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:36:52 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:36:52 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:52.219 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:52.220 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.225 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.226 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.226 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.226 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.226 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.226 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.226 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.227 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m 2022/08/24 15:36:52 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:52.228 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:36:52.228 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:36:52.228 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:36:53 readConfigFile
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:53.392 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m 2022/08/24 15:36:53 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:53.393 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.399 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.400 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.400 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.401 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.401 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.401 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.401 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.402 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m 2022/08/24 15:36:53 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:53.403 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:36:53.403 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:36:53.403 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:36:54 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:36:54 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:54.906 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:54.907 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.912 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.913 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.913 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.913 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.913 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.913 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.913 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.914 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:54.915 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:36:54.915 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:36:54 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:36:54.915 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:36:57 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:36:57 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:57.198 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:36:57.199 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.202 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.203 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.203 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.203 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.203 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.204 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.204 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.204 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m 2022/08/24 15:36:57 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:36:57.205 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:36:57.205 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:36:57.205 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:37:01 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:37:01 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:37:01.301 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:37:01.302 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.308 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.310 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.310 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.310 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.310 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.310 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.310 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m 2022/08/24 15:37:01 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.311 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:01.312 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:37:01.312 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:37:01.312 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:37:08 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:37:08 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:37:08.421 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:37:08.422 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.427 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.428 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.428 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.429 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.429 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.429 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.429 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.430 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m 2022/08/24 15:37:08 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:08.431 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:37:08.431 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:37:08.431 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m 2022/08/24 15:37:22 readConfigFile
�[36mfocalboard         |�[0m 2022/08/24 15:37:22 {ServerRoot:http://localhost:8000 Port:8000 DBType:sqlite3 DBConfigString:/data/focalboard.db DBTablePrefix: UseSSL:false SecureCookie:false WebPath:./pack FilesDriver:local FilesS3Config:{AccessKeyID: SecretAccessKey: Bucket: PathPrefix: Region: Endpoint: SSL:false SignV2:false SSE:false Trace:false} FilesPath:/data/files MaxFileSize:0 Telemetry:true TelemetryID: PrometheusAddress: WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false FeatureFlags:map[] EnableDataRetention:false DataRetentionDays:0 TeammateNameDisplay:username AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON: NotifyFreqCardSeconds:0 NotifyFreqBoardSeconds:0}
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:37:22.161 Z] FocalBoard Server                        �[36mcaller�[0m="main/main.go:57" �[36mversion�[0m=7.2.0 �[36medition�[0m=linux �[36mbuild_number�[0m=dev �[36mbuild_date�[0m=n/a �[36mbuild_hash�[0m=720563c170a9aee51c1e51abc8c2feffa4ce34c8
�[36mfocalboard         |�[0m �[36minfo�[0m  [2022-08-24 15:37:22.162 Z] connectDatabase                          �[36mcaller�[0m="sqlstore/sqlstore.go:44" �[36mdbType�[0m=sqlite3
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.167 Z] Creating migration engine                caller="sqlstore/migrate.go:198"
�[36mfocalboard         |�[0m 2022/08/24 15:37:22 ==  add_file_info: migrating  ======================================================================
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.168 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=14 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.168 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.169 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=18 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.169 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.169 Z] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:490" version=20 current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.169 Z] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:498"
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.169 Z] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:265" current_version=21
�[36mfocalboard         |�[0m debug [2022-08-24 15:37:22.170 Z] Closing migration engine                 caller="sqlstore/migrate.go:204"
�[36mfocalboard         |�[0m �[31merror�[0m [2022-08-24 15:37:22.170 Z] Table creation / migration failed        �[31mcaller�[0m="sqlstore/sqlstore.go:67" �[31merror�[0m="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m fatal [2022-08-24 15:37:22.170 Z] server.NewStore ERROR                    caller="main/main.go:146" error="driver: sqlite, message: failed when applying migration, command: apply_migration, originalError: UNIQUE constraint failed: schema_migrations.Version, query: 
�[36mfocalboard         |�[0m 
�[36mfocalboard         |�[0m INSERT INTO schema_migrations (Version, Name) VALUES (17, 'add_file_info')
�[36mfocalboard         |�[0m "
�[36mfocalboard         |�[0m   main.main
�[36mfocalboard         |�[0m       /go/src/focalboard/server/main/main.go:146
�[36mfocalboard         |�[0m   runtime.main
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/proc.go:250
�[36mfocalboard         |�[0m   runtime.goexit
�[36mfocalboard         |�[0m       /usr/local/go/src/runtime/asm_amd64.s:1571
�[36mfocalboard         |�[0m 

.schema:http://sprunge.us/xbJ37F

SELECT * FROM schema_migrations;

1|init
2|system_settings_table
3|blocks_rootid
4|auth_table
5|blocks_modifiedby
6|sharing_table
7|workspaces_table
8|teams
9|blocks_history
10|blocks_created_by
11|match_collation
12|match_column_collation
13|millisecond_timestamps
14|add_not_null_constraint
15|blocks_history_no_nulls
16|subscriptions_table
17|add_teams_and_boards
18|populate_categories
19|populate_category_blocks
20|create_boards_members_history
21|create_default_board_role

[XerofAdmin]

Same here, error initializing the Database, mariaDB is not supported - After Upgrade to mattermost 7.3.

[mvayak]

Same here, error initializing the Database, mariaDB is not supported - After Upgrade to mattermost 7.3.

https://prnt.sc/yE7po7hvwRMB

[henrikhj]

This is clearly an intended 'feature' according to #3725.
It seems that a bunch of the migration SQLs that are being run, are using the column->path operator even though the JSON_EXTRACT function could probably just as well have been used, which is supported in both MySQL and MariaDB.
Going from https://db-engines.com/en/ranking it seems that this decision has broken or is going to break about 10% of the installations using Mattermost Boards.
We have somewhere around 20-30 MariaDB instances running, and we are definitely not going to increase the complexity of our operations by having 20-30 MariaDB instances and one MySQL instance running. That's just not a wise business decision, seen from a resource, knowledge, and security perspective.

We are now stuck running Mattermost 7.3.0 with a broken Boards plugin that isn't able to start. That you have targeted a fix for the 7.5 release is not a viable solution for us.
Just a couple of months ago we moved a single team from monday.com onto Boards to evaluate the solution in real life conditions. If this is something that we have to calculate for, we will need to move that team back to monday.com and continue our search for a replacement. We can't have drastic changes like this affect our entire organisation any time we update our installation.

I know that one argument for this change is that MariaDB was never supported. Nevertheless we have run Mattermost on MariaDB for almost a year now, with no issues whatsoever. Boards was also running just fine for months, up until an hour ago where this update killed it completely. We can obviously roll back to the pre-update backup, but this leaves us unprotected from the security vulnerability that 7.3.0 fixes.

One should probably also take the industry trend into account in cases like this.

[agnivade]

Hi @henrikhj, my apologies that you are encountering this. We have indeed some users using just Mattermost experiencing this as well (mattermost/mattermost#18351). I just wanted to point a small thing:

Nevertheless we have run Mattermost on MariaDB for almost a year now, with no issues whatsoever.

I believe this was due to sheer luck, or you just haven't run into edge cases. Mattermost is broken with MariaDB from atleast 6.7 onwards.

In short, atleast on the server side, we have never supported or tested our code with MariaDB. Some users do use MariaDB, but we'd suggest to migrate to either MySQL or Postgres for full and complete support.

I do understand that it's a massive pain for you, but I have outlined some of the reasons to do this here: https://community.mattermost.com/core/pl/5m9mnur4ejn9z8c7c9dipaw7jc. Hopefully that puts things in context.

Recently, we have started to throw a warning in the server logs, if we detect MariaDB to be the database used.

[henrikhj]

I definitely understand the business decision on your end, to not support several different RDMSes. It's a lot of work.
I do however wonder why the decision was made to go against the popular choice these days. But I guess that ship has sailed a long time ago.

What annoys me the most is that we evaluated the software from the belief that it would work perfectly fine on our MariaDB infrastructure, and has now worked for about a year, without me ever noticing that there wasn't support for MariaDB (I know, I'm also to blame, for just blindly assuming there was support).

Had I known there was an active choice to not support MariaDB, our evaluation of Mattermost would quite possibly have gone differently, because we don't want to support MySQL technically in house, nor indirectly support Oracle politically.

The day you decided to drop support for MariaDB you should have prevented the software from starting at all, instead of opening up customers to this road down a doubtful path that has now inevitably ended up in a weird limbo that isn't easily fixed technically nor practically with the degree of vendor lock-in that will alway occur when training people to use new software.
A warning in a log file isn't enough. That will only be seen, if one goes on a debugging hunt and when the damage has already been done.

[agnivade]

The day you decided to drop support for MariaDB you should have prevented the software from starting at all, instead of opening up customers to this road down a doubtful path

Fully agree with you there. The only problem there is someone needs to spend the time to provide an official migration script from MariaDB to MySQL/Postgres. We just haven't had the time to do that. There is some discussion here: mattermost/mattermost#18351. I'll look into prioritizing that for next quarter.

[wuwinson]

@henrikhj @fraschm1998 @XerofAdmin @mvayak

I'm sorry to hear that you're all running into this issue with MariaDB. As @agnivade mentioned, we don't officially support MariaDB, but we should have made it more obvious aside from the documentation and a warning in the logs.

To help mitigate this issue, we're working on #3929 and plan to ship it as a point release for v7.4 which should at least fix the Boards plugin and give you more time to decide how you'd like to move forward with Mattermost Boards.

Again, apologies for this experience. We understand this might be frustrating and upsetting, but we recommend migrating from MariaDB to the MySQL equivalent to continue using Boards. While Boards may work with MariaDB, we cannot guarantee that it will continue to work in future releases.

cc @sbishel @mgdelacroix

[XerofAdmin]

Thank you @wuwinson , from my side, I just switched over to MySQL, so all my environments are fine. But this has forced me to kick out mariaDB on those servers, so I had to switch my web apps over too. The people over @ mariadb might not be too happy with you :)

[XerofAdmin]

The day you decided to drop support for MariaDB you should have prevented the software from starting at all, instead of opening up customers to this road down a doubtful path

Fully agree with you there. The only problem there is someone needs to spend the time to provide an official migration script from MariaDB to MySQL/Postgres. We just haven't had the time to do that. There is some discussion here: mattermost/mattermost-server#18351. I'll look into prioritizing that for next quarter.

sudo mysqldump mattermost > mattermost.sql
sudo systemctl stop mysql
sudo apt purge -y mariadb-server mysql-server mysql-common mysql-client mysql*
sudo rm -rf rm -rf /var/lib/mysql && sudo rm -rf rm -rf /etc/mysql*
sudo reboot
sudo apt install -y mysql-server
sudo systemctl status mysql
sudo mysql_secure_installation
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
sudo mysql -e "CREATE DATABASE mattermost DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;CREATE USER 'mmuser'@'localhost' IDENTIFIED BY 'xxx';GRANT ALL ON mattermost.* TO 'mmuser'@'localhost';flush privileges;"
sudo mysql mattermost < mattermost.sql