[jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14704280#comment-14704280
]
Sanjay Patel commented on CASSANDRA-9670:
-
Carl, any plan for analysis?Thanks
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: - Apache Cassandra 2.1.7 and 2.1.8 in Ubuntu
> - DataStax Community Edition on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Carl Yeksigian
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14649728#comment-14649728
]
Sanjay Patel commented on CASSANDRA-9670:
-
Hi Tyler,
any update on this ? Any planned date ?
At present we are really stuck here, as we are unable to create application
schema and migrate application to new tech stack.
Best Regards
Sanjay
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: - Apache Cassandra 2.1.7 and 2.1.8 in Ubuntu
> - DataStax Community Edition on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Tyler Hobbs
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14649728#comment-14649728
]
Sanjay Patel edited comment on CASSANDRA-9670 at 7/31/15 7:52 PM:
--
Hi Tyler,
any update on this ? Any planned date ?
At present we are really stuck here, as we are unable to create application
schema and migrate application to new tech stack.
We are facing same issue in 2.2.0
Best Regards
Sanjay
was (Author: bholya):
Hi Tyler,
any update on this ? Any planned date ?
At present we are really stuck here, as we are unable to create application
schema and migrate application to new tech stack.
Best Regards
Sanjay
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: - Apache Cassandra 2.1.7 and 2.1.8 in Ubuntu
> - DataStax Community Edition on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Tyler Hobbs
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Environment:
- Apache Cassandra 2.1.7 and 2.1.8 in Ubuntu
- DataStax Community Edition on Windows 7, 64 Bit and Ubuntu
was:
DataStax Community Edition
on Windows 7, 64 Bit and Ubuntu
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: - Apache Cassandra 2.1.7 and 2.1.8 in Ubuntu
> - DataStax Community Edition on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Reproduced In: 2.1.8, 2.1.7 (was: 2.1.7)
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14632288#comment-14632288
]
Sanjay Patel commented on CASSANDRA-9670:
-
I have updated schema (sp_setup.cql). Thanks
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Attachment: sp_setup.cql
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Attachment: (was: sp_setup.cql)
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14622846#comment-14622846
]
Sanjay Patel commented on CASSANDRA-9670:
-
Philip, any workaround for this ?
Thanks
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14613576#comment-14613576
]
Sanjay Patel edited comment on CASSANDRA-9670 at 7/4/15 6:55 AM:
-
Sorry, i was out of station with no possibility to access dev env,
I have attached sp_setup.cql.
I suspect that problem is with German character.
---
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh> source 'sp_setup.cql' ;
cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
in range(128)
cities.cql:13:
Error starting import process:
cities.cql:13:Can't pickle : it's not found as thread.lock
cities.cql:13:can only join a started process
cities.cql:15:
Error starting import process:
cities.cql:15:Can't pickle : it's not found as thread.lock
cities.cql:15:can only join a started process
cqlsh> Traceback (most recent call last):
Traceback (most recent call last):
File "", line 1, in
File "", line 1, in
File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
main
File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
main
prepare(preparation_data)
File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
prepare
prepare(preparation_data)
File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
prepare
file, path_name, etc = imp.find_module(main_name, dirs)
ImportError: No module named cqlsh
file, path_name, etc = imp.find_module(main_name, dirs)
ImportError: No module named cqlsh
was (Author: bholya):
Sorry, i was out of station with no possibility to access dev env,
I have attached sp_setup.cql.
I suspect that problem is with German character.
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.File
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Attachment: india_states.csv
india_cities.csv
germany_cities.cql
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, germany_cities.cql,
> india_cities.csv, india_states.csv, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14613576#comment-14613576
]
Sanjay Patel edited comment on CASSANDRA-9670 at 7/4/15 6:47 AM:
-
Sorry, i was out of station with no possibility to access dev env,
I have attached sp_setup.cql.
I suspect that problem is with German character.
was (Author: bholya):
Main script
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Attachment: sp_setup.cql
Main script
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql, sp_setup.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14608917#comment-14608917
]
Sanjay Patel commented on CASSANDRA-9670:
-
Philip, problem is with executing this script. Cities.cql execute this scrpt
and having error. Surprisingly it imports N number of records before throwing
error, where N was < 40.
On ubuntu today data was imported, but throwing error :
'ascii' codec can't decode byte 0xc3 in position 57: ordinal not in range(128)
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjay Patel updated CASSANDRA-9670:
Attachment: germany_cities.cql
Scripts thorws error while executing this
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql, germany_cities.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14605922#comment-14605922
]
Sanjay Patel commented on CASSANDRA-9670:
-
Yes, it does exist. In main script i am dropping and creating again. All other
tables are created succesfully.
but having problem with data import. Same scripts runs in all environment
+server seccessfully with 2.0.7.
> Cannot run CQL scripts on Windows AND having error Ubuntu Linux
> ---
>
> Key: CASSANDRA-9670
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9670
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Community Edition
> on Windows 7, 64 Bit and Ubuntu
>Reporter: Sanjay Patel
>Assignee: Philip Thompson
> Labels: cqlsh
> Fix For: 2.1.x
>
> Attachments: cities.cql
>
>
> After installation of 2.1.6 and 2.1.7 it is not possible to execute cql
> scripts, which were earlier executed on windows + Linux environment
> successfully.
> I have tried to install Python 2 latest version and try to execute, but
> having same error.
> Attaching cities.cql for reference.
> ---
> {code}
> cqlsh> source 'shoppoint_setup.cql' ;
> shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query]
> message="Keyspace 'shopping' does not exist"
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> cities.cql:14:
> Error starting import process:
> cities.cql:14:Can't pickle : it's not found as thread.lock
> cities.cql:14:can only join a started process
> cities.cql:16:
> Error starting import process:
> cities.cql:16:Can't pickle : it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "", line 1, in
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> Traceback (most recent call last):
> File "", line 1, in
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in
> main
> prepare(preparation_data)
> File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in
> prepare
> file, path_name, etc = imp.find_module(main_name, dirs)
> ImportError: No module named cqlsh
> shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18:
> ordinal not in range(128)
> ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\data\syste
> m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException: java.io.FileNotFoundException:
> I:\var\lib\cassandra\d
> ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db
> (The process cannot access the file because it is being used by another
> process)">
> shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14:
> ordinal not in range(128){code}
> -
> In one of Ubuntu development environment we have similar errors.
> -
> {code}
> shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57:
> ordinal not in range(128)
> cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not
> in range(128)
> (corresponding line) COPY cities (city,country_code,state,isactive) FROM
> 'testdata/india_cities.csv' ;
> [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte
> 0xc3 in position 18: ordinal not in range(128)
> {code}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
[ https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sanjay Patel updated CASSANDRA-9670: Environment: DataStax Community Edition on Windows 7, 64 Bit and Ubuntu was:Windows 7, 64 Bit and Ubuntu > Cannot run CQL scripts on Windows AND having error Ubuntu Linux > --- > > Key: CASSANDRA-9670 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9670 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: DataStax Community Edition > on Windows 7, 64 Bit and Ubuntu >Reporter: Sanjay Patel > Fix For: 2.1.7 > > Attachments: cities.cql > > > After installation of 2.1.6 and 2.1.7 it is not possible to execute cql > scripts, which were earlier executed on windows + Linux environment > successfully. > I have tried to install Python 2 latest version and try to execute, but > having same error. > Attaching cities.cql for reference. > --- > cqlsh> source 'shoppoint_setup.cql' ; > shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query] > message="Keyspace 'shopping' does not exist" > shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57: > ordinal not in range(128) > cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not > in range(128) > cities.cql:14: > Error starting import process: > cities.cql:14:Can't pickle : it's not found as thread.lock > cities.cql:14:can only join a started process > cities.cql:16: > Error starting import process: > cities.cql:16:Can't pickle : it's not found as thread.lock > cities.cql:16:can only join a started process > Traceback (most recent call last): > File "", line 1, in > File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in > main > prepare(preparation_data) > File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in > prepare > Traceback (most recent call last): > File "", line 1, in > file, path_name, etc = imp.find_module(main_name, dirs) > ImportError: No module named cqlsh > File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in > main > prepare(preparation_data) > File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in > prepare > file, path_name, etc = imp.find_module(main_name, dirs) > ImportError: No module named cqlsh > shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18: > ordinal not in range(128) > ipcache.cql:28:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException: > java.lang.RuntimeException: java.io.FileNotFoundException: > I:\var\lib\cassandra\data\syste > m\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-ka-300-Data.db > (The process cannot access the file because it is being used by another > process)"> > ccavn_bulkupdate.cql:75:ServerError: message="java.lang.RuntimeException: java.util.concurrent.ExecutionException: > java.lang.RuntimeException: java.io.FileNotFoundException: > I:\var\lib\cassandra\d > ata\system\schema_columns-296e9c049bec3085827dc17d3df2122a\system-schema_columns-tmplink-ka-339-Data.db > (The process cannot access the file because it is being used by another > process)"> > shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14: > ordinal not in range(128) > - > In one of Ubuntu development environment we have similar errors. > - > shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57: > ordinal not in range(128) > cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not > in range(128) > (corresponding line) COPY cities (city,country_code,state,isactive) FROM > 'testdata/india_cities.csv' ; > [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte > 0xc3 in position 18: ordinal not in range(128) > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
Sanjay Patel created CASSANDRA-9670: --- Summary: Cannot run CQL scripts on Windows AND having error Ubuntu Linux Key: CASSANDRA-9670 URL: https://issues.apache.org/jira/browse/CASSANDRA-9670 Project: Cassandra Issue Type: Bug Components: Core Environment: Windows 7, 64 Bit and Ubuntu Reporter: Sanjay Patel Fix For: 2.1.7 Attachments: cities.cql After installation of 2.1.6 and 2.1.7 it is not possible to execute cql scripts, which were earlier executed on windows + Linux environment successfully. I have tried to install Python 2 latest version and try to execute, but having same error. Attaching cities.cql for reference. --- cqlsh> source 'shoppoint_setup.cql' ; shoppoint_setup.cql:16:InvalidRequest: code=2200 [Invalid query] message="Keyspace 'shopping' does not exist" shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57: ordinal not in range(128) cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not in range(128) cities.cql:14: Error starting import process: cities.cql:14:Can't pickle : it's not found as thread.lock cities.cql:14:can only join a started process cities.cql:16: Error starting import process: cities.cql:16:Can't pickle : it's not found as thread.lock cities.cql:16:can only join a started process Traceback (most recent call last): File "", line 1, in File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in main prepare(preparation_data) File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in prepare Traceback (most recent call last): File "", line 1, in file, path_name, etc = imp.find_module(main_name, dirs) ImportError: No module named cqlsh File "I:\programm\python2710\lib\multiprocessing\forking.py", line 380, in main prepare(preparation_data) File "I:\programm\python2710\lib\multiprocessing\forking.py", line 489, in prepare file, path_name, etc = imp.find_module(main_name, dirs) ImportError: No module named cqlsh shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18: ordinal not in range(128) ipcache.cql:28:ServerError: ccavn_bulkupdate.cql:75:ServerError: shoppoint_setup.cql:680:'ascii' codec can't decode byte 0xe2 in position 14: ordinal not in range(128) - In one of Ubuntu development environment we have similar errors. - shoppoint_setup.cql:647:'ascii' codec can't decode byte 0xc3 in position 57: ordinal not in range(128) cities.cql:9:'ascii' codec can't decode byte 0xc3 in position 51: ordinal not in range(128) (corresponding line) COPY cities (city,country_code,state,isactive) FROM 'testdata/india_cities.csv' ; [19:53:18] j.basu: shoppoint_setup.cql:663:'ascii' codec can't decode byte 0xc3 in position 18: ordinal not in range(128) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
