[Gmod-help] using gmod_bulk_load_gff3.pl in a multiuser environment

[Ghiban, Cornel]

Hi all,

I'm building a web application that uses this script to load various analyses results into 
a chado database. We often notice the loading fails and it wasn't difficult to see why. Since gmod_bulk_load_gff3.pl takes a few good seconds to execute, a second or third instance of this script will fail to work properly, if the first run is still running.

This is because of the temporary tables. 

The first script will create a series of temporary tables, meanwhile a 2nd script tries to do the same, but it fails - it may still continue to run, I'm not sure, but then the 1st script finishes (drops the temporary tables) and the 2nd script can't do it's job.

Maybe the temporary objects' name should contain a random string (unique per run), that would prevent name clashes. Could this be easily done? Or is there another solution?

Also in the web environment, Bio::GMOD::DB::Adapter->file_handles fails to create the temp files, unless I change the TEMPLATE to "/tmp/chado-$key-XXXX".

Thanks,
Cornel