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

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
>>>>
>>>>
>>com.trilogy.sc.local.SCLocalSession.executeQuery(SCLocalSession.java:245)
>>
>>
>>>>       at
>>>>com.trilogy.sc.SCQuery.execute(SCQuery.java:57)
>>>>
>>>>Does this error have anything to do with the
>>>>
>>>>
>>query
>>
>>
>>>>that our application executes, in which case I
>>>>
>>>>
>>need
>>
>>
>>>to
>>>
>>>
>>>>modify the particular query... In the current
>>>>situation I cannot give details about the SQL
>>>>
>>>>
>>query
>>
>>
>>>>that is getting executed because the query in our
>>>>application is written in a custom language OQL
>>>>
>>>>
>>and
>>
>>
>>>>the OQL parser is mapping the query to SQL query
>>>>statement... Hence, changing query may be bit of
>>>>difficult task. So, may I know as to whether we
>>>>
>>>>
>>can
>>
>>
>>>>get rid of this exception by changing certain
>>>>
>>>>
>>>postgres
>>>
>>>
>>>>settings?
>>>>
>>>>Thank you,
>>>>Venkatesh
>>>>
>>>>
>>>>
>>>>__________________________________
>>>>Do you Yahoo!?
>>>>The all-new My Yahoo! - What will yours do?
>>>>http://my.yahoo.com
>>>>
>>>>---------------------------(end of
>>>>
>>>>
>>>broadcast)---------------------------
>>>
>>>
>>>>TIP 9: the planner will ignore your desire to
>>>>
>>>>
>>>choose an index scan if your
>>>
>>>
>>>>     joining column's datatypes do not match
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>--
>>>Dave Cramer
>>>http://www.postgresintl.com
>>>519 939 0336
>>>ICQ#14675561
>>>
>>>
>>>
>>>
>>__________________________________________________
>>Do You Yahoo!?
>>Tired of spam?  Yahoo! Mail has the best spam
>>protection around
>>http://mail.yahoo.com
>>
>>
>>
>
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Mail - now with 250MB free storage. Learn more.
>http://info.mail.yahoo.com/mail_250
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>
>
>