laravel/framework · error · RuntimeException

The chunkById operation was aborted because the

Error message

The chunkById operation was aborted because the [{$alias}] column is not present in the query result.

What it means

RuntimeException from chunkById() when, after fetching a chunk, the configured alias/id column cannot be read from the last result row (data_get returns null). chunkById paginates by remembering the last id, so a missing id column makes safe pagination impossible and the operation aborts to avoid silent skips/duplicates.

Solutions

1. Ensure the id/alias column is in the SELECT list: ->select(['id', 'name'])->chunkById(...).
2. Pass the matching $alias argument equal to the column actually returned by the query.
3. Use chunk() (page-based) if you intentionally select without the id, accepting its caveats.
4. If using a custom primary key, pass $column = 'your_pk' and $alias = 'your_pk' consistently.

Example fix

// before
User::select('email')->chunkById(500, function ($rows) {
    // ...
});
// after
User::select(['id', 'email'])->chunkById(500, function ($rows) {
    // ...
});

// Ensure the chunk column is part of the SELECT before chunkById.
$alias = 'id';
$selected = $query->columns ?: ['*'];
if ($selected !== ['*'] && ! in_array($alias, $selected, true)) {
    $query->select(array_merge($selected, [$alias]));
}
$query->chunkById(500, $callback, $alias);

function chunkColumnIsSelected(\Illuminate\Database\Eloquent\Builder $q, string $alias): bool
{
    $cols = $q->getQuery()->columns;
    return $cols === null || in_array('*', $cols, true) || in_array($alias, $cols, true);
}

try {
    $query->chunkById($size, $callback, $alias);
} catch (\RuntimeException $e) {
    if (str_contains($e->getMessage(), 'column is not present in the query result')) {
        // add the alias column to select() and restart
    }
    throw $e;
}

When it happens

Trigger: Calling ->select('name')->chunkById(100, ...) so the id column is not selected; passing a custom $alias that does not match any selected column; using chunkById on a query with a custom alias for the primary key that the result rows do not expose; raw expressions hiding the id.

Common situations: Optimizing a query to select only specific columns and dropping the primary key; using chunkById on a UNION or subquery where the id column is aliased differently; passing $column but forgetting to also alias it in select().

Related errors

• The lazyById operation was aborted because the
• You must specify an orderBy clause when using this function.
• A subquery must be a query builder instance, a Closure, or…
• $count records were found.
• Illegal operator and value combination.

AI-assisted analysis of laravel/framework@e0f6eb3518 (2026-08-11). Data as JSON: /api/errors/22d3ba1f502e4347. Report an issue: GitHub.

Appendix: source

Thrown at src/Illuminate/Database/Concerns/BuildsQueries.php:214

            if ($countResults === 0) {
                break;
            }

            if (! is_null($remaining)) {
                $remaining = max($remaining - $countResults, 0);
            }

            // On each chunk result set, we will pass them to the callback and then let the
            // developer take care of everything within the callback, which allows us to
            // keep the memory low for spinning through large result sets for working.
            if ($callback($results, $page) === false) {
                return false;
            }

            $lastId = data_get($results->last(), $alias);

            if ($lastId === null) {
                throw new RuntimeException("The chunkById operation was aborted because the [{$alias}] column is not present in the query result.");
            }

            unset($results);

            $page++;
        } while ($countResults == $count);

        return true;
    }

    /**
     * Execute a callback over each item while chunking by ID.
     *
     * @param  callable(TValue, int): mixed  $callback
     * @param  int  $count
     * @param  string|null  $column
     * @param  string|null  $alias
     * @return bool

View on GitHub (pinned to e0f6eb3518)