[CASSANDRA-9670] Cannot run CQL scripts on Windows AND having error Ubuntu Linux

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Labels: cqlsh

Environment

• Apache Cassandra 2.1.7 and 2.1.8 in Ubuntu
• DataStax Community Edition on Windows 7, 64 Bit and Ubuntu

• Severity: Normal
• Assignee: Carl Yeksigian
• Reporter: Sanjay Patel

Authors

Carl Yeksigian

• Created: 28/Jun/15 17:55
• Updated: 16/Apr/19 09:31
• Resolved: 24/Aug/15 16:46

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.

-----------

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)

------------

Issue Links

• duplicates: CASSANDRA-9898 cqlsh crashes if it load a utf-8 file.