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 debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org