• Gogs version (or commit ref): 0.9.48.0722
• Git version: 2.1.4
• Operating system: Debian 8/jessie
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • SQLite
• Can you reproduce the bug at https://try.gogs.io:
  • Yes (provide example URL)
  • No
  • Not relevant
• Log gist: https://gist.github.com/jerrykan/95944b21de45b303523bc3e48f76b207

After running a clean install the DB seems to be initialised OK, but when gogs is restarted I get the following error:

[...s/routers/install.go:71 GlobalInit()] [E] Fail to initialize ORM engine: sync database struct error: pq: relation "UQE_user_lower_name" already exists

I tried dropping the user table to see if it would be regenerated (which it is), but then gogs falls over with:

[...s/routers/install.go:71 GlobalInit()] [E] Fail to initialize ORM engine: sync database struct error: pq: relation "IDX_public_key_owner_id" already exists

Looking at the logs (linked above) it seems as though the indexes are trying to be created even though they already exist.