[Openroad-users] Execute mcompsrc3 hang

[Larry West]

Hi Kim,

Thanks for the information.  I'm still trying to solve the problem.

At 11:14 PM 2/15/2008, you wrote:
>Hi Larry,
>
>I have seen this as well.
>I have logged an issue 122652 on this. No confirmed bug number.
>
>We have seen this where we ran on Terminal 
>services clients on a 2003 server. We have only 
>seen it on one specific customer project which I find a bit strange.
>You can do this all by yourself. So it must have 
>something to do with the workbench having multiple db-connections open.
>We haven't been able to track down what exactly 
>we do differently in that project.
>I have found that the work around is to simply 
>kill the session that is blocking for the "Execute mcompsrc3".
>We haven't seen any side effects by doing this.
>If you don't do it like this, you will loose all your changes.
>
>Kim
>
>-----Oprindelig meddelelse-----
>Fra: openroad-users-bounces at peerlessit.com 
>[mailto:openroad-users-bounces at peerlessit.com] På vegne af Brigitte Duplenne
>Sendt: 15. februar 2008 20:05
>Til: 'International OpenROAD Users'
>Emne: Re: [Openroad-users] (no subject)
>
>Hi Larry,
>
>Do you mind opening an issue with our Ingres support and attach the
>printqry.log.
>Please let me know the issue number when it is done.
>
>Thank you,
>Brigitte
>
>OpenROAD support.
>
>
>-----Original Message-----
>From: openroad-users-bounces at peerlessit.com
>[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Larry West
>Sent: vendredi 15 février 2008 10:04
>To: International OpenROAD Users
>Subject: Re: [Openroad-users] (no subject)
>
>At the time of the hang, ipm shows a lock "LOCK(P" in the query execution
>facility "Execute mcompsrc3"
>
>At 08:11 AM 2/15/2008, you wrote:
> >Larry,
> >
> >  If its only happening on the remote vnodes (and not the local
> >database) then you really need to investigate what happens when you
> >click on delete/save etc. You'll have to use ipm on the remote server,
> >to see the status of your DBMS session and what it is waiting for. You
> >could also start to diagnose the issue from the OR2006 client using
> >
> >    ingsetenv II_EMBED_SET "printqry;qryfile c:\temp\iiprtqry.log"
> >
> >Have a look at the c:\temp\iiprtqry.log file when the hang occurs to
> >see what (if anything) it has sent to the server etc..
> >
> >You could also inject the display of the SQL thats being fired using
> >
> >    ingsetenv ING_PRINT "set printqry"
> >
> >You'll then see in the OpenRoad trace window all the SQL being fired..
> >if any :-)...
> >
> >This may give you some more pointers...
> >
> >Gary
> >
> >
> >
> >E-Mail Notice and disclaimer.
> >
> >This e-mail (including any attachment) is intended for the addressee
> >named above. As this e-mail may contain confidential or privileged
> >information, if you are not the named addressee, or the person
> >responsible for delivering the message to the named addressee, please
> >notify us immediately.
> >Every effort has been made to ensure that this e mail and any
> >attachment is free from viruses but we give no warranty to that effect
> >and can accept no responsibility for any losses resulting from infected
> >e-mail. The internet cannot guarantee the integrity of this message.
> >Indesit Company UK Ltd (and its subsidiaries) shall not be liable for
> >the message if modified. Please note that any views expressed in this
> >e-mail may be those of the author and do not necessarily reflect those
> >of this organisation.
> >Indesit Company UK Limited
> >Registered Office: Morley Way, Peterborough, PE2 9JB.
> >Company Number 106725. EEE Reg. Number WEE/DH0057TS
> >
> >________________________________________________________________
> >OpenROAD-Users mailing list
> >
> >You can maintain your subscription here:
> >http://www.peerlessit.com/mailman/listinfo/openroad-users
> >
> >To unsubscribe click on this link
> >mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
> >
> >To subscribe click on this link
> >mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
>
>Larry West
>Applied Physics Lab, University of Washington<br>
>(206) 543-1644<
>
>________________________________________________________________
>OpenROAD-Users mailing list
>
>You can maintain your subscription here:
>http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>To unsubscribe click on this link
>mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
>To subscribe click on this link
>mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
>
>________________________________________________________________
>OpenROAD-Users mailing list
>
>You can maintain your subscription here:
>http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>To unsubscribe click on this link
>mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
>To subscribe click on this link
>mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
>________________________________________________________________
>OpenROAD-Users mailing list
>
>You can maintain your subscription here:
>http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>To unsubscribe click on this link
>mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
>To subscribe click on this link
>mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe


Larry West
Applied Physics Lab, University of Washington<br>
(206) 543-1644<