Re: vacuum taking an unusually long time

["Mason Hale" <masonhale@xxxxxxxxx>]

Here's some of the strace output:

select(0, NULL, NULL, NULL, {0, 10000}) = 0 (Timeout)

semop(9895945, 0x7fff1321db70, 1)       = 0

read(72, "\233\7\0\0H\207f2\1\0\1\0`\0\0 \0 \4 \0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "!\5\0\0\370\277\371\247\1\0\1\0\214\0\330\23\0 \4 \0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "}\4\0\0h]\333\217\1\0\1\0X\0\310\v\0 \4 \0\0\0\0\0\0\0\0X\235H\5"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "}\4\0\0(\260\333\217\1\0\1\0\\\0\200\v\0 \4 \0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "}\4\0\0p\305\333\217\1\0\1\0\\\0p\v\0 \4 \0\0\0\0\370\235\20\4\0\0\0\0"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "!\5\0\0\10\330\371\247\1\0\1\0P\0\240\10\0 \4 \0\0\0\0\0\0\0\0\360\234 \6"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "\233\7\0\0\340\212f2\1\0\1\0t\0(\35\0 \4 \0\0\0\0\0\0\0\0(\235\250\5"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "\24\10\0\0\230\333\372\207\1\0\1\0`\0\330\n\0 \4 \0\0\0\0X\220@\4\7\0\1\0"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

semop(9830407, 0x7fff1321db90, 1)       = 0

read(72, "\362\n\0\0H\316,r\1\0\1\0\204\0P\r\0 \4 _\17L\21x\235\20\5\5\0\1\0"..., 8192) = 8192

select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)

read(72, "\177\5\0\0\300\317A\276\1\0\1\0p\0\210\1\0 \4 \0\0\0\0\26\0\1\0\30\235\310\5"..., 8192) = 8192

All those "select(0, NULL, NULL, NULL, {0, 10000}) = 0 (Timeout)" commands sure look suspicious.

Any thoughts?

Mason

On Tue, Jul 15, 2008 at 10:06 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

"Mason Hale" <masonhale@xxxxxxxxx> writes:
> The longest running vacuum has been running more than 6 days at this point.

Is it actually *doing* anything, or is it just blocked waiting for
someone else?  strace or local equivalent would be the most definitive
way to check.

                       regards, tom lane