If I remove comment from BackgroundWorkerInitializeConnection
https://github.com/le0pard/pg_web/blob/master/src/pg_web.c#L179 and comment InitPostgres
https://github.com/le0pard/pg_web/blob/master/src/pg_web.c#L98, I have the same errors in log:
2013-11-24 13:35:24 UTC ERROR: stack depth limit exceeded
2013-11-24 13:35:24 UTC HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate.
2013-11-24 13:35:24 UTC CONTEXT: SQL statement "SELECT COUNT(*) FROM pg_class;"
2013-11-24 13:35:25 UTC LOG: worker process: pg_web (PID 1957) exited with exit code 1
2013-11-24 13:35:26 UTC LOG: starting background worker process "pg_web"
2013-11-24 13:35:26 UTC INFO: Start web server on port 8080
If I change InitPostgres to BackgroundWorkerInitializeConnection and leave BackgroundWorkerInitializeConnection in bgw_main, I will have this error:
2013-11-24 13:39:58 UTC ERROR: invalid processing mode in background worker
2013-11-24 13:39:58 UTC LOG: worker process: pg_web (PID 2719) exited with exit code 1
2013-11-24 13:39:59 UTC LOG: starting background worker process "pg_web"
Воскресенье, 24 ноября 2013, 14:06 +01:00 от Andres Freund <andres@anarazel.de>:
Hi,
On 2013-11-24 16:27:06 +0400, Олексій Васильєв wrote:
> This is part where I try to connect to database:
https://github.com/le0pard/pg_web/blob/master/src/pg_web.c#L92-L132 , but SPI functions give error in log (it is commented):
>
> 2013-11-24 02:57:43 UTC ERROR: stack depth limit exceeded
> 2013-11-24 02:57:43 UTC HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate.
> 2013-11-24 02:57:43 UTC CONTEXT: SQL statement "SELECT COUNT(*) FROM pg_class;"
>
> Because I doing something in wrong way. I will appreciate for any help: where I doing wrong, link to the article how to do it, just a tip, pull request - anything. Google search and PostgreSQL sources reading so far helped me to this point.
At the very least you're calling InitPostgres() instead of
BackgroundWorkerInitializeConnection() which you have commented out. And
the latter should only be called once in every worker.
Greetings,
Andres Freund