[6.x] Collection entries are not getting loaded in the CP

[AtmoFX]

Bug description

On 6.0.0-alpha.11, entries for 1 of my collections are not being displayed by the CP.

How to reproduce

I do not know how to reproduce, but I noted some differences in the queries logged by the debugbar, hoping it can give you enough clue to at least tell me where to put a breakpoint.

When loading the collection, the queries shown are:

Then, within the same page load, the tab content is changed to:

---

For a collection that gets loaded (Pages), the queries are first:

Then, the SELECT COUNT(*) as aggregate ... disappears (thus the logged queries very much look like the 2nd screenshot above), then the tab content changes again and logs:

A lot of queries inside Assets are not shown below that section of the bar but the important point is that entries get selected this time

Logs

AFAICT, no logs get written.

Environment

Environment
Application Name: GaiaMine UAT
Laravel Version: 11.46.1
PHP Version: 8.4.13
Composer Version: 2.8.10
Environment: local
Debug Mode: OFF
URL: design.test/
Maintenance Mode: OFF
Timezone: UTC
Locale: en

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: file
Database: mysql
Logs: stack / single
Mail: smtp
Queue: sync
Session: database

Pulse
Enabled: ENABLED
Version: v1.4.3

Livewire
Livewire: v3.6.4

Statamic
Addons: 5
Sites: 1
Stache Watcher: Enabled (auto)
Static Caching: Disabled
Version: 6.0.0-alpha.11 PRO

Statamic Addons
alt-design/alt-seo: 1.3.0
jacksleight/statamic-bard-mutator: 3.0.5
pecotamic/sitemap: 1.4.10
statamic/eloquent-driver: 4.32.0
stillat/antlers-components: 2.6.0

Statamic Eloquent Driver
Asset Containers: file
Assets: file
Blueprints: file
Collection Trees: file
Collections: file
Entries: eloquent
Fieldsets: file
Form Submissions: eloquent
Forms: file
Global Sets: file
Global Variables: file
Navigation Trees: file
Navigations: file
Revisions: file
Sites: file
Taxonomies: file
Terms: file
Tokens: file

Installation

Other (please explain)

Additional details

Site migrated from 5.x

[duncanmcclean]

When you say they're "not getting loaded in the CP", what do you mean exactly? Is the listing empty? Are there any errors in the console?

[AtmoFX]

Yes, that is exactly what I mean.
In the case of my Research collection, the best I get is these skeletons:

After a few seconds, the skeletons disappear and all that remains is the "Research" title with a completely white area under it and that lasts for as long as I was willing to wait (>15 minutes).

Regarding the errors in the console, you are making a good point.
I originally thought there was none but leaving the page opened while I was writing this very comment shows I was wrong. It takes some time to finally appear but I ended up seeing:

---

Some more observations since I opened the issue:

1. The issue persists in alpha.12

2. After my computer boots up (or right after the upgrade to alpha.12), I get 504 Gateway Time out errors on the faulty pages, i.e. /cp/collections/research and /cp/collections/ (see the issues below) while, at the same time, other pages load fine (e.g. /cp/collections/pages).

3. Though I doubt it could possibly be the issue, Research is the only collection for which I changed the icon
   

4. Above, I talked about the SQL queries but I can see in other parts of the debugbar:

   • On /cp/collections/pages:
     
     
   • On /cp/collections/research:
     
     

5. Despite what is happening, the research collection loads perfectly normally in the front end as well as in /cp/collections/ (it is shown last but not by much and this could be because it is one of the largest collections it has to load + judging by the fact there is no top right "Blade" label, I believe both /cp/collections and /cp/collections/research are on Inertia).
   
   With that said, I have noticed 2 additional points on that page:

   • it sometimes happens that the entries are not listed for a collection. During the time it took to write this comment, I refreshed the page a few times and I see this, with another "variable is undefined" error. This collection is the top-right & truncated from the above screenshot and it was displaying entries when I took it, not after a refresh though.
     
     
   • All the "Published" count are 0, though it is incorrect