[Sqlrelay-discussion] I'm having to coninually restart sqlrelay. Why?
Brought to you by:
mused
Menu
▾
▴
[Sqlrelay-discussion] I'm having to coninually restart sqlrelay. Why?
|
From: Luis M. C. C. <lmc...@ho...> - 2009-04-24 15:51:46
|
I install rudiments-0.32 and sqlrelay-0.39.4 in a Fedora system. I use a C++ program to connect to SQL Relay and SQL Relay to connect to MySql. When I run the queries everything works fine for a while. However after several minutes and hundreds of successful queries the C++ program waits indefinitely when retrieving data from the database. The SQL listener and SQL Connections process are running well, because I check it with the "ps -A | grep sqlr" command But what I found interesting is the log info, because this is what I see in the sqlr.connection.46542 logfile. (the same sequence is repeated over and over again, meaning that the connection is in an infinite loop. trying... initializing cursors... 0 1 2 3 4 done initializing cursors done relogging in creating /usr/local/firstworks/var/sqlrelay/tmp/ipc/jtrekdb-db processing query... preparing/executing... commit or rollback check... done with commit or rollback check processing query failed done processing query handling error... returning error... done returning error database is down... unlinking /usr/local/firstworks/var/sqlrelay/tmp/ipc/jtrekdb-db relogging in... closing cursors... 0 1 2 3 4 done closing cursors... trying... initializing cursors... Also I found that the same error was already found in https://sourceforge.net/mailarchive/forum.php?thread_name=461289CD.1070304%40linfield.edu&forum_name=sqlrelay-discussion I reproduce the text here because I don't know if the link will work. Can I get in contact with this people ?? I'm afraid that I'm definitely a newbie using sqlrelay, so I'm not sure what information to provide. I built and installed sqlrelay on a RedHat AS3 system running apache, php and perl. The database I want to provide connection pooling for is a mysql database running on a different machine. I can start sqlrelay using the linux service command (service sqlrelay start) and all is well for a while. Database accesses work both in php and perl. Then suddenly (and I don't know what causes the "suddenly"), both php and perl apps hang while trying to retrieve data from the database. Sqlrelay has not stopped running and so I do a restart (service sqlrelay restart), and everything is working again. Any ideas how to figure out the cause of the hanging on the database access? This is the connection string from the sqlrelay.conf file: <connections> <connection connectionid="db1" string="user=dbuser;password=secret;db=webapps;host=dbhost.linfield.edu;port=3306;fakebinds=no;" metric="1" behindloadbalancer="1"/> </connections> Thanks, Rob -- Rob Tanner UNIX Services Manager Linfield College, McMinnville OR and here is the reply.... Sounds like the sqlrelay server-side components are crashing or hanging. Whenever it hangs up, take a look and see if any sqlr-connection-mysql processes are running. If not, then they may have crashed. If so, then they may have hung. You can turn on debug in the sqlrelay.conf file and take a look at the logs. Recently, I updated SQL Relay to use the mysql statement API rather than the standard mysql API. There could be a bug with that. The debug logs would be really helpful in figuring out what's going on. Dave david.muse@fi... _________________________________________________________________ Get 5 GB of storage with Windows Live Hotmail. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_5gb_112008 |
