Thread: pgsql.broken.csc

pgsql.broken.csc

From
M Rather
Date:
Hello,

one of our clients is using pgsql 8.1, and recently the site crashed due
to lack of hard disk space. Upon inspection a file was found :

pgsql.broken.csc  (size: > 51 GB)

I cannot find any reference to this file on pgsql site or on google.

What is this file? Is it related to PGSQL? What caused it to grow to
this size?

Any help will be appreciated.

Thanks

Environment:
OS: Redhat Linux 4
DB: pgsql 8.1
AppSrvr: Tomat 5.5.9

Re: pgsql.broken.csc

From
Tom Lane
Date:
M Rather <mrather@definedlogic.com> writes:
> one of our clients is using pgsql 8.1, and recently the site crashed due
> to lack of hard disk space. Upon inspection a file was found :

> pgsql.broken.csc  (size: > 51 GB)

> I cannot find any reference to this file on pgsql site or on google.

> What is this file? Is it related to PGSQL? What caused it to grow to
> this size?

PG would never make a file named that.

Did you try looking into the file to see what it contains?

            regards, tom lane

Re: pgsql.broken.csc

From
M Rather
Date:
Tom Lane wrote: <blockquote cite="mid:24470.1193762916@sss.pgh.pa.us" type="cite"><pre wrap="">M Rather <a
class="moz-txt-link-rfc2396E"href="mailto:mrather@definedlogic.com"><mrather@definedlogic.com></a> writes:
</pre><blockquotetype="cite"><pre wrap="">one of our clients is using pgsql 8.1, and recently the site crashed due 
 
to lack of hard disk space. Upon inspection a file was found :   </pre></blockquote><pre wrap=""> </pre><blockquote
type="cite"><prewrap="">pgsql.broken.csc  (size: > 51 GB)   </pre></blockquote><pre wrap=""> </pre><blockquote
type="cite"><prewrap="">I cannot find any reference to this file on pgsql site or on google.   </pre></blockquote><pre
wrap=""></pre><blockquote type="cite"><pre wrap="">What is this file? Is it related to PGSQL? What caused it to grow to

this size?   </pre></blockquote><pre wrap="">
PG would never make a file named that.

Did you try looking into the file to see what it contains?
        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
 </pre></blockquote> I should have mentioned this in my original email.<br /> Unfortunately the file was deleted by the
hostingservice (our client had OK'd it) to bring the site backup immediately.<br /><br /> I may have to see if some
otherprocess (valid or malicious) may have created the file. <br /><br /> Thanks and Regards<br /> -MRather<br />