> Thanks for the help!
>
No problem. That's why the list is here. I help you, you help others. That easy
:)
> dspam_merge %myemailaddress% -o %globalgroupaddress%
>
Ahhhgrr! I hate that tool. Okay. Hate is a strong word. The tool is fine but
can be optimized.
> The first few lines are a million miles long, but start with:
> [07/02/2009 12:12:00] 9157: MySQL server has gone away: select uid,
> token, spam_hits, innocent_hits from dspam_token_data where uid = 2 and
> token in('16215517488802866677',
>
> Then I get lots of these:
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = -2231226584906684939
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = -6283520083841259381
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = -4906385273207823380
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = 8002922027662966784
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = -3511434928684000909
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = 4393824718668730963
> [07/02/2009 12:12:02] 9157: MySQL server has gone away: update
> dspam_token_data set spam_hits = 0, innocent_hits = 0 where uid = 2 and
> token = -2067679234647758444
>
MySQL is a good RDBMS but in some areas it is ultra terrible. I can't now say
what the issue is since I am out of office and would need to look at the code
to see why the error is happening. But I think the issue is the query
size/length. In about 2 hours I will be again in the office and then I will
look at the issue. Okay?
btw: Thanks for reminding me to fix that tool. I would have forgotten that.
btw2: As a workaround I could quickly craft a SQL query doing what dspam_merge
does. Would you accept that as a workaround until we get dspam_merge fixed?
> pace
>
Steve
--
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
------------------------------------------------------------------------------
_______________________________________________
Dspam-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-user
