Hi, On 2018-07-23 15:23:04 -0500, Dimitri Maziuk wrote: > I'm playing with logical replication in postgres-10 and I got it to hang > on startup with > > > 2018-07-23 13:15:06.577 CDT [18624] FATAL: the database system is starting up > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(1): 0 before_shmem_exit callbacks to make > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(1): 0 on_shmem_exit callbacks to make > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: proc_exit(1): 1 callbacks to make > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: exit(1) > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make > > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: proc_exit(-1): 0 callbacks to make > ... forever ... What precedes that "loop"? Could you describe what exactly you did into that situation? > After poking around: > > # find /var/lib/pgsql/10/data/pg_logical/snapshots -printf . | wc -c > 12727975 Ugh, something absolutely clearly isn't right here. > It looks like ZFS simply can't handle this many files: `ls` etc. hang > forever. ls probably works in general, it's just the sorting that makes it hang. Should work with -f or such. Greetings, Andres Freund
