On 09/02/2013 10:23 AM, Pavlo Lavrenenko wrote:
> Paul, can you please review the changes in
> https://github.com/pjstevns/dbmail/pull/1 ?
>
> I am not sure how you prioritize your tasks, especially during the dbmail
> stabilization process, still I am about to backport them to 3.0.2 and
> I'd rea
On Samstag 19 September 2009 Paul J Stevens wrote:
> Jorge,
>
> You're mixing up tables here.
>
> there is *no* direct connection between messages and partlists. There
> *is* a 1-1 connection between physmessages and partlists, and that is
> maintained by a database constraint.
>
> But mimeparts ha
> Jorge Bastos wrote:
> > Allow me other question for this, with 40492 mimeparts to delete, or
> 11
> > mimeparts to delete also, it takes barely the same time.
> >
> > Normal?
>
> Is that a question?
>
Yap, it takes almost the same time to delete a lot or a few messages.
__
Jorge Bastos wrote:
> Allow me other question for this, with 40492 mimeparts to delete, or 11
> mimeparts to delete also, it takes barely the same time.
>
> Normal?
Is that a question?
--
Paul Stevens
Jorge Bastos wrote:
>>> mysql> DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN
>>> dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id)
>> WHERE
>>> dbmail_partlists.physmessage_id IS NULL;
>> I'm pretty sure we don't use that kind of query. I wasn't even aware of
>> this tr
Allow me other question for this, with 40492 mimeparts to delete, or 11
mimeparts to delete also, it takes barely the same time.
Normal?
> Only one question,
> In every run, the partlists part, always has 0 unconnected partlists's.
> Is
> it normal? Example below.
>
>
> ---
> Setting DELETE
> > mysql> DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN
> > dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id)
> WHERE
> > dbmail_partlists.physmessage_id IS NULL;
>
> I'm pretty sure we don't use that kind of query. I wasn't even aware of
> this trick.
It was somethi
Jorge,
You're mixing up tables here.
there is *no* direct connection between messages and partlists. There
*is* a 1-1 connection between physmessages and partlists, and that is
maintained by a database constraint.
But mimeparts have a 1-N connection to partlists, so no database
constraint there
Extra info on this:
mysql> UPDATE dbmail_messages SET status = 3 WHERE status = 2;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> DELETE FROM dbmail_messages WHERE status=3;
Query OK, 1 row affected (0.03 sec)
mysql> DELETE dbmail_mimeparts.* FRO
This is intentional. Mail is rotated from deleted state to purge, then
purged on the following run.
Aaron
On Jul 23, 2008, at 12:10 PM, hinote wrote:
hi there,
is there any reason for dbmail-util to purge messages with delete
status
before it sets this status to the messages that are m
On Tue, 2007-08-07 at 14:36 +0200, Marc Dirix wrote:
> JOINS are, if possible, preferable over subselects.
> However the most gain is met when batching multiple mails instead of
> itterating every mail seperate.
We have code to do this (g_list_slices, et al) but means changing the
db.c functions
JOINS are, if possible, preferable over subselects.
However the most gain is met when batching multiple mails instead of
itterating every mail seperate.
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbm
Why not use subselects to delete the rows like this?
DELETE FROM dbmail_messageblks WHERE EXISTS
( SELECT message_idnr FROM dbmail_messages WHERE status=3
AND message_idnr = ... );
That would need one statement per table only.
On Sun, 5 Aug 2007, Jonathan Fealy wrote:
I know it seems like
On Mon, 2007-08-06 at 10:16 +0200, Marc Dirix wrote:
> If it runs 32 hours, as ours did last time. It is going to be a
> performance hit during the day at some point.
Ouch! :0
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net
If it runs 32 hours, as ours did last time. It is going to be a
performance hit during the day at some point.
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
We should be chunking these queries to do like 50 - 100 messages at a
time and calculating whatever we need to calculate for everything in
that chunk of messages. Doing things one at a time was basically
quick-and-dirty to get the functionality working, but indeed does not
scale well. Our justifica
On Sun, 2007-08-05 at 21:20 +0200, Marc Dirix wrote:
> If I'm only using POP3, what are the chances a dbmail_physmessage_id
> is for more then one message?
Identical as for IMAP; it's a matter of what happens at delivery -
multiple recipients on the RCPT TO line, or alias table entries
specifyin
If I'm only using POP3, what are the chances a dbmail_physmessage_id
is for more then one message?
Marc
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
I know it seems like a lot of queries, but it basically runs like this.
A beginning SELECT * FROM dbmail_messages WHERE status='3'; // This
selects the list of message ids to be deleted.
Now each ID is iterated over like so:
SELECT * FROM dbmail_messages WHERE message_idnr='x'; // Grab th
I guess running dbmail-util should be part of the test-runs :-(
Aaron Stone wrote:
> This is bug #418. It's a simple typo, I'll get a fix committed ASAP.
>
> On Wed, 2006-09-27 at 22:16 +0200, Marc Dirix wrote:
>> Hi,
>>
>> When using dbmail-util with freshly compiled svn head I get:
>>
>> Open
This is bug #418. It's a simple typo, I'll get a fix committed ASAP.
On Wed, 2006-09-27 at 22:16 +0200, Marc Dirix wrote:
> Hi,
>
> When using dbmail-util with freshly compiled svn head I get:
>
> Opening connection to database...
> Opening connection to authentication...
> Ok. Connected.
>
> R
rtfm, a faq.
add -y or nothing will be done (dry-run mode is default).
Alexander Benaguev wrote:
> Paul, you were absolutly right about compiling problems. Just my bad
> knowlege of SVN=). thanks. Now all is working fine, but some thing
> confusing me (I thought, this bug and my be it's fixed in
Paul, I wrote you off list but never heard back from you, so I'll do it
again on-list.
I will send you a one of the culprit messages, but I'm not sure how best
to do that. I assume if I forward it to you from Thunderbird, be it
in-line or as an attachment, that's going to change the message
Matthew, could you please forward me one of the culprit messages so I
can try to reproduce this.
Matthew T. O'Connor wrote:
> 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 quer
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 que
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.
--
Paul Stevens
Paul J Stevens wrote:
(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 0x00ea5c38 in trace (level=TRACE_DEBUG
Matthew T. O'Connor wrote:
> Running the latest from SVN HEAD, dbmail-util -ay segfaults. I can go
> into the database delete the problem email and dbmail-util will get a
> bit further through the DB, will then bomb on another message.
>
> I get the following from dbmail-util -ay
>
> .dbpgsql.c,
s applies to 1.2.11 / 2.0.x / 2.1.5 / SVN Trunk
best...
Mike
----- Original Message -
From: "Aaron Stone" <[EMAIL PROTECTED]>
To: "DBMAIL Developers Mailinglist"
Sent: Friday, May 05, 2006 4:48 PM
Subject: Re: [Dbmail-dev] dbmail-util -a - adduser MD5 howto?
On
Aaron Stone wrote:
On Thu, May 4, 2006, Aaron Stone <[EMAIL PROTECTED]> said:
On Thu, 2006-05-04 at 00:18 -0700, kbaker wrote:
Java md5-digest result:
X03MO1qnZdYdgyfeuILPmQ==
dbmail-util -p md5-hash-raw result:
X03MO1qnZdYdgyfeuILPmQ==
So I would like to use the md5-hash-raw encoding p
On Thu, May 4, 2006, Aaron Stone <[EMAIL PROTECTED]> said:
> On Thu, 2006-05-04 at 00:18 -0700, kbaker wrote:
>
>> Java md5-digest result:
>> X03MO1qnZdYdgyfeuILPmQ==
>>
>> dbmail-util -p md5-hash-raw result:
>> X03MO1qnZdYdgyfeuILPmQ==
>>
>> So I would like to use the md5-hash-raw encoding
Aaron Stone wrote:
On Thu, 2006-05-04 at 00:18 -0700, kbaker wrote:
Java md5-digest result:
X03MO1qnZdYdgyfeuILPmQ==
dbmail-util -p md5-hash-raw result:
X03MO1qnZdYdgyfeuILPmQ==
So I would like to use the md5-hash-raw encoding problem is that
when I do I can not log into the IMAP account
On Thu, 2006-05-04 at 00:18 -0700, kbaker wrote:
> Java md5-digest result:
> X03MO1qnZdYdgyfeuILPmQ==
>
> dbmail-util -p md5-hash-raw result:
> X03MO1qnZdYdgyfeuILPmQ==
>
> So I would like to use the md5-hash-raw encoding problem is that
> when I do I can not log into the IMAP account. The d
Aaron Stone wrote:
On Wed, 2006-05-03 at 22:44 -0700, Aaron Stone wrote:
On Wed, 2006-05-03 at 21:30 -0700, kbaker wrote:
So I am using the "-p md5-hash-raw" setting now. I got this from the
"dbmail-users -h" command as you suggested. It matches the MD5
encryption I was using in Java s
On Wed, 2006-05-03 at 22:44 -0700, Aaron Stone wrote:
> On Wed, 2006-05-03 at 21:30 -0700, kbaker wrote:
>
> > So I am using the "-p md5-hash-raw" setting now. I got this from the
> > "dbmail-users -h" command as you suggested. It matches the MD5
> > encryption I was using in Java so that's good
On Wed, 2006-05-03 at 21:30 -0700, kbaker wrote:
> So I am using the "-p md5-hash-raw" setting now. I got this from the
> "dbmail-users -h" command as you suggested. It matches the MD5
> encryption I was using in Java so that's good.
>
> However now DBMail is not accepting the password.
>
> It
Aaron Stone wrote:
On Wed, 2006-05-03 at 16:59 -0700, Kevin Baker wrote:
How do I go about specifying MD5 encryption on a dbmail
user with the dbmail-util?
Right now I am using:
dbmail-users -a kbaker -w MYPASSWORD -g 0 -m 250M -s kbaker
at MYDOMAIN [EMAIL PROTECTED]
Per dbmail-users -h, ad
On Wed, 2006-05-03 at 16:59 -0700, Kevin Baker wrote:
> How do I go about specifying MD5 encryption on a dbmail
> user with the dbmail-util?
>
> Right now I am using:
>
>
> dbmail-users -a kbaker -w MYPASSWORD -g 0 -m 250M -s kbaker
> at MYDOMAIN [EMAIL PROTECTED]
Per dbmail-users -h, add -p md
""Matthew T. O'Connor"" said:
> Small question with dbmail-util,
[snip]
> Based on this explanation and the fact
> that we have -t which tests for integrity problems and -r which fixes
> them, I was expecting -u to only check for null messages, but not fix
> them.
As I recall, the function
39 matches
Mail list logo
