Hi All,

VW 2.5.1 (a64.lnx/162)NPTL + 16202

I know there is a limit of 1 open cursor per database connection...assumingthe cursor is connected to a vectorwise table.

Its looking to me that there is also an upper limit of 20 on the number of 'VW' cursors in the installation. As soon as I try a program which opens 21cursors I get all subsequent connections to the database stall in SCF witha select dbmsinfo('AUTOCOMMIT_STATE').

Top shows no activity on the machine worth talking about.

Anyone got any idea what may be happening?

Marty

On Aug 28, 2012, at 10:30 AM, Martin Bowes wrote:

You might possibly be running into the vectorwise transaction limit. Take a look
at the vectorwise.conf and see what the transaction limit is set to. If you try to
exceed that limit, sessions will stall in the x100-server and bad things happen.

Fixing this is on the list, but it will require some work to implement the transaction
limit on the Ingres server side rather than the vectorwise engine side. The Ingres
dbms server isn't written to expect that a start-of-transaction can stall.

Karl

Hi Karl,

Yes the max_transactions is set to 20.

I'll bump to 200 and see if that causes any grief....tomorrow.

Marty

-----Original Message-----
From: Karl Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: 28 August 2012 15:45
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Vectorwise total cursors limit?


On Aug 28, 2012, at 10:30 AM, Martin Bowes wrote:

You might possibly be running into the vectorwise transaction limit. Take a look at the vectorwise.conf and see what the transaction limit is set to. If you try to exceed that limit, sessions will stall in the x100-server and bad things happen.

Fixing this is on the list, but it will require some work to implement the transaction limit on the Ingres server side rather than the vectorwise engine side. The Ingres dbms server isn't written to expect that a start-of-transaction can stall.

Karl



_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres