[Bro-Dev] [JIRA] (BIT-1325) multiple sqlite writers to same db file yields "database is locked" error

[Tony Cebzanov (JIRA)]

Tony Cebzanov created BIT-1325:
----------------------------------

             Summary: multiple sqlite writers to same db file yields "database is locked" error
                 Key: BIT-1325
                 URL: https://bro-tracker.atlassian.net/browse/BIT-1325
             Project: Bro Issue Tracker
          Issue Type: Problem
          Components: Bro
    Affects Versions: 2.2
            Reporter: Tony Cebzanov


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

{code}
    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);
{code}

I get the following error:

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



--
This message was sent by Atlassian JIRA
(v6.4-OD-15-055#64014)