Hi!
I have different Firebird instances/databases, one is running on Windows,
another on Linux (the servers have different RAM amount as well). The execution
of the same SQL code results in almost the same indexed reads, non-indexed
reads statistics, but the numbers of read and fetch operations
I managed to find the exact cause (in terms of SQL) of this difference.
I have simple update statement like
update contract set
total=total
where contract_number=5;
When I call this statement 2 times (in the same transaction) on the Windows
server, then the number of reads for the second ca
Of course, I checked the triggers of this table. There are not any dependencies
or futher updates in them. The size of the table is very modest - less several
thousands of records. It is heavily used - both in selects and updates.
The strangest part of the store is this - such unexpected reads a
Hi!
I have Firebird 2.x database which from time to time has rather long
transactions - up to 30 seconds and so, there is high probability that the same
record will be updated from the several different transactions and the lock
conflict - deadlock exeption will be raised. I am currently using
Just some notes.
1) Almost all of A-transactions end with success in my case, so almost always
B-transactions will fail with deadlock message anyway. Therefore the wait mode
has no advantages in my case.
2) There are floating around some stories from my clients that the deadlock
messages can r
I am trying to migrate Firebird 1.5 dialect 1 charset NONE database to Firebird
2.1 dialect 1 charset WIN1257 database, that still will be used by BDE.
All is working. The only problem is that metadata (code of procedures or
triggers) can not contain WIN1257 specific characters (with special
Hi!
We are trying to use Firebird 3.0 for our Delphi programs that use IBX
components (Delphi 2009, Delphi 2010 and Delphi XE). Local connection to the
Firebird 3.0 database is succesfull both from Flamerobin and from IBX. The
problem is connection to the remote server: both - Flamerobin and IB
I am trying select contracts together with the contract lines. around 30.000
contracts and around 800.000 contract lines. And I have two queries that to
essentially the same (each contract has at least one contract_line):
select c.id
c.contract_date,
(select sum(cl.amount)
Hi!
I am trying to execute statement on Firebird 3.0 (64bit, Windows 10) from
IBExpert (2016.5.2.1):
create or alter procedure tests123
(p1 date,
p2 date)
returns (
p_test0 integer,
p_test1 date)
as begin
end
But there is immediate error:
unsuccessful execution caused by system erro
Are the following statements correct?
- Most Firebird client software still is 32bit (Flamerobin, IBExpert, Delphi
2009 and older editions) and therefore it requires 32bit Firebird 3.0 client
dlls (fbclient.dll or gds32.dll) even if it connects to the 64bit edition of
server.
- 64bit Firebird
OK. After Firebird 64 bit installation it was necessary to make Firebird32 bit
client installation and with Firebird 3.0 32bit fbclient.dll/gds32.dll this
statement can be executed normally.
We managed to use Firebird 1.5 and 2.1.7 clients (gds32.dll/fbclient.dll)
smoothly with older Delphi programs, including ones that use BDE. Now Firebird
3.0 client is sometimes giving error message:
General SQL error.
---
Error: 13059,DC: -804
Incorrect values within SQLDA st
I know and I have used Laravel Firebird driver for dialect 3 databases:
jacquestvanzuydam/laravel-firebird
https://github.com/jacquestvanzuydam/laravel-firebird
https://github.com/jacquestvanzuydam/laravel-firebird
jacquestvanzuydam/laravel-firebird
https://github.com/jacquestvanzuydam
I am trying to use Firebird 1.5 database with Yii with Yii-Firebird extension
yii2-firebird | Extension | Yii PHP Framework
http://www.yiiframework.com/extension/yii2-firebird/
http://www.yiiframework.com/extension/yii2-firebird/
yii2-firebird | Extension | Yii PHP Framework
http://www.
Both databases have dialect 1 and that means that case in table names and
quotation is irrelevant. I managed to call generator from 1.5 database but
tables are not accessible still from the Active record infrastrcture:
$list = Yii::$app->db->createCommand('select gen_id(contract_ino, 1) from
I am searching PHP REST framework for Yii but I had problems with Laravel who
required dialect 3 syntax and now I have problems with Yii which have been
described in stack question:
How to retrieve the result of a Firebird INSERT ... RETURNING in Yii
http://stackoverflow.com/questions/39411482/h
I am trying to fetch data from PDOStatement with insert... into... or stored
procedure (without suspend clause) in PHP using PHP data objects (PDO) with
Firebird. And I am getting the error:
SQLSTATE[HY000]: General error: -502 Cursor is not open Is is possible to
execute insert... into... and
But it looks like from the Yii2 code that select and insert...returning is
handled alike in the PHP Data Objects. Can it be possible that Firebird PDO
driver deviates from the official PDO interface. Who develops pdo_firebird.dll
and is it possible to adapt is behavior?
I tried to create new topic in firebird-php but it is getting list, not
visible. :((
SYSDBA users can see other connected users using monitoring tables but is it
possible to implement such feature for non-SYSDBA users? Are there
event/triggers that act uppon connecting and disconnecting and which can insert
usual database records. Triggers no MON$ tables are not suitable because
Hi!
I am reading message Yahoo! Groups
https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876
https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876
Yahoo! Groups
https://beta.groups.yahoo.com/neo/groups/firebird-suppor
I know that it was necessary to execute ALTER PROCEDURE for the parent
procedure if nested procedure was changed with ALTER PROCEDURE - that was in
the previous Firebird versions. Without parent alter there were cases when the
source code (that could be seen in RDB$ tables) of the nested procedu
I am trying to create or modify the following procedure:
create or alter procedure test_procedure(id integer, p_from_date date)
as
declare variable from_date date;
declare variable to_date date;
begin
end
But this SQL restarts server or the connection remains hanging (from IBExpert
or f
Problem happens only on dialect 1 database, dialect 3 database accepts this SQL
as expected.
This is becoming serious, because datbase has several hundreds procedures and
some of them have the same situation (date arguments and variables) and have
the same problem. Problem manifsts only when free statement is issues. Problem
disappers when the procedure is changes from the IBExpert proc
Empty body is not the cause of the error message, because:
- in old times the empty body problem was reported as SQL syntax error and the
server remained alive
- the problem happens with the procedures that already were created in Firebird
1.5 and that have large bodies.
I am sorry, this was false alarm! I used IBExpert and Flamerobin with the
gds32.dll from the previous Firebird versions (not 3.0.x). After updateing
gds32.dll all is working as expected.
Hi!
There is very promising Typescript ORM https://github.com/typeorm/typeorm
https://github.com/typeorm/typeorm As more and more server side development
moves to JavaScript and Typescript, there is need for Firebird ORM for
Typescript. Is there ongoing work on this (maybe as part of other proj
Hi!
IBExpert uses two settings for database charsets:
- Charset (apparently Database related) and
- Font Character Set (apparently Client related)
As I understand then Charset is the same setting as lc_ctype=UNICODE_FSS in
TIBDatabase.Params parameters. But how can I indicate Font Character Set
No, this did no help!
Hi!
Our client has Firebird 3.0 super server installation which has the following
behaviour:
- Client software (e.g. Flamerobin) can establish connection using Firebird 2.x
fbclient.dll
- When client software (e.g. Flamerobin) tries to connect using Firebird 3.x
fbclient.dll then the error mess
Actually, I don't understand this thing about old and new authorization system.
Does it mean that there are two SYSDBA and other user accounts - one for old
and other for new authorization system and does it mean that there are two sets
of passwords?
Is it safe to check 'Enable authorization fo
OK, I have working Firebird 3.0.1 installation and I have copied security3.fdb
from the broken Firebird installation and now I am also receiving the error
message. So - security3.fdb is somehow broken, problem is in security3.fdb
OK - I am starting to understand. Apparently client had Firebird default
instance Windows registry entry from the Firebird installations of the previous
versions. That is why Firebird 3.0 installation wizard did not displayed
extended configuration form with the possibility to initialize securit
isql allowed to change the password of the SYSDBA account but that did not
removed original error message about "installation incomplete"...
Solution found - I had to use the "create user" command with the "using" clause:
SQL> create user SYSDBA password 'masterkey' using plugin Srp;
My firebird.cong indicated that Legacy_Auth is the first (default) user manager
and it was necessary for isql to know that Srp manager had to be used:
Us
Hi!
I am running Firebird 2.1 and I am receiving deadlock error with the
transaction Id. From this Id I can find the attachment with the SQL:
select a.*
from mon$transactions t
left join mon$attachments a on (t.mon$attachment_id=a.mon$attachment_id)
where t.mon$transactionid=2264690
From
Hi!
I am using Firebird 3 and I need to write one execute block statement which
makes several alter table and update table commands, like:
execute statement 'alter table accounts add balance double precision'
execute statement 'update accounts set balance=previous_balance+10'
etc.
The problem i
OK, I guess there is not available better solution than quite risky:
in autonomous transaction do execute statement 'alter table accounts add
balance double precision';
etc.
Hi!
We have observed, that Firebird 3.0.1 freezes on one specific table for some
10-20 minutes during backup. This freezing happens only in the case when
gfix/mend had been performed before backup. Backup runs smoothly when no
gfix/mend had been performed previously. There are no significat
Operating system is Windows
No, we don't use -g.
We are doing immedate restore anyway after each backup. The freeze during
backup time greatly increases time when the system is down and unavailable and
it is becoming unacceptable.
I have experience that such freeze happened once to the database that soon got
corrupted. B
I checked the system again - we use 3.0.2 indeed.
There is no particular reason why we use -mend. We use it routinely between
backup/restore operations to prevent the situation that any corruption errors
my intervene in our operations. My understanding is that mend can not and it
should not cau
For DB upgrade (from 1.5 to 3.0) I need to define custom internal function like
this:
create or alter function F_ABS (
VAR_1 double precision)
returns integer
AS
declare variable result double precision;
begin
result = abs(var_1);
return result;
end
But I am confused. My experiment
Hi!
My question is the result of the investigation of the database that froze
during backup (as reported in
https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/131840
https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/131840).
Backup froze during b
Hello!
I have Firebird 2.1 dialect 1/charset NONE database and I am moving it to
Firebird to get all the performance improvements (64 bit, multi-process
capabilities, etc.). Move to dialect 3/charset UTF8 is quite involved, I am
trying to do this, of course, but as fallback option I would like
Just wanted to know if there is available free (of charge) C++/C compiler for
Firebird 3 UDFs on Windows - 32 bit and 64 bit?
Jonatan
I am trying to restore Firebird 2.1 database on Linux but I am receiving error
message:
Command '/opt/firebird02/bin/gbak –c –v –p 4096 –user SYSDBA –pass masterkey
/backup/BIG_DATABASE /backup/BIG_DATABASE.FDB'
failed with return code 139 and error message -bash: line 56: 11100
Segmentation
I am using Delphi 2009 Unicode and Firebird 3.x UTF8/dialect 3 database with
IBX components. And now I see that all the exceptions raised from the Firebird
SQL procedure and trigger code (e.g. using exception my_exception; statement)
are handled by IBX as special Firebird exceptions:
Attempt to
After initialization code in the project file (this is IB routine
http://docs.embarcadero.com/products/rad_studio/delphiAndcpp2009/HelpUpdate2/EN/html/delphivclwin32/IB_SetIBDataBaseErrorMessages.html):
SetIBDataBaseErrorMessages([ShowSQLCode,ShowIBMessage,ShowSQLMessage]);
I am getting norm
The generic exception about attempt appears when the procedure is called from
the IBX TIBStoredProc, but if stored procedure is called (via select from...)
from the TIBDataSet, then the right error message appears. So - there should be
problem how TIBStoredProc handles the error messages.
Maybe someone knows why Jeff introduced such second call and what bugs this
second call tried to solve?
It appears, that Delphi XE 10.2 code makes the second call only in the specific
case:
if (fetch_res = isc_bad_stmt_handle) then And that makes the erroneous second
call rare enough to solve the problem in my question. So, the solution is to
replace the initial general condition (fetch_res <> is
OK, there are multiple error reports in Flamerobin trackers about this and no
solution in more than 1.5 years. Flamerobin 9.2 works as expected, although it
does not support internal functions, but such feature is not necesary for
script execution. Apparently, Flamerobin is ceasing to exist.
I used to execute GRANT... TO PUBLIC for every new database object I had
created in the past, but for some time (I can not tell exactly - whether
starting from Firebird 2.1 or from Firebird 3.0 only) this has not effect. I
can see in the metadata tables, that PUBLIC has been granted new rights,
Hi!
I am reading
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-access-sql.html
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-access-sql.html
and I have impression that I have to grant alter exception privilege to
certain user only
Hi!
I have client which uses faulty VPN to connect client application (IBX, ZEOS
for Interbase/Firebird) to the Firebird running on Linux. After each 7 or 10
minutes the Firebird connection gets lost. My question is - can I configure the
connection to reduce lost connection?
As I underst
Hi!
Sometimes I need to alter procedures on running Firebird 3.0 database and I
need to disconnect all the users for doing that (there is 'procedure in use'
control exception, there is no similar control for triggers). Sometimes I have
no other option than to restart Firebird Windows service
Especially - what happens to the SQL (especially update) commands that are
running during the restart of the service? I know that service is not waiting
for the completion of those commands. I fear that some interrupted commands can
introduce gds corruption errors, that is my greated concern in
My client occassionally receives "connection rejected by remote interface"
error while trying to connect to the remote server. I know that incompatibility
of versions between gds32.dll/fbclient32.dll and server version can create such
errors, but those are deterministic errors that happens alway
It is superserver.
I tried to skim the source code - tha call stack is:
INET_analyze
INET_connect
send_full(port, packet)
xdr_protocol(&port->port_send, packet) / bool_t xdr_protocol(XDR*
xdrs, PACKET* p)
case op_connect:
{
Hi!
Sometimes I need to deactive all indices (for some special processing whose
intermediate results can invalidate constraints) and then reactive them all
again. Of course, I can do this with DB restore option which does not activate
indices during restore process. But so far I have always
We should move the project to the github and use google groups for discussions.
It is obvious, wondering, why such proposal has not emerged so far already.
Hi!
Sometimes I receive error message (during development and tests, of course):
deadlock
update conflict with concurret update
concurrent transaction number is 2926
Then I can find the other attachment with the long-running transaction using:
select a.mon$user, a.mon$attachment_n
Hi!
I have set of Delphi applications that uses IBX and Zeos for connecting to
Firebird 3.0 server. Some are direct client-server solutions (i.e. Delphi
application uses IBX or Zeos components to open connection on the Firebird
server) and some are 3-tier applications which have Delphi server an
I am trying to reply to Scalability of connection numbers of client-server
solution with Firebird 3.0?
1. I am not receiving messages from the yahoo Firebird group (I don't want that
they are coming in my mail, if I can always read them on the Web and in the the
nice threaded format and with his
66 matches
Mail list logo