[Pkg-puppet-devel] Bug#568379: Bug#568379: Bug#568379: Acknowledgement (puppetmaster - postgresql connection goes away)

[Bastian Blank]

On Tue, Mar 02, 2010 at 01:30:30AM -0500, micah anderson wrote:
> However, I *think* Bastian is perhaps asking if there are any known
> working storedconfig setups with postgresql?

No, I try to find _any_ working setup. And what I saw in the meantime
shows that puppet is not able to scale. Most of the seen problems may be
Rails errors, but this does not change the effect.

SQLite:
Have no problem to scale with thin storedconfig enabled. But it have the
quirk that rollback can fail if more than one transaction is active. If
several puppet clients are connecting at the same time, some of the db
connections are rolled back without need and the error make the complete
request fail.

PostgreSQL:
Just looses or uses way to much connections to the database.

So two of the three obvious options fails for no particular reason.

Bastian

-- 
Spock: The odds of surviving another attack are 13562190123 to 1, Captain.