Hi everyone, I have got a problem with a corrupted Firebird 1.5 database which is about 2 GB in size. The database server ran out of disk space and due to...
101258
Christian Gütter
christian.gu...
Apr 1, 2009 4:19 pm
Hi everyone, I have got a problem with a corrupted Firebird 1.5 database which is about 2 GB in size. The database server ran out of disk space and due to...
101259
Dimitry Sibiryakov
aafemt
Apr 1, 2009 4:59 pm
... Gfix is unable to fix databases corrupted this way. Either restore database from backup or call database repair service. SY, SD....
101260
Gustavo
gstv_m
Apr 1, 2009 7:45 pm
Hello: I have an application in Delphi which uses FireBird 2.0.1 Superserver. It is installed in an enterprise which has 8 users in a local network and 5 users...
101261
Walter Neumann
walter@...
Apr 1, 2009 7:51 pm
Hello, I use FB 1.5 on a Linux Server (was tested on Windows Server too). In a stored procedure I have this statement: STDNEU = STDNEU + STUND2 + FREQUSTDNEU2;...
101262
SoftTech
st_wizard
Apr 1, 2009 8:27 pm
Greetings All, I was just wondering if anyone else has found a way to find any record in any and all tables in a Firebird database that should not be null, but...
101263
colincoleman2002
colincoleman...
Apr 1, 2009 8:48 pm
Hi , I thought I new this but im am stummped, I have a Domain that we have defined as Decimal(6,2) We have launched our project and started importing data...
101264
Ann W. Harrison
annwharrison
Apr 1, 2009 9:47 pm
... The 6 in decimal(6,2) is the precision. It includes the decimal digits. So the legal range is not -999,999.99 to +999,999.99 but -999,999 to +999,999 and...
101265
Helen Borrie
helebor
Apr 1, 2009 10:01 pm
... This is stored as SMALLINT with scale of 2. ... Sure, you increased the theoretical limit by the power of 4! ... Meaning DECIMAL(6,2) could store <=...
101266
Doug Chamberlin
dougchamberlin
Apr 1, 2009 10:19 pm
... 1. Change the field back to allow nulls. 2. Get rid of the nulls. 3. Change the field again to not allow nulls....
101267
Ann W. Harrison
annwharrison
Apr 1, 2009 10:33 pm
... left out the word 'times' in the description value = <stored value> * 10^(<scale factor> * -1>) 123.45 = 12345 * 10^-2 Ann...
101268
Christian Gütter
christian.gu...
Apr 1, 2009 10:36 pm
Hi Dimitry, ... would it be possible to repair the database with 3rd party tools like IB FirstAID? Regards, Christian...
101269
colincoleman2002
colincoleman...
Apr 1, 2009 11:25 pm
Thanks for the help both of you...... I now see where I went wrong, What is the difference between DECIMAL and NUMERIC ....? Cheers Colin...
101270
SoftTech
st_wizard
Apr 2, 2009 3:06 am
Doug, I was trying to find which of 400+ tables might contain this issue without having to manually go thru each table and do what you suggest on every field...
101271
SoftTech
st_wizard
Apr 2, 2009 3:15 am
Greetings All, I use Database Workbench for development of my database. Upon doing a validation on my database using GFix thur Database Workbench it return...
101272
SoftTech
st_wizard
Apr 2, 2009 3:51 am
Just in case it is needed here is the Database Statistics: Anyone see any issues with these settings under Firebird 1.5 Classic? Database header page...
101273
Nigel Weeks
nweeks@...
Apr 2, 2009 4:09 am
Here's one I whipped up in PHP ... #!/usr/local/bin/php <?php $conn = ibase_connect("localhost:/raid/db/passport.fdb","sysdba","masterkey"); // Obtain a list...
101274
SoftTech
st_wizard
Apr 2, 2009 4:18 am
Greetings Nigel, I do not have access to PHP. Is there anyway to handle this in Database Workbench? Thanks, Mike ... From: Nigel Weeks To:...
101275
Nigel Weeks
nweeks@...
Apr 2, 2009 4:25 am
Hmm, not without extending it's operation via some scripting, which won't be easy. If your database was accessible from the outside world, it could be scanned ...
101276
Maya Opperman
maya_mcleod
Apr 2, 2009 5:08 am
... Space ... Ouch! Is there any easy way of querying the Firebird Server for free disk space on the server when logging on from a client PC? That way we can...
101277
Martijn Tonies
martijntonie...
Apr 2, 2009 6:08 am
... Database Workbench will issue a warning if you try to "not null" a nullable existing field. It allows you to enter a value that will be applied before ...
101278
Gabor Boros
gaborboros
Apr 2, 2009 6:41 am
Hi, The released and the RC2 (Win32) kits contains same binaries. This is correct? Gabor...
101279
Helen Borrie
helebor
Apr 2, 2009 6:58 am
... Sorry, but this must be something you provide for. The database engine has no way of knowing how much disk space there is, nor how much is needed, nor...
101280
John vd Waeter
pa3erp
Apr 2, 2009 7:15 am
(message didn't show up on list, sent it again) Frank, Could it be 192.168.1.100 is not available at clientside? Or, could it be you have set and left active a...
101281
Svein Erling Tysvær
svein_erling
Apr 2, 2009 7:32 am
I may well be wrong, and have no possibility to try it now, but have you tried SELECT * FROM <MyTable> WHERE <MyNotNullableField> +0 is null Replace +0 with...
101282
Vlad Khorsun
fbvlad
Apr 2, 2009 7:34 am
... Just rebuild corresponding indices. Be ready that some of corrupted indices will not be activated - if they are unique and data have duplicates. In later...
101283
Vlad Khorsun
fbvlad
Apr 2, 2009 7:35 am
... This issue is gone if you use FB 2.1 and ODS 11.1 Regards, Vlad...
101284
Pavel Cisar
pcisar2000
Apr 2, 2009 8:06 am
... Yes, this is correct. According to QA procedure, we sign off *binaries*. Making new binaries even from the same sources would require another QA round....
101285
Dimitry Sibiryakov
aafemt
Apr 2, 2009 8:56 am
... I'm not sure, but probably - no. I heard from Dmitry Kouzmenko that repair of such databases is a handwork. SY, SD....
101286
Dimitry Sibiryakov
aafemt
Apr 2, 2009 9:00 am
... Too much cache, IMHO. It can slowdown performance and run out of RAM if number of connection is big. SY, SD....
