We have experienced problems with our application which seem to be
specifically related to Firebird 1.5.2 SuperServer
and Windows 2003 SBS. We do not have direct access to the system in
question so have not have the opportunity
to analyse it personally, but it appears from the user point of view that
the firebird server service freezes up every
couple of days or so.

We have looked at issues like background backup services that may have been
attempting to copy the firebird database
while it was being used, however removing the database from the backup
didn't remove the problem.

It is not possible to stop and restart the service manually when it freezes
because attempting to stop the service fails, leaving
the service in "Stopping" mode , but never stopping it.

The only solution has been to reboot the server which seems to get
everything back to normal.

The problems did not exist when the users were running Firebird 1.5.1, they
started after the 1.5.2 upgrade.

Exactly the same symptoms have manifested on two client's systems, both
using Windows 2003 SBS.

The application uses the IBX components and is written in Delphi 5, about to
be migrated to Delphi 2005 in the near future.

We have run the same application of Windows XP, 2000 and even 98 machines as
servers with Firebird 1.5.2 and have not
experienced any similar problems.

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Myles Wakeham
Sent: Saturday, 25 June 2005 5:03 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] General concensus on possible issue


I have been monitoring the forums regarding a potential issue with Firebird
1.52 Super Server, and I believe that it is not an issue related
specifically to the database server software, but to the way in which it is
used.

A collegue of mine recently stopped using Firebird for a mission critical,
transactional application because they found that the performance of the
database was good most of the time, but in some cases the database appeared
to have 'stalled' and was taking 30 seconds or more to process a simple
query. This seemed to coincide with the CPU on the server running at 100%
utilization with Firebird taking the majority of the horsepower of the box.

I suspect that the problem may have been in the way that their architecture
was setup, as we have never seen this behavior with our applications. Mind
you, all of our applications are built around stored procedures, and all run
on Windows 2000 servers, with Firebird 1.52 Super Server. I believe their
hardware platform/OS was Windows 2003 SBS with Firebird 1.52 Super Server
using a .NET provider from their client applications to the database. They
were not using Stored procedures at all. In our case, we are either using
PHP or we are using Delphi with native API through FIBPlus for the
connectivity.

We are currently working on a large, transactional application as well and I
want to be sure that we won't land in the same position as my collegue did.
Are there specific instructions that have been learned through the 'school
of hard knocks' that ensure one doesn't create a situation in Firebird where
it goes into a 100% CPU utilization mode? I'm still unsure as to the cause
of this, but would prefer to devote time to avoid this situation rather than
respond to it, if and when it occurs.

I would also like to hear any success stories regarding high volume,
transactional client/server applications with Firebird 1.5x on the backend.
It would sure help to hear the glories that people are getting with this,
amongst the negative issues.

All feedback on this greatly appreciated.

Regards,
Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]