I have a serious problem with hanging backends.

From: johan27(at)advalvas(dot)be
To: pgsql-bugs(at)postgresql(dot)org
Subject: I have a serious problem with hanging backends.
Date: 2001-09-05 22:42:57
Message-ID: 3b96a984.828441@news.skynet.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I have a serious problem with hanging backends.
This is wat I get from ps ->
postgres 23507 22794 0 13:33 ? 00:00:09
/usr/local/pgsql/bin/postgres 1.1.3.123 postgres bts01 SELECT waiting

This blocks all the other clients. (ODBC call failed)

The situation

- PostgreSQL 6.4.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.
(SlackWare)
- 30 Access 2000 clients connecting through 6.40.00.06 ODBC driver

- ODBC connections error's

-> CONN ERROR: func=SQLGetConnectOption,
desc='fOption=30002', errnum=205, errmsg='Unknown connect
option (Get)'

------------------------------------------------------------
henv=144902176, conn=144863832, status=0,
num_stmts=16
so ck=144902128, stmts=144902048, lobj_type=-999

----------------SocketInfo-------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=144870304, buffer_out=144874408
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0

CONN ERROR: func=SQLSetConnectOption,
desc='fOption=30002, vParam=143791720', errnum=205,
errmsg='Unknown connect option (Set)'

------------------------------------------------------------
henv=144902176, conn=144863832, status=0, num_stmts=16
sock=144902128, stmts=144902048, lobj_type=-999

----------------SocketInfo-------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=144870304, buffer_out=144874408
buffer_filled_in=0, buffer_filled_out=0,
buffer_read_in=0

- In de server-log I found that the access-application wants to
connect with the user Admin then we get
FATAL 1 : user Admin not in pg_shadow

But in the connection properties the user postgres is set.
This (connection with user Admin) seems to have started with
the conversion 97 -> 2000

I've added the user, this error was gone, but some of the jobs

are admin owned other postgres

- I had problems before with the MaxBackendId
I've rebuild with MaxBackendId set to 128 and started the
postmaster with -B 256 parameter.
This was because of the message "cache invalidation
initialization failed"
So this was solved, or is

- In the loggings the SELECT waiting jobs hang on ProcessQuery and
the other InitPostgres fail.

- vacuum verbose analyze doen't seem to report errors

- debug higher then 4 is not usable (2 gig in 10 minutes)

In which direction do I have to search?
Can there be data corruption without being reported?
Can it be solved with a pg_dump file, destroydb, createdb,
psql -e file ? (Not done already -> production machine)
Is our version to old -> should an upgrade help?
.... ?

Thanks,

Jeroen Ryckeboer

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-09-06 05:04:50 Bug #438: New users inherit permissions from dropped users
Previous Message Tom Lane 2001-09-05 21:35:31 Re: create view bug