Leo,
> I'm experiencing some occasional crashes in sqlite-code, using an SQL
> enabled amavisd-new-2.5.0-pre3. Those crashes appear once every 1000 mails.
It's been a while since the last time I tried it with SQLite.
In my experience it was very nice for read-only lookups,
but totally inappropriate for concurrect use as a sql logging
database for amavisd (for any load higher than light)
because of its coarse locking granularity.
> The funny thing is that they all occur in the same line: it is the
> second $conn_h->execute() in find_or_save_addr(). (I verified this by
> adding do_log entries before and after that line.)
>
> $conn_h->begin_work_nontransaction; # (re)connect if not connected
> eval { $conn_h->execute($ins_adr,$naddr,$invdomain) };
> my($eval_stat) = $@; chomp($eval_stat);
> # INSERT may have failed because of race condition with other
>
> It seems to be a bug in sqlite but I'm wondering why I don't get any
> core-dumps, even though I do set the resource-limit for core-files to
> unlimited before starting amavisd:
> ulimit -S -c unlimited
> Are there any known problems with sqlite?
> P.S.: I'm using perl-5.8.3, DBI-1.53-1 and DBD::SQLite-1.13, compiled
> against sqlite-3.3.6.
I'd try with 3.3.14 first, before investing any further time in
troubleshooting. There are two entries in later release notes
that might explain crashes.
Mark
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
