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
OpenPGP_signature
Description: OpenPGP digital signature
