p

    Petr Postulka

    3 weeks ago
    hi all, I would like to ask for the help ... we started getting the following error when querying the data from quest, any idea how we can resolve this? thx a lot in advance for the help
    2022-09-01T06:44:48.417037Z E i.q.c.p.PGConnectionContext not enough space in buffer for row data [buffer=1048576]
    Sep 01 06:44:48 questdb-preprod-0 questdb[1186]: 2022-09-01T06:44:48.417077Z E i.q.c.p.PGConnectionContext error [pos=-1, msg=`server configuration error: not enough space in send buffer for row data`, errno=`0]
    Sep 01 06:44:51 questdb-preprod-0 questdb[1186]: 2022-09-01T06:44:51.504769Z E i.q.c.p.PGConnectionContext not enough space in buffer for row data [buffer=1048576]
    Sep 01 06:44:51 questdb-preprod-0 questdb[1186]: 2022-09-01T06:44:51.504816Z E i.q.c.p.PGConnectionContext error [pos=-1, msg=`server configuration error: not enough space in send buffer for row data`, errno=`0]
    Sep 01 06:44:52 questdb-preprod-0 questdb[1186]: 2022-09-01T06:44:52.535557Z I i.q.c.p.PGConnectionContext disconnected on read [code=-2]
    Nicolas Hourcard

    Nicolas Hourcard

    3 weeks ago
    @Imre @Adam Cimarosti would you be able to say if this is a bug versus a config issue very quickly?
    Imre

    Imre

    3 weeks ago
    looks to me that this problem could be resolved by increasing the buffer size. try to increase it using the below property in the config:
    pg.send.buffer.size
    currently it is using the default 1 Mb
    pg.send.buffer.size=1M
    p

    Petr Postulka

    3 weeks ago
    Will try, thx
    Imre

    Imre

    3 weeks ago
    it should be sized that it can fit at least a single row
    p

    Petr Postulka

    3 weeks ago
    Makes complete sense
    @Imre it seems it helps, does the buffer size affect performance of the queries somehow? Or not really?
    I mean should we use 2M for example or don't care much about the size and put there for example 10M (to be on the safe side) What would be the difference and how accurate we should try to be?
    Imre

    Imre

    3 weeks ago
    it should not affect performance. we will read only the part of the buffer which actually has data in it. not sending the empty/unused part.
    i would go with the 10M if that is the safe setting
    the only thing it has an impact on is your memory footprint