[Info-ingres] A knotty problem with a checkpoint procedure.

[Martin Bowes]

What do you have connect_limit set to?

I ask because the only thing I can find regarding the error E_CL0654 mentions this as a possibility. Why it would affect just Solaris work Scheduler is a mystery.

Martin Bowes

-----Original Message-----
From: Oh-tis-so-frustrating [mailto:user1region1 at gmail.com] 
Sent: 20 June 2017 10:55
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] A knotty problem with a checkpoint procedure.

This in Support, but I wonder whether any other knowledgeable people have ideas that might give something (anything!), to work on. This is completely bonkers!


We run a checkpoint procedure (under Solaris 11 SPARC, Ingres 10.2) that calls "infodb", and this (infodb) fails under a particular circumstance.


I wrote a simple script to demonstrate the issue:

#! /bin/sh -x
. /etc/profile
truss -o /tmp/truss.test-infodb -wall -aef infodb ourdb infodb ourdb exit

Bear with me on the "truss" for the time being, please!


The above runs OK from an interactive shell, and also from cron, and it works under Solaris 10/Ingres 10.2 when run from our "work scheduler package" (Automic Dollar Universe), BUT when it is run from "work scheduler" in Solaris 11, a truly bizarre thing happens.


The infodb call works when run through truss. When run on its own, it errors!!!


Output is:

Tue Jun 13 17:16:58 2017 E_DM9268_OPEN_DB Error occurred opening a database.
Tue Jun 13 17:16:58 2017 E_DM1009_JSP_DBDB_OPEN  Error occurred trying to open IIDBDB database.


I guess it's trying to open the iidbdb to find out where "ourdb" is so it can look at ourdb's config.

In the errlog.log, we see:

sysa              ::[II_JSP            , 7846      ,  000000010118c200, dm0c.c:1224           ]: Tue Jun 13 17:16:58 2017 E_CL0654_DILRU_ALL_PINNED_ERR DIlru: All files in the LRU are pinned

sysa              ::[II_JSP            , 7846      ,  000000010118c200, dm0c.c:1224           ]: Tue Jun 13 17:16:58 2017 E_DM9004_BAD_FILE_OPEN        Disk file open error on database:iidbdb table:Not a table pathname:/fs1/ingres/data/default/iidbdb filename:aaaaaaaa.cnf

sysa              ::[II_JSP            , 7846      ,  000000010118c200, dm0c.c:1626           ]: Tue Jun 13 17:16:58 2017 E_DM923A_CONFIG_OPEN_ERROR    Error occurred opening configuration file (aaaaaaaa.cnf).
sysa              ::[II_JSP            , 7846      ,  000000010118c200, dm2d.c:5854           ]: Tue Jun 13 17:16:58 2017 E_DM9268_OPEN_DB      Error occurred opening a database.
sysa              ::[II_JSP            , 7846      ,  000000010118c200, dmfjsp.c:4303         ]: Tue Jun 13 17:16:58 2017 E_DM1009_JSP_DBDB_OPEN        Error occurred trying to open IIDBDB database.


Any ideas will be much appreciated, either in what's wrong, or what debugging to try.
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres