no bulk update after delete alias (The SELECT would examine more than MAX_JOIN_SIZE rows)

Hello,

after deleting node aliase, we cant make a bulk update to all nodes. its coming following error status:

user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT COUNT(*) FROM node n LEFT JOIN url_alias ua ON CONCAT('node/', n.nid) = ua.src WHERE ua.src IS NULL AND n.nid > 0 in /is/htdocs/xxxxx/www/xxx/sites/all/modules/pathauto/pathauto.pathauto.inc on line 62.

drupal version: 6.24
pathauto version: 6.x-2.0 (after testing 6.x-1.6 with same result)
nodes: ~54000
php information: http://www.prnewsnet.de/test.php

I have no idea what to do. open for help.