Serialization of closure is not allowed

[webcodecs]

I want to export xlsx files with a lot of rows and cells. At some point the memory is no longer sufficient to cache the cells. I have changed the cache driver to batch. When the memory limit is reached now, the remaining cells should be stored in my Redis cache. But I immediately get a serialization error Serialization of 'Closure' is not allowed.

I can't say exactly how to reproduce it. Maybe its a problem with my usage from view?
I have a database table with orders and order details. I use the collection from orders in the view I use for export.
According to the logs it is always another cell where the error occurs.

Maybe the view-File is helping?

@php($headerStyle = "height:50px;background-color:#76a9fa;font-weight:bold;text-align:center;vertical-align: middle;")

@php($headerStyleGreen = "height:50px;background-color:green;font-weight:bold;text-align:center;vertical-align: middle;")

<table>
    <thead>
    <tr>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-ID</h1></th>
        @if($storeMappings->count() > 0)
            <th valign="middle" style="{{ $headerStyle }}"><h1>Lief Markt-ID</h1></th>
        @endif
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-Name</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-Name2</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-Straße</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-HsNr</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-PLZ</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Markt-Ort</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Hersteller-ID</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Hersteller-Name</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Art.Nr.</h1></th>
        @if($articleMappings->count() > 0)
            <th valign="middle" style="{{ $headerStyle }}"><h1>Lief-Art.Nr.</h1></th>
        @endif
        <th valign="middle" style="{{ $headerStyle }}"><h1>Artikel-Bezeichnung</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Geb.</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Inh.</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Verpackung</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>Menge</h1></th>
        @if(!$isSupplier)
            <th valign="middle" style="{{ $headerStyle }}">Rabatt- <br>summe</th>
        @endif
        <th valign="middle" style="{{ $headerStyle }}"><h1>Zentrallager- <br>bestellung</h1></th>
        @if($isFairy)
            <th valign="middle" style="{{ $headerStyle }}"><h1>KW</h1></th>
        @else
            <th valign="middle" style="{{ $headerStyle }}"><h1>Lieferzeitraum</h1></th>
        @endif
        <th valign="middle" style="{{ $headerStyle }}"><h1>Abholung</h1></th>
        <th valign="middle" style="{{ $headerStyleGreen }}"><h1>Gratis-Artikel <br>Nr.</h1></th>
        <th valign="middle" style="{{ $headerStyleGreen }}"><h1>Gratis-Artikel <br>Bezeichnung</h1></th>
        <th valign="middle" style="{{ $headerStyleGreen }}"><h1>Gratis-Artikel <br>Geb.</h1></th>
        <th valign="middle" style="{{ $headerStyleGreen }}"><h1>Gratis-Artikel <br>Inh.</h1></th>
        <th valign="middle" style="{{ $headerStyleGreen }}"><h1>Gratis-Artikel <br>Verpackung</h1></th>
        <th valign="middle" style="{{ $headerStyleGreen }}"><h1>Gratis-Artikel <br>Menge</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>LiefID</h1></th>
        <th valign="middle" style="{{ $headerStyle }}"><h1>LiefName</h1></th>
    </tr>
    </thead>
    <tbody>
    @foreach($orders as $order)
        @foreach($order->details as $detail)
            <tr>
                <td align="right">{{ $order->store->central_data_management_number }}</td>
                @if($storeMappings->count() > 0)
                    <td align="right">{{ $storeMappings[$order->store->id]['supplier_store_number'] ?? '' }}</td>
                @endif
                <td align="left">{{ $order->store->name1 }}</td>
                <td align="left">{{ $order->store->name2 }}</td>
                <td align="left">{{ (string) $order->store->address->streetWithoutNumber }}</td>
                <td align="right">{{ (string) $order->store->address->streetNumber }}</td>
                <td align="right">{{ $order->store->address->postcode }}</td>
                <td align="left">{{ $order->store->address->city }}</td>
                <td align="right">{{ $order->article->baseArticle->manufacturer->central_data_management_number }}</td>
                <td align="left">{{ $order->article->baseArticle->manufacturer->name }}</td>
                <td align="right">{{ $order->article->baseArticle->article_number }}</td>
                @if($articleMappings->count() > 0)
                    <td align="right">{{ $articleMappings[$order->article->baseArticle->id]['supplier_article_number'] ?? '' }}</td>
                @endif
                <td align="left">{{ $order->article->baseArticle->name }}</td>
                <td align="right">{{ $order->article->baseArticle->bundle_size }}</td>
                <td align="right">{{ $order->article->baseArticle->volume_of_content }}</td>
                <td align="right">{{ $order->article->baseArticle->packaging->name }}</td>
                <td align="right">{{ $detail->quantity }}</td>
                @if(!$isSupplier)
                    <td align="right">{{ number_format($detail->discountSum, 2) }} €</td>
                @endif
                <td align="right">{{ $order->store->isCentralStore ? 'ja' : 'nein' }}</td>
                @if($isFairy)
                    <td align="middle">{{ $order->FirstDeliveryKW }}</td>
                @else
                    <td align="middle">{{ $order->deliveryTimerange}}</td>
                @endif
                <td align="right">{{ $order->pickup ? 'ja' : 'nein' }}</td>
                <td align="right">{{ $order->bonusArticle->article_number ?? '-' }}</td>
                <td align="left">{{ $order->bonusArticle->name ?? '-' }}</td>
                <td align="right">{{ $order->bonusArticle->bundle_size ?? '-' }}</td>
                <td align="right">{{ $order->bonusArticle->volume_of_content ?? '-' }}</td>
                <td align="right">{{ $order->bonusArticle->packaging->name ?? '-' }}</td>
                <td align="right">{{ $detail->bonus_quantity ?? '-' }}</td>
                <td align="right">{{ $order->supplier->central_data_management_number }}</td>
                <td align="left">{{ $order->supplier->name }}</td>
            </tr>
        @endforeach
    @endforeach
    </tbody>
</table>

Here is an example cell where the error was triggered for:

PhpOffice\PhpSpreadsheet\Cell\Cell {[#5996 ▼]()
  -value: "Getränke Star Tholemeyer-Nöring"
  -calculatedValue: null
  -dataType: "s"
  -parent: null
  -xfIndex: 4
  -formulaAttributes: null
}

or this cell

PhpOffice\PhpSpreadsheet\Cell\Cell {[#6111 ▼]()
  -value: 550051
  -calculatedValue: null
  -dataType: "n"
  -parent: null
  -xfIndex: 3
  -formulaAttributes: null
}
}

i would appreciate any kind of hint or help. Thanks in advance

[patrickbrouwers]

Based on this information I can't tell you what exactly is trying to serialize. However if you run into memory issues with views, you shouldn't be using FromView. FromView uses a lot of memory for already transforming your view into an array of cells before it even starts inserting them.

[webcodecs]

The serialization error always pops up on serializing Cells. Two examples are above. I dont understand, where a clousre will be seriliazed.

The memory consumption of FromView is huge. Maybe i will change it

[webcodecs]

Okay it works if i use FromCollection instead of FromView. But im still interested why the Exception was thrown ;)