Search Postgresql Archives

Re: Vacuumdb Errors --Any ideas?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Keary Suska <hierophant@pcisys.net> writes:
> I received the following errors from an automated full vacuum:
> vacuumdb: vacuuming of database "milemgr" failed: ERROR:  tuple concurrently
> updated

Hm, could you have had more than one of these beasts running?  It's
possible to get such an error from concurrent ANALYZE operations on
the same table.  (This happens if the second ANALYZE tries to update the
pg_statistic rows before the first one is able to commit.  It's a pretty
narrow window, and there's no real harm involved, so we haven't tried
hard to get rid of the race condition.)

> ERROR: Vacuum command failed: Inappropriate ioctl for device

I have no idea where that came from --- I can't find "vacuum command
failed" anywhere in current sources.  I suspect the second part of the
message just comes from someone printing strerror(errno) in a context
where errno isn't meaningful.

Bottom line: don't panic.  If you can find where the second message came
from, though, I'd like to know.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux