Two properties are defined in xwiki.properties: eventstream.uselocalstore and eventstream.usemainstore.

Those properties used to have 2 usages: they were used for the storage of the events in the DB, and they were used for the storage of the notification filter preferences that are stored in the DB.

Since we moved the events in Solr, and that we moved the post-filtering code to legacy, the properties are now only used for the storage of the notification filter preferences. So the documentation we currently have in xwiki.properties right now is wrong and outdated since it’s talking about the events.

Now the default for those properties is to rely on the mainStore (both properties are set to true, but mainStore has priorities over localStore). Main store means main wiki here. So the side effect is that right now all notification filter preferences are stored in the main wiki by default, instead of being stored in the same DB than the users: it’s not very consistent and it might even lead to problems in case of manual operations on the DB.

Proposal made in https://forum.xwiki.org/t/get-rid-of-eventstream-uselocalstore-and-eventstream-usemainstore-configurations/13136/ to change the behaviour.