Unusual Postgres 9.4 error message

From: "Keefer, Brad (ITS)" <Brad(dot)Keefer(at)its(dot)ny(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Unusual Postgres 9.4 error message
Date: 2017-06-12 19:20:04
Message-ID: BY2PR09MB1079D407F05CE402603A18F2DCCD0@BY2PR09MB1079.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

So, I was looking in the Postgres log file for today on our DB server, and it's nothing but lines like these:

< 2017-06-12 18:37:59.249 UTC >STATEMENT: SELECT "main_instance"."id", "main_instance"."uuid", "main_instance"."hostname", "main_instance"."created", "main_instance"."modified", "main_instance"."version", "main_instance"."capacity" FROM "main_instance" LIMIT 1 FOR UPDATE NOWAIT
< 2017-06-12 18:38:05.289 UTC >ERROR: could not obtain lock on row in relation "main_instance"
< 2017-06-12 18:38:05.289 UTC >STATEMENT: SELECT "main_instance"."id", "main_instance"."uuid", "main_instance"."hostname", "main_instance"."created", "main_instance"."modified", "main_instance"."version", "main_instance"."capacity" FROM "main_instance" LIMIT 1 FOR UPDATE NOWAIT
< 2017-06-12 18:38:12.496 UTC >ERROR: could not obtain lock on row in relation "main_instance"
< 2017-06-12 18:38:12.496 UTC >STATEMENT: SELECT "main_instance"."id", "main_instance"."uuid", "main_instance"."hostname", "main_instance"."created", "main_instance"."modified", "main_instance"."version", "main_instance"."capacity" FROM "main_instance" LIMIT 1 FOR UPDATE NOWAIT
< 2017-06-12 18:38:59.267 UTC >ERROR: could not obtain lock on row in relation "main_instance"
< 2017-06-12 18:38:59.267 UTC >STATEMENT: SELECT "main_instance"."id", "main_instance"."uuid", "main_instance"."hostname", "main_instance"."created", "main_instance"."modified", "main_instance"."version", "main_instance"."capacity" FROM "main_instance" LIMIT 1 FOR UPDATE NOWAIT

Our setup is a little different, as we are running the 2ndQuadrant BDR-enabled Postgres 9.4 package on the server:

[14:39:01 root(at)dch282ml5pgsql> yum list installed |grep postgres
Repository epel is listed more than once in the configuration
Repository epel-source is listed more than once in the configuration
Repository jlaska-rabbitmq is listed more than once in the configuration
Repository pgdg94 is listed more than once in the configuration
Repository pgdg94 is listed more than once in the configuration
Repository pgdg94-source is listed more than once in the configuration
postgresql-bdr94-2ndquadrant-redhat.noarch

and the OS is RHEL 7.3.

As far as I can tell, the DB is up, accepting connections, and basically working the way it should. So those error messages are confusing me. Are they something that can be ignored? If so, is it possible to turn them off?

Just trying to figure out what is trying to access the database that could be generating statements like that.

Any information you could provide would be greatly appreciated.

Thanks.

Brad Keefer
Red Hat Consultant - RHCSA

Office of Information Technology Services
Tax & Finance Building 8, Floor 7, Harriman Campus
C: 919-210-7045 | brad(dot)keefer(at)its(dot)ny(dot)gov<mailto:brad(dot)keefer(at)its(dot)ny(dot)gov>
www.its.ny.gov

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2017-06-12 19:36:36 Re: Unusual Postgres 9.4 error message
Previous Message x_hsky 2017-06-12 06:44:17 Re: PG-10.0 Distributed Cluster