Grocy breaks after adding certain amount of products in master data

[BeLeFu]

Hey guys, I’m experiencing a problem and i couldn’t seem to find anything like this anywhere:

Grocy is great and worked perfectly on syncloud. Until I get over a certain threshold of poducts in master data.

At a few more than 80 products, the android app throws java errors when trying to do anything else but list the stock overview.

At 90-something products, the browser version starts sending blank pages on almost everything but the stock overview and master data editing pages.

I tested this with the official grocy demo server and nothing like that happens there.

Has anyone here experienced this? How could I go on troubleshooting the issue?

Thanks in advance
BeLeFu

[boris]

Can you reproduce the issue and send us logs from Settings - Support (include support) please?

[BeLeFu]

Hi Boris,

yes the error happens consistently every time I add more than 83 products.
I sent the error log after doing the following:

There were 83 products in the master data,
I added an 84th one and navigated to the purchase page - got a blank page back.
Went back to the products page in master data and removed the 84th entry - navigated to the purchase page and it worked as expected.

[boris]

hmm, nothing in the logs.
Let me add 84 products on my test device.
Meanwhile can you open Developer Tools and look at Console tab and Network tab to see if there is anything unusual when opening 84th blank pages?

[boris]

I was able to add 90 products without an issue.
Can you send me the output of this command?

du -h /var/snap/grocy/current/data/grocy.db

[BeLeFu]

Screenshots at 83 products:

(Splitting the post bc of 1 image per post limit)

[BeLeFu]

[BeLeFu]

more than 83:

[BeLeFu]

Output of the command:

root@syncloud:~# du -h /var/snap/grocy/current/data/grocy.db
1.6M /var/snap/grocy/current/data/grocy.db

Also I already tried reinstalling grocy, both with and without restoring from a backup, to no avail.

[boris]

Can you click on publish request on network page and see the response when more than 83 please?

[BeLeFu]

Here’s the network tab output

[BeLeFu]

And the elements tab for good measure: it really just sends an empty html page

[boris]

Sorry I mean lt if you click on the line which says “purchase” on Network tab it will open more details on right side. The most interesting tabs on the right side will be Headers and Response.

[boris]

Splitting the post bc of 1 image per post limit

Changed to 10

[BeLeFu]

[boris]

ok I cannot find anything in their issue tracker, would you be able to send your grocy.db file to support@syncluod.it so I can reproduce it locally?
You can clean it from any personal data.
I there anything special in this last product?
If you change least with previous the result is the same?

[boris]

strange, it works fine on my arm64 test device.
ok let me create an automated test to see that it is working on all supported CPUs and then I will try to upgrade php as there are some mentions on the internet about instability around php 8.2 so I will try to upgrade to 8.3 and will let you know.

[boris]

Hey, sorry for the delay, I have just pushed a new version with upgraded php and more tests (creating a 100 products and is still green). Let me me know if that helps.