I have a hard time seeing anything wrong with this query.. But there
must be something wrong.
Sergey, can you give some more log output. More specifically, can you
send the lines where the query is executed.
Ilja
Sergey Spiridonov wrote:
Ilja Booij wrote:
can you rewind the log a bit more, to see what the exact query was?
I fetch some lines before and afer:
May 13 10:50:30 james dbmail/imap4d[14068]: COMMAND: [4 noop]
May 13 10:50:30 james dbmail/imap4d[14068]: COMMAND: [5 UID fetch
29175:* (FLAGS)]
May 13 10:50:31 james dbmail/imap4d[14068]: COMMAND: [6 noop]
May 13 10:50:31 james dbmail/imap4d[14068]: COMMAND: [7 UID fetch
29175:* (FLAGS)]
May 13 10:50:32 james dbmail/smtp[14220]: sort.c, sort_and_deliver:
message id=30141, size=860 is inserted
May 13 10:50:35 james dbmail/imap4d[14068]: COMMAND: [8 UID fetch 29174
(UID RFC822.SIZE BODY[])]
May 13 10:50:48 james dbmail/smtp[14222]: dbpgsql.c, db_query: Error
executing query [INSERT INTO messageblks(messageblk,blocksize,
physmessage_id) VALUES ('Return-Path: <[EMAIL PROTECTED]>
May 13 10:50:48 james Delivered-To: [EMAIL PROTECTED]
May 13 10:50:48 james Received: from legba.gamic.com [192.168.12.1]
May 13 10:50:48 james by localhost with POP3 (fetchmail-6.2.5)
May 13 10:50:48 james for [EMAIL PROTECTED] (single-drop); Thu, 13 May
2004 10:50:48 +0200 (CEST)
May 13 10:50:48 james Received: (qmail 19060 invoked from network); 12
May 2004 12:56:14 -0000
May 13 10:50:48 james Received: from unknown (HELO localhost) (127.0.0.1)
May 13 10:50:48 james by 127.0.0.1 with SMTP; 12 May 2004 12:56:14 -0000
May 13 10:50:48 james Message-ID: <[EMAIL PROTECTED]>
May 13 10:50:48 james Disposition-Notification-To: Martin Malkomes
<[EMAIL PROTECTED]>
May 13 10:50:48 james Date: Wed, 12 May 2004 14:55:59 +0200
May 13 10:50:48 james From: Martin Malkomes <[EMAIL PROTECTED]>
May 13 10:50:48 james Organization: GAMIC
May 13 10:50:48 james User-Agent: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.6) Gecko/20040113
May 13 10:50:48 james X-Accept-Language: en-us, en, fr, de
May 13 10:50:48 james MIME-Version: 1.0
May 13 10:50:48 james To: [EMAIL PROTECTED]
May 13 10:50:48 james CC: [EMAIL PROTECTED]
May 13 10:50:48 james Subject: Re: RES: Notebook PC''s
May 13 10:50:48 james References: <[EMAIL PROTECTED]>
May 13 10:50:48 james In-Reply-To: <[EMAIL PROTECTED]>
May 13 10:50:48 james Content-Type: multipart/mixed;
May 13 10:50:48 james boundary="------------000601050905040008050003"
May 13 10:50:48 james ] : [ERROR: parser: unterminated quoted string at
or near "'Return-Path: <[EMAIL PROTECTED]>
May 13 10:50:48 james Delivered-To: [EMAIL PROTECTED]
May 13 10:50:48 james Received: from legba.gamic.com [192.168.12.1]
May 13 10:50:48 james by localhost with POP3 (fetchmail-6.2.5)
May 13 10:50:48 james for [EMAIL PROTECTED] (single-drop); Thu, 13 May
2004 10:50:48 +0200 (CEST)
May 13 10:50:48 james Received: (qmail 19060 invoked from network); 12
May 2004 12:56:14 -0000
May 13 10:50:48 james Received: from unknown (HELO localhost) (127.0.0.1)
May 13 10:50:48 james by 127.0.0.1 with SMTP; 12 May 2004 12:56:14 -0000
May 13 10:50:48 james Received: from unknown (HELO localhost) (127.0.0.1)
May 13 10:50:48 james by 127.0.0.1 with SMTP; 12 May 2004 12:56:14 -0000
May 13 10:50:48 james Message-ID: <[EMAIL PROTECTED]>
May 13 10:50:48 james Disposition-Notification-To: Martin Malkomes
<[EMAIL PROTECTED]>
May 13 10:50:48 james Date: Wed, 12 May 2004 14:55:59 +0200
May 13 10:50:48 james From: Martin Malkomes <[EMAIL PROTECTED]>
May 13 10:50:48 james Organization: GAMIC
May 13 10:50:48 james User-Agent: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.6) Gecko/20040113
May 13 10:50:48 james X-Accept-Language: en-us, en, fr, de
May 13 10:50:48 james MIME-Version: 1.0
May 13 10:50:48 james To: [EMAIL PROTECTED]
May 13 10:50:48 james CC: [EMAIL PROTECTED] Subject: Re: RES:
Notebook PC''s References: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]> Content-Type:
multipart/mixed; boundary="------------000601050905040008050003" " at
character 71 ]
May 13 10:50:48 james dbmail/smtp[14222]:
db.c,db_insert_message_block_physmessage: dbquery failed
May 13 10:50:48 james dbmail/smtp[14222]: db.c,db_insert_message_block:
error inserting messageblks for physmessage [21964]
May 13 10:50:48 james dbmail/smtp[14222]: store_message_temp(): error
inserting msgblock [header]
May 13 10:50:48 james dbmail/smtp[14222]: pipe.c, insert_messages:
failed to store temporary message.
May 13 10:50:48 james dbmail/smtp[14222]: main(): insert_messages failed
May 13 10:50:54 james dbmail/imap4d[14064]: COMMAND: [4 noop]
May 13 10:50:54 james dbmail/imap4d[14064]: COMMAND: [5 UID fetch
26872:* (FLAGS)]
May 13 10:51:10 james dbmail/smtp[14225]: dbpgsql.c, db_query: Error
executing query [INSERT INTO messageblks(messageblk,blocksize,
physmessage_id) VALUES ('Return-Path: <[EMAIL PROTECTED]>
May 13 10:51:10 james Delivered-To: [EMAIL PROTECTED]
May 13 10:51:10 james Received: from legba.gamic.com [192.168.12.1]
May 13 10:51:10 james by localhost with POP3 (fetchmail-6.2.5)
May 13 10:51:10 james for [EMAIL PROTECTED] (single-drop); Thu, 13 May
2004 10:51:10 +0200 (CEST)
May 13 10:51:10 james Received: (qmail 19060 invoked from network); 12
May 2004 12:56:14 -0000
May 13 10:51:10 james Received: from unknown (HELO localhost)
(127.0.0.1)
May 13 10:51:10 james by 127.0.0.1 with SMTP; 12 May 2004 12:56:14 -0000
May 13 10:51:10 james Message-ID: <[EMAIL PROTECTED]>
May 13 10:51:10 james Disposition-Notification-To: Martin Malkomes
<[EMAIL PROTECTED]>
May 13 10:51:10 james Date: Wed, 12 May 2004 14:55:59 +0200
May 13 10:51:10 james From: Martin Malkomes <[EMAIL PROTECTED]>
May 13 10:51:10 james Organization: GAMIC
May 13 10:51:10 james User-Agent: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.6) Gecko/20040113
May 13 10:51:10 james X-Accept-Language: en-us, en, fr, de
May 13 10:51:10 james MIME-Version: 1.0
May 13 10:51:10 james To: [EMAIL PROTECTED]
May 13 10:51:10 james CC: [EMAIL PROTECTED]
May 13 10:51:10 james Subject: Re: RES: Notebook PC''s
May 13 10:51:10 james References: <[EMAIL PROTECTED]>
May 13 10:51:10 james In-Reply-To: <[EMAIL PROTECTED]>
May 13 10:51:10 james Content-Type: multipart/mixed;
May 13 10:51:10 james boundary="------------000601050905040008050003"
May 13 10:51:10 james ] : [ERROR: parser: unterminated quoted string at
or near "'Return-Path: <[EMAIL PROTECTED]>
May 13 10:51:10 james Delivered-To: [EMAIL PROTECTED]
May 13 10:51:10 james Received: from legba.gamic.com [192.168.12.1]
May 13 10:51:10 james by localhost with POP3 (fetchmail-6.2.5)
May 13 10:51:10 james for [EMAIL PROTECTED] (single-drop); Thu, 13 May
2004 10:51:10 +0200 (CEST)
May 13 10:51:10 james Received: (qmail 19060 invoked from network); 12
May 2004 12:56:14 -0000
May 13 10:51:10 james Received: from unknown (HELO localhost)
(127.0.0.1)
May 13 10:51:10 james by 127.0.0.1 with SMTP; 12 May 2004 12:56:14 -0000
May 13 10:51:10 james Message-ID: <[EMAIL PROTECTED]>
May 13 10:51:10 james Disposition-Notification-To: Martin Malkomes
<[EMAIL PROTECTED]>
May 13 10:51:10 james Date: Wed, 12 May 2004 14:55:59 +0200
May 13 10:51:10 james From: Martin Malkomes <[EMAIL PROTECTED]>
May 13 10:51:10 james Organization: GAMIC
May 13 10:51:10 james User-Agent: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.6) Gecko/20040113
May 13 10:51:10 james X-Accept-Language: en-us, en, fr, de
May 13 10:51:10 james MIME-Version: 1.0
May 13 10:51:10 james To: [EMAIL PROTECTED]
May 13 10:51:10 james CC: [EMAIL PROTECTED] Subject: Re: RES:
Notebook PC''s References: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]> Content-Type:
multipart/mixed; boundary="------------000601050905040008050003" " at
character 71 ]
May 13 10:51:10 james dbmail/smtp[14225]:
db.c,db_insert_message_block_physmessage: dbquery failed
May 13 10:51:10 james dbmail/smtp[14225]: db.c,db_insert_message_block:
error inserting messageblks for physmessage [21965]
May 13 10:51:10 james dbmail/smtp[14225]: store_message_temp(): error
inserting msgblock [header]
May 13 10:51:10 james dbmail/smtp[14225]: pipe.c, insert_messages:
failed to store temporary message.
May 13 10:51:10 james dbmail/smtp[14225]: main(): insert_messages failed
May 13 10:51:54 james dbmail/imap4d[14068]: COMMAND: [9 noop]
May 13 10:51:54 james dbmail/imap4d[14068]: COMMAND: [10 UID fetch
29175:* (FLAGS)]
May 13 10:51:54 james dbmail/imap4d[14068]: COMMAND: [11 UID fetch 30141
(UID RFC822.SIZE FLAGS BODY.PEEK[HEADER.FIELDS (From To Cc Subject Date
Message-ID Priority X-Priority References Newsgroups In-Reply-To)])]
--
Best regards, Sergey Spiridonov
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
