Why am I getting "sql_error_code = 00000" in my PostgreSQL logs? Is this an error from my queries?

Issue

Different PostgreSQL statements in my logs show sql_error_code = 00000. Is this an error or a problem with my statements?

Resolution

These log lines do not indicate any errors with your PostgreSQL queries.

PostgreSQL's log lines that include sql_error_code = 00000 mean that the specific statement that was logged was successful. This specific sql_error_code=00000 corresponds to successful_completion. The complete list of PostgreSQL error logs and their definitions is available at https://www.postgresql.org/docs/current/errcodes-appendix.html.

All messages emitted by PostgreSQL will include sql_error_code with the corresponding five-character error code, even if they refer to statements that were successful.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support