Bugzilla importer hangs

[Anthony Kirby]

Running a migration from Bugzilla to JIRA for over 4 days and it remains at 0% issues migrated. It had no issues with users, version, etc. It has issues at migrating the actual bugs/issues. The query being invoked to get a list of bugs takes forever due to the sub-select of the longdesc table. Is there a suggestion in getting around this issue?

[Tiago Comasseto · Accepted solution]

Hi Anthony,

I had a similar issue some time ago, in my case the error was in the backup of the base of Bugzilla. The backup did not have the constraints in the tables.

Example:

Import works with tables like this:
CREATE TABLE `attach_data` (
`id` mediumint(9) NOT NULL default '0',
`thedata` longblob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MAX_ROWS=100000 AVG_ROW_LENGTH=1000000;

Import doesn't work with tables like this:
CREATE TABLE `attach_data` (
`id` mediumint(9) NOT NULL default '0',
`thedata` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I hope this helps.

Cheers

[Anthony Kirby]

Turned out to be some confusion on the mysql side with the indexes. I removed all of them and added them back grandually. Problem solved. However, the Bugzilla importer can't handle large amounts of data. I'm forced to do a migration of 100,000 issues in 25,000 chunks.

[petry]

Hey @Anthony Kirby, can you share with us how did you imported this in parts? :)