A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=475 ====================================================================== Reported By: lrosenman Assigned To: ====================================================================== Project: DBMail Issue ID: 475 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 14-Dec-06 23:56 CET Last Modified: 15-Dec-06 17:26 CET ====================================================================== Summary: Invalid timestamps generated to PostgreSQL backend Description: Random messages coming in via dbmail-smtp are failed going into a PostgreSQL 8.1.5 (SQL_ASCII) Database.
====================================================================== ---------------------------------------------------------------------- lrosenman - 14-Dec-06 23:59 ---------------------------------------------------------------------- Here's the DB log for the same message (First one): $ grep 'pg-prod\[38071\]' /var/log/pg-prod.log Dec 14 15:42:45 thebighonker pg-prod[38071]: [1-1] <[unknown]%[unknown]> LOG: connection received: host=localhost port=63419 Dec 14 15:42:45 thebighonker pg-prod[38071]: [2-1] <ler%dbmail> LOG: connection authorized: user=ler database=dbmail Dec 14 15:42:45 thebighonker pg-prod[38071]: [3-1] <ler%dbmail> LOG: statement: SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0 Dec 14 15:42:45 thebighonker pg-prod[38071]: [4-1] <ler%dbmail> LOG: duration: 6.107 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [5-1] <ler%dbmail> LOG: statement: SELECT 1=1 FROM dbmail_headervalue LIMIT 1 OFFSET 0 Dec 14 15:42:45 thebighonker pg-prod[38071]: [6-1] <ler%dbmail> LOG: duration: 1.287 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [7-1] <ler%dbmail> LOG: statement: SELECT 1=1 FROM dbmail_envelope LIMIT 1 OFFSET 0 Dec 14 15:42:45 thebighonker pg-prod[38071]: [8-1] <ler%dbmail> LOG: duration: 1.443 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [9-1] <ler%dbmail> LOG: statement: SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('ler') AND lower(alias) <> Dec 14 15:42:45 thebighonker pg-prod[38071]: [9-2] lower(deliver_to) Dec 14 15:42:45 thebighonker pg-prod[38071]: [10-1] <ler%dbmail> LOG: duration: 2.517 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [11-1] <ler%dbmail> LOG: statement: SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('ler') Dec 14 15:42:45 thebighonker pg-prod[38071]: [12-1] <ler%dbmail> LOG: duration: 1.482 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [13-1] <ler%dbmail> LOG: statement: BEGIN Dec 14 15:42:45 thebighonker pg-prod[38071]: [14-1] <ler%dbmail> LOG: duration: 0.258 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [15-1] <ler%dbmail> LOG: statement: SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('[EMAIL PROTECTED]@__') Dec 14 15:42:45 thebighonker pg-prod[38071]: [16-1] <ler%dbmail> LOG: duration: 0.565 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [17-1] <ler%dbmail> LOG: statement: SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name ILIKE 'INBOX' AND owner_idnr=1 Dec 14 15:42:45 thebighonker pg-prod[38071]: [18-1] <ler%dbmail> LOG: duration: 1.737 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [19-1] <ler%dbmail> LOG: statement: INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES (0, Dec 14 15:42:45 thebighonker pg-prod[38071]: [19-2] TO_TIMESTAMP('1166132546-05-07 15:42:45', 'YYYY-MM-DD HH:MI:SS')) Dec 14 15:42:45 thebighonker pg-prod[38071]: [20-1] <ler%dbmail> ERROR: timestamp out of range Dec 14 15:42:45 thebighonker pg-prod[38071]: [20-2] <ler%dbmail> STATEMENT: INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES (0, TO_TIMESTAMP('1166132546-05-07 Dec 14 15:42:45 thebighonker pg-prod[38071]: [20-3] 15:42:45', 'YYYY-MM-DD HH:MI:SS')) Dec 14 15:42:45 thebighonker pg-prod[38071]: [21-1] <ler%dbmail> LOG: statement: ROLLBACK Dec 14 15:42:45 thebighonker pg-prod[38071]: [22-1] <ler%dbmail> LOG: duration: 0.174 ms Dec 14 15:42:45 thebighonker pg-prod[38071]: [23-1] <ler%dbmail> LOG: disconnection: session time: 0:00:00.03 user=ler database=dbmail host=localhost port=63419 $ I may be able to get the message from my MBX store if y'all feel it's necessary. Thanks! ---------------------------------------------------------------------- lrosenman - 15-Dec-06 17:26 ---------------------------------------------------------------------- I just attached a copy of the message that caused this, as it exists in my MBX file (the first line is the MBX header for it, IIRC). Issue History Date Modified Username Field Change ====================================================================== 14-Dec-06 23:56 lrosenman New Issue 14-Dec-06 23:59 lrosenman Note Added: 0001678 15-Dec-06 17:25 lrosenman File Added: bad.msg 15-Dec-06 17:26 lrosenman Note Added: 0001679 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev