[Bioperl-l] load_seqdatabase error with a specific locus from genbank

Johann PELLET johann.pellet at inserm.fr
Wed Apr 1 10:14:25 UTC 2009


Hi all,

With the latest version of BioPerl and BioSQL, I have tried to insert  
entry from a GenBank file, which I have downloaded from the NCBI  
website (648 937 records)

After successfully loading ncbi_taxonomy i am getting following error  
message while loading sequences into database.

perl load_seqdatabase.pl gb_03-2009 -format genbank -driver Pg -dbname  
biosql


--------------------- WARNING ---------------------
MSG: The supplied lineage does not start near 'Human papillomavirus  
type 2c' (I was supplied 'Human papillomavirus - 2 |  
Alphapapillomavirus | Pa
pillomaviridae')

the script is not stopped until this entry: S67864

--------------------- WARNING ---------------------
MSG: insert in Bio::DB::BioSQL::LocationAdaptor (driver) failed,  
values were ("1","19)","1","3") FKs (41914,<NULL>)
ERROR:  invalid input syntax for integer: "19)"

---------------------------------------------------
Could not store S67864:
------------- EXCEPTION: Bio::Root::Exception -------------
MSG: error while executing statement in  
Bio::DB::BioSQL::LocationAdaptor::find_by_unique_key: ERROR:  current  
transaction is aborted, commands ig
nored until end of transaction block

STACK: Error::throw
STACK: Bio::Root::Root::throw /Library/Perl/5.8.8/Bio/Root/Root.pm:357
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::_find_by_unique_key / 
Library/Perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:970
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::find_by_unique_key / 
Library/Perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:873
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /Library/Perl/ 
5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:216
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /Library/Perl/ 
5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:264
STACK: Bio::DB::Persistent::PersistentObject::store /Library/Perl/ 
5.8.8/Bio/DB/Persistent/PersistentObject.pm:284
STACK: Bio::DB::BioSQL::SeqFeatureAdaptor::store_children /Library/ 
Perl/5.8.8/Bio/DB/BioSQL/SeqFeatureAdaptor.pm:291
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /Library/Perl/ 
5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:227
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /Library/Perl/ 
5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:264
STACK: Bio::DB::Persistent::PersistentObject::store /Library/Perl/ 
5.8.8/Bio/DB/Persistent/PersistentObject.pm:284
STACK: Bio::DB::BioSQL::SeqAdaptor::store_children /Library/Perl/5.8.8/ 
Bio/DB/BioSQL/SeqAdaptor.pm:257
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /Library/Perl/ 
5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:227
STACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /Library/Perl/ 
5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:264
STACK: Bio::DB::Persistent::PersistentObject::store /Library/Perl/ 
5.8.8/Bio/DB/Persistent/PersistentObject.pm:284
STACK: load_seqdatabase.pl:630
-----------------------------------------------------------

  at load_seqdatabase.pl line 643

Any Idea?

Thanks in advance

Johann




More information about the Bioperl-l mailing list