Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Title: BuildMaster 26.0.2 (PostgreSQL): Scripts list page leaks a DB connection per visit; Native API calls fail with missing __BuildMaster_GetStoredProcInfo
-
Hi,
We're running BuildMaster 2026.2 (26.0.2, Build 2) on Windows Server 2025 with the embedded PostgreSQL database (fresh 2026 install, Free license). We've found two issues.
- Connection leak on the Scripts list page (it caused failed deployments)
Steps to reproduce:
Open Administration > Scripts (/scripts/all), or an application's Scripts page (/applications/<app>/scripts/all).
Run select pid, state, query from pg_stat_activity where state = 'idle in transaction';
Each visit leaves one connection "idle in transaction" whose last query is SELECT * FROM "Rafts_GetRaftItems"($1,$2,$3,$4), and it is never released. Npgsql's pool counters (dotnet-counters, db.client.connection.count, state=used) go up by one per visit and never come back down. Our measurements, one action at a time:Opening the Scripts list: +1 every time.
Opening a single script, version history, pipelines, deploys, executions, health and the REST APIs: +0.
No error is written to the error log.
None of these released the connections: killing the sessions with pg_terminate_backend (the pool's "used" count stayed the same), a forced GC, logging off, or running the Raft Analyzer. A heap snapshot shows one live Npgsql.NpgsqlTransaction per leaked connection, with no TransactionScope involved. Only restarting the service frees them.Impact: after about 6 days the pool was full and deployments failed with:
Npgsql.NpgsqlException: The connection pool has been exhausted, either raise 'Max Pool Size' (currently 100) or 'Timeout' (currently 15 seconds)
At the same time, web requests failed with UserNotFoundException in BuildMasterHttpModule.AuthorizeRequestAsync.Our workaround for now: we avoid the Scripts list, set Maximum Pool Size=90, and run a scheduled task that restarts the service through Prepare for Shutdown before the pool fills up.
- Native API doesn't work on PostgreSQL
Every /api/json/* call (for example Applications_GetApplications, Credentials_GetCredentials) returns HTTP 500:
42883: function __BuildMaster_GetStoredProcInfo() does not exist
None of the SQL scripts that ship with 26.0.2 define this function for PostgreSQL. The same calls work on a 26.0.1 instance that runs on SQL Server.Questions:
Are fixes for these planned, and roughly when?
In the meantime, is exporting from PostgreSQL and importing into SQL Server (same version) a supported way to get the Native API working?
Thanks!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login