Hi @mailing.database.pgsql-bugs,

i got a problem, searching for days in the online archives, but i cant
get solved ?!?!? its getting me mad... for sure its an OS related
problem, because the same stuff (same table structures, same stored
procedures, same php, etc.) is working on a NET BSD 1.6 system...
but i cant solve it... maybe im in the wrong newsgroup...
but please give me a chance... or tell me where it could fit better...
i also will post this message in the suse help groups... and i saw
similar problems as well occuring in the past...

on a

SUSE 7.3
Linux ns1 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown

system i get following LOG entries:

Mar 3 01:54:49 ns1 postgres[1322]: [10-1] LOG: could not receive data
from client: Connection reset by peer
Mar 3 01:54:49 ns1 postgres[1322]: [11-1] LOG: unexpected EOF on
client connection

this appears after i call a stored procedure which executes a sql
and returns the result as refcursor...

if i call this procedure with
SELECT col1, col2, col3 from tableX
ORDER BY length(col3) ASC

everything works fine...

if i call this procedure with
SELECT col1, col2, col3 from tableX
ORDER BY length(col3) DESC

i get the log entries mentioned above... ????? i read about in the
online archives and other newsgroups that it could be a SHARED MEMORY
PROBLEM of the OS... but i did set up all the shared memory settings
of the kernel... and nothing works, i dont get away from this error...

Filesystem on the OS is
REISERFS on a RAID 0 (Promise Fasttrak)

postgres 7.4.1 is compiled with

../configure \
--with-perl \
--with-openssl \
--with-maxbackends=1024 \
--enable-multibyte=UNICODE \
--enable-unicode-conversion

KERNEL (sysctl -a) memory values are:

vm.max_map_count = 65536
vm.max-readahead = 31
vm.min-readahead = 3
vm.heap-stack-gap = 1
vm.page-cluster = 3
vm.pagetable_cache = 25 50
vm.kswapd = 512 32 8
vm.overcommit_memory = 0
vm.bdflush = 30 500 0 0 500 3000 60 20 0
vm.vm_passes = 20
vm.vm_mapped_ratio = 100
vm.vm_lru_balance_ratio = 2
vm.vm_vfs_scan_ratio = 6
vm.vm_gfp_debug = 0
kernel.overflowgid = 65534
kernel.overflowuid = 65534
kernel.random.uuid = 359a5d76-f22e-4965-9e16-2715b0fe38c6
kernel.random.boot_id = ae4ac7cd-86ee-40ed-95b2-cfca2b934b12
kernel.random.write_wakeup_threshold = 128
kernel.random.read_wakeup_threshold = 8
kernel.random.entropy_avail = 2767
kernel.random.poolsize = 512
kernel.threads-max = 128000
kernel.cad_pid = 1
kernel.sysrq = 0
kernel.sem = 250 256000 32 1024
kernel.msgmnb = 16384
kernel.msgmni = 1024
kernel.msgmax = 81920
kernel.shmmni = 40960
kernel.shmall = 2097152
kernel.shmmax = 268435456
kernel.rtsig-max = 1024
kernel.rtsig-nr = 1
kernel.acct = 4 2 30
kernel.hotplug = /sbin/hotplug
kernel.modprobe = /sbin/modprobe
kernel.printk = 1 4 1 7
kernel.ctrl-alt-del = 0
kernel.real-root-dev = 2054
kernel.cap-bound = -257
kernel.tainted = 0
kernel.core_uses_pid = 0
kernel.panic = 0
kernel.version = #1 Wed Mar 27 13:57:05 UTC 2002
kernel.osrelease = 2.4.18-4GB
kernel.ostype = Linux
fs.lease-break-time = 45
fs.dir-notify-enable = 1
fs.leases-enable = 1
fs.overflowgid = 65534
fs.overflowuid = 65534
fs.dentry-state = 38822 33082 45 0 0 0
fs.dquot-nr = 0 0
fs.file-max = 104851
fs.file-nr = 1065 253 104851
fs.inode-state = 84422 47907 0 0 0 0 0
fs.inode-nr = 84422 47907

would be really nice, if someone could help a bit...
thanx, claus pruefer/developer...