Message-ID: <53A1DFAC.7050903@felipegasper.com>
Date: Wed, 18 Jun 2014 13:51:24 -0500
From: Felipe Gasper <felipe@felipegasper.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: pgsql-bugs@postgresql.org
Subject: Re: =?UTF-8?B?4oCcc2VydmVyIGNsb3NlZCB0aGUgY29ubmVjdGlvbiB1?=
 =?UTF-8?B?bmV4cGVjdGVkbHnigJ0=?=
References: <53A1DAB5.8080106@felipegasper.com> <53A1DE2D.7000203@vmware.com>
In-Reply-To: <53A1DE2D.7000203@vmware.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

On 6/18/14 1:45 PM, Heikki Linnakangas wrote:
> On 06/18/2014 09:30 PM, Felipe Gasper wrote:
>> The query:
>>
>> SELECT schemaname, tablename
>>             FROM pg_tables
>>             WHERE tableowner IN (E'njvue5kiy1c') OR schemaname='public';
>>
>> --------
>> The error:
>>
>> DBD::Pg::db selectall_arrayref failed: server closed the connection
>> unexpectedly
>>     This probably means the server terminated abnormally
>>     before or while processing the request.
>>
>> --------
>>
>> It happens every time. The “njvue5kiy1c” is a random generated name.
>
> Is there any more information in the server log?
>

setting log_min_messages to DEBUG5 shows this as the last query and after:

==============
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: LOG:  00000: 
statement: GRANT ALL PRIVILEGES on DATABASE "sameownerdb" TO "sameownerdb";
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: LOCATION: 
exec_simple_query, postgres.c:842
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: DEBUG:  00000: 
ProcessUtility
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: LOCATION: 
PortalRunUtility, pquery.c:1163
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: DEBUG:  00000: 
CommitTransactionCommand
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: LOCATION: 
finish_xact_command, postgres.c:2369
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: DEBUG:  00000: 
CommitTransaction
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: LOCATION: 
ShowTransactionState, xact.c:4116
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: DEBUG:  00000: name: 
unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 
694/1/1, nestlvl: 1, children:
“postgres” in “postgres” @ 2014-06-18 13:47:15 CDT: LOCATION: 
ShowTransactionStateRec, xact.c:4154
==============

(Curiously, setting any DEBUG* log_min_messages value also makes the log 
messages spit to STDERR as well as my log file.)

-F


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs