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/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
