Weird problem in 8.0.0

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I've just upgraded two servers to 8.0.0, using PGDG RPMs.

One of them is working well; however I'm experiencing problems in the
other one.

I first thought that this was a VACUMM issue; but then I saw that I can't
execute any command.

First case: Connected to template1 using psql and ran VACUMM. Here is the
log output (debug 5) (same thing happens when I run vacuumdb from the
command line)

=============================================================================
<[unknown][unknown]%t>LOG: connection received: host=[local] port=
<%t>DEBUG: forked new backend, pid=3104 socket=7
<postgrestemplate1%tauthentication>DEBUG: received password packet
<postgrestemplate1%tauthentication>LOG: connection authorized:
user=postgres database=template1
<postgrestemplate1%tauthentication>DEBUG: postmaster child[3104]:
starting with (
<postgrestemplate1%tauthentication>DEBUG: postgres
<postgrestemplate1%tauthentication>DEBUG: -v196608
<postgrestemplate1%tauthentication>DEBUG: -p
<postgrestemplate1%tauthentication>DEBUG: template1
<postgrestemplate1%tauthentication>DEBUG: )
<postgrestemplate1%tstartup>DEBUG: InitPostgres
<postgrestemplate1%tstartup>DEBUG: StartTransaction
<postgrestemplate1%tstartup>DEBUG: name: unnamed; blockState:
DEFAULT; state: INPROGR, xid/subid/cid: 4341/1/0, nestlvl: 1, children: <>
<postgrestemplate1%tstartup>DEBUG: CommitTransaction
<postgrestemplate1%tstartup>DEBUG: name: unnamed; blockState:
STARTED; state: INPROGR, xid/subid/cid: 4341/1/0, nestlvl: 1, children: <>
<postgrestemplate1%tidle>DEBUG: StartTransactionCommand
<postgrestemplate1%tidle>STATEMENT: VACUUM ;
<postgrestemplate1%tidle>DEBUG: StartTransaction
<postgrestemplate1%tidle>STATEMENT: VACUUM ;
<postgrestemplate1%tidle>DEBUG: name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 4342/1/0, nestlvl: 1, children: <>
<postgrestemplate1%tidle>STATEMENT: VACUUM ;
<postgrestemplate1%tidle>LOG: statement: VACUUM ;
<postgrestemplate1%tidle>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>DEBUG: ProcessUtility
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>DEBUG: CommitTransaction
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>DEBUG: name: unnamed; blockState:
STARTED; state: INPROGR, xid/subid/cid: 4342/1/0, nestlvl: 1, children: <>
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>DEBUG: StartTransaction
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>DEBUG: name: unnamed; blockState:
DEFAULT; state: INPROGR, xid/subid/cid: 4343/1/0, nestlvl: 1, children: <>
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>DEBUG: vacuuming
"information_schema.sql_packages"
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
<postgrestemplate1%tVACUUM>ERROR: canceling query due to user request
<postgrestemplate1%tVACUUM>STATEMENT: VACUUM ;
=============================================================================

Now, second case:

template1=# \c proftpd
You are now connected to database "proftpd".
proftpd=# SELECT passwd FROM users WHERE userid='istanbul';
ERROR: canceling query due to user request

And the log shows:

=============================================================================
<postgresproftpd%tidle>DEBUG: StartTransactionCommand
<postgresproftpd%tidle>STATEMENT: SELECT passwd FROM users WHERE
userid='istanbul';
<postgresproftpd%tidle>DEBUG: StartTransaction
<postgresproftpd%tidle>STATEMENT: SELECT passwd FROM users WHERE
userid='istanbul';
<postgresproftpd%tidle>DEBUG: name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 4347/1/0, nestlvl: 1, children: <>
<postgresproftpd%tidle>STATEMENT: SELECT passwd FROM users WHERE
userid='istanbul';
<postgresproftpd%tidle>LOG: statement: SELECT passwd FROM users WHERE
userid='istanbul';
<postgresproftpd%tidle>STATEMENT: SELECT passwd FROM users WHERE
userid='istanbul';
<postgresproftpd%tSELECT>ERROR: canceling query due to user request
<postgresproftpd%tSELECT>STATEMENT: SELECT passwd FROM users WHERE
userid='istanbul';
<postgresproftpd%tidle>DEBUG: proc_exit(0)
<postgresproftpd%tidle>DEBUG: shmem_exit(0)
=============================================================================

What might be the problem? The upgrade process was done as usual...

Regards,

- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFB9JaLtl86P3SPfQ4RAgwaAKCfupu287wiCGZntn6+WZmyg8QSBACgp8VO
i/6uRBjyMDdPcFIXCrlP2E8=
=dSc+
-----END PGP SIGNATURE-----