Project

General

Profile

Actions

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.

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
Actions #1

Updated by pjessen almost 4 years ago

  • Private changed from Yes to No
Actions #2

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

Actions #3

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.

Actions #4

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

Also available in: Atom PDF