tuplesort: unexpected end of data - Mailing list pgsql-hackers

From NunoACHenriques
Subject tuplesort: unexpected end of data
Date
Msg-id Pine.LNX.4.44.0206021647330.20299-100000@students.fct.unl.pt
Whole thread Raw
Responses Re: tuplesort: unexpected end of data
List pgsql-hackers
Hi all!
First of all, thanks for your fine job and the answers to a problem
(which I thought it was a PG bug) I posted some days ago. I've solved it!
Now I've got another strange issue to post...
Briefing: the program runs daily and this (please see below) error
does not always happen, actually this was the first time this week.
I hope you can help me?... If I'm doing something wrong, please let
me know...
Thanks in advance! :-)


[JDBC driver error report]
org.sourceforge.jxutil.sql.I18nSQLException: sqlError[tuplesort: unexpected end of data]at
org.sourceforge.jxdbcon.postgresql.PGExceptions.sqlError(UnknownSource)at
org.sourceforge.jxdbcon.postgresql.PGErrors.throwError(UnknownSource)at
org.sourceforge.jxdbcon.postgresql.PGResult.checkException(UnknownSource)at
org.sourceforge.jxdbcon.postgresql.PGExecResult.checkException(UnknownSource)at
org.sourceforge.jxdbcon.postgresql.PGConnection.executeSQL(UnknownSource)at
org.sourceforge.jxdbcon.postgresql.PGStatement.execute(UnknownSource)at
org.sourceforge.jxdbcon.AbstractStatement.executeQuery(UnknownSource)
 
(...)

[PostgreSQL log excerpt]
(...)
(comment: the query in question)
Jun  2 05:35:48 srv31 postgres[2986]: [57277] DEBUG:  query: SELECT  fill_warehouse()
Jun  2 05:35:48 srv31 postgres[2986]: [57278-1] DEBUG:  query: insert into warehouse (uri, expression, n, relevance,
spid_measure,size, title, sample) select d.uri,
 
Jun  2 05:35:48 srv31 postgres[2986]: [57278-2]  dn.expression, n.n, dn.relevance, d.spid_measure, d.size, d.title,
dn.samplefrom document as d inner join (document_n_gram as
 
Jun  2 05:35:48 srv31 postgres[2986]: [57278-3]  dn inner join n_gram as n on (dn.expression = n.expression)) on (d.uri
=dn.uri) order by dn.expression asc, n.n asc
 
Jun  2 06:37:08 srv31 postgres[11485]: [3317] DEBUG:  recycled transaction log file 00000018000000DA
Jun  2 06:37:08 srv31 postgres[11485]: [3318] DEBUG:  recycled transaction log file 00000018000000DB
(commment: this is a local monitor server)
Jun  2 06:39:39 srv31 postgres[11488]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 06:44:38 srv31 postgres[11498]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 06:49:39 srv31 postgres[11505]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 06:54:39 srv31 postgres[11515]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 06:59:38 srv31 postgres[11522]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 07:04:39 srv31 postgres[11541]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 07:09:39 srv31 postgres[11548]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 07:14:38 srv31 postgres[11558]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 07:19:38 srv31 postgres[11565]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 07:24:39 srv31 postgres[11575]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
(comment: the error)
Jun  2 06:29:37 srv31 postgres[2986]: [57279] ERROR:  tuplesort: unexpected end of data
Jun  2 06:29:37 srv31 postgres[2986]: [57280] NOTICE:  Error occurred while executing PL/pgSQL function fill_warehouse
Jun  2 06:29:37 srv31 postgres[2986]: [57281] NOTICE:  line 2 at SQL statement
Jun  2 07:29:39 srv31 postgres[11582]: [3317] FATAL 1:  No pg_hba.conf entry for host 193.136.120.30, user root,
databasetemplate1
 
Jun  2 06:29:40 srv31 postgres[2986]: [57282] DEBUG:  query: COMMIT
Jun  2 06:29:40 srv31 postgres[2986]: [57283] DEBUG:  ProcessUtility: COMMIT
Jun  2 06:29:41 srv31 postgres[2985]: [48998] DEBUG:  pq_recvbuf: unexpected EOF on client connection
Jun  2 06:29:41 srv31 postgres[2982]: [3335] DEBUG:  pq_recvbuf: unexpected EOF on client connection
Jun  2 06:29:41 srv31 postgres[2986]: [57284] DEBUG:  pq_recvbuf: unexpected EOF on client connection
(...)

[System info]
Red Hat Linux release 7.2 (Enigma)
Kernel 2.4.9-13
postgresql-libs-7.2.1-2PGDG
postgresql-server-7.2.1-2PGDG
postgresql-7.2.1-2PGDG

--     o__        Bem haja,   _.>/ _            NunoACHenriques  (_) \(_)            ~~~~~~~~~~~~~~~
http://students.fct.unl.pt/users/nuno/



pgsql-hackers by date:

Previous
From: "Mattew T. O'Connor"
Date:
Subject: make_ctags problem
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: make_ctags problem