[Spock Proxy Devel] Issues in getting spock proxy to work...

[Anand K. <an...@en...>]

I have been trying to get spock to work. However, i am facing some  
issues. The configuration is simple and as per your example.

(1) using mysql root user with proper password.
(2) Installed spock proxy and all associated packages needed.
(3) configured using the config file

#listening address:port of the proxy-server ,default is ":4040"
PROXY_ADDRESS=:4040

#listening address:port of internal admin-server, default is ":4041"
ADMIN_ADDRESS=:4041

#host of table partition information tables, this MUST be set
PARTITION_INFO_HOST=127.0.0.1

#database name of the table partition info. this MUST be set
PARTITION_INFO_DB=db_mapping

#db user for connecting to back end servers and connecting to the proxy,
#this MUST be set
DB_USER=root

#password for the DB_USER
DB_PASSWD=tiger

(4) DB created and populated using the example script provided.

+-------------+-----------+-------------+---------------+
| database_id | host_name | port_number | database_name |
+-------------+-----------+-------------+---------------+
|           1 | 127.0.0.1 |        3306 | db_sample_1   |
|           2 | 127.0.0.1 |        3306 | db_sample_2   |
+-------------+-----------+-------------+---------------+

Rest of the tables are populated with proper data.

Looks like the proxy starts off initially by reading the config and  
creating the connection pool. Until this the logs seems to be ok, the  
info messages say there isnt any problems. But these are followed by a  
lot of errors. The 2 main errors that i see are

(a) Tue Jun 30 13:58:57 2009 WARNING network-mysqld-proxy.cpp.5204:  
handshake packet error
Tue Jun 30 13:58:57 2009 WARNING ^H.2762:  
CON_STATE_ASYNC_READ_HANDSHAKE con_read_handshake failed returned an  
error

and

(b) Tue Jun 30 13:58:57 2009 WARNING network-mysqld.cpp.3069: error in  
selecting default database: Bad handshake
Tue Jun 30 13:58:57 2009 WARNING network-mysqld.cpp.3069: error in  
selecting default database: Bad handshake


And after a while, i start seeing these messages

Tue Jun 30 14:53:08 2009 ERROR network-mysqld.cpp.540:  
socket(127.0.0.1:3306) failed: Too many open files
Tue Jun 30 14:53:08 2009 ERROR network-mysqld.cpp.540:  
socket(127.0.0.1:3306) failed: Too many open files


If i connect through mysql command

mysql -uroot -ptiger -h127.0.0.1 -P3306 db_mapping,  i can select and  
operate on the tables etc. So, looks like the mysql is running fine  
and accepting connections.

Im using

Linux version 2.6.18-92.el5PAE (moc...@bu...) (gcc  
version 4.1.2 20071124 (Red Hat 4.1.2-42)) #1 SMP Tue Jun 10 19:22:41  
EDT 2008
mysql  Ver 14.12 Distrib 5.0.45


Any pointers would be greatly appreciated.