Subject | Re: [firebird-support] FB 2.1.1 server crashing randomlly |
---|---|
Author | Helen Borrie |
Post date | 2009-02-03T21:33:26Z |
At 11:42 AM 3/02/2009, you wrote:
8) OS threading model. You'll get "random crashes" if
a) you're trying to use the NPTL package on a Linux where NTPL is broken.
b) you're trying to use the non-NPTL package on a Linux where NPTL is the active threading model.
9) You're getting an out-of-memory condition under load with 600 users threading off one Superserver process.
10) You are running some admin tool alongside regular user applications, that is keeping a MON$ transaction running and consuming resources
./heLen
>We have a pool of more than 600 users accessing some FB 2.1.1Superserver?
>databases on a Open SUSE Linux server from different win32 apps
>(Delphi 7 and VB6).
>We have migrated those databases from FB 1.5 since there was aNo
>performance problem with large DB sql queries and stored procedures
>(one of this DBs has a single file of more than 9 GB with a table of
>more than 25 millions of records).
>After the migration, the server begins with random crashes
>("terminated abnormally (-1)" message on firebird.log).
>Unfortunatelly, this log is not enough to detect what is the problem.
>After some surfing through several forums we detected that problems
>could be among:
>1) incompatibility of clients (gds32.dll, fbclient.dll, etc.)
>2) incompatibility of UDFs (i.e.: rfunc)Yes
>3) Network disconnection of some clients (errors 104, 32, etc. in theNo - these are symptoms, not causes
>log).
>4) Incompatibility of components used in the source code (Zeos,No
>Intersol, IProvider, etc.)
>5) Queries that are restricted from FB 2.0 (table alias, etc.)No. Exceptions, yes.
>6) Linux rights over some files or folders? (errors while writing toNo. If permissions were the problem, it wouldn't cause random crashes. It just wouldn't work.
>FDB datafiles).
>7) Any other I forget?Assuming Superserver (because of the Guardian message you're seeing in the log)
8) OS threading model. You'll get "random crashes" if
a) you're trying to use the NPTL package on a Linux where NTPL is broken.
b) you're trying to use the non-NPTL package on a Linux where NPTL is the active threading model.
9) You're getting an out-of-memory condition under load with 600 users threading off one Superserver process.
10) You are running some admin tool alongside regular user applications, that is keeping a MON$ transaction running and consuming resources
./heLen