Re: [Sqlrelay-discussion] Database Server Failover BUG

[Firstworks/4access <dav...@fi...>]

Thanks, I'll apply this fix and it'll be in the next release.

David Muse
dav...@fi...

On Fri, 2005-10-07 at 12:52 -0700, Cesar Peregrina wrote:
> I'm using sqlrelay to connect to MS-SQL thru freetds
> 
> When the DB Server goes down the I got this message:
> 
> ERROR sendQuery: Client Library error:
>         severity(78)
>         layer(0)
>         origin(0)
>         number(38)
> Error:  Write to SQL Server failed.
> 
> But the connection stay live and doesn't try to reconnect
> I look into the code and found that this error isn't considered
> A server fail for freetds only the read
> 
> src/connections/freetds/freetds.C: 
> 	CS_RETCODE freetdsconnection::csMessageCallback
> 	.
> 	.
> 	.
> 	// for a read from sql server failed message, set deadconnection
> to 1
>       } else if (CS_SEVERITY(msgp->msgnumber)==78 &&
>               CS_LAYER(msgp->msgnumber)==0 &&
>               CS_ORIGIN(msgp->msgnumber)==0 &&
>               CS_NUMBER(msgp->msgnumber)==36) {
>               deadconnection=true;
>       }
> 
> I think must be 
>       // for a read-from or write-to sql server failed message,
>       // set deadconnection to 1
>       } else if (CS_SEVERITY(msgp->msgnumber)==78 &&
>               CS_LAYER(msgp->msgnumber)==0 &&
>               CS_ORIGIN(msgp->msgnumber)==0 &&
>               (CS_NUMBER(msgp->msgnumber)==36 ||
>                CS_NUMBER(msgp->msgnumber)==38  )) {
>               deadconnection=true;
>       }
> 
> 
> And the same in 
> 
> 	CS_RETCODE freetdsconnection::clientMessageCallback
> 
> 
> Appreciate comments.
> 
> 	Thanx in advance
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>