Filter Rules disappearing

jengelh

The only way this is gonna get resolved is to track the table delete/modify event and see what client it was issued from, i.e. custom build and diagnosis.

ashceryth

@jengelh, I think there is nothing deleted in the database as all rules reappear when using the same database with an older (working) version of kopano-core, as my tests showed about half a year ago. So the rules seem to simply becoming invisible.

Christoph.Goth

The Problem seems so occure when “dumping” the rules for the dagent (?) to process the mails while arriving.

I’v made the same discovery as @ashceryth, the rules get listed as long as no mail arrives. After the first mail being proccessed after editing the ruleset they disappear in the webapp and kopani-ibrules and none (!) get processed anymore. Using python kopano-rules.py i can list and modify them, after deleting any Rule-Entry - so the rule-set gets smaller again - they reappear and get prosessed again! Ther seems to be a point of summary rulesize where the problem beginns.

My rules are mostly based on “if senders-Adress contains X, move to folder Y”.
It doesnt mather, if i use one very big rule oder a few smaller ones, after some numbers of entrys the problem occures again and again, only solution is to delete a rule entry so the rest is working again…

jengelh

I smell a cache issue. (I tested and can reproduce now; kopano-srvadm --purge-cache=all makes it visible.)

ashceryth

@jengelh Great that you are on to something now. You mean kopano-srvadm --purge-cache=all makes the rules visible again?

ashceryth

I cleared the cache with kopano-srvadm --clear-cache=all after the rules disappeared (~20 rules) and they didn’t came back. With kopano-backup --only-meta -u <username> -f Inbox the rules file was empty but with SELECT h.owner, val_binary FROM properties AS p INNER JOIN hierarchy AS h ON p.hierarchyid=h.id WHERE tag=0x3FE1 all rules were listed in the output. So everything was still in the db. I can go up to about ~15 simple rules (if sender address is X move to folder Y) until the rules disappear.

freyuh

My rules went back after running ‘kopano-cli --clear-cache’

freyuh

Okay, my rules came back after the “clear-cache”, but only one of them is working: it’s the one with the ‘subject-rule’.
All with ‘sent-to-rules’ don’t work …

jengelh

Anyway it’s fixed in 8.6.90.80 / 8.7.80.283 and newer.

bmaehr

@jengelh Thank you!

ashceryth

@jengelh

Thanks!

freyuh

@jengelh

Thanks!

freyuh

@jengelh said in Filter Rules disappearing:

Anyway it’s fixed in 8.6.90.80 / 8.7.80.283 and newer.

I have installed the update, but nothing has changed: only the ‘subject rule’ works …
Do I have to do someting more than installing the fix?

freyuh

Hello,

maybe the error is with the email-address?

I went through all email addresses and did a ‘save’ without changing the addresses.
Before the 'update I got following content:

 *  PR_RULE_CONDITION:
     *  RES_SUBRESTRICTION subobject PR_MESSAGE_RECIPIENTS
         *  RES_COMMENT
             *  Restriction:
                 *  RES_PROPERTY 0x300b0102 == binary("SMTP:ENBW@UELLERN.DE")
             *  tag 0x60000003 1
             *  tag 0x00010102 binary("SMTP:ENBW@UELLERN.DE")
             *  tag 0x0001001f "enbw@uellern.de <enbw@uellern.de>"
             *  PR_DISPLAY_TYPE 0

And after the ‘update’ I got:

 *  PR_RULE_CONDITION:
     *  RES_SUBRESTRICTION subobject PR_MESSAGE_RECIPIENTS
         *  RES_COMMENT
             *  Restriction:
                 *  RES_PROPERTY 0x300b0102 == binary("SMTP:ENBW@UELLERN.DE\0")
             *  tag 0x60000003 1
             *  tag 0x00010102 binary("SMTP:ENBW@UELLERN.DE\0")
             *  tag 0x0001001f "enbw@uellern.de <enbw@uellern.de>"
             *  PR_DISPLAY_TYPE 0

So the addresses have changed a little. There has been added a ‘\0’ after each address …

Now I’m waiting if ‘save’ did the job …

freyuh

Now the email-rules are working too …