Extremely slow response when on Guest Account

74 views
Skip to first unread message

Opicron

unread,
Aug 26, 2021, 7:28:41 AM8/26/21
to ResourceSpace

I found multiple threads about unresponsive Guest accounts.

Some solutions where to disable the collection bar. Which worked for some people.

I found that in the years (from version 8.6 to 9.6) my collection table (database) was filling up with millions of 'Default Collection' from Guest accounts.

These were automatically generated somehow and maybe still are. This I dont know.

Anyway, I ran the following database query:

delete from collection where name="Default Collection";

Now the RS is blazing fast again.

Opicron

unread,
Aug 26, 2021, 7:32:22 AM8/26/21
to ResourceSpace
The table entries are still being created! This is on a open guest account setting. Clearly a small bug somewhere =).

Anybody able to fix this? In the meantime I run this query daily to avoid more issues.

ref;name;user;created;public;theme;theme2;theme3;allow_changes;cant_delete;keywords;savedsearch;home_page_publish;home_page_text;home_page_image;session_id;theme4;theme5;theme6;theme7;theme8;description;type;parent;thumbnail_selection_method;bg_img_resource_ref
1382527;Default Collection;2;2021-08-26 11:30:59;0;;;;0;1;;;;;;970240924;;;;;;;0;;;
1382528;Default Collection;2;2021-08-26 11:31:10;0;;;;0;1;;;;;;1786567908;;;;;;;0;;;
1382529;Default Collection;2;2021-08-26 11:31:12;0;;;;0;1;;;;;;845044167;;;;;;;0;;;
1382530;Default Collection;2;2021-08-26 11:31:21;0;;;;0;1;;;;;;437398349;;;;;;;0;;;
1382531;Default Collection;2;2021-08-26 11:31:32;0;;;;0;1;;;;;;528693891;;;;;;;0;;;

Etc etc..

Opicron

unread,
Aug 26, 2021, 7:59:03 AM8/26/21
to ResourceSpace
Maybe not so much of a bug, more of not running the cron job 013 (remove_anonymous_collections.php).

Well, hopefully this will help other users in the future.
Reply all
Reply to author
Forward
0 new messages