Discussions

Expand all | Collapse all

Ran out of slots in the query output buffer error

  • 1.  Ran out of slots in the query output buffer error

    Posted 12-02-2019 05:34
    Edited by Omnisci user 12-03-2019 04:56
    Hi
    i am getting this error as  "Ran out of slots in the query output buffer" frequently for some queries. is there any way to sort out this problem

    #Core
    #Immerse


  • 2.  RE: Ran out of slots in the query output buffer error

    Posted 12-02-2019 06:32
    Hi,

    try to disable the watchdog setting the parameter enable-watchdog to false. the system should retry with a bigger buffer value


  • 3.  RE: Ran out of slots in the query output buffer error

    Posted 12-23-2019 02:32
    Hi @Candido Dessanti

    we have disabled watchdog to false but it is still showing same error

    added below line in conf file
    enable-watchdog=false



  • 4.  RE: Ran out of slots in the query output buffer error

    Posted 12-23-2019 02:42
    Hi,

    be sure the parameter is effectively used by the system checking into the logs; when you start the server you should find a line like this

    2019-12-23T11:39:22.751670 I 124937 MapDServer.cpp:1117 OmniSci started with data directory at '/opt/mapd_storage/data50'
    2019-12-23T11:39:22.751678 I 124937 MapDServer.cpp:1126 Watchdog is set to false

    if the watchdog is disabled and you are still having this error please post the offending queries, tables and estimated cardinalities of those queries, so we can try to reproduce the issue