Thread: Fwd: Re: Help with this exception...
--- 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
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 > > >
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