[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 862
  • Last Modified:

firebird database version 1.5.2 periodically at random the server to locks the firebird service

I am running a firebird database version 1.5.2 on a dual xeon server with 2GB RAM running windows 2000 server.
The business system is a set Delphi 7 apps which use IBObjects to communicate with firebird.  Periodically at random, the server appears to lock up such so that all instances of the application on all client workstations freeze.  
The server service will not respond to any shutdown or restart commands using command prompt or the firebird service gui utility. I need to restart the 2000 server to restart the service and all is OK until the next lock.
Locks occur any time of the day but generally only once a day 3 or so days a week. At bad times the server may lock 3 times per day.

The server task manager does not show 100% cpu usage.
The developer has looked at many things and we have had a third party developer also look at the system.  We have looked at transaction handling,the udfs etc.
Does any one have any suggestions on what could be the cause or if they have heard of this.

0
CSSROSS
Asked:
CSSROSS
  • 9
  • 7
  • 3
  • +1
1 Solution
 
phuocnhCommented:
Can you post your firebird.log, firebird.conf  here? I think your set of Delphi apps don't manage transaction very well.
It is better for troubleshooter if you shot your Task Manager (all tabs) while your apps are freezing and post somewhere (http://www.imageshack.us/) then link here.
Phuoc H. Nguyen
0
 
Gary BenadeCommented:
As a start I recommend you upgrade all clients and server to firebird 1.5.3.
Which version of IBO are you using?
0
 
NickUpsonCommented:
what is your sweep interval set to, set it to zero to switch it off
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
CSSROSSAuthor Commented:
OK some Feedback

NickUpson The Sweep Interval is already switched off

Hobbit72 Firebird 1.5.3 is currently on my development server (seperate server) and ready to be installed on the live server next week.
I have managed to lock the development Firebird 1.5.3.4870 server

Phuocnh I have a copy of the logs you have mentioned I have reviewed these time and time again and am happy to post them but I have no where to store them. I tried imageshack but it seems you can only post images, How can I display these files? Thanks
0
 
CSSROSSAuthor Commented:
I have finally set up a store for the files

firebird.log   - http://rossmarch.tripod.com/firebirdlog.log
Application log - http://rossmarch.tripod.com/app_log.txt
all other logs are empty

have analysed these files as have other external development companies. Unfortunately we have found nil.

Any other suggestions
0
 
CSSROSSAuthor Commented:
Firebird .conf- http://rossmarch.tripod.com/firebird.conf

Sorry missed this one.
0
 
phuocnhCommented:
I think firebird.conf  is small you can copy and paste here. Firebird.log can be large you can copy some last lines and paste here too. With imageshack you can post image you shot your taskmanager to troubleshooter can know what apps running on your box.
0
 
CSSROSSAuthor Commented:
Phocnh Can you access the links provided
0
 
phuocnhCommented:
I have read it. Your configuration is default. Some errors are in your log file but they just are minor.
0
 
Gary BenadeCommented:
How big is the data, and how much space is available on the data and temp drives?
How many users hit this database at the same time?
Do you have an antivirus running ont the server, and does it exclude gdb/fdb files?
Also try change CpuAffinityMask = 2 to CpuAffinityMask = 1, and ProcessPriorityLevel = 1 to ProcessPriorityLevel = 0 in your firebird.conf. ie. try default settings again.
0
 
NickUpsonCommented:
can you do a backup & restore of the database
0
 
CSSROSSAuthor Commented:
I have no antivirus running on the server, Database is now 1.2GB (locks have been occuring since it has been about 600MB).
I have 14GB free space on the partition which has firebird and database files. I have 500 MB on c:\ Drive.
I have paging file of 1GB on c:, 2GB on e:, and 2GB on f:
Hobbit72 You mentioned upgrading the clients to the latest version of firbird as well. what would be the easiest way to identify the client version of firebird?
I have made the relevant conf file changes as it can't hurt.
I have 35 users whom can access the application at one time but generally between 13 and 20 users will access the database at one time.
0
 
CSSROSSAuthor Commented:
Has any one any additional ideas?
0
 
phuocnhCommented:
You use 2-tier application model to connect to FB/IB, it is easy to get into a deadlock.
To prevent it, I think you should manage a connection pool well.

0
 
CSSROSSAuthor Commented:
phuocnh - not to sure what you are meaning?
0
 
phuocnhCommented:
I mean that the problem can be at your client site. If your client application doesn't manage transaction well, the server can be deadlock.
Another reason I used to caught that is net adapter sleeping when server get into idle time.
Are you sure to turn off this feature in your server box.
Phuoc H. Nguyen
0
 
CSSROSSAuthor Commented:
phuocnh - have checked the net adapter sleeping. Do you know how I can upgrade all clients to latest firebird or check to see version running on client machines. with this information I will upgrade the clients and close this question and accept for your input
0
 
phuocnhCommented:
Theriotically, firebird client just need fbclient.dll (gds32.dll).
0
 
phuocnhCommented:
To know its version, you right click on it, select "Version" tab, select "Product version".
0
 
CSSROSSAuthor Commented:
Thanks for the help phuocnh here's hoping we have it resolved
0
 
Gary BenadeCommented:
When the freeze happens, is everything stable except firebird - can you browse all drives and access the network?
When the freeze happens, can you connect to the database using IBOConsole, dbworkbench etc?
When the freeze happens, is there hard drive activity?
What is the CPU usage of fbserver when the freeze happens?
How long do you wait before restarting?
What error pops up on the clients?
Does the task manager allow you to terminate the fbserver process?
Does the server have a static IP address?
Have you done a full backup and restore recently? If not suggest you do immediately.
How big is your page size, and how many page buffers have you allocated?
Is sweep interval set to 0?

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 7
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now