Found nn messages in the processing-messages database
mark at msapiro.net
Thu Apr 23 15:12:42 IST 2009
On Thu, Apr 23, 2009 at 09:31:45AM +0100, Julian Field wrote:
> On 23/04/2009 02:57, Mark Sapiro wrote:
> >I have looked a bit more clusely at the messages that were left in the
> >database. and it is not only that the id is all-decimal; the entropy
> >fragment must also be all-decimal or contain only a single 'E', so in
> >every case, they are being interpred as a floating point number rather
> >than a string.
> Which is a Perl bug. Perl should carry them around as both a number and
> a string, and the final destination type is a string (that's the type of
> the field in the SQL query), so someone is squashing it to just a number
> before checking the destination type. That's either a bug in Perl or in
> the implementation of DBD::SQLite.
> >E.g., the latest list from running for a while with the
> > $sth->execute("$id");
> >patch is
> >all of which are valid floating point number representations. If you
> >look at the lists in the messages I previously posted such as at
> >you will see that those too are all decimal to the left of the period
> >and all decimal or contain at most one 'E' to the right of the period
> >so they are all valid floating point number representations, and were
> >apparently treated as floating point numbers when passed to the
> >statement handler method with perl-DBD-SQLite-1.21, but apparently not
> >with the prior perl-DBD-SQLite-1.13.
> Well diagnosed, sir :-)
> So an alternative solution would be to put a "P" (for Postfix, but is
> arbitrary) on the front of the message id.
> Would you like me to do that, or just live with the slight inefficiency
> in the database deletion?
I had an idea, and I am trying
I will also take a look at 4.76.16. I'll let you know what I find.
Mark Sapiro mark at msapiro net The highway is for gamblers,
San Francisco Bay Area, California better use your sense - B. Dylan
More information about the MailScanner