[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#41277: postgresql: Doesn't work on sparc (fwd)

Can anyone help with this problem, please?

------- Forwarded Message

Date:    Wed, 14 Jul 1999 16:03:46 +0200
From:    Ruud de Rooij <ruud@twijfel.twi.tudelft.nl>
To:      submit@bugs.debian.org
Subject: Bug#41277: postgresql: Doesn't work on sparc

Package: postgresql
Version: 6.5-2
Severity: normal

For some reason, PostgreSQL doesn't work on my Sparcs.  Both are sun4c based,
in case it matters.

Starting the postmaster works, connecting to it with psql causes the
/usr/lib/postgres/bin/postgres child process to stay in an infinite 100% CPU
consuming loop.  Some debugging showed that it hangs inside the S_LOCK function
on line 109 of spin.c.

# gdb postgres 7181
GNU gdb 4.17.m68k.objc.threads.hwwp.fpu.gnat
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "sparc-linux"...

/usr/lib/postgresql/bin/7181: No such file or directory.
Attaching to program `/usr/lib/postgresql/bin/postgres', process 7181
Reading symbols from /lib/libcrypt.so.1...done.
Reading symbols from /lib/libnsl.so.1...done.
Reading symbols from /lib/libdl.so.2...done.
Reading symbols from /lib/libm.so.6...done.
Reading symbols from /lib/libreadline.so.2...done.
Reading symbols from /usr/lib/libhistory.so.2...done.
Reading symbols from /lib/libncurses.so.4...done.
Reading symbols from /lib/libc.so.6...done.
Reading symbols from /lib/ld-linux.so.2...done.
Reading symbols from /lib/libnss_compat.so.2...done.

SpinAcquire (lockid=-536764404) at spin.c:109
109             S_LOCK(&(slckP->locklock));

(gdb) where
#0  SpinAcquire (lockid=-536764404) at spin.c:109
#1  0xb03d8 in BufferAlloc (reln=0x1c7188, blockNum=0, 
    foundPtr=0xefff8bbf " ", bufferLockHeld=0 '\000') at bufmgr.c:376
#2  0xb01fc in ReadBufferWithBufferLock (reln=0x1c7188, blockNum=0, 
    bufferLockHeld=0 '\000') at bufmgr.c:252
#3  0xb0168 in ReadBuffer (reln=0x1c7188, blockNum=0) at bufmgr.c:171
#4  0xb0148 in RelationGetBufferWithBuffer (relation=0x1c7188, blockNumber=0, 
    buffer=0) at bufmgr.c:142
#5  0x3413c in heapgettup (relation=0x1c7188, tuple=0x1c9cb4, dir=1, 
    buffer=0x1c9cd8, snapshot=0x0, nkeys=1, key=0x1c9d28) at heapam.c:380
#6  0x3566c in heap_getnext (scandesc=0x1c9ca0, backw=0) at heapam.c:912
#7  0xee018 in scan_pg_rel_seq (buildinfo={infotype = 2, i = {
        info_id = 1238616, 
        info_name = 0x12e658 "pg_attribute_relid_attnum_index"}})
    at relcache.c:359
#8  0xedf70 in ScanPgRelation (buildinfo={infotype = 2, i = {
        info_id = 1238616, 
        info_name = 0x12e658 "pg_attribute_relid_attnum_index"}})
    at relcache.c:314
#9  0xeebfc in RelationBuildDesc (buildinfo={infotype = 2, i = {
        info_id = 1238616, 
        info_name = 0x12e658 "pg_attribute_relid_attnum_index"}})
    at relcache.c:802
#10 0xf0724 in write_irels () at relcache.c:2042
#11 0xf0694 in init_irels () at relcache.c:1866
#12 0xefa0c in RelationInitialize () at relcache.c:1623
#13 0xf4bcc in InitPostgres (name=0xefffd318 "template1") at postinit.c:546
#14 0xbe264 in PostgresMain (argc=-16396, argv=0xffffbff5, real_argc=-16394, 
    real_argv=0xffffbff7) at postgres.c:1475
#15 0xa3338 in DoBackend (port=0xffffeca4) at postmaster.c:1628
#16 0xa2d24 in BackendStartup (port=0x1bc838) at postmaster.c:1373
#17 0xa227c in ServerLoop () at postmaster.c:823
#18 0xa1d78 in PostmasterMain (argc=0, argv=0xefffeb34) at postmaster.c:616
#19 0x730cc in main (argc=12, argv=0xefffeb34) at main.c:97
#20 0xe01c2dd0 in   ()

- -- System Information
Debian Release: potato
Kernel Version: Linux rosalyn 2.2.9 #4 Sun Jun 6 10:46:52 EDT 1999 sparc unknow

Versions of the packages postgresql depends on:
ii  debianutils     1.11           Miscellaneous utilities specific to Debian.
ii  libc6           2.1.1-9        GNU C Library: Shared libraries and timezone
ii  libncurses4     4.2-3.2        Shared libraries for terminal handling
ii  libpgsql2       6.5-2          Shared library libpq.so.2 for PostgreSQL
ii  libreadlineg2   2.1-13.3       GNU readline and history libraries, run-time

------- End of Forwarded Message

      Vote against SPAM: http://www.politik-digital.de/spam/
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
     "Be not deceived; God is not mocked; for whatsoever a
      man soweth, that shall he also reap."               
                                   Galatians 6:7 

Reply to: