Error querying postgres within a light thread

l.lafon34 · 2014-07-11T02:39:58+00:00

Hi,I have started the development of a cassandra cql driver in Lua.The code is available at https://github.com/jbochi/lua-resty-cassandra.It has several unim...

Error querying postgres within a light thread

l.lafon34

Hello,

We use "ngx.timer.at" in order to push data from redis to postgres.

Sometimes we have the following error: "failed to send query: cannot send query in the current context: 2"

After checking the lua-resty-postgres code, current context:2 means "STATE_COMMAND_SENT".

If someone have a solution for this problem.

agentzh

Hello!

On Thu, Jul 10, 2014 at 7:24 AM,  l.lafon34 wrote:
> Sometimes we have the following error: "failed to send query: cannot send
> query in the current context: 2"
>
> After checking the lua-resty-postgres code, current context:2 means
> "STATE_COMMAND_SENT".
>

I know very little about the lua-resty-postgres library you're using.
But from the error message, maybe you should read all the results for
your previous query before sending another query?

BTW, please subscribe to this list before posting otherwise your posts
always require manual moderation. Thank you for your cooperation.

Regards,
-agentzh