[Sqlrelay-discussion] [sqlrelay] Cursor Error

[Roger <b-r...@ro...>]

Failed to get a cursor id. A network error may have ocurred. Success

This error is occuring on an increasing frequency with the use of
DBD::SQLRelay, as the two databases I'm using SQLRelay to access are
getting busier. I have a kludge in place that will disconnect from
SQLRelay, reconnect, and retry the query (in a loop). It works and has
never had to retry more than once - so far. I am not using network at all
(local database, using sockets). I am concerned that I can find no
information about this error and what can be done to fix it.

Any help, fixes, pointers, would be appreciated. Thanks.

I am using sqlrelay-0.41 on a CentOS 5.x system with a MySQL 5.0 RDBMS.
The following is my my.cnf file, and one of the instance definitions from
the sqlrelay.conf file (two instances are identical except for port and
database they are accessing - errors appear for both):

=== my.cnf ===
[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords   = 1
old_passwords   = 0

skip-networking
log_slow_queries
log_long_format
skip-bdb
query_cache_type    = 1
thread_cache_size   = 40
wait_timeout        = 15
max_connections     = 200
max_connect_errors  = 10
table_cache         = 1024
max_allowed_packet  = 2M
binlog_cache_size   = 1M
max_heap_table_size = 16M
key_buffer_size     = 16M
read_buffer_size    = 2M
sort_buffer_size    = 8M
join_buffer_size    = 1M
query_cache_size    = 8M
query_cache_limit   = 1M
tmp_table_size      = 64M
long_query_time     = 2
thread_concurrency  = 8
read_rnd_buffer_size    = 2M
innodb_buffer_pool_size = 2G
innodb_lock_wait_timeout    = 10
innodb_max_dirty_pages_pct  = 90
innodb_additional_mem_pool_size = 16M
innodb_flush_log_at_trx_commit  = 1

[mysqld_safe]

log-error           = /var/log/mysqld.log
pid-file            = /var/run/mysqld/mysqld.pid
open-files-limit    = 4096
=== ===

=== sqlrelay.conf ===
    <instance
        id="testid"
        port="9002"
        dbase="mysql"
        handoff="pass"
        connections="1"
        maxconnections="100"
        maxqueuelength="0"
        cursors="50"
        growby="2"
        ttl="300"
        maxsessioncount="0"
        sessiontimeout="10"
    >
    <users>
        <user
            user="testuser"
            password="testpassword"
        />
    </users>
    <connections>
        <connection
            connectionid="con1"
            string="user=testuser;password=testpassword;db=testdatabase;"
        />
    </connections>
    </instance>
=== ===

-- 
Roger