[#QB-3132] DB Backups seems to open more DB connections than it should

QuickBuild

DB Backups seems to open more DB connections than it should

Created: 19/Feb/18 09:58 AM Updated: 19/Jan/19 01:19 PM

Component/s:

None

Affects Version/s:

7.0.31

Fix Version/s:

None

Original Estimate:	Unknown	Remaining Estimate:	Unknown	Time Spent:	Unknown
File Attachments:	1. connections.txt (156 kb)

Description

« Hide

We're running QB 7.0.31 with PostgreSQL database. The login role had a limit of 50 connections. The QB db pool has a max size of 50.

We've seen a lot of log lines on DB side like:

quickbuild@quickbuild FATAL: too many connections for role "quickbuild"

because of this also builds failed. I increased the login role limit to 70 and it still fails. And always at around the same time: When the QB backup is running.

Now I'm wondering if QB tries to open more than the configured connections to the database during the backup process?

All

Comments

Work Log

Change History

Sort Order:

No work has yet been logged on this issue.