firebird: backport upstream patch to avoid life cycle issues

with temp files...

Change-Id: I3c76baa38c6854600fbfd1dd48c554ff8716969e
Revert "firebird: enable-debug cause trouble due to a lifecycle management issue"

This reverts commit 814818c3451fa32900c011278e2e5b62e3518eb0.
Upstream patched the underlying cause