Environment
ZENworks 20.3 or higherExternal PostgreSQL
Situation
ZENworks Primary configured with external PostgreSQL database on SUSE servers can randomly abort transactions and terminates connections for backend queries due to parallel worker process can't initialize or resources unavailable.
This can impact ZENworks functionalities that are database intensive or any maintenance tasks.
Few examples of errors or exceptions can be seen in the ZENworks logs (loader-messages.log) or PostgreSQL logs(postmaster.log)
postgresql.log:
LOG: could not fork worker process: Resource temporarily unavailable LOG: could not fork new process for connection: Resource temporarily unavailable ERROR: parallel worker failed to initialize ERROR: current transaction is aborted, commands ignored until end of transaction block
loader-messages.log:
org.postgresql.util.PSQLException: ERROR: parallel worker failed to initialize org.postgresql.util.PSQLException: ERROR: lost connection to parallel worker
Find resolution on support portal
Support
Documentation
Learning Services
Partner Programs
