Re: [Roundup-users] Docker Container 2.5.0 / UniqueViolation: duplicate key value violates unique constraint "_issue_pkey"

[Ralf S. <rs...@ru...>]

On Tue, Nov 04, 2025 at 08:56:50AM +0000, SCHLEMMER Norbert wrote:
> Hello
> 
> Well, I performed the following steps:
[...]

Apart from the additional import/export to PostgreSQL 17 this looks like
the process I also would use.


> I then compared the tracker directory with one from version 2.5.0 and
> noticed a few changes, apart from the message files, which I still
> want to look at in detail.

Hmm, there should be no changes in the db directory.

On Mon, Nov 03, 2025 at 09:31:04PM -0500, John Rouillard via Roundup-users wrote:

> Also one thing I thought of. If you are using the same tracker home,
> you can export just the database with no files using roundup-admin.
> Then import just the database data. That should speed up the process.
> My guess is the 6 hours load time was spent shuffling those 85000
> messages.

I don't think the messages would be the problem, In the past I noticed
that for large database tables our import code can take a long time...

Also glad it worked :-)

Kind regards
Ralf
-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: of...@ru...