tuplesort: unexpected end of data

From: NunoACHenriques <nach(at)fct(dot)unl(dot)pt>
To: pgsql-hackers(at)postgresql(dot)org
Subject: tuplesort: unexpected end of data
Date: 2002-06-02 16:20:52
Message-ID: Pine.LNX.4.44.0206021647330.20299-100000@students.fct.unl.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(Unknown Source)
at org.sourceforge.jxdbcon.postgresql.PGErrors.throwError(Unknown Source)
at org.sourceforge.jxdbcon.postgresql.PGResult.checkException(Unknown Source)
at org.sourceforge.jxdbcon.postgresql.PGExecResult.checkException(Unknown Source)
at org.sourceforge.jxdbcon.postgresql.PGConnection.executeSQL(Unknown Source)
at org.sourceforge.jxdbcon.postgresql.PGStatement.execute(Unknown Source)
at org.sourceforge.jxdbcon.AbstractStatement.executeQuery(Unknown Source)
(...)

[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.sample from 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, database template1
Jun 2 06:44:38 srv31 postgres[11498]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 06:49:39 srv31 postgres[11505]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 06:54:39 srv31 postgres[11515]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 06:59:38 srv31 postgres[11522]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 07:04:39 srv31 postgres[11541]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 07:09:39 srv31 postgres[11548]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 07:14:38 srv31 postgres[11558]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 07:19:38 srv31 postgres[11565]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
Jun 2 07:24:39 srv31 postgres[11575]: [3317] FATAL 1: No pg_hba.conf entry for host 193.136.120.30, user root, database template1
(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, database template1
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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-06-02 18:03:41 Re: make_ctags problem
Previous Message Mattew T. O'Connor 2002-06-02 08:12:12 make_ctags problem