Hoi Paul,
This message exist on our server also on small mailboxes. I probably found what
the problem is / was. It
seems there is something wrong with the InnoDB index file. I'm running my
migration again to see if it
resolves the problem.
I will let the list know what my solution was for my problem maybe it will work
for others.
Thx in advance.
Maikel
> Maikel,
>
>
> I have this same problem on a memory starved server. The sql below
> happens when you open a large mailbox with a lot of unread messages
> using thunderbird.
>
>
> "Maikel Dollé [Hebbizz BV]" wrote:
>> # Query_time: 56 Lock_time: 0 Rows_sent: 447 Rows_examined: 9444548
>> SELECT message_idnr,headername,headervalue FROM dbmail_headervalue v
>> JOIN dbmail_messages m ON v.physmessage_id=m.physmessage_id JOIN
>> dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr JOIN
>> dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr = 2700
>> AND message_idnr BETWEEN 15651805 AND 16208824 AND lower(headername) IN
>> ('date','to','cc','from','subject','x-priority','importance','priority','content-type');
>
>
> --
> ________________________________________________________________
> Paul Stevens paul at nfg.nl
> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
> The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> DBmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
