[ 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 <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. > ----------------------------- > {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)