Re: Power problem leaves transaction lock hanging

In article <4de2fp$agi@redstone.interpath.net> mdl@interpath.com "Mike Lemon" writes: > Well it had to happen. Due to some construction in the office, a user's PC > running > a 4GL program on my AIX server lost power and the program was terminated. > Unfortunately, this didn't close the transaction she was in properly, and the > document she was modifying is still locked. I checked the engine > (Online 5.02),> and there are no parentless sqlturbo processes to > terminate with tbmode. But there may have been a parent of an 'sqlturbo' process which was incorrectly attached to a PPID of 1 instead! If so, killing that process, *NOT* the 'sqlturbo', may well have sorted the problem! This sounds like a known bug which Jonathan Leffler sent me the number for a couple of weeks back which I posted on, fixed in (he said!) 4.14/6.02 whereby the front-end goes rogue instead of dying if the terminal is turned of - a problem we have found when using PCs over networks! I'm sure an OnLine person will mail how to resolve your current situation WRT locks! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================