attempting to retrieve column names from information schema fails.

From: "Day, David" <dday(at)redcom(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: attempting to retrieve column names from information schema fails.
Date: 2017-12-04 15:53:09
Message-ID: 182854d4bc7e4438a3ade4cecaae3694@exch-02.redcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I'm looking on some insights on the following problem on retrieving table column names from the information schema ( postgres 9.6.6 FreeBSD 11.1 )

When my client starts up up. Each thread ( 10 ) run this command.

select column_name from information_schema.columns where table_name = 'pep_port_log';

I have encountered two instances of testing Where the server does not respond to that command.
Otherwise I can interact with the database. I end up restoring the database to recover.

At the point of failure, Using pgamdinIII , I find the information schema is visible. In general any catalog "column" related table fails to respond with data.
( I end up cancelling the query, as it just appears to hang. Normal response would be a second or two )
The tables that it should be representing i.e. pep_port_log is present and viewable in it's schema.
A sample of other non-column related objects return data in the information schema.

Shutting down the database/postgres and restarting does not clear the issue.
I do not recall seeing any locks that would help explain the issue.

Nothing yet has caught my eye in the postgres log related to this circumstance.

I'll add that this all works 99.99% of the time. I have only experienced this twice, while exploring load testing of the total system.
The client side was started, running and has coredumped. The client side has a pool of connections (10) that as a matter of routine
Drop and re-establish a connection on a round robin basis. One of the threads may have been running the above command at the time
the client coredumps in an unrelated matter. It is on the subsequent restart of the client that this command starts to fail and the client fails to
reach a runnable condition as it blocks on this query.
I have no clue the point at which the information_schema. column relations got out of wack.

Any suggestions as to how these column related relations might become corrupted or
Debug/inspection measure that I should attempt on the next rare occurrence?

Best Regards

Dave Day

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nicola Contu 2017-12-04 15:57:40 Re: Centos 6.9 and centos 7
Previous Message sql2pg 2017-12-04 15:50:50 WAL reducing size