Package: postgresql-9.1
Version: 9.1.3-1
Severity: normal
Tags: upstream
Dear Maintainer,
* What led up to the situation?
# su - postgres
$ LANG=C /usr/lib/postgresql/9.1/bin/psql -p5433 -d db
psql (9.1.3)
db=# DELETE FROM taxinomie_taxref_rang;
If needed I can provide the database.
* What was the outcome of this action?
Query "DELETE FROM taxinomie_taxref_rang;" doesn't end. Process postgres
with pid 25056 take 100% CPU (1 core).
Table taxinomie_taxref_rang contains 17 rows.
Problem still occurs after:
- # /etc/init.d/postgresql restart
- # reboot
# ps aux|grep db
postgres 25055 0.0 0.0 74356 3428 pts/1 S+ 12:53 0:00
/usr/lib/postgresql/9.1/bin/psql -p5433 -d db
postgres 25056 97.7 0.9 119964 39236 ? Rs 12:53 17:39 postgres:
postgres db [local] DELETE
# strace -f -p 25056
lseek(43, 0, SEEK_END) = 16695296
lseek(45, 0, SEEK_END) = 0
[the two lines above repeated many times]
read(37, "\0\0\0\0\20\334=\226\1\0\0\0\254\0@\1\0 \4
\331-\0\0\350\236.\2\370\235\326\1"..., 8192) = 8192
lseek(43, 0, SEEK_END) = 16695296
lseek(45, 0, SEEK_END) = 0
[the two lines above repeated many times]
# ls -lH /proc/25056/fd/45
-rw------- 1 postgres postgres 0 Mar 2 13:15 /proc/25056/fd/45
# ls -lH /proc/25056/fd/43
-rw------- 1 postgres postgres 16695296 Mar 3 12:53 /proc/25056/fd/43
# /usr/lib/postgresql/9.1/bin/psql -p5433 -d db -c "\d
taxinomie_taxref_rang"
Table "public.taxinomie_taxref_rang"
Column | Type |
Modifiers
-----------------+--------------------------------+--------------------------------------------------------------------
id | integer | not null default
nextval('taxinomie_taxref_rang_id_seq'::regclass)
create_date | timestamp(6) without time zone |
write_date | timestamp(6) without time zone |
create_uid | integer |
write_uid | integer |
rng_code | character varying | not null
rng_description | character varying |
Indexes:
"taxinomie_taxref_rang_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
"taxinomie_taxref_rang_create_uid_fkey" FOREIGN KEY (create_uid)
REFERENCES res_user(id) ON DELETE SET NULL
"taxinomie_taxref_rang_write_uid_fkey" FOREIGN KEY (write_uid)
REFERENCES res_user(id) ON DELETE SET NULL
Referenced by:
TABLE "taxinomie_taxref" CONSTRAINT "taxinomie_taxref_trf_rang_fkey"
FOREIGN KEY (trf_rang) REFERENCES taxinomie_taxref_rang(id) ON DELETE CASCADE
# /usr/lib/postgresql/9.1/bin/psql -p5433 -d db -c "select * from
taxinomie_taxref_rang;"
id | create_date | write_date | create_uid | write_uid |
rng_code | rng_description
----+-------------------------+------------+------------+-----------+----------+-----------------
52 | 2012-03-02 16:14:04.974 | | 0 | | AB
| Abberatio
53 | 2012-03-02 16:14:04.974 | | 0 | | AGES
| Agrégat
54 | 2012-03-02 16:14:04.974 | | 0 | | CAR
| Cultivar
55 | 2012-03-02 16:14:04.974 | | 0 | | CL
| Classe
56 | 2012-03-02 16:14:04.974 | | 0 | | CVAR
| Convariété
57 | 2012-03-02 16:14:04.974 | | 0 | | ES
| Espèce
58 | 2012-03-02 16:14:04.974 | | 0 | | FM
| Famille
59 | 2012-03-02 16:14:04.974 | | 0 | | FO
| Forme
60 | 2012-03-02 16:14:04.974 | | 0 | | GN
| Genre
61 | 2012-03-02 16:14:04.974 | | 0 | | KD
| Règne
62 | 2012-03-02 16:14:04.974 | | 0 | | OR
| Ordre
63 | 2012-03-02 16:14:04.974 | | 0 | | PH
| Embranchement
64 | 2012-03-02 16:14:04.974 | | 0 | | RACE
| Race
65 | 2012-03-02 16:14:04.974 | | 0 | | SSES
| Sous-espèce
66 | 2012-03-02 16:14:04.975 | | 0 | | SSFO
| Sous-Forme
67 | 2012-03-02 16:14:04.975 | | 0 | | SVAR
| Sous-variété
68 | 2012-03-02 16:14:04.975 | | 0 | | VAR
| Variété
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable'), (1,
'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-1-amd64 (SMP w/8 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages postgresql-9.1 depends on:
ii libc6 2.13-27
ii libcomerr2 1.42.1-2
ii libgssapi-krb5-2 1.10+dfsg~beta1-2
ii libkrb5-3 1.10+dfsg~beta1-2
ii libldap-2.4-2 2.4.28-1.1
ii libpam0g 1.1.3-7
ii libpq5 9.1.3-1
ii libssl1.0.0 1.0.0g-1
ii libxml2 2.7.8.dfsg-7
ii locales 2.13-27
ii locales-all [locales] 2.13-27
ii postgresql-client-9.1 9.1.3-1
ii postgresql-common 128
ii ssl-cert 1.0.28
ii tzdata 2011n-2
postgresql-9.1 recommends no packages.
Versions of packages postgresql-9.1 suggests:
pn locales-all 2.13-27
pn oidentd | ident-server <none>
-- debconf-show failed
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
