sebgiroux / cassandra-cluster-admin Goto Github PK

Today I upgraded my cassandra from 1.1.2 to 1.2.28 but Cassandra-Cluster-Admin stopped working with problems related to the Thrift library:

Fatal error: Uncaught exception 'TTransportException' with message 'TSocket: timed out reading 4 bytes from 127.0.0.1:9160' in /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/transport/TSocket.php:268 Stack trace: #0 /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/transport/TTransport.php(87): TSocket->read(4) #1 /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/transport/TFramedTransport.php(135): TTransport->readAll(4) #2 /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/transport/TFramedTransport.php(102): TFramedTransport->readFrame() #3 /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/transport/TTransport.php(87): TFramedTransport->read(4) #4 /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/protocol/TBinaryProtocol.php(300): TTransport->readAll(4) #5 /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/protocol/TBinaryProtocol.php(192): TBinaryProtocol->readI32(NULL) #6 /usr/local/www/apach in /usr/local/www/apache22/data/cassandra-cluster-admin/include/thrift/transport/TSocket.php on line 268

Any hints?

Thanks,
d.

With columnfamily_action.php?action=edit_row, when you put just 0 in a column family. It gets deleted, rather than set to the string '0'.

Would be nice to have a import/export function. So we can easily export the keyspace for trying something out or for publishing it from development to production environment.

I‘m trying to use this project to connect my remote cassandra-3.10 cluster but it report connection issue as
" ’An error occured while connecting to your Cassandra server: TSocket: Could not connect to 10.129.x.x:9160 (Connection refused [111])".

Does this project support Cassandra-3.10? Thanks.

It would be nice to have all JMX / nodetool functions available on JMX view (ala OpsCenter ;) ). I'm trying to deploy and add this functions and I would be happy to pull the changes... but I'm in trouble with MX4J.

http://192.168.10.91/invoke?operation=forceTableRepair&objectname=org.apache.cassandra.db%3Atype%3DStorageService&value0=&type0=java.lang.String&type1=[Ljava.lang.String%3B

MBean operation: invoke method on MBean org.apache.cassandra.db:type=StorageService
Error during MBean operation invocationMessage: count of parameter types doesn't match count of parameter values

http://192.168.10.91/invoke?operation=forceTableRepair&objectname=org.apache.cassandra.db%3Atype%3DStorageService&value0=&type0=java.lang.String&type1=[Ljava.lang.String%3B&value1=

MBean operation: invoke method on MBean org.apache.cassandra.db:type=StorageService
Error during MBean operation invocationMessage: Parameter 1: cannot be converted to type [Ljava.lang.String;

http://192.168.10.91/invoke?operation=forceTableRepair&objectname=org.apache.cassandra.db%3Atype%3DStorageService

MBean operation: invoke method on MBean org.apache.cassandra.db:type=StorageService
Error during MBean operation invocationMessage: Operation singature has no match in the MBean

...the strange thing is that some ops (es. forceTableRepair, forceTableCleanup) have optional parameters, so it should be possibile to call that methods without parameters.

cassandra Increase access, visit has been wrong

error:An error occured while connecting to your Cassandra server: You have not logged in

But I landing was successful, but can't access the data.
my access.properties
system Under the table Access is all
ro

I cannot browse the records of a Column Family that have a UUID as key. Trying to browse for records simply does not display anything (as if the Column Family would be empty).

I'm using XAMPP for Linux, version 1.7.7. Cassandra version is 1.0.6. The Column Family that I'm trying to browse has only the key_validation_class attribute set to LexicalUUIDType. I've inserted the records using Ruby and the Cassandra Twitter Gem.

When creating a new column family, the description (hovering the ?) of Row Cache Size shows "Each each ...".

I'm deploying a Cassandra cluster and using CCA I noticed that it works perfectly with all cluster nodes up. In case of some nodes down operations with CCA works in a intermittent manner (and JMX view cease to works at all expecially if the first node of the cluster is down). I solved with some modifications to CCA and phpcassa, using ConnectionPool instead of ConnectionWrapper for instantiating SystemManager, and don't using getRandomNode anymore. In JMX view I added node selection (the condition of JMX unreacheble could be due to missing mx4j as like as node down).

I'd like to submit a pull request regarding the code I modified, but I'm in trouble with the structure of the code... phpcassa is included in Cassandra Cluster Admin. But phpcassa is a standalone repository. And I forked it and made a change to SystemManager() class. So... how to manage this situation? Is it possibile to link phpcassa into a directory of CCA? Or it would be better to drop entirely phpcassa from CCA? (PS: Usually I use Google Code, I'm a newbe on github, thanks in advance for your support)

Example:

Insert a Row

Row Key: 3d873924-2bd7-4884-b263-48fc5eb3f43d
Column Name: ID
Column Value: 3d873924-2bd7-4884-b263-48fc5eb3f43d

It results in a successful message though the row didn't seem to get added when click "Browse Data".

Inserting a row works fine when I took out the dashes in "Row Key". Inserting the same row key with dashes works from my Java program with the hector client as well. Could this potentially be an encoding issue?

Error while inserting row: An attempt to execute batch_mutate failed 6 times. The last error was exception 'cassandra_UnavailableException' in /var/www/cluster-admin/include/phpcassa/thrift/Thrift.php:574 Stack trace: #0 /var/www/cluster-admin/include/phpcassa/thrift/packages/cassandra/Cassandra.php(3181): TBase->_read('Cassandra_batch...', Array, Object(TBinaryProtocolAccelerated)) #1 /var/www/cluster-admin/include/phpcassa/thrift/packages/cassandra/Cassandra.php(886): cassandra_Cassandra_batch_mutate_result->read(Object(TBinaryProtocolAccelerated)) #2 /var/www/cluster-admin/include/phpcassa/thrift/packages/cassandra/Cassandra.php(846): CassandraClient->recv_batch_mutate() #3 [internal function]: CassandraClient->batch_mutate(Array, 1) #4 /var/www/cluster-admin/include/phpcassa/connection.php(354): call_user_func_array(Array, Array) #5 /var/www/cluster-admin/include/phpcassa/columnfamily.php(617): ConnectionPool->call('batch_mutate', Array, 1) #6 /var/www/cluster-admin/columnfamily_action.php(512): ColumnFamily->insert('test', Array) #7 {main}

Hello.

I've got exception while i am trying to insert row

Error while inserting row: An attempt to execute batch_mutate failed 6 times. The last error was exception 'cassandra_UnavailableException' in /home/sergey/workspace/test/cassandra/test/include/phpcassa/thrift/packages/cassandra/Cassandra.php:871 Stack trace: #0 /home/sergey/workspace/test/cassandra/test/include/phpcassa/thrift/packages/cassandra/Cassandra.php(871): thrift_protocol_read_binary(Object(TBinaryProtocolAccelerated), 'cassandra_Cassa...', false) #1 /home/sergey/workspace/test/cassandra/test/include/phpcassa/thrift/packages/cassandra/Cassandra.php(846): CassandraClient->recv_batch_mutate() #2 [internal function]: CassandraClient->batch_mutate(Array, 1) #3 /home/sergey/workspace/test/cassandra/test/include/phpcassa/connection.php(354): call_user_func_array(Array, Array) #4 /home/sergey/workspace/test/cassandra/test/include/phpcassa/columnfamily.php(617): ConnectionPool->call('batch_mutate', Array, 1) #5 /home/sergey/workspace/test/cassandra/test/columnfamily_action.php(512): ColumnFamily->insert('test', Array) #6 {main}

Is that my mistake or your lib bug ?

when I changed the keyspace 's name from 'keyspace1' to 'myspace', it output the message like below:

Fatal error: Uncaught exception 'cassandra_NotFoundException' in E:\WampServ\www\phpcassa\thrift\Thrift.php:574 Stack trace: #0 E:\WampServ\www\phpcassa\thrift\packages\cassandra\Cassandra.php(3769): TBase->_read('Cassandra_descr...', Array, Object(TBinaryProtocolAccelerated)) #1 E:\WampServ\www\phpcassa\thrift\packages\cassandra\Cassandra.php(1357): cassandra_Cassandra_describe_keyspace_result->read(Object(TBinaryProtocolAccelerated)) #2 E:\WampServ\www\phpcassa\thrift\packages\cassandra\Cassandra.php(1318): CassandraClient->recv_describe_keyspace() #3 E:\WampServ\www\phpcassa\sysmanager.php(506): CassandraClient->describe_keyspace('Keyspace12') #4 E:\WampServ\apps\Cassandra-Cluster-Admin\keyspace_action.php(206): SystemManager->describe_keyspace('Keyspace12') #5 {main} thrown in E:\WampServ\www\phpcassa\thrift\Thrift.php on line 574

Cassandra 1.0 added support to compress CF using pluggable scheme. It would be nice to be able to see what compress options are enabled on a CF. If there are other compression related stats available (like compression ratio) that would be great too!

There are certain instances of using this tool where it just timeouts, such as when attempting to browse through data or creating secondary index.

May I know why, and is there a way around it?

Thanks!

Hi. I got this message when I'm trying to access cassandra on localhost
An error occured while connecting to your Cassandra server: TSocket: Could not connect to 127.0.0.1:9160 (No connection could be made because the target machine actively refused it.
I use xampp to connect
What should i do

when column name is longtype greater than 32 bit (for example 10999888777) only the 32 bit part is displayed (2409954185)

Any idea why every row with more than 100 columns is being truncated to100 when viewing with CCA? As an example within cassandra-cli the count is 157 and in within CCA only 100 show?

/s

I've created some tables using the cql3 api provided by the latest cassandra. I used something like the following:

CREATE TABLE users (
user_name varchar PRIMARY KEY,
password varchar,
gender varchar,
session_token varchar,
state varchar,
birth_year bigint
);

But the table/columnfamily doesn't show up in the cassandra-cluster-admin.

It would be nice to handle multiline fields (XML for example).

Because I just try with some XML and all I got is a blank page (probably because of the type "input" instead of textarea).

Thank you in advance

Line 16 of jmx.php currently is set as below
if (isset($_GET['change_mx4j_node'])) $_SESSION['mx4j_node'] = $_GET['mx4j_node'];

But observing the logic below line 16, the correct _GET paramenter setting _SESSION[mx4j_node] should be change_mx4j_node instead of mx4j_node
Making that line
if (isset($_GET['change_mx4j_node'])) $_SESSION['mx4j_node'] = $_GET['change_mx4j_node'];

I inserted some value into a CF by CCA, and I can browse and get it by CCA, and, it can read by php that i programed , but it can 't read under cassandra-cli, how was it?

Hi,

I'm using your solution in my small start-up, it's a nice free alternative to the very expensive Datastax Opscenter, thanks for it.

But to really replace it I need statistics. It seems that jmx stats can give me that but I wasn't able to see them.

I got an internal error when trying to get jmx.php page.

I got a 2 nodes cluster that I configured in the include/conf.inc.php. I'm sur that my mx4j is successfully loaded on each node on cassandra start :

"INFO 08:43:47,742 mx4j successfuly loaded
HttpAdaptor version 3.0.2 started on port 8081"

Did you already heard about this kind of error ?

Should you need any further information, please do not hesitate to let me know.