pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Craig Ringer <craig@postnewspapers.com.au>
To: Brian Cox <brian.cox@ca.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: query slow; strace output worrisome
Date: Tue, 06 Apr 2010 09:53:51 +0800
Message-ID: <4BBA942F.4080100@postnewspapers.com.au> (raw)
In-Reply-To: <4BBA87DC.1030205@ca.com>
References: <4BBA87DC.1030205@ca.com>

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

view thread (7+ messages)  latest in thread

Message-ID: <4BBA942F.4080100@postnewspapers.com.au>
Permalink:  ../4BBA942F.4080100@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4BBA942F.4080100@postnewspapers.com.au

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: craig@postnewspapers.com.au, brian.cox@ca.com
  Subject: Re: query slow; strace output worrisome
  In-Reply-To: <4BBA942F.4080100@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox