Participants
maxiangqian
maxiangqian
Attachments
Show all attachments
Thread Outline
#1maxiangqianmaxiangqian
Feb 21, 2014

table "db1.public.a" and all behind "db1.public.a" tables did not do analyzing

Started by maxiangqianabout 12 years ago1 messagesgeneral
Jump to latest
#1maxiangqian
maxiangqian
maxiangqian@gmail.com

when I used vacuumdb -d db1 -z -v > /BACKUP/script/db1.$LOG_DATE.log 2>&1
it occued this error [automatic vacuum of table "db1.public.a": could not
(re)acquire exclusive lock for truncat]
and table "db1.public.a" and all behind "db1.public.a" tables did not do
analyzing.
I want to know:
1.why table "db1.public.a" and all behind "db1.public.a" tables did not do
analyzing?

log is below:
#PostGreSQL: VACUUM 2014-02-07 05:36:16 CST user db1 [local] CSTINFO:
vacuuming "public.t1"
#PostGreSQL: VACUUM 2014-02-07 05:36:16 CST user db1 [local] CSTINFO:
analyzing "public.t1"
#PostGreSQL: VACUUM 2014-02-07 05:36:16 CST user db1 [local] CSTINFO:
vacuuming "public.t2"
#PostGreSQL: VACUUM 2014-02-07 05:36:16 CST user db1 [local] CSTINFO:
analyzing "public.t2"

#PostGreSQL: VACUUM 2014-02-07 05:36:16 CST user db1 [local] CSTINFO:
vacuuming "public.a"
#PostGreSQL: VACUUM 2014-02-07 05:36:18 CST user db1 [local] CSTLOG:
automatic vacuum of table "db1.public.a": could not (re)acquire exclusive
lock for truncate scan

#PostGreSQL: VACUUM 2014-02-07 05:36:18 CST user db1 [local] CSTINFO:
vacuuming "public.b"
#PostGreSQL: VACUUM 2014-02-07 05:36:18 CST user db1 [local] CSTINFO:
vacuuming "public.c"
#PostGreSQL: VACUUM 2014-02-07 05:36:20 CST user db1 [local] CSTINFO:
vacuuming "public.d"
#PostGreSQL: VACUUM 2014-02-07 05:36:20 CST user db1 [local] CSTINFO:
vacuuming "public.e"
#PostGreSQL: VACUUM 2014-02-07 05:36:27 CST user db1 [local] CSTINFO:
vacuuming "public.f"
#PostGreSQL: VACUUM 2014-02-07 05:36:27 CST user db1 [local] CSTINFO:
vacuuming "public.g"
#PostGreSQL: VACUUM 2014-02-07 05:36:27 CST user db1 [local] CSTINFO:
vacuuming "public.h"
#PostGreSQL: VACUUM 2014-02-07 05:36:27 CST user db1 [local] CSTINFO:
vacuuming "public.i"
#PostGreSQL: VACUUM 2014-02-07 05:36:36 CST user db1 [local] CSTINFO:
vacuuming "public.j"
#PostGreSQL: VACUUM 2014-02-07 05:36:37 CST user db1 [local] CSTINFO:
vacuuming "public.k"
#PostGreSQL: VACUUM 2014-02-07 05:36:37 CST user db1 [local] CSTINFO:
vacuuming "public.m"

--
View this message in context: http://postgresql.1045698.n5.nabble.com/table-db1-public-a-and-all-behind-db1-public-a-tables-did-not-do-analyzing-tp5792980.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

← Back to Topics