7.8.01.15: increased usage of TEMP pages until DB_FULL

[Former Member]

While filling a system using TDMS and MaxDB 7.8 the database uses TEMP pages until all the database is filled up and stops working with DB_FULL. After a restart the data is free'ed again.

The data is inserted using pretty huge blocks but there are enough commits. Even if I stop the data transfer the temp pages stay there until the database is restarted.

Is this a known issue?

Markus

[holger_becker · Accepted solution]

Hi Markus,

did you activate the command monitor with 'diagnose monitor time' command or via transaction db50?

If yes, this might be a known issue with the new command monitor in MaxDB version 7.8 and higher.

The problem is a faulty change of the unit for command execution time from milli seconds to micro seconds.

This problem should be solved with version 7.8.1.16.

As a workaround you should multiply the threshold for command execution time (or runtime) by 1000000.

If this is not the case, I would be interested in the first rows of "select * from files order by treeleavessize desc"

Kind regards

Holger

[markus_doehr2 · Accepted solution]

Hi Holger,

> did you activate the command monitor with 'diagnose monitor time' command or via transaction db50?

No, this is switched off, it has been switched on before but since the restart it's off.

> This problem should be solved with version 7.8.1.16.

I'll try that! 7.8.01.17 is available.

> If this is not the case, I would be interested in the first rows of "select * from files order by treeleavessize desc"

(sorry for the bad formatting - table is too wide to be posted here as one row)

| FILEID             | SESSIONID        | ROOT             | RECOVERYMODE | FILESYSTEMID        | TYPE                 | PRIMARYFILEID                | FILESTATE            | ENT
RYCOUNT                     | TREEINDEXSIZE                  | TREELEAVESSIZE                 | LOBSIZE                        | CLUSTERED | DYNAMIC | PACKED | PACKEDNUMBERCOLUMN
  | PACKEDUNICODECOLUM   | CACHE | NOCACHE |
| ------------------ | ---------------- | ---------------- | ------------ | ------------------- | -------------------- | ---------------------------- | -------------------- | ---
--------------------------- | ------------------------------ | ------------------------------ | ------------------------------ | --------- | ------- | ------ | ------------------
- | -------------------- | ----- | ------- |
| 0x000000000001350E | ?                |         68499646 | PERMANENT    |                   0 | TABLE                | ?                            | OK                   |    
                   83545614 |                        1205352 |                       81933888 |                              0 | YES       | NO      | NO     | NO                
  | NO                   | NO    | NO      |
| 0x00000000000006BA | ?                |         26917579 | PERMANENT    |                   0 | TABLE                | ?                            | OK                   |    
                   71976726 |                         616792 |                       63415024 |                              0 | YES       | NO      | NO     | NO                
  | NO                   | NO    | NO      |
| 0x0000000000011A7B | ?                |         60949461 | PERMANENT    |                   0 | TABLE                | ?                            | OK                   |    
                   61135882 |                         761776 |                       62646616 |                              0 | YES       | NO      | NO     | NO                
  | NO                   | NO    | NO      |
| 0x00000000000137F4 | ?                |         80570833 | PERMANENT    |                   0 | TABLE                | ?                            | OK                   |    
                   39500046 |                         371912 |                       50520376 |                              0 | YES       | NO      | NO     | NO                
  | NO                   | NO    | NO      |
| 0x0000000000000B9A | ?                |         38395970 | PERMANENT    |                   0 | TABLE                | ?                            | OK                   |    
                   83377329 |                         964032 |                       45427984 |                              0 | YES       | NO      | NO     | NO                
  | NO                   | NO    | NO      |
| 0x00000000000159C6 | ?                |        101501151 | PERMANENT    |                   0 | SHORT COLUMN FILE    | 0x00000000000159C7           | OK                   |    
                   15207238 |                         206096 |                       43317544 |                              0 | NO        | ?       | ?      | ?                 
  | ?                    | NO    | NO      |
| 0x000000000000716F | ?                |         48381763 | PERMANENT    |                   0 | TABLE                | ?                            | OK                   |    
                   74493831 |                         320664 |                       41539144 |                              0 | YES       | NO      | NO     | NO                
  | NO                   | NO    | NO      |
| 0x00000000000005F5 | ?                |         17831169 | PERMANENT    |                   0 | INDEX                | 0x00000000000005F0           | OK                   |    
                   93798545 |                         342456 |                       36173936 |                              0 | NO        | ?       | ?      | 

Markus

Edited by: Markus Doehr on Aug 3, 2010 6:41 PM

[Former Member]

hello,

I have the same issue using libSQLBDC.dll (7.7.07.16) on a 7.7.07.16 database.

The issue appear when I execute a request with a blob and if the resultset is copied.

To free temporary data on server side, I have to call fist() or last() method on SQLDBC_ResultSet object before closing the resultSet.

resultSet->first()

resultSet->close()

Regards.

Yann.

[holger_becker]

Hi,

'<>' seems to have a special meaning in the wiki and got lost.

It have to be "recoverymode != 'PERMANENT'"

Kind regards

Holger

[holger_becker]

Hi Markus,

sorry I posted the wrong query.

I'm interested in "select * from files where recoverymode <> 'PERMANENT' order by treeleavessize desc" to see only the temporary files.

Kind regards

Holger

[markus_doehr2]

Hi Holger,

after having applied 7.8.01.17 the problem is gone.

Thank you for your help!

Markus