Bugzilla Migration to new server issue

Thorsten Schöning tschoening at am-soft.de
Mon Sep 27 18:45:18 UTC 2021

Guten Tag derek.bennett at attaininsight.com,
am Montag, 27. September 2021 um 19:58 schrieben Sie:

> After giving up migrating Bugzilla to a Windows Server,

Was a bad idea most likely anyway, as multiple Bugzilla features won't
work at all or only difficult to setup.

> Adding new table bz_schema...
> DBD::Pg::db do failed: ERROR:  relation "bz_schema" already exists at
> Bugzilla/DB.pm line 848.

This means your migration process was wrong and you restored most
likely only parts of the former database. Bugzilla maintaines its
schema within the databse to decide what needs to be
created/migrated/... during upgrades. bz_schema is the table storing
those data and therefore not expected to be missed/damaged/... at all.

One mistake additionally often done is running checksetup.pl on an
empty database and import some backup afterwards. That most likely
won't work as well.

> ERROR:  could not open extension control file
> "/usr/share/postgresql/10/extension/pg_repack.control": No such file or
> directory

This has nothing to do with Bugzilla itself, you simply created the
database differently than before. Seems like you installed that
extension at some point and removed it or alike.

Mit freundlichen Grüßen

Thorsten Schöning

AM-SoFT IT-Service - Bitstore Hameln GmbH
Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK

E-Mail: Thorsten.Schoening at AM-SoFT.de
Web:    http://www.AM-SoFT.de/

Tel:   05151-  9468- 0
Tel:   05151-  9468-55
Fax:   05151-  9468-88
Mobil:  0178-8 9468-04

AM-SoFT IT-Service - Bitstore Hameln GmbH, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 221853 - Geschäftsführer: Janine Galonska

More information about the support-list mailing list