Skip to main content
O
OkTulsa
Participant
August 19, 2008
Question

Error Executing Database Query

  • August 19, 2008
  • 2 replies
  • 860 views
Sorry, put this in the wrong category. Moved to database category. But i'll leave the error posted here:

About three times a week, we get a ton of errors for "Error Executing Database Query", all at once. That is about as descriptive as it gets. It does tell us the line and the exact SQL statement it tried to run, but when we copy and paste the SQL into a query browser it runs fine. It's almost like there is a connection failure somewhere between CF and the db that is causing this "error"? Has anyone experienced anything like this? Thanks for any help.
    This topic has been closed for replies.

    2 replies

    N
    Newsgroup_User
    Inspiring
    August 19, 2008
    Adam Cameron wrote:
    >
    > There's plenty of investigation here for you to do.
    >

    As well as all that Cameron says, you will probably want to investigate
    load as that can be a root cause to many of the items he suggests. I.E.
    maybe it is too many simultaneous requests causing something to be dropped.

    N
    Newsgroup_User
    Inspiring
    August 19, 2008
    It sounds to me like the connection between your DB server and CF server is
    dropping. Where is the DB server in relation to the CF server? Did the DB
    get taken down for maintenance? Is the problem always at the same time of
    day? what time of day is that? Does it happen for ALL queries? When the
    problem is manifesting, can you make a connection from the CF server to the
    DB server using [insert name of appropriate DB client software here]. Can
    you even ping it during these times? Does anything get logged on the DB
    end of things?

    There's plenty of invesigation here for you to do.

    --
    Adam
    O
    OkTulsaAuthor
    Participant
    August 19, 2008
    Where is the DB server in relation to the CF server?
    We run a clustered, load balanced environment involving seven web servers running on windows boxes. The Informix database is running on a separate linux box, but all in the same domain.

    Did the DB get taken down for maintenance?
    No

    Is the problem always at the same time of day? what time of day is that?
    There is not a real consistency with when it happens, but if there is a more common time it would be early afternoon

    Does it happen for ALL queries?
    No. Some people get through just fine which makes me think it is one or two of the seven web servers that is having the problem. But we don't really have any way of telling which one it is.

    When the problem is manifesting, can you make a connection from the CF server to the DB server using [insert name of appropriate DB client software here].
    Informix's software is not very user friendly, but i'll try.

    Can you even ping it during these times?
    With some queries getting through, I would think yes.

    Does anything get logged on the DB end of things?
    Not that I have seen, but I'll check again.
    O
    OkTulsaAuthor
    Participant
    August 19, 2008
    I was able to get a dump of the entire error, which is returning an informix error code of -408. The description of that error is below. Does anyone know that this means? Thanks to all for the help.

    -408 Invalid message type received from the sqlexec process.
    This internal error indicates a problem in the communication between the database server and the library functions that call it. Make sure that your program software is compatible with the database engine in use. If the error recurs, please note all circumstances and contact Informix Technical Support.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices