I gotta ask this question again... the problem has been getting worse.

This problem shows itself in several ways throughout our systems:

Error: Database server is currently processing SQL task (Error -439)
occurs when I call ifx_connect() within a php script. Typically,
re-loading the page works -- we haven't been able to reproduce this
reliably.

Our users aren't getting full permissions when they log in (it's a kluge
our vendor put in to attempt merge permissions as they merged two
products).

"Unspecified Error" messages in our vendor's reporting tool. Requesting
the report

I take a look onstat -u and typically see 400+ sessions there. This is
a high number for us. As I've watched this over the last couple of
weeks, we seem to have more problem occurrences when the number of
active sessions is 450-500. When it drops down to around 400, I don't
hear about problems.

I've looked at the SQL for these a lot of these sessions that have 0
nreads and 0 nwrites -- they are typically queries that our vendor's
software might do -- certainly nothing our home-grown stuff does.
Looking at other sessions where there have been reads and writes shows a
smattering of SQL that might come from the vendor's software or from our
custom stuff.

The flags on all these sessions is Y--P---. So it would seem that 99+%
of my database sessions are just setting there with nothing to do. So
I'm curious why the sessions don't disappear. Is that what you would
expect?

Brian McLaughlin


-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Carsten Haese
Sent: Tuesday, August 07, 2007 11:27 AM
To: informix-list@iiug.org
Subject: Re: error -439

On Tue, 2007-08-07 at 11:11 -0700, Brian McLaughlin wrote:
> Hi all,
>
>
>
> I have a web page in php that does a number of queries to pull up
> various bits of information on students. Occasionally, this page
> produces the following:
>
> ERROR: Database server is currently processing SQL task.
> Error #: -439
> Database: SOL
> File: /var/apache/share/irislink/helpers/dbconnect.php
> Line: 50
>
> The line it's failing on is the call to ifx_connect();
> [...]

My first instinct would be to update PHP and/or the PHP-Informix module.
Actually, that would be my second instinct, while my first instinct
would be to switch to Python, but I imagine that's not practical for
you ;-)

Ideally, you should drop the ancient ifx_stuff in favor of PDO/Informix,
but that may not be feasible either.

HTH,

--
Carsten Haese
http://informixdb.sourceforge.net


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list