thibaultcha / lua-cassandra

Pure Lua driver for Apache Cassandra
https://thibaultcha.github.io/lua-cassandra
Other
98 stars 35 forks source link

socket time out when reading large amount of data #53

Closed JilinXie closed 8 years ago

JilinXie commented 8 years ago

Hi, I'm trying to requesting all data from a table, which contains about 19000 rows. session:execute("select * from table", nil, {page_size=1000, auto_paging=true})

With the default page_size of 1000, I found nginx logs such error:

But if I cange page_size to 20000, no socket timeout occurs.

I'm trying to understand why this happens. And I'm not sure if this is a problem about my cassandra or my misuse of this lib. So, any ideas

thibaultcha commented 8 years ago

Were you able to resolve this?

(Sorry for the delayed response)

thibaultcha commented 8 years ago

Well, considering this resolved then; especially since the 1.0.0 release which rewrites this library. Feel free to re-open if the issue persists and if you have some more details about it.