[Bro-Dev] [JIRA] (BIT-1325) multiple sqlite writers to same db file yields "database is locked" error
Robin Sommer (JIRA)
jira at bro-tracker.atlassian.net
Fri Apr 10 11:40:00 PDT 2015
[ https://bro-tracker.atlassian.net/browse/BIT-1325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Robin Sommer updated BIT-1325:
------------------------------
Priority: Low (was: Normal)
> 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
> Priority: Low
> 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-16-006#64014)
More information about the bro-dev
mailing list