UPDATE START:
I did went back to php 7.0.30 and did TRUNCATE the cbsubs_history table. At least I do not get any new ERROR_logs during browsing the site. As a logged in user the whole site i.e browsing user profile list, or show details of a certain user etc. is unbelievable slow. If I do this as a guest I do have a good performant site. Any thoughts what it could be?
UPDATE END:


Hello!

my cbsubs_history database is now at a size of 19.4GiB - in the CB Subs History backend view I do see that for every logged user I get tons of these error log messages added into the history log (see the attachement)

Any ideas what could be wrong here?

Using the following environment:
Joomla 3.8.5
PHP 7.2.7
CB 2.1.3
CB Subs 4.1.1+build.2018.02.15.21.30.26.93a914c2d

I know that these versions are not bleeding edge (update is planned) but they were working for months but now I get flooded with these error logs and due to the size of the cb_subs_history table and the corresponding queries the site is unbelievable slow.

Any hints more than welcome - even short term like disabling the logging so that the table will not increase more. Can I delete all error messages from the table with with DELETE FROM cbsubs_history WHERE event_type=1 without side effects?

Thanks a lot
Frank

UPDATE START:
I could isolate the problem a bit. I turned on the CB paid subscription plugin again and disabled a module (type of cb content with "[cb:usertab tab="17" /]" This tab with id 17 is just tab type of CB Menu. If this module is turned off the user profiles and the user list (only in these two menus the module gets shown) loads perfectly fine. Did anything changed recently in the cb content handling?
UPDATE END:

Hi Krileon,

thanks for your answer. I updated yesterday the whole site to the bleeding edge versions:
Joomla 3.8.12
CB 2.2.1 with the following other CB Plugins (CB Auto Actions, CB PRivacy, CB Conditional all the latest versions)
CB Subs 4.3.0+build.2018.07.05.21.23.07.5cee7f443

I went back to PHP 7.0.30

I do not get any new error logs into cbsubs_history just "normal" logs like a new user subscripted. I also truncated that massive table. so now it just has 30 entries. But the complete site is unbelievable slow. Just loading a user profile page takes up to 13.98 seconds . With the Chrome debug tools I do see in the profiling that there is a WAITING of 12.79 seconds. I attached the screenshot (loading_user_profile_paid_subscription_plugin_published.jpg) - if I just unpublish the CB Paid subscription plugin within the CB Plugin manager the same user profile load just takes 2.02s and there is just a WAITING of 472.82 ms. (look screenshot loading_user_profile_paid_subscription_plugin_unpublished.jpg)

So how can the cb paid subscription plugin influence the load of a user profile so dramatically? Do you have any idea? Do we have a chance that you might look into our site? Could mail you credentials via PM.

Thank you so much for your support

Frank

Hi!

After further investigation I can give you some more informations. I figured out which module is delaying the overall loading time of the userlist and also the profile view of a user profile (not the own profile)

On a Joomla menu where the cb user list gets shown and also within the profile view I do show a module type of cb content where I display the CB Menu tab. The content of that module is (17 is the id of the corresponding CB Tab (CB Menu):

Loading my own (profile of the logged in user) profile page I do get the following loading times with the Joomla debug system:

This is shocking long. As you proposed I reduced the number of published CB Subs Plans (was 14 and now I have just 6). With that reduced amount of available CB Subs Plans the loading time reduced down to:

which is better but still far away from good. I do show/hide some menu items within that CB Menu with CB Auto Actions - I disabled all these Actions but the loading time still stays at that high level.

So the problem is quiet well isolated but I have no idea how I could improve this. On the cb user list I had the same problem but there I could just disable the show of that CB menu module (from UX point of view it was not mandatory there) but I cannot disable the CB Menu within the profile view because there I do need the ability to "Send private Message, Manage Favorites, Remove From Favorites" which are items within that CB menu.

The very strange thing is that this enormous loading time is only within the profile view of my own (the logged in user) profile. If I load other users profile I do get the following loading times:

The same module with the CB menu gets shown there as well but the loading time is just 4.59ms and not 3199 ms like I do get within loading the logged in user profile.

I hope that my explanations are making sense for you and you do have some good ideas.

Thanks for your support
Frank