From 9be89cc9f142e237387aa466f5c3d9fb75b3dd9e Mon Sep 17 00:00:00 2001 From: Eric Wong Date: Fri, 23 Jun 2017 01:19:46 +0000 Subject: [PATCH] msgmap: ignore duplicates instead of dying This prevents public-inbox-watch from dying when reloading (and thus rescanning) already-imported directories. --- lib/PublicInbox/Msgmap.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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); -- 2.44.0