Hi!
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.
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.)
-------------------- 8< --------------------
$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 processes;
# try the SELECT again, it will most likely succeed this time;
# SELECT after INSERT also avoids the need for a working
last_insert_id()
-------------------- 8< --------------------
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?
Cheers,
--leo
P.S.: I'm using perl-5.8.3, DBI-1.53-1 and DBD::SQLite-1.13, compiled
against sqlite-3.3.6.
--
-----------------------------------------------------------------------
[EMAIL PROTECTED] Fax: +43-1-31336-906050
Zentrum fuer Informatikdienste - Wirtschaftsuniversitaet Wien - Austria
-------------------------------------------------------------------------
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/
