Thanks!!! Two simple actions 1. sudo apt-get install python-setuptools 2. sudo easy_install cql
And it did the trick! But just to be on the safe side, before I move to upgrade our staging environment, does anyone know a detailed description of how to upgrade cassandra installed from tar.gz? or how to upgrade Amazon EC2 datastax AMI? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Apr 17, 2012 at 4:56 PM, Watanabe Maki <watanabe.m...@gmail.com>wrote: > 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 > > [image: Inline image 1] > > 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.gzand >> 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) >> >> atjava.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) >> >> atorg.apache.cassandra.db.compaction.CompactionTask.execute(CompactionTask.java:200) >> >> atorg.apache.cassandra.db.compaction.CompactionManager$1.call(CompactionManager.java:134) >> >> atorg.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) >> >> atjava.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 >> >>
<<tokLogo.png>>
