Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

30 questions
4
votes
3 answers

Firebird CpuAffinityMask for 16 core server?

I have a server with 16 cores. What do I set the CpuAffinityMask to? 1111 1111 1111 1111 is 65535, should I put 65535? Also, how to I configure the SuperClassic server? This is for Firebird 2.5. TIA
ioan
3
votes
1 answer

Firebird slowdowns while resources are available

I have a strange slowdown problem with a Firebird database. During the daily use of the database the clients experience significant slowdowns while the system still have lots of resources available. Some information about the environment: 64 bit…
Zizzencs
  • 937
  • 1
  • 10
  • 22
3
votes
2 answers

Using pconnect on several databases in PHP on Apache2

I am running PHP in preforked(MOD_PHP) on an apache2 server. The setup is on linux Ubuntu 10.04. The database I am using is a firebird database 2.5.2. The apache2 server are running in a web cluster consisting of 8 webservers. At a point in time we…
Ronnie Jespersen
  • 221
  • 5
  • 13
3
votes
2 answers

Network connection to Firebird 2.1 became slow after upgrading to Ubuntu 10.04

We've got a setup that we're using for different clients : a program connecting to a Firebird server on a local network. So far we mostly used 32bit processors running Ubuntu LTS (recently upgraded to 10.04). Now we introduced servers running on…
lyle
  • 131
  • 4
3
votes
3 answers

Vmware Esxi - Old 32bit software performance issue on multi core

I've been going crazy for 2 days now and I'm asking for help. I have a program developed in delphi (early 2000s about) that accesses a firebird v3 database, currently installed on the same machine (windows server 2016 x64 - db and program are…
MenInTheMiddle
  • 39
  • 3
3
votes
3 answers

Firebird on FreeBSD

Does anybody know on how to install Firebird 2.0 on FreeBSD 7.2? I have updated the ports and the kernels, but when I try to do a "make install", I get the error: Please do not build firebird as 'root' because this may cause conflicts with SysV…
Victor Ian
  • 171
  • 4
2
votes
4 answers

High memory utilization with firebird + windows server 2008 r2

i have a Windows Server 2008 R2 (64bit) running a 64bit installation of Firebird 2.1.4.18393_0 in a 4GB phisical server. After a while, the task manager show that all memory is used, but the sum of the memory of all process does not stack to the…
chesterman
  • 65
  • 1
  • 3
  • 12
2
votes
0 answers

Firebird 2.5 Database Corrupt

We have an issue where a database hangs the server when: a backup is performed (Hangs on a specific table) selecting * or count(1) from a specific table or viewing data that is related to the table (FKs, etc) We could browse the table to a certain…
BrendanH
2
votes
2 answers

Firebird 2.1: gfix -online returns "database shutdown"

Googling this one hasn't made a bit of difference, unfortunately, as most results specify the syntax for onlining a database after using gfix -shut -force 30 (or any other number of seconds) as gfix -online dbname, and I have run gfix -online dbname…
user41758
1
vote
1 answer

Is there any workaround to make Firebird v2.5 under Arch Linux attach existing databases and open them?

I have tried almost everything to get Firebird v2.5 under Arch Linux connect to an existing .fdb database without getting the error message: *** IBPP::SQLException *** Context: Database::Connect Message: isc_attach_database failed SQL Message :…
Tomay
  • 11
  • 3
1
vote
0 answers

Connection to specific firebird 2.5 server is slow

I have the following setup: Two laptops connected to a network using the same switch Multiple Windows Server running Firebird 2.5. My problem is that when I try to connect to one specific firebird server (172.16.2.106) using my first laptop…
Kia
  • 123
  • 3
1
vote
1 answer

Firebird Backups Failing with Two Installations on Windows

I have a Windows Server running Firebird 2.5.4 on port 3050, and I have another Firebird Server older version on port 3051. I use the 3051 server for compatibility reasons for another application. I turn it on when I need it, and most of the time it…
Israel Lopez
  • 113
  • 3
1
vote
4 answers

How to migrate data from a Firebird database to PostGreSQL on Linux

Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly written to export/import from one firebird db to…
Tom Feiner
  • 16,758
  • 8
  • 29
  • 24
1
vote
2 answers

QoS for Firebird database connections - how?

Our Firebird database connection goes through a network connection that seems to imply a high latency for normal TCP connections. However, I am quite sure that the network connection supports quality-of-service on network traffic. Is there any way…
Lars D
  • 280
  • 2
  • 16
1
vote
1 answer

What may the reason of slowness be (see details in message body)?

I've got a really weird situation I'm beating to solve. A performance problem which looks really like an empty waiting sequence set in code (while it probably isn't so). I've got a pretty powerful dedicated server (10 GB RAM, eight Xeon cores, etc)…
Ivan
  • 3,288
  • 19
  • 48
  • 70
1
2