Postgres crash? could not write to log file: No space left on device

From: "Yuri Levinsky" <yuril(at)celltick(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Postgres crash? could not write to log file: No space left on device
Date: 2013-06-25 12:23:00
Message-ID: B72526FA2066E344AFD09734A487318103E9294E@falcon1.celltick.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dear All,

I have the following issue on Sun Solaris 10. PostgreSQL version is
9.2.3. The wall logging is minimal and no archiving. The DB restarted
several time, the box is up for last 23 days. The PostgreSQL
installation and files under /data/postgres that is half empty. Is it
some other destination that might cause the problem? Can I log the space
consumption and directory name where the problem is happening by some
debug level or trace setting?

PANIC: could not write to log file 81, segment 125 at offset 13959168,
length 1392640: No space left on device

LOG: process 10203 still waiting for ShareLock on transaction 3010915
after 1004.113 ms

STATEMENT: UPDATE tctuserinfo SET clickmiles = clickmiles + $1,
periodicalclickmiles = periodicalclickmiles + $2, active = $3,
activeupdatetime = $4, activationsetby = $5, smscid = $6, sdrtime = $7,
simvalue = simvalue + $8, totalsimval

ue = totalsimvalue + $9, firstclick = $10, lastclick = $11,
firstactivationtime = $12, cbchannel = $13, clickmilesupdatetime = $14,
ci = $15, lac = $16, bscid = $17, lastlocationupdatetime = $18,
subscriptiontype = $19, contentcategory =

$20, livechannels = $21, contextclicks = $22 WHERE phonenumber = $23

LOG: WAL writer process (PID 10476) was terminated by signal 6

LOG: terminating any other active server processes

FATAL: the database system is in recovery mode

But it looks OK:

dbnetapp:/vol/postgres

90G 44G 46G 49% /data/postgres

Is it possible that "heavy" queries consuming disk space (as temporary
space) and after the crash and recovery it becoming OK?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-06-25 13:46:47 Re: Postgres crash? could not write to log file: No space left on device
Previous Message Amit Kapila 2013-06-25 03:53:08 Re: BUG #8242: No way to debug "subquery must return only one column" error