EDIT Sep 21st: Sinática Monitor 2.1.03 solves the issue. You may download it now. The original bug in Firebird 2.1.3 is already fixed in CVS too.
If you’ve followed my advice and upgraded to Firebird 2.1.3 only to find you’re now getting consistent “invalid BLOB ID” messages, please update Sinática Monitor to the latest version.
There is a very specific condition that triggers this error message and it’s highly likely you won’t be affected. If you are being affected, however, please check your environment:
- In my testing the bug only occurs when there are clients attached using charset NONE. If you change them to use a proper charset such as ASCII, ISO8859_1 or UTF8 the error message will be gone. Any charset different from NONE will do. Also make sure Sinática Monitor is not using NONE charset.
- If you run into this error and it’s not related to charset NONE, please contact me. Every additional information will be helpful.
A new version of Sinática Monitor is available to fix the issue.
Comments (1)
Yesterday Firebird 2.1.3 was made public. As with all maintenance releases its focus is stability. A number of bugs are fixed and it is a recommended update for everyone using older versions of the 2.1 series.
Default authentication method changed
The Release Notes is quick to warn about a change that may break current setups: The default authentication method changed from mixed to native. In practice this means that before 2.1.3 you could use both firebird’s native authentication and windows authentication out of the box.
From now on you have to explicitly tell Firebird that you wish to use windows authentication. Simply change the firebird.conf configuration file to:
Authentication = mixed
Lighter nBackup
Prior to 2.1.3 nBackup could exhaust server I/O resources and negatively affect database operation. Starting from Firebird 2.1.3 nBackup is lighter and can be used even when the database is heavily loaded.
Monitoring Fixes
Some fixes are specially important for Sinática Monitor users and anyone that uses monitoring tables frequently.
- Error “cannot transliterate” would happen when trying to read monitoring tables containing data from an attachment using character set NONE.
- Possible “clumplet errors” while using monitoring tables in Classic Server Linux.
- Data instability on monitoring tables while clients were connecting or disconnecting.
Other fixes
The list of bugs fixed is long and it’s easy to see that quality is the Firebird Team’s first objective. Kudos to everyone involved in this release and keep your fingers crossed for Firebird 2.5!
Comments (4)
This week I received the Brazilian Active Delphi magazine with a pleasant surprise. My very first published article.
The title is Identifying performance problems with Firebird and I write about the need to evaluate performance issues before getting down to business with application and infrastructure changes.
Big thanks to Kelver Merlotti for the invitation and to all the magazine team for the opportunity.
Comments (1)
A fresh new Sinática Monitor 2.1 for Firebird is available for download.
This release supports monitoring Firebird 2.5 databases and adds new alarms and the option to choose the layout for the Charts Page.
Find out more about what’s new or check out the release notes for a complete list of changes.
Download Sinática Monitor 2.1 right now!
Comments (3)
The sixth edition of the Brazilian Firebird Developers Day will be held in Piracicaba at the next 4th of July.
And there’s news this year: The Madness Session will let the audience ask any questions directly to the speakers. I liked this idea. Everyone knows there will be time to ask their questions.
Another good news is the presence of Vlad Khorsun, one of Firebird’s current main developers. He will present two sessions. One on CTE (Common Table Expressions) and another on What’s new in Firebird 2.5.
There are two presentations by Dmitri Kouzmenko that you just can’t miss. On one of them, entitled “Database maintenance“, he promises to show different tool to monitor the database. Is he going to mention Sinática Monitor? I have no idea.
There are two other presentations from the Brazilian folks that caught my attention: “Database Structure and Organization for websites” by Maurício Longo and “Optimizing Firebird 2.1 queries using Execute Block and nested selects” by Eduardo Jedliczka.
This event is great and I do recommend. I was there last year and certainly I will be there this year. See you!
Comments (1)
It’s now official: Sinática Monitor 2.0 for Firebird is online.
You may download it right now and read about what’s new in the 2.0 series.
Comments (1)
The last couple of months were intense. On one hand I wanted to fulfill the feature requests I receive, on the other hand I didn’t want to go dark for too long without a new release.
The most frequent features requests were:
- Include filters
- Review the History system
- Include statement execution time
- Reduce memory consumption
Differently from what I did in the past this time I chose a larger schedule to create a new version that would address all these requirements at once.
Thus Sinática Monitor 2.0 for Firebird SQL is born.
You may download a Beta and read about what’s new.
Don’t keep from sending me your impressions. They determine the next set of features!
Comments (1)
The Firebird Development Team released Firebird 2.1.2 this week. This sub-release focus on stability. There are no big changes, they’re all in store for Firebird 2.5, but it is important nonetheless. The list of bugs fixed is impressive.
Bugs
Among several fixes, some deserve to be highlighted:
The last two bug-fixes directly affect Sinática Monitor users. This update is highly recommended.
Improvements
Besides the fixed bugs, a few improvements were included.
- DPB user restriction. If you connect to Firebird Server using a non-sysdba user and some special attachment parameter, check to see if it is in the restricted parameters list. It is also possible that your connectivity layer may be adding special parameter to your DPB. In these cases Firebird will reject the attachments.
- Possible to use MS C Runtime in a private folder. In the old days (2.0 and before), all you had to do to install a client was copy fbclient.dll to you application folder or the system folder. Runtime installation then became necessary starting from Firebird 2.1. This lead to client distribution problems as client installation became more complex. Firebird 2.1.2 allows you to once again deploy a client simply by copying fbclient.dll (or gds32.dll) and the appropriate runtime files.
To know more, visit the release notes.
Download Firebird 2.1.2 now!
Comments (2)
Release 1.2.03 is recommended to everyone using Sinática Monitor 1.2.
This version contains important fixes to problems found in the last couple of days.
Thanks to everyone who reported errors.
View the release notes or download now.
Comments (0)
Sinática Monitor release 1.2 is online now.
The most significant change in this version is the new main interface.
Containing the most important counters and a clear indication of pending alarms, the new user interface is a great quick overview of your databases’ health.
Another new feature is the Sweep Alarm. It warns you if your databases’ sweep configuration is not ideal.
You may view every improvement and fixes in the release notes.
Download Sinática Monitor 1.2 now!
Comments (0)
