Bug: 502 Bad Gateway on Personal Server (Ubuntu)

Steps to reproduce the behavior

visit https://focalboard.my.domain

Expected behavior

The page is successfully loaded.

Edition and Platform

• Edition: Personal Server
• Version: 0.9.2
• Browser and OS: Any and all.

Additional context

When I installed the Focalboard personal server, I created a mariadb database instead of using mysql, as I was already using mariadb for nextcloud, and installing mysql along side mariadb would be beyond my know how. I recall having some 502 issue at the time, but I eventually resolved it. Focalboard had been working for about a month since then, but is now failing to start after I restarted my debian 10 webserver.

Running systemctl status focalboard returns: ● focalboard.service - Focalboard server Loaded: loaded (/lib/systemd/system/focalboard.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Sat 2022-02-05 18:59:11 UTC; 4s ago Process: 32650 ExecStart=/opt/focalboard/bin/focalboard-server (code=exited, status=1/FAILURE) Main PID: 32650 (code=exited, status=1/FAILURE)

Running manually, as described here, returns: 2022/02/05 19:03:22 readConfigFile 2022/02/05 19:03:22 {ServerRoot:http://localhost:8000 Port:8000 DBType:mysql DBConfigString:boardsuser:_plainTextPasswordStringThatIDontFeelLikeSharing_@tcp(127.0.0.1:3306)/boards 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:./files Telemetry:true TelemetryID: PrometheusAddress::9092 WebhookUpdate:[] Secret: SessionExpireTime:2592000 SessionRefreshTime:18000 LocalOnly:false EnableLocalMode:true LocalModeSocketLocation:/var/tmp/focalboard_local.socket EnablePublicSharedBoards:false AuthMode:native LoggingCfgFile: LoggingCfgJSON: AuditCfgFile: AuditCfgJSON:} info [2022-02-05 19:03:22.574 Z] FocalBoard Server caller="mlog/mlog.go:218" version=0.9.2 edition=linux build_number=1320942631 build_date="Fri Oct 8 15:36:12 UTC 2021" build_hash=c632409feb1c6ea66851f99db8e0f92472b953fc error [2022-02-05 19:03:22.574 Z] Database Ping failed caller="mlog/mlog.go:228" error="commands out of sync. Did you run multiple statements at once?" fatal [2022-02-05 19:03:22.574 Z] server.NewStore ERROR caller="mlog/mlog.go:234" error="commands out of sync. Did you run multiple statements at once?" github.com/mattermost/focalboard/server/services/mlog.(*Logger).Fatal /home/runner/work/focalboard/focalboard/server/services/mlog/mlog.go"234 main.main /home/runner/work/focalboard/focalboard/server/main/main.go"165

From my googling, this seems to be an error with the version of mariadb I am using, but that conclusion is quite confusing to me, as mariadb had been working previously.

I don't know where to go from here, any and all help is appreciated.

Also set the Severity using the Sev/1, Sev/2 or Sev/3 labels as best you can:

• Sev/2: Issue affects major functionality with a difficult or non-obvious workaround