Actions
tickets #67762
closedpontifex - trying to scan a mirror - ERROR: array size exceeds the maximum allowed (134217727)
Status:
Resolved
Priority:
High
Assignee:
-
Category:
Mirrors
Target version:
-
Start date:
2020-06-05
Due date:
% Done:
100%
Estimated time:
Description
# mb scan -e intergrid
Fri Jun 5 08:19:56 2020 mirror.intergrid.com.au: starting
__DIE__: (=> =>)
CREATE TEMPORARY TABLE temp1 AS
SELECT id FROM filearr
WHERE 586 = ANY(mirrors): ERROR: array size exceeds the maximum allowed (134217727)
CONTEXT: parallel worker at /usr/bin/scanner line 289.
Completed in 3 seconds
Updated by pjessen almost 4 years ago
- Category set to Mirrors
- Priority changed from Normal to High
This has also been happening on olaf since 3 June around 0200 CET. Was some limit somehow reset ? 134217727 = 128M-1
Updated by andriinikitin almost 4 years ago
This was narrowed down to single problem row, which did cause all queries to fail, and updating value of that row seems to resolve the issue:
$ select mirrors FROM filearr WHERE id = 547319155;
ERROR: array size exceeds the maximum allowed (134217727)
$ select path from filearr where id = 547319155;
path
-------------------------------------------------------------------------------------------------
repositories/home:/csbuild:/DBA/SLE_11_SP3/i586/dba-proftpd-134d-postgresql-1.3.4d-3.1.i586.rpm
$ update filearr set mirrors = array[]::smallint[] where id = 547319155;
UPDATE 1
Hard to tell what lead to such weird corruption, but I hope all is fine now.
Updated by pjessen almost 4 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Thanks a lot for fixing it!
Actions