From: Eric Wong Date: Fri, 23 Jun 2017 01:19:46 +0000 (+0000) Subject: msgmap: ignore duplicates instead of dying X-Git-Tag: v1.0.0~48 X-Git-Url: http://www.git.stargrave.org/?p=public-inbox.git;a=commitdiff_plain;h=9be89cc9f142e237387aa466f5c3d9fb75b3dd9e msgmap: ignore duplicates instead of dying This prevents public-inbox-watch from dying when reloading (and thus rescanning) already-imported directories. --- diff --git a/lib/PublicInbox/Msgmap.pm b/lib/PublicInbox/Msgmap.pm index a49b61e8..7e0f34a4 100644 --- a/lib/PublicInbox/Msgmap.pm +++ b/lib/PublicInbox/Msgmap.pm @@ -179,7 +179,7 @@ sub id_batch { sub mid_set { my ($self, $num, $mid) = @_; my $sth = $self->{mid_set} ||= do { - my $sql = 'INSERT INTO msgmap (num, mid) VALUES (?,?)'; + my $sql = 'INSERT OR IGNORE INTO msgmap (num, mid) VALUES (?,?)'; $self->{dbh}->prepare($sql); }; $sth->execute($num, $mid);