Paul J Stevens wrote:
Matthew, I'm still suspicious of the savepoint calls. I've disabled the
code in question. Could you please try again? You may start seeing query
errors, but at least they won't be fatal.
Nope...
dbpgsql.c,db_query: executing query [BEGIN]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Return-Path']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(2,786556,'<[EMAIL PROTECTED]>')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Original-To']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(75,786556,'[EMAIL PROTECTED]')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Delivered-To']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(76,786556,'[EMAIL PROTECTED]')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Received']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (3,786556,'by
snappy.tocr.com (Postfix, from userid 99) id 9BEC995026A; Mon, 4
Jul 2005 17:47:23 -0400 (EDT)')]
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (3,786556,'from
bdy93-6-82-237-45-78.fbx.proxad.net (bdy93-6-82-237-45-78.fbx.proxad.net
[82.237.45.78]) by snappy.tocr.com (Postfix) with SMTP id
0CB43950264; Mon, 4 Jul 2005 17:47:22 -0400 (EDT)')]
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (3,786556,'from
jockey.intel.com (monica.intel.com) by caduceus.jf.intel.com
(8.11.2/8.11.0/d: outer.mc,v 1.55) with ESMTP id h056ols78137
for <[EMAIL PROTECTED]>; Tue, 05 Jul 2005 03:38:58 +0400')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Date']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (9,786556,'Mon, 04
Jul 2005 22:39:58 -0100')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='From']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (5,786556,'"Alden
Strong" <[EMAIL PROTECTED]>')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='To']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(7,786556,'[EMAIL PROTECTED]')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Cc']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(45,786556,'[EMAIL PROTECTED]')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Subject']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (8,786556,'[SPAM]
Information')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='Message-ID']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(4,786556,'<[EMAIL PROTECTED]>')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Spam-Prev-Subject']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(1483,786556,'Information')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Spam-Flag']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (37,786556,'YES')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Spam-Checker-Version']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES
(10,786556,'SpamAssassin 3.0.3 (2005-04-27) on snappy.tocr.com')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Spam-Level']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (11,786556,'*****')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Spam-Status']
dbpgsql.c,db_query: executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (12,786556,'Yes,
score=5.1 required=5.0 tests=ALL_NATURAL,
HELO_DYNAMIC_IPADDR,INFO_TLD autolearn=no version=3.0.3')]
dbpgsql.c,db_query: executing query [SELECT id FROM dbmail_headername
WHERE headername='X-Spam-Report']
Segmentation fault (core dumped)
[EMAIL PROTECTED] dbmail]$
[EMAIL PROTECTED] dbmail]$ gdb /usr/local/dbmail/sbin/dbmail-util core.8279
(gdb) bt
#0 0x00a03474 in vfprintf () from /lib/tls/libc.so.6
#1 0x009ffbfc in buffered_vfprintf () from /lib/tls/libc.so.6
#2 0x009ffe3b in vfprintf () from /lib/tls/libc.so.6
#3 0x00a0845f in fprintf () from /lib/tls/libc.so.6
#4 0x004a9bb8 in trace (level=TRACE_DEBUG, formatstring=0x5d7d5e
"%s,%s: executing query [%s]") at debug.c:61
#5 0x005d75b0 in db_query (
the_query=0x97f4bc0 "INSERT INTO dbmail_headervalue (headername_id,
physmessage_id, headervalue) VALUES (38,786556,'* 2.8
HELO_DYNAMIC_IPADDR Relay HELO''d using suspicious hostname (IP addr
1)\t* 1.8 ALL_NATURAL BODY: S"...) at dbpgsql.c:277
#6 0x004bbd37 in db_query (
the_query=0x97f4bc0 "INSERT INTO dbmail_headervalue (headername_id,
physmessage_id, headervalue) VALUES (38,786556,'* 2.8
HELO_DYNAMIC_IPADDR Relay HELO''d using suspicious hostname (IP addr
1)\t* 1.8 ALL_NATURAL BODY: S"...) at dbmodule.c:129
#7 0x004a4f4e in _header_cache (header=0x97f8960 "X-Spam-Report",
value=0x97f8978 "* 2.8 HELO_DYNAMIC_IPADDR Relay HELO'd using
suspicious hostname (IP addr 1)\t* 1.8 ALL_NATURAL BODY: Spam is 100%
natural?!\t* 0.5 INFO_TLD URI: Contains an URL in the INFO top-level
domain", user_data=0x97f63b0) at dbmail-message.c:896
#8 0x00855d90 in g_mime_header_foreach (header=0x97f4e80, func=0x4a4ea4
<_header_cache>, user_data=0x97f63b0) at gmime-header.c:416
#9 0x004a5800 in dbmail_message_headers_cache (self=0x97f63b0) at
dbmail-message.c:825
#10 0x004ac6f7 in db_set_headercache (lost=0x97e2f00) at db.c:1732
#11 0x0804ae45 in main (argc=2, argv=0xbfe49104) at maintenance.c:697
