Database dump contains no data when using "gitea dump -d postgres"

[mpraeger]

• Gitea version (or commit ref): 1.6.3, 17.0-rc2
• Git version: 2.20.1
• Operating system: FreeBSD 11.2
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No
  • Not relevant
• Log gist:

Description

I'm trying to migrate from MySQL to PostgreSQL and was advised (see #5651) that using gitea dump -d postgres might work. While this does indeed produce an SQL dump the inserts do not contain any data (see dump.txt ).

I've used the following command:

gitea dump -c /usr/local/etc/gitea/conf/app.ini -d postgres

If there's anything missing or further information is required I'd be more than happy to provide it.

Thanks!

Screenshots

[typeless]

Maybe you can try to add '-v' to get more details.

Edit: Looking at the log message and https://github.com/go-gitea/gitea/blob/master/cmd/dump.go might give some clues.

[mpraeger]

Absolutely: gitea_dump_verbose.txt

Unfortunately gitea does not seem to be logging much for the database dump.

[typeless]

@mpraeger Do you have the log file xorm.log in the generated zip file?

[mpraeger]

@typeless Had to create a new dump, but sure: xorm.log

[mpraeger]

I've just tested dumping to sqlite3, that produced a proper dump.

[mpraeger]

Alright so going from MySQL to sqlite3 and then issuing gitea dump -d postgres produces a proper dump.

[gzsombor]

I accidentally found the same issue, and figured out, how to fix : go-xorm/xorm#1186

[lunny]

@gzsombor merged in that xorm's PR, please send a vendor update PR on gitea.

[techknowlogick]

Closed with #5680