Uploaded image for project: 'Bro Issue Tracker'
  1. BIT-1325

multiple sqlite writers to same db file yields "database is locked" error

    Details

    • Type: Problem
    • Status: Closed
    • Priority: Normal
    • Resolution: Merged
    • Affects Version/s: git/master
    • Fix Version/s: 2.5
    • Component/s: Bro
    • Labels:
    • Sprint:

      Description

      I want to have multiple log streams logged to the same sqlite database, but when trying to log to sqlite using the following configuration:

          local filter: Log::Filter =
              [
              $name="sqlite_conn",
              $path="analysis",
              $config=table(["tablename"] = "conn"),
              $writer=Log::WRITER_SQLITE
              ];
      
          Log::add_filter(Conn::LOG, filter);
      
          local http_filter: Log::Filter =
              [
              $name="sqlite_http",
              $path="analysis",
              $config=table(["tablename"] = "http"),
              $writer=Log::WRITER_SQLITE
              ];
      
          Log::add_filter(HTTP::LOG, http_filter);
      

      I get the following error:

      error: analysis/Log::WRITER_SQLITE: Error executing table creation statement: database is locked
      

        Attachments

          Activity

            People

            • Assignee:
              robin Robin Sommer
              Reporter:
              tonycpsu Tony Cebzanov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: