Bug: migration issue re: pg_type_typname_nsp_index

[lieut-data]

Steps to reproduce the behavior

{"timestamp":"2022-07-13 08:47:42.449 Z","level":"error","msg":"Failed to install prepackaged plugin","path":"/mattermost/prepackaged_plugins/focalboard-v7.0.1-linux-amd64.tar.gz","error":"Failed to install extracted prepackaged plugin /mattermost/prepackaged_plugins/focalboard-v7.0.1-linux-amd64.tar.gz: installExtractedPlugin: Unable to restart plugin on upgrade., error initializing the DB: migration failed: duplicate key value violates unique constraint \"pg_type_typname_nsp_index\", Key (typname, typnamespace)=(focalboard_workspaces, 5716503) already exists. in line 0: CREATE TABLE IF NOT EXISTS focalboard_workspaces (
    id VARCHAR(36),
    signup_token VARCHAR(100) NOT NULL,
    settings JSON,
    modified_by VARCHAR(36),
    update_at BIGINT,
    PRIMARY KEY (id)
) ;
 (details: pq: duplicate key value violates unique constraint \"pg_type_typname_nsp_index\")","stacktrace":[{"Function":"github.com/mattermost/mattermost-server/v6/app.(*Channels).processPrepackagedPlugins.func2","File":"github.com/mattermost/mattermost-server/v6/app/plugin.go","Line":947},{"Function":"runtime.goexit","File":"runtime/asm_amd64.s","Line":1571}]}
{"timestamp":"2022-07-13 08:47:42.433 Z","level":"error","msg":"Table creation / migration failed","plugin_id":"focalboard","error":"\"migration failed: duplicate key value violates unique constraint \"pg_type_typname_nsp_index\", Key (typname, typnamespace)=(focalboard_workspaces, 5716503) already exists. in line 0: CREATE TABLE IF NOT EXISTS focalboard_workspaces (
    id VARCHAR(36),
    signup_token VARCHAR(100) NOT NULL,
    settings JSON,
    modified_by VARCHAR(36),
    update_at BIGINT,
    PRIMARY KEY (id)
) ;
 (details: pq: duplicate key value violates unique constraint \"pg_type_typname_nsp_index\")\"","stacktrace":[{"Function":"github.com/mattermost/mattermost-server/v6/app.(*PluginAPI).LogError","File":"github.com/mattermost/mattermost-server/v6/app/plugin_api.go","Line":940},{"Function":"github.com/mattermost/mattermost-server/v6/plugin.(*apiTimerLayer).LogError","File":"github.com/mattermost/mattermost-server/v6/plugin/api_timer_layer_generated.go","Line":1058},{"Function":"github.com/mattermost/mattermost-server/v6/plugin.(*apiRPCServer).LogError","File":"github.com/mattermost/mattermost-server/v6/plugin/client_rpc.go","Line":814},{"Function":"reflect.Value.call","File":"reflect/value.go","Line":556},{"Function":"reflect.Value.Call","File":"reflect/value.go","Line":339},{"Function":"net/rpc.(*service).call","File":"net/rpc/server.go","Line":381},{"Function":"runtime.goexit","File":"runtime/asm_amd64.s","Line":1571}]}

Expected behavior

See https://community.mattermost.com/core/pl/astrw13wppgn8ni7afxjxb4soo.

Screenshots (optional)

N/A

Edition and Platform

• Edition: Mattermost Boards (plugin)
• Version: Cloud
• Browser and OS: N/A

Additional context (optional)

Severity unknown.

[wuwinson]

@mgdelacroix Is this something we should consider for v7.2? Let's chat about this in our meeting tomorrow. Thanks!