Reads should occur with Repeatable Read Isolation Level

Question

Reads should occur with Repeatable Read Isolation Level

TimSC opened this issue 6 years ago · 2 comments

This prevents inconsistent reads and dumps? https://www.postgresql.org/docs/10/transaction-iso.html

Answer 1 · 2019-03-18T16:35:17.000Z

This seems to be related to the dreaded dump duplicate problem

ALTER TABLE "planet2_static_livenodes" ADD PRIMARY KEY (id);
ERROR:  could not create unique index "planet2_static_livenodes_pkey"
DETAIL:  Key (id)=(25982976) is duplicated.

Looks like we were getting "phantom reads"

Answer 2 · 2019-05-12T20:22:14.000Z

Dump fosm-planet_20190501174901.o5m.gz worked without any duplicates :)