libpthread compatibility problem with Firebird 2.5

We’ve identified an issue where the latest libpthread library versions are not compatible with Firebird 2.5 (including the latest available release of vanilla version 2.5.9.27139 and HQbird 2.5 till the version 2.5.9.27173).

This incompatibility may cause Firebird 2.5 to crash during certain operations on newer Linux distributions. The error occurs frequently in architectures SuperServer and SuperClassic, and less frequently, in Classic.

Immediate Action Required:
To prevent any impact on Firebird 2.5, please follow the guidance provided below.

Assessing Your System:
Determining which Linux distributions are impacted is dificult since libpthread updates can be applied to older operating system versions, potentially introducing the issue to Firebird. It means that any update of OS can bring the problem to your system, even if you are running old version. It means that you need to test your instance of OS.

Testing for Compatibility:
We’ve developed a command-line application to test whether libpthread is compatible with Firebird 2.5.

Download Instructions:
•  The binary for the test application can be downloaded from the following link: www.ib-aid.com/download/libpthread/pthr-tst
•  The source code for the test application is also available at this link: www.ib-aid.com/download/libpthread/test.cpp

Execution Guide:
Execute the test application in your terminal as outlined in the instructions below to perform the compatibility check.

For the Operating System with old libptread (i.e., it is compatible with 2.5)  

wget https://ib-aid.com/download/libpthread/pthr-tst
chmod +x pthr-tst
# ./pthr-tst 
Set signals
Sigenv works 

For the Operating System with new libptread (i.e., not compatible with 2.5):

# ./pthr-tst
Set signals
Segmentation fault

What to do next in short-term

For Firebird 2.5 vanilla users:
If you have made the test and found that libpthread is not compatible with Firebird 2.5, change the architecture to Classic (make sure to do not confuse the configuration!), and then plan to reinstall your Linux Operating System to the old version with compatible libpthread, which does not have this problem – as soon as possible.

If you have made the test and did not encounter the problem with libpthread, there is no direct danger at the moment. Make this test after each OS update.

Please note that Firebird 2.5 is discontinued version, and Firebird Project will not release fix for vanilla version of 2.5.

For user of commercial versions
Contact your vendor to receive a fix.

What to do next in long-term? Upgrade!

Take this as a final notice that you need to upgrade to Firebird 5.0. The version 2.5 was good and stable, but it originates from 2010, the majority of products released in that year already retired.

There are enough material to perform upgrade in the smooth and easy way, see for details Practical Migration Guide to Firebird 5.
 

Questions?

Please feel free to ask any questions: ak@firebirdsql.org

Original article: https://firebirdsql.org/en/news/urgent-and-import-message-for-users-of-firebird-2-5-on-linux/

Practical Migration Guide To Firebird 5.0

The “Practical Migration Guide to Firebird 5.0,” authored by D. Simonov, is a free technical manual that describes the main steps for upgrading to Firebird 5 from legacy versions such as 2.5, 3.0, and 4.0.

It encapsulates a wealth of pragmatic advice, troubleshooting methodologies, and resolution techniques for common migration challenges. Despite its brevity (40 pages), the guide comprehensively addresses critical aspects of the migration process, including installation protocols, configuration optimization, user account migration, and data type transition strategies.

Read “Practical Migration Guide to Firebird 5.0” or download it in printable PDF format.

From www.firebirdsql.org

Note from the submitter: For those upgrading to Firebird 5, this practical guide can be considered an “add-on” for my (+200 pages) Migration Guide to Firebird 4 eBook, which contains detailed and very important information specially for those moving from FB 3 (or older versions).

The Backend Ring – 2024/Q1 (Adriano Fernandes)

The Backend Ring is a challenge whose main objective is to share knowledge in the form of a challenge! This is the second edition.

Adriano Santos Fernandes, one of the Firebird Core Developers, published an article about his participation in the 2024/Q1 Backend Ring edition, where he submitted solutions using Firebird, PostgreSQLand LMDB. Here is an excerpt from the article translated to English:

“Today, March 10, 2024, is the deadline for project submissions for the Backend Ring – 2024/Q1, which is the second edition of the Backend Ring. In summary, it was necessary to deliver a project that simulates a banking service with a statement and creation of transactions concurrently, where accounts can never go negative below each customer’s limit. In addition, it was necessary to run in docker, with a load balancer distributing the load to at least two API services, and all services together could use a maximum of 1.5 CPU units and 550MB of memory.

I did not participate in the first edition in 2023 because I only found out after it ended.

After this first edition of the Backend Ring, there was a Compilers Ring (and interpreters) where I was able to participate and my project ranked 9th.”

Why now is the best time to become a sponsor of Firebird Foundation?

Pasted from FirebirdSQL:

Firebird is a powerful, open source, relational database that has been serving the needs of thousands of users and developers for over 20 years. Firebird is free to use and distribute, thanks to the generous support of the Firebird Foundation and its sponsors.

But Firebird needs your help to continue its development and innovation. By becoming a sponsor of the Firebird Foundation, you can contribute to the future of Firebird and ensure its quality, security, and performance.

Do you want to have a say in the future of Firebird? As a sponsor of the Firebird Foundation, you can be part of the Technical Task Group and help shape the direction and plans for the next versions of Firebird.

Right now, the Firebird developers are working on the plan for version 6 and beyond, and they would love to hear your ideas and feedback. This is a perfect time to join the discussion and make a difference.

You can become a sponsor of the Firebird Foundation with a Bronze plan, which costs only USD 900 per year. There are also other plans with more benefits and perks.

If you are interested in becoming a sponsor of the Firebird Foundation, please email Alexey Kovyazin, the President of the Firebird Foundation, at ak@firebirdsql.org. He will be happy to answer your questions and guide you through the process.

FirebirdSQL

Firebird 5 estimated release date

For those wondering when Firebird 5 will be officially released: the core developers plan to release one more Release Candidate (RC2) next week, containing several fixes for bugs found after RC1 was publicly released.

The Firebird 5 final version should arrive in the end of December or early January!

Firebird 5.0 beta 1 is out!

Firebird Project announces the first Beta release of Firebird 5.0, the next major version of the Firebird relational database, which is now available for testing.

This Beta release arrives with features and improvements already implemented by the Firebird development team, as well as with many bugfixes. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Beta release.

Going to 2K views

The interview I did with Ann Harrison, the mother of Firebird, is about to reach 2.000 views on Youtube! If you didn’t see it yet, watch it now, hit the “like” button and subscribe to the channel! Ann is married to Jim Starkey, the creator of InterBase. She have shared a lot of her memories from the time IB got open sourced and Firebird was born! A must see! The audio is in English with Portuguese subtitles.

Firebird 3.0.10 was released

Firebird Project is happy to announce general availability of Firebird 3.0.10 — the latest point release in the Firebird 3.0 series.

This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes.
Binary kits for Windows, Linux and Android platforms are immediately available for download, packages for Mac OS will follow shortly.

The Firebird Project
1 2 3 84