Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
[Info-Ingres] iiuser table does not exist
33 views
Skip to first unread message
Martin Bowes
Apr 2, 2013, 6:16:06 AM4/2/13
to info-...@kettleriverconsulting.com
Hi All.
II 10.0.0 (a64.lnx/132)NPTL + p14200.
I have a system which is reporting E_US000A iiuser table does not exist. For example the error is listed 14 times in March.
I suspect that it is associated with another session getting a failure on a long object. Before the error we see a short flurry of messages like:
E_DM9328_DM2T_NOFREE_TCB Cannot free resources, no TCBs to reclaim.
E_DM9C8B_DM2T_TBL_INFO An error occurred while attempting to build the Table Control Block for table (33,0) in database miketest.
E_DM9C89_DM2T_BUILD_TCB An error occurred while building a Table Control Block for a table.
E_DM9C8A_DM2T_FIX_TCB An error occurred while trying to locate and/or build the Table Control Block for a table.
I've seen Knowledge Doc 415443, but that relates to Ingres2.6 and the suggested workaround of bumping dmf_hash_size is not that useful given that the installation has no dmf_hash_size parameter in its config.dat.
The installation has dmf_tcb_limit: 12000.
Suggestions?
Martin Bowes
-----Original Message-----
From: Peter Harding [mailto:Peter....@ctsu.ox.ac.uk]
Sent: 02 April 2013 02:41
To: Martin Bowes
Subject: Re: RUBBLE
Had 5 of these this year, from a wing job that runs every minute. Still, shouldn't be so. Always around 7am.
Probably not terribly urgent!!
On Mon, 2013-04-01 at 07:01 +0100, RUBBLE wrote:
> IIAPI_ST_FAILURE: API_GE_ERROR: 50000: ge_errorCode 10 : iiuser table does not exist.
>
> Have a nice day
II 10.0.0 (a64.lnx/132)NPTL + p14200.
I have a system which is reporting E_US000A iiuser table does not exist. For example the error is listed 14 times in March.
I suspect that it is associated with another session getting a failure on a long object. Before the error we see a short flurry of messages like:
E_DM9328_DM2T_NOFREE_TCB Cannot free resources, no TCBs to reclaim.
E_DM9C8B_DM2T_TBL_INFO An error occurred while attempting to build the Table Control Block for table (33,0) in database miketest.
E_DM9C89_DM2T_BUILD_TCB An error occurred while building a Table Control Block for a table.
E_DM9C8A_DM2T_FIX_TCB An error occurred while trying to locate and/or build the Table Control Block for a table.
I've seen Knowledge Doc 415443, but that relates to Ingres2.6 and the suggested workaround of bumping dmf_hash_size is not that useful given that the installation has no dmf_hash_size parameter in its config.dat.
The installation has dmf_tcb_limit: 12000.
Suggestions?
Martin Bowes
-----Original Message-----
From: Peter Harding [mailto:Peter....@ctsu.ox.ac.uk]
Sent: 02 April 2013 02:41
To: Martin Bowes
Subject: Re: RUBBLE
Had 5 of these this year, from a wing job that runs every minute. Still, shouldn't be so. Always around 7am.
Probably not terribly urgent!!
On Mon, 2013-04-01 at 07:01 +0100, RUBBLE wrote:
> IIAPI_ST_FAILURE: API_GE_ERROR: 50000: ge_errorCode 10 : iiuser table does not exist.
>
> Have a nice day
Karl Schendel
Apr 2, 2013, 9:14:35 AM4/2/13
to Ingres and related product discussion forum
On Apr 2, 2013, at 6:16 AM, Martin Bowes wrote:
> Hi All.
>
> II 10.0.0 (a64.lnx/132)NPTL + p14200.
>
> I have a system which is reporting E_US000A iiuser table does not exist. For example the error is listed 14 times in March.
>
> I suspect that it is associated with another session getting a failure on a long object. Before the error we see a short flurry of messages like:
> E_DM9328_DM2T_NOFREE_TCB Cannot free resources, no TCBs to reclaim.
> ...
> Hi All.
>
> II 10.0.0 (a64.lnx/132)NPTL + p14200.
>
> I have a system which is reporting E_US000A iiuser table does not exist. For example the error is listed 14 times in March.
>
> I suspect that it is associated with another session getting a failure on a long object. Before the error we see a short flurry of messages like:
> E_DM9328_DM2T_NOFREE_TCB Cannot free resources, no TCBs to reclaim.
>
> The installation has dmf_tcb_limit: 12000.
Try raising tcb_limit to say 20000.
> The installation has dmf_tcb_limit: 12000.
Karl
0 new messages