Alan McDonald wrote:

>>I had this same exact error for a while and traced it to us accidentally
>>passing in a variable that was too large to one of our udfs. Once we
>>modified the udf to handle a larger input string the error went away.
>>
>>-steve
>>
>>
>
>yep - UDFs could easily by the issue. And smells like just the reason that
>linux handles it better than windows
>Alan
>
>
>

The thing is, that it is poosible to model situation with no udf with
same results. Sample :
create procedure ... XXX ... ...
declare variable X1 char(1)
X1 = 'AAAAAAA' -- Overflow exception


No udf is used, FB server closes all connections for all clients,
and win just throws exception about overflow.
Of course this is error situation, but by this ALL USERS from server
are kicked out from DB, what IMHO shouldnt be.
We tried to backup, and restore DB : same result.
And question remains the same : FB win and linux are acting differently

Adomas

>>On Fri, 2005-07-01 at 23:53 +1000, Alan McDonald wrote:
>>
>>
>>
>>>>Hi,
>>>>Currently we are facing strange behavior of DB in linux (Linux
>>>>
>>>>
>>>Mandrake,
>>>
>>>
>>>>Athlon 64bit ~3GHZ ,Db ~ 3Gb). If someone executes something (Sp or
>>>>select), what returns exception "Numeric or string overflow",
>>>>
>>>>
>>>server
>>>
>>>
>>>>kills all connections, and all users have to reconnect to db. In win
>>>>envir. there appears only exception of overflow.Any ideas how to get
>>>>same behavior on linux ?
>>>>
>>>>Adomas
>>>>
>>>>
>>>I think I'd be checking the health of the database first - before I
>>>wanted
>>>such an error to pass quietly.
>>>If this error is not linked to a specific statement, then do a
>>>backup/restore cycle. If it's only one select or SP, then I'd be
>>>digging
>>>around to find out why it's happening.
>>>Alan
>>>
>>>
>>>
>>>
>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>>Visit http://firebird.sourceforge.net and click the Resources item
>>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>>
>>>Also search the knowledgebases at http://www.ibphoenix.com
>>>
>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>>Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>[Non-text portions of this message have been removed]
>>
>>
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Visit http://firebird.sourceforge.net and click the Resources item
>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>>Also search the knowledgebases at http://www.ibphoenix.com
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>