====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000181 ====================================================================== Reported By: Eduardo Stern Assigned To: ====================================================================== Project: DBMail Bug ID: 181 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new ====================================================================== Date Submitted: 13-Mar-05 07:12 CET Last Modified: 13-Mar-05 07:37 CET ====================================================================== Summary: Error in SQL using SuSE Linux 9, max value for int8 is exceeded, PostgreSQL 8 + Postfix Description: When using SuSE Linux 9, DBMAIL sends a bad insert command, with the max value of message_idnr:
Mar 11 19:41:30 dbxslave dbmail/imap4d[3933]: dbpgsql.c, db_query: Error executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '1' AND '18446744073709551615' AND mailbox_idnr = '1' AND status < '2' ORDER BY message_idnr ASC] : [ERROR: value "18446744073709551615" is out of range for type bigint ] ====================================================================== ---------------------------------------------------------------------- paul - 13-Mar-05 07:33 CET ---------------------------------------------------------------------- Eduardo, Are you perhaps using Outlook as imap client?? If so, you're probably encountering bug http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000160 which was fixed already. ---------------------------------------------------------------------- paul - 13-Mar-05 07:37 CET ---------------------------------------------------------------------- Eduardo, On second thought, the out-of-range value doesn't look like http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000160 after all. Could you please include more from the logline so I can reconstruct the command sequence that led up to the error. Also, more details about the client used would be helpful if we are to reproduce this one. Bug History Date Modified Username Field Change ====================================================================== 13-Mar-05 07:12Eduardo Stern New Bug 13-Mar-05 07:33paul Bugnote Added: 0000606 13-Mar-05 07:37paul Bugnote Added: 0000607 ======================================================================
