FW: FW: maia_mail keeps growin

I actually discovered this is a mysql related problem. If
anyone has a
clue to the 'why' please shoot.

mysql> select * from maia_mail_recipients where
mail_id=9536 and
type='C';
+---------+--------------+------+---------------+
| mail_id | recipient_id | type | token         |
+---------+--------------+------+---------------+
|    9536 |           20 | C    | expired209536 |
|    9536 |           31 | C    | expired319536 |
+---------+--------------+------+---------------+
2 rows in set (0.02 sec)

mysql> delete from maia_mail_recipients where
mail_id=9536 and type='C'
limit 1;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from maia_mail_recipients where
mail_id=9536 and type='C'
and recipient_id=20 limit 1;
Query OK, 1 row affected (0.03 sec)

Hell if I know what this is. It seems to only do damage if I
insert a
unique entry.

Rgds,

Michiel

-----Oorspronkelijk bericht-----
Van: maia-users-bouncesrenaissoft.com
[mailto:maia-users-bouncesrenaissoft.com] Namens
Michiel van den Berg
Verzonden: vrijdag 29 juni 2007 14:41
Aan: Maia
Onderwerp: [Maia-users] FW: maia_mail keeps growin


Report to the list to ;)

-----Oorspronkelijk bericht-----
Van: Erik Weber [mailto:twiztargmail.com] 
Verzonden: vrijdag 29 juni 2007 14:39
Aan: Michiel van den Berg
Onderwerp: Re: [Maia-users] maia_mail keeps growin

Michiel van den Berg wrote:
> Yes, im just doing that. Added some debug info to. It
says its
deleting all the mail for id=x but it actually doesn't do
this. For
example:
>
> 2007-06-29 12:26:51 Maia: [process-quarantine-sub]
Learned mail item
3320 as spam and reported it
> 2007-06-29 12:26:51 Maia: [process-quarantine-sub]
Deleted
spam/non-spam recipient references to mail item 3320 type C
> 2007-06-29 12:26:51 Maia: [process-quarantine-sub]
Retaining mail item
3320, since it still has recipient references.
> 2007-06-29 12:26:51 Maia: [process-quarantine-sub]
TIMING [total 1556
ms] - msg-prep: 5 (0%), send-report: 1549 (100%),
delete-mail: 3 (0%),
rundown: 0 (0%)
>
> DB:
> 3320  	20  	C  	expired203320
> 3320 		31 	C 	expired313320
>
> If I remove 1 of the lines from the DB in
maia_mail_recieved, it does
actually delete the other entry & mail entry to. But as
long as there
are 2 or more lines. It doesn't delete them.
>
> It does seem like the delete statement in
process-quarantine-sub is
good. The amavis user I use for db connectivity also has the
proper
delete right as I can manually delete a row when logged in
as that user.
And it also deletes the row if there is only 1 on the ID.
Besides that I
really have no clue whats going on at this moment. But I
will keep
debugging.
>
>   
The mail wouldn't happen to have multiple recipients?

-- 
Erik
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jun 29, 2007, at 8:16 AM, Michiel van den Berg wrote:

> I actually discovered this is a mysql related problem.
If anyone has a
> clue to the 'why' please shoot.
>
> mysql> select * from maia_mail_recipients where
mail_id=9536 and
> type='C';
> +---------+--------------+------+---------------+
> | mail_id | recipient_id | type | token         |
> +---------+--------------+------+---------------+
> |    9536 |           20 | C    | expired209536 |
> |    9536 |           31 | C    | expired319536 |
> +---------+--------------+------+---------------+
> 2 rows in set (0.02 sec)
>
> mysql> delete from maia_mail_recipients where
mail_id=9536 and  
> type='C'
> limit 1;
> Query OK, 0 rows affected (0.00 sec)
>

What happens in this sequence if you leave off the
"limit 1" above?

I wonder if you have an index problem, maybe you need to
check  tables ?




David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFGhQq3Uy30ODPkzl0RAsMiAKDIY9bopbFT3Z60ZOqFoEhRNBvk5ACg
hpov
mjN60rqlP8vL6S6/ahaFPcE=
=U4tL
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

Without the limit, it does not delete anything either. 

mysql> check table maia_mail_recipients;
+---------------------------+-------+----------+----------+
| Table                     | Op    | Msg_type | Msg_text |
+---------------------------+-------+----------+----------+
| maia.maia_mail_recipients | check | status   | OK       |
+---------------------------+-------+----------+----------+
1 row in set (5.10 sec)

mysql> select * from maia_mail_recipients where
mail_id=10226 and
type='C';
+---------+--------------+------+----------------+
| mail_id | recipient_id | type | token          |
+---------+--------------+------+----------------+
|   10226 |            9 | C    | expired910226  |
|   10226 |           11 | C    | expired1110226 |
+---------+--------------+------+----------------+
2 rows in set (0.03 sec)

mysql> delete from maia_mail_recipients where
mail_id=10226 and
type='C';
Query OK, 0 rows affected (0.00 sec)

Doesn't fix it :(

Rgds,

Michiel

-----Oorspronkelijk bericht-----
Van: David Morton [mailto:mortondadgrmm.net] 
Verzonden: vrijdag 29 juni 2007 15:36
Aan: Michiel van den Berg
CC: Maia
Onderwerp: Re: [Maia-users] FW: FW: maia_mail keeps growin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jun 29, 2007, at 8:16 AM, Michiel van den Berg wrote:

> I actually discovered this is a mysql related problem.
If anyone has a
> clue to the 'why' please shoot.
>
> mysql> select * from maia_mail_recipients where
mail_id=9536 and
> type='C';
> +---------+--------------+------+---------------+
> | mail_id | recipient_id | type | token         |
> +---------+--------------+------+---------------+
> |    9536 |           20 | C    | expired209536 |
> |    9536 |           31 | C    | expired319536 |
> +---------+--------------+------+---------------+
> 2 rows in set (0.02 sec)
>
> mysql> delete from maia_mail_recipients where
mail_id=9536 and  
> type='C'
> limit 1;
> Query OK, 0 rows affected (0.00 sec)
>

What happens in this sequence if you leave off the
"limit 1" above?

I wonder if you have an index problem, maybe you need to
check  tables ?




David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFGhQq3Uy30ODPkzl0RAsMiAKDIY9bopbFT3Z60ZOqFoEhRNBvk5ACg
hpov
mjN60rqlP8vL6S6/ahaFPcE=
=U4tL
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

Was there also a second response maybe ? as in my last mail.
This does
not fix it.

-----Oorspronkelijk bericht-----
Van: David Morton [mailto:mortondadgrmm.net] 
Verzonden: vrijdag 29 juni 2007 15:41
Aan: Michiel van den Berg
Onderwerp: Re: [Maia-users] FW: FW: maia_mail keeps growin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jun 29, 2007, at 8:16 AM, Michiel van den Berg wrote:

> I actually discovered this is a mysql related problem.
If anyone has a
> clue to the 'why' please shoot.
>
> mysql> select * from maia_mail_recipients where
mail_id=9536 and
> type='C';
> +---------+--------------+------+---------------+
> | mail_id | recipient_id | type | token         |
> +---------+--------------+------+---------------+
> |    9536 |           20 | C    | expired209536 |
> |    9536 |           31 | C    | expired319536 |
> +---------+--------------+------+---------------+
> 2 rows in set (0.02 sec)
>
> mysql> delete from maia_mail_recipients where
mail_id=9536 and  
> type='C'
> limit 1;
> Query OK, 0 rows affected (0.00 sec)

The first response I got on freenode #mysql was:

CHECK TABLE maia_mail_recipients;



David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFGhQwEUy30ODPkzl0RAvSVAJ9gByxUFIM22gdh2yxKBTzLyuOGywCf
VGKc
OhoQ5STbh2gwHbpTy2JvRdw=
=75pD
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users