[Info-Ingres] ii_abfdependencies escalating to table level locks... any clues?

Gang,

On a system like this:

  OS:     Redhat ES 5.2 64-bit x86_64
  Ingres: II 9.1.1 (a64.lnx/103)NPTL
  Patch:  12819

I'm getting quite a few of the messages below on a database
with a fresh SYSMOD.

Table info is below as well.

Any ideas?

Thanks,

Mike Leo

SHAGGYDB          ::[52573             , 14514     ,  00002aaaacae4200]: Fri Jun 13 10:45:18 2008 E_DM9041_LK_ESCALATE_TABLE Maximum number of locks for transaction exceeded. Escalating to table-level lock on table ii_abfdependencies in database scooby_doo.


* help table ii_abfdependencies \g
Executing . . .

Name:                 ii_abfdependencies
Owner:                $ingres
Created:              2008-06-13 21:31:20     
Location:             cidreq_don
Type:                 system catalog
Version:              II9.0
Page size:            16384
Cache priority:       0
Alter table version:  0
Alter table totwidth: 125
Row width:            125
Number of rows:       37629
Storage structure:    btree
Compression:          none
Duplicate Rows:       not allowed
Number of pages:      531
Overflow data pages:  0
Journaling:           enabled
Base table for view:  no
Permissions:          yes
Integrities:          none
Optimizer statistics: none

Column Information:
                                                                   Key
Column Name                      Type       Length Nulls Defaults Seq
object_id                        integer         4   no      no     2
abfdef_applid                    integer         4  yes    null     1
abfdef_name                      varchar        32   no      no      
abfdef_owner                     varchar        32   no      no      
object_class                     integer         4   no      no      
abfdef_deptype                   integer         4   no      no      
abf_linkname                     varchar        32  yes    null      
abf_deporder                     integer         4  yes    null      

Secondary indexes:    none

I'm guessing you've modified from a 2k page size. That would result in you
now taking row level locks. I'm not sure if there's anything you can do
other than increasing the number of locks allowable in a lock list,
remodifying back to 2k pages or just living with it.

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....ngres/200806/1

Simon Lovell via DBMonster.com wrote:
> I'm guessing you've modified from a 2k page size. That would result in you
> now taking row level locks. I'm not sure if there's anything you can do
> other than increasing the number of locks allowable in a lock list,
> remodifying back to 2k pages or just living with it.
>
>
Good catch!

I didn't even LOOK at the page size.

That is interesting ....

Thanks,

Mike Leo