API Error: Memory limit (total) exceeded

GraphQL API
,
1

Howdy BQ folks,

We’re occasionally getting responses like these from bitquery APIs:

{
    data: { ethereum: { address: [Array] } },
    errors: [
        {
            message: "JSON::ParserError: 416: unexpected token at 'Code: 241, e.displayText() = DB::Exception: Memory limit (total) exceeded: would use 78.01 GiB (attempt to allocate chunk of 5243168 bytes), maximum: 78.01 GiB: while receiving packet from chapi44.api-cluster.local:9000: While executing Remote: While executing CreatingSetsTransform (version 20.8.11.17 (official build))\n" +
            "'",
            locations: [Array],
            path: [Array]
        }
    ]
}

Anecdotally it seems to struggle for a while on particular wallet addresses, but eventually will succeed.

The query we are making is attempting to get tokens held in a wallet, roughly:

{ethereum(network: bsc) {
    address(address: {is: "{ADDRESS}"}) { 
            address 
            balances {
                currency {
                    address
                    decimals
                    name
                    symbol
                }
                value
            }
        }
    }
}

How can we get this data without hitting these memory issues?

2

It may depend on address, for which addresses you get out of memory?