我運行一個生信軟體pasa出現主鍵重復問題，求教如何解決，不勝感激！
DBD::mysql::db do failed: Duplicate entry 'asmbl_8-f3p0' for key 'PRIMARY' at /home/softwares/PASApipeline.v2.4.1/PerlLib//DB_connect.pm line 221.
failed query: <insert into asmbl_link (asmbl_acc, cdna_acc) values (?,?)> values: asmbl_8 f3p0
Errors: Duplicate entry 'asmbl_8-f3p0' for key 'PRIMARY'
我定位到DB_connect.pm line 221的陳述句為：
sub RunMod {
211 my ($dbproc,$query, @values) = @_;
212 my ($result);
213
214 if($::DEBUG||$::DB_SEE) {print "QUERY: $query\tVALUES: @values\n";}
215 if($::DEBUG) {
216 $result = "NOT READY";
217 } else {
218 eval {
219 {
220 lock $LOCKVAR;
221 $dbproc->{dbh}->do($query, undef, @values);
222 }
223 };
224 if ($@) { #error occurred
225
226 ## check for mysql gone away:
227 if ($DBI::errstr =~ /server has gone away|Lost connection/) {
228 ## reestablish connection and try again:
229 &reconnect_to_server($dbproc);
230 return (&RunMod($dbproc, $query, @values));
uj5u.com熱心網友回復：
可以使用mysql的主鍵沖突的時候更新這種語法轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/269409.html
標籤：MySQL
上一篇：求助,為什么會報錯