[
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
