hiera-mysql occasionally doesn't close MySQL connections

[djjudas21]

I've been using hiera-mysql in production for a couple of weeks now and on the whole it's been a very good experience, thanks for sharing.

On a handful of occasions, hiera-mysql doesn't properly close MySQL database connections and keeps opening new ones, often having over 100 connections in use. Eventually the MySQL database runs out of available connections and other services that use that database server break.

I've had a look in the puppet master log and there's nothing relevant in there. Any hints on how to go about troubleshooting this?

In the meantime, I've set MySQL's wait_timeout to a lower value, so if this happens again then hopefully the idle connections will be killed by MySQL before too long.

Alternatively, do you have any plans to implement a persistent database connection for hiera-mysql? Would be nice and fast if it opens one connection when the puppetmaster starts, and then throws all queries down the same connections.

Thanks,
Jonathan