Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Your table is locked.
Before starting cdr check, try to:
$ export IFX_DIRTY_WAIT=600and then try to execute cdr check again.
If it does repeat, there seems to be any session/application that is locking the table (maybe a defunct process?)
Hope it helps.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
Date: Wed, 8 May 2013 12:05:25 -0600
Subject: ER Problem
From: lgustin@utah.gov
To: informix-list@iiug.org
IDS 11.7 FC7Linux
Im getting this error when I try to run cdr chek on a single replicate.
cdr check repl -m g_psprod1sl -r abc_checks_incident_status -a
Error returned from getNumRows: select count(*) from 'informix'.incident_statusSQLCODE -252 ISAM -154
Error Details: 252: Cannot get system information for table.
154: ISAM error: Lock Timeout Expired
Current Connection:conn4, Database:@g_psprod1sl command failed -- SQL failure (195)
I have stopped and restarted ER , and deleted and recreated the replicate. Any clues?
Thanks!Laurie
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.