Forum Discussion

Level 5

13 years ago

SQL Logs Job Stuck on Connecting state

I run the sql logs backup but since last 2hours it was stuck on connecting state .... nothing is processing. Find the screenshot attached.

Marianne
13 years ago
Check client Host Properties - ensure new Master is specified as Master.
Seems your client still has old master listed as Master?
**** EDIT **** Just remembered something else: Check SERVER entry in script as well.

Level 6

13 years ago

Nope - not stuck in connecting state.

Have another look - I see 'Connected' as well as bphdb started on client - PID 8120.

You need to check what is happening on the client. Check Task manager for 'db...' and 'bp...' processes running.

Hopefully you have bphdb and dbclient logs enabled on client. If so, rename to reflect process name (e.g. dbclient.txt) abd post as attachments.

Also check SQL errorlog and VDI logs.