Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5

>>>>> "molofeev" == molofeev  <molofeev3@gmail.com> writes:

 >> You said a server crash occurred while you were creating indexes. Was
 >> that a hard crash (power failure, etc.) and is it possible that you had
 >> fsync disabled in postgresql.conf, or hardware or filesystems that don't
 >> respect fsync properly?
 
 molofeev> That was not hard crash, and fsync was disabled.
 
 molofeev> I was disconnected form remote terminal, which was performing
 molofeev> creating indexes from sql file.

Just being disconnected remotely (for some reason other than a server
crash) isn't enough to account for the corruption; fsync=off only results
in corrupt data if there is an actual OS-level crash or unclean shutdown.

So I wouldn't rule out the possibility of hardware or storage subsystem
problems.

-- 
Andrew (irc:RhodiumToad)