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/
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 |