Re: query slow; strace output worrisome - Mailing list pgsql-performance

From Craig Ringer
Subject Re: query slow; strace output worrisome
Date
Msg-id 4BBA942F.4080100@postnewspapers.com.au
Whole thread Raw
In response to query slow; strace output worrisome  (Brian Cox <brian.cox@ca.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Brian Cox
Date:
Subject: query slow; strace output worrisome
Next
From: Brian Cox
Date:
Subject: Re: query slow; strace output worrisome