Strange Error in postgresql 8.4

From: Dick Kniep <dick(dot)kniep(at)lindix(dot)nl>
To: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Subject: Strange Error in postgresql 8.4
Date: 2014-06-20 08:18:43
Message-ID: zarafa.53a3ee63.31e5.721e3745317f2996@mail.int.lindix.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

We have been using Postgresql for more than a decade now. Never had any real problems. Thank you very much for this great product.

Now recently I have noticed a strange problem.

Below is a traceback of a python program using psycopg and this correlates with the postgresql log below that.

Traceback (most recent call last):
File "/opt/CVix/src/ftsDocs.py", line 686, in <module>
CVixfts(schemanaam=schemanaam, hostnaam=hostnaam, dbnaam=dbnaam, production=production)
File "/opt/CVix/src/ftsDocs.py", line 82, in __init__
dbhost=hostnaam, dbname=dbnaam, production=production)
File "/opt/CVix-prod/src/Batch/BatchMod.py", line 58, in __init__
self.ExecPgm(schemanaam, programma, importfile)
File "/opt/CVix-prod/src/Batch/BatchMod.py", line 69, in ExecPgm
else: eval('self.' + programma + '(schemanaam)')
File "<string>", line 1, in <module>
File "/opt/CVix/src/ftsDocs.py", line 124, in BuildFtsIndex
self.indexDocs()
File "/opt/CVix/src/ftsDocs.py", line 202, in indexDocs
docs, cursorContext = self.DocTAB.scroll(WHERE=wherestmt, LIMIT=50, withhold=True)
File "/opt/CVix-prod/src/SQLConnect/SQLDict.py", line 620, in scroll
c = self.select(WHERE=WHERE, LOGICALDELETE=LOGICALDELETE, ORDER=ORDER, NAMEDCURSOR=True, WITHHOLD=withhold)
File "/opt/CVix-prod/src/SQLConnect/SQLDict.py", line 599, in select
if self.executeSQL(c, selectstmt, i): return self._resultcursor
File "/opt/CVix-prod/src/SQLConnect/SQLDict.py", line 309, in executeSQL
self._resultcursor.execute(stmt)
psycopg2.DatabaseError: SSL error: ccs received early

postresql log

2014-06-20 09:45:09 CEST LOG: duration: 4265.211 ms statement: SELECT "doc_id", "document", "mutd
at", "mutmed", "opd_id", "rapport", "doc_type", "cli_id", "classificatie", "entry_owner", "createda
te", "doc_ptype", "bed_id", "cper_id", "lastrealuser", "doc_mimetype", "doc_md5sum", "doc_selectman
ually", "eigen_bed_id", "doc_template", "per_id", "doc_standardtype", "pathfilename", "lastmodifica
tion", "imported", "doc_fts_processed", "doc_address_addition", "doc_type_id" FROM "comsupport"."do
cumenten" sqd1 WHERE (doc_fts_processed < mutdat or doc_fts_processed is NULL)
2014-06-20 09:45:31 CEST LOG: could not send data to client: Connection reset by peer
2014-06-20 09:45:31 CEST STATEMENT: SELECT "doc_id", "document", "mutdat", "mutmed", "opd_id", "rapport", "doc_type", "cli_id", "classificatie", "entry_owner", "createdate", "doc_ptype", "bed_id", "cper_id", "lastrealuser", "doc_mimetype", "doc_md5sum", "doc_selectmanually", "eigen_bed_id", "doc_template", "doc_standardtype", "per_id", "pathfilename", "lastmodification", "doc_fts_processed", "imported", "doc_address_addition", "doc_type_id" FROM "menea"."documenten" sqd1 WHERE (doc_fts_processed < mutdat or doc_fts_processed is NULL)
2014-06-20 09:45:31 CEST LOG: could not send data to client: Broken pipe
2014-06-20 09:45:31 CEST STATEMENT: SELECT "doc_id", "document", "mutdat", "mutmed", "opd_id", "rapport", "doc_type", "cli_id", "classificatie", "entry_owner", "createdate", "doc_ptype", "bed_id", "cper_id", "lastrealuser", "doc_mimetype", "doc_md5sum", "doc_selectmanually", "eigen_bed_id", "doc_template", "doc_standardtype", "per_id", "pathfilename", "lastmodification", "doc_fts_processed", "imported", "doc_address_addition", "doc_type_id" FROM "menea"."documenten" sqd1 WHERE (doc_fts_processed < mutdat or doc_fts_processed is NULL)
2014-06-20 09:45:33 CEST LOG: duration: 16535.228 ms statement: SELECT "doc_id", "document", "mutdat", "mutmed", "opd_id", "rapport", "doc_type", "cli_id", "classificatie", "entry_owner", "createdate", "doc_ptype", "bed_id", "cper_id", "lastrealuser", "doc_mimetype", "doc_md5sum", "doc_selectmanually", "eigen_bed_id", "doc_template", "doc_standardtype", "per_id", "pathfilename", "lastmodification", "doc_fts_processed", "imported", "doc_address_addition", "doc_type_id" FROM "menea"."documenten" sqd1 WHERE (doc_fts_processed < mutdat or doc_fts_processed is NULL)
2014-06-20 09:45:33 CEST LOG: SSL error: bad write retry
2014-06-20 09:45:33 CEST LOG: could not send data to client: Connection reset by peer
2014-06-20 09:45:33 CEST LOG: SSL error: sslv3 alert unexpected message
2014-06-20 09:45:33 CEST LOG: could not receive data from client: Connection reset by peer
2014-06-20 09:45:33 CEST LOG: unexpected EOF on client connection

Googling did not reveal any clues on what is causing this. I am considering a reboot of the complete db server, but I don't like to do things without having a clue on what is causing this.

Cheers,
D. Kniep

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2014-06-20 08:52:49 Re: How can I get first day date of the previous month ?
Previous Message Arup Rakshit 2014-06-20 07:11:01 Re: How can I get first day date of the previous month ?