1

im having such problem: phpcassa causes such exception when the load increases to 200 queries to script per second

Error connecting to localhost:9160: TException: TSocket: Could not connect to localhost:9160 (Cannot assign requested address [99])
Error connecting to localhost:9160: TException: TSocket: Could not connect to localhost:9160 (Cannot assign requested address [99])
PHP Fatal error:  Uncaught exception 'NoServerAvailable' with message 'An attempt was made to connect to every server twice, but all attempts failed. The last error was: TException:TSocket: Could not connect to localhost:9160 (Cannot assign requested address [99])' in /var/www/megaumnik/context/connection.php:232
Stack trace:
#0 /var/www/megaumnik/context/connection.php(257): ConnectionPool->make_conn()
#1 /var/www/megaumnik/context/connection.php(351): ConnectionPool->get()
#2 /var/www/megaumnik/context/connection.php(286): ConnectionPool->call('describe_keyspa...', 'thegame')
#3 /var/www/megaumnik/context/columnfamily.php(194): ConnectionPool->describe_keyspace()
#4 /var/www/megaumnik/data/getData.class.php(265): ColumnFamily->__construct(Object(ConnectionPool), 'username')
#5 /var/www/megaumnik/data/test.php(6): getData->getDataByKey('username', '317')
#6 {main}
  thrown in /var/www/megaumnik/context/connection.php on line 232

script has 4 $cf->get() from different column families.each column family has 1000 rows

Undrooleek
  • 223
  • 4
  • 12

1 Answers1

1

It sounds like maybe you are hitting the open file limit. You can see what the current limit is with 'ulimit -a'.

To increase the limit, you can set a new limit in one of two ways. First, you can do something like 'ulimit -n 10000', which is temporary, and will only affect processes started by that shell. To permanently increase the limit, you need to add a line to /etc/security/limits.conf that looks like this:

*               -       nofile      10000

For this to take effect, I believe you need to log in again.

Tyler Hobbs
  • 6,872
  • 24
  • 31