[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philip Thompson updated CASSANDRA-9670:
---------------------------------------
Description:
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 <type 'thread.lock'>: 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 <type 'thread.lock'>: it's not found as thread.lock
cities.cql:16:can only join a started process
Traceback (most recent call last):
File "<string>", line 1, in <module>
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 "<string>", line 1, in <module>
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: <ErrorMessage code=0000 [Server error]
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: <ErrorMessage code=0000 [Server error]
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.
-----------------------------
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)
------------
was:
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 <type 'thread.lock'>: 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 <type 'thread.lock'>: it's not found as thread.lock
cities.cql:16:can only join a started process
Traceback (most recent call last):
File "<string>", line 1, in <module>
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 "<string>", line 1, in <module>
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: <ErrorMessage code=0000 [Server error]
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: <ErrorMessage code=0000 [Server error]
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)
------------
> 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.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 <type 'thread.lock'>: 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 <type 'thread.lock'>: it's not found as thread.lock
> cities.cql:16:can only join a started process
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
> 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 "<string>", line 1, in <module>
> 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: <ErrorMessage code=0000 [Server error]
> 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: <ErrorMessage code=0000 [Server error]
> 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.
> -----------------------------
> 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)
