User would get list view as blank when a key on the keyboard has been typed multiple times while within a filter field, exceeding the number of keys to 4,000.
This creates a URI that is beyond allowed size of 4096 and the list view fails.
With help of @snv figured out that table __UserSettings gets populated.
To resolve it followed the below:
Delete records from database:
In
bench mariadb
delete from __UserSettings where length(data) > 4000;
Sync user settings:
bench console
from frappe.model.utils.user_settings import sync_user_settings, get_user_settings
sync_user_settings()
Check if it is cleared: e.g. For Sales Invoice list view for user info@nowhere.com
bench console
frappe.cache().hget('_user_settings', '"Sales Invoice"::"info@nowhere.com"')