Networker

[Networker] SOLVED: RE: [Networker] SQL backups fail but Legato shows Success ?

2003-10-09 09:42:39
Subject: [Networker] SOLVED: RE: [Networker] SQL backups fail but Legato shows Success ?
From: Riaan Louwrens <riaanl AT SOURCECONSULTING.CO DOT ZA>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Thu, 9 Oct 2003 15:51:52 +0200
Hi All,

It seemed to be one of those "Murphy" scenario's. As a matter of precaution
(and to rule out bugs / fixes patches) we upgraded the client from 611 to
613 and the problem 'went away'.

All backups now report 100%.

(I still have no explanation, but we'll leave it at that).

Thank you for the various replies, i'll bug you soon with another brain
teaser ...

;p

Regards,

Riaan

-----Original Message-----
From: Riaan Louwrens
Sent: Thursday, October 02, 2003 3:51 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: Re: [Networker] SQL backups fail but Legato shows Success ?


Sumie,

When you backup one DB you get exactly the same symptom: i.e. the save
happens, when the stream ends the nsrsqlsv process doenst end.

Legato eventually times out and tries to kill the process.

The group shows successfull but there is no more in-depth info in the groups
details.

Riaan

-----Original Message-----
From: Sumash Singh [mailto:ssingh AT STORTECH.CO DOT ZA]
Sent: Thursday, October 02, 2003 3:27 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: Re: [Networker] SQL backups fail but Legato shows Success ?


Riaan,

What happens when you backup just one Database. Does the group end
successfully?? And the nsrsqlsv process?? Does this also terminate
correctly??

Sumash

-----Original Message-----
From: Riaan Louwrens [mailto:riaanl AT SOURCECONSULTING.CO DOT ZA]
Sent: 02 October 2003 03:24 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: [Networker] SQL backups fail but Legato shows Success ?


Hi There,

I would like to pick the list's collective thoughts:

We have a SQL (v7 sp4 - Win2K SP3) client machine that is backing up to a
Solaris (8) 6.1.1 Networker server.

For a while now the group details have shown that there is "8GB" backed up -
BUT - then it states "nsrexec attempting a kill on remote server - Aborted
due to inactivity. The group's status shows a green light and successfull.

The DB is only 8GB big.

I have applied the latest 3.1 version to my svr.
I have checked all logs (all fine and show no anomalies).
I have upgraded the client to 6.1.3.
I will be (out of desperation) upgrading the BS svr to 6.1.3.
I have checked admin rights.
I have changed group timeout settings.

There is +- 45 DB's on the SQL svr. What I have found though is that if I
watch Legato and when the save process end - I manually kill the nsrsqlsv
processes on the client - then the next saveset will continue directly. If I
continue doing this 45 times the group will finish successfully and the
group details will be correct - (i.e. info on each DB size is displayed).

This is obviously a problem with killing the processes - all the Legato
rights / processes are full admin (even changed the account the service runs
under).

Apart from COMPLETELY reinstalling SQL (i.e. trash server) is there anything
else I can do ? Thoughts ? Comments ? Jeering remarks about my bad typing ?

Thanks !

Riaan

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>
  • [Networker] SOLVED: RE: [Networker] SQL backups fail but Legato shows Success ?, Riaan Louwrens <=