hi Dave,<br> I met the same error as the last time .It said <br>"DBD::Pg::db commit failed: ERROR: insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"<br>DETAIL: Key (srcfeature_id)=(517344) is not present in table "feature". at /usr/local/share/perl/5.10.1/Bio/GMOD/DB/Adapter.pm line 2651, <$fh> line 4878.<br>commit failed: ERROR: insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"<br>DETAIL: Key (srcfeature_id)=(517344) is not present in table "feature". at /usr/local/share/perl/5.10.1/Bio/GMOD/DB/Adapter.pm line 2651, <$fh> line 4878.<br>"<br><br>I used the --save option and got the tmp files .But when I run the query :<br> select * from feature where feature_id = 517344 .It is empty. So why didn't loader loaded feature into my database?<br>Is my gff file problem?<br><br> Thank you very much!!!<br><br>Wangjun<br><div></div><br>在2010-04-22 02:31:44，"Dave Clements, GMOD Help Desk" <help@gmod.org> 写道：<br> <blockquote id="isReplyContent" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Hi Wangjun,<div><br></div><div>I'm CC'ing the Schema/Chado list, which is probably a better place to discuss this question.</div><div><br></div><div>I talked to Scott Cain about this: Make sure that BioPerl and schema are up to date, and if that doesn't fix it, run the loader with the --save option so the tmp files get saved. Then you can find the line in the featureloc file that is offending. If that approach doesn't result in solving the problem, then we might need to see the GFF that is causing the problem.</div>
<div><br></div><div>Thanks</div><div><br></div><div>Dave C</div><div><br></div><div><div class="gmail_quote">2010/4/15 wangjun19820303 <span dir="ltr"><<a href="mailto:wangjun19820303@163.com">wangjun19820303@163.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi all,<br> When I was importing blast result gff3 file into chado database using <a href="http://gmod_bulk_load_gff3.pl" target="_blank">gmod_bulk_load_gff3.pl</a>, I got the errors like this:<br>
DBD::Pg::db commit failed: ERROR: insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"<br>DETAIL: Key (srcfeature_id)=(177) is not present in table "feature". at /usr/local/share/perl/5.10.1/Bio/GMOD/DB/Adapter.pm line 2651, <$fh> line 4190.<br>
commit failed: ERROR: insert or update on table "featureloc" violates foreign key constraint "featureloc_srcfeature_id_fkey"<br>DETAIL: Key (srcfeature_id)=(177) is not present in table "feature". at /usr/local/share/perl/5.10.1/Bio/GMOD/DB/Adapter.pm line 2651, <$fh> line 4190.<br>
I don't know why and how to handle. Could you help me?<br>I am looking forward to your reply.<br><br>Wangjun<br><br><br><br><span title="neteasefooter"></span><br>------------------------------------------------------------------------------<br>
Download Intel&#174; Parallel Studio Eval<br>
Try the new software tools for yourself. Speed compiling, find bugs<br>
proactively, and fine-tune applications for parallel performance.<br>
See why Intel Parallel Studio got high marks during beta.<br>
<a href="http://p.sf.net/sfu/intel-sw-dev" target="_blank">http://p.sf.net/sfu/intel-sw-dev</a><br>_______________________________________________<br>
Gmod-devel mailing list<br>
<a href="mailto:Gmod-devel@lists.sourceforge.net">Gmod-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/gmod-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/gmod-devel</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>===> PLEASE KEEP RESPONSES ON THE LIST <===<br><a href="http://gmod.org/wiki/GMOD_Logo_Program">http://gmod.org/wiki/GMOD_Logo_Program</a><br><a href="http://gmod.org/wiki/GMOD_News">http://gmod.org/wiki/GMOD_News</a><br>
Was this helpful? <a href="http://gmod.org/wiki/Help_Desk_Feedback">http://gmod.org/wiki/Help_Desk_Feedback</a><br><br>
</div>
</blockquote><br><br><span title="neteasefooter"/><hr/>
<a href="http://ym.163.com/?from=od2" target="_blank">网易免费域名邮箱正式上线</a>
</span>