[ https://issues.apache.org/jira/browse/CASSANDRA-15044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912738#comment-16912738 ]
Nirmal Singh KPS commented on CASSANDRA-15044: ---------------------------------------------- To me its some kind of temporary HTTP issue ,. which cannot be reproduced . Kindly close this ticket. > LIST ALL; crashes with ServerError: java.lang.IllegalArgumentException: Name > EESBKEYSPACE is not valid for any resource type > ---------------------------------------------------------------------------------------------------------------------------- > > Key: CASSANDRA-15044 > URL: https://issues.apache.org/jira/browse/CASSANDRA-15044 > Project: Cassandra > Issue Type: Bug > Environment: [cqlsh 5.0.1 | Cassandra 3.11.2 | CQL spec 3.4.4 | > Native protocol v4] > Linux eu50mqvt006.area1.eurofins.local 3.10.0-693.17.1.el7.x86_64 #1 SMP Sun > Jan 14 10:36:03 EST 2018 x86_64 x86_64 x86_64 GNU/Linux > Reporter: Petr Kuzel > Priority: Urgent > > Following crashes: > > *{{$CASSANDRA_HOME/bin/cqlsh -u admin -e "LIST ALL;" > $HOSTNAME}}{{<stdin>:1:ServerError: java.lang.IllegalArgumentException: Name > EESBKEYSPACE is not valid for any resource type}}* > > While following passes: > {{admin@cqlsh> list all of cassandra;}} > {{role | username | resource | permission}} > {{-----------+-----------+---------------------------------------------+------------}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | CREATE}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | ALTER}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | DROP}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | SELECT}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | MODIFY}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | AUTHORIZE}} > {{ cassandra | cassandra | <table *eesbkeyspace.eesbmessage_monitoring*> | > ALTER}} > {{....}} > > Apparently it depends on user because: > {{admin@cqlsh> list all of admin;}} > {{ServerError: java.lang.IllegalArgumentException: Name EESBKEYSPACE is not > valid for any resource type}} > > When trying from the keyspace listing angle getting: > > {{admin@cqlsh> list all on eesbkeyspace.eesbmessage_monitoring;}} > {{InvalidRequest: Error from server: code=2200 [Invalid query] > message="<table eesbkeyspace.eesbmessage_monitoring> doesn't exist"}} > Warning: This is strange as it comes from above list. Something is > inconsistent/stale and might be related to the ServerError. > > Anyway let use existing table for the same: > {{admin@cqlsh> list all on eesbkeyspace.message_monitoring;}} > {{role | username | resource | permission}} > {{-----------+-----------+-----------------------------------------+------------}} > {{ admin | admin | <keyspace eesbkeyspace> | CREATE}} > {{ admin | admin | <keyspace eesbkeyspace> | ALTER}} > {{ admin | admin | <keyspace eesbkeyspace> | DROP}} > {{ admin | admin | <keyspace eesbkeyspace> | SELECT}} > {{ admin | admin | <keyspace eesbkeyspace> | MODIFY}} > {{ admin | admin | <keyspace eesbkeyspace> | AUTHORIZE}} > {{ admin | admin | <table eesbkeyspace.message_monitoring> | ALTER}} > {{ admin | admin | <table eesbkeyspace.message_monitoring> | DROP}} > {{ admin | admin | <table eesbkeyspace.message_monitoring> | SELECT}} > {{ admin | admin | <table eesbkeyspace.message_monitoring> | MODIFY}} > {{ admin | admin | <table eesbkeyspace.message_monitoring> | AUTHORIZE}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | CREATE}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | ALTER}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | DROP}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | SELECT}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | MODIFY}} > {{ cassandra | cassandra | <keyspace eesbkeyspace> | AUTHORIZE}} > {{ cassandra | cassandra | <table eesbkeyspace.message_monitoring> | ALTER}} > {{ cassandra | cassandra | <table eesbkeyspace.message_monitoring> | DROP}} > {{ cassandra | cassandra | <table eesbkeyspace.message_monitoring> | SELECT}} > {{ cassandra | cassandra | <table eesbkeyspace.message_monitoring> | MODIFY}} > {{ cassandra | cassandra | <table eesbkeyspace.message_monitoring> | > AUTHORIZE}} > > That works. > > The keyspace itself: > {{admin@cqlsh> describe keyspace eesbkeyspace;}} > {{CREATE KEYSPACE eesbkeyspace WITH replication = \{'class': > 'NetworkTopologyStrategy', ...} AND durable_writes = true;}} > {{CREATE TABLE eesbkeyspace.coupa_monitoring (}} > {{ ...}} > {{}}{{CREATE TABLE eesbkeyspace.test_monitoring (}} > {{...}} > {{CREATE TABLE eesbkeyspace.genomics_monitoring (}} > {{...}} > {{CREATE TABLE eesbkeyspace.statistics (}} > {{...}} > {{CREATE TABLE eesbkeyspace.message_monitoring (}} > {{...}} > {{CREATE TABLE eesbkeyspace.genomics_monitoring_statistics (}} > {{...}} -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org