Fwd: Re: Help with this exception...

--- 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
> >
>
>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