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

["Sanjay Patel (JIRA)" <ji...@apache.org>]

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 <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)

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






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)