Mailing List Archive: awl postgresql

awl postgresql

Mar 20, 2023, 6:37 AM

Post #1 of 6 (236 views)

i lost the fixes Sidney did, imho never committed to trunk :/

Mar 20 00:02:23 localhost postgres[20411]: [7-1] 2023-03-19 23:02:24.002
UTC [20411] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 00:02:23 localhost postgres[20411]: [7-2] 2023-03-19 23:02:24.002
UTC [20411] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 00:02:37 localhost postgres[20420]: [7-1] 2023-03-19 23:02:37.783
UTC [20420] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 00:02:37 localhost postgres[20420]: [7-2] 2023-03-19 23:02:37.783
UTC [20420] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 00:19:27 localhost postgres[20979]: [7-1] 2023-03-19 23:19:27.201
UTC [20979] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 00:19:27 localhost postgres[20979]: [7-2] 2023-03-19 23:19:27.201
UTC [20979] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 01:00:05 localhost postgres[22426]: [7-1] 2023-03-20 00:00:05.136
UTC [22426] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 01:00:05 localhost postgres[22426]: [7-2] 2023-03-20 00:00:05.136
UTC [22426] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 01:11:39 localhost postgres[22809]: [7-1] 2023-03-20 00:11:39.856
UTC [22809] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 01:11:39 localhost postgres[22809]: [7-2] 2023-03-20 00:11:39.856
UTC [22809] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 01:21:19 localhost postgres[23122]: [7-1] 2023-03-20 00:21:19.249
UTC [23122] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 01:21:19 localhost postgres[23122]: [7-2] 2023-03-20 00:21:19.249
UTC [23122] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 01:21:19 localhost postgres[23123]: [7-1] 2023-03-20 00:21:19.439
UTC [23123] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 01:21:19 localhost postgres[23123]: [7-2] 2023-03-20 00:21:19.439
UTC [23123] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 01:54:30 localhost postgres[24194]: [7-1] 2023-03-20 00:54:30.195
UTC [24194] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 01:54:30 localhost postgres[24194]: [7-2] 2023-03-20 00:54:30.195
UTC [24194] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 02:00:02 localhost postgres[24407]: [7-1] 2023-03-20 01:00:02.933
UTC [24407] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 02:00:02 localhost postgres[24407]: [7-2] 2023-03-20 01:00:02.933
UTC [24407] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 02:27:11 localhost postgres[25284]: [7-1] 2023-03-20 01:27:11.129
UTC [25284] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 02:27:11 localhost postgres[25284]: [7-2] 2023-03-20 01:27:11.129
UTC [25284] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 03:00:03 localhost postgres[26343]: [7-1] 2023-03-20 02:00:03.296
UTC [26343] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 03:00:03 localhost postgres[26343]: [7-2] 2023-03-20 02:00:03.296
UTC [26343] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 03:26:20 localhost postgres[27212]: [7-1] 2023-03-20 02:26:20.416
UTC [27212] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 03:26:20 localhost postgres[27212]: [7-2] 2023-03-20 02:26:20.416
UTC [27212] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 04:00:03 localhost postgres[28767]: [7-1] 2023-03-20 03:00:03.091
UTC [28767] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 04:00:03 localhost postgres[28767]: [7-2] 2023-03-20 03:00:03.091
UTC [28767] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 04:02:36 localhost postgres[28902]: [7-1] 2023-03-20 03:02:36.202
UTC [28902] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 04:02:36 localhost postgres[28902]: [7-2] 2023-03-20 03:02:36.202
UTC [28902] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8
Mar 20 04:12:17 localhost postgres[29257]: [7-1] 2023-03-20 03:12:17.101
UTC [29257] ERROR: column reference "totscore" is ambiguous at
character 175
Mar 20 04:12:17 localhost postgres[29257]: [7-2] 2023-03-20 03:12:17.101
UTC [29257] STATEMENT: INSERT INTO awl
(username,email,ip,msgcount,totscore,signedby) VALUES
($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO
UPDATE set msgcount = $7, totscore = totscore + $8

i have currently just disabled awl

Re: awl postgresql [ In reply to ]

giovanni at paclan

Mar 20, 2023, 6:49 AM

Post #2 of 6 (236 views)

Permalink

On 3/20/23 14:37, Benny Pedersen wrote:
>
> i lost the fixes Sidney did, imho never committed to trunk :/
>
Sidney committed the fix on r1906450, looking at the code it seems you are running a previous version.

Giovanni

> Mar 20 00:02:23 localhost postgres[20411]: [7-1] 2023-03-19 23:02:24.002 UTC [20411] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 00:02:23 localhost postgres[20411]: [7-2] 2023-03-19 23:02:24.002 UTC [20411] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 00:02:37 localhost postgres[20420]: [7-1] 2023-03-19 23:02:37.783 UTC [20420] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 00:02:37 localhost postgres[20420]: [7-2] 2023-03-19 23:02:37.783 UTC [20420] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 00:19:27 localhost postgres[20979]: [7-1] 2023-03-19 23:19:27.201 UTC [20979] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 00:19:27 localhost postgres[20979]: [7-2] 2023-03-19 23:19:27.201 UTC [20979] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 01:00:05 localhost postgres[22426]: [7-1] 2023-03-20 00:00:05.136 UTC [22426] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 01:00:05 localhost postgres[22426]: [7-2] 2023-03-20 00:00:05.136 UTC [22426] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 01:11:39 localhost postgres[22809]: [7-1] 2023-03-20 00:11:39.856 UTC [22809] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 01:11:39 localhost postgres[22809]: [7-2] 2023-03-20 00:11:39.856 UTC [22809] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 01:21:19 localhost postgres[23122]: [7-1] 2023-03-20 00:21:19.249 UTC [23122] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 01:21:19 localhost postgres[23122]: [7-2] 2023-03-20 00:21:19.249 UTC [23122] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 01:21:19 localhost postgres[23123]: [7-1] 2023-03-20 00:21:19.439 UTC [23123] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 01:21:19 localhost postgres[23123]: [7-2] 2023-03-20 00:21:19.439 UTC [23123] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 01:54:30 localhost postgres[24194]: [7-1] 2023-03-20 00:54:30.195 UTC [24194] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 01:54:30 localhost postgres[24194]: [7-2] 2023-03-20 00:54:30.195 UTC [24194] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 02:00:02 localhost postgres[24407]: [7-1] 2023-03-20 01:00:02.933 UTC [24407] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 02:00:02 localhost postgres[24407]: [7-2] 2023-03-20 01:00:02.933 UTC [24407] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 02:27:11 localhost postgres[25284]: [7-1] 2023-03-20 01:27:11.129 UTC [25284] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 02:27:11 localhost postgres[25284]: [7-2] 2023-03-20 01:27:11.129 UTC [25284] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 03:00:03 localhost postgres[26343]: [7-1] 2023-03-20 02:00:03.296 UTC [26343] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 03:00:03 localhost postgres[26343]: [7-2] 2023-03-20 02:00:03.296 UTC [26343] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 03:26:20 localhost postgres[27212]: [7-1] 2023-03-20 02:26:20.416 UTC [27212] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 03:26:20 localhost postgres[27212]: [7-2] 2023-03-20 02:26:20.416 UTC [27212] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 04:00:03 localhost postgres[28767]: [7-1] 2023-03-20 03:00:03.091 UTC [28767] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 04:00:03 localhost postgres[28767]: [7-2] 2023-03-20 03:00:03.091 UTC [28767] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 04:02:36 localhost postgres[28902]: [7-1] 2023-03-20 03:02:36.202 UTC [28902] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 04:02:36 localhost postgres[28902]: [7-2] 2023-03-20 03:02:36.202 UTC [28902] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
> Mar 20 04:12:17 localhost postgres[29257]: [7-1] 2023-03-20 03:12:17.101 UTC [29257] ERROR: column reference "totscore" is ambiguous at character 175
> Mar 20 04:12:17 localhost postgres[29257]: [7-2] 2023-03-20 03:12:17.101 UTC [29257] STATEMENT: INSERT INTO awl (username,email,ip,msgcount,totscore,signedby) VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (username, email, signedby, ip) DO UPDATE set msgcount = $7, totscore = totscore + $8
>
>
> i have currently just disabled awl

Re: awl postgresql [ In reply to ]

me at junc

Mar 20, 2023, 9:56 AM

Post #3 of 6 (236 views)

Permalink

giovanni@paclan.it skrev den 2023-03-20 14:49:
> On 3/20/23 14:37, Benny Pedersen wrote:
>>
>> i lost the fixes Sidney did, imho never committed to trunk :/
>>
> Sidney committed the fix on r1906450, looking at the code it seems you
> are running a previous version.

AWL in trunk is dated 27 april 2022 ?

"works for me you commited, works in trunk now" :)

Re: awl postgresql [ In reply to ]

giovanni at paclan

Mar 20, 2023, 11:12 AM

Post #4 of 6 (235 views)

Permalink

On 3/20/23 17:56, Benny Pedersen wrote:
> giovanni@paclan.it skrev den 2023-03-20 14:49:
>> On 3/20/23 14:37, Benny Pedersen wrote:
>>>
>>> i lost the fixes Sidney did, imho never committed to trunk :/
>>>
>> Sidney committed the fix on r1906450, looking at the code it seems you
>> are running a previous version.
>
> AWL in trunk is dated 27 april 2022 ?
>
fix is in Mail::SpamAssassin::SQLBasedAddrList.pm and is dated 2023-01-07

Giovanni

> "works for me you commited, works in trunk now" :)
>

Re: awl postgresql [ In reply to ]

me at junc

Mar 20, 2023, 11:55 AM

Post #5 of 6 (235 views)

Permalink

giovanni@paclan.it skrev den 2023-03-20 19:12:
> On 3/20/23 17:56, Benny Pedersen wrote:
>> giovanni@paclan.it skrev den 2023-03-20 14:49:
>>> On 3/20/23 14:37, Benny Pedersen wrote:
>>>>
>>>> i lost the fixes Sidney did, imho never committed to trunk :/
>>>>
>>> Sidney committed the fix on r1906450, looking at the code it seems
>>> you
>>> are running a previous version.
>>
>> AWL in trunk is dated 27 april 2022 ?
>>
> fix is in Mail::SpamAssassin::SQLBasedAddrList.pm and is dated
> 2023-01-07

ah yes, now i remember, its just to hard to load this one in a pre file
:)

or no ?

also is

X-Spam-ExtractText-Chars: _EXTRACTTEXTCHARS_
X-Spam-ExtractText-Extensions: _EXTRACTTEXTEXTENSIONS_
X-Spam-ExtractText-Flags: _EXTRACTTEXTFLAGS_
X-Spam-ExtractText-Tools: _EXTRACTTEXTTOOLS_
X-Spam-ExtractText-Types: _EXTRACTTEXTTYPES_
X-Spam-ExtractText-Words: _EXTRACTTEXTWORDS_

not resolved yet ?, empty results in generic

>
> Giovanni
>
>> "works for me you commited, works in trunk now" :)
>>

Re: awl postgresql [ In reply to ]

giovanni at paclan

Mar 21, 2023, 1:21 AM

Post #6 of 6 (234 views)

Permalink

On 3/20/23 19:55, Benny Pedersen wrote:
> giovanni@paclan.it skrev den 2023-03-20 19:12:
>> On 3/20/23 17:56, Benny Pedersen wrote:
>>> giovanni@paclan.it skrev den 2023-03-20 14:49:
>>>> On 3/20/23 14:37, Benny Pedersen wrote:
>>>>>
>>>>> i lost the fixes Sidney did, imho never committed to trunk :/
>>>>>
>>>> Sidney committed the fix on r1906450, looking at the code it seems you
>>>> are running a previous version.
>>>
>>> AWL in trunk is dated 27 april 2022 ?
>>>
>> fix is in Mail::SpamAssassin::SQLBasedAddrList.pm and is dated 2023-01-07
>
> ah yes, now i remember, its just to hard to load this one in a pre file :)
>
> or no ?
>
SQLBasedAddrList cannot be loaded from .pre files and I think it would be better to update to latest trunk code whenever possible instead of updating only some files.

> also is
>
> X-Spam-ExtractText-Chars: _EXTRACTTEXTCHARS_
> X-Spam-ExtractText-Extensions: _EXTRACTTEXTEXTENSIONS_
> X-Spam-ExtractText-Flags: _EXTRACTTEXTFLAGS_
> X-Spam-ExtractText-Tools: _EXTRACTTEXTTOOLS_
> X-Spam-ExtractText-Types: _EXTRACTTEXTTYPES_
> X-Spam-ExtractText-Words: _EXTRACTTEXTWORDS_
>
> not resolved yet ?, empty results in generic
>
fixed in r1907776 on 2023-02-20

Giovanni

Mailing List Archive

Attached Files:

Attached Files:

Attached Files: