7.4b4 undetected deadlock? - Mailing list pgsql-bugs

From Robert Creager
Subject 7.4b4 undetected deadlock?
Date
Msg-id 20031005181236.5963ae76.Robert_Creager@LogicalChaos.org
Whole thread Raw
Responses Re: 7.4b4 undetected deadlock?
List pgsql-bugs
I'm running 7.4b4 and ran into a little problem with my import and pg_autovacuum's call of VACUUM.

PostgreSQL 7.4beta4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 (Mandrake Linux 9.1 3.2.2-3mdk)

$ ./configure --with-tcl --with-openssl=/usr/include/openssl --with-CXX --enable-syslog --with-tclconfig=/usr/lib
--with-perl

postgres 16542 16541  0 Oct04 ?        00:00:02 /usr/local/pgsql/bin/pg_autovacuum -d 0
postgres 20209     1  0 Oct04 pts/4    00:00:01 /usr/local/pgsql/bin/postmaster -D /var/lib/pgsql/data -D
/var/lib/pgsql/data
postgres 20213 20209  0 Oct04 pts/4    00:00:10 postgres: stats buffer process
     
postgres 20215 20213  0 Oct04 pts/4    00:00:11 postgres: stats collector process
     
postgres 20231 20209  0 Oct04 pts/4    00:08:09 postgres: perl_test cpan 192.168.0.250 idle
     
postgres 29304 20209  0 17:37 pts/4    00:00:00 postgres: robert tassiv 192.168.0.250 idle in transaction
     
postgres 29305 20209  0 17:37 pts/4    00:00:00 postgres: robert tassiv 192.168.0.250 idle
     
postgres 29335 20209  0 17:37 pts/4    00:00:01 postgres: robert tassiv 192.168.0.250 REINDEX waiting
     
postgres 29336 20209  0 17:37 pts/4    00:00:00 postgres: robert tassiv 192.168.0.250 idle
     
postgres 29549 20209  0 17:44 pts/4    00:00:00 postgres: postgres tassiv [local] VACUUM waiting
     

The reindex command is:

REINDEX TABLE temp_obs_i
or
REINDEX TABLE temp_obs_v

temp_obs_? is not a temporary table:

tassiv=# \d temp_obs_v
                     Table "public.temp_obs_v"
 Column  |  Type   |                   Modifiers
---------+---------+------------------------------------------------
 x       | real    | not null
 y       | real    | not null
 imag    | real    | not null
 smag    | real    | not null
 loc     | spoint  | not null
 obs_id  | integer | not null default nextval('"obs_id_seq"'::text)
 file_id | integer | not null
 use     | boolean | default false
 solve   | boolean | default false
 star_id | integer |
 mag     | real    |
Indexes:
    "temp_obs_v_file_id_index" btree (file_id)
    "temp_obs_v_loc_index" gist (loc)
Inherits: obs_root

tassiv=# \d obs_root
                      Table "public.obs_root"
 Column  |  Type   |                   Modifiers
---------+---------+------------------------------------------------
 x       | real    | not null
 y       | real    | not null
 imag    | real    | not null
 smag    | real    | not null
 loc     | spoint  | not null
 obs_id  | integer | not null default nextval('"obs_id_seq"'::text)
 file_id | integer | not null
 use     | boolean | default false
 solve   | boolean | default false
 star_id | integer |
 mag     | real    |
Foreign-key constraints:
    "$1" FOREIGN KEY (file_id) REFERENCES files(file_id)
    "$2" FOREIGN KEY (star_id) REFERENCES catalog(star_id)

backtrace from 29549
#0  0x403279d7 in semop () from /lib/i686/libc.so.6
#1  0x081333c1 in PGSemaphoreLock ()
#2  0x081508bc in ProcSleep ()
#3  0x0814f814 in WaitOnLock ()
#4  0x0814f429 in LockAcquire ()
#5  0x0814e999 in LockRelation ()
#6  0x0807b2f9 in relation_open ()
#7  0x080e92c4 in vacuum_rel ()
#8  0x080e8be1 in vacuum ()
#9  0x08158ce5 in PortalRunUtility ()
#10 0x08158f78 in PortalRunMulti ()
#11 0x0815887e in PortalRun ()
#12 0x08155b5c in exec_simple_query ()
#13 0x08157b87 in PostgresMain ()
#14 0x0813663f in BackendFork ()
#15 0x08136108 in BackendStartup ()
#16 0x0813498d in ServerLoop ()
#17 0x08134318 in PostmasterMain ()
#18 0x0810a09c in main ()
#19 0x4025e7f7 in __libc_start_main () from /lib/i686/libc.so.6

and from 29335
#0  0x403279d7 in semop () from /lib/i686/libc.so.6
#1  0x081333c1 in PGSemaphoreLock ()
#2  0x081508bc in ProcSleep ()
#3  0x0814f814 in WaitOnLock ()
#4  0x0814f429 in LockAcquire ()
#5  0x0814e999 in LockRelation ()
#6  0x0807b2f9 in relation_open ()
#7  0x0807b444 in heap_open ()
#8  0x0809fff4 in reindex_relation ()
#9  0x080d2c40 in ReindexTable ()
#10 0x08158ce5 in PortalRunUtility ()
#11 0x08158f78 in PortalRunMulti ()
#12 0x0815887e in PortalRun ()
#13 0x08155b5c in exec_simple_query ()
#14 0x08157b87 in PostgresMain ()
#15 0x0813663f in BackendFork ()
#16 0x08136108 in BackendStartup ()
#17 0x0813498d in ServerLoop ()
#18 0x08134318 in PostmasterMain ()
#19 0x0810a09c in main ()
#20 0x4025e7f7 in __libc_start_main () from /lib/i686/libc.so.6

Cheers,
Rob

--
17:55:02 up 65 days, 10:24,  4 users,  load average: 2.20, 2.16, 2.57

pgsql-bugs by date:

Previous
From: Theodore Petrosky
Date:
Subject: congrats
Next
From: Tom Lane
Date:
Subject: Re: 7.4b4 undetected deadlock?