sqlrelay-discussion Mailing List for SQL Relay (Page 17)
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: Jerome M. <jer...@gm...> - 2010-01-20 19:15:32
|
sqlr-listener wont start...
did a debug..
....
creating shared memory and semaphores
id filename:
/usr/local/firstworks/var/sqlrelay/tmp/ipc/staging
creating shared memory...
creating semaphores...
--------------------
conf..
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<instance id="staging" port="9000" socket="/tmp/mysqltest.socket"
dbase="mysql" connections="3" maxconnections="5" maxqueuelength="0"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
handoff="pass" debug="listener_and_connection">
<users>
<user user="stagingconn" password="testdd"/>
</users>
<connections>
<connection connectionid="staging"
string="host=testbox;user=staginguser;password=test;db=staging" metric="1"/>
</connections>
</instance>
</instances>
|
|
From: hiroaki k. <hk...@cp...> - 2009-12-22 04:31:43
|
Hello. I found following script returns undefined value in bound inout variable: $id ... my $sth = $dbh->prepare(<<END); insert into nr_test(nr_dir) values(?) returning nr_test.rowid into ? END my $place; $sth->bind_param(++$place, $dir); $sth->bind_param_inout(++$place, \ my $id, 64); ... Note: Above worked fine on sqlrelay-0.37.1. After some stracing, I finally found DBD::SQLRelay::st::execute calls $cursor->clearBinds *before* $cursor->getOutputBindString. Attached patch will fix this problem. |
|
From: Renat S. <sr...@st...> - 2009-11-12 13:55:38
|
I have strange statistics on the one of our servers: Open Server Connections: 15 Opened Server Connections: 52643 Open Client Connections: 63 Opened Client Connections: 417874 Open Server Cursors: 33 Opened Server Cursors: 384360 Times New Cursor Used: 0 Times Cursor Reused: 7330868 Total Queries: 3943572 Total Errors: 186 Forked Listeners: 9 "ps" says there were 15 sqlr-connection-oracle8, 1 sqlr-listener and 1 sqlr-scaler Open Server Cursors should be 30 because of cursors="2" in config Open Client Connections should be 15 - there is no forked listeners in ps output Forked Listeners should be 0 - there is no forked listeners in ps output Where am I wrong? -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Renat S. <sr...@st...> - 2009-11-12 13:55:32
|
I'm afraid I've found the cause of strange statistics look at this code in sqllistener.C : shmdata *ptr=(shmdata *)staticlistener->idmemory->getPointer(); ptr->statistics.forked_listeners--; If 2 processes simultaniously get access to shared memory and, for example, in this moment forked_listeners = 10, then they both decrease this value to 9 and put back to shared memory. As result would be 9 instead of 8. Solution ids obvious: semaphores should be used to access shared memory. For example: shmdata *ptr=(shmdata *)staticlistener->idmemory->getPointer(); sem_t *mutex=staticlistener->idmemory->getSemaphore(); sem_wait(mutex); ptr->statistics.forked_listeners--; sem_post(mutex); -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Dan H. <Dan...@Me...> - 2009-10-15 00:32:55
|
Ah, ok! Thanks ________________________________ From: David Muse [mailto:dav...@fi...] Sent: Thursday, 15 October 2009 13:10 To: Discussion of topics related to SQL Relay Subject: Re: [Sqlrelay-discussion] Perl and SQLRelay There should be a SQLRelay.pm.in file that gets turned into SQLRelay.pm during the build. Look in the src/api/perl/DBD directory. Dave On Oct 14, 2009, at 6:20 PM, "Dan Horne" <Dan...@Me...> wrote: Thanks for your reply, Dave. I can't see DBD/SQLRelay.pm in the tarball. What am I missing? Dan ________________________________ From: David MuseSent: Thursday, 15 October 2009 10:47 To: <mailto:sql...@li...> sql...@li... Subject: Re: [Sqlrelay-discussion] Perl and SQLRelay The DBI driver is part of the SQL Relay distribution. If you build and install it, the DBI driver will be installed too. I've always meant to get all of the perl-SQL Relay stuff on cpan, but so many things, so little time... David Muse <mailto:dav...@fi...> dav...@fi... On 10/11/2009 09:01 PM, Dan Horne wrote: Hi Just swung by cpan to install DBD::SQLRelay, but it's not there. Backpan shows a version from 2000. Is DBD::SQLRelay deprecated? Thanks Dan Attention: This email together with any attachments is confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author and will not necessarily reflect the views of Meridian Energy. ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ************* ------------------------------------------------------------------------ ------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! <http://p.sf.net/sfu/devconference> http://p.sf.net/sfu/devconference _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting <http://www.doteasy.com> http://www.doteasy.com _______________________________________________ Sqlrelay-discussion mailing list <mailto:Sql...@li...> Sql...@li... <https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting <http://www.doteasy.com> http://www.doteasy.com Attention: This email together with any attachments is confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author and will not necessarily reflect the views of Meridian Energy. ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ************* ------------------------------------------------------------------------ ------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com Attention: This email together with any attachments is confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author and will not necessarily reflect the views of Meridian Energy. ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ************* |
|
From: David M. <dav...@fi...> - 2009-10-15 00:10:08
|
There should be a SQLRelay.pm.in file that gets turned into SQLRelay.pm during the build. Look in the src/api/perl/DBD directory. Dave On Oct 14, 2009, at 6:20 PM, "Dan Horne" <Dan...@Me...> wrote: > Thanks for your reply, Dave. I can't see DBD/SQLRelay.pm in the > tarball. What am I missing? > > Dan > > From: David MuseSent: Thursday, 15 October 2009 10:47 > To: sql...@li... > Subject: Re: [Sqlrelay-discussion] Perl and SQLRelay > > The DBI driver is part of the SQL Relay distribution. If you build > and install it, the DBI driver will be installed too. > > I've always meant to get all of the perl-SQL Relay stuff on cpan, > but so many things, so little time... > > David Muse > dav...@fi... > > On 10/11/2009 09:01 PM, Dan Horne wrote: >> >> Hi >> >> Just swung by cpan to install DBD::SQLRelay, but it's not there. >> Backpan shows a version from 2000. Is DBD::SQLRelay deprecated? >> >> Thanks >> >> Dan >> Attention: >> >> This email together with any attachments is confidential. If you >> are not the intended recipient please delete the message and notify >> the sender. Any views or opinions presented are solely those of the >> author and will not necessarily reflect the views of Meridian Energy. >> >> >> ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING >> ************* >> >> >> >> --- >> --- >> --- >> --------------------------------------------------------------------- >> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >> is the only developer event you need to attend this year. Jumpstart >> your >> developing skills, take BlackBerry mobile applications to market >> and stay >> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >> http://p.sf.net/sfu/devconference >> >> _______________________________________________________ >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting >> http://www.doteasy.com >> >> _______________________________________________ >> Sqlrelay-discussion mailing list >> Sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> >> _______________________________________________________ >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting >> http://www.doteasy.com > > Attention: > > This email together with any attachments is confidential. If you are > not the intended recipient please delete the message and notify the > sender. Any views or opinions presented are solely those of the > author and will not necessarily reflect the views of Meridian Energy. > > > ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING > ************* > > > --- > --- > --- > --------------------------------------------------------------------- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart > your > developing skills, take BlackBerry mobile applications to market and > stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com |
|
From: Dan H. <Dan...@Me...> - 2009-10-14 22:21:12
|
Thanks for your reply, Dave. I can't see DBD/SQLRelay.pm in the tarball. What am I missing? Dan ________________________________ From: David MuseSent: Thursday, 15 October 2009 10:47 To: sql...@li... Subject: Re: [Sqlrelay-discussion] Perl and SQLRelay The DBI driver is part of the SQL Relay distribution. If you build and install it, the DBI driver will be installed too. I've always meant to get all of the perl-SQL Relay stuff on cpan, but so many things, so little time... David Muse dav...@fi... On 10/11/2009 09:01 PM, Dan Horne wrote: Hi Just swung by cpan to install DBD::SQLRelay, but it's not there. Backpan shows a version from 2000. Is DBD::SQLRelay deprecated? Thanks Dan Attention: This email together with any attachments is confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author and will not necessarily reflect the views of Meridian Energy. ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ************* ------------------------------------------------------------------------ ------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com Attention: This email together with any attachments is confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author and will not necessarily reflect the views of Meridian Energy. ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ************* |
|
From: David M. <dav...@fi...> - 2009-10-14 21:47:26
|
The DBI driver is part of the SQL Relay distribution. If you build and install it, the DBI driver will be installed too. I've always meant to get all of the perl-SQL Relay stuff on cpan, but so many things, so little time... David Muse dav...@fi... On 10/11/2009 09:01 PM, Dan Horne wrote: > Hi > Just swung by cpan to install DBD::SQLRelay, but it's not there. > Backpan shows a version from 2000. Is DBD::SQLRelay deprecated? > Thanks > Dan > *Attention:* > This email together with any attachments is confidential. If you are > not the intended recipient please delete the message and notify the > sender. Any views or opinions presented are solely those of the author > and will not necessarily reflect the views of Meridian Energy. > ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING > ************* > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com |
|
From: Dan H. <Dan...@Me...> - 2009-10-12 01:17:11
|
Hi Just swung by cpan to install DBD::SQLRelay, but it's not there. Backpan shows a version from 2000. Is DBD::SQLRelay deprecated? Thanks Dan Attention: This email together with any attachments is confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author and will not necessarily reflect the views of Meridian Energy. ************** PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ************* |
|
From: Cameron L. <cla...@gm...> - 2009-09-17 14:24:29
|
On Thu, Sep 17, 2009 at 3:58 AM, Henrik HJ <tes...@li...> wrote:
> Can you please help me. I can't connect to SQLRelay, when I try to
> connect. The client freeze and stop working.
>
> I have 4 server:
> Serv1: 10.131.50.191 Database #1
> Serv2: 10.131.50.192 Database #2
> Serv3: 10.131.50.193 SQLRelay
> Serv4: 10.131.50.190 This is the server who have the client install.
> ...
>
The best help *I* can give you is to illustrate how I'd move forward with
such a situation if I were facing it on my own network.
When you talk about connecting to SQLRelay, exactly what do you mean? Are
you, for example, launching from a command-line something like
sqlrsh 10.131.50.193 "" /tmp/master.socket postgres xxx
? If so, what is the exact command-line response that leads to your
conclusion that you "can't connect"?
Are you able to access the Postgres instance at 10.131.50.191 withOUT
SQLRelay?
|
|
From: Henrik HJ <tes...@li...> - 2009-09-17 09:10:42
|
Can you please help me. I can't connect to SQLRelay, when I try to connect. The client freeze and stop working. I have 4 server: Serv1: 10.131.50.191 Database #1 Serv2: 10.131.50.192 Database #2 Serv3: 10.131.50.193 SQLRelay Serv4: 10.131.50.190 This is the server who have the client install. Thanks in advance Henrik Startup shell script #!/bin/sh /usr/local/firstworks/bin/sqlr-start -id master /usr/local/firstworks/bin/sqlr-start -id slave /usr/local/firstworks/bin/sqlr-start -id router SQLRELAY.CONF <?xml version="1.0"?> <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> <instances> <!-- This instance maintains connections to the "master" Postgresql database on the masterdb machine. This instance only listens on the unix socket /tmp/master.socket and thus cannot be connected to by clients from another machine. --> <instance id="master" port="" socket="/tmp/master.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1"> <users> <user user="postgres" password="xxx"/> </users> <connections> <connection connectionid="db" string="user=postgres;password=xxx;host=10.131.50.191;db=duc;" metric="1" behindloadbalancer="no"/> </connections> </instance> <!-- This instance maintains connections to 1 "slave" Postgresql databases on 1 slave machines. This instance only listens on the unix socket /tmp/slave.socket and thus cannot be connected to by clients from another machine. --> <instance id="slave" port="" socket="/tmp/slave.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1"> <users> <user user="postgres" password="xxx"/> </users> <connections> <connection connectionid="db1" string="user=postgres;password=xxx;host=10.131.50.192;db=duc;" metric="1" behindloadbalancer="no"/> </connections> </instance> <!-- This instance sends DML (insert,update,delete) and DDL (create/delete) queries to the "master" SQL Relay instance which, in turn, sends them to the "master" database. This instance sends any other queries to the "slave" SQL Relay instance which, in turn, distributes them over the "slave" databases. --> <instance id="router" port="9000" socket="/tmp/router.socket" dbase="router" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1"> <users> <user user="postgres" password="xxx"/> </users> <router> <!-- send all DML/DDL queries to "master" --> <route host="" port="" socket="/tmp/master.socket" user="masteruser" password="masterpassword"> <query pattern="^\s*select\s+.*\s+from\s+"/> <query pattern="^\s*insert\s+into\s+"/> <query pattern="^\s*update\s+"/> <query pattern="^\s*delete\s+from\s+"/> <query pattern="^\s*drop\s+table\s+"/> <query pattern="^\s*create\s+table\s+"/> </route> <!-- send all other queries to "slave" --> <route host="" port="" socket="/tmp/slave.socket" user="slaveuser" password="slavepassword"> <query pattern=".*"/> </route> </router> </instance> </instances> Output Warning: using default id. Starting listener: sqlr-listener -id master -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to db : sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf Starting scaler: sqlr-scaler -id master -config /usr/local/firstworks/etc/sqlrelay.conf Starting cache manager: sqlr-cachemanager Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Starting listener: sqlr-listener -id slave -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to db1 : sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf Starting scaler: sqlr-scaler -id slave -config /usr/local/firstworks/etc/sqlrelay.conf cache manager already running. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Couldn't set autocommit off. Couldn't set autocommit off. Starting listener: sqlr-listener -id router -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to defaultid : sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf Starting scaler: sqlr-scaler -id router -config /usr/local/firstworks/etc/sqlrelay.conf cache manager already running. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Couldn't set autocommit off. _________________________________________________________________ Få 25 GB lagerplads på nettet! http://www.microsoft.com/danmark/windows/windowslive/products/skydrive.aspx |
|
From: Renat S. <sr...@st...> - 2009-09-16 10:15:27
|
David Muse пишет: > I think I fixed the debian ruby.h detection too. > It's all in CVS. I don't have a debian machine though, so please give > it a test and let me know if it works or not :) It works fine, thank you! -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: David M. <dav...@fi...> - 2009-09-16 02:23:42
|
Thanks Renat, I applied this patch and the others you submitted, including the rudiments man page. I think I fixed the debian ruby.h detection too. It's all in CVS. I don't have a debian machine though, so please give it a test and let me know if it works or not :) Dave dav...@fi... Renat Sabitov wrote: > Scaler still uses old sqlr-connection-smthng-debug notation for > connections with debug. Now this could be done only with "-debug" > option. Patch attached. > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > ____________________________________________________ > Domain + Hosting Only US$2.95/yr. Register Yours Today. > http://www.doteasy.com > ------------------------------------------------------------------------ > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > ____________________________________________________ > Domain + Hosting Only US$2.95/yr. Register Yours Today. > http://www.doteasy.com |
|
From: Renat S. <sr...@st...> - 2009-09-11 11:47:23
|
Scaler still uses old sqlr-connection-smthng-debug notation for connections with debug. Now this could be done only with "-debug" option. Patch attached. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Renat S. <sr...@st...> - 2009-09-10 07:31:53
|
Forwarded from http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=343552 From: Stephen van Egmond <sva...@ha...> To: Debian Bug Tracking System <su...@bu...> Subject: sqlrelay: segfaults when history file isn't writable Date: Thu, 15 Dec 2005 19:27:32 -0500 Package: sqlrelay Version: 1:0.35-10 Severity: minor I was experimenting with sqlrelay as root, and then switched to my user account. The .sqlrsh_history file was chown 400 root. The problem is this passage in src/cmdline/sqlrsh.C: // create the history file if it doesn't exist now FILE *historyfile=fopen(filename,"a"); fclose(historyfile); read_history(filename); Wrapping fclose() and read_history() with if (historyfile) { } should suffice. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Renat S. <sr...@st...> - 2009-09-08 14:48:53
|
Hello! configure script in sqlrelay-0.41 uses gmake for testing if ruby.h exist. Unfortunetely there is no gmake on Debian so this test always fail. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Renat S. <sr...@st...> - 2009-09-08 10:41:41
|
Hello! I've found that configure script doesn't set HAVE_ORACLE_8i constant while compiling against Oracle 11g. As result CLOB binding doesn't work. Patch attached. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Henrik HJ <tes...@li...> - 2009-09-01 14:05:51
|
Hi. I'm trying to connect OpenErp to Sql Relay version 0.41. when I sending this command psql -d database -h 10.131.50.193 -p 9000 -U postgres when the command is executed we never return to prompt. Please help here. Henrik _________________________________________________________________ NY Windows Live Messenger med nye fede funktioner. Hent den her! http://download.live.com/messenger |
|
From: andrew w. <and...@gm...> - 2009-09-01 08:02:38
|
Hi All, Have installed rudiments 0.32 and tried sqlrelay from both the 0.41 package and cvs. I followed the Programming with SQL Relay using the PHP API page and can connect to the db without any problems but when I tried the SQL Relay Drop-In Replacement Libraries by using exporting LD_PRELOAD=/usr/local/firstworks/lib/libmysql50sqlrelay.so and then mysql -h localhost -P 9000 --user=myuser in cli it just drops me back to the shell. Where can I look to debug? I am running Fedora 8, standard rpms, mysql 5.0.45, php 5.2.6. Has anyone else experienced this? I have multiple web servers that access the db, should i install sqlrelay on each web server to get the api to connect to the sqlrelay service running on the db? Thanks, Andrew |
|
From: Renat S. <sr...@st...> - 2009-08-23 17:21:47
|
Cameron Laird wrote: > The memory use is not just disproportionate; it's an operational > problem. Lockup-inducing memory exhaustion on our SQL Relay host is a > recurring issue for us. > > What can we do? The main problem with memory in sqlrelay is allocation of all memory in cursor's constructor. sqlr-connection allocates memory for all cursors immediately after starting. See http://sourceforge.net/mailarchive/message.php?msg_name=49F9B0FC.901%40stacksoft.ru > For example if you set cursors=10 then it'll allocate 10*10*256*32k = 800M. 10 - N of cursors 10 - fetch 10 rows at once 256 - N of columns 32k - memory for one column This memory allocation strategy cause big problems on sun solaris where memory limit for one user by default is 1/4 of physical memory. |
|
From: Cameron L. <cla...@gm...> - 2009-08-23 15:13:05
|
A Linux-based Oracle listener seems to require 500 MB. That feels ... crazy. Listeners for other DMBSs typically use 50-80 MB, in our experience. We like SQL Relay much, and use it with many different back-ends; among other things, this gives us plenty of practice with different technologies, so we're confident our observations are real. The memory use is not just disproportionate; it's an operational problem. Lockup-inducing memory exhaustion on our SQL Relay host is a recurring issue for us. What can we do? I've found nothing in the archives of the mailing list, nor <URL: http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/oracle.html >. I suspect a remedy is actually documented somewhere; I haven't found it, though. If no one knows better, I'll start to look at the source code ... |
|
From: Dan T. <dtr...@to...> - 2009-07-30 23:02:05
|
Hi, all -
I'm trying to trace down a problem with sqlrelay, in particular
sqlr-listener-${INSTANCENAME}.
Long story short, my debbuging reveals that sqlr-start will start a
listener (in this case sqlr-listener-development, as defined per
sqlrelay.conf), create N number of sqlr-connection-freetds isntances
(again, per my configuration file), then finally an attempt at
sqlr-scaler. Assuming that's the correct order, then I would be seeing
sqlr-listener-development dying immediately after my 20 worker processes
are created, but still being created prior to any of those worker
processes being started. Below is a sniplet of the error:
Starting scaler:
sqlr-scaler -id development -debug -config /etc/sqlrelay.conf
sqlr-scaler error:
The file /var/sqlrelay/tmp/pids/sqlr-listener-development was not
found. This usually means that the sqlr-listener is not running. The
sqlr-listener must be running for the sqlr-scaler to start.
This is in fact true, as the pid file does exist while the workers are
being started, but is removed immediately after.
I've turned debugging on for both the listener and the connector; from
that I don't get much information, just what that specific binary is
doing, which I can get in large part from just a 'ps'.
At this point I'm looking for reasons as to why
sqlr-listener-development would even die.
I'm kind of stumped as to where I should go from here. If anyone has
any suggestions, I would greatly appreciate it. I can provide any such
information that may aide in the resolution of this.
Thanks!
-dant
|
|
From: Roger <b-r...@ro...> - 2009-07-29 13:41:16
|
On Tue, 28 Jul 2009, David Muse wrote:
> I recently put a fix in CVS that should fix this problem with MySQL.
>
> A patch would be to modify src/connections/mysql/mysqlconnection.C and
> change the openCursor method as follows:
>
> bool mysqlcursor::openCursor(uint16_t id) {
> stmt=mysql_stmt_init(&mysqlconn->mysql);
> return sqlrcursor_svr::openCursor(id);
> }
>
> Give that a try, I think it will fix the problem.
It didn't seem to hurt anything, but it hasn't helped, either.
(You have my sqlrelay.conf file.) The mail instance runs 24/7, and the
hourly "cursor error" files overnight are at least as many retries as
before.
At least I figured how to add a retry loop, which must disconnect
from sqlrelay and reconnect, but so far, has only required one retry per
incident. But it's still a kludge.
What is happening that a cursor would not be available?
--
Roger
|
|
From: David M. <dav...@fi...> - 2009-07-29 03:57:25
|
Could you email me the sqlrelay.conf file that doesn't work? I'll try to reproduce the error. David Muse dav...@fi... Roger wrote: > On Tue, 28 Jul 2009, David Muse wrote: > > >> This kind of problem is usually caused when the xml file has a problem, >> like a missing double-quote or missing end-tag or something similar. >> >> Try running xmllint on the sqlrelay.conf file and see if it turns up any >> errors. >> >> Dave >> > > Thanks for the tip. However... > > With --valid (or even with no options), the only thing I see is > the output is reformatted a bit, but there are no errors reported. As I > indicated, I copied one instance and simply changed the id, database, > port, and the maxconnections, as appropriate. When I restart, the dummy > (of course) does nothing, the other two instances restart, but nothing > happens for the new instance. > > |
|
From: David M. <dav...@fi...> - 2009-07-29 03:55:14
|
Just one of those things I never got around to. Some DB's don't report
error numbers, just error messages, or at least some DB's that SQL Relay
used to support were like that. Since they didn't all support error
numbers, I didn't implement it for any.
In some cases, SQL Relay prepends the error number to the message. It's
lame though. I'll put it on the TODO list.
David Muse
dav...@fi...
b-r...@ro... wrote:
> (This is a repost, since the original garnered no responses.)
>
> I've got a Perl package that checks for the errno when there is a
> MySQL error. However, I found that SQLRelay was not passing them through -
> just the error text. As a result, I was getting failures that were not
> being caught.
>
> Why does SQLRelay not pass through the errno?
>
> $errno = $dbh->{ 'mysql_errno' } ;
>
> Thanks,
>
> R
>
> ------------------------------------------------------------------------------
> Enter the BlackBerry Developer Challenge
> This is your chance to win up to $100,000 in prizes! For a limited time,
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize
> details at: http://p.sf.net/sfu/Challenge
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
> http://www.doteasy.com
>
|
16 messages has been excluded from this view by a project administrator.
