Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page

From: "Rajan Bhide" <rbhide(at)nulinkinc(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-novice(at)postgresql(dot)org>, " Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
Date: 2004-05-31 12:30:30
Message-ID: FF851C7EEB75954F9BCFB5CA117AB1ECFC322F@delta.nulinkinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 5) What additional logs should be monitored/enabled to get more help
to resolve this problem?

To enable statistics collection I updated few related entries in
postgresql.conf file but got following msg.

$ 2004-05-28 08:13:01 LOG: could not bind socket for statistics
collector: Cannot assign requested address
2004-05-28 08:13:01 LOG: database system was shut down at 2004-05-28
08:13:00 GMT
2004-05-28 08:13:01 LOG: checkpoint record is at 80/89392010
2004-05-28 08:13:01 LOG: redo record is at 80/89392010; undo record is
at 0/0; shutdown TRUE
2004-05-28 08:13:01 LOG: next transaction ID: 124196777; next OID:
237888262
2004-05-28 08:13:01 LOG: database system is ready

Whats the reason for this?
I am starting Postmaster with -o -I option. (Enabled TCP/IP
communication)

The localhost is avaliable in /etc/hosts file.

$)ifconfig -a
lo0: flags=1000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 8232 index 1
inet 127.0.0.1 netmask ff000000
eri0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index
2
inet 10.2.5.3 netmask ffff0000 broadcast 10.2.255.255
eri1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index
3
inet 192.168.206.2 netmask ffffff00 broadcast 192.168.206.255

$)nslookup localhost
Server: <undisclosed>
Address: 12.33.234.50

Name: localhost
Address: 127.0.0.1

$)more /etc/hosts
127.0.0.1 localhost

$)more /etc/inet/ipnodes
#
# Internet host table
#
::1 localhost
127.0.0.1 localhost

Thanks,
Rajan Bhide

Browse pgsql-novice by date

  From Date Subject
Next Message derrick 2004-05-31 15:04:50 Re: Dynamic Array into pl/pgSQL function
Previous Message Oliver Elphick 2004-05-31 07:03:54 Re: Dynamic Array into pl/pgSQL function