[openstack-dev] How to get openstack bugs data for research?

Jesus M. Gonzalez-Barahona jgb at bitergia.com
Wed Dec 3 23:42:09 UTC 2014

You can download a database dump with (hopefully) information for all
Launchpad tickets corresponding to OpenStack, already organized and
ready to be queried:


(linked from
http://activity.openstack.org/dash/browser/data_sources.html )

It is a 7z-zipped file with includes a MySQL dump of the actual
database, produced by Bicho (one of the tools in MetricsGrimoire). It is
updated daily.

You can just feed it to MySQL, and start to do your queries. There is
some information about Bicho and the database schema used at



Please, let me know if you need further info.



On Wed, 2014-12-03 at 20:20 +0800, zfx0906 at gmail.com wrote:
> Hi, all
> I am a graduate student in Peking University, our lab do some research
> on open source projects. 
> This is our introduction: https://passion-lab.org/
> Now we need openstack issues data for research, I found the issues
> list: https://bugs.launchpad.net/openstack/
> I want to download the openstack issues data, Could anyone tell me how
> to download the data? Or is there some link or API for download the
> data?
> And I found 9464  bugs in https://bugs.launchpad.net/openstack/ ,is
> this all? why so few?
> Many thanks!
> Beat regards,
> Feixue, Zhang
> ______________________________________________________________________
> zfx0906 at gmail.com
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Bitergia: http://bitergia.com
/me at Twitter: https://twitter.com/jgbarah

More information about the OpenStack-dev mailing list