tickets #67762
closed
pontifex - trying to scan a mirror - ERROR: array size exceeds the maximum allowed (134217727)
Added by pjessen almost 4 years ago.
Updated almost 4 years ago.
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
- Private changed from Yes to No
- 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
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.
- Status changed from New to Resolved
- % Done changed from 0 to 100
Thanks a lot for fixing it!
Also available in: Atom
PDF