[opendmarc-users] DELETE failed error. What is causing this?

[Robert@QuantumRadio]

Ok, this fixed it.


I opted to change this line in opendmarc-expire to

$dbi_s = $dbi_h->prepare("DELETE FROM requests WHERE lastsent <= DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL ? DAY) AND NOT lastsent = '1970-01-01 00:00:00'”);
  
It was 

$dbi_s = $dbi_h->prepare("DELETE FROM requests WHERE lastsent <= DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL ? DAY) AND NOT lastsent = '0000-00-00 00:00:00'”);


This 0000-00-00 00:00:00 in the code meant that MySQL threw an error before it even got to the database because MySQL is set to No_ZERO_DATE and simply won’t allow it. When the perl script ran, MySql refused it. 
 So I changed that line in the script, and also changed the db structure and made sure that the requests -> lastsent field in the database was defaulting to 1970-01-01 00:00:00 - a non-zero date. and now all is well. As mentioned previously.



The endo of the run from last night’s cron job. All is now well.


…
…
… 
opendmarc-import: updating at line 817
opendmarc-import: terminating at Sat Jun 25 00:00:02 2016
opendmarc-reports: started at Sat Jun 25 00:00:04 2016
opendmarc-reports: selected 196 domain(s)
opendmarc-reports: sent report for andreasschulze.de <http://andreasschulze.de/> to rua at dmarc.andreasschulze.de <mailto:rua at dmarc.andreasschulze.de> (2.0.0 Ok: queued as 1FD44376F737)
opendmarc-reports: sent report for andreasschulze.de <http://andreasschulze.de/> to d at rua.agari.com <mailto:d at rua.agari.com> (2.0.0 Ok: queued as 719B9376F73A)
opendmarc-reports: sent report for quantum-radio.net <http://quantum-radio.net/> to eclq31iz at ag.dmarcian.com <mailto:eclq31iz at ag.dmarcian.com> (2.0.0 Ok: queued as 8E11C376F77E)
opendmarc-reports: sent report for sapienti-sat.org <http://sapienti-sat.org/> to rua at dmarc.sapienti-sat.org <mailto:rua at dmarc.sapienti-sat.org> (2.0.0 Ok: queued as 4A148376F7B6)
opendmarc-reports: sent report for sapienti-sat.org <http://sapienti-sat.org/> to pbozavy3 at ag.dmarcian.com <mailto:pbozavy3 at ag.dmarcian.com> (2.0.0 Ok: queued as 6CFD4376F7B7)
opendmarc-reports: sent report for coinbase.com <http://coinbase.com/> to jpohmdhp at ag.dmarcian.com <mailto:jpohmdhp at ag.dmarcian.com> (2.0.0 Ok: queued as B5C57376F7C5)
opendmarc-reports: sent report for avc.su to hisnb7cu at ag.dmarcian-eu.com <mailto:hisnb7cu at ag.dmarcian-eu.com> (2.0.0 Ok: queued as 51AAD376F7E4)
opendmarc-reports: terminating at Sat Jun 25 00:00:09 2016
opendmarc-expire: started at Sat Jun 25 00:00:09 2016
opendmarc-expire: connected to database
opendmarc-expire: expiring messages older than 180 day(s)
opendmarc-expire: expiring signatures on expired messages (id < 56)
opendmarc-expire: expiring request data older than 180 days
opendmarc-expire: terminating at Sat Jun 25 00:00:09 2016
opendmarc-expire: 29 row(s) deleted
opendmarc-expire: no rows deleted
opendmarc-expire: 1 row(s) deleted
/tmp/opendmarc.11864
/tmp/opendmarc.18088
/tmp/opendmarc.39908
/tmp/opendmarc.62399
/tmp/opendmarc.89241


> On 24 Jun 2016, at 21:55, Benny Pedersen <me at junc.eu> wrote:
> 
> On 2016-06-24 21:50, A. Schulze wrote:
> 
>> Anyway: I noticed some messages ago the default of opendmarc-epire set
>> to 180 days.
>> I only store two days or so. That keep the database significant smaller.
> 
> i have made it to 8 days, and just report weekly, so opendmarc-report takes data from 7 days backlog
> 
> works well here
> _______________________________________________
> opendmarc-users mailing list
> opendmarc-users at trusteddomain.org
> http://www.trusteddomain.org/mailman/listinfo/opendmarc-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.trusteddomain.org/pipermail/opendmarc-users/attachments/20160625/da72b4f0/attachment.htm>