{"action":"opened","issue":{"url":"https://api.github.com/repos/cjfields/redmine-test/issues/38","labels_url":"https://api.github.com/repos/cjfields/redmine-test/issues/38/labels{/name}","comments_url":"https://api.github.com/repos/cjfields/redmine-test/issues/38/comments","events_url":"https://api.github.com/repos/cjfields/redmine-test/issues/38/events","html_url":"https://github.com/cjfields/redmine-test/issues/38","id":108254961,"number":38,"title":"postgres 8.3 - load_seqdatabase.pl / swissprot","user":{"login":"cjfields","id":49265,"avatar_url":"https://avatars.githubusercontent.com/u/49265?v=3","gravatar_id":"","url":"https://api.github.com/users/cjfields","html_url":"https://github.com/cjfields","followers_url":"https://api.github.com/users/cjfields/followers","following_url":"https://api.github.com/users/cjfields/following{/other_user}","gists_url":"https://api.github.com/users/cjfields/gists{/gist_id}","starred_url":"https://api.github.com/users/cjfields/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjfields/subscriptions","organizations_url":"https://api.github.com/users/cjfields/orgs","repos_url":"https://api.github.com/users/cjfields/repos","events_url":"https://api.github.com/users/cjfields/events{/privacy}","received_events_url":"https://api.github.com/users/cjfields/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cjfields/redmine-test/labels/Priority:%20Normal","name":"Priority: Normal","color":"666600"},{"url":"https://api.github.com/repos/cjfields/redmine-test/labels/Status:%20New","name":"Status: New","color":"FF6600"},{"url":"https://api.github.com/repos/cjfields/redmine-test/labels/Tracker:%20Bug","name":"Tracker: Bug","color":"FF0000"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-25T03:25:34Z","updated_at":"2015-09-25T03:25:34Z","closed_at":null,"body":"---\n\n\nAuthor Name: **Erikjan empty** (Erikjan empty)\nOriginal Redmine Issue: 2474, https://redmine.open-bio.org/issues/2474\nOriginal Date: 2008-03-23\nOriginal Assignee: Bioperl Guts\n\n---\n\nLatest bioperl-live, bioperl-db, biosql schema.\n\nUsing:\n PostgreSQL 8.3.1\n DBD::Pg 2.3.0\n perl 5.8.8\n\nLoading uniprot\\_sprot.dat with load\\_seqdatabase.pl\n\nSome entries are rejected. The errors and warnings are:\n\n10 instances of error: value too long for type character varying(40) (all BioCyc id’s that are bit longer than 40 chars)\n if we change the varchar(40) to varchar(128) ( or something ), these entries should be alright.\n\n——————————- WARNING ——————————-\nMSG: insert in Bio::DB::BioSQL::DBLinkAdaptor (driver) failed, values were (“BioCyc”,“EcoCyc:ASP-SEMIALDEHYDE-DEHYDROGENASE-MON”,“0”,“”) FKs ()\nERROR: value too long for type character varying(40)\n—————————————————————————-\nCould not store P0A9Q9:\n——————- EXCEPTION: Bio::Root::Exception ——————-\nMSG: create: object (Bio::Annotation::DBLink) failed to insert or to be found by unique key\nSTACK: Error::throw\nSTACK: Bio::Root::Root::throw /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/Root/Root.pm:357\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:206\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:251\nSTACK: Bio::DB::Persistent::PersistentObject::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/Persistent/PersistentObject.pm:271\nSTACK: Bio::DB::BioSQL::AnnotationCollectionAdaptor::store\\_children /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/AnnotationCollectionAdaptor.pm:217\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:214\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:251\nSTACK: Bio::DB::Persistent::PersistentObject::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/Persistent/PersistentObject.pm:271\nSTACK: Bio::DB::BioSQL::SeqAdaptor::store\\_children /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/SeqAdaptor.pm:224\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:214\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:251\nSTACK: Bio::DB::Persistent::PersistentObject::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/Persistent/PersistentObject.pm:271\nSTACK: scripts/biosql/load\\_seqdatabase.pl:630\n—————————————————————————————-\n\n150 instances of error: “Could not store”. (The offending sprot id’s are enumerated below the error stack.)\n\nCould not store P0C6J8:\n——————- EXCEPTION: Bio::Root::Exception ——————-\nMSG: create: object (Bio::Species) failed to insert or to be found by unique key\nSTACK: Error::throw\nSTACK: Bio::Root::Root::throw /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/Root/Root.pm:357\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:206\nSTACK: Bio::DB::Persistent::PersistentObject::create /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/Persistent/PersistentObject.pm:244\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::create /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:169\nSTACK: Bio::DB::BioSQL::BasePersistenceAdaptor::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/BioSQL/BasePersistenceAdaptor.pm:251\nSTACK: Bio::DB::Persistent::PersistentObject::store /home/aardvark/bin/perl/lib/site\\_perl/5.8.8/Bio/DB/Persistent/PersistentObject.pm:271\nSTACK: scripts/biosql/load\\_seqdatabase.pl:630\n—————————————————————————————-\n\n(this list includes id’s with some other errors, for instance the above BioCyc errors. It’s a bit hard to separate those out)\nP0C6J8 P0C695 P0C696 P0C697 P0C698 Q9QAB9 Q67924 Q9QBF2 P0C677 Q9E6S6 Q81102 P0C6H7 Q81164 P0C6H8 Q9QMI2 P0C680 P0C6I2 P0C6I3 Q69608 P0C683\nP0C682 P0C6I8 P0C6I9 P0C6I6 O71303 Q37472 P54971 P85028 P0A9Q9 P0C691 Q91C36 O91533 Q4R1S7 Q4R1R9 Q9QAB8 Q9PX62 Q67925 Q9QBF1 P0C676 Q9E6S5\nP0C688 Q913A7 Q81165 P0C690 Q9QMI1 P0C679 Q67878 O56655 Q69602 Q80IU7 Q9QAW8 Q80IU4 Q8JMY4 Q99HS4 Q99HR5 Q69605 Q8QZQ2 Q9IBI4 P87744 Q9YPV8\nQ8JMY7 Q8JN08 Q8JMZ7 Q9J5S2 O71304 P03398 P03324 P0C6J9 Q91C37 O91532 Q4R1S8 Q4R1S0 P0C6G8 P0C6H0 P0C6H1 P0C6K6 P0C6H2 P0C6H3 Q913A8 P0C6K5\nP0C6I0 P0C6I1 Q67876 O92920 P0C6I5 P89951 Q9WJE9 Q8JMZ4 P0C6J0 P0C684 Q91C35 O91534 Q4R1S6 Q4R1R8 Q9QAB7 Q9PWW3 Q67926 Q9QBF0 Q8JXB9 Q9E6S4\nP31868 Q913A6 Q81162 Q998L9 Q9QMI0 Q998M2 Q67875 O92921 Q69603 Q80IU6 Q80IU3 Q99HS3 Q99HR4 Q69606 Q9IBI3 P87745 Q9WKC4 Q8JMY6 Q8JN07 Q8JMZ6\nQ77NU1 O71305 P21645 P01546 P09348 P0AF06 P0A749 Q000A9 P02147 P31057 P26647 Q65399 P00529 Q9I9M4 P0AGK1 P0A887 P75728 Q91C38 O91531 Q4R1S9\nQ4R1S1 P0C685 Q9PXA2 Q67923 Q9PX75 P0C678 Q9E6S8 P0C686 Q913A9 Q81163 P0C687 Q9QMI3 P0C681 Q67877 O93195 Q69604 Q80IU8 Q9QAX0 Q80IU5 Q8JMY3\nQ99HR6 Q69607 Q9IBI5 P87743 Q9YJT2 Q8JMY5 Q8JN06 Q8JMZ5 Q9J5S3 O71302\n\nThen there around 1000 WARNINGs about taxonomy (I think), of the form:\n——————————- WARNING ——————————-\nMSG: The supplied lineage does not start near ‘Epstein-Barr virus’ (I was supplied ‘Human herpesvirus 4 | Lymphocryptovirus | Gammaherpesvirinae | Herpesviridae’)\n—————————————————————————-\nI will attach a file with the output of\n grep “^MSG:” ~/load\\_seqdatabase.pl.swissprot.output.txt | sort | uniq -c\n(Unfortunately the sprot id is not mentioned)\n\nsee also:\n\nhttp://article.gmane.org/gmane.comp.lang.perl.bio.general/16844\n\nhttp://bugzilla.open-bio.org/show\\_bug.cgi?id=2389\n\n\n\n\n"}}