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:
[r...@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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
