Re: [Sqlrelay-discussion] [sqlrelay] Cursor Error

[Benoit C. <ben...@fr...>]

Hi,

i got this error when using idleclienttimeout parameters and idle time
is reached.
Maybe this error could also happen with "sessiontimeout" parameter.

Try to set an higher value. (regarding to your script execution time)

I see maxqueuelength="0" in your config. 
All 100 connexions are spawned at start ?


Best regards

--
Benoit Cattié



Roger a écrit :
> 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>
> === ===
>
>