After upgrading to QV11 SR2 system is unstable

[andy]

Hi folks,

After upgrading to QV11 SR2 last week we have been forced to performed restarts every day. Qlikview server is just not responding, today it showed "No server".

The installation has a separate machine for the QVS which also holds an IIS.

Today the memory usage was very low (4-9 GB) when the server had hanged before it have reached 25 GB.

175 users/ 50 applications

Nothing special is written in the logs. The only thing I see is when it happens is this: qvpx: Exception while handling request

and the 2nd time (when the "No server" message appeared) it hang today it said first

14:11 qvpx: Exception while handling request

and then

14:42 Restart: Server aborted trying to recover by restart. Reason for restart: Internal inconsistency, type D, detected.

Any hints?

Just don't want the customer to force me to reinstall QV9 again but they are discussing it.

/Andy

[#2]

I see... I have done something similar. I added an additional step to what you describe, and set up a Windows Task to trigger running the batch script. The task is triggered by a "Custom event filter" and the XML for the filter looks something like this:

<QueryList>

  <Query Id="0" Path="Application">

    <Select Path="Application">

      *[System[(Level=2) and (EventID=300)]]

      and

      *[EventData[Data and (Data='qvpx: Exception while handling request')]]

    </Select>

  </Query>

</QueryList>

The QVS is automatically restarted when the ERROR event occurs.

[#3]

Andy, which server did you guys buy? I am considering a dual socket E5-2690  with 256 GB RAM

[andy]

Hi,

I think that will be fine, same processor as we got two of and things have

been very stable since then.

Got this recommendation:

Intel Xeon E5-2650, Intel Xeon E5-2690 or the older Intel X5690.

Bios settings:

Variable. Setting. How to configure

Hyper threading. Disable. System BIOS setting

Node Interleaving. Enable. Advanced BIOS setting Hardware

pre-fetch. Disable. Advanced BIOS setting

HP Power Profile. Maximum Performance. Power Management Options

Intel Turbo Boost Technology. Enabled. System BIOS setting

Turbo Boost Optimization. Optimized for Performance. Power BIOS

setting

Energy settings:

Change Power Options/Power Plan to High performance

/Andy

Den 26 jun 2013 15:56 skrev "Aji Paul" <qcwebmaster@qlik.com>:

[#5]

Thank you Andy!

BTW did you guys look into any other processors ?

ex. E5-2687W seems higher performance

Also Intel's naming conventions are super confusing

[andy]

No problem. No we didn't look into any other.

/Andy

Den 27 jun 2013 18:15 skrev "Aji Paul" <qcwebmaster@qlik.com>:

**

QlikCommunity <http://community.qlik.com/index.jspa> Re: After

upgrading to QV11 SR2 system is unstable created by Aji Paul<http://community.qlik.com/people/ajipaul01>in

Deployment and Management (Server/Publisher/AJAX/IE/Web Parts) - View

the full discussion <http://community.qlik.com/message/361748#361748>