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