store: Log more details when SubscriptionManager encounters problems #10368

Job	Run time
Run unit tests	6m 31s
Check rustfmt style	27s
Run integration tests	4m 25s
Clippy linting	2m 27s
Build in release mode	4m 33s
Subgraph Runner integration tests	3m 25s
	21m 48s

Provide feedback