Bugzilla importer hangs

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?

1 answer

1 accepted

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

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.

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

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

80 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you