Error trying to download export as .xlsx
An export has recently started failing in production when I try to download as .xslx. It still works fine if I download as .csv.
The same report also works fine locally.
Stack trace is attached.
I have checked the storage folder and I see the .xlsx file there, and I can download it through ftp just fine.
Permissions look fine, they're the same for every file in storage.
Any clue as to where I should start debugging?
2 Replies
Is it possible you have multiple queue workers running the same queue? Seems strange there is no buffer to delete unless it's been cleaned as the export happens in the buffer
I have multiple queue workers, but they each operate on just one queue at a time
I'll try stopping my workers and see if I can manually run the queue worker just once to be sure
Also, the error is triggered when I click the download button in the notification so the actual export seems to run fine
Yeah that didn't work. Stopped all my workers, hit the export button, ran queue:work, it generated the export files just fine, but when I try to download as .xslx it errors out. Downloading as .csv works fine.
Gotta run into a meeting right now so might be slow to answer for the next couple hours or so
Bumping this because I still can't figure it out. Everything works fine on dev, but on prod the
ob_end_clean() triggers an error. I monkey-patched the XlsxDownloader class to just comment out ob_end_clean() and this seem to be working fine for now, but that's obviously not a solution I'm confortable with long-term.