Re: Locking Problem
christian.winterhager@orbit.de schrieb:
} This seems to me very mysterious:
}
} There is 1 Table "tab1" with no indexes on it, but LOCK MODE ROW.
} After the following statements
}
} begin work;
} update tab1 set lname = "kkkk" where nr = 10
} update tab1 set lname = "kkkk" where nr = 9
}
} onstat -k produced this output:
}
} INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 00:06:20 -- 11312
} Kbytes
}
} Locks
} address wtlist owner l klist type
} tblsnum
} rowid key#/bsiz
} 1. 1008bd8c 0 104410e4 0 HDR+S 100002 206
} 0
} 2. 1008bdbc 0 104410e4 1008bd8c HDR+IX 200044 0
} 0
} 3. 1008bdec 0 104410e4 1008bdbc HDR+X 200044 10f
} 0
} 4. 1008be1c 0 104410e4 1008bdec HDR+X 200044 100 0
}
} 5. 1008be4c 0 104410e4 1008be1c HDR+X 200044 10e
} 0
} 6. 1008be7c 0 104410e4 1008be4c HDR+X 200044 201 0
}
} 7. 1008beac 0 104410e4 1008be7c HDR+X 200044 200
} 0
} 7 active, 8000 total, 8192 hash buckets
}
} But why did OnLine lock the PAGES 1 and 2 (see 4. and 7.)? The table
} has
} definitely
} lock mode row, so i cannot imagine, why online did so. Any ideas?
}
} Christian
}
} -------------------==== Posted via Deja News
} ====-----------------------
} http://www.dejanews.com/ Search, Read, Post to Usenet
After looking at this problem a time i dropped the database und
recreated it;
the problem vanished and i was content. I couldn't reproduce the
situation and the
output of onstat -k, so don't think about this temporary bug.
Christian