sqlrelay-discussion Mailing List for SQL Relay (Page 51)
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion — Discussion of topics related to SQL Relay
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
(20) |
Mar
(27) |
Apr
(17) |
May
(32) |
Jun
(45) |
Jul
(49) |
Aug
(68) |
Sep
(44) |
Oct
(29) |
Nov
(64) |
Dec
(25) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(61) |
Feb
(22) |
Mar
(25) |
Apr
(31) |
May
(18) |
Jun
(28) |
Jul
(19) |
Aug
(16) |
Sep
(8) |
Oct
(17) |
Nov
(32) |
Dec
(4) |
| 2007 |
Jan
(20) |
Feb
(25) |
Mar
(5) |
Apr
(12) |
May
(11) |
Jun
(18) |
Jul
(16) |
Aug
(22) |
Sep
(37) |
Oct
(20) |
Nov
(11) |
Dec
(2) |
| 2008 |
Jan
(11) |
Feb
(33) |
Mar
(12) |
Apr
(18) |
May
(22) |
Jun
(31) |
Jul
(23) |
Aug
(6) |
Sep
|
Oct
(10) |
Nov
(22) |
Dec
|
| 2009 |
Jan
(12) |
Feb
(8) |
Mar
(11) |
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(27) |
Aug
(2) |
Sep
(10) |
Oct
(5) |
Nov
(2) |
Dec
(1) |
| 2010 |
Jan
(11) |
Feb
(18) |
Mar
(10) |
Apr
(28) |
May
(28) |
Jun
|
Jul
(27) |
Aug
(9) |
Sep
(21) |
Oct
(2) |
Nov
(2) |
Dec
(11) |
| 2011 |
Jan
|
Feb
(2) |
Mar
(4) |
Apr
(2) |
May
(2) |
Jun
(44) |
Jul
(9) |
Aug
(2) |
Sep
(12) |
Oct
(7) |
Nov
(11) |
Dec
(7) |
| 2012 |
Jan
(5) |
Feb
|
Mar
(9) |
Apr
(9) |
May
(12) |
Jun
|
Jul
(13) |
Aug
(3) |
Sep
(3) |
Oct
(1) |
Nov
(1) |
Dec
(10) |
| 2013 |
Jan
(21) |
Feb
(3) |
Mar
(4) |
Apr
|
May
(3) |
Jun
(2) |
Jul
(3) |
Aug
(3) |
Sep
(3) |
Oct
|
Nov
|
Dec
(4) |
| 2014 |
Jan
(7) |
Feb
|
Mar
(1) |
Apr
|
May
(2) |
Jun
|
Jul
(4) |
Aug
(2) |
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: David E. <dav...@lb...> - 2005-11-09 10:08:03
|
Thanks, David. Looking forward to 0.37! On a slightly different topic, I have briefly tried benchmarking the SQL Relay DBI driver against the standard MySQL DBI driver. Obviously there are a huge number of variables involved - I am running SQL Relay locally on our web server connecting to a DB on a different machine, for example - but I was surprised to find SQL Relay marginally slower. On average, transactions via SQL relay took 0.16 secs vs 0.13 secs direct. I was hoping for a slight improvement through connection pooling. Are there any tweaks I could try not listed on your performance tuning page? Does the socket parameter get used by the DBI driver? Or would I be best off rewriting my DB wrapper to use the SQL Relay API directly rather than via DBI? David -----Original Message----- From: David Muse [mailto:dav...@fi...] Sent: 08 November 2005 04:04 To: sql...@li... Subject: RE: [Sqlrelay-discussion] Perl compilation error with 0.36.4 Hmmm, I'll have to look into that a bit deeper. Adding a $ in front will have the effect of requiring the 3rd argument to be the string "SQLRelay::SQL_CLOB" to bind a clob. I'm not sure that's right, but if you don't use clob's then go with it :) I'll figure out what's what though and fix it in the 0.37 release. Dave dav...@fi... On Fri, 2005-11-04 at 15:03 +0000, David Edwards wrote: > Hi David, > > Thanks for replying. I've tried the replacement file, but still got the same > compilation error. I did try inserting a $ in front of > DBD::SQLRelay::SQL_CLOB and DBD::SQLRelay::SQL_BLOB on lines 282 and 294, > and this did get rid of the compilation error. However, I don't know whether > the resulting code does what it's supposed to do, because I'm not using > CLOBs or BLOBs. > > Regards, > > David > > -----Original Message----- > From: Firstworks/4access [mailto:dav...@fi...] > Sent: 04 November 2005 14:48 > To: sql...@li... > Subject: Re: [Sqlrelay-discussion] Perl compilation error with 0.36.4 > > > Hmm, looks like DBD::SQLReay::SQL_CLOB and SQL_BLOB aren't defined. Try > replacing /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm with the > attached file and see if it works. > > David Muse > dav...@fi... > > On Thu, 2005-11-03 at 10:56 +0000, David Edwards wrote: > > I am trying to use SQL Relay via the DBI driver from a simple Perl script, > > but have run into a problem. On our development environment - using SQL > > Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on our > > production environment, trying to run the same script results in the > > following Perl error: > > > > install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not > > allowed while "strict subs" in use at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use > at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > > Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in use > at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use > at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > > Compilation failed in require at (eval 4) line 3. > > > > Is this an issue with our Perl, or a problem with the SQL Relay code? If > the > > former, does anyone have any suggestions as to how to solve the problem? > > > > Thanks, > > > > David > > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. > Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: Thomas J. <Shi...@gm...> - 2005-11-08 08:40:02
|
Hi guys! I looked in the manual, but I didn't find anything regarding the load-balancing in SQL Relay. Can you tell me what kind of load-balancing is used in SQL Relay? Is it a simple round robin type or a real load dependent load-balancing? I'm just curious... Thanks in advance! -- Telefonieren Sie schon oder sparen Sie noch? NEU: GMX Phone_Flat http://www.gmx.net/de/go/telefonie |
|
From: Deepa K. M. <de...@te...> - 2005-11-08 05:08:50
|
Hi I have configured sqlrelay, sqlr-start works fine But when I try to connect using zope i am unable to do so, It says couldn't connect to listner Help Needed !!! -- Deepa K. Mahajan <de...@te...> Tetra Information Services Pvt. Ltd |
|
From: David M. <dav...@fi...> - 2005-11-08 04:03:11
|
Hmmm, I'll have to look into that a bit deeper. Adding a $ in front will have the effect of requiring the 3rd argument to be the string "SQLRelay::SQL_CLOB" to bind a clob. I'm not sure that's right, but if you don't use clob's then go with it :) I'll figure out what's what though and fix it in the 0.37 release. Dave dav...@fi... On Fri, 2005-11-04 at 15:03 +0000, David Edwards wrote: > Hi David, > > Thanks for replying. I've tried the replacement file, but still got the same > compilation error. I did try inserting a $ in front of > DBD::SQLRelay::SQL_CLOB and DBD::SQLRelay::SQL_BLOB on lines 282 and 294, > and this did get rid of the compilation error. However, I don't know whether > the resulting code does what it's supposed to do, because I'm not using > CLOBs or BLOBs. > > Regards, > > David > > -----Original Message----- > From: Firstworks/4access [mailto:dav...@fi...] > Sent: 04 November 2005 14:48 > To: sql...@li... > Subject: Re: [Sqlrelay-discussion] Perl compilation error with 0.36.4 > > > Hmm, looks like DBD::SQLReay::SQL_CLOB and SQL_BLOB aren't defined. Try > replacing /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm with the > attached file and see if it works. > > David Muse > dav...@fi... > > On Thu, 2005-11-03 at 10:56 +0000, David Edwards wrote: > > I am trying to use SQL Relay via the DBI driver from a simple Perl script, > > but have run into a problem. On our development environment - using SQL > > Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on our > > production environment, trying to run the same script results in the > > following Perl error: > > > > install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not > > allowed while "strict subs" in use at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use > at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > > Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in use > at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use > at > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > > Compilation failed in require at (eval 4) line 3. > > > > Is this an issue with our Perl, or a problem with the SQL Relay code? If > the > > former, does anyone have any suggestions as to how to solve the problem? > > > > Thanks, > > > > David > > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. > Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: David M. <dav...@fi...> - 2005-11-08 03:42:57
|
The SQLRelay folder should definitely go inside the lib/python/Products/ZSQLRelayDA folder. After making sure that's right, try: ldd /usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/SQLRelay/CSQLRelay.so Dave dav...@fi... On Fri, 2005-11-04 at 10:39 -0500, Vecchio, Peppi wrote: > Thanks for the help. I did the "ldd /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so" and it came up with "no such file or directory" via commandline, but through my SSHclient, I'm looking at the file. I musn't have the path set properly. I'll continue to work on it. > > As far as the Zope path, I'm afraid it's my mistake for not being entirely clear. The /lib/python is actually /usr/src/zope-2.7.7/lib/python/. I had read that someone moved the SQLRelay folder to /usr/src/zope-2.7.7/lib/python/ as opposed to /usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA. Thought it was worth a try. As far as structure and permissions, can you please confirm for me that the SQLRelay folder does belong in ZSQLRelayDA and that all folders should be set to 755 and all subsequent files (dtml, py, etc.) should be 644? Seems I've had some issues installing other products where the permissions were not getting set right. > > Thanks again, > > Peppi Vecchio | Web Developer > TECHNOLOGY SERVICES GROUP > > > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...]On Behalf Of > Firstworks/4access > Sent: Friday, November 04, 2005 10:00 AM > To: sql...@li... > Subject: Re: [Sqlrelay-discussion] SQLRelay install issue > > > Did you ever get this worked out? > > Usually what causes this problem is if libsqlrclient-0.34.r.so.1 isn't > in your LD_LIBRARY_PATH or /etc/ld.so.conf file. If you're sure that it > is and you're sure that you've run ldconfig (which you did), then the > only other reason that it might not work is if the python module > CSQLRelay.so was compiled with -rpath and libsqlrclient-0.34.4.so.1 > isn't in that path. > > Try doing: > ldd /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so > and see what path it has for libsqlrclient-0.34.4.so.1 > > If the output of the ldd command isn't clear, send it to me and I'll > take a look at it. > > There does also appear to be something strange going on with Zope. > If you installed stuff under /lib/python, then why is Zope looking (and > finding) stuff in /usr/src/zope-2.7.7/lib/python? > > David Muse > dav...@fi... > > On Thu, 2005-10-20 at 14:22 -0400, Vecchio, Peppi wrote: > > So close! Can't quite figure out the last leg of this install. > > > > I have freetds-0.63 working - tested with the tsql command. > > > > unixODBC working -tested with the isql command. > > > > sqlr - working: > > > > some@here bin]# sqlr-start -id mssql > > > > Starting listener: > > sqlr-listener -id mssql > > -config /usr/local/firstworks/etc/sqlrelay.conf > > > > Starting 3 connections to db1 : > > sqlr-connection-freetds -id mssql -connectionid db1 > > -config /usr/local/firstworks/etc/sqlrelay.conf > > sqlr-connection-freetds -id mssql -connectionid db1 > > -config /usr/local/firstworks/etc/sqlrelay.conf > > sqlr-connection-freetds -id mssql -connectionid db1 > > -config /usr/local/firstworks/etc/sqlrelay.conf > > > > Starting scaler: > > sqlr-scaler -id mssql > > -config /usr/local/firstworks/etc/sqlrelay.conf > > > > Starting cache manager: > > sqlr-cachemanager > > > > > > Thanks to MP3.com for sponsoring: > > Clustered/Replicated database support. > > Perl API. > > > > All running on RedHad Linux Enterprise. Trying to finish connecting > > to MSSQL Server. > > > > When I installed SQLRelay, it put ZSQLRelayDA in /lib/python/Products. > > I read somewhere that SQLRelay (in /lib/python/Products/ZSQLRelayDA/) > > needs to be in /lib/python. So I tried it and have gotten this far. > > Now when I restart zope with zopectl fg - this is the error I'm > > seeing: > > > > 2005-10-20T13:32:29 ERROR(200) Zope Could not import > > Products.ZSQLRelayDA > > Traceback (most recent call last): > > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > > in import_product > > product=__import__(pname, global_dict, global_dict, silly) > > File > > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > > line 7, in ? > > import DA > > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > > line 7, in ? > > from db import DB > > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > > line 1, in ? > > import SQLRelay, DateTime > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > > in ? > > import PySQLRDB > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > > in ? > > from SQLRelay import CSQLRelay > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > > line 4, in ? > > import PySQLRDB > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > > line 10, in ? > > from SQLRelay import CSQLRelay > > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > > file: No such file or directory > > Traceback (most recent call last): > > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 50, > > in ? > > run() > > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 19, > > in run > > start_zope(opts.configroot) > > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > > 52, in start_zope > > starter.startZope() > > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > > 231, in startZope > > Zope.startup() > > File "/usr/src/zope-2.7.7/lib/python/Zope/__init__.py", line 47, in > > startup > > _startup() > > File "/usr/src/zope-2.7.7/lib/python/Zope/App/startup.py", line 45, > > in startup > > OFS.Application.import_products() > > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 650, > > in import_products > > import_product(product_dir, product_name, raise_exc=debug_mode) > > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > > in import_product > > product=__import__(pname, global_dict, global_dict, silly) > > File > > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > > line 7, in ? > > import DA > > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > > line 7, in ? > > from db import DB > > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > > line 1, in ? > > import SQLRelay, DateTime > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > > in ? > > import PySQLRDB > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > > in ? > > from SQLRelay import CSQLRelay > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > > line 4, in ? > > import PySQLRDB > > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > > line 10, in ? > > from SQLRelay import CSQLRelay > > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > > file: No such file or directory > > > > > > libsqlrclient-0.36.r.so.1 is in /usr/local/firstworks/lib - this path > > is also in ld.so.conf (of which I removed ld.so.cache and ran > > ldconfig) > > > > Yet I'm still getting this "cannot open shared object file" error. > > > > Can anyone help shed some light on this for me? I would be eternally > > grateful. > > > > Thanks, > > > > > > Peppi Vecchio | Web Developer > > TECHNOLOGY SERVICES GROUP > > > > > > > > ______________________________________________________________________ > > > > The information contained in this message is privileged, confidential > > and intended only for use of the individual or entity addressed above. > > If you have received this communication in error, please immediately > > notify us by reply and delete the same. Thank you. > > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Paul D. W. <pdw...@qu...> - 2005-11-07 05:36:48
|
Hi David, 0.36pre3 worked perfectly. I have not tested 0.36pre4, but will do so if you would like. Your latest prerelease, 0.37pre3 also compiles cleanly in the same environment and so far appears to work perfectly. I am using that version now. - Paul >Message: 5 >Subject: Re: [Sqlrelay-discussion] FYI: compile errror sqlrelay 0.37pre2 >From: Firstworks/4access <dav...@fi...> >To: sql...@li... >Date: Fri, 04 Nov 2005 10:05:53 -0500 >Reply-To: sql...@li... > >Sorry to take sooo long to get back on this one... > >Try http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz > >I ran into similar problems on a couple of other platforms. This >pre-release should fix this problem. If it doesn't, let me know. > >David Muse >dav...@fi... |
|
From: David M. <dav...@fi...> - 2005-11-07 05:05:32
|
I'm sorry, it's 0.37pre3: http://www.firstworks.com/sqlrelay-0.37pre3.tar.gz Dave On Fri, 2005-11-04 at 19:01 -0800, Cesar A. Peregrina Fimbres wrote: > Broken link > > http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz > > I think must be 37pre4 > > http://www.firstworks.com/sqlrelay-0.37pre4.tar.gz > > But also is a broken link. !!! > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Cesar A. P. F. <cpe...@bt...> - 2005-11-05 03:00:08
|
Broken link http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz I think must be 37pre4 http://www.firstworks.com/sqlrelay-0.37pre4.tar.gz But also is a broken link. !!! |
|
From: Dennis B. <den...@mc...> - 2005-11-04 19:13:15
|
Nope, it did nothing at all. I still get one extra cursor left open on the database for each bind cursor returned. I just rebuilt it again this morning with the fix applied to 0.36.4 (Had been on 0.36.2), with the same results. Just in case, I did a manual uninstall and rebuilt everything. No luck. Dennis On Fri, 2005-11-04 at 13:50 -0500, Matt Flynn wrote: > So did this fix do nothing at all for you? The reason I say the fix > helped is because it took 3x as long (6 hrs vs 2 hrs prior to applying > the fix) before the oracle cursors climbed to an unacceptable level. If > the fix is not working, the extra time it took sqlrelay to fail may be > due to less traffic on the site at the time of testing. Perhaps this > fix did not solve the issue. > > -Matt > > > Dennis Bolton wrote: > > >Good luck Matt, > > > >I still get the same results as below with ref cursors left open. > > > >Dennis > > > >On Fri, 2005-11-04 at 12:48 -0500, Matt Flynn wrote: > > > > > >>This seems to have helped the situation but not resolved it. I'm > >>looking into other areas where cursors could be left open. > >> > >>David Muse wrote: > >> > >> > >> > >>>It took a while, but I believe I found the bug. > >>> > >>>You can fix it by editing src/connection/sqlrconnection/getbinds.C > >>>and adding this line after line 110: > >>> > >>> curs->busy=true; > >>> > >>>That should take care of it. > >>> > >>>David Muse > >>>dav...@fi... > >>> > >>>On Tue, 2005-10-11 at 15:58 -0400, Matt Flynn wrote: > >>> > >>> > >>> > >>> > >>>>I am experiencing similar behavior. > >>>> > >>>>I am also using sqlrcur_getOutputBindCursor but I have not yet > >>>>determined if this is the (only) cause of open cursors on the oracle > >>>>server. Using PHP OCI I typically see around 8000 open cursors on one > >>>>database for a particular db user. Using sqlr I watched the open > >>>>cursors climb to 20000+ before shutting down sqlrelay. Oracle version > >>>>is 9.2.0.5. > >>>> > >>>>Here is my instance configuration in sqlrelay.conf: > >>>><instance id="dbinstance" port="9000" socket="/tmp/dbinstance.socket" > >>>>dbase="oracle8" connections="50" maxconnections="200" maxqueuelength="0" > >>>>growby="5" ttl="60" endofsession="commit" sessiontimeout="600" > >>>>runasuser="sqlrelay" runasgroup="sqlrelay" cursors="3" > >>>>authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none"> > >>>> > >>>>If cursors are left open on the Oracle server, does this mean a cursor > >>>>is left hanging on the sqlrelay server? Meaning that my php app can no > >>>>longer use that sqlrelay cursor? The behavior I am experiencing is that > >>>>my sqlrelay connections are eventually all used up and my php app can no > >>>>longer connect to the sqlrelay servers. With my current configuration > >>>>the increase of sqlr-connection processes running on the server is > >>>>progressive even though the web server traffic is relatively stable. My > >>>>50 initial connections last maybe 15 minutes before they scale up and > >>>>after about an hour to an hour and a half, all 200 sqlr-connection > >>>>processes are running and the site can no longer connect to sqlr. > >>>> > >>>>I have taken extreme care, per > >>>>http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php, to make sure ALL > >>>>open sqlr connections and cursors are explicitly closed through calls to > >>>>sqlrcur_free() and sqlrcon_free() before the php scripts end and I am > >>>>positive this is not the issue. > >>>> > >>>>Any suggestions or further troubleshooting steps are greatly appreciated. > >>>> > >>>>Thanks, > >>>> > >>>>Matt > >>>> > >>>> > >>>> > >>>> > >>>>Firstworks/4access wrote: > >>>> > >>>> > >>>> > >>>> > >>>> > >>>>>Looks like the server-side isn't cleaning up those cursors properly. > >>>>>I'll take a look and see if I can figure out what's going on. > >>>>> > >>>>>Dave > >>>>> > >>>>>On Thu, 2005-09-22 at 11:01 -0700, Dennis Bolton wrote: > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>>>Hi, > >>>>>> > >>>>>>When running the code below repeatedly I find that the > >>>>>>cursor created in > >>>>>> > >>>>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > >>>>>> > >>>>>>is never closed on the oracle server. After enough iterations the > >>>>>>server will error with to many open cursors. > >>>>>> > >>>>>>I am running sqlrelay 3.6.4, but the same results occur on 3.6.2. > >>>>>>PHP version is 4.4 . Oracle is 9.2g > >>>>>> > >>>>>>Here is a couple of consecutive sample results from this code: > >>>>>> > >>>>>>1. > >>>>>>there are 711 open cursors > >>>>>>Array > >>>>>>( > >>>>>> [StudentSortOrder] => 0 > >>>>>> [ClassID] => 818 > >>>>>> [Class] => Best Wisshes > >>>>>> [ClassDesc] => > >>>>>> [GradeLevel] => 4 > >>>>>> [ActiveStudents] => 1 > >>>>>>) > >>>>>>there are 712 open cursors > >>>>>> > >>>>>>2. > >>>>>>there are 712 open cursors > >>>>>>Array > >>>>>>( > >>>>>> [StudentSortOrder] => 0 > >>>>>> [ClassID] => 818 > >>>>>> [Class] => Best Wisshes > >>>>>> [ClassDesc] => > >>>>>> [GradeLevel] => 4 > >>>>>> [ActiveStudents] => 1 > >>>>>>) > >>>>>>there are 713 open cursors > >>>>>> > >>>>>> > >>>>>> > >>>>>>What might I be doing wrong? > >>>>>> > >>>>>> > >>>>>>************************************************************************************* > >>>>>><pre> > >>>>>><?php > >>>>>> > >>>>>>$conn = > >>>>>>sqlrcon_alloc('localhost','','/tmp/emgames.socket','webuser','thisisit',0,1); > >>>>>>//print_r($conn); > >>>>>> > >>>>>>//print_r($relay); > >>>>>> > >>>>>>$countquery = "select count(*) from sys.gv_\$open_cursor"; > >>>>>> > >>>>>>$qcur = sqlrcur_alloc($conn); > >>>>>>sqlrcur_sendquery($qcur,$countquery); > >>>>>>sqlrcon_endSession($conn); > >>>>>> > >>>>>>$rowarray=sqlrcur_getRow($qcur,0); > >>>>>> > >>>>>>echo "there are {$rowarray[0]} open cursors\n"; > >>>>>> > >>>>>>$procedure = "BEGIN sa.s_classes_teacher(2559,:returncur); END;"; > >>>>>> > >>>>>>if($cur = sqlrcur_alloc($conn)){ > >>>>>> > >>>>>> sqlrcur_prepareQuery($cur,$procedure); > >>>>>> > >>>>>> sqlrcur_defineOutputBindCursor($cur,'returncur'); > >>>>>> > >>>>>> sqlrcur_executeQuery($cur); > >>>>>> > >>>>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > >>>>>> > >>>>>> sqlrcur_fetchFromBindCursor($returncur); > >>>>>> > >>>>>> > >>>>>> $numrows = sqlrcur_rowCount($returncur); > >>>>>> $numcolumns = sqlrcur_colCount($returncur); > >>>>>> > >>>>>> > >>>>>> // Get the column names and types > >>>>>> for($i = 0; $i < $numcolumns; $i++){ > >>>>>> $columnnames[$i] = sqlrcur_getColumnName($returncur,$i); > >>>>>> $columntypes[$i] = sqlrcur_getColumnType($returncur,$i); > >>>>>> } > >>>>>> > >>>>>> // Get each row column by column and store each of them in the Results > >>>>>>array > >>>>>> for($i = 0 ; $i < $numrows ; $i++) { > >>>>>> for($j = 0 ; $j < $numcolumns; $j++){ > >>>>>> $results[$i][$columnnames[$j]] = sqlrcur_getField($returncur,$i,$j); > >>>>>> } > >>>>>> } > >>>>>>print_r($results[0]); > >>>>>> sqlrcon_endsession($conn); > >>>>>> sqlrcur_clearbinds($returncur); > >>>>>> sqlrcur_free($returncur); > >>>>>> sqlrcur_clearbinds($cur); > >>>>>> sqlrcur_free($cur); > >>>>>> > >>>>>>} > >>>>>>else { > >>>>>> echo "couldn't open cursor"; > >>>>>>} > >>>>>> > >>>>>>sqlrcur_sendquery($qcur,$countquery); > >>>>>>sqlrcon_endSession($conn); > >>>>>> > >>>>>> > >>>>>>$rowarray=sqlrcur_getRow($qcur,0); > >>>>>> > >>>>>>echo "there are {$rowarray[0]} open cursors"; > >>>>>> > >>>>>> > >>>>>>sqlrcur_free($qcur); > >>>>>>sqlrcon_free($conn); > >>>>>>?> > >>>>>></pre> > >>>>>>********************************************************************* > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>------------------------------------------------------- > >>>>>SF.Net email is sponsored by: > >>>>>Tame your development challenges with Apache's Geronimo App Server. Download > >>>>>it for free - -and be entered to win a 42" plasma tv or your very own > >>>>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>>>>_______________________________________________ > >>>>>Sqlrelay-discussion mailing list > >>>>>Sql...@li... > >>>>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>------------------------------------------------------- > >>>>This SF.Net email is sponsored by: > >>>>Power Architecture Resource Center: Free content, downloads, discussions, > >>>>and more. http://solutions.newsforge.com/ibmarch.tmpl > >>>>_______________________________________________ > >>>>Sqlrelay-discussion mailing list > >>>>Sql...@li... > >>>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > >>>> > >>>> > >>>> > >>>> > >>>> > >>> > >>>------------------------------------------------------- > >>>This SF.Net email is sponsored by the JBoss Inc. > >>>Get Certified Today * Register for a JBoss Training Course > >>>Free Certification Exam for All Training Attendees Through End of 2005 > >>>Visit http://www.jboss.com/services/certification for more information > >>>_______________________________________________ > >>>Sqlrelay-discussion mailing list > >>>Sql...@li... > >>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > >>> > >>> > >>> > >>> > >>> > >> > >>------------------------------------------------------- > >>SF.Net email is sponsored by: > >>Tame your development challenges with Apache's Geronimo App Server. Download > >>it for free - -and be entered to win a 42" plasma tv or your very own > >>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>_______________________________________________ > >>Sqlrelay-discussion mailing list > >>Sql...@li... > >>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > >> > >> > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion -- Dennis Bolton Manager, Web Engineering McGraw-Hill Learning Group Technology 425-806-3495 |
|
From: Matt F. <ma...@eq...> - 2005-11-04 18:54:51
|
So did this fix do nothing at all for you? The reason I say the fix helped is because it took 3x as long (6 hrs vs 2 hrs prior to applying the fix) before the oracle cursors climbed to an unacceptable level. If the fix is not working, the extra time it took sqlrelay to fail may be due to less traffic on the site at the time of testing. Perhaps this fix did not solve the issue. -Matt Dennis Bolton wrote: >Good luck Matt, > >I still get the same results as below with ref cursors left open. > >Dennis > >On Fri, 2005-11-04 at 12:48 -0500, Matt Flynn wrote: > > >>This seems to have helped the situation but not resolved it. I'm >>looking into other areas where cursors could be left open. >> >>David Muse wrote: >> >> >> >>>It took a while, but I believe I found the bug. >>> >>>You can fix it by editing src/connection/sqlrconnection/getbinds.C >>>and adding this line after line 110: >>> >>> curs->busy=true; >>> >>>That should take care of it. >>> >>>David Muse >>>dav...@fi... >>> >>>On Tue, 2005-10-11 at 15:58 -0400, Matt Flynn wrote: >>> >>> >>> >>> >>>>I am experiencing similar behavior. >>>> >>>>I am also using sqlrcur_getOutputBindCursor but I have not yet >>>>determined if this is the (only) cause of open cursors on the oracle >>>>server. Using PHP OCI I typically see around 8000 open cursors on one >>>>database for a particular db user. Using sqlr I watched the open >>>>cursors climb to 20000+ before shutting down sqlrelay. Oracle version >>>>is 9.2.0.5. >>>> >>>>Here is my instance configuration in sqlrelay.conf: >>>><instance id="dbinstance" port="9000" socket="/tmp/dbinstance.socket" >>>>dbase="oracle8" connections="50" maxconnections="200" maxqueuelength="0" >>>>growby="5" ttl="60" endofsession="commit" sessiontimeout="600" >>>>runasuser="sqlrelay" runasgroup="sqlrelay" cursors="3" >>>>authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none"> >>>> >>>>If cursors are left open on the Oracle server, does this mean a cursor >>>>is left hanging on the sqlrelay server? Meaning that my php app can no >>>>longer use that sqlrelay cursor? The behavior I am experiencing is that >>>>my sqlrelay connections are eventually all used up and my php app can no >>>>longer connect to the sqlrelay servers. With my current configuration >>>>the increase of sqlr-connection processes running on the server is >>>>progressive even though the web server traffic is relatively stable. My >>>>50 initial connections last maybe 15 minutes before they scale up and >>>>after about an hour to an hour and a half, all 200 sqlr-connection >>>>processes are running and the site can no longer connect to sqlr. >>>> >>>>I have taken extreme care, per >>>>http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php, to make sure ALL >>>>open sqlr connections and cursors are explicitly closed through calls to >>>>sqlrcur_free() and sqlrcon_free() before the php scripts end and I am >>>>positive this is not the issue. >>>> >>>>Any suggestions or further troubleshooting steps are greatly appreciated. >>>> >>>>Thanks, >>>> >>>>Matt >>>> >>>> >>>> >>>> >>>>Firstworks/4access wrote: >>>> >>>> >>>> >>>> >>>> >>>>>Looks like the server-side isn't cleaning up those cursors properly. >>>>>I'll take a look and see if I can figure out what's going on. >>>>> >>>>>Dave >>>>> >>>>>On Thu, 2005-09-22 at 11:01 -0700, Dennis Bolton wrote: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>Hi, >>>>>> >>>>>>When running the code below repeatedly I find that the >>>>>>cursor created in >>>>>> >>>>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); >>>>>> >>>>>>is never closed on the oracle server. After enough iterations the >>>>>>server will error with to many open cursors. >>>>>> >>>>>>I am running sqlrelay 3.6.4, but the same results occur on 3.6.2. >>>>>>PHP version is 4.4 . Oracle is 9.2g >>>>>> >>>>>>Here is a couple of consecutive sample results from this code: >>>>>> >>>>>>1. >>>>>>there are 711 open cursors >>>>>>Array >>>>>>( >>>>>> [StudentSortOrder] => 0 >>>>>> [ClassID] => 818 >>>>>> [Class] => Best Wisshes >>>>>> [ClassDesc] => >>>>>> [GradeLevel] => 4 >>>>>> [ActiveStudents] => 1 >>>>>>) >>>>>>there are 712 open cursors >>>>>> >>>>>>2. >>>>>>there are 712 open cursors >>>>>>Array >>>>>>( >>>>>> [StudentSortOrder] => 0 >>>>>> [ClassID] => 818 >>>>>> [Class] => Best Wisshes >>>>>> [ClassDesc] => >>>>>> [GradeLevel] => 4 >>>>>> [ActiveStudents] => 1 >>>>>>) >>>>>>there are 713 open cursors >>>>>> >>>>>> >>>>>> >>>>>>What might I be doing wrong? >>>>>> >>>>>> >>>>>>************************************************************************************* >>>>>><pre> >>>>>><?php >>>>>> >>>>>>$conn = >>>>>>sqlrcon_alloc('localhost','','/tmp/emgames.socket','webuser','thisisit',0,1); >>>>>>//print_r($conn); >>>>>> >>>>>>//print_r($relay); >>>>>> >>>>>>$countquery = "select count(*) from sys.gv_\$open_cursor"; >>>>>> >>>>>>$qcur = sqlrcur_alloc($conn); >>>>>>sqlrcur_sendquery($qcur,$countquery); >>>>>>sqlrcon_endSession($conn); >>>>>> >>>>>>$rowarray=sqlrcur_getRow($qcur,0); >>>>>> >>>>>>echo "there are {$rowarray[0]} open cursors\n"; >>>>>> >>>>>>$procedure = "BEGIN sa.s_classes_teacher(2559,:returncur); END;"; >>>>>> >>>>>>if($cur = sqlrcur_alloc($conn)){ >>>>>> >>>>>> sqlrcur_prepareQuery($cur,$procedure); >>>>>> >>>>>> sqlrcur_defineOutputBindCursor($cur,'returncur'); >>>>>> >>>>>> sqlrcur_executeQuery($cur); >>>>>> >>>>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); >>>>>> >>>>>> sqlrcur_fetchFromBindCursor($returncur); >>>>>> >>>>>> >>>>>> $numrows = sqlrcur_rowCount($returncur); >>>>>> $numcolumns = sqlrcur_colCount($returncur); >>>>>> >>>>>> >>>>>> // Get the column names and types >>>>>> for($i = 0; $i < $numcolumns; $i++){ >>>>>> $columnnames[$i] = sqlrcur_getColumnName($returncur,$i); >>>>>> $columntypes[$i] = sqlrcur_getColumnType($returncur,$i); >>>>>> } >>>>>> >>>>>> // Get each row column by column and store each of them in the Results >>>>>>array >>>>>> for($i = 0 ; $i < $numrows ; $i++) { >>>>>> for($j = 0 ; $j < $numcolumns; $j++){ >>>>>> $results[$i][$columnnames[$j]] = sqlrcur_getField($returncur,$i,$j); >>>>>> } >>>>>> } >>>>>>print_r($results[0]); >>>>>> sqlrcon_endsession($conn); >>>>>> sqlrcur_clearbinds($returncur); >>>>>> sqlrcur_free($returncur); >>>>>> sqlrcur_clearbinds($cur); >>>>>> sqlrcur_free($cur); >>>>>> >>>>>>} >>>>>>else { >>>>>> echo "couldn't open cursor"; >>>>>>} >>>>>> >>>>>>sqlrcur_sendquery($qcur,$countquery); >>>>>>sqlrcon_endSession($conn); >>>>>> >>>>>> >>>>>>$rowarray=sqlrcur_getRow($qcur,0); >>>>>> >>>>>>echo "there are {$rowarray[0]} open cursors"; >>>>>> >>>>>> >>>>>>sqlrcur_free($qcur); >>>>>>sqlrcon_free($conn); >>>>>>?> >>>>>></pre> >>>>>>********************************************************************* >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>------------------------------------------------------- >>>>>SF.Net email is sponsored by: >>>>>Tame your development challenges with Apache's Geronimo App Server. Download >>>>>it for free - -and be entered to win a 42" plasma tv or your very own >>>>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >>>>>_______________________________________________ >>>>>Sqlrelay-discussion mailing list >>>>>Sql...@li... >>>>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>------------------------------------------------------- >>>>This SF.Net email is sponsored by: >>>>Power Architecture Resource Center: Free content, downloads, discussions, >>>>and more. http://solutions.newsforge.com/ibmarch.tmpl >>>>_______________________________________________ >>>>Sqlrelay-discussion mailing list >>>>Sql...@li... >>>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >>>> >>>> >>>> >>>> >>>> >>> >>>------------------------------------------------------- >>>This SF.Net email is sponsored by the JBoss Inc. >>>Get Certified Today * Register for a JBoss Training Course >>>Free Certification Exam for All Training Attendees Through End of 2005 >>>Visit http://www.jboss.com/services/certification for more information >>>_______________________________________________ >>>Sqlrelay-discussion mailing list >>>Sql...@li... >>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >>> >>> >>> >>> >>> >> >>------------------------------------------------------- >>SF.Net email is sponsored by: >>Tame your development challenges with Apache's Geronimo App Server. Download >>it for free - -and be entered to win a 42" plasma tv or your very own >>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >>_______________________________________________ >>Sqlrelay-discussion mailing list >>Sql...@li... >>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> |
|
From: Dennis B. <den...@mc...> - 2005-11-04 18:16:32
|
Good luck Matt, I still get the same results as below with ref cursors left open. Dennis On Fri, 2005-11-04 at 12:48 -0500, Matt Flynn wrote: > This seems to have helped the situation but not resolved it. I'm > looking into other areas where cursors could be left open. > > David Muse wrote: > > >It took a while, but I believe I found the bug. > > > >You can fix it by editing src/connection/sqlrconnection/getbinds.C > >and adding this line after line 110: > > > > curs->busy=true; > > > >That should take care of it. > > > >David Muse > >dav...@fi... > > > >On Tue, 2005-10-11 at 15:58 -0400, Matt Flynn wrote: > > > > > >>I am experiencing similar behavior. > >> > >>I am also using sqlrcur_getOutputBindCursor but I have not yet > >>determined if this is the (only) cause of open cursors on the oracle > >>server. Using PHP OCI I typically see around 8000 open cursors on one > >>database for a particular db user. Using sqlr I watched the open > >>cursors climb to 20000+ before shutting down sqlrelay. Oracle version > >>is 9.2.0.5. > >> > >>Here is my instance configuration in sqlrelay.conf: > >><instance id="dbinstance" port="9000" socket="/tmp/dbinstance.socket" > >>dbase="oracle8" connections="50" maxconnections="200" maxqueuelength="0" > >>growby="5" ttl="60" endofsession="commit" sessiontimeout="600" > >>runasuser="sqlrelay" runasgroup="sqlrelay" cursors="3" > >>authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none"> > >> > >>If cursors are left open on the Oracle server, does this mean a cursor > >>is left hanging on the sqlrelay server? Meaning that my php app can no > >>longer use that sqlrelay cursor? The behavior I am experiencing is that > >>my sqlrelay connections are eventually all used up and my php app can no > >>longer connect to the sqlrelay servers. With my current configuration > >>the increase of sqlr-connection processes running on the server is > >>progressive even though the web server traffic is relatively stable. My > >>50 initial connections last maybe 15 minutes before they scale up and > >>after about an hour to an hour and a half, all 200 sqlr-connection > >>processes are running and the site can no longer connect to sqlr. > >> > >>I have taken extreme care, per > >>http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php, to make sure ALL > >>open sqlr connections and cursors are explicitly closed through calls to > >>sqlrcur_free() and sqlrcon_free() before the php scripts end and I am > >>positive this is not the issue. > >> > >>Any suggestions or further troubleshooting steps are greatly appreciated. > >> > >>Thanks, > >> > >>Matt > >> > >> > >> > >> > >>Firstworks/4access wrote: > >> > >> > >> > >>>Looks like the server-side isn't cleaning up those cursors properly. > >>>I'll take a look and see if I can figure out what's going on. > >>> > >>>Dave > >>> > >>>On Thu, 2005-09-22 at 11:01 -0700, Dennis Bolton wrote: > >>> > >>> > >>> > >>> > >>>>Hi, > >>>> > >>>>When running the code below repeatedly I find that the > >>>>cursor created in > >>>> > >>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > >>>> > >>>>is never closed on the oracle server. After enough iterations the > >>>>server will error with to many open cursors. > >>>> > >>>>I am running sqlrelay 3.6.4, but the same results occur on 3.6.2. > >>>>PHP version is 4.4 . Oracle is 9.2g > >>>> > >>>>Here is a couple of consecutive sample results from this code: > >>>> > >>>>1. > >>>>there are 711 open cursors > >>>>Array > >>>>( > >>>> [StudentSortOrder] => 0 > >>>> [ClassID] => 818 > >>>> [Class] => Best Wisshes > >>>> [ClassDesc] => > >>>> [GradeLevel] => 4 > >>>> [ActiveStudents] => 1 > >>>>) > >>>>there are 712 open cursors > >>>> > >>>>2. > >>>>there are 712 open cursors > >>>>Array > >>>>( > >>>> [StudentSortOrder] => 0 > >>>> [ClassID] => 818 > >>>> [Class] => Best Wisshes > >>>> [ClassDesc] => > >>>> [GradeLevel] => 4 > >>>> [ActiveStudents] => 1 > >>>>) > >>>>there are 713 open cursors > >>>> > >>>> > >>>> > >>>>What might I be doing wrong? > >>>> > >>>> > >>>>************************************************************************************* > >>>><pre> > >>>><?php > >>>> > >>>>$conn = > >>>>sqlrcon_alloc('localhost','','/tmp/emgames.socket','webuser','thisisit',0,1); > >>>>//print_r($conn); > >>>> > >>>>//print_r($relay); > >>>> > >>>>$countquery = "select count(*) from sys.gv_\$open_cursor"; > >>>> > >>>>$qcur = sqlrcur_alloc($conn); > >>>>sqlrcur_sendquery($qcur,$countquery); > >>>>sqlrcon_endSession($conn); > >>>> > >>>>$rowarray=sqlrcur_getRow($qcur,0); > >>>> > >>>>echo "there are {$rowarray[0]} open cursors\n"; > >>>> > >>>>$procedure = "BEGIN sa.s_classes_teacher(2559,:returncur); END;"; > >>>> > >>>>if($cur = sqlrcur_alloc($conn)){ > >>>> > >>>> sqlrcur_prepareQuery($cur,$procedure); > >>>> > >>>> sqlrcur_defineOutputBindCursor($cur,'returncur'); > >>>> > >>>> sqlrcur_executeQuery($cur); > >>>> > >>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > >>>> > >>>> sqlrcur_fetchFromBindCursor($returncur); > >>>> > >>>> > >>>> $numrows = sqlrcur_rowCount($returncur); > >>>> $numcolumns = sqlrcur_colCount($returncur); > >>>> > >>>> > >>>> // Get the column names and types > >>>> for($i = 0; $i < $numcolumns; $i++){ > >>>> $columnnames[$i] = sqlrcur_getColumnName($returncur,$i); > >>>> $columntypes[$i] = sqlrcur_getColumnType($returncur,$i); > >>>> } > >>>> > >>>> // Get each row column by column and store each of them in the Results > >>>>array > >>>> for($i = 0 ; $i < $numrows ; $i++) { > >>>> for($j = 0 ; $j < $numcolumns; $j++){ > >>>> $results[$i][$columnnames[$j]] = sqlrcur_getField($returncur,$i,$j); > >>>> } > >>>> } > >>>> print_r($results[0]); > >>>> sqlrcon_endsession($conn); > >>>> sqlrcur_clearbinds($returncur); > >>>> sqlrcur_free($returncur); > >>>> sqlrcur_clearbinds($cur); > >>>> sqlrcur_free($cur); > >>>> > >>>>} > >>>>else { > >>>> echo "couldn't open cursor"; > >>>>} > >>>> > >>>>sqlrcur_sendquery($qcur,$countquery); > >>>>sqlrcon_endSession($conn); > >>>> > >>>> > >>>>$rowarray=sqlrcur_getRow($qcur,0); > >>>> > >>>>echo "there are {$rowarray[0]} open cursors"; > >>>> > >>>> > >>>>sqlrcur_free($qcur); > >>>>sqlrcon_free($conn); > >>>>?> > >>>></pre> > >>>>********************************************************************* > >>>> > >>>> > >>>> > >>>> > >>> > >>>------------------------------------------------------- > >>>SF.Net email is sponsored by: > >>>Tame your development challenges with Apache's Geronimo App Server. Download > >>>it for free - -and be entered to win a 42" plasma tv or your very own > >>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >>>_______________________________________________ > >>>Sqlrelay-discussion mailing list > >>>Sql...@li... > >>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > >>> > >>> > >>> > >>> > >>> > >> > >>------------------------------------------------------- > >>This SF.Net email is sponsored by: > >>Power Architecture Resource Center: Free content, downloads, discussions, > >>and more. http://solutions.newsforge.com/ibmarch.tmpl > >>_______________________________________________ > >>Sqlrelay-discussion mailing list > >>Sql...@li... > >>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > >> > >> > >> > > > > > > > >------------------------------------------------------- > >This SF.Net email is sponsored by the JBoss Inc. > >Get Certified Today * Register for a JBoss Training Course > >Free Certification Exam for All Training Attendees Through End of 2005 > >Visit http://www.jboss.com/services/certification for more information > >_______________________________________________ > >Sqlrelay-discussion mailing list > >Sql...@li... > >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion -- Dennis Bolton Manager, Web Engineering McGraw-Hill Learning Group Technology 425-806-3495 |
|
From: Matt F. <ma...@eq...> - 2005-11-04 17:48:54
|
This seems to have helped the situation but not resolved it. I'm looking into other areas where cursors could be left open. David Muse wrote: >It took a while, but I believe I found the bug. > >You can fix it by editing src/connection/sqlrconnection/getbinds.C >and adding this line after line 110: > > curs->busy=true; > >That should take care of it. > >David Muse >dav...@fi... > >On Tue, 2005-10-11 at 15:58 -0400, Matt Flynn wrote: > > >>I am experiencing similar behavior. >> >>I am also using sqlrcur_getOutputBindCursor but I have not yet >>determined if this is the (only) cause of open cursors on the oracle >>server. Using PHP OCI I typically see around 8000 open cursors on one >>database for a particular db user. Using sqlr I watched the open >>cursors climb to 20000+ before shutting down sqlrelay. Oracle version >>is 9.2.0.5. >> >>Here is my instance configuration in sqlrelay.conf: >><instance id="dbinstance" port="9000" socket="/tmp/dbinstance.socket" >>dbase="oracle8" connections="50" maxconnections="200" maxqueuelength="0" >>growby="5" ttl="60" endofsession="commit" sessiontimeout="600" >>runasuser="sqlrelay" runasgroup="sqlrelay" cursors="3" >>authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none"> >> >>If cursors are left open on the Oracle server, does this mean a cursor >>is left hanging on the sqlrelay server? Meaning that my php app can no >>longer use that sqlrelay cursor? The behavior I am experiencing is that >>my sqlrelay connections are eventually all used up and my php app can no >>longer connect to the sqlrelay servers. With my current configuration >>the increase of sqlr-connection processes running on the server is >>progressive even though the web server traffic is relatively stable. My >>50 initial connections last maybe 15 minutes before they scale up and >>after about an hour to an hour and a half, all 200 sqlr-connection >>processes are running and the site can no longer connect to sqlr. >> >>I have taken extreme care, per >>http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php, to make sure ALL >>open sqlr connections and cursors are explicitly closed through calls to >>sqlrcur_free() and sqlrcon_free() before the php scripts end and I am >>positive this is not the issue. >> >>Any suggestions or further troubleshooting steps are greatly appreciated. >> >>Thanks, >> >>Matt >> >> >> >> >>Firstworks/4access wrote: >> >> >> >>>Looks like the server-side isn't cleaning up those cursors properly. >>>I'll take a look and see if I can figure out what's going on. >>> >>>Dave >>> >>>On Thu, 2005-09-22 at 11:01 -0700, Dennis Bolton wrote: >>> >>> >>> >>> >>>>Hi, >>>> >>>>When running the code below repeatedly I find that the >>>>cursor created in >>>> >>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); >>>> >>>>is never closed on the oracle server. After enough iterations the >>>>server will error with to many open cursors. >>>> >>>>I am running sqlrelay 3.6.4, but the same results occur on 3.6.2. >>>>PHP version is 4.4 . Oracle is 9.2g >>>> >>>>Here is a couple of consecutive sample results from this code: >>>> >>>>1. >>>>there are 711 open cursors >>>>Array >>>>( >>>> [StudentSortOrder] => 0 >>>> [ClassID] => 818 >>>> [Class] => Best Wisshes >>>> [ClassDesc] => >>>> [GradeLevel] => 4 >>>> [ActiveStudents] => 1 >>>>) >>>>there are 712 open cursors >>>> >>>>2. >>>>there are 712 open cursors >>>>Array >>>>( >>>> [StudentSortOrder] => 0 >>>> [ClassID] => 818 >>>> [Class] => Best Wisshes >>>> [ClassDesc] => >>>> [GradeLevel] => 4 >>>> [ActiveStudents] => 1 >>>>) >>>>there are 713 open cursors >>>> >>>> >>>> >>>>What might I be doing wrong? >>>> >>>> >>>>************************************************************************************* >>>><pre> >>>><?php >>>> >>>>$conn = >>>>sqlrcon_alloc('localhost','','/tmp/emgames.socket','webuser','thisisit',0,1); >>>>//print_r($conn); >>>> >>>>//print_r($relay); >>>> >>>>$countquery = "select count(*) from sys.gv_\$open_cursor"; >>>> >>>>$qcur = sqlrcur_alloc($conn); >>>>sqlrcur_sendquery($qcur,$countquery); >>>>sqlrcon_endSession($conn); >>>> >>>>$rowarray=sqlrcur_getRow($qcur,0); >>>> >>>>echo "there are {$rowarray[0]} open cursors\n"; >>>> >>>>$procedure = "BEGIN sa.s_classes_teacher(2559,:returncur); END;"; >>>> >>>>if($cur = sqlrcur_alloc($conn)){ >>>> >>>> sqlrcur_prepareQuery($cur,$procedure); >>>> >>>> sqlrcur_defineOutputBindCursor($cur,'returncur'); >>>> >>>> sqlrcur_executeQuery($cur); >>>> >>>> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); >>>> >>>> sqlrcur_fetchFromBindCursor($returncur); >>>> >>>> >>>> $numrows = sqlrcur_rowCount($returncur); >>>> $numcolumns = sqlrcur_colCount($returncur); >>>> >>>> >>>> // Get the column names and types >>>> for($i = 0; $i < $numcolumns; $i++){ >>>> $columnnames[$i] = sqlrcur_getColumnName($returncur,$i); >>>> $columntypes[$i] = sqlrcur_getColumnType($returncur,$i); >>>> } >>>> >>>> // Get each row column by column and store each of them in the Results >>>>array >>>> for($i = 0 ; $i < $numrows ; $i++) { >>>> for($j = 0 ; $j < $numcolumns; $j++){ >>>> $results[$i][$columnnames[$j]] = sqlrcur_getField($returncur,$i,$j); >>>> } >>>> } >>>> print_r($results[0]); >>>> sqlrcon_endsession($conn); >>>> sqlrcur_clearbinds($returncur); >>>> sqlrcur_free($returncur); >>>> sqlrcur_clearbinds($cur); >>>> sqlrcur_free($cur); >>>> >>>>} >>>>else { >>>> echo "couldn't open cursor"; >>>>} >>>> >>>>sqlrcur_sendquery($qcur,$countquery); >>>>sqlrcon_endSession($conn); >>>> >>>> >>>>$rowarray=sqlrcur_getRow($qcur,0); >>>> >>>>echo "there are {$rowarray[0]} open cursors"; >>>> >>>> >>>>sqlrcur_free($qcur); >>>>sqlrcon_free($conn); >>>>?> >>>></pre> >>>>********************************************************************* >>>> >>>> >>>> >>>> >>> >>>------------------------------------------------------- >>>SF.Net email is sponsored by: >>>Tame your development challenges with Apache's Geronimo App Server. Download >>>it for free - -and be entered to win a 42" plasma tv or your very own >>>Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >>>_______________________________________________ >>>Sqlrelay-discussion mailing list >>>Sql...@li... >>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >>> >>> >>> >>> >>> >> >>------------------------------------------------------- >>This SF.Net email is sponsored by: >>Power Architecture Resource Center: Free content, downloads, discussions, >>and more. http://solutions.newsforge.com/ibmarch.tmpl >>_______________________________________________ >>Sqlrelay-discussion mailing list >>Sql...@li... >>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> >> > > > >------------------------------------------------------- >This SF.Net email is sponsored by the JBoss Inc. >Get Certified Today * Register for a JBoss Training Course >Free Certification Exam for All Training Attendees Through End of 2005 >Visit http://www.jboss.com/services/certification for more information >_______________________________________________ >Sqlrelay-discussion mailing list >Sql...@li... >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > |
|
From: Vecchio, P. <PVe...@or...> - 2005-11-04 15:39:51
|
Thanks for the help. I did the "ldd = /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so" and it = came up with "no such file or directory" via commandline, but through my = SSHclient, I'm looking at the file. I musn't have the path set = properly. I'll continue to work on it. As far as the Zope path, I'm afraid it's my mistake for not being = entirely clear. The /lib/python is actually = /usr/src/zope-2.7.7/lib/python/. I had read that someone moved the = SQLRelay folder to /usr/src/zope-2.7.7/lib/python/ as opposed to = /usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA. Thought it was = worth a try. As far as structure and permissions, can you please confirm = for me that the SQLRelay folder does belong in ZSQLRelayDA and that all = folders should be set to 755 and all subsequent files (dtml, py, etc.) = should be 644? Seems I've had some issues installing other products = where the permissions were not getting set right. Thanks again, Peppi Vecchio | Web Developer=20 TECHNOLOGY SERVICES GROUP=20 -----Original Message----- From: sql...@li... [mailto:sql...@li...]On Behalf Of Firstworks/4access Sent: Friday, November 04, 2005 10:00 AM To: sql...@li... Subject: Re: [Sqlrelay-discussion] SQLRelay install issue Did you ever get this worked out? Usually what causes this problem is if libsqlrclient-0.34.r.so.1 isn't in your LD_LIBRARY_PATH or /etc/ld.so.conf file. If you're sure that it is and you're sure that you've run ldconfig (which you did), then the only other reason that it might not work is if the python module CSQLRelay.so was compiled with -rpath and libsqlrclient-0.34.4.so.1 isn't in that path. Try doing: ldd /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so and see what path it has for libsqlrclient-0.34.4.so.1 If the output of the ldd command isn't clear, send it to me and I'll take a look at it. There does also appear to be something strange going on with Zope. If you installed stuff under /lib/python, then why is Zope looking (and finding) stuff in /usr/src/zope-2.7.7/lib/python? David Muse dav...@fi... On Thu, 2005-10-20 at 14:22 -0400, Vecchio, Peppi wrote: > So close! Can't quite figure out the last leg of this install. > =20 > I have freetds-0.63 working - tested with the tsql command. > =20 > unixODBC working -tested with the isql command. > =20 > sqlr - working: > =20 > some@here bin]# sqlr-start -id mssql > =20 > Starting listener: > sqlr-listener -id mssql > -config /usr/local/firstworks/etc/sqlrelay.conf > =20 > Starting 3 connections to db1 : > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > =20 > Starting scaler: > sqlr-scaler -id mssql > -config /usr/local/firstworks/etc/sqlrelay.conf > =20 > Starting cache manager: > sqlr-cachemanager > =20 >=20 > Thanks to MP3.com for sponsoring:=20 > Clustered/Replicated database support. > Perl API. > =20 > All running on RedHad Linux Enterprise. Trying to finish connecting > to MSSQL Server. > =20 > When I installed SQLRelay, it put ZSQLRelayDA in /lib/python/Products. > I read somewhere that SQLRelay (in /lib/python/Products/ZSQLRelayDA/) > needs to be in /lib/python. So I tried it and have gotten this far. > Now when I restart zope with zopectl fg - this is the error I'm > seeing: > =20 > 2005-10-20T13:32:29 ERROR(200) Zope Could not import > Products.ZSQLRelayDA > Traceback (most recent call last): > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > in import_product > product=3D__import__(pname, global_dict, global_dict, silly) > File > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > line 7, in ? > import DA > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > line 7, in ? > from db import DB > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > line 1, in ? > import SQLRelay, DateTime > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > in ? > from SQLRelay import CSQLRelay > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > line 4, in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > line 10, in ? > from SQLRelay import CSQLRelay > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > file: No such file or directory > Traceback (most recent call last): > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 50, > in ? > run() > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 19, > in run > start_zope(opts.configroot) > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > 52, in start_zope > starter.startZope() > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > 231, in startZope > Zope.startup() > File "/usr/src/zope-2.7.7/lib/python/Zope/__init__.py", line 47, in > startup > _startup() > File "/usr/src/zope-2.7.7/lib/python/Zope/App/startup.py", line 45, > in startup > OFS.Application.import_products() > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 650, > in import_products > import_product(product_dir, product_name, raise_exc=3Ddebug_mode) > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > in import_product > product=3D__import__(pname, global_dict, global_dict, silly) > File > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > line 7, in ? > import DA > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > line 7, in ? > from db import DB > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > line 1, in ? > import SQLRelay, DateTime > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > in ? > from SQLRelay import CSQLRelay > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > line 4, in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > line 10, in ? > from SQLRelay import CSQLRelay > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > file: No such file or directory >=20 > =20 > libsqlrclient-0.36.r.so.1 is in /usr/local/firstworks/lib - this path > is also in ld.so.conf (of which I removed ld.so.cache and ran > ldconfig) > =20 > Yet I'm still getting this "cannot open shared object file" error. > =20 > Can anyone help shed some light on this for me? I would be eternally > grateful. > =20 > Thanks, >=20 >=20 > Peppi Vecchio | Web Developer=20 > TECHNOLOGY SERVICES GROUP=20 >=20 > =20 >=20 > ______________________________________________________________________ >=20 > The information contained in this message is privileged, confidential > and intended only for use of the individual or entity addressed above. > If you have received this communication in error, please immediately > notify us by reply and delete the same. Thank you.=20 >=20 ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. = Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: David E. <dav...@lb...> - 2005-11-04 15:03:51
|
Hi David, Thanks for replying. I've tried the replacement file, but still got the same compilation error. I did try inserting a $ in front of DBD::SQLRelay::SQL_CLOB and DBD::SQLRelay::SQL_BLOB on lines 282 and 294, and this did get rid of the compilation error. However, I don't know whether the resulting code does what it's supposed to do, because I'm not using CLOBs or BLOBs. Regards, David -----Original Message----- From: Firstworks/4access [mailto:dav...@fi...] Sent: 04 November 2005 14:48 To: sql...@li... Subject: Re: [Sqlrelay-discussion] Perl compilation error with 0.36.4 Hmm, looks like DBD::SQLReay::SQL_CLOB and SQL_BLOB aren't defined. Try replacing /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm with the attached file and see if it works. David Muse dav...@fi... On Thu, 2005-11-03 at 10:56 +0000, David Edwards wrote: > I am trying to use SQL Relay via the DBI driver from a simple Perl script, > but have run into a problem. On our development environment - using SQL > Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on our > production environment, trying to run the same script results in the > following Perl error: > > install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not > allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > Compilation failed in require at (eval 4) line 3. > > Is this an issue with our Perl, or a problem with the SQL Relay code? If the > former, does anyone have any suggestions as to how to solve the problem? > > Thanks, > > David > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-04 15:02:31
|
Sorry to take sooo long to get back on this one... Try http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz I ran into similar problems on a couple of other platforms. This pre-release should fix this problem. If it doesn't, let me know. David Muse dav...@fi... On Fri, 2005-10-14 at 16:51 +0800, Paul D. Walker wrote: > Hi All, > > I just tried compiling 0.37pre2 on a machine that had no complaints with > 0.36.4 and got the following error: > > === > In file included from debugfile.C:4: > debugfile.h:22: type specifier omitted for parameter > debugfile.h:22: parse error before `)' > debugfile.h:25: type specifier omitted for parameter > debugfile.h:25: parse error before `)' > debugfile.h:26: type specifier omitted for parameter > debugfile.h:26: parse error before `)' > debugfile.C: In method `void debugfile::debugPrint (const char *, int, > int)': > debugfile.C:74: call of overloaded `write(char *&, int32_t &, int32_t > &)' is ambiguous > /usr/local/site/firstworks/include/rudiments/logger.h:116: candidates are: > void > rudiments::logger::write (const char *, int, char) > /usr/local/site/firstworks/include/rudiments/logger.h:119: > void > rudiments::logger::write (const char *, int, long int) > /usr/local/site/firstworks/include/rudiments/logger.h:122: > void > rudiments::logger::write (const char *, int, double) > debugfile.C: At top level: > debugfile.C:84: type specifier omitted for parameter > debugfile.C:84: parse error before `)' > debugfile.C: In method `void debugfile::debugPrintBlob (...)': > debugfile.C:91: `uint32_t' undeclared (first use this function) > debugfile.C:91: (Each undeclared identifier is reported only once for > each function it appears in.) > debugfile.C:91: parse error before `=' > debugfile.C:91: `i' undeclared (first use this function) > debugfile.C:91: `length' undeclared (first use this function) > debugfile.C:92: `blob' undeclared (first use this function) > debugfile.C: At top level: > debugfile.C:110: type specifier omitted for parameter > debugfile.C:110: parse error before `)' > debugfile.C: In method `void debugfile::debugPrintClob (...)': > debugfile.C:116: parse error before `=' > debugfile.C:117: `clob' undeclared (first use this function) > === > > I checked the file is was complaining about (debugfile.h) and did a diff > against the previous version > > === > diff debugfile.h ../../../sqlrelay-0.36.4/src/util/debugfile.h > 17,26c17,22 > < void debugPrint(const char *name, int32_t tabs, > < const char *string); > < void debugPrint(const char *name, int32_t tabs, > < int32_t number); > < void debugPrint(const char *name, int32_t tabs, > < uint32_t number); > < void debugPrint(const char *name, int32_t tabs, > < double number); > < void debugPrintBlob(const char *blob, uint32_t length); > < void debugPrintClob(const char *clob, uint32_t length); > --- > > void debugPrint(const char *name, int tabs, > > const char *string); > > void debugPrint(const char *name, int tabs, long number); > > void debugPrint(const char *name, int tabs, double > number); > > void debugPrintBlob(const char *blob, unsigned long > length); > > void debugPrintClob(const char *clob, unsigned long > length); > === > > where int was refined as int32_t. The compiler here doesnt like it. > > Does anyone have any suggestions on how I can get around this problem? > > The system is a Redhat 7.3 based system using gcc 2.96. > > Any help would be appreciated. > > - Paul > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Power Architecture Resource Center: Free content, downloads, discussions, > and more. http://solutions.newsforge.com/ibmarch.tmpl > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-04 14:56:52
|
Did you ever get this worked out? Usually what causes this problem is if libsqlrclient-0.34.r.so.1 isn't in your LD_LIBRARY_PATH or /etc/ld.so.conf file. If you're sure that it is and you're sure that you've run ldconfig (which you did), then the only other reason that it might not work is if the python module CSQLRelay.so was compiled with -rpath and libsqlrclient-0.34.4.so.1 isn't in that path. Try doing: ldd /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so and see what path it has for libsqlrclient-0.34.4.so.1 If the output of the ldd command isn't clear, send it to me and I'll take a look at it. There does also appear to be something strange going on with Zope. If you installed stuff under /lib/python, then why is Zope looking (and finding) stuff in /usr/src/zope-2.7.7/lib/python? David Muse dav...@fi... On Thu, 2005-10-20 at 14:22 -0400, Vecchio, Peppi wrote: > So close! Can't quite figure out the last leg of this install. > > I have freetds-0.63 working - tested with the tsql command. > > unixODBC working -tested with the isql command. > > sqlr - working: > > some@here bin]# sqlr-start -id mssql > > Starting listener: > sqlr-listener -id mssql > -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting 3 connections to db1 : > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting scaler: > sqlr-scaler -id mssql > -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting cache manager: > sqlr-cachemanager > > > Thanks to MP3.com for sponsoring: > Clustered/Replicated database support. > Perl API. > > All running on RedHad Linux Enterprise. Trying to finish connecting > to MSSQL Server. > > When I installed SQLRelay, it put ZSQLRelayDA in /lib/python/Products. > I read somewhere that SQLRelay (in /lib/python/Products/ZSQLRelayDA/) > needs to be in /lib/python. So I tried it and have gotten this far. > Now when I restart zope with zopectl fg - this is the error I'm > seeing: > > 2005-10-20T13:32:29 ERROR(200) Zope Could not import > Products.ZSQLRelayDA > Traceback (most recent call last): > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > in import_product > product=__import__(pname, global_dict, global_dict, silly) > File > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > line 7, in ? > import DA > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > line 7, in ? > from db import DB > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > line 1, in ? > import SQLRelay, DateTime > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > in ? > from SQLRelay import CSQLRelay > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > line 4, in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > line 10, in ? > from SQLRelay import CSQLRelay > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > file: No such file or directory > Traceback (most recent call last): > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 50, > in ? > run() > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 19, > in run > start_zope(opts.configroot) > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > 52, in start_zope > starter.startZope() > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > 231, in startZope > Zope.startup() > File "/usr/src/zope-2.7.7/lib/python/Zope/__init__.py", line 47, in > startup > _startup() > File "/usr/src/zope-2.7.7/lib/python/Zope/App/startup.py", line 45, > in startup > OFS.Application.import_products() > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 650, > in import_products > import_product(product_dir, product_name, raise_exc=debug_mode) > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > in import_product > product=__import__(pname, global_dict, global_dict, silly) > File > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > line 7, in ? > import DA > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > line 7, in ? > from db import DB > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > line 1, in ? > import SQLRelay, DateTime > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > in ? > from SQLRelay import CSQLRelay > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > line 4, in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > line 10, in ? > from SQLRelay import CSQLRelay > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > file: No such file or directory > > > libsqlrclient-0.36.r.so.1 is in /usr/local/firstworks/lib - this path > is also in ld.so.conf (of which I removed ld.so.cache and ran > ldconfig) > > Yet I'm still getting this "cannot open shared object file" error. > > Can anyone help shed some light on this for me? I would be eternally > grateful. > > Thanks, > > > Peppi Vecchio | Web Developer > TECHNOLOGY SERVICES GROUP > > > > ______________________________________________________________________ > > The information contained in this message is privileged, confidential > and intended only for use of the individual or entity addressed above. > If you have received this communication in error, please immediately > notify us by reply and delete the same. Thank you. > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-04 14:44:36
|
Hmm, looks like DBD::SQLReay::SQL_CLOB and SQL_BLOB aren't defined. Try replacing /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm with the attached file and see if it works. David Muse dav...@fi... On Thu, 2005-11-03 at 10:56 +0000, David Edwards wrote: > I am trying to use SQL Relay via the DBI driver from a simple Perl script, > but have run into a problem. On our development environment - using SQL > Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on our > production environment, trying to run the same script results in the > following Perl error: > > install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not > allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use at > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > Compilation failed in require at (eval 4) line 3. > > Is this an issue with our Perl, or a problem with the SQL Relay code? If the > former, does anyone have any suggestions as to how to solve the problem? > > Thanks, > > David > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-04 14:39:22
|
I'm not aware of any way to do that currently. I've been working on getting various components of SQL Relay working on windows though, so eventually it should be possible to write an ODBC driver that access can use. But it's still a little way off. David Muse dav...@fi... On Fri, 2005-11-04 at 12:19 +0100, Raphael Bauduin wrote: > Hi, > > is it possible to connect to sqlrelay from MS Access? > any info out there about the best way to achieve that? > > Thanks. > > Raph > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Raphael B. <rb...@gm...> - 2005-11-04 11:19:44
|
Hi, is it possible to connect to sqlrelay from MS Access? any info out there about the best way to achieve that? Thanks. Raph |
|
From: David E. <dav...@lb...> - 2005-11-03 10:56:32
|
I am trying to use SQL Relay via the DBI driver from a simple Perl script, but have run into a problem. On our development environment - using SQL Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on our production environment, trying to run the same script results in the following Perl error: install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in use at /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use at /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in use at /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in use at /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. Compilation failed in require at (eval 4) line 3. Is this an issue with our Perl, or a problem with the SQL Relay code? If the former, does anyone have any suggestions as to how to solve the problem? Thanks, David |
|
From: Andrew L. <ala...@bo...> - 2005-11-02 22:46:21
|
I have a setup similar to yours, Seth. I noticed that the configure
script looks for the library libcore10.a to determine that you have
Oracle 10g, but then once that library is found adds -lclntsh to the
linker's command line, so running the following command
touch $ORACLE_HOME/lib/libcore10.a
before running configure will allow the sqlrealy Oracle connector to
be built.
(I'd recommend removing the touch file afterwards, so no one would
get confused.)
|
|
From: David M. <dav...@fi...> - 2005-10-29 04:34:23
|
Hello SQL Relayers, There's a new prerelease available at http://www.firstworks.com/sqlrelay-0.37pre3.tar.gz It contains updated versions of rudiments and sqlrelay. This prerelease should fix the problem people have been reporting with freetds where it keeps saying "failed to start a new operation with results pending" or something like that. Some other bugs are fixed and a few other features too, see the ChangeLog file for them. 0.37 is getting pretty close now. Dave dav...@fi... |
|
From: Dennis B. <den...@mc...> - 2005-10-26 23:39:46
|
Thanks David! I'll give it a try. Dennis On Wed, 2005-10-26 at 19:24 -0400, David Muse wrote: > It took a while, but I believe I found the bug. > > You can fix it by editing src/connection/sqlrconnection/getbinds.C > and adding this line after line 110: > > curs->busy=true; > > That should take care of it. > > David Muse > dav...@fi... > > On Tue, 2005-10-11 at 15:58 -0400, Matt Flynn wrote: > > I am experiencing similar behavior. > > > > I am also using sqlrcur_getOutputBindCursor but I have not yet > > determined if this is the (only) cause of open cursors on the oracle > > server. Using PHP OCI I typically see around 8000 open cursors on one > > database for a particular db user. Using sqlr I watched the open > > cursors climb to 20000+ before shutting down sqlrelay. Oracle version > > is 9.2.0.5. > > > > Here is my instance configuration in sqlrelay.conf: > > <instance id="dbinstance" port="9000" socket="/tmp/dbinstance.socket" > > dbase="oracle8" connections="50" maxconnections="200" maxqueuelength="0" > > growby="5" ttl="60" endofsession="commit" sessiontimeout="600" > > runasuser="sqlrelay" runasgroup="sqlrelay" cursors="3" > > authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none"> > > > > If cursors are left open on the Oracle server, does this mean a cursor > > is left hanging on the sqlrelay server? Meaning that my php app can no > > longer use that sqlrelay cursor? The behavior I am experiencing is that > > my sqlrelay connections are eventually all used up and my php app can no > > longer connect to the sqlrelay servers. With my current configuration > > the increase of sqlr-connection processes running on the server is > > progressive even though the web server traffic is relatively stable. My > > 50 initial connections last maybe 15 minutes before they scale up and > > after about an hour to an hour and a half, all 200 sqlr-connection > > processes are running and the site can no longer connect to sqlr. > > > > I have taken extreme care, per > > http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php, to make sure ALL > > open sqlr connections and cursors are explicitly closed through calls to > > sqlrcur_free() and sqlrcon_free() before the php scripts end and I am > > positive this is not the issue. > > > > Any suggestions or further troubleshooting steps are greatly appreciated. > > > > Thanks, > > > > Matt > > > > > > > > > > Firstworks/4access wrote: > > > > >Looks like the server-side isn't cleaning up those cursors properly. > > >I'll take a look and see if I can figure out what's going on. > > > > > >Dave > > > > > >On Thu, 2005-09-22 at 11:01 -0700, Dennis Bolton wrote: > > > > > > > > >>Hi, > > >> > > >>When running the code below repeatedly I find that the > > >>cursor created in > > >> > > >> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > > >> > > >>is never closed on the oracle server. After enough iterations the > > >>server will error with to many open cursors. > > >> > > >>I am running sqlrelay 3.6.4, but the same results occur on 3.6.2. > > >>PHP version is 4.4 . Oracle is 9.2g > > >> > > >>Here is a couple of consecutive sample results from this code: > > >> > > >>1. > > >>there are 711 open cursors > > >>Array > > >>( > > >> [StudentSortOrder] => 0 > > >> [ClassID] => 818 > > >> [Class] => Best Wisshes > > >> [ClassDesc] => > > >> [GradeLevel] => 4 > > >> [ActiveStudents] => 1 > > >>) > > >>there are 712 open cursors > > >> > > >>2. > > >>there are 712 open cursors > > >>Array > > >>( > > >> [StudentSortOrder] => 0 > > >> [ClassID] => 818 > > >> [Class] => Best Wisshes > > >> [ClassDesc] => > > >> [GradeLevel] => 4 > > >> [ActiveStudents] => 1 > > >>) > > >>there are 713 open cursors > > >> > > >> > > >> > > >>What might I be doing wrong? > > >> > > >> > > >>************************************************************************************* > > >><pre> > > >><?php > > >> > > >>$conn = > > >>sqlrcon_alloc('localhost','','/tmp/emgames.socket','webuser','thisisit',0,1); > > >>//print_r($conn); > > >> > > >>//print_r($relay); > > >> > > >>$countquery = "select count(*) from sys.gv_\$open_cursor"; > > >> > > >>$qcur = sqlrcur_alloc($conn); > > >>sqlrcur_sendquery($qcur,$countquery); > > >>sqlrcon_endSession($conn); > > >> > > >>$rowarray=sqlrcur_getRow($qcur,0); > > >> > > >>echo "there are {$rowarray[0]} open cursors\n"; > > >> > > >>$procedure = "BEGIN sa.s_classes_teacher(2559,:returncur); END;"; > > >> > > >>if($cur = sqlrcur_alloc($conn)){ > > >> > > >> sqlrcur_prepareQuery($cur,$procedure); > > >> > > >> sqlrcur_defineOutputBindCursor($cur,'returncur'); > > >> > > >> sqlrcur_executeQuery($cur); > > >> > > >> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > > >> > > >> sqlrcur_fetchFromBindCursor($returncur); > > >> > > >> > > >> $numrows = sqlrcur_rowCount($returncur); > > >> $numcolumns = sqlrcur_colCount($returncur); > > >> > > >> > > >> // Get the column names and types > > >> for($i = 0; $i < $numcolumns; $i++){ > > >> $columnnames[$i] = sqlrcur_getColumnName($returncur,$i); > > >> $columntypes[$i] = sqlrcur_getColumnType($returncur,$i); > > >> } > > >> > > >> // Get each row column by column and store each of them in the Results > > >>array > > >> for($i = 0 ; $i < $numrows ; $i++) { > > >> for($j = 0 ; $j < $numcolumns; $j++){ > > >> $results[$i][$columnnames[$j]] = sqlrcur_getField($returncur,$i,$j); > > >> } > > >> } > > >> print_r($results[0]); > > >> sqlrcon_endsession($conn); > > >> sqlrcur_clearbinds($returncur); > > >> sqlrcur_free($returncur); > > >> sqlrcur_clearbinds($cur); > > >> sqlrcur_free($cur); > > >> > > >> } > > >> else { > > >> echo "couldn't open cursor"; > > >> } > > >> > > >>sqlrcur_sendquery($qcur,$countquery); > > >>sqlrcon_endSession($conn); > > >> > > >> > > >>$rowarray=sqlrcur_getRow($qcur,0); > > >> > > >>echo "there are {$rowarray[0]} open cursors"; > > >> > > >> > > >>sqlrcur_free($qcur); > > >>sqlrcon_free($conn); > > >>?> > > >></pre> > > >>********************************************************************* > > >> > > >> > > > > > > > > > > > >------------------------------------------------------- > > >SF.Net email is sponsored by: > > >Tame your development challenges with Apache's Geronimo App Server. Download > > >it for free - -and be entered to win a 42" plasma tv or your very own > > >Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > >_______________________________________________ > > >Sqlrelay-discussion mailing list > > >Sql...@li... > > >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: > > Power Architecture Resource Center: Free content, downloads, discussions, > > and more. http://solutions.newsforge.com/ibmarch.tmpl > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the JBoss Inc. > Get Certified Today * Register for a JBoss Training Course > Free Certification Exam for All Training Attendees Through End of 2005 > Visit http://www.jboss.com/services/certification for more information > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion -- Dennis Bolton Manager, Web Engineering McGraw-Hill Learning Group Technology 425-806-3495 |
|
From: David M. <dav...@fi...> - 2005-10-26 23:21:24
|
It took a while, but I believe I found the bug. You can fix it by editing src/connection/sqlrconnection/getbinds.C and adding this line after line 110: curs->busy=true; That should take care of it. David Muse dav...@fi... On Tue, 2005-10-11 at 15:58 -0400, Matt Flynn wrote: > I am experiencing similar behavior. > > I am also using sqlrcur_getOutputBindCursor but I have not yet > determined if this is the (only) cause of open cursors on the oracle > server. Using PHP OCI I typically see around 8000 open cursors on one > database for a particular db user. Using sqlr I watched the open > cursors climb to 20000+ before shutting down sqlrelay. Oracle version > is 9.2.0.5. > > Here is my instance configuration in sqlrelay.conf: > <instance id="dbinstance" port="9000" socket="/tmp/dbinstance.socket" > dbase="oracle8" connections="50" maxconnections="200" maxqueuelength="0" > growby="5" ttl="60" endofsession="commit" sessiontimeout="600" > runasuser="sqlrelay" runasgroup="sqlrelay" cursors="3" > authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none"> > > If cursors are left open on the Oracle server, does this mean a cursor > is left hanging on the sqlrelay server? Meaning that my php app can no > longer use that sqlrelay cursor? The behavior I am experiencing is that > my sqlrelay connections are eventually all used up and my php app can no > longer connect to the sqlrelay servers. With my current configuration > the increase of sqlr-connection processes running on the server is > progressive even though the web server traffic is relatively stable. My > 50 initial connections last maybe 15 minutes before they scale up and > after about an hour to an hour and a half, all 200 sqlr-connection > processes are running and the site can no longer connect to sqlr. > > I have taken extreme care, per > http://sqlrelay.sourceforge.net/sqlrelay/faq.html#php, to make sure ALL > open sqlr connections and cursors are explicitly closed through calls to > sqlrcur_free() and sqlrcon_free() before the php scripts end and I am > positive this is not the issue. > > Any suggestions or further troubleshooting steps are greatly appreciated. > > Thanks, > > Matt > > > > > Firstworks/4access wrote: > > >Looks like the server-side isn't cleaning up those cursors properly. > >I'll take a look and see if I can figure out what's going on. > > > >Dave > > > >On Thu, 2005-09-22 at 11:01 -0700, Dennis Bolton wrote: > > > > > >>Hi, > >> > >>When running the code below repeatedly I find that the > >>cursor created in > >> > >> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > >> > >>is never closed on the oracle server. After enough iterations the > >>server will error with to many open cursors. > >> > >>I am running sqlrelay 3.6.4, but the same results occur on 3.6.2. > >>PHP version is 4.4 . Oracle is 9.2g > >> > >>Here is a couple of consecutive sample results from this code: > >> > >>1. > >>there are 711 open cursors > >>Array > >>( > >> [StudentSortOrder] => 0 > >> [ClassID] => 818 > >> [Class] => Best Wisshes > >> [ClassDesc] => > >> [GradeLevel] => 4 > >> [ActiveStudents] => 1 > >>) > >>there are 712 open cursors > >> > >>2. > >>there are 712 open cursors > >>Array > >>( > >> [StudentSortOrder] => 0 > >> [ClassID] => 818 > >> [Class] => Best Wisshes > >> [ClassDesc] => > >> [GradeLevel] => 4 > >> [ActiveStudents] => 1 > >>) > >>there are 713 open cursors > >> > >> > >> > >>What might I be doing wrong? > >> > >> > >>************************************************************************************* > >><pre> > >><?php > >> > >>$conn = > >>sqlrcon_alloc('localhost','','/tmp/emgames.socket','webuser','thisisit',0,1); > >>//print_r($conn); > >> > >>//print_r($relay); > >> > >>$countquery = "select count(*) from sys.gv_\$open_cursor"; > >> > >>$qcur = sqlrcur_alloc($conn); > >>sqlrcur_sendquery($qcur,$countquery); > >>sqlrcon_endSession($conn); > >> > >>$rowarray=sqlrcur_getRow($qcur,0); > >> > >>echo "there are {$rowarray[0]} open cursors\n"; > >> > >>$procedure = "BEGIN sa.s_classes_teacher(2559,:returncur); END;"; > >> > >>if($cur = sqlrcur_alloc($conn)){ > >> > >> sqlrcur_prepareQuery($cur,$procedure); > >> > >> sqlrcur_defineOutputBindCursor($cur,'returncur'); > >> > >> sqlrcur_executeQuery($cur); > >> > >> $returncur = sqlrcur_getOutputBindCursor($cur,'returncur'); > >> > >> sqlrcur_fetchFromBindCursor($returncur); > >> > >> > >> $numrows = sqlrcur_rowCount($returncur); > >> $numcolumns = sqlrcur_colCount($returncur); > >> > >> > >> // Get the column names and types > >> for($i = 0; $i < $numcolumns; $i++){ > >> $columnnames[$i] = sqlrcur_getColumnName($returncur,$i); > >> $columntypes[$i] = sqlrcur_getColumnType($returncur,$i); > >> } > >> > >> // Get each row column by column and store each of them in the Results > >>array > >> for($i = 0 ; $i < $numrows ; $i++) { > >> for($j = 0 ; $j < $numcolumns; $j++){ > >> $results[$i][$columnnames[$j]] = sqlrcur_getField($returncur,$i,$j); > >> } > >> } > >> print_r($results[0]); > >> sqlrcon_endsession($conn); > >> sqlrcur_clearbinds($returncur); > >> sqlrcur_free($returncur); > >> sqlrcur_clearbinds($cur); > >> sqlrcur_free($cur); > >> > >> } > >> else { > >> echo "couldn't open cursor"; > >> } > >> > >>sqlrcur_sendquery($qcur,$countquery); > >>sqlrcon_endSession($conn); > >> > >> > >>$rowarray=sqlrcur_getRow($qcur,0); > >> > >>echo "there are {$rowarray[0]} open cursors"; > >> > >> > >>sqlrcur_free($qcur); > >>sqlrcon_free($conn); > >>?> > >></pre> > >>********************************************************************* > >> > >> > > > > > > > >------------------------------------------------------- > >SF.Net email is sponsored by: > >Tame your development challenges with Apache's Geronimo App Server. Download > >it for free - -and be entered to win a 42" plasma tv or your very own > >Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > >_______________________________________________ > >Sqlrelay-discussion mailing list > >Sql...@li... > >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Power Architecture Resource Center: Free content, downloads, discussions, > and more. http://solutions.newsforge.com/ibmarch.tmpl > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Seth G. <sgo...@op...> - 2005-10-26 21:41:51
|
One more thing, the sysliblist file does not seem to work. It must have come from another computer. There is a reference to a directory that I do not have on my machine. --Seth Seth Gottlieb wrote: > Hi, > > I am trying to run ./configure and include Oracle 10g support. I have > installed the Oracle thin client (plus a bunch of additional libraries > and headers that I needed to install compile DCOracle2 with) and It does > not seem to work. Could you tell me what libraries it is looking for? > > Here is my ./configure command: > > ./configure --with-oracle-home=$ORACLE_HOME > > where $ORACLE_HOME has the following: > > classes12.jar libnnz10.so libsqlplusic.so sdk > glogin.sql libocci.so.10.1 libsqlplus.so sqlplus > lib libociei.so ojdbc14.jar tnsnames.ora > libclntsh.so.10.1 libocijdbc10.so rdbms > libiodbc.so libodbc.so README_IC.htm > > lib: > cdemo81.c libclntsh.so.10.1 libocci.so.10.1 libsqlplus.so > ojdbc14.jar > classes12.jar libheteroxa10.so libociei.so occidemod.sql > orai18n.jar > demo.mk libiodbc.so libocijdbc10.so occidemo.sql > sysliblist > glogin.sql libnnz10.so libodbc.so occidml.cpp > libclntsh.so libocci.so libsqlplusic.so ocrs12.jar > > > (I recognize the redundancy) > > Anything else I should add? > > BTW, I didn't have a sysliblist in my lib directory so I copied it from > my sdk directory. > > --Seth > -- Seth Gottlieb Optaros, Inc. 60 Canal Street Boston, MA 02114 e: sgo...@op... v: 617.227.1855 ext. 107 f: 617.227.1755 m: 617.852.2956 |
16 messages has been excluded from this view by a project administrator.
