# Cassandra Node issue for query using timestamp

**URL:** <https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453>\
**Category:** General\
**Created:** [8 April 2020 10:24 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453 "2020-04-08T10:24:05Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcouelier](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@jcouelier](https://discourse.nodered.org/u/jcouelier)\
**Post date:** [8 April 2020 10:24 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/1 "2020-04-08T10:24:05Z")

</div>

Hello nodered community,

I am creating mDashboards to display historical events in my system. My database is a Cassandra database, so i am using the Cassandra Node.  
Unfortunately, my requests are not working when i am trying to retrieve data in the past.  
In my flow i am formatting my request and sending my request to Cassandra node.

Error seems be about buffer length at Cassandra level but i did find interesting information on the net about it.

Below is my traces:

3 Apr 11:40:03 - [info] [function:convert UNIXtime to startDate] 1585309203485

3 Apr 11:40:03 - [info] [function:convert UNIXtime to startDate] Fri Mar 27 2020 11:40:03 GMT+0000 (UTC)

3 Apr 11:40:03 - [info] [function:convert UNIXtime to startDate] 2020

3 Apr 11:40:03 - [info] [function:data extraction] select tagdataid, timestamp, assetidentifier, batterylevel, temperature, energy, humidity, power, pressure, profilename, tagidentifier from lbs.tagdatatable where assetidentifier='tousSensors' and timestamp\>='2020-3-27 0:0:0.0' and timestamp\<='2020-4-1 23:59:59.999' allow filtering;

3 Apr 11:40:03 - [info] [cassandra:b1d642fe.1031c] Executing CQL query:  
3 Apr 11:40:03 - [info] [function:convert UNIXtime to endDate] 1585914003485  
3 Apr 11:40:03 - [info] [function:convert UNIXtime to endDate] Fri Apr 03 2020 11:40:03 GMT+0000 (UTC)  
3 Apr 11:40:03 - [info] [function:convert UNIXtime to endDate] 2020  
3 Apr 11:40:03 - [info] [function:data extraction] select tagdataid, timestamp, assetidentifier, batterylevel, temperature, energy, humidity, power, pressure, profilename, tagidentifier from lbs.tagdatatable where assetidentifier='tousSensors' and timestamp\>='2020-3-27 0:0:0.0' and timestamp\<='2020-4-3 23:59:59.999' allow filtering;  
3 Apr 11:40:03 - [info] [cassandra:b1d642fe.1031c] Executing CQL query:  
3 Apr 11:40:05 - [red] Uncaught Exception:  
3 Apr 11:40:05 - RangeError: Trying to access beyond buffer length  
at FrameReader.checkOffset (/usr/src/node-red/node\_modules/cassandra-driver/lib/readers.js:119:15)  
at FrameReader.readString (/usr/src/node-red/node\_modules/cassandra-driver/lib/readers.js:107:8)  
at FrameReader.readError (/usr/src/node-red/node\_modules/cassandra-driver/lib/readers.js:315:22)  
at Parser.parseBody (/usr/src/node-red/node\_modules/cassandra-driver/lib/streams.js:180:66)  
at Parser.\_transform (/usr/src/node-red/node\_modules/cassandra-driver/lib/streams.js:135:10)  
at Parser.Transform.\_read (\_stream\_transform.js:186:10)  
at Parser.Transform.\_write (\_stream\_transform.js:174:12)  
at doWrite (\_stream\_writable.js:396:12)  
at writeOrBuffer (\_stream\_writable.js:382:5)  
at Parser.Writable.write (\_stream\_writable.js:290:11)  
npm ERR! code ELIFECYCLE  
npm ERR! errno 1  
npm ERR! [node-red-docker@1.0.0](mailto:node-red-docker@1.0.0) start: `node $NODE_OPTIONS node_modules/node-red/red.js -v $FLOWS "--userDir" "/data"`  
npm ERR! Exit status 1  
npm ERR!  
npm ERR! Failed at the [node-red-docker@1.0.0](mailto:node-red-docker@1.0.0) start script.  
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

If someone is able to help me to understand this issue and to fix it, thank you in advance.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [9 April 2020 22:08 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/2 "2020-04-09T22:08:31Z")

</div>

That looks like a bug in that Cassandra node. I would looks at the node’s project page to see if there are any known issues, and if not raise one.

---

<div class="post-metadata">

**Author:** ![jcouelier](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@jcouelier](https://discourse.nodered.org/u/jcouelier)\
**Post date:** [11 April 2020 12:13 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/3 "2020-04-11T12:13:33Z")

</div>

Thanks a lot dceejay for your prompt answer.  
Waiting for the results of your investigations

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [11 April 2020 12:48 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/4 "2020-04-11T12:48:39Z")

</div>

I am not investigating 🙂

---

<div class="post-metadata">

**Author:** ![jcouelier](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@jcouelier](https://discourse.nodered.org/u/jcouelier)\
**Post date:** [11 April 2020 13:03 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/5 "2020-04-11T13:03:08Z")

</div>

Sorry, i did not correctly understand your first answer 🙂  
Could you just tell me where i could find the project page of the cassandra node please (i am a newbee on NodeRed)

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [11 April 2020 13:43 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/6 "2020-04-11T13:43:59Z")

</div>

follow the links to github for whichever one you installed as there are two - [https://flows.nodered.org/search?term=cassandra](https://flows.nodered.org/search?term=cassandra)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [10 June 2020 13:44 UTC](https://discourse.nodered.org/t/cassandra-node-issue-for-query-using-timestamp/24453/7 "2020-06-10T13:44:01Z")

</div>

Closed on 10 June 2020 13:44 UTC

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.