[10501] PDOException in Connection.php line 451

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3371874' for key 'PRIMARY'

  1. // 调试结束
  2. $this->debug(false);
  3. $this->numRows = $this->PDOStatement->rowCount();
  4. return $this->numRows;
  5. } catch (\PDOException $e) {
  6. if ($this->isBreak($e)) {
  7. return $this->close()->execute($sql, $bind);
  8. }
  9. throw new PDOException($e, $this->config, $this->getLastsql());
  10. } catch (\ErrorException $e) {
  11. if ($this->isBreak($e)) {
  12. return $this->close()->execute($sql, $bind);
  13. }
  14. throw $e;
  15. }
  16. }
  17. /**

Exception Datas

PDO Error Info
SQLSTATE 23000
Driver Error Code 1062
Driver Error Message Duplicate entry '3371874' for key 'PRIMARY'
Database Status
Error Code 10501
Error Message SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3371874' for key 'PRIMARY'
Error SQL INSERT INTO `ws_spiders` (`add_time` , `type` , `pageUrl` , `ip` , `vendor` , `userAgent`) VALUES (1710814997 , 'other' , 'https://www.caishui1688.com/zcgs/zhucezibenrenjiaozhichuxianzhihoushijizijinzhiyou10.html' , '3.236.18.23' , '其它蜘蛛' , 'claudebot')
Database Config
type mysql
hostname localhost
database www_caishui1688_
username www_caishui1688_
password SmMtCLDFXWmBRFZE
hostport 3306
dsn
params []
charset utf8
prefix ws_
debug 0
deploy 0
rw_separate
master_num 1
slave_no
fields_strict 1
result_type 2
resultset_type array
auto_timestamp
datetime_format Y-m-d H:i:s
sql_explain
builder
query \think\db\Query
break_reconnect false