Thursday, 30 August 2018

Log Stacktrace of Python in PostgreSQL trigger

I try to find a not reproducible bug which happens from time to time on our production server.

Some value in the DB gets changed in a way which I don't want it to.

I could write a PostgreSQL trigger which fires if this bug happens.

Raising a Exception in the PostgreSQL trigger would be a solution. I would see the Python traceback which executes the unwanted SQL statement.

But in this case I don't want to stop the processing of the request.

Is there a way to log the Python/Django traceback from within a PostgreSQL trigger?

I know that this is not trival since the DB code runs under a different linux process with a different user id.

I am using Python, Django, PostgreSQL, Linux.

I guess this is not easy since the DB trigger runs in a different context than the python interpreter.

Please ask if you need further information.



from Log Stacktrace of Python in PostgreSQL trigger

No comments:

Post a Comment