On Fri, Oct 6, 2017 at 8:19 AM, tushar <tushar.ah...@enterprisedb.com> wrote: > I got some few queries after running sqlsmith against PG HEAD , where i am > getting LOG message like - "parallel worker (PID) exited with exit code 1" > > set force_parallel_mode =1; > select > pg_catalog.pg_wal_replay_pause() as c0, > ref_0.ev_type as c1 > from > pg_catalog.pg_rewrite as ref_0 > where ref_0.ev_enabled > ref_0.ev_type > limit 53; > > 2017-10-06 13:15:34.785 BST [5680] LOG: background worker "parallel worker" > (PID 5964) exited with exit code 1 > ERROR: recovery is not in progress > HINT: Recovery control functions can only be executed during recovery. > CONTEXT: parallel worker
You seem to be assuming this is wrong, but I don't see what the problem is. There's nothing unsafe about an error happening side of a worker, and you got an error because this function isn't safe to execute during normal running. I would say this is a case of everything working as intended. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers