Re: Strange Error in postgresql 8.4

On 06/20/2014 01:18 AM, Dick Kniep wrote:
> Hi list,
>
> We have been using Postgresql for more than a decade now. Never had any real problems. Thank you very much for this
greatproduct. 
>
> 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
>

What is the Postgres version and the OS type and version?

For the momentI am going to go out on a limb and say you are using some
form of Debian and the problem is possibly related to this bug:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=751093

> Cheers,
> D. Kniep
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com