Re: Fwd: Re: Help with this exception...

Hello all,

Thanks for the info... I guess you were right. Given
below is the output of the df command on my machine:

Filesystem Size Used Avail Use% Mounted on
/dev/sda3 5.8G 3.0G 2.6G 55% /
/dev/sda2 286G 222G 50G 82% /apps
/dev/sda1 99M 57M 37M 61% /boot
none 16G 0 16G 0% /dev/shm

So, / is mounted on the partition having only 5.8G and
I cleared some of the files in /tmp, because of which
I could get around 2 G free space and the application
executed correctly without any exception :-)

Any way, thanks for looking at this problem...

-Venkatesh

--- Kevin Schmidt <kschmidt(at)techrunning(dot)com> wrote:

> What platform are you running on and on what
> drive/partition is
> Postgresql installed/running? It is likely you have
> a drive/partition
> that PostgreSQL is using for a temporary file that
> doesn't have the 65
> GB free disk space you are mentioning.
>
> Venkatesh Babu wrote:
>
> >--- Venkatesh Babu <venkatbabukr(at)yahoo(dot)com> wrote:
> >
> >
> >
> >>Date: Mon, 10 Jan 2005 06:34:10 -0800 (PST)
> >>From: Venkatesh Babu <venkatbabukr(at)yahoo(dot)com>
> >>Subject: Re: [JDBC] Help with this exception...
> >>To: pg(at)fastcrypt(dot)com
> >>
> >>Hi,
> >>
> >>Sorry, just wanted to confirm...
> >>
> >>Do you mean to say that 65 GB disk space is not
> >>enough?
> >>
> >>Thanks,
> >>Venkatesh
> >>
> >>--- Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
> >>
> >>
> >>
> >>>Hi,
> >>>
> >>>Apparently you do not have lots of space on the
> >>>
> >>>
> >>disk
> >>
> >>
> >>>that the server is on.
> >>>
> >>>Dave
> >>>
> >>>Venkatesh Babu wrote:
> >>>
> >>>
> >>>
> >>>>Hello,
> >>>>
> >>>>I am getting this particular exception while
> >>>>
> >>>>
> >>>testing
> >>>
> >>>
> >>>>our application on postgres (we recently
> migrated
> >>>>
> >>>>
> >>>our
> >>>
> >>>
> >>>>application(which was earlier running fine on
> >>>>
> >>>>
> >>>Oracle)
> >>>
> >>>
> >>>>to postgres)...
> >>>>
> >>>>org.postgresql.util.PSQLException: ERROR: could
> >>>>
> >>>>
> >>not
> >>
> >>
> >>>>write to hash-join temporary file: No space left
> >>>>
> >>>>
> >>on
> >>
> >>
> >>>>device
> >>>>
> >>>>However, I have lot of disk space free (around
> 65
> >>>>
> >>>>
> >>>GB
> >>>
> >>>
> >>>>of disk space is free)... The exception stack
> >>>>
> >>>>
> >>trace
> >>
> >>
> >>>is
> >>>
> >>>
> >>>>shown below:
> >>>>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.database.JDBCPreparable.executeQueryRaw(JDBCPreparable.java:300)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.database.JDBCPreparable.executeQuery(JDBCPreparable.java:286)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.query.OQLHeavyRecordset.init(OQLHeavyRecordset.java:68)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.query.OQLHeavyRecordset.<init>(OQLHeavyRecordset.java:45)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.local.Persister$7.act(Persister.java:733)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.local.Persister.transact(Persister.java:111)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.local.Persister.executeQuery(Persister.java:744)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.local.Persister.executeQuery(Persister.java:685)
> >>
> >>
> >>>> at
> >>>>
> >>>>
>
>>com.trilogy.sc.local.Persister.executeQuery(Persister.java:680)
> >>
> >>
> >>>> at
>
=== message truncated ===

__________________________________
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
http://my.yahoo.com