On Wed, 2025-02-19 at 06:54 -0700, David G. Johnston wrote: > > We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we are noticing these messages excessively: > > > > db=postgres,user=postgres ERROR: canceling statement due to user request > > > > Does Export cancel the SQLs? If not, why are we noticing these messages excessively during the export operation? The load on the instance is minimal > > It says “user request”. I’d advise figuring out what was cancelled and what “user” did so. > Probably DDL commands failing to get exclusive locks.
No, that message is from a cancel request, like when you interrupt your currently running query with Ctrl+C in "psql" or invoke pg_cancel_backend(). PostgreSQL doesn't do that by itself.
The Linux oom killer? I don't remember the exact error message that PG gives to the user, but ISTR that it's "user request”. Had to search through /var/log/messages to see that oomkiller was the culprit.
