RE: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Release Notes

"New ODS Number
Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12. 
In the initial release, a database
with an older ODS cannot be opened by Firebird 3.0. In order to work with a 
database with an older ODS it will
be necessary to make a backup using gbak  under the older server and restore it 
with gbak on Firebird 3.
Note
A legacy provider for databases with ODS 8 to 11.2 is planned for a future 
sub-release"

Paul
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 25 June 2020 16:46
To: Firebird Support
Subject: [firebird-support] error when trying to open databases 2.5 on server 
3.0.5



Is it possible to open database 2.5.9 on servers 3.0.5?

when I try to open it with flamerobin it gives me the following error:
Context:Database::Connect
Message:isc_attach_database failed

SQL Message:-820
wrong or obsolete version

Engine Code :335544379
Engine Message:
unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, support 
12.2
IProvider::attachDatabase failed when loading mapping cache

Is it possible to create databases on a 3.0.5 server with a user other than 
sysdba?

when i try in flamerobin create a database with another user it gives me the 
following error:
Context:Database::Create
Message:isc_dsql_execute_immediate failed

SQL Message:-551
This user not have privilege to perform this operation on this object

Engine Code :335544352
no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

RE: [firebird-support] How to inspect nbak state of a Firebird database

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge.

Regards
Paul

-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 22 April 2020 09:56
To: Firebird Forum
Subject: [firebird-support] How to inspect nbak state of a Firebird database


  
Is there a way in C# to inspect the nbak state of a Firebird database?

The state in the database header would be set to |nbak_state_diff| or 
|nbak_state_normal|. But how do I actually read this value?

https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database

Regards,
Kjell

[Non-text portions of this message have been removed]

RE: [firebird-support] with wrong sql i get no exception or firebird error

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

< INSERT INTO LOG(WAS) VALUES ('blabla');
causes the error:
  Statement failed, SQLSTATE = 23000
  validation error for column "LOG"."ID", value "*** null ***"

if postet with the c++ code:
IBPP::Transaction _tr = IBPP::TransactionFactory(db);
IBPP::Statement st = IBPP::StatementFactory(db, _tr);
_tr->Start();
st->Prepare("INSERT INTO LOG(WAS) VALUES (?)");
st->Set(1, "blabla");
st->Execute();
_tr->Commit();

i get no error...nothing! No Record is created.
In other error cases i get an ibpp message with try catch IBPP::Exception& e  
somethin like.

*** IBPP::LogicException ***
Context: Statement::Set[char*]
Message: The statement does not take parameters.

but never the real firebird error.

How can get this errors?>>

Probably by using 
Class::SQLException

http://www.ibpp.org/reference/exceptions

Paul

RE: [firebird-support] Basic Re-Start

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> 30.09.2019 14:27, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> > What the the link for downloading Embedded Firebird?
> 
>None. Read Firebird 3 Release Notes.

Or read this...
https://www.ibphoenix.com/files/Embedded_fb3.pdf

Regards
Paul






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Firebird upgrade advise

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

This will help.

https://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

Regards
Paul

RE: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

Yes, by default we build and install as a Framework on MacOS, which means
as part of the build process we finesse the locations of all the relevant 
libraries and
executables etc using the install_name_tool. If you look at the source code 
specifically 
posix/postfix.darwin, and you will need to do the same for all the 
libs/executables
you wish to use...

There was a script to do this in Firebird 2.x
See posix/builds/install/arch-specific/darwin/embed.darwin

Paul

RE: [firebird-support] Compling from source.

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

< ./configure --prefix=/home/pol/Downloads/sw/db/fb/inst 
> --with-builtin-libtommath
then
> make
Same failure as before (at bottom).
I totally get your point about it being to do with libtommath, that much is 
obvious from the error messages.
However, I have tried the solution proposed - i.e. using ./configure with the 
--wtih-builtin-libtommath flag.
Now, I need further assistance. This is failing. I am compiling on Fedora 29 
with Development Tools installed.
Where do I need to place, or what do I need to do, with the tommath 
code/library in order for  a simple compile to work?
Any assistance much appreciated. >>

Look very carefully at the error you are getting and you will notice that 
although
you are specifying --with-builtin-libtommath
its actually picking up the non fPIC lib in /usr/local/lib 

---> /usr/bin/ld: //usr/local/lib/libtommath.a
This is being picked up before the builtin one within extern
probably because of your library search paths

The correct library would be extern/libtommath/.libs for libtommath.so not 
libtommath.a
See gen/make.defaults

Paul




== Fails =



/usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation 
R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a 
shared object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod.o): relocation 
R_X86_64_32 against symbol `mp_reduce' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod_fast.o): relocation 
R_X86_64_32 against symbol `mp_reduce_2k' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: final link failed: nonrepresentable section on output
collect2: error: ld returned 1 exit status
make[3]: *** [Makefile:305: 
/home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4] 
Error 1
make[3]: Leaving directory '/home/p ol/Downloads/sw/db/fb/gen'
make[2]: *** [Makefile:180: master_process] Error 2
make[2]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make[1]: *** [Makefile:66: firebird] Error 2
make[1]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make: *** [Makefile:6: firebird] Error 2

RE: [firebird-support] Compling from source.

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> at a guess it looks like the libtommath you installed wasn't build with =fPIC
> a must if you want to include its symbols in another shared library (Firebird)

> Perhaps it would be easier if you used the configure command 
> --with-builtin-libtommath?

<>

if you do a ./configure --help 
you will see that --with-builtin-libtommath "build libtommath library from the 
firebird tree"
This means the libtommath library should be built "within" firebird...
If you look in extern within your firebird code there should be a libtommath 
directory.
That code is used to build the libtommath library which will be linked into the 
firebird
shared library during compilation.

I know this works because there is no installed libtommath library on MacOS and 
I have to build
fireird this way so that firebird is dependent on some randomly installed 3rd 
party libtommath
library.

regards
Paul

RE: [firebird-support] Compling from source.

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<<(phew...), but that's where the fun begins - I hit an error!


/usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation 
R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a 
shared object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod.o): relocation 
R_X86_64_32 against symbol `mp_reduce' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod_fast.o): relocation 
R_X86_64_32 against symbol `mp_reduce_2k' can not be used when making a shared 
object; recompile with -fPIC
/usr/bin/ld: final link failed: nonrepresentable section on output
collect2: error: ld returned 1 exit status
make[3]: *** [Makefile:305: 
/home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4] 
Error 1
make[3]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make[2]: *** [Makefile:180: master_process] Error 2
make[2]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make[1]: *** [Makefile:66: firebird] Error 2
make[1]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen'
make: *** [Makefile:6: firebird] Error 2
[pol@UNKNOWN fb]$>>

at a guess it looks like the libtommath you installed wasn't build with =fPIC 
a must if you want to include its symbols in another shared library (Firebird)

Perhaps it would be easier if you used the configure command 
--with-builtin-libtommath?

Regards
Paul

RE: [firebird-support] Transactions

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Kevin,

You might want to read this...
https://www.ibphoenix.com/resources/documents/search/doc_67

Regards
Paul


-Original Message-
From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com]
Sent: 03 April 2019 06:37
To: Firebird Support
Subject: [firebird-support] Transactions


  
Greetings,

I’m sure this has been asked before - is there a knowledge base somewhere?

I’m trying to get a handle on transactions from gstat and I just want to make 
sure I’m reading this correctly. One of my installs is having some issues, 
Firebird 1.56, Classic Server. I have been reading Helen’s book, Chapter 25 - 
Overview of Transactions.

My app (a large one) is written in Delphi, using Devart’s IBDAC components.

Also, my end users tend to End Task on my app if a report doesn’t pop up 
immediately. I’ve tried to educate them. So with Classic (or Superserver I’m 
guessing) when the user kills a client app, I’m assuming it leaves not only a 
connection to the database active (as seen in Task Manager on the server) but 
also potentially one or more transactions active.

It appears from the book that I should be concerned with the gap between the 
OIT and the OAT and making sure they both move ahead. So from the gstat figures 
below, my app needs a bunch of improvements in transaction handling which I’m 
diving into as we speak.

4/1/2019 - before backup / restore
Oldest transaction 1388 (OIT)
Oldest active 812976 (OAT)
Oldest snapshot 811580
Next transaction 905141
Note: Performance was horrible on this day and usually is the first day of the 
month.

4/1/2109 - after backup / restore:
Oldest transaction 1294
Oldest active 1295
Oldest snapshot 1295
Next transaction 1298
Note: This looks perfect to me.

4/2/2019 - around mid-day:
Oldest transaction 1297
Oldest active 1298
Oldest snapshot 1295
Next transaction 56071
Note: Not good. OIT and OAT not moving forward.

4/2/2019 - around end of day:
Oldest transaction 1297
Oldest active 1298
Oldest snapshot 1295
Next transaction 91583
Note: Even worse. OIT and OAT not moving forward.

4/2/2019 - after backup and sweep:
Oldest transaction 1626
Oldest active 91623
Oldest snapshot 91623
Next transaction 91631
Question: I would’ve thought performing a sweep would’ve not only done garbage 
collection but also dealt with rolled-back transactions and remove “stumps” of 
deleted records (from the book) increasing the OIT.

4/2/2019 - after a 2nd sweep:
Oldest transaction 91631
Oldest active 91623
Oldest snapshot 91623
Next transaction 91632
Note: Now this is interesting. This looks pretty perfect to me. 
Questions: Why didn’t the first sweep give me this kind of result? And should I 
schedule two sweeps every night? 

Thanks in advance for any help here!

Best Regards,
Kevin

Some more background:

Batch file that does backup / sweep every night:

del "e:\fb databases\lumber\lumber_bu.log"
gbak -b -user SYSDBA -password masterkey "127.0.0.1:e:\fb 
databases\lumber\lumber.fdb" "e:\fb databases\lumber\lumber.fbk" -v -y "e:\fb 
databases\lumber\lumber_bu.log"
gfix -sweep -user sysdba -password masterkey "127.0.0.1:e:\fb 
databases\lumber\lumber.fdb"

Sweep batch file I run interactively:
e:
cd "e:\program files (x86)\firebird15\bin\"
gfix -sweep -user sysdba -password masterkey "127.0.0.1:e:\fb 
databases\lumber\lumber.fdb"
pause

[Non-text portions of this message have been removed]

RE: [firebird-support] Re: installing fb 1.5 in Mac Mojave

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> yes, I follow the one in the blog and run the postinstall script under root 
> account

Then it should work OK... I am not aware of any major changes re. dscl, 
launchctl etc
that should stop it from working.

Paul

RE: [firebird-support] Re: installing fb 1.5 in Mac Mojave

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Did you actually use the original install script as instructed on the blog,
or did you just try and use launchctl?

Regards
Paul

RE: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

Regards
Paul

RE: [firebird-support] Apparently timeout on queries

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> I would like to know if the Firebird have any kind of timeout on query 
> execution.

Firebird 4.0

http://tracker.firebirdsql.org/browse/CORE-985

Paul

RE: [firebird-support] Re: WireCrypt and win_sspi

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Daniel,

>><>is only possible for >>ServerAuth=SRP. Is this correnct? Or is there any kind 
>>of configuration to use WireCrypt with >>ServerAuth=win_sspi?>>

>More info here: https://www.ibphoenix.com/files/Authentication_FB3.pdf

<>

Yes, my reading of 

"Wirecrypt, which sets encryption across the wire. In the default installation 
it is set
as Required on the server side and Enabled on the V.3 client side. If you expect
applications to connect using the V.2 client, or the V.3 client with win_sspi, 
then it
should be downgraded to Enabled in the conf file on the server. The default on 
the
client side is Enabled, which is OK, so there is no need to reconfigure it 
there."

Also suggests that your conclusion is correct. 

Thats why I suggested reading the document. At the moment its the gospel on 
authentication in Firebird 3, cross checking on this to make sure I get..

a definitive WireCrypt with win_sspi-Authentification is not possible
Where Required = yes, enabled = no, and disabled = no
and if you do use win_sspi required will mean a failed connection

Regards
Paul

RE: [firebird-support] WireCrypt and win_sspi

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

More info here: https://www.ibphoenix.com/files/Authentication_FB3.pdf

Paul

RE: [firebird-support] INET/inet_error: read errno = 10054

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> Does anybody know what causes this message in firebird.log?

INET/inet_error: read errno = 10054

Winsock.h

WSAECONNRESET 10054 Connection reset by peer.

An existing connection was forcibly closed by the remote host. This normally 
results if the peer application on the remote host is
suddenly stopped, the host is rebooted, the host or remote network interface is 
disabled, or the remote host uses a hard close (see
setsockopt for more information on the SO_LINGER option on the remote socket).

This error may also result if a connection was broken due to keep-alive 
activity detecting a failure while one or more operations
are in progress. Operations that were in progress fail with WSAENETRESET. 
Subsequent operations fail with WSAECONNRESET.

This happens if a sockets client is actively sending or receiving data to or 
from a Firebird Server, and the network connection is
lost. If a client crashes or a network error occurs (for example, an 
intermediate router goes down), the server has no way of
knowing this, unless it tries to use send(). In this case send fails with the 
WSAECONNRESET error.

How does an application know that the remote end has terminated the connection? 
The answer depends on whether the remote end
terminated the connection gracefully or abortively. If the termination was 
abortive, then send() and recv() calls will fail with the
error WSAECONNRESET.
So, in simpler terms the socket that is the end point of the other connection 
has gone. Either the Firebird server has crashed, or
the application using the Firebird client has disconnected abnormally (the 
application may also have crashed). You need to make a
new connection, as the existing connection(s) can no longer be used. If these 
are infrequent, there is probably nothing to worry
about, a client may have rebooted their system, or has been turned off without 
disconnecting from the database server. However if
they are frequent, then you need to look at what may be causing the 
disconnections, either in the application or on the network.

Regards
Paul

RE: [firebird-support] Create sysdba user

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> I there an easy way to create another user with same privileges and can 
> access all tables as SYSDBA?

https://firebirdsql.org/rlsnotesh/rnfb25-admin.html

Paul

RE: [firebird-support] backup on amd64 restore on raspberry pi 3

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Et al,

> on https://www.ibphoenix.com/resources/documents/general/doc_323
> "Rows are restricted to 32767 bytes."

That doc has now been updated to reflect all versions of Firebird upto Firebird 
3.

Regards
Paul

RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> < command followed by the path and filename, hitting Enter and then typing in 
> my username and password (the only user is sysdba and I did change the 
> password) I get the following error message:
> Statement failed, SQLSTATE = 08006
> Can not access lock files directory /tmp/firebird/>>
> 
> [...]

It all depends on the path you provide in CREATE DATABASE. If it is just 
a local filesystem path, e.g. CREATE DATABASE "/somefolder/dbname.fdb", 
then the FB instance handling your request is running with your current 
user account (somewhat like embedded FB).
So, try what the rest of the error message suggests and do:
CREATE DATABASE "localhost:/somefolder/dbname.fdb" USER "SYSDBA" 
PASSWORD "yourpassword";
This way you access the FB server via the network stack and the request 
gets handled by the FB inet server, running with "firebird" account 
priviledges.

What I said, but better. Make sure somefolder has the privileges to allow
another user (firebird) to write to it and access it.

Regards
Paul

RE: [firebird-support] Re: Cannot create new database: "Can not access lock files directory /tmp/firebird/"

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

>

Or ifyou are seriously interested in Firebird 
http://www.ibphoenix.com/products/books/firebird_book

Paul

RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

You can add your user to the firebird group (without using an 
ip address or local host you are effectively using firebird in local mode).
Addin your user to the firebird group means that you can access the tmp files
created when firebird starts up.

Or you can rm /tmp/firebird and then access firebird locally via your user
all the time. The new tmp files will be owned by you. Access remotely will be
a problem though.

Or use an ip address or localhost to create the database.

Paul

RE: [firebird-support] Re: Mailing list change?

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> In principal I like your idea of a Firebird powered archive of Firebird 
> related emails.

http://www.ibphoenix.com/products/dvd/developer_dvd
"A browsable, search application for Windows and Linux for the whole of the 
Firebird Support and Developer Lists to date"

Regards
Paul

RE: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<< it may be worth considering and adjunct piece of software to Firebird, 
called "HqBird", which uses Firebird as its base database engine.  "HqBird" was 
designed for Firebird databases that are by necessity very large and require 
more power and capabilities than the standard version may offer.  A similar 
situation has arisen with the equally powerful PostgreSQL database engine where 
when extensive power is required, the EnterpriseDB database engine has been 
developed using PostgreSQL as a base.  EnterpriseDB can now provide Oracle-like 
capabilities at a fraction of the cost>>

Nice analogy, but not entirely accurate...

Paul

RE: [firebird-support] running Firebird without fbintl

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

>With GCC "-fvisibility=internal" can be used to suppress exporting of all 
> symbols.

We currently use -fvisibility-inlines-hidden and -fvisibility=hidden for 
clang...

Paul




> ++
> 
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
> 
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/ 
> 
> ++
> 
> 
> Yahoo Groups Links
> 
> 
> 
> 






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] running Firebird without fbintl

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

2.5.8 64bit Firebird now compiles with -O0 because of a problem with 
optimisation in fbintl that caused
Firebird to crash...

Paul

RE: [firebird-support] running Firebird without fbintl

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

And a couple of final questions, what optimisation level are you using during 
the build?
32bit or 64bit Firebird?

Paul

-Original Message-
From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com]
Sent: 05 July 2018 14:47
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] running Firebird without fbintl


  

<>

MacOS does not use a full icu implementation, so I doubt you are linking
against the system icu lib (/usr/lib/libicucore.dylib) unless of course
you are specifically requesting it. 

To be honest I doubt you could build Firebird if you hadn't installed 
a proper copy of icu from elsewhere.

Personally I expect the problem is elsewhere... 
Does it crash on 10.13 or on earlier versions of the OS?
Have you analysed a crash dump?
What happens if you use isql on your embedded version of Firebird?
What version of Firebird are you using?

Paul 

RE: [firebird-support] running Firebird without fbintl

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

MacOS does not use a full icu implementation, so I doubt you are linking
against the system icu lib (/usr/lib/libicucore.dylib) unless of course
you are specifically requesting it. 

To be honest I doubt you could build Firebird if you hadn't installed 
a proper copy of icu from elsewhere.

Personally I expect the problem is elsewhere... 
Does it crash on 10.13 or on earlier versions of the OS?
Have you analysed a crash dump?
What happens if you use isql on your embedded version of Firebird?
What version of Firebird are you using?

Paul 

RE: [firebird-support] GET LINGER?

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Mark,

> You can use select rdb$linger from rdb$database

Neat, I didn't know about that. Thanks.

Paul

RE: [firebird-support] GET LINGER?

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

AFAIK, you cannot "view" this setting however you can set it and adjust it 
using the following commands...
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-enhance-linger

Paul

RE: [firebird-support] NVME drive optimize for firebird engine

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

1. I don't understand how RAID 0 gives you redundancy...
"RAID 0 (also known as a stripe set or striped volume) splits ("stripes") data 
evenly across two or more disks, without parity information, redundancy, or 
fault tolerance. Since RAID 0 provides no fault tolerance or redundancy, the 
failure of one drive will cause the entire array to fail; as a result of having 
data striped across all disks, the failure will result in total data loss"

If you only have 2 disks surely RAID 1 will give you the redundancy you are 
looking for?

Consider the following...

You could buy a couple more disks and Use RAID 10
If you are using RAID1 or RAID5, consider RAID10 – it is 15-25% faster.
Check the BBU. If you are using a RAID controller, check that it has Backup 
Battery Unit (BBU) is 
installed and operational – some vendors do not provide BBU by default. Without 
BBU, 
the controller disables the cache, and RAID can be slow, even slower than usual 
SATA drives. 
Usually, you can check BBU status in the RAID configuration tool.
Set the write cache to write-back
If you are using RAID controller with installed BBU (and server with UPS), 
check that its cache is 
set to write-back (not write-through). «Write-back» enables write cache of the 
controller.
If you use a RAID controller, check that it has enabled the read cache. 

Paul

RE: [firebird-support] Firebird log, error

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

What might be causing this, any ideas?
Server: Firebird 64bit classic on Ubuntu Linux (2.5.4.26856)
Client: Windows 10

After this error, the connection drops & client app hangs. 

Mar 24 15:05:58 kernel: [2481720.238260] fb_inet_server[10098]: segfault at 0 
ip 7f5cba31bb05 sp 7f5cb86d4b90 error 4 in 
libfbembed.so.2.5.6[7f5cba1bf000+4cd000]>>

#define EINTR4  /* Interrupted system call */
You need to capture a coredump on the server and analyse it.
https://www.ibphoenix.com/resources/documents/search/doc_36

regards
Paul

RE: [firebird-support] Does gstat "max version">1000 indicates about problems?

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

>

Two issues... 
1. Max versions = older versions of a record that will be tidied up by garbage 
collection at an
appropriate time, either by sweep (gfix -s), coperative garbage collection or 
by gbak when a
backup takes place.
Consider using the -g switch during backup to inhibit garbage collection and 
instead run sweeps 
regularly.

2. Errors in the firebird log = probable corruptions to the database...
Please read this.
http://www.ibphoenix.com/resources/documents/search/doc_5

Paul

RE: [firebird-support] Restore firebird 1.5 backup into firebird 2.5.8 database with GBAK Fails

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

Hmm, 2.5.8 was compiled on 10.13 with a macosx-version-min of 10.9 using clang 
17.3
However it looks like you have run into this particular issue...

it look s you need to update your OS to at least MacOS Sierra 10.12
As the function clock_gettime was not provided in earlier versions of OSX (El 
Capitain for example),

It looks like Apple have introduced the clock_gettime posix API in MacOSX 10.12
The configure script used to build firebird is detecting this and enable usage 
of it. 
Since you are running on 10.10, this functionality doesn't exist, so the 
linking at runtime fails. 

Depending on how critical this is, it might be possible to create a build of 
Fireird that 
defaults to the previous behaviour (pre 10.12) where configure does not detect 
the function 
_clock_gettime and uses firebirds own methods.


Paul

RE: [firebird-support] "Over the wire" Connection Encryption: AES

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

As far as I am aware the only current commercially available plugins for 
Firebird are for encryption.
If your customer is interested in such a plugin, we could probably develop one 
for them.

Regards
Paul

RE: [firebird-support] info

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> If I try the select, I don’t have any record where realindex is null 

Then I would next check the database for any possible problems... corruption 
etc.

http://www.ibphoenix.com/resources/documents/how_to/doc_5

Regards
Paul

RE: [firebird-support] info

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

Try the following...

Partner index description not found (175))

internal gds software consistency check (partner index description not found. 
Missing index for a primary or a foreign key. The problem may be caused by 
physical database corruption or by a bug.

Recovery process:

To find the missing index, use following SELECT statement:

select R.RDB$CONSTRAINT_NAME, R.RDB$INDEX_NAME as REFINDEXNAME,
   I.RDB$INDEX_NAME as REALINDEX, I.RDB$RELATION_NAME, I.RDB$INDEX_INACTIVE
from RDB$INDICES I RIGHT
JOIN RDB$RELATION_CONSTRAINTS R on I.RDB$INDEX_NAME = R.RDB$INDEX_NAME
where R.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
   or R.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
order by R.RDB$CONSTRAINT_NAME

The contraint that is missing an index (where column REALINDEX is empty) will 
be 
corrupted. Try and recreate this constraint.

Paul

RE: [firebird-support] Firebird database corrupt with wrong page type error on table

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

http://www.ibphoenix.com/resources/documents/how_to/doc_5

Regards
Paul

  -Original Message-
  From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
  Sent: 21 December 2017 13:14
  To: firebird-support@yahoogroups.com
  Subject: [firebird-support] Firebird database corrupt with wrong page type
error on table




  Hello everyone,



  During inserting data to a table I received an error on my application log
"database file appears corrupt (DB Path) wrong page type page 232333 is of
wrong type (expected 5, found 7)".



  On looking in FB log I got following  :



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB

  Data page 232331 (sequence 168514) is confuse d in table
TABLENAME (159)



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB

  Page 232333 wrong type (expected 5 encountered 7)



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB< /p>

  Data page 232333 (sequence 168515) is confused in table
TABLENAME (159)



  DEVMACHINE (Server)  Thu Dec 21 16:45:24 2017

  Database: DB

  Page 232317 is an orphan





  This is the first time I am seeing this error and don't know what has
caused it. Is there any precaution to avoid such kind of errors..?



  This database is around 3 years old and database maintenance activity is
not done on it.  Also, the said table has 5.4 million records in it.





  Thank you in advance J


  

RE: [firebird-support] Issue with GBAK and upgrading old DB (1.5 -> 3.x)

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

Please read

Upgrading from Firebird 1.5 to 2.5 and beyond (.pdf) (161.31K)
by Pavel Cisar

http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

It will help...

Regards
Paul

RE: Re[2]: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

Simply put.

As long as the database on the NFS mount cannot be accessed by another Firebird 
server
on another system then you can use this "feature" (RemoteFileOpenAbility).

Regards
Paul

RE: [firebird-support] Embedded FB3 was killed?

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> >Read carefully "Remodelled Architecture" part.
> 
> As far as I understand that, I just call "fbclient.dll" as usual,
> and if the database path is a local file, "fbclient.dll" automagically
> calls "engine12.dll" (or whatever it needs) for the use as a local/
> embedded server. Correct?
> 
> Which leads my to the question: Which of the 274 files in the 3.0.2
> ZIP are necessary to be copied into the client's application directory
> in order to run the embedded server? (Of course, as few as possible...)

This might help
https://www.lawinegevaar.nl/firebird/jaybird_embedded_example.html
Jaybird with Firebird embedded example and the section Details on embedded use

Regards
Paul






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Transaction Management Failing?

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

> > The logic is that straightforward. The InsertMyData inserts lines of an 
> > invoice or any
> > other customer transaction into ledgers, each identified by a transaction 
> > number. The
> > problem is that when the issue occurs, multiple copies of the data end up 
> > in the database,
> > which based on the above logic should not be possible.
>
>Not quite so. You don't write down what exception happen in exception 
> handler. If any
> exception happen between CommitTransaction and 'Done := true', you'll get 
> duplicates.
>You haven't described how InsertMyData works. If (by mistake) it uses 
> AutoCommit - the
> window where you logic can blow up is getting wider.
>
> > It’s a really difficult one as it is totally random.
>
>Still you can turn audit on and (even logs will be enormous) find out 
> exact sequence of
> events.

Dimitry is right, I would suggest implementing the trace and audit facility, 
find out when the errror
next occurs and start looking at exactly what is happening as far as the 
database is concerned.

https://firebirdsql.org/rlsnotesh/rnfb25-trace.html

I tracked down a problem on a  known accounting/inventory system using this 
feature, and proved there
was a logic problem within the client software.

Paul







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] Firebird 3 crashes, unable to capture crash dumps ( terminated abnormally (4294967295) )

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

>

Try following these instructions
http://www.ibphoenix.com/resources/documents/search/doc_35
Tracking Down Crashes on Windows Systems

Regards
Paul

RE: [firebird-support] file size and transactions

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

 
> I read somewhere that the "read only" transactions are absolutelly harmless 
> to the GC and sweeping. Is that so?

>>Read only transactions only physically have an impact on the TIP/Header 
>>page(s), however a long running read only transaction
>>will have the same effect as a long running read write transaction in that it 
>>will block GC and sweeps until it
>>commits.

<>

Karol,

I was referring to the default transaction state of snapshot (repeatable 
read)
Other transaction states will have different effects. In your case
read commited needs only the newest record version (or record versions created 
by 
the transaction itself) so its not going to block anything.

Paul

RE: [firebird-support] file size and transactions

['Paul Beach7; pbe...@mail.ibphoenix.com [firebird-support]]

<>

Not really, 2 weeks or 2 months would be a huge time.

> I read somewhere that the "read only" transactions are absolutelly harmless 
> to the GC and sweeping. Is that so?

Read only transactions only physically have an impact on the TIP/Header 
page(s), however a long running read only transaction
will have the same effect as a long running read write transaction in that it 
will block GC and sweeps until it
commits.

Paul