[BUG] Invalid prisma.marketData.findMany() invocation

[aveekbhat]

The Issue tracker is ONLY used for reporting bugs. New features should be discussed in our Slack community or in Discussions.

Bug Description

Accounts section does not work see screenshot below
Seems to be a prisma library issue
Invalid prisma.marketData.findMany() invocation:
Assertion violation on the database: too many bind variables in prepared statement, expected maximum of 32767, received 37180
prisma/prisma#21648

Screenshots

Logs

_ghostfolio-ghostfolio-1_logs.txt

Environment

• Self-hosted
• Ghostfolio Version 2.22.0 - 2023-11-11
• Browser Chrome/Firefox
• OS Windows/Archlinux

Additional context

[dtslvr]

Maybe be related with this change here of #2631? 🤔

[dtslvr]

@aveekbhat @Pindol83
I am not able to reproduce this error locally. Can you give a rough estimate of how many assets / activities you have in Ghostfolio?

[aveekbhat]

sorry for the late reply .. i have 534

@aveekbhat @Pindol83 I am not able to reproduce this error locally. Can you give a rough estimate of how many assets / activities you have in Ghostfolio?
i have 534 activities ..

I downgraded to version 2.20.0 (i was running that before) and everything is normal .. i will wait for the next release

[dtslvr]

Thank you for the reply, @aveekbhat.
There is a new release available addressing this: https://github.com/ghostfolio/ghostfolio/releases/tag/2.24.0
Does it fix the issue?

[aveekbhat]

Thank you for the reply, @aveekbhat. There is a new release available addressing this: https://github.com/ghostfolio/ghostfolio/releases/tag/2.24.0 Does it fix the issue?

Just upgraded it to this release and everything looks great !! 💯

[dtslvr]

Just upgraded it to this release and everything looks great !! 💯

That's great. Thanks for the feedback 😎

[shiruken]

I was also seeing this error but upon updating to 2.24.0 I'm now seeing flat lines (0%) on all performance charts and $0.00 values for all my holdings. No error messages are being generated in the logs.

[dtslvr]

I was also seeing this error but upon updating to 2.24.0 I'm now seeing flat lines (0%) on all performance charts and $0.00 values for all my holdings. No error messages are being generated in the logs.

Do you see anything if you create a new user account and import the activities of ok.json?

[shiruken]

Do you see anything if you create a new user account and import the activities of ok.json?

Nope, everything is still zeros with errors in the log

[dtslvr]

Cannot read properties of undefined (reading 'items') seems to be a different issue: #1228

[shiruken]

Cannot read properties of undefined (reading 'items') seems to be a different issue: #1228

Ah, that's it. I recently disabled the TZ="" variable in my configuration because I couldn't remember what it was for. Added it back and everything is working again now.

[dtslvr]

Ah, that's it. I recently disabled the TZ="" variable in my configuration because I couldn't remember what it was for. Added it back and everything is working again now.

Interesting. Could you please document your insights in this ticket #2669, too?