Lock issue with replicated server
We are experiencing a strange issue regarding creating indexes on Informix
7.30 with replication enabled. We have three similar instances, all with a
copy of the same database. Our production database, where we are
experiencing the issue, is the only replicated database. I have noticed
that Userthread address 20479caa0 (Session ID 16 in the below example),
which is a Informix daemon thread that I do not see on my other servers, has
a table lock on 4003da (feb98bs_a). I have come to the assumption that this
is a replication issue.
Can anyone explain what is going on with this? Any information would be
appreciated.
The following is an example of our problem:
create index x1feb98bs on feb98bs_a (seg01,rl_code);
create index x2feb98bs on feb98bs_a (seg02,rl_code);# ^
# 242: Could not open database table (jburns.feb98bs_a).
# 113: ISAM error: the file is locked.
#
onstat -uk
Informix Dynamic Server Version 7.30.FC4 -- On-Line (Prim) -- Up 08:25:20
-- 293160 Kbytes
Userthreads
address flags sessid user tty wait tout
locks nreads nwrites
20479caa0 ---P--D 16 root - 0 0 1
0 6
2047adf90 L--PR-- 1478 root ttyp4 2001d9fc0 30 1
0 0
60 active, 128 total, 71 maximum concurrent
Locks
address wtlist owner lklist type
tblsnum rowid key#/bsiz
2001d9fc0 2047adf90 20479caa0 0 HDR+S
4003da 0 0
2001dab70 0 2047adf90 0 S
100002 203 0
46 active, 200000 total, 65536 hash buckets
onstat -g ses 1478
Informix Dynamic Server Version 7.30.FC4 -- On-Line (Prim) -- Up 08:25:49
-- 293160 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
1478 root ttyp4 19812 kmc9 1 73728 48208
tid name rstcb flags curstk status
3431 sqlexec 2047adf90 L--PR-- 2456 2047adf90sleeping(secs:
16)
Memory pools count 1
name class addr totalsize freesize #allocfrag
#freefrag
1478 V 20646a028 73728 25520 293 19
name free used name free used
overhead 0 176 scb 0 144
opentable 0 4536 filetable 0 1632
ru 0 280 log 0 2168
temprec 0 1696 keys 0 376
ralloc 0 4768 gentcb 0 13392
ostcb 0 2896 sqscb 0 10064
rdahead 0 416 hashfiletab 0 552
osenv 0 2656 sqtcb 0 1984
fragman 0 472
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
1478 CREATE INDEX kmc_prod CR Wait 30 0 0 7.30
Current SQL statement :
create index i1feb98bs_a on feb98bs_a (rl_code)
Last parsed SQL statement :
create index i1feb98bs_a on feb98bs_a (rl_code)
TIA,
John E. Porcello, Jr.
Corporate DBA
Kaman Corporation
jep-corp@kaman.com
My views and opinions may not reflect those of Kaman Corporation.