Page MenuHomeMiraheze

PHP Fatal error: Out of memory in /../w/includes/libs/rdbms/database/DatabaseMysqli.php on line 46 for $wgRottenLinksExcludeNamespaces
Closed, ResolvedPublic

Description

Setup

  • MediaWiki 1.31.1 (4b70558) 22:37, 19. Nov. 2018
  • PHP 7.0.30-0+deb9u1 (apache2handler)
  • MariaDB 10.1.37-MariaDB-0+deb9u1
  • RottenLinks 1.0.4 (a162d8a) 17:17, 2. Nov. 2018

LocalSettings.php

$wgMemoryLimit = '256M';

## RottenLinks
wfLoadExtension( 'RottenLinks' );
$wgRottenLinksExcludeNamespaces = [ 1, 3, 5, 7, 9, 11, 13, 15 ];

Issue

When trying to update the status of links with:

php extensions/RottenLinks/maintenance/updateExternalLinks.php

I get the following fatal:

Dropping all existing recorded entries

mmap() failed: [12] Cannot allocate memory

mmap() failed: [12] Cannot allocate memory
PHP Fatal error:  Out of memory (allocated 7222591488) (tried to allocate 562036744 bytes) in /../w/includes/libs/rdbms/database/DatabaseMysqli.php on line 46

When commenting out $wgRottenLinksExcludeNamespaces = [ 1, 3, 5, 7, 9, 11, 13, 15 ]; everything works as expected.

Event Timeline

Kghbln updated the task description. (Show Details)
Kghbln updated the task description. (Show Details)
Kghbln updated the task description. (Show Details)
Kghbln added a subscriber: John.
John claimed this task.

Removed feature, super inefficient SQL wise within MediaWiki.

However this was an appealing feature. I liked it. No worries, one day there will be a solution. Admittedly the respective wiki I use for testing holds about 23,000 external links in total which is intense.