Tags: 3database, database, disk, error, execute, group, informix, isam, mysql, oracle, query, random, single, space, sql, subject, time

131: ISAM error: no free disk space

On Database » Informix

4,305 words with 2 Comments; publish: Fri, 23 May 2008 14:52:00 GMT; (250156.25, « »)

hi,

i have a random error (in title) when execute a single query on 3

database in same time.

i read all subject with this problem on the group but all the solution

write not resolve my problem.

i have 4 dbsapce (4Gb) temp online and used by the application, a root

dbspace with large free space (1Gb), the query plan of my query is

clean (index are ok)...

In fact, i have no problem when i execute this query on 1 or 2

databases only and when i execute it on my 3 database in the same time,

it is one time ok on the 3 database and one time non ok on only one

database (but never the same) ...

my query have 7 join on 4 tables (one 2 time and an other 3 time) and

no order, no group by...

somebody have an idea

ps : sorry for my english...

All Comments

Leave a comment...

  • 2 Comments
    • It seems rather clear that you are running out of disk space somewhere. I'd

      start by running the query and watching your root and temp space usage. Your

      sorts could also be spilling into the file system so you should watch the f

      ile system space as well, s

      pecifically the $DBTEMP location if it is set.

      DL Redden

      Lisha Lynn Mineral Cosmetics

      -- Original Message --

      From: dayv38 <david.chaumeil.informix.todaysummary.com.unilog.com>

      To: informix-list.informix.todaysummary.com.iiug.org

      Sent: Wednesday, March 22, 2006 9:25:57 AM

      Subject: 131: ISAM error: no free disk space

      hi,

      i have a random error (in title) when execute a single query on 3

      database in same time.

      i read all subject with this problem on the group but all the solution

      write not resolve my problem.

      i have 4 dbsapce (4Gb) temp online and used by the application, a root

      dbspace with large free space (1Gb), the query plan of my query is

      clean (index are ok)...

      In fact, i have no problem when i execute this query on 1 or 2

      databases only and when i execute it on my 3 database in the same time,

      it is one time ok on the 3 database and one time non ok on only one

      database (but never the same) ...

      my query have 7 join on 4 tables (one 2 time and an other 3 time) and

      no order, no group by...

      somebody have an idea

      ps : sorry for my english...

      ________________________________________

      _______

      Informix-list mailing list

      Informix-list.informix.todaysummary.com.iiug.org

      http://www.iiug.org/mailman/listinfo/informix-list

      #1; Fri, 23 May 2008 14:53:00 GMT
    • Would it be possible that you were reaching the maximum number of =

      extents -

      possibly in tempdbs. If the temp dbspace is being used by all the =

      queries

      at the same time it is possible that it will not use contiguous space. =

      From

      the query plan what is the estimated number of rows returned? and from =

      your

      select statement, how big are the rows? It is well-known that reaching =

      the

      maximum number of extents will give an out of disk space error.

      Regards

      malcolm

      --Original Message--

      From: informix-list-bounces.informix.todaysummary.com.iiug.org =

      [mailto:informix-list-bounces.informix.todaysummary.com.iiug.org]

      On Behalf Of dayv38

      Sent: 22 March 2006 15:26

      To: informix-list.informix.todaysummary.com.iiug.org

      Subject: 131: ISAM error: no free disk space

      hi,

      i have a random error (in title) when execute a single query on 3 =

      database

      in same time. i read all subject with this problem on the group but all =

      the

      solution write not resolve my problem. i have 4 dbsapce (4Gb) temp =

      online

      and used by the application, a root dbspace with large free space (1Gb), =

      the

      query plan of my query is clean (index are ok)... In fact, i have no =

      problem

      when i execute this query on 1 or 2 databases only and when i execute it =

      on

      my 3 database in the same time, it is one time ok on the 3 database and =

      one

      time non ok on only one database (but never the same) ...

      my query have 7 join on 4 tables (one 2 time and an other 3 time) and no

      order, no group by...

      somebody have an idea

      ps : sorry for my english...

      ________________________________________

      _______

      Informix-list mailing list

      Informix-list.informix.todaysummary.com.iiug.org =

      http://www.iiug.org/mailman/listinfo/informix-list

      #2; Fri, 23 May 2008 14:54:00 GMT