Subject | Re: IBO and Intraweb in multi-thread still problem |
---|---|
Author | wdelph2001 |
Post date | 2006-01-02T19:30:34Z |
I'm having a similar problem with an IntraWeb app..
Using D7, IW 7, IBO 4 and Firebird 1.5.3
The app is running on an XP machine.
The app will just lockup after some time in operation. It's
arbitrary, I can't seem to put my finger on what's making it lockup.
The IW debug screen reports active sessions but nothing connects to
the database after the lockup. I have to shut down the app and
restart it.
I can however lock it up every time from one of my computers that's
on the same physical network as the server. I don't know why this
one computer locks it up but other pc's in the hub will not lock it
up. Also certain users outside of the local network that access it
using the normal browser links can lock it up too.
There's no message when the lockup occurs, it just freezes!
Before I switched to IBO I was using the components that come with
Interbase. Every time I used the Commit statement it would do the
same lockup. When I switched to IBO the frequency of the lockups
decreased but I still get them occasionally.
Any ideas?
Thanks,
Wayne
Using D7, IW 7, IBO 4 and Firebird 1.5.3
The app is running on an XP machine.
The app will just lockup after some time in operation. It's
arbitrary, I can't seem to put my finger on what's making it lockup.
The IW debug screen reports active sessions but nothing connects to
the database after the lockup. I have to shut down the app and
restart it.
I can however lock it up every time from one of my computers that's
on the same physical network as the server. I don't know why this
one computer locks it up but other pc's in the hub will not lock it
up. Also certain users outside of the local network that access it
using the normal browser links can lock it up too.
There's no message when the lockup occurs, it just freezes!
Before I switched to IBO I was using the components that come with
Interbase. Every time I used the Commit statement it would do the
same lockup. When I switched to IBO the frequency of the lockups
decreased but I still get them occasionally.
Any ideas?
Thanks,
Wayne
--- In IBObjects@yahoogroups.com, "jubaonline" <jubaon@t...> wrote:
>
> Jason I have still the problem !
>
> Today morning just two people connected on two different db after
20
> minutes
> get stop the application. I don't know more what to do. Thursday
and
> Friday
> I've to terminate the application during the day other two-three
> times. When
> happend, I find the application stopped, something written on the
> debug
> window, nothing responds when I try to go in the application with
the
> browser (calling the port) and when I want to close the application
> on the
> server it don't close: I need to terminate with the task manager.
>
> Otherwise if two or more people are using the same port and the
same
> db I
> don't get any problem. I ask also to IW group but nothing. The
> problem is
> that there are too few debug information. The debug window of IW
> don't say
> me what form, and which method is just call. IB Monitor show me all
> the
> transaction and date-time, good, but without the name of the
> connection.
>
> I check also with my provider: my server on Internt work fine, no
> problem
> with firewall.
>
> If you have experience with IW I can send you more code, just to
> debug this
> mistake.
>
> I notice the problem is using different db at the same time.
>
> Thanks
>
> Fabrizio
>
>
> > > Subject: [IBO] IBO and Intraweb in multi-thread problem
> > >
> > >
> > > As Jason says I've updated my ISAPI Intraweb program moving all
> the
> > > rest of tables and query from the forms to the only 1 data-
module
> as
> > > you say. I've tested hardly in local network and then put
online.
> > > After half a day I get a crash (6-7 user only just working on 2-
3
> > > differnt db): in the data-module I've IB_Session (first in
> creation
> > > order), IB_Connection, IB_Transaction and all the query e
tables.
> > > Interbase server was ok and I can always connect also after the
> > > crash. I you use for debugging the Application Mode and I
notice
> that
> > > Intraweb is not down, because the application respond to my
> request
> > > till before login check (query on db).
> > >
> > > What can be ? What is the propery IB_Session.TimeInterval ? I
set
> it
> > > to 0. Is it a problem with IWServerController.SessionTimeout ?
> > >
> > > I use Interbase 6.0 and my ISAPI connect 1 only db based on the
> user
> > > login. So each group of user use a different db.
> > >
> > > I use the IB_Monitor also to check all the interactions and I
> notice
> > > the problem is in a conflict using the db when accessing in the
> same
> > > moment. That's why don't happend everytime.
> > >
> > > Intraweb for each user session create a new data-module (and so
a
> new
> > > IB_Session and IB_Connection).
> > >
> > > I try also to create a unique CriticalSection variable and set
it
> for
> > > Acquire and Release before and a after all db operation. It
seems
> > > better, but sometimes crash or get very slow.
> > >
> > > IBObject bugs ?
> > >
> > > HELP ME please, I'm doing something wrong ?
> > >
> > > Intraweb 5.1.3 e D7 , IBO 4.2.I, Interbase 6.01
> > >
> > > Thanks
> > > Fabrizio
> >
> >
> >
> >
>
______________________________________________________________________
> _____
> > IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> > without the need for BDE, ODBC or any other layer.
> >
>
______________________________________________________________________
> _____
> > http://www.ibobjects.com - your IBO community resource for Tech
Info
> papers,
> > keyword-searchable FAQ, community code contributions and more !
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
>