[Bro-Dev] [JIRA] (BIT-1325) multiple sqlite writers to same db file yields "database is locked" error
Jon Siwek (JIRA)
jira at bro-tracker.atlassian.net
Fri Mar 13 08:14:01 PDT 2015
[ https://bro-tracker.atlassian.net/browse/BIT-1325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jon Siwek reassigned BIT-1325:
------------------------------
Assignee: Johanna Amann
> 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.3
> Reporter: Tony Cebzanov
> Assignee: Johanna Amann
> Labels: logging, sqlite
> Fix For: 2.4
>
> Attachments: bro_sqlite_busy_wait.patch
>
>
> 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)
More information about the bro-dev
mailing list