Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd7318d4

Browse files
committed
Log a better message when canceling autovacuum.
The old message was at DEBUG2, so typically it didn't show up in thelog at all. As a result, in most cases where autovacuum was canceled,the only information that was logged was the table being vacuumed,with no indication as to what problem caused the cancel. Crank upthe level to LOG and add some more details to assist with debugging.Back-patch all the way, per discussion on pgsql-hackers.
1 parent4da8fc0 commitd7318d4

File tree

1 file changed

+21
-4
lines changed
  • src/backend/storage/lmgr

1 file changed

+21
-4
lines changed

‎src/backend/storage/lmgr/proc.c

Lines changed: 21 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1086,12 +1086,29 @@ ProcSleep(LOCALLOCK *locallock, LockMethod lockMethodTable)
10861086
!(autovac_pgxact->vacuumFlags&PROC_VACUUM_FOR_WRAPAROUND))
10871087
{
10881088
intpid=autovac->pid;
1089+
StringInfoDatalocktagbuf;
1090+
StringInfoDatalogbuf;/* errdetail for server log */
1091+
1092+
initStringInfo(&locktagbuf);
1093+
initStringInfo(&logbuf);
1094+
DescribeLockTag(&locktagbuf,&lock->tag);
1095+
appendStringInfo(&logbuf,
1096+
_("Process %d waits for %s on %s"),
1097+
MyProcPid,
1098+
GetLockmodeName(lock->tag.locktag_lockmethodid,
1099+
lockmode),
1100+
locktagbuf.data);
1101+
1102+
/* release lock as quickly as possible */
1103+
LWLockRelease(ProcArrayLock);
10891104

1090-
elog(DEBUG2,"sending cancel to blocking autovacuum PID %d",
1091-
pid);
1105+
ereport(LOG,
1106+
(errmsg("sending cancel to blocking autovacuum PID %d",
1107+
pid),
1108+
errdetail_log("%s",logbuf.data)));
10921109

1093-
/* don't hold the lock across the kill() syscall */
1094-
LWLockRelease(ProcArrayLock);
1110+
pfree(logbuf.data);
1111+
pfree(locktagbuf.data);
10951112

10961113
/* send the autovacuum worker Back to Old Kent Road */
10971114
if (kill(pid,SIGINT)<0)

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp