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@techrunning.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@yahoo.com> wrote:
> >
> >
> >
> >>Date: Mon, 10 Jan 2005 06:34:10 -0800 (PST)
> >>From: Venkatesh Babu <venkatbabukr@yahoo.com>
> >>Subject: Re: [JDBC] Help with this exception...
> >>To: pg@fastcrypt.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@fastcrypt.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