On 6/04/2010 9:01 AM, Brian Cox wrote:
The SELECT show below has been running for 30+mins and the strace output is alarming: [root@dione ~]# strace -p 10083 Process 10083 attached - interrupt to quit creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 creat(NULL, 037777777777) = 216203264 restart_syscall(<... resuming interrupted call ...>) = 8192 creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 creat(umovestr: Input/output error 0x2, 037777777777) = 1025220608 however, I can find no indication of I/O errors in the postgres log. Anyone have any idea what's going on here?
Anything in `dmesg' (command) or /var/log/syslog ? -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
