This plugin is installed.

I performed everything up to and including step 9 of https://github.com/mantisbt-plugins/source-integration for the 'slicer.org' repo. In other words, I haven't setup cron to fetch new changesets.

What repos do you want to integrate with Mantis?

The fetch process took forever, and eventually I had to kill it.

Then any refreshes of the repo data resulted in a SQL error (even for the already fetched small slicer.org repo):
APPLICATION ERROR 0000401 Database query failed. Error received from database was 0001064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY timestamp ASC LIMIT 1' at line 2 for the query: SELECT parent FROM mantis_plugin_Source_changeset_table WHERE repo_id=? AND branch=?ORDER BY timestamp ASC. Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

So, I checked the database; found a bug in the SQL; submitted a patch upstream.

I re-fetched the slicer repo, but it's still churning away over 8 hours later. It's NOT consuming all server resources, so it's safe to allow it to run. But I need to keep that browser window open and oddly enough the application blocks (queues) requests from the same client. So I'm typing this on a separate machine at the same IP.

As of now, the tool has collected 533 changesets for the Slicer repo, and continues to retrieve the data from GitHub

Repository Type Changesets Files Issues
Slicer GitHub 533 1081 0

See https://issues.slicer.org/plugin.php?page=Source/index for current stats (Administrator Only)

Since I don't know yet what will be the added value yet, if you think this will increase the size of our backup and is causing more trouble ... may be we can abandon.

It's not consuming a lot of disk. The mantis database is only 22M (/var/lib/mysql/mantis), and the Mantis installation "uploads" is 663M. It also doesn't appear to be impacting services for other users/sites. It's just that the retrieval operation is extremely slow. I actually wish it were multi-threaded.

I'm letting it run in the background.... it's up to 683 changesets indexed now.

Hi Greg,

Consider that:

(1) there are more 20k changeset to process

(2) the plugin is incorrectly adds notes to issue. For example, see https://issues.slicer.org/view.php?id=2839#c14668 where it correctly find the commit 20ce292 but associated the wrong branch Slicer: 2145-support-for-installing-extension-from-file

I suggest we abort the import.

This branch lives on my fork but I don't understand why the plugin is referencing it .... https://github.com/jcfr/Slicer/tree/2145-support-for-installing-extension-from-file

It should only process the master branch.

I think I understand, the repository configured is associated with my username. It should instead have the username "Slicer"

Screenshot from 2017-06-07 23-48-06.png (27,229 bytes)

Hi Jc, Agreed. I aborted it at 10:30 pm. I believe you can map branches, but there isn't any documentation and it's buggy.

My mistake on the username... I thought that had to do with repo owner, but that doesn't make sense.

Will need to figure out how to clean up. In other words, does deleting a repo remove the inserted notes? And why does only one repo offer a 'delete' button?

@grundlett After updating the repository info (username: Slicer, branch: master), I clicked on "Import everything. That should be better now.