The locking problem you have described has long been a bug with isql.
In programming it's fine but within ISQL it takes a shared-lock even
although you may have readlock=nolock...


Best Regards

Graham T Newlands
IT Consultant
Fujitsu Australia

Address:
Lvl 20, 222 Exhibition St, Melbourne, VIC 3000
Tel:
+61 3 9657 8705
Mobile:
0404 003 104
Fax:
+61 3 9664 6570
Email:
graham.newlands (AT) au (DOT) fujitsu.com
Web site:
http://au.fujitsu.com




-----Original Message-----
From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of
info-ingres-request (AT) cariboulake (DOT) com
Sent: Wednesday, 27 July 2005 3:00 AM
To: info-ingres (AT) cariboulake (DOT) com
Subject: Info-ingres digest, Vol 1 #283 - 7 msgs

Send Info-ingres mailing list submissions to
info-ingres (AT) cariboulake (DOT) com

To subscribe or unsubscribe via the World Wide Web, visit
http://mailman.cariboulake.com/mailm...py/info-ingres
or, via email, send a message with subject or body 'help' to
info-ingres-request (AT) cariboulake (DOT) com

You can reach the person managing the list at
info-ingres-admin (AT) cariboulake (DOT) com

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Info-ingres digest..."


Today's Topics:

1. Strange locking in Ingres 6.4/06 (Norman Woo)
2. RE: Strange locking in Ingres 6.4/06 (Peter Gale)
3. Openroad curframe.confirmpopup on MS XP crashes application
(paustin (AT) redflex (DOT) com.au)
4. Why cant I run infodb? (martin.bowes (AT) ctsu (DOT) ox.ac.uk)
5. Re: Why cant I run infodb? (Paul Mason)
6. Re: Why cant I run infodb? (martin.bowes (AT) ctsu (DOT) ox.ac.uk)
7. Re: Why cant I run infodb? (Paul Mason)

--__--__--

Message: 1
From: Norman Woo <nwoo (AT) videotron (DOT) ca>
Date: Mon, 25 Jul 2005 18:12:46 -0400
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Strange locking in Ingres 6.4/06

Hi Folks

Yes, I'm still using Ingres 6.4/06 on HP UX 10.20.

I have encountered a strange locking issue where a table is locked by
another process. Other users acessing this table eventually timeout and
their transactions rolled back.

In ISQL, my query against this table times out. Also setting the
"lockmode session where readlock = nolock" still does not allow me to
view the table. I thought we were able to access the table under all
condition when "readlock = nolock". Under IPM, everything looks fine.
No locking problem reported by IPM.

This is a single row, single column table containing the "last"
counter that generates next "unique" key to use. The system has been
running for the last 15 years with no problems and just lately we have
started to see this locking problem.

Thanks

--__--__--

Message: 2
Reply-To: <PGale (AT) comp-soln (DOT) co.uk>
From: "Peter Gale" <PGale (AT) comp-soln (DOT) co.uk>
To: "'Norman Woo'" <nwoo (AT) videotron (DOT) ca>,
"Info Ingres" <info-ingres (AT) cariboulake (DOT) com>
Subject: RE: [Info-ingres] Strange locking in Ingres 6.4/06
Date: Tue, 26 Jul 2005 06:37:41 +0100

Hi Norman,

I am not sure why you cannot see your blocked lock situation in IPM but
one possible reason for the problem is that another process is MODIFYing
the table. The lock taken when this happens cannot be bypassed using
"set lockmode session where readlock = nolock". However this seems
unlikely because this is such a small table the MODIFY would take almost
no time at all, unless of course it is part of a much larger
transaction.

Next time this happens go into IPM and make sure you turn on all the
options. Go into the options screen and set the following items to 'y'

Display null resources?
Display all resource types?
Display system locklists?
Display inactive transactions?
Display internal sessions?

If it still doesn't show up run "lockstat" and "logstat" and for each
DBMS server start an iimonitor session and do 'format all'. From that it
will be possible to identify the offending lock and transaction. Feel
free to send me the output and I will take a look.

Peter Gale
Comprehensive Solutions (US)
Comprehensive Solutions International (UK)
T: +44 (0)1398 341777 M: +44 (0)7831 513181
PGale (AT) Comp-Soln (DOT) co.uk www.Comp-Soln.co.uk
-----Original Message-----
From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of Norman Woo
Sent: 25 July 2005 23:13
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Strange locking in Ingres 6.4/06

Hi Folks

Yes, I'm still using Ingres 6.4/06 on HP UX 10.20.

I have encountered a strange locking issue where a table is locked by
another process. Other users acessing this table eventually timeout and
their transactions rolled back.

In ISQL, my query against this table times out. Also setting the
"lockmode session where readlock = nolock" still does not allow me to
view the table. I thought we were able to access the table under all
condition when "readlock = nolock". Under IPM, everything looks fine.
No locking problem reported by IPM.

This is a single row, single column table containing the "last"
counter that generates next "unique" key to use. The system has been
running for the last 15 years with no problems and just lately we have
started to see this locking problem.

Thanks
_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres


--__--__--

Message: 3
From: paustin (AT) redflex (DOT) com.au
Date: 25 Jul 2005 23:18:46 -0700
Organization: http://groups.google.com
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Openroad curframe.confirmpopup on MS XP crashes
application

I have installed ingres client and Openroad 4.0 software for Microsoft
Windows (Intel) from the CD Ingres II Enterprise Edition (the same CD we
used to install on NT) on a Microsoft Widows XP Professional version
2002 Service Pack 2 PC.

The application works until it executes any 'curframe.ConfirmPopup'
statement. It then exits with no messages and nothing in the log.

I have stepped through the code in the Openroad work bench and any
curframe.confirmpopup causes it to exit and close the work bench.


--__--__--

Message: 4
From: martin.bowes (AT) ctsu (DOT) ox.ac.uk
To: info-ingres (AT) cariboulake (DOT) com
Date: Tue, 26 Jul 2005 10:00:18 +0100
Subject: [Info-ingres] Why cant I run infodb?

Hi Dudes,

Having recently upgraded a Linux box to II2.6 I've just found
that only ingres can run the infodb command. Anybody else gets greeted
with:

infodb ldb1
Tue Jul 26 09:53:03 2005 E_DM00AB_CANT_MAP_SHARED_MEM
Could not map the server's shared memory. Please check errlog.log for
more details.
Tue Jul 26 09:53:03 2005 E_DM1051_JSP_NO_INSTALL The
installation is not currently running. Run INGSTART then try again.
Tue Jul 26 09:53:03 2005 E_DM1001_JSP_INIT An error occurred
initializing the journal support program. Make sure program is installed
and/or you are running with proper privilege.

Ingres is up and running, no messages get printed into the errlog.
I've checked that iimerge has a setuid bit.
However, when a non ingres users does ipcs they cant list the ingres
shared memory segments.

Anyone got any ideas?

Marty
--
Random Duckman Quote #100:
Cornfed: That's either 800 tones of raging, destructive, flood water or
Rush
Limbaugh on roller blades.
Aunt Bernice: Oh will you stop with your dry little pig jokes.
Cornfed: Everyone thinks your butt is huge.


--__--__--

Message: 5
Date: Tue, 26 Jul 2005 10:22:06 +0100
From: Paul Mason <latepaul (AT) gmail (DOT) com>
Reply-To: Paul Mason <latepaul (AT) gmail (DOT) com>
To: "martin.bowes (AT) ctsu (DOT) ox.ac.uk" <martin.bowes (AT) ctsu (DOT) ox.ac.uk>
Subject: Re: [Info-ingres] Why cant I run infodb?
Cc: info-ingres (AT) cariboulake (DOT) com

On 7/26/05, martin.bowes (AT) ctsu (DOT) ox.ac.uk <martin.bowes (AT) ctsu (DOT) ox.ac.uk>
wrote:
Has iimerge got the suid bit set? Try running iilink (with ingres
shutdown) to recreate the links and permissions.


--__--__--

Message: 6
From: martin.bowes (AT) ctsu (DOT) ox.ac.uk
To: Paul Mason <latepaul (AT) gmail (DOT) com>
Date: Tue, 26 Jul 2005 11:21:38 +0100
Subject: Re: [Info-ingres] Why cant I run infodb?
Cc: info-ingres (AT) cariboulake (DOT) com

Hi Paul,


Yep. I'd found a few things on the Tech base about this Error
number which had suggested this might be the problem. So it was one
thing I'd checked.

ls -l `which iimerge`
-rwsr-xr-x 1 ingres root 19639 Feb 11 2004
/user/ingres/bin/iimerge

Try running iilink (with ingres
Dont have any udadts so I've never need to run this. Given the
iimerge has the setuid bit set - I'm not game to run iilink.

I'm thinking it may have more to do with the OS. As the non
ingres user on this Linux box I do an ipcs and see nothing. On a tru64
box the non ingres user can at least see the ingres shared memory
resources. Permissions on the resources are the same. 600's and 700s

Marty
--
Random Titus Quote #27:
'Man will always be quick to anger, as he'll sell his soul for revenge.'
Hereclitis, 500BC.

'My Dad's Pubes are toast!'
Titus, 1998.


--__--__--

Message: 7
Date: Tue, 26 Jul 2005 13:17:40 +0100
From: Paul Mason <latepaul (AT) gmail (DOT) com>
Reply-To: Paul Mason <latepaul (AT) gmail (DOT) com>
To: info-ingres (AT) cariboulake (DOT) com
Subject: Re: [Info-ingres] Why cant I run infodb?

On 7/26/05, martin.bowes (AT) ctsu (DOT) ox.ac.uk <martin.bowes (AT) ctsu (DOT) ox.ac.uk>
wrote:
It's perfectly safe. You can back up iimerge if you don't believe me.
The reason I suggested it is that I've come across references to
needing to re-link iimerge on Linux:

"On Linux iimerge is linked dynamically, which means that for security
reasons LD_LIBRARY_PATH is not considered. The problem must be solved
by running iilink (which allows the dynamic linker to pick up the
libraries from $II_SYSTEM/ingres/lib."

True, but AFAIK, that's normal for Linux.

--
Paul Mason



--__--__--

_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres


End of Info-ingres Digest


This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.

If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email unsubscribe (AT) au (DOT) fujitsu.com

"Newlands, Graham" <Graham.Newlands (AT) au (DOT) fujitsu.com> wrote

Not true. isql doesn't and never has behaved like that. The SET LOCKMODE
statement is executed by the server process, but it has no idea which
application sent it.

Roy