Thread: [Sqlrelay-discussion] possible bug
Brought to you by:
mused
From: Frank W. <fr...@wi...> - 2005-06-16 21:22:20
|
Hi Everyone, I'm trying to use SQLRelay with an Oracle 8 database and keep running into a problem. Every so often, after several hours of perfect use, SQLRelay completely stops being able to communicate with the database. Btw, I'm using the Perl DBI and DBD::SQLRelay libraries to connect to the database. There are some known network connectivity issues between the database and client server where SQLRelay is running, but even when connectivity is restored database queries will not go through. Has anyone else run into this problem before? --------------------------------- Frank Wiles <fr...@wi...> http://www.wiles.org --------------------------------- |
From: David M. <dav...@fi...> - 2005-06-17 01:43:03
|
The most common cause of that is if there's a firewall (especially a Cisco PIX firewall) between SQL Relay and the database. See http://sqlrelay.sourceforge.net/sqlrelay/faq.html#firewallhang for more details. If there's no firewall, then there could be a bug. I'd need to know more details though. If you're using a relatively new version (0.35 or newer) then SQL Relay should be able to handle it if the database goes down or otherwise becomes inaccessible and comes back up, but it's possible that there's still a bug in that code. David Muse dav...@fi... On Thu, 2005-06-16 at 16:23 -0500, Frank Wiles wrote: > Hi Everyone, > > I'm trying to use SQLRelay with an Oracle 8 database and keep running > into a problem. Every so often, after several hours of perfect use, > SQLRelay completely stops being able to communicate with the database. > Btw, I'm using the Perl DBI and DBD::SQLRelay libraries to connect > to the database. > > There are some known network connectivity issues between the database > and client server where SQLRelay is running, but even when > connectivity is restored database queries will not go through. > > Has anyone else run into this problem before? > > --------------------------------- > Frank Wiles <fr...@wi...> > http://www.wiles.org > --------------------------------- > > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
From: Frank W. <fr...@wi...> - 2005-06-17 13:51:05
|
I believe there is a PIX firewall in between, which I completely forgot about when trying to debug this. Thanks for pointing me to the right docs. --------------------------------- Frank Wiles <fr...@wi...> http://www.wiles.org --------------------------------- On Thu, 16 Jun 2005 21:44:28 -0400 David Muse <dav...@fi...> wrote: > The most common cause of that is if there's a firewall (especially a > Cisco PIX firewall) between SQL Relay and the database. See > http://sqlrelay.sourceforge.net/sqlrelay/faq.html#firewallhang > for more details. > > If there's no firewall, then there could be a bug. I'd need to know > more details though. If you're using a relatively new version (0.35 > or newer) then SQL Relay should be able to handle it if the database > goes down or otherwise becomes inaccessible and comes back up, but > it's possible that there's still a bug in that code. > > David Muse > dav...@fi... > > On Thu, 2005-06-16 at 16:23 -0500, Frank Wiles wrote: > > Hi Everyone, > > > > I'm trying to use SQLRelay with an Oracle 8 database and keep > > running into a problem. Every so often, after several hours of > > perfect use, SQLRelay completely stops being able to communicate > > with the database. Btw, I'm using the Perl DBI and DBD::SQLRelay > > libraries to connect to the database. > > > > There are some known network connectivity issues between the > > database and client server where SQLRelay is running, but even > > when connectivity is restored database queries will not go > > through. > > > > Has anyone else run into this problem before? > > > > --------------------------------- > > Frank Wiles <fr...@wi...> > > http://www.wiles.org > > --------------------------------- > > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: Discover Easy Linux Migration > > Strategies from IBM. Find simple to follow Roadmaps, straightforward > > articles, informative Webcasts and more! Get everything you need to > > get up to speed, fast. > > http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > --------------------------------- Frank Wiles <fr...@wi...> http://www.wiles.org --------------------------------- |