> 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

>
> 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
>
>
>
>
>
>
>