Problem in S_LOCK?

From: Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk>
To: hackers(at)postgresql(dot)org
Subject: Problem in S_LOCK?
Date: 1999-05-24 16:11:01
Message-ID: 199905241611.RAA23700@mtcc.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm experiencing a strange problem when playing with the
bench scripts. (No postmaster running).

Platform SPARC Linux 2.0.36, latest CVS.

If I do:-

[postgres(at)sparclinux bench]$ rm -rf /usr/local/pgsql/data/
[postgres(at)sparclinux bench]$ initdb

We are initializing the database system with username postgres (uid=900).
This user will own all the files and must also own the server process.

Creating Postgres database system directory /usr/local/pgsql/data

Creating Postgres database system directory /usr/local/pgsql/data/base

Creating template database in /usr/local/pgsql/data/base/template1

Creating global classes in /usr/local/pgsql/data/base

Adding template1 database to pg_database...

Vacuuming template1
Creating public pg_user view
Creating view pg_rules
Creating view pg_views
Creating view pg_tables
Creating view pg_indexes
Loading pg_description
[postgres(at)sparclinux bench]$ postgres -D/usr/local/pgsql/data template1

POSTGRES backend interactive interface
$Revision: 1.115 $ $Date: 1999/05/22 17:47:49 $

backend> create database bench

The command just hangs.

If I run under a debugger I can see the following backtrace:-

(gdb) cont
Continuing.

Program received signal SIGINT, Interrupt.
SpinAcquire (lockid=5) at spin.c:109
109 S_LOCK(&(slckP->locklock));
(gdb) bt
#0 SpinAcquire (lockid=5) at spin.c:109
#1 0xd0b80 in LockAcquire (lockmethod=1, locktag=0xefff6e00, lockmode=1) at lock.c:530
#2 0xd02c4 in LockRelation (relation=0x2c9b18, lockmode=1) at lmgr.c:185
#3 0x104d8c in scan_pg_rel_ind (buildinfo={infotype = 2, i = {info_id = 1400920, info_name = 0x156058 "pg_type_oid_index"}})
at relcache.c:394
#4 0x104c68 in ScanPgRelation (buildinfo={infotype = 2, i = {info_id = 1400920, info_name = 0x156058 "pg_type_oid_index"}})
at relcache.c:316
#5 0x1059f0 in RelationBuildDesc (buildinfo={infotype = 2, i = {info_id = 1400920, info_name = 0x156058 "pg_type_oid_index"}})
at relcache.c:802
#6 0x1061cc in RelationNameGetRelation (relationName=0x156058 "pg_type_oid_index") at relcache.c:1220
#7 0x3d0d4 in index_openr (relationName=0x156058 "pg_type_oid_index") at indexam.c:153
#8 0x102d5c in CatalogCacheInitializeCache (cache=0x2ec018, relation=0x2cadb0) at catcache.c:247
#9 0x103c1c in SearchSysCache (cache=0x2ec018, v1=705, v2=0, v3=0, v4=0) at catcache.c:834
#10 0x107d8c in SearchSysCacheTuple (cacheId=13, key1=705, key2=0, key3=0, key4=0) at syscache.c:507
#11 0x96db4 in typeidType (id=705) at parse_type.c:67
#12 0x955a8 in make_const (value=0x30e390) at parse_node.c:421
#13 0x91cdc in transformExpr (pstate=0x30e590, expr=0x30e388, precedence=1) at parse_expr.c:105
#14 0x97ecc in MakeTargetEntryComplex (pstate=0x30e590, res=0x30e3b0) at parse_target.c:367
#15 0x98430 in transformTargetList (pstate=0x30e590, targetlist=0x30e3c8) at parse_target.c:574
#16 0x88078 in transformInsertStmt (pstate=0x30e590, stmt=0x30e530) at analyze.c:267
#17 0x87ee8 in transformStmt (pstate=0x30e590, parseTree=0x30e530) at analyze.c:180
#18 0x87c60 in parse_analyze (pl=0x30e578, parentParseState=0x0) at analyze.c:72
#19 0x905b4 in parser (str=0x1d7c00 "", typev=0x0, nargs=0) at parser.c:62
#20 0xd6f58 in pg_parse_and_plan (
query_string=0xefffb8e0 "insert into pg_database (datname, datdba, encoding, datpath) values ('bench', '900', '0', 'bench');",
typev=0x0, nargs=0, queryListP=0xefffb65c, dest=Debug, aclOverride=0 '\000') at postgres.c:454
#21 0xd7350 in pg_exec_query_dest (
query_string=0xefffb8e0 "insert into pg_database (datname, datdba, encoding, datpath) values ('bench', '900', '0', 'bench');",
dest=Debug, aclOverride=0 '\000') at postgres.c:664
#22 0x72228 in createdb (dbname=0x30e040 "bench", dbpath=0xefffb6e0 "bench", encoding=0, dest=Debug) at dbcommands.c:91
#23 0xd9e68 in ProcessUtility (parsetree=0x30e058, dest=Debug) at utility.c:560
#24 0xd7400 in pg_exec_query_dest (query_string=0xefffbcc8 "create database bench\n", dest=Debug, aclOverride=0 '\000') at
postgres.c:704
#25 0xd7304 in pg_exec_query (query_string=0xefffbcc8 "create database bench\n") at postgres.c:642
#26 0xd86fc in PostgresMain (argc=3, argv=0xeffffd94, real_argc=3, real_argv=0xeffffd94) at postgres.c:1626
#27 0x87c24 in main (argc=3, argv=0xeffffd94) at main.c:103
(gdb)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy J.M. Cain 1999-05-24 16:51:20 Re: [HACKERS] Open 6.5 items
Previous Message Oleg Bartunov 1999-05-24 15:46:51 Re: [HACKERS] Updated 6.5 HISTORY