Board index » delphi » interbase hangs for small periods of time, than comes up

interbase hangs for small periods of time, than comes up

Hi,
I have InterBase 5 running on w2k. I connect to it from two hosts: one in the webserver where our JSP web application connects through JDBC and Interclient. The other application is just a java app, again jdbc and Interclient, but it runs on the database server itself. Sometimes (quite often) the application just fails to connect to interbase. At the same time JSP on the web server keep working fine (I assume using a connection established before server hang). When this happens I can't connect using Server Manager either, so it's not Interclient problem. Then after 10 or 30 minutes it starts working again.

I'd appreciate any advice,
TIA!

P.S. Please cc: me, getting to this newsgroup is somewhat complicated for me.

 

Re:interbase hangs for small periods of time, than comes up


In article <3cab51b6$1_2@dnews>, mes...@scorch2000.com says...

Quote

        Sorry, there's just not enough information in your post to help you
out.  You have to do some basic level of research so that we can figure
out what is going on.  When the server "hangs" what happens?  Do you see
an error message?  Are there messages in interbase.log?  Is the CPU at
100%?  Lots of disk activity?  What else do you notice.

Quote
> P.S. Please cc: me, getting to this newsgroup is somewhat complicated for me.

        Sorry, the messages need to be in public only -- this way they
benefit all newsgroup readers.

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
     Delphi/InterBase WebLog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Re:interbase hangs for small periods of time, than comes up


Craig Stuntz [TeamB] <cstuntz@no_spam.vertexsoftware.com> wrote:

Quote
>In article <3cab51b6$1_2@dnews>, mes...@scorch2000.com says...

>    Sorry, there's just not enough information in your post to help you
>out.  You have to do some basic level of research so that we can figure
>out what is going on.  When the server "hangs" what happens?  Do you see
>an error message?  Are there messages in interbase.log?  Is the CPU at
>100%?  Lots of disk activity?  What else do you notice.

I described everything. Nothing else happens. No cpu load, no disk activity and no error messages. After a while the applications that are blocking on attempt to connect come up and work ok.
I will check the log file again.

Quote
>> P.S. Please cc: me, getting to this newsgroup is somewhat complicated for me.

>    Sorry, the messages need to be in public only -- this way they
>benefit all newsgroup readers.

I know, but usually it's possible to send a carbon copy to the e-mail address is addition to the newsgroup post.

Re:interbase hangs for small periods of time, than comes up


In article <3cad1585$1_2@dnews>, mes...@scorch2000.com says...

Quote

> I described everything. Nothing else happens. No cpu load,
> no disk activity and no error messages. After a while the
> applications that are blocking on attempt to connect come
> up and work ok.

        So they are still connected to the DB?

Quote
> I know, but usually it's possible to send a carbon copy to
> the e-mail address is addition to the newsgroup post.

        If I do that, people might respond via email.  The conversation
needs to stay in the newsgroup for everyone to read.

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
     Delphi/InterBase WebLog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Re:interbase hangs for small periods of time, than comes up


Craig Stuntz [TeamB] <cstuntz@no_spam.vertexsoftware.com> wrote:

Quote
>In article <3cad1585$1_2@dnews>, mes...@scorch2000.com says...

>> I described everything. Nothing else happens. No cpu load,
>> no disk activity and no error messages. After a while the
>> applications that are blocking on attempt to connect come
>> up and work ok.

>    So they are still connected to the DB?

It looks like the applications that are connected to the database before it hangs keep working fine, but applications which attempt connection block for a long period of time. I don't know whether they block before actually connection or after, because server managers blocks too.

I've checked log file (there is only one, right?) and it doesn't have anything interesting.

Re:interbase hangs for small periods of time, than comes up


In article <3cadfc32$1_2@dnews>, mes...@scorch2000.com says...

Quote

> It looks like the applications that are connected to the
> database before it hangs keep working fine, but applications
> which attempt connection block for a long period of time. I
> don't know whether they block before actually connection or
> after, because server managers blocks too.

        Sounds like a threading conflict.  If your app is multithreaded
make sure that you are using a remote connect string and that each
thread has its own connection to IB.

        I have no idea how this works in the InterClient world.

        HTH,

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
     Delphi/InterBase WebLog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Re:interbase hangs for small periods of time, than comes up


I have seen something similar using InterClient->InterServer when
InterClient is running on one platform and InterServer is running on a
different platform. In this case the fix is to run InterServer on the same
platform (same box) and have InterClient talk to the local InterServer and
have InterServer connect to a remote db via 3050.

This does present a different problem if the remote database goes down,
though. InterClient is unaware that this has occurred.

Francis Brock
QuickHire, Inc.

Quote
"Meshko" <mes...@scorch2000.com> wrote in message news:3cad1585$1_2@dnews...

> Craig Stuntz [TeamB] <cstuntz@no_spam.vertexsoftware.com> wrote:
> >In article <3cab51b6$1_2@dnews>, mes...@scorch2000.com says...

> > Sorry, there's just not enough information in your post to help you
> >out.  You have to do some basic level of research so that we can figure
> >out what is going on.  When the server "hangs" what happens?  Do you see
> >an error message?  Are there messages in interbase.log?  Is the CPU at
> >100%?  Lots of disk activity?  What else do you notice.

> I described everything. Nothing else happens. No cpu load, no disk

activity and no error messages. After a while the applications that are
blocking on attempt to connect come up and work ok.
Quote
> I will check the log file again.

> >> P.S. Please cc: me, getting to this newsgroup is somewhat complicated
for me.

> > Sorry, the messages need to be in public only -- this way they
> >benefit all newsgroup readers.

> I know, but usually it's possible to send a carbon copy to the e-mail

address is addition to the newsgroup post.

Other Threads