Re: IngresII 2.6+sp2 on tru64 = mutex

Hej John,

Can you provide ls-la on $II_SYSTEM/ingres/bin catalog

Regards
Vahan

"John Pan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi All
>
> once again I am in need of the vast experience out there as I have
> exhusted all at my end.
>
> I am upgrading (read re-installing) my 2.5 to 2.6:
> OS is tru64 5.1.
> IngresII 2.6/0201 then applying SP2.
>
> I have unloaded the databse in binary and destroyed EVERYTHING.
> Re-installed ingres as if for the first time.
> Apply SP2.
>
> Bog standard installation.
> syscheck tell me all is ok.
> Only changes to config.dat are 4K pages ON, max_tuple_length set to 0,
> log writer 4 to 20, event limit 80 to 160 and buffer count to 100.
>
> start the reload.ing
> when finished no errors: do a optimizedb -zk -zc
> process doing the optimzedb goes into mutex
>
> Following on from this (start all this last tuesday) I have rebuilt
> installation several times and can now get the mutexes when doing
>
> sysmods, destroydb, createdb - also running a script that
> deletes/updates a couple of tables.
>
> Most of the mutexes I have seen seem to involve only the process, but
> I have seem on a number of occassions all the log writer threads in a
> mutex state as well as the CP thread.
>
> I have tried the system with mor than one dbms and shared cache - no
> help.
> CA have double checks and have several diag pack I put together and
> this should be at level 2 by tonight - however I thought someone out
> there might have already struck this problem.
>
> I have also seen the mutex on the standard 2.6/0201 install although I
> have spent all my diag gathering on the SP2 version.
>
> show mutex sample:
> Session 0000000140E94200:15791616 (ingres                  ) cs_state:
> CS_COMPUTABLE cs_mask:
> IIMONITOR> Mutex at 0000000000800B08: Name: LG LGD mutex, is currently
> unowned
>     Shared:        0 Collisions:        0 Hwm:    0
>       Excl:     2083 Collisions:        7
>      Spins:   179689     Yields:       73
> IIMONITOR> Mutex at 0000000000800B08: Name: LG LGD mutex, is currently
> unowned
>     Shared:        0 Collisions:        0 Hwm:    0
>       Excl:     2083 Collisions:        7
>      Spins:   179689     Yields:       73
>
>
> Any pointers??
>
> thanks
> john
>
> ps - OS kernal has enough resources to run two ingres installations
> which this machine normally does. However during these tests Only the
> installation I am having problems with is running.