Problems after restoring bugzilla database

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Problems after restoring bugzilla database

Buch, Christian-2
Hello,

we have to move bugzilla to a new host.

I installed Bugzilla Version 5.0.3 at the new machine.

Afterwards, I created a blank database as described:
mysql -u root -p**** -e "CREATE DATABASE bugs DEFAULT CHARACTER SET utf8;"

./checksetup.pl was okay.

I backed up the database on the old host (Bugzilla Version 4.4.4):
mysqldump -uroot -p***** bugs > /backup/bugsdump.sql

Copied the dump file to the new host.

I restored the database on the new host:
mysql -uroot -p***** bugs < /backup/bugsdump.sql

./checksetup.pl aborted with this error:
DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist [for Statement "DESCRIBE bugs"] at Bugzilla/DB/Mysql.pm line 868.
        Bugzilla::DB::Mysql::bz_enum_initial_values('Bugzilla::DB::Mysql=HASH(0x84ed940)') called at Bugzilla/DB.pm line 525
        Bugzilla::DB::bz_populate_enum_tables('Bugzilla::DB::Mysql=HASH(0x84ed940)') called at ./checksetup.pl line 123

The error at the web frontend looks like this:
DBD::mysql::db selectcol_arrayref failed: Table 'bugs.bugs' doesn't exist [for Statement "SELECT bugs.bug_id AS bug_id, bugs.priority AS priority, bugs.bug_severity AS bug_severity
  FROM bugs
LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id
INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value
INNER JOIN bug_severity AS map_bug_severity ON bugs.bug_severity = map_bug_severity.value
WHERE bugs.creation_ts IS NOT NULL
   AND  (security_map.group_id IS NULL OR security_map.group_id IN (-1))
   AND  bugs.bug_status IN ('UNCONFIRMED','CONFIRMED','IN_PROGRESS')
GROUP BY bugs.bug_id
ORDER BY map_priority.sortkey, map_priority.value, map_bug_severity.sortkey, map_bug_severity.value
LIMIT 2000
"] at Bugzilla/Search.pm line 775, <DATA> line 558.
        Bugzilla::Search::data('Bugzilla::Search=HASH(0x591e0e0)') called at /srv/www/bugzilla/buglist.cgi line 742



Any ideas?

Thanks.



Mit engagierten Grüßen / best regards,

i. A. Christian Buch
[cid:image001.jpg@01D5A907.BF0049B0]<https://www.gib.world/>

Christian Buch

GIB mbH


Martinshardt 19


57074 Siegen

IT Services

Germany


Phone: +49 271 238 71 4000

www.gib.world<https://www.gib.world>

Fax: +49 271 238 71 4999

[cid:image002.png@01D5A907.BF0049B0]Skype for Business<sip:[hidden email]>

Mail: [hidden email]



G.I.B Gesellschaft für Information und Bildung mbH
Martinshardt 19, 57074 Siegen
Sitz der Gesellschaft: Siegen; Amtsgericht Siegen HR B 3920
Geschäftsführer: Björn Dunkel

SAP Partner

Der Inhalt dieser Nachricht ist vertraulich und nur für den angegebenen Empfänger bestimmt. Jede Form der Kenntnisnahme oder Weitergabe durch Dritte ist unzulässig. Sollte diese Nachricht nicht für Sie bestimmt sein, so bitten wir Sie, sich mit uns per E-Mail oder telefonisch in Verbindung zu setzen und alle Kopien zu vernichten. Vielen Dank
This message is confidential and may be privileged, and maybe not used or disseminated by anyone other than the intended recipient. If received in error, please notify the sender immediately, and destroy all copies. Thank you.
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

AW: Problems after restoring bugzilla database

Buch, Christian-2
Hello,

I'm so sorry, running the ./checksetup.pl after restoring and not directly after creating the database fixed the problem.

Thanks for your help.


Mit engagierten Grüßen / best regards,

Christian Buch



IT Services



GIB mbH
Martinshardt 19
57074 Siegen
Germany

Phone: +49 271 238 71 4000
Fax: +49 271 238 71 4999
Mail: [hidden email]
https://www.gib.world/


G.I.B Gesellschaft für Information und Bildung mbH
Martinshardt 19, 57074 Siegen
Sitz der Gesellschaft: Siegen; Amtsgericht Siegen HR B 3920
Geschäftsführer: Björn Dunkel

SAP Partner

Der Inhalt dieser Nachricht ist vertraulich und nur für den angegebenen Empfänger bestimmt. Jede Form der Kenntnisnahme oder Weitergabe durch Dritte ist unzulässig. Sollte diese Nachricht nicht für Sie bestimmt sein, so bitten wir Sie, sich mit uns per E-Mail oder telefonisch in Verbindung zu setzen und alle Kopien zu vernichten. Vielen Dank
This message is confidential and may be privileged, and maybe not used or disseminated by anyone other than the intended recipient. If received in error, please notify the sender immediately, and destroy all copies. Thank you.

-----Ursprüngliche Nachricht-----
Von: support-bugzilla <[hidden email]> Im Auftrag von Thorsten Schöning
Gesendet: Montag, 2. Dezember 2019 12:31
An: [hidden email]
Betreff: Re: Problems after restoring bugzilla database

Guten Tag Buch, Christian,
am Montag, 2. Dezember 2019 um 11:58 schrieben Sie:

> I installed Bugzilla Version 5.0.3 at the new machine.

You were following the docs, correct?

https://urldefense.proofpoint.com/v2/url?u=https-3A__bugzilla.readthedocs.io_en_5.0_installing_moving.html&d=DwIFAw&c=riR7jviByh3sGm7GIiSlHkFN0_aSATB6A8x0nHa2EM0&r=2HIcYFn5NRKZZLo9eRGXfwbSma672VplbpdiGv9WKCA&m=gFC0TXDzyl29WR6Yg6xu2leDUuY7CILGdII1Epw0e84&s=VEQJItptqm2XPkDPpZYDXTQMwwnwv5t-KkNz42t2eV8&e= 

> Afterwards, I created a blank database as described:
> mysql -u root -p**** -e "CREATE DATABASE bugs DEFAULT CHARACTER SET utf8;"

> ./checksetup.pl was okay.

That means you installed a new fresh 5.0.3 database schema into your formerly empty database. Look at the docs carefully, that's the reason why they don't advise to run checksetup.pl after creating the database.

> ./checksetup.pl aborted with this error:
> DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist [for
> Statement "DESCRIBE bugs"] at Bugzilla/DB/Mysql.pm line 868.

Look at your dump, if that really contains all the tables and stuff related to Bugzilla. Besides that, you NEED to restore the dump into an empty database, which wasn't the case for you.

> The error at the web frontend looks like this:

No need to look at the web frontend until checksetup.pl succeeds.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning       E-Mail: [hidden email]
AM-SoFT IT-Systeme      https://urldefense.proofpoint.com/v2/url?u=http-3A__www.AM-2DSoFT.de_&d=DwIFAw&c=riR7jviByh3sGm7GIiSlHkFN0_aSATB6A8x0nHa2EM0&r=2HIcYFn5NRKZZLo9eRGXfwbSma672VplbpdiGv9WKCA&m=gFC0TXDzyl29WR6Yg6xu2leDUuY7CILGdII1Epw0e84&s=FURfsmJ9VgTV_ZcsJZftHFOA8byRJrSoHP8w_l_OYYM&e= 

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

_______________________________________________
support-bugzilla mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.mozilla.org_listinfo_support-2Dbugzilla&d=DwIFAw&c=riR7jviByh3sGm7GIiSlHkFN0_aSATB6A8x0nHa2EM0&r=2HIcYFn5NRKZZLo9eRGXfwbSma672VplbpdiGv9WKCA&m=gFC0TXDzyl29WR6Yg6xu2leDUuY7CILGdII1Epw0e84&s=Pn_9BFA9XbqFXkb-ooDNS5-XnH4Rx8luLMuVmiCocDM&e=
PLEASE put [hidden email] in the To: field when you reply.


_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.