RegisterBackgroundWorker does not actually start a bg worker process in 9.4.4

From: John Lumby <johnlumby(at)hotmail(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: RegisterBackgroundWorker does not actually start a bg worker process in 9.4.4
Date: 2015-06-15 18:58:51
Message-ID: COL131-W797566963E38D7BFE52BFFA3B80@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I am new to bg_workers so this may be my user error,
but when I build and run the  contrib/worker_spi
extension,    I find that :

  .   starting postgres with the extension named in shared_preload_libraries :
      its _PG_init is invoked as expected but no process is started -
      it is as though RegisterBackgroundWorker did nothing

  .  creating the extension and then
psql ...  "select worker_spi_launch(2);" :
    I see
 28409 28288 ?        463508       00:05 00:00:00  0.0 postgres: bgworker: worker 2   
as expected.

Is there maybe some bug in postmaster's processing of
    workers marked as start_at = BgWorkerStart_RecoveryFinished
in 9.4.4?

Cheers,   John

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-06-15 19:19:34 Re: localtime ?
Previous Message Yaroslav 2015-06-15 18:55:58 Re: Row count estimation bug in BETWEEN?

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-06-15 19:12:24 Re: Function to get size of notification queue?
Previous Message Amit Kapila 2015-06-15 18:52:54 Re: Re: [COMMITTERS] pgsql: Map basebackup tablespaces using a tablespace_map file