Hi All,

Every day we get a problem with Stream and Search service on our Dev environment.

So We make every day a clean restart to make those services started correctly.

We have 2 nodes: one for Frontend (NodeType= WebUser) and one for Backend (NodeType=Backgroundprocessing, Batch, Stream, Search)

Every restart We run those truncate commands on the database:

``` 

truncate table  pegadata.pr_data_stream_node_updates; truncate table  pegadata.pr_data_stream_nodes; truncate table  pegadata.pr_data_stream_sessions; truncate table  pegadata.pr_data_qp_run_partition; truncate table  pegadata.pr_sys_statusnodes; truncate table  pegadata.pc_work_dsm_batch; truncate table  pegadata.pr_data_decision_ddf_run_opts; truncate table  pegadata.pr_data_decision_df_part; truncate table  pegadata.pr_data_decision_ddf_error; truncate table  pegadata.pr_data_decision_df_met; truncate table  pegadata.pr_log_dataflow_events; truncate table  pegadata.pr_data_decision_ddf_runtime;

```

So is there a solution to avoid restarting every day? because developers waste time every day and sometimes a developer needs to work on weekends or at night and he gets stuck