Re: [HACKERS] parallel worker (PID ) exited with exit code 1

On Fri, Oct 6, 2017 at 8:19 AM, tushar <tushar.ahuja@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