Hello all,
Our customer has changed the server from Windows XP to new HP server
Windows 2008 R2 64bit, where he needs to run FB2.1 32bit. The server
is installed with default options.
The problem is, that the performance on new Windows 2008 Server R2 is
significantly lower than on old Windows XP
Hello All,
I have installed new fresh ubuntu server where I installed Firebird
2.1 Classic server, but I am unable to create any database.
Using [isq-fb -user SYSBDA -password masterkey] then [create database
"test.fdb"] I get:
Statement failed, SQLCODE = -902
cannot attach to password database
Hello firebird-support@yahoogroups.com!
This is the end of restore:
...
gbak:activating and creating deferred index FK_ADRESAR_ZAMESTNAVATEL
gbak:activating and creating deferred index FK_SABLONY_MIESTO
gbak:committing metadata
gbak:finishing, closing, and going home
gbak: ERROR:Error
Hello all,
I have tried to restore the database on Ubuntu 11.04 64bit with FB 2.1 Classic
and it was restored fine.
What the hell happens with 32 bit?
TRoland;
<<< 01.09.2011 18:00:00 - Roland Turcan "k...@rotursoft.sk" >>>
Hello firebird-support@yahoogroups.com!
Hi all,
I have been looking into my Firebird.log on my Windows 7 64bit running
64bit Firebird 2.5.2.26536 and I can see very often:
DEVELOP (Client)Mon Oct 29 20:56:59 2012
"C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated
abnormally (4294967295)
What could b
Hello firebird-support@yahoogroups.com!
When I make an backup then server restarts. It happens when it writes
"finishing and going home". Also when I try to restore that backup it
makes during finalization server restart.
SERVER1 (Client)Tue Feb 19 21:52:55 2013
"C:\Program File
restarted.
<<< 19. 2. 2013 22:56 - Roland Turcan "k...@rotursoft.sk" >>>
RT> Hello firebird-support@yahoogroups.com!
RT>
RT> When I make an backup then server restarts. It happens when it writes
RT> "finishing and going home". Also when I try to restore t
Sorry I sent one answer accidentally unfinished.
<<< 20. 2. 2013 8:28 - Alexey Kovyazin "a...@ib-aid.com" >>>
> Hi Roland,
Hi Alexey,
> Terminated abnormally is indication of the server crash, not
> database corruption (though it can be some relation).
> First of all, you need to look at UDFs y
Hello Alexey and others,
I have done today the following:
1. gbak -b -v -m no problem
2. used fbcopy (thanks to M.Babuskov) to copy data to healthy DB
3. gbak -b -v on new database no problem.
Sooo, once again thanks to all of you at least for reading my emails.
Of course especially
4bit where customers are
having SuperServer instance and average database size is 8 GB and all
servers are working with the only database all the day.
Do you have any recommendation what to check?
TRoland;
<<< 21. 2. 2013 23:59 - Roland Turcan "k...@rotursoft.sk" >>>
RT&
Hello all once again,
I have spent quite long time with analyzing firebird.log files on many
different servers I can access today.
All servers I checked are running on Windows 7/2008R2 and they have in
firebird.log very often logged this problem:
"C:\Program Files\Firebird\Firebird_2_5\bin\fbser
Hello all!
I am very confused for few days. I have problems with strange
application hangs which happens when some application tries to read
some rows and second one tries to insert into another table.
I thought that the applications were not using the same transaction
isolation le
Hello firebird-support@yahoogroups.com!
I have two tables:
TABLE_A (ID integer)
TABLE_B (ID integer, TABLE_A_ID integer)
TABLE_B.TABLE_A_ID has foreign key to TABLE_A.ID
TABLE_A contains a row e.g. with ID=5
one transaction updates the row with "update TABLE_A set id=id
where id=5", but do
Hello all,
I have two procedures:
ProcA and ProcB where ProcB calls ProcA. I have made the altering of
ProcA because of bugfix and I haven't touched the ProcB, because it
was OK.
When I was getting the results from ProcB, it still haven't returned
me as I wanted and then I've got the r
Hello guys,
I found some info about problems with performance when FB is running
on Win2008R2 which is domain controller.
But in my case is it not DC, but the performance is the worst I met.
It is new server running 10GB of RAM, RAID, ... it is quite new
server box.
It cannot be, that b
ngle core.
Of course.
TS> --
TS> With regards,
TS> Thomas Steinmaurer
TS> http://www.upscene.com/
TS>
TS> Professional Tools and Services for Firebird
TS> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
TS>
>>
>> <<< 22.01
Hello firebird-support@yahoogroups.com!
CREATE TABLE AAA_TABLE_A
(ID D_INTEGER);
CREATE TABLE AAA_TABLE_B
(ID D_INTEGER, AAA_TABLE_A D_INTEGER, MY_VALUE D_INTEGER, MY_VALUE2 D_INTEGER);
DELETE FROM AAA_TABLE_A;
INSERT INTO AAA_TABLE_A (ID) VALUES (1);
INSERT INTO AAA_TABLE_A (ID) VALUES (2);
INS
Hello firebird-support@yahoogroups.com!
I am trying to deploy Firebird 3.0 to our customers. Only three small
customers are running on FB3, but all of them have the same problem:
invalid transaction handle (expecting explicit transaction start).
This exception happens on different places which
Hello Norbert,
Thanks for your confimation, that I am not alone on this planet having
this problem.
I can't say if customers had it during concurrent access to the same
record, but in my case it was definitely not caused by concurrent
access, because I have got it on my developer test da
<<< 17.06.2016 13:20 - Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
"firebird-support@yahoogroups.com" >>>
DSsicfs> 17.06.2016 13:17, Roland Turcan k...@rotursoft.sk [firebird-support]
wrote:
>> I don't want to post this issue into DEVEL
Hello firebird-support@yahoogroups.com!
I have installed new clean database to new customer having FB3.0.1
32bit running on Windows7Pro 32bit. He was complaining that he is not
able to add new record into some parts of our software. I have
connected to his computer and made backu
< 6.12.2016 9:23 - Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] "firebird-support@yahoogroups.com" >>>
DYdusnfs> 06.12.2016 11:05, Roland Turcan wrote:
>>
>> I have installed new clean database to new customer having FB3.0.1
>> 32bit runn
<<< 21.12.2016 9:34 - Helen Borrie hele...@iinet.net.au [firebird-support]
"firebird-support@yahoogroups.com" >>>
HBhinafs> Hello Roland,
HBhinafs>
HBhinafs> Wednesday, December 21, 2016, 9:11:36 PM, Roland Turcan wrote:
HBhinafs>
>> But
<<< 22.12.2016 7:20 - Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] "firebird-support@yahoogroups.com" >>>
DYdusnfs> 21.12.2016 12:39, Roland Turcan wrote:
>>
>> But still, why this problem occurred? Why didn't some generators
Hello firebird-support@yahoogroups.com!
I am migrating data and changing many and many records in one
transactions. I have not made anything strange just SQL editor and
some SQL commands which forced this database corruption:
DEVELOP Mon Feb 20 16:17:54 2017
Database: C:\EXEK
Hello FireBird Support!
Some customers are having troubles which causes %subject% error
messages.
I think it can be a problem with UDF, but I cannot prove if it is
right.
Firebird.log file shows only lines with 10054 and nothing else.
How can I find out the reason why a use
.com [firebird-support]
"firebird-support@yahoogroups.com" >>>
DSsicfs> 26.04.2017 13:42, Roland Turcan k...@rotursoft.sk [firebird-support]
wrote:
>> Firebird.log file shows only lines with 10054 and nothing else.
DSsicfs>Is it server log or client log?
>> How
"firebird-support@yahoogroups.com" >>>
DSsicfs> 26.04.2017 14:51, Roland Turcan k...@rotursoft.sk [firebird-support]
wrote:
>> What else can I check?
DSsicfs>Network cards, cable, commutators and firewall/antivirus between
this server and
DSsicfs> 192.168.0.22
Hello firebird-support@yahoogroups.com!
I have one customer having this error message very often when he
starts software after he boots up his computer which is as server as
well
"no permission for read-write accesstodatabase
C:\DATA\CUSTOMERS.FDB"
He runs the sof
Hello All,
I have few tables which are used for many years as temporary table,
but that time was not possible to create them in Firebird.
Do you know any "hack" over system tables which would allow to change
normal table to global temporary and it will not cause some problems?
It would be
Hello guys,
How can I rebuild all my SP or triggers after altering of one which
has many depended callings.
How can I assure that my altered SP will be used in all objects
depending on it instead of old BLR of it.
Should I call "alter procedure" and "alter trigger" on all SP or TR.
If y
Hello firebird-support@yahoogroups.com!
I am migrating my UDF from windows to linux, but all functions using
string as output when they are used crashes the server.
I suppose it must be related to libib_util.so and its function
ib_util_malloc.
My declaration is the following:
{$IFDEF W
Hello All,
How to build up SQL query over system tables to find out which tables
are depending to exact table and column I am searching for.
Thanks in advance.
--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk
42 matches
Mail list logo