In my experience, anything that is accessing the file(s) in question - and not just Universe processes - can cause the error. If the file is opened by any other process, that would be sufficient for the exclusive use check to fail. So things to look out for extend beyond just Universe. This could include scheduled tasks/daemon processes, replication, including possibly built-in disk replication type accesses, backups, etc.
Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Tuesday, May 05, 2009 9:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV resize error Sometimes problems like this can arise if you run UniVerse foreground shells from root crontab on AIX (ans: donbt do it). "crontab -l" as root will give you the list of jobs - take a look (maybe). This can leave a footprint behind if it's historic - compare the number of attaches on the UniVerse shared memory segment with the number of attached processes that exist. The main shared memory segment attaches to itself, so the count of all "ace" segments should equal the attach count. "ps -efl"grep ace|wc -l". Another useful indicator (over time - a spot check doesn't help) is to look for dead processes accruing: "ps -efl"grep 0xffffffff" Lastly - is AIX paging? - the resolution process can result in random Unix processes being shot dead on the spot. Let us know if anything turns up. Regards JJ -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Rosenzweig Sent: 05 May 2009 01:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV resize error We've had similar issues with little luck. We've unlocked the inode of the over and data sections as well as all the index inodes and have had limited success. Sometimes it works, sometimes it doesn't. My suspicion is that there's a dead process that universe is not showing in LIST.READU EVERY or PORT.STATUS. When we've had only a few users on the system, we were once able to use ipcs -mop | grep ace to look for universe sessions(hex address for universe sessions start with ace) and found a pid in memory that wasn't actually showing up in ps. Once we removed that memory segment with: iprm -m xxxx, where xxxx is the shared memory id returned in the above command, we were able to resize the file. If you have a lot of users on at any one time this will be tough to reconcile. I suppose you could write a utility to compare pids returned in ipcs with pids returned with ps for universe sessions to see if one was missing. Lastly, if youbre accessing the database via rpc there could be an rpc connection that isn't letting go, but you'd see these in the ipcs results. I know this isn't a fix, but it may be helpful. P.S. Were on an AIX box running Universe 10.2.4. ---------------------------------------------------------------- Eric Rosenzweig Vice President, Information Systems Application Development and System Administration Petco Animal Supplies, Inc. 9125 Rehco Rd. San Diego, CA 92121 (858) 453-7845 x3125 (858) 638-2120 fax mailto:eri...@petco.com o Think before you print -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net Sent: Monday, May 04, 2009 2:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV resize error Not that this is any help but I had the same issue this weekend on uv10.2.7 on HPUX 11.11. No other users... /etc/fuser showed on processes... I assumed that our backup process had it but haven't had time to confirm. ----- Original Message ----- From: "John Hester" <jhes...@momtex.com> To: u2-users@listserver.u2ug.org Sent: Monday, May 4, 2009 4:01:39 PM GMT -06:00 US/Canada Central Subject: [U2] UV resize error I got an error message I've never seen before when attempting to resize a couple of dynamic files to static hashed files over the weekend: --- RESIZE error! Unable to gain exclusive use necessary to continue. File is currently in use by other processes. B Please try again at a later time when the file is not in use. --- I got the same message on each of 2 different dynamic files. B There were no other users on the system at the time, an no phantoms open those files. B LIST.READU EVERY showed only a single entry: Active Group Locks: B B B B B B B B B B B B B B B B B B Record Group Group Group Device.... Inode.... B Netnode Userno B Lmode G-Address. B Locks ...RD ...SH ...EX B B B B 2304 B 6972787 B B B B 0 B B 42 B 125 RD B B B B B 0 B B B 0 B B 35 0 B B 0 B The entry is still there, and PORT.STATUS did not list a UV process with user # 42 then or now. B I ran fuser at the OS level against the data and overflow pieces for each file, and came up empty. B This is UV 10.2.7 on RH ES 5. B Anyone ever seen this before? Thanks, John ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
