graphsense
Cassandra version
I am interested what Cassandra version I should use. I had Cassandra version 4.0-rc1 on my worker nodes and I got error message in transformation step something like this.
22/04/27 14:33:02 WARN pool.ChannelPool: [s0|/192.168.66.153:9042] Fatal error while initializing pool, forcing the node down (UnsupportedProtocolVersionException: [/192.168.66.153:9042] Host does not support protocol version V5) 22/04/27 14:33:02 WARN pool.ChannelPool: [s0|/192.168.66.114:9042] Fatal error while initializing pool, forcing the node down (UnsupportedProtocolVersionException: [/192.168.66.114:9042] Host does not support protocol version V5)
For this I understood I had to downgrade cassandra version to 3.0.26. Afterwards I had to clean up the /var/lib/cassandra/data/* folder
I re-run the second step ingest and now I get error, because cassandra 3 does not support PER PARTITION keyword.
Unlocking data directory.
[root@graphsense-master ingest]# docker-compose run ingest-btc
WARNING: The GETH_IPC variable is not set. Defaulting to a blank string.
Creating ingest_ingest-btc_run ... done
Creating Cassandra keyspace btc_raw
Error: Keyspace "btc_raw" already exists.
----------------------------------------------------------
Last parsed block: 299615 (2014-05-07 22:44:18 UTC)
Traceback (most recent call last):
File "/usr/local/bin/blocksci_export.py", line 644, in <module>
main()
File "/usr/local/bin/blocksci_export.py", line 491, in main
most_recent_block = query_most_recent_block(cluster, args.keyspace)
File "/usr/local/bin/blocksci_export.py", line 57, in query_most_recent_block
result = session.execute(simple_stmt)
File "cassandra/cluster.py", line 2618, in cassandra.cluster.Session.execute
File "cassandra/cluster.py", line 4894, in cassandra.cluster.ResponseFuture.result
cassandra.protocol.SyntaxException: <Error from server: code=2000 [Syntax error in CQL query] message="line 1:33 no viable alternative at input 'PER' (SELECT block_id_group FROM [block] PER...)">
