Paul J Stevens wrote:
This looks like a level 3 or 4 trace. Could you please provide a level 5
trace?
Did you do as suggested: run dbmail-utils -ay?
yes I did
here is the level 5 for the smtp I'm using PostgreSQL 8.0.3
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [BEGIN]
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE
userid='[EMAIL PROTECTED]@__']
Sep 6 06:18:36 debian dbmail/smtp[1886]: misc.c,create_unique_id:
created: f62e398dbb67086b653a17a8f8381568
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='316']
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES ('0', CURRENT_TIMESTAMP)]
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_physmessage_id_seq')]
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id,
unique_id,recent_flag, status) VALUES ('987', '323959',
'f62e398dbb67086b653a17a8f8381568', '1', '5')]
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_message_idnr_seq')]
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'324498']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('1','Received: from CHANGED (debian [127.0.0.1])
^Iby CHANGED (Postfix) with ESMTP id 7A966601FD; ^IMon, 5 Sep 2005
14:21:37 -0400 (EDT) Received: from CHANGED (unknown [211.155.235.11])
^Iby CHANGED (Postfix) with SMTP id 024AC601F2; ^IMon, 5 Sep 2005
14:21:27 -0400 (EDT) X-Message-Info: 03EG895Pyoc5UT18p[1 Message-Id:
<[EMAIL PROTECTED]> Date: Mon, 5 Sep 2005
14:21:27 -0400 (EDT) From: [EMAIL PROTECTED] To: undisclosed-recipients:
; ', '481', '323959')]
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_messageblk_idnr_seq')]
Sep 6 06:18:36 debian dbmail/smtp[1886]: store_message_temp():
allocating [524288] bytes of memory for readblock
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [UPDATE dbmail_messages SET unique_id =
'f62e398dbb67086b653a17a8f8381568', status = '0' WHERE message_idnr =
'324498']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'324498']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [UPDATE dbmail_physmessage SET messagesize = '481', rfcsize =
'13835055048805057005' WHERE id = '323959']
here comes the error
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c, db_query: Error
executing query [UPDATE dbmail_physmessage SET messagesize = '481',
rfcsize = '13835055048805057005' WHERE id = '323959'] : [ERROR: value
"13835055048805057005" is out of range for type bigint ]
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_physmessage_set_sizes:
error setting messagesize and rfcsize for physmessage [323959]
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_update_message: error
updating physmessage [323959]. The database might be inconsistent. Run
dbmail-util
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT dbmail_mailboxes.owner_idnr FROM dbmail_mailboxes,
dbmail_messages WHERE dbmail_mailboxes.mailbox_idnr =
dbmail_messages.mailbox_idnr AND dbmail_messages.message_idnr = '324498']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c, db_query: Error
executing query [SELECT dbmail_mailboxes.owner_idnr FROM
dbmail_mailboxes, dbmail_messages WHERE dbmail_mailboxes.mailbox_idnr =
dbmail_messages.mailbox_idnr AND dbmail_messages.message_idnr =
'324498'] : [ERROR: current transaction is aborted, commands ignored
until end of transaction block ]
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_get_useridnr: query failed
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_add_quotum_used:
adding 481 to mailsize
Sep 6 06:18:36 debian dbmail/smtp[1886]:
db.c.user_idnr_is_delivery_user_idnr: looking up user_idnr for
[EMAIL PROTECTED]@__
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE
userid='[EMAIL PROTECTED]@__']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c, db_query: Error
executing query [SELECT user_idnr FROM dbmail_users WHERE
userid='[EMAIL PROTECTED]@__'] : [ERROR: current transaction
is aborted, commands ignored until end of transaction block ]
Sep 6 06:18:36 debian dbmail/smtp[1886]: authsql.c,__auth_query: error
executing query
Sep 6 06:18:36 debian dbmail/smtp[1886]: authsql.c,auth_user_exists:
could not execute query
Sep 6 06:18:36 debian dbmail/smtp[1886]:
db.c,user_idnr_is_delivery_user_idnr: error looking up user_idnr for
DBMAIL_DELIVERY_USERNAME
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_add_quotum_used: call
to user_idnr_is_delivery_user_idnr() failed
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT dbmail_mailboxes.owner_idnr FROM dbmail_mailboxes,
dbmail_messages WHERE dbmail_mailboxes.mailbox_idnr =
dbmail_messages.mailbox_idnr AND dbmail_messages.message_idnr = '324498']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c, db_query: Error
executing query [SELECT dbmail_mailboxes.owner_idnr FROM
dbmail_mailboxes, dbmail_messages WHERE dbmail_mailboxes.mailbox_idnr =
dbmail_messages.mailbox_idnr AND dbmail_messages.message_idnr =
'324498'] : [ERROR: current transaction is aborted, commands ignored
until end of transaction block ]
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_get_useridnr: query failed
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_update_message: error
calculating quotum used for user [18446744073709551615]. Database might
be inconsistent. run dbmail-util
Sep 6 06:18:36 debian dbmail/smtp[1886]: pipe.c,store_message_temp:
error updating message [324498]. Trying to clean up
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'324498']
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c, db_query: Error
executing query [SELECT physmessage_id FROM dbmail_messages WHERE
message_idnr = '324498'] : [ERROR: current transaction is aborted,
commands ignored until end of transaction block ]
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_get_physmessage_id:
error getting physmessage_id
Sep 6 06:18:36 debian dbmail/smtp[1886]: db.c,db_delete_message: error
getting physmessage_id
Sep 6 06:18:36 debian dbmail/smtp[1886]: pipe.c,store_message_temp
error deleting message [324498]. Database might be inconsistent, run
dbmail-util
Sep 6 06:18:36 debian dbmail/smtp[1886]: pipe.c, insert_messages:
failed to store temporary message.
Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
query [ROLLBACK]
Sep 6 06:18:36 debian dbmail/smtp[1886]: main(): insert_messages failed
Sep 6 06:18:36 debian dbmail/smtp[1886]: main(): freeing dsnuser list
Sep 6 06:18:36 debian dbmail/smtp[1886]: dsn.c, dsnuser_free: dsnuser freed
Sep 6 06:18:36 debian dbmail/smtp[1886]: main(): freeing all other lists
Sep 6 06:18:36 debian dbmail/smtp[1886]: main(): freeing memory blocks
Sep 6 06:18:36 debian dbmail/smtp[1886]: main(): they're all free.
we're done.
Sep 6 06:18:36 debian dbmail/smtp[1886]: main(): exit code is [75].
Does this 2 tables dbmail_physmessage and dbmail_message should have
the same row count ?
dbmail=> select count(*) from dbmail_physmessage;
count
-------
8115
(1 row)
dbmail=> select count(*) from dbmail_messages;
count
-------
8124
(1 row)
Thank you very much
Leonel
