[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cassandra-commits
Subject:    [jira] [Commented] (CASSANDRA-9670) Cannot run CQL scripts on Windows AND having error Ubuntu Linux
From:       "Sanjay Patel (JIRA)" <jira () apache ! org>
Date:       2015-06-30 19:30:06
Message-ID: JIRA.12841194.1435514148000.62127.1435692606840 () Atlassian ! JIRA
[Download RAW message or body]


    [ https://issues.apache.org/jira/browse/CASSANDRA-9670?page=com.atlassian.jira.plu \
gin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14608917#comment-14608917 \
] 

Sanjay Patel commented on CASSANDRA-9670:
-----------------------------------------

Philip, problem is with executing this script. Cities.cql execute this scrpt and \
having error. Surprisingly it imports N number of records before throwing error, \
where N was < 40.

On ubuntu today data was imported, but throwing error :
'ascii' codec can't decode byte 0xc3 in position 57: 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
> 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)


[prev in list] [next in list] [prev in thread] [next in thread]