[
https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14631485#comment-14631485
]
Philip Thompson commented on CASSANDRA-9670:
--------------------------------------------
Sorry, [~bholya], i was away from the office for a few weeks. I'm looking at
these scripts now, and while the problem is definitely in the importing of one
of these characters, the sp_setup.cql file you attached does not define the
schema for the cities table, which is the one with the failing imports from the
attached .csv files. Could you please give me that schema so I can repro the
issue?
> 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 <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)
