Why am I getting the PostgreSQL error "sql_error_code = 00000 LOG: checkpoint starting" in my logs?

Issue

sql_error_code = 00000 LOG: checkpoint starting: time, and similar log lines are appearing in the logs for professional-tier Heroku Postgres databases.

[121-1]  sql_error_code = 00000 LOG:  checkpoint starting: time
[122-1]  sql_error_code = 00000 LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.000 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=31129 kB
[299-1]  sql_error_code = 00000 LOG:  checkpoint starting: force wait
...
[300-1]  sql_error_code = 00000 LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.000 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16383 kB, estimate=31129 kB

Resolution

These log lines don't indicate any errors as sql_error_code = 00000 LOG translates to "successful completion". See: Why am I getting "sql_error_code = 00000" in my PostgreSQL logs? Is this an error from my queries?.

The checkpoint logs are part of the automatic WAL (Write-Ahead Logging) archiving activity that allows us to protect your database from catastrophic failures and is used in continuous protection and other Heroku Postgres features like database forks and followers.

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
Terms of Service Privacy Cookies © 2020 Salesforce.com