[
https://issues.apache.org/jira/browse/CASSANDRA-19953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17884910#comment-17884910
]
Maxwell Guo edited comment on CASSANDRA-19953 at 9/26/24 8:04 AM:
------------------------------------------------------------------
[~atailh4n]Cassandra will create some virtual tables ,and the table of
streaming is one of them. And there are other places where similar problems
may arise, such as:
[JobTable|https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/virtual/LocalRepairTables.java#L245]
The reason why you encountered this problem is that I guess it is the default
Turkish and UTF-8 encoding?
I just reproduced in local docker env by setting the LANG to tr_TR.UTF-8.
{quote}adding Locale.US to all toLowerCase(), toUpperCase() etc{quote}
I think it is a huge project, For me , it may be better to export
LANG=en_US.UTF-8 in
[cassandra-env.sh|https://github.com/apache/cassandra/blob/trunk/conf/cassandra-env.sh]
or some other start shell script.
[~brandon.williams] [~dcapwell] Do you think we should treat this as a bug ?
was (Author: maxwellguo):
[~atailh4n]Cassandra will create some virtual tables ,and the table of
streaming is one of them. And there are other places where similar problems
may arise, such as:
[JobTable|https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/virtual/LocalRepairTables.java#L245]
The reason why you encountered this problem is that I guess it is the default
Turkish and UTF-8 encoding?
I just reproduced in local docker env by setting the LANG to tr_TR.UTF-8.
{quote}adding Locale.US to all toLowerCase(), toUpperCase() etc{quote}
I think it is a huge project, For me , it may be better to export
LANG=en_US.UTF-8 in
[cassandra-env.sh|https://github.com/apache/cassandra/blob/trunk/conf/cassandra-env.sh]
or some other start shell script.
[~brandon.williams] [~dcapwell] Do you think we should treat this as a bug ?
> CQL schema parser fails on startup when system locale set to tr_TR.UTF-8 with
> SyntaxException: "no viable alternative at character 'ı'"
> ---------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-19953
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19953
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: Ata İlhan Köktürk
> Assignee: Ata İlhan Köktürk
> Priority: Normal
>
> Fresh installation of Cassandra 5.0 fails to start with the following error:
> {code:java}
> ERROR [main] 2024-09-25 14:50:58,401 CassandraDaemon.java:900 - Exception
> encountered during startup
> java.lang.ExceptionInInitializerError: null
> at
> org.apache.cassandra.service.CassandraDaemon.setupVirtualKeyspaces(CassandraDaemon.java:575)
> at
> org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:286)
> at
> org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:744)
> at
> org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:878)
> Caused by: org.apache.cassandra.exceptions.SyntaxException: Failed parsing
> CREATE TABLE: [CREATE TABLE streaming ( id timeuuid,
> follower boolean,
> operation text,
> peers frozen<list<text>>,
> status text,
> progress_percentage float,
> last_updated_at timestamp,
> duration_millis bigint,
> failure_cause text,
> success_message text,
> bytes_to_receive bigint,
> bytes_received bigint,
> bytes_to_send bigint,
> bytes_sent bigint,
> files_to_receive bigint,
> files_received bigint,
> files_to_send bigint,
> files_sent bigint,
> status_ınıt_timestamp timestamp,
> status_start_timestamp timestamp,
> status_success_timestamp timestamp,
> status_faılure_timestamp timestamp,
> PRIMARY KEY ((id)))] reason: SyntaxException line 21:9 no viable alternative
> at character 'ı'
> at
> org.apache.cassandra.cql3.CQLFragmentParser.parseAny(CQLFragmentParser.java:48)
> at
> org.apache.cassandra.cql3.statements.schema.CreateTableStatement.parse(CreateTableStatement.java:465)
> at
> org.apache.cassandra.db.virtual.StreamingVirtualTable.<init>(StreamingVirtualTable.java:37)
> at
> org.apache.cassandra.db.virtual.SystemViewsKeyspace.<init>(SystemViewsKeyspace.java:47)
> at
> org.apache.cassandra.db.virtual.SystemViewsKeyspace.<clinit>(SystemViewsKeyspace.java:26)
> ... 4 common frames omitted
> {code}
>
> So, I changed my system language, re-created and deleted locales (switched
> from {{tr_TR.UTF-8}} to {{{}en_US.UTF-8{}}}), and changed it from GNOME
> Settings too.
> I use Ubuntu 24.02. In this error you see {{'ı'}} (a Turkish character, i but
> without dot) used and Java basically couldn't find an alternative for {{'ı'}}
> but the question is I just installed Cassandra. I didn't create this table.
> This is probably for Cassandra and created automatically (I haven't used
> Cassandra, this was about to be my first time but as you can see I got error).
> Also, I tried other stable version 41x, same result. I completely removed
> {{/var/lib/cassandra}} and {{/var/log cassandra}} before install too.
> My solution (I am currently trying to test): adding {{Locale.US}} to all
> {{{}toLowerCase(){}}}, {{toUpperCase()}} etc. Because my keyboard map affects
> it. I think we can fix this with this way.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
