急问个关于INFORMIX锁的问题

gzhu 发表于 2007-03-20 06:55

我这里是 informix 9.4HDR, AIX5.3的环境.
前几天online.log 中报

06:29:38dr_idx_send: can't lock 0x801985, iserrno 154

06:29:38
06:29:38IBM Informix Dynamic Server Version 9.40.FC7 Software Serial Number AAA#B000000

06:29:38Assert Warning: Cannot send index 'master_dms:"root".catalog#catalog_idx2' to Secondary
06:29:38 Who: Session(1020481, root@baly, 0, 7000000c64f0778)
Thread(1079183, dr_idx_send, 7000000b1733bb8, 6)
File: rshdr.c Line: 7310
06:29:38 Results: Index will be unusable on Secondary
06:29:38 Action: Drop and recreate on Primary
06:29:38Stack for thread: 1079183 dr_idx_send

现在想删除表catalog,
执行如下操作,
et isolation dirty read;
set lock mode to wait 20;
drop table catalog;

结果报如下错误,表删除不了,而且删除表中记录也不行.
242: Could not open database table (root.catalog).
154: ISAM error: Lock Timeout Expired

各位帮忙看看.

gzhu 发表于 2007-03-20 08:34

用onstat -u也什么都看不到

113:isam error: the file is locked
242:could not open database table(×××××)
用select partnum from systables where tabname = 'locked table' 可以找到partnum,转换到16进制后，用onstat -k |grep partnum后可以找出ADDRESS，
用onstat -u |grep ADDRESS 就什么都看不到，
但用onstat -x, 然后用onlog -n 可以看到这个进程是在DRSYNC.
不知怎样处理才好.

页: [1]

Chinaunix's Archiver

急问个关于INFORMIX锁的问题

用onstat -u也什么都看不到