attempting to retrieve column names from information schema fails. - Mailing list pgsql-general

From Day, David
Subject attempting to retrieve column names from information schema fails.
Date
Msg-id 182854d4bc7e4438a3ade4cecaae3694@exch-02.redcom.com
Whole thread Raw
Responses Re: attempting to retrieve column names from information schema fails.
List pgsql-general
Hi,


I'm looking on some insights on the following problem on retrieving table column names from the information schema (
postgres9.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"
relatedtable 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
thetotal system. 
The client side was started, running and has coredumped.  The client side has a pool of  connections (10) that as a
matterof routine  
Drop and re-establish a  connection on a round robin basis. One of the threads may have been running the above command
atthe time 
the client coredumps in an unrelated matter.  It is on the subsequent restart of the client that this command starts to
failand 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









pgsql-general by date:

Previous
From: sql2pg
Date:
Subject: WAL reducing size
Next
From: Nicola Contu
Date:
Subject: Re: Centos 6.9 and centos 7