RE: error -439
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
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
"Unspecified Error" messages in our vendor's reporting tool. Requesting
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
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
[mailto:email@example.com] On Behalf Of Carsten Haese
Sent: Tuesday, August 07, 2007 11:27 AM
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
Ideally, you should drop the ancient ifx_stuff in favor of PDO/Informix,
but that may not be feasible either.
Informix-list mailing list