asked on

CLUSTER statement fails with 'server closed the connection unexpectedly'

The following command use to work:

wts1=# CLUSTER inv_search4_idx ON Invoice ;

But now I am getting the following error:

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

OS Info:
Postrgesql 7.4.7
Fedora Core 2

The actual script looks like:

# Knock off any users. They shouldn't be up this late!

echo
/sbin/service postgresql restart

echo
date
echo -e "\n-->Re-Clustering Orderdate Index on Invoice Table"

/usr/bin/psql -h 192.168.2.144 wts1 <<EOF
CLUSTER inv_search4_idx ON Invoice ;
VACUUM FULL ANALYZE Invoice ;
EOF

echo
date
echo -e "\nDone"

Thanks in advance

gheist

Your firewall(or NAT router) in the middle closed connection...

ASKER CERTIFIED SOLUTION

earth man2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike Hagan

ASKER

To gheist:

I thought of this. The sql fails on the local machine.

Mike Hagan

ASKER

To earthman2:

I am getting ready to upgrade to Fedora Core 4 ... I'm not quite ready to jump to 5. I have scripts that create my index and reset the OID. I can use your solution in the interim without much effort.

Thanks

gheist

If you can get new machine then try any distribution with 8.x.y, if it works prepare to jump.