You need to install cql driver for python as it says. % easy_install cql If you don't have easy_install, you need to install it first. You will be able to find easy_install by querying "easy_install python" on google.
maki On 2012/04/17, at 20:18, Tamar Fraenkel <ta...@tok-media.com> wrote: > Thanks for answering! > I unzipped the cassandra taken from > http://off.co.il/apache/cassandra/1.0.9/apache-cassandra-1.0.9-bin.tar.gz. > I changed the cassandra init script to run from the new installation > (CASSANDRA_HOME). > > I retried it, and found out that the reason Cassandra didn't start the > previous time was a typo in the init script. > So now Cassandra 1.0.9 is up, but cqlsh still give me the following error, > even when I make sure it is started from the 1.0.9 bin (Cassandra-cli works > well): > Python CQL driver not installed, or not on PYTHONPATH. > You might try "easy_install cql". > > Python: /usr/bin/python > Module load path: ['/usr/share/apache-cassandra-1.0.9/bin/../pylib', > '/usr/share/apache-cassandra-1.0.9/bin', '/usr/lib/python2.7', > '/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk', > '/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', > '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', > '/usr/lib/python2.7/dist-packages/PIL', > '/usr/lib/python2.7/dist-packages/gst-0.10', > '/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7', > '/usr/lib/python2.7/dist-packages/ubuntu-sso-client', > '/usr/lib/python2.7/dist-packages/ubuntuone-client', > '/usr/lib/python2.7/dist-packages/ubuntuone-control-panel', > '/usr/lib/python2.7/dist-packages/ubuntuone-couch', > '/usr/lib/python2.7/dist-packages/ubuntuone-installer', > '/usr/lib/python2.7/dist-packages/ubuntuone-storage-protocol'] > > Error: No module named cql > > > Also, do you have a good step by step upgrade guide for tar.gz? > > Thanks, > > Tamar Fraenkel > Senior Software Engineer, TOK Media > > > > ta...@tok-media.com > Tel: +972 2 6409736 > Mob: +972 54 8356490 > Fax: +972 2 5612956 > > > > > > On Tue, Apr 17, 2012 at 12:15 PM, aaron morton <aa...@thelastpickle.com> > wrote: >> 1. No cql is installed now. Do I need to download and install separately? > > If you have just unzipped the bin distrobution nothing will be installed, it > will only be in the unzipped file locations. cqlsh is in the bin/ directory. > > As well as the datastax packages there are Debian packages from Apache, see > http://cassandra.apache.org/download/ > >> 2. Cassandra won't start, I got the following exception below. > > > This message >> INFO [RMI TCP Connection(2)-127.0.0.1] 2012-04-16 00:25:37,980 >> StorageService.java (line 667) DRAINED > Says that the sever was drained via the JMX / Node Tool interface. The > RejectedExecutionError that followed are a result of the server shutting > down. > >> 3. While at it, does someone know if Hector 1.0.3 supports Cassandra 1.0.9? > > It should do, cassandra 1.0.9 is compatible with previous 1.0.X releases. > > Cheers > > > ----------------- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 16/04/2012, at 7:54 PM, Tamar Fraenkel wrote: > >> Hi! >> I had datastax 1.0.7 installed on ubuntu. >> I downloaded >> http://off.co.il/apache/cassandra/1.0.9/apache-cassandra-1.0.9-bin.tar.gz >> and unzipped it. I left both versions installed, but changed my service >> script to start the 1.0.9. >> Two problems: >> >> 1. No cql is installed now. Do I need to download and install separately? >> 2. Cassandra won't start, I got the following exception below. >> 3. While at it, does someone know if Hector 1.0.3 supports Cassandra 1.0.9? >> >> Thanks, >> Tamar >> >> INFO [FlushWriter:2] 2012-04-16 00:25:37,879 Memtable.java (line 283) >> Completed flushing >> /var/lib/cassandra/data/OpsCenter/events_timeline-hc-28-Data.db (79 bytes) >> INFO [RMI TCP Connection(2)-127.0.0.1] 2012-04-16 00:25:37,980 >> StorageService.java (line 667) DRAINED >> ERROR [CompactionExecutor:3] 2012-04-16 00:25:38,021 >> AbstractCassandraDaemon.java (line 139) Fatal exception in thread >> Thread[CompactionExecutor:3,1,RMI Runtime] >> java.util.concurrent.RejectedExecutionException >> at >> java.util.concurrent.ThreadPoolExecutor$AbortPolicy.rejectedExecution(ThreadPoolExecutor.java:1768) >> at >> java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:767) >> at >> java.util.concurrent.ScheduledThreadPoolExecutor.delayedExecute(ScheduledThreadPoolExecutor.java:215) >> at >> java.util.concurrent.ScheduledThreadPoolExecutor.schedule(ScheduledThreadPoolExecutor.java:397) >> at >> java.util.concurrent.ScheduledThreadPoolExecutor.submit(ScheduledThreadPoolExecutor.java:470) >> at >> org.apache.cassandra.io.sstable.SSTableDeletingTask.schedule(SSTableDeletingTask.java:67) >> at >> org.apache.cassandra.io.sstable.SSTableReader.releaseReference(SSTableReader.java:742) >> at >> org.apache.cassandra.db.DataTracker.removeOldSSTablesSize(DataTracker.java:316) >> at org.apache.cassandra.db.DataTracker.replace(DataTracker.java:287) >> at >> org.apache.cassandra.db.DataTracker.replaceCompactedSSTables(DataTracker.java:233) >> at >> org.apache.cassandra.db.ColumnFamilyStore.replaceCompactedSSTables(ColumnFamilyStore.java:1006) >> at >> org.apache.cassandra.db.compaction.CompactionTask.execute(CompactionTask.java:200) >> at >> org.apache.cassandra.db.compaction.CompactionManager$1.call(CompactionManager.java:134) >> at >> org.apache.cassandra.db.compaction.CompactionManager$1.call(CompactionManager.java:114) >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >> at java.lang.Thread.run(Thread.java:662) >> INFO [CompactionExecutor:3] 2012-04-16 00:25:38,025 CompactionTask.java >> (line 113) Compacting >> [SSTableReader(path='/var/lib/cassandra/data/OpsCenter/events_timeline-hc-25-Data.db'), >> >> SSTableReader(path='/var/lib/cassandra/data/OpsCenter/events_timeline-hc-27-Data.db'), >> >> SSTableReader(path='/var/lib/cassandra/data/OpsCenter/events_timeline-hc-28-Data.db'), >> >> SSTableReader(path='/var/lib/cassandra/data/OpsCenter/events_timeline-hc-26-Data.db')] >> ERROR [CompactionExecutor:3] 2012-04-16 00:25:38,051 >> AbstractCassandraDaemon.java (line 139) Fatal exception in thread >> Thread[CompactionExecutor:3,1,RMI Runtime] >> java.util.concurrent.RejectedExecutionException >> at >> java.util.concurrent.ThreadPoolExecutor$AbortPolicy.rejectedExecution(ThreadPoolExecutor.java:1768) >> at >> java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:767) >> at >> java.util.concurrent.ScheduledThreadPoolExecutor.delayedExecute(ScheduledThreadPoolExecutor.java:215) >> at >> java.util.concurrent.ScheduledThreadPoolExecutor.schedule(ScheduledThreadPoolExecutor.java:397) >> at >> java.util.concurrent.ScheduledThreadPoolExecutor.submit(ScheduledThreadPoolExecutor.java:470) >> at >> org.apache.cassandra.io.sstable.SSTableDeletingTask.schedule(SSTableDeletingTask.java:67) >> at org.apache.cassandra
