On 26-02-14 22:29, Paul J Stevens wrote:
> On 26-02-14 20:58, Gray, Patrick wrote:
>> Would something like:
>> Delete from dbmail_headervalues where id not in(select headervalue_id from
>> dbmail_header);
>
> That situation should never occur if your schema is intact, since
> dbmail_header.header
ther one is the same size.
-Original Message-
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Paul J Stevens
Sent: Wednesday, February 26, 2014 4:29 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
On 26-02-14 20:58,
On 26-02-14 20:58, Gray, Patrick wrote:
> Would something like:
> Delete from dbmail_headervalues where id not in(select headervalue_id from
> dbmail_header);
That situation should never occur if your schema is intact, since
dbmail_header.headervalue_id references dbmail_headervalue.id with a
cas
Would something like:
Delete from dbmail_headervalues where id not in(select headervalue_id from
dbmail_header);
Get the job done?
___
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
On 2014-02-26 17:23, Gray, Patrick wrote:
Just counted how many headervalues are in my dbmail_headervalue table.
It looks to be somewhere arund 32 million.
Could the sheer amount of the headervalues be causing dbmail-util to sit
there and not appear to be doing anything?
Thanks for your help
On 26-02-14 17:35, Peter Milesson wrote:
>
>
> On 2014-02-26 17:23, Gray, Patrick wrote:
>> Just counted how many headervalues are in my dbmail_headervalue table.
>>
>> It looks to be somewhere arund 32 million.
>>
>> Could the sheer amount of the headervalues be causing dbmail-util to sit
>> the
On 26-02-14 17:23, Gray, Patrick wrote:
> Just counted how many headervalues are in my dbmail_headervalue table.
>
>
>
> It looks to be somewhere arund 32 million.
>
>
>
> Could the sheer amount of the headervalues be causing dbmail-util to sit
> there and not appear to be doing anything?
[mailto:dbmail-boun...@dbmail.org] On Behalf Of
Gray, Patrick
Sent: Monday, February 24, 2014 11:58 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
Also, just a heads up that dbmail-util -m segmentation faults for me.
From: dbmail-boun...@dbmail.org<mailto:dbmail-b
Also, just a heads up that dbmail-util -m segmentation faults for me.
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Gray, Patrick
Sent: Monday, February 24, 2014 11:12 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
The
We are trying to run the
process to clean the database and cut it down to about 200k messages.
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Gray, Patrick
Sent: Monday, February 24, 2014 10:52 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functiona
)
Subject: Re: [Dbmail] Dbmail-util functionality problems
Hello Everyone,
It's been a while since I last updated on this problem.
After I grabbed the dbmail 3.1.10 version that Paul said should fix the
problem, I tried compiling and running it, but the IMAP processes somehow spun
out of co
Hello Everyone,
It's been a while since I last updated on this problem.
After I grabbed the dbmail 3.1.10 version that Paul said should fix the
problem, I tried compiling and running it, but the IMAP processes somehow spun
out of control and I decided not to update.
Is there a solution to make
Awesome.
Thanks so much Paul and everyone for your help.
-Original Message-
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Paul J Stevens
Sent: Wednesday, January 22, 2014 3:06 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality
On 21-01-14 17:31, Gray, Patrick wrote:
> I mean the dbmail/mysql question. I'm still a bit confused on what to do to
> solve the dbmail-util -t problem that Paul referred to as the 'envelope
> sender' problem.
>
> Sounds like a possible patch needs to be done on my end? Or just an upgrade?
Ye
om: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Gray, Patrick
Sent: Tuesday, January 21, 2014 11:29 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
Sorry about the second question of that last email. I figured that out with a
simple search.
: [Dbmail] Dbmail-util functionality problems
Thanks for the information everyone.
Since I'm running dbmail 3.1.7, should I upgrade to the latest version? Is that
fix for the 'envelope sender' problem included in the newest release?
Also, if I deleted a lot of the emails out
MySQL reuse the space created by the erased messages or just keep
expanding?
-Original Message-
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Alan Hodgson
Sent: Tuesday, January 21, 2014 10:53 AM
To: dbmail@dbmail.org
Subject: Re: [Dbmail] Dbmail-uti
On Tuesday, January 21, 2014 03:46:55 PM Gray, Patrick wrote:
> Is there any way to see how much space will be freed before migrating to
> file-per-table mode?
>
You could find the minimum space your message store needs by backing up and
restoring into an empty database on another machine. Assum
ch space will be freed before migrating to
> file-per-table mode?
>
> -Original Message-
> From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf
> Of Paul J Stevens
> Sent: Tuesday, January 21, 2014 10:42 AM
> To: DBMail mailinglist
&
On 21-01-14 16:37, Gray, Patrick wrote:
> That makes a lot of sense. Sorry if anything got confused from my end.
>
> I'm trying to clean up our database and delete all mail older than 30 days
> old, but nothing I do seems to free up any space or make any difference to
> the size that I see on ou
: [Dbmail] Dbmail-util functionality problems
On 21-01-14 16:37, Gray, Patrick wrote:
> That makes a lot of sense. Sorry if anything got confused from my end.
>
> I'm trying to clean up our database and delete all mail older than 30 days
> old, but nothing I do seems to free up any
l-boun...@dbmail.org] On Behalf Of
Paul J Stevens
Sent: Tuesday, January 21, 2014 10:17 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
Wait a minute!
If you don't have a messageblks table, just do *NOT* run dbmail-util -M
-M is meant to migrate co
h migration when I upgraded from
>> dbmail-3.0..2 to 3.1.7? I checked that .mysql file and it doesn't seem to
>> have anything in it concerning dbmail_messageblks.
>>
>> -Original Message-
>> From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail
Of Paul J Stevens
> Sent: Saturday, January 18, 2014 10:27 AM
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Dbmail-util functionality problems
>
> On 16-01-14 20:40, Gray, Patrick wrote:
>
>> Error:[db] db_query(+361): failed query [SELECT DISTINCT(physmessage_id)
>> FROM
18, 2014 10:27 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
On 16-01-14 20:40, Gray, Patrick wrote:
> Error:[db] db_query(+361): failed query [SELECT DISTINCT(physmessage_id)
> FROM dbmail_messageblks LIMIT 1]
Again,
On 16-01-14 20:40, Gray, Patrick wrote:
> Error:[db] db_query(+361): failed query [SELECT DISTINCT(physmessage_id)
> FROM dbmail_messageblks LIMIT 1]
Again, try to replay above query - minus the spaces:
SELECT DISTINCT(physmessage_id) FROM dbmail_mess
On 16-01-14 18:24, Gray, Patrick wrote:
> Jan 16 12:11:48 LAMZ1LAPS001N1 dbmail-util[14083]: [0x82be008]
> Error:[db] db_query(+361): failed query [SELECT b.messageblk,
> b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO'))
> FROM dbmail_messageblks b JOIN dbmail_physmessage p ON
Good news: I went in manually and deleted that single message, but now I still
seem to be getting the problem with dbmail-util –t
Also, it seems that running dbmail-util –M gives me some weird output. I only
did this because it showed up when running one of the other util commands.
Output:
Migr
l.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
Gray, Patrick
Sent: Thursday, January 16, 2014 10:45 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
Below is the result of explain (select hv.id from dbmail_headervalue hv left
join dbmail_header h on hv.i
'dbmail.hv.id','1', 'Using where;
Using index; Not exists'
I guess the NULLs look a bit suspicious.
Not really sure where to go from here.
Thanks for your help.
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun..
Hi Patrick,
I would run EXPLAIN of that SELECT query to see if some indexes got
corrupted or not used in the DB. This is more likely to slow query down
rather than dbmail.
Checking DBMAIL headervalues integrity...
DATE SERVERNAME dbmail-util[12351]: [0x93dc008] Warning:[db]
log_query_time(+
31 matches
Mail list logo
