[firebird-support] Changing non-nullable column to nullable in FB 3

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

i followed the guideline here
http://www.firebirdsql.org/manual/nullguide-alter-pop-tables.html
to change an already populated column to nullable (constraint has no name).

The guideline involves updating a system table in such a case and in 3.0 they 
are read-only now. What would be the way to do it now?

Thanks
Ralf

RE: [firebird-support] Changing non-nullable column to nullable in FB 3

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Found. Tried. Worked. Thanks

-Original Message-
From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Freitag, 29. April 2016 18:24
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Changing non-nullable column to nullable in FB 3

29.04.2016 18:19, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] 
wrote:
> What would be the way to do it now?

   Read Release Notes about changes in DDL.

-- 
   WBR, SD.






++

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

[firebird-support] HowTo for Plugins

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

I wanted to experiment with the dbcrypt sample deployed with FB 3.0. But all I 
found was the source code file in the examples folder.
Is there any documentation on what is needed to get a compiling project? And 
some documentation about the used/needed interfaces in that example and how 
they are supposed to work/be used?

I tried to find something in the deployed documentation and via google but 
failed to find something helpful ☹

Thanks for any pointers
Ralf

[firebird-support] FW: HowTo for Plugins

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

unfortunately, my question didn't get anything as response so I assume that 
there isn't a documentation dedicated to writing plugins.
Let me try a more concrete question on the subject.

I was reading the Release Notes here
http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-plugins
and it is talking about a plug-in.h header file I can't find. Should it rather 
mention ImplementationHelper.h? Or is plug-in.h something I need?

Ralf


From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Mittwoch, 4. Mai 2016 11:38
To: firebird-support@yahoogroups.com
Subject: [firebird-support] HowTo for Plugins

  
Hi,
 
I wanted to experiment with the dbcrypt sample deployed with FB 3.0. But all I 
found was the source code file in the examples folder. 
Is there any documentation on what is needed to get a compiling project? And 
some documentation about the used/needed interfaces in that example and how 
they are supposed to work/be used?
 
I tried to find something in the deployed documentation and via google but 
failed to find something helpful ☹
 
Thanks for any pointers
Ralf

RE: Re: [firebird-support] SQL standard for sort fields and returned fields

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

What Exception?
Sql92 seems to not state anything in that regard. So this belongs presumably 
into the implementation specific area.

I’m sure if it had been defined there it would not be a clear yes/no thing.
For example, Firebird allows this even when the select clause contains DISTINCT 
so that some sort of grouping takes place. I have no idea on what info a 
meaningful sorting should take place then? The column wasn’t part of the 
grouping. In my (obviously wrong) mental model of what happens the column isn’t 
there anymore when ordering takes place.

Ralf


From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Montag, 9. Mai 2016 16:30
To: firebird-support@yahoogroups.com
Subject: ODP: Re: [firebird-support] SQL standard for sort fields and returned 
fields


hi,

could you explain this exception?
And i also have not sql standard to look into and need some exact confirmation 
about this (something like Sql92 or sql2013.. say this)

regards,
Karol Bieniaszewski


 Oryginalna wiadomość 
Od: "Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support]" 
mailto:firebird-support@yahoogroups.com>>
Data: 09.05.2016 13:20 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: [firebird-support] SQL standard for sort fields and returned fields



On 2016-05-09 11:45, liviuslivius 
liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi,
>
> This is not specific to Firebird question but:
> is something in SQL standard specification about sorted fields must
> be
> also returned?
> I mean:
>
> SELECT
> [FILM_DATE,]FILM_TITLE
> FROM
> FILMS
> ORDER BY FILM_DATE, FILM_TITLE
>
> is [FILM_DATE] required by SQL standard or it is optional or SQL
> standard tell nothing about this?

I don't have the SQL standard at hand right now, so I can't double
check. As far as I know, the SQL standard allows you to sort on any
field, even if it is not in the select list (with the exception of
course of ordering by column index).

Mark

RE: [firebird-support] FW: HowTo for Plugins

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

really? The groups disclaimer states „DO NOT USE THIS LIST FOR SUPPORT 
QUESTIONS REGARDING RELEASED VERSIONS.”

Ralf

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Montag, 9. Mai 2016 13:21
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FW: HowTo for Plugins

  
On 2016-05-09 10:36, Ralf Jansen mailto:ralf.jan...@mailstore.com 
[firebird-support] wrote:
> Hi,
>
> unfortunately, my question didn't get anything as response so I
> assume that there isn't a documentation dedicated to writing plugins.
> Let me try a more concrete question on the subject.
>
> I was reading the Release Notes here
> 
> http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-plugins
> and it is talking about a plug-in.h header file I can't find. Should
> it rather mention ImplementationHelper.h? Or is plug-in.h something I
> need?
>
> Ralf
>
>
> From: mailto:firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Sent: Mittwoch, 4. Mai 2016 11:38
> To: mailto:firebird-support@yahoogroups.com
> Subject: [firebird-support] HowTo for Plugins
>
>  
> Hi,
>  
> I wanted to experiment with the dbcrypt sample deployed with FB 3.0.
> But all I found was the source code file in the examples folder.
> Is there any documentation on what is needed to get a compiling
> project? And some documentation about the used/needed interfaces in
> that example and how they are supposed to work/be used?
>  
> I tried to find something in the deployed documentation and via
> google but failed to find something helpful ☹
>  
> Thanks for any pointers
> Ralf

I suggest that you post this to the firebird-devel mailinglist instead.

Mark

[firebird-support] Checking Ods version (2.5 <-> 3.0)

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,
is there an easy/official way to check the ODS versions?
I was going the gstat route but the 2.5 gstat doesn't know anything about ODS 
12 and up and the 3.0 gstat only knows about ODS 12 and up.
Both gstats throw errors in case of an unknown ODS Version but it feels wrong 
relying on that error message for distinction.

Thanks
Ralf

RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

I missed to say that it’s all about embedded usage. So before executing any 
statement I would need to know what firebird library to use for connecting.
My use case is actually detecting pre ODS 12 databases and doing a 
backup/restore to get them into the current format.



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Donnerstag, 12. Mai 2016 17:30
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)


Hi,

i do not know what do you mean “to check”
Can you connect to db? or you cannot and need to check?

If you can connect, then this is simple:

SELECT r.MON$ODS_MAJOR, r.MON$ODS_MINOR
FROM MON$DATABASE r

regards,
Karol Bieniaszewski

From: mailto:firebird-support@yahoogroups.com
Sent: Thursday, May 12, 2016 4:02 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Checking Ods version (2.5 <-> 3.0)



Hi,
is there an easy/official way to check the ODS versions?
I was going the gstat route but the 2.5 gstat doesn't know anything about ODS 
12 and up and the 3.0 gstat only knows about ODS 12 and up.
Both gstats throw errors in case of an unknown ODS Version but it feels wrong 
relying on that error message for distinction.

Thanks
Ralf

RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

No Server involved. I am directly using the fbembed/fbclient.dll for for 
connecting to an fdb file.
I'm a Firebird embedded user.



From: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com]
Sent: Thursday, May 12, 2016 20:18
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)



Hi,

This detection is useless .
use the latest library (FB3) and you can connect to any older servers

regards,
Karol Bieniaszewski

From: 
mailto:firebird-support@yahoogroups.com
Sent: Thursday, May 12, 2016 6:50 PM
To: 
firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)


I missed to say that it’s all about embedded usage. So before executing any 
statement I would need to know what firebird library to use for connecting.
My use case is actually detecting pre ODS 12 databases and doing a 
backup/restore to get them into the current format.
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Donnerstag, 12. Mai 2016 17:30
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

Hi,
i do not know what do you mean “to check”
Can you connect to db? or you cannot and need to check?
If you can connect, then this is simple:
SELECT r.MON$ODS_MAJOR, r.MON$ODS_MINOR
FROM MON$DATABASE r
regards,
Karol Bieniaszewski
From: 
mailto:firebird-support@yahoogroups.com
Sent: Thursday, May 12, 2016 4:02 PM
To: 
firebird-support@yahoogroups.com
Subject: [firebird-support] Checking Ods version (2.5 <-> 3.0)


Hi,
is there an easy/official way to check the ODS versions?
I was going the gstat route but the 2.5 gstat doesn't know anything about ODS 
12 and up and the 3.0 gstat only knows about ODS 12 and up.
Both gstats throw errors in case of an unknown ODS Version but it feels wrong 
relying on that error message for distinction.

Thanks
Ralf

[firebird-support] Firebird Embedded and shutdown state

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

i have a .Net application that is using firebird embedded 2.5 and 3.0 
concurrently. That is needed for a smooth, almost uninterrupted, transition 
from 2.5 to 3.0 databases for that application.
Starting the application and using 2.5 and 3.0 databases in parallel simply 
works. But after doing a backup/restore from inside the application (backup via 
2.5 restore via 3.0 client library) for upgrading a database I can only use 
that 3.0 database for around 60 seconds without a problem.
After that I get a "connection shutdown" error (335544856) for all databases 
using the 3.0 client. 2.5 databases are ok.

Any pointers what that might be? What does shutdown mean in the context of an 
embedded db?

[firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

I just learned that enabling encryption via "ALTER DATABASE ENCRYPT etc." 
starts encryption of the database asynchronously in the background.
Are there any settings or something to change/manage the behavior or monitor 
the progress?

For example, I would need to be able to start stop that background encryption 
for backups (via volume shadow service).
Normally I could simply stop all running connections and clearing the 
connection pool to get the database into a state where it could be backed-up.
But the encryption task seems to keep a handle to the file open.

--
Mit freundlichen Grüßen / Kind regards
Ralf Jansen

MailStore Software GmbH
Clörather Str. 1-3
41748 Viersen, Germany

Phone:   +49-2162-50299 0
Fax: +49-2162-50299 29
E-mail:  ralf.jan...@mailstore.com
Web: http://www.mailstore.com

Handelsregister Mönchengladbach, HRB 11557
Geschäftsführer: Philip Weber, Anthony Folger, Thomas Kasper

WG: [firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Yes, monitoring seems to be possible. Automating gstat isn't really nice but 
looking at the system tables should be ok.
But what about stopping/resuming the progress?

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Dienstag, 2. August 2016 13:11
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Firebird 3 encryption in the background

02.08.2016 13:03, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] 
wrote:
> i agree that will be good to see possibility to check finished state

   gstat and monitoring tables are for that.


-- 
   WBR, SD.






++

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

AW: [firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,


Ø  how often do you encrypt database? i suppose that only once.

Sure every database only once. In this case a high 6-digit count of databases 
around the world that should be upgraded/encrypted only once automatically and 
should not interfere with the backup strategy of the
responsible admin.


Ø  this is not good think to include database file in Volume Shadow Copy Service

Why do you think so? VSS means uninterrupted usage (a few milliseconds that a 
transaction has to wait before the snapshot is ready and the database is not 
usable) of the software while backing up and the VSS copy will still be 
encrypted.
As far as I understand you get unencrypted backups when using gback/nbackup. 
That’s not what I need.

Ralf

AW: WG: [firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Ok. What does that mean for embedded? The docs describe embedded as neither 
Super/Superclassic or Classic but as its own 4th model as of FB 3.0.
I closed all connection to the database while encrypting and encrypting was 
still going on(I assume it was still going on, I just saw still open 
filehandles to the db file). Do I need to unload the database somehow 
explicitly?


-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Dienstag, 2. August 2016 15:45
An: firebird-support@yahoogroups.com
Betreff: Re: WG: [firebird-support] Firebird 3 encryption in the background

02.08.2016 15:39, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] 
wrote:
> But what about stopping/resuming the progress?

   Encryption is stopped when database unloaded for superserver or at 
disconnect for classic. Encryption is resumed on any next attach.


-- 
   WBR, SD.






++

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

AW: WG: [firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Need to come back to this. I can reproduce the behavior with flamerobin as 
client.
Connect via the embedded client to a database start encryption, disconnect. I 
can see that a handle to the database is still opened by flamerobin even if 
disconnected and I can monitor the encryption progress via "gstat -e".
When the encryption is ready and no connection to the database is open then the 
hosting process will crash and burn.

Is there a way to stop/start the encryption progress?

PS. If you get it twice, Sorry. Reposted as reaction to Helen's post.

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 2. August 2016 15:58
An: firebird-support@yahoogroups.com
Betreff: AW: WG: [firebird-support] Firebird 3 encryption in the background



Ok. What does that mean for embedded? The docs describe embedded as neither 
Super/Superclassic or Classic but as its own 4th model as of FB 3.0.
I closed all connection to the database while encrypting and encrypting was 
still going on(I assume it was still going on, I just saw still open 
filehandles to the db file). Do I need to unload the database somehow 
explicitly?

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 2. August 2016 15:45
An: firebird-support@yahoogroups.com
Betreff: Re: WG: [firebird-support] Firebird 3 encryption in the background

02.08.2016 15:39, Ralf Jansen 
ralf.jan...@mailstore.com [firebird-support] 
wrote:
> But what about stopping/resuming the progress?

Encryption is stopped when database unloaded for superserver or at disconnect 
for classic. Encryption is resumed on any next attach.

--
WBR, SD.





++

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

AW: WG: [firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Need to come back to this. I can reproduce the behavior with flamerobin as 
client.
Connect via the embedded client to a database start encryption, disconnect. I 
can see that a handle to the database is still opened by flamerobin even if 
disconnected and I can monitor the encryption progress via "gstat -e".
Is there a way to stop/start the encryption progress?



Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 2. August 2016 15:58
An: firebird-support@yahoogroups.com
Betreff: AW: WG: [firebird-support] Firebird 3 encryption in the background



Ok. What does that mean for embedded? The docs describe embedded as neither 
Super/Superclassic or Classic but as its own 4th model as of FB 3.0.
I closed all connection to the database while encrypting and encrypting was 
still going on(I assume it was still going on, I just saw still open 
filehandles to the db file). Do I need to unload the database somehow 
explicitly?

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 2. August 2016 15:45
An: firebird-support@yahoogroups.com
Betreff: Re: WG: [firebird-support] Firebird 3 encryption in the background

02.08.2016 15:39, Ralf Jansen 
ralf.jan...@mailstore.com [firebird-support] 
wrote:
> But what about stopping/resuming the progress?

Encryption is stopped when database unloaded for superserver or at disconnect 
for classic. Encryption is resumed on any next attach.

--
WBR, SD.





++

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

WG: [firebird-support] Firebird 3 encryption in the background

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Thanks Vlad,
i wasn’t aware of the „linger“-feature. Shouldn’t be a factor here. I did not 
enabled that feature and I’m under the impression that Embedded != Superserver.

I have a multitude of problems with the encryption in embedded fb. This is just 
one of it. When I have enough understanding about it and have the feeling that 
this is a bug and not just a misunderstood feature I will report it in the bug 
tracker.

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 5. August 2016 19:20
An: firebird-support@yahoogroups.com
Betreff: Re: AW: WG: [firebird-support] Firebird 3 encryption in the background

  ---In 
firebird-support@yahoogroups.com, 
mailto:ralf.jansen@...>> wrote :

> Need to come back to this. I can reproduce the behavior with flamerobin as 
> client.
> Connect via the embedded client to a database start encryption, disconnect. I 
> can see that a handle to the database
> is still opened by flamerobin even if disconnected and I can monitor the 
> encryption progress via “gstat -e”.
> When the encryption is ready and no connection to the database is open then 
> the hosting process will crash and burn.

If you are sure there is no database linger set and there is really no user 
conections - report a bug in tracker, please.

> Is there a way to stop/start the encryption progress?

Of course - no. But you may use the fact that background encryption thread 
pause itself while database
physical state is not "normal". I.e. when database file is locked for physical 
backup.

Regards,
Vlad

[firebird-support] monitoring encryption

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

I'm trying to monitor encryption and look at Mon$Database for it.
Documentation has this example  "select MON$CRYPT_PAGE * 100 / MON$PAGES from 
MON$DATABASE"
As indicator that encryption it done I thought that the value of CRYPT_PAGE 
should be equal to PAGES (PAGES - CRYPT_PAGE == 0).
But it seems that CRYPT_PAGE jumps back to 0 in the end of the process. Is that 
correct? Is that intended behavior?

[firebird-support] CORE-5154 Services API don't work with non-ascii database names

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

CORE-5154 is marked as fixed with the 3.0.1 release but I still have that 
problem with a current nightly build (3.0.2.32615) and stumble into this when 
having german umlauts (from Codepage 1252) in the path to the database.
As I'm using Firebird via the.Net Provider I'm struggling if it's still a 
Firebird engine problem or rather a problem of the .Net Provider.
Can someone (using firebird without the .Net Provider) confirm if the problem 
still persists?

Thanks
Ralf

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

[firebird-support] causes for disabled indexes

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,

I'm using firebird embedded (2.5 and 3) in an on-premise solution. I get 
sometimes reports of slow behaviour and when checking those databases I can see 
that some or all indexes are disabled.
I can than simply enable those indexes and all seems well afterwards. Gfix does 
not find any problems and backup/restore works without a problem either then.

Are there some known causes that will result in disabled indexes without 
breaking the database otherwise?
The application itself doesn't touch indexes directly they just get created at 
some point.

Thanks
Ralf

[firebird-support] RE: causes for disabled indexes

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi Neil,

I also have that experience when restoring. But as you said only when there are 
problems in the underlying table. Like duplicate values in a column that has a 
unique index.
In that case i can only reenable the index when fixing the table. In the cases 
I'm talking about there are no obvious problems but the indexes are disabled 
nevertheless and can simply be reenabled.
Since I do not have that problem in a controlled environment I can't say if my 
cases are also connected to restoring or not. I can say that in this case, if 
gbak would have left those indexes disabled it does not report it back via an 
errorcode.

Cheers,
Ralf

From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com]
Sent: Freitag, 23. Februar 2018 12:33
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] causes for disabled indexes


I know from experience that a restore can sometimes leave indexes in a disabled 
state, and you would usually get an error when trying to activate it as it was 
left disabled during the restore phase due to a minor data issue. The 
errorlevel returned by GBAK is greater than 0 so you can detect when this has 
happened without having to check all the indexes.

We see this with our firebird databases on occasion, it's preferable to the 
restore just failing and having to be run again without restoring indexes and 
manually identifying and dealing with the data issue then turning all the 
indexes back on again. It seems to be minor data issues that cause the index 
gets left disabled by GBAK, bigger issues and the restore will just stop with 
an error.

Cheers,

Neil Pickles

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com]
Sent: 23 February 2018 11:21
To: firebird-support@yahoogroups.com
Subject: [firebird-support] causes for disabled indexes


Hi,

I'm using firebird embedded (2.5 and 3) in an on-premise solution. I get 
sometimes reports of slow behaviour and when checking those databases I can see 
that some or all indexes are disabled.
I can than simply enable those indexes and all seems well afterwards. Gfix does 
not find any problems and backup/restore works without a problem either then.

Are there some known causes that will result in disabled indexes without 
breaking the database otherwise?
The application itself doesn't touch indexes directly they just get created at 
some point.

Thanks
Ralf

[firebird-support] Firebird 3.0.3 changes for encryption plugins

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

Hi,
I have just read the general notes for FB 3.0.3 especially the alert for users 
of encryption via a plugin.
That alert seems to refer to CORE-5735. But that issue does not seem to be 
readable without special permissions. At least I'm not allowed to read that one 
when signed in to the tracker.

Would be nice if that ticket could be made readable.

AW: [firebird-support] multiple embedded versions

[Ralf Jansen ralf.jan...@mailstore.com [firebird-support]]

I’m using multiple firebird embedded versions from within the same process 
without fiddling around in environment variables like FIREBIRD_LOCK or conf 
files of the different firebird versions.

There should be no need in doing anything special. Just use the version(s) you 
like.

Ralf


Von: firebird-support@yahoogroups.com 
Gesendet: Donnerstag, 28. Februar 2019 21:17
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] multiple embedded versions


hi,
let's say that i have differents applications on different folders .

each folder contain a firebird database and an embedded firebird dll .

is it safe to use this setup knowing that all the embedded libraries will use 
the same firebird lock directory .

the reason for this and not using a regular firebird server is that i am on a 
web shared hosting environement ,
i have several websites on the same server and each website have it's own 
database and fbembed.dll library .

i have managed to use the firebird embedded on the shared hosting by setting
the FIREBIRD_LOCK variable , but i dont know if it safe to use this setup that 
way .


another option is to use a single fbembed.dll library for all the website but i 
don't know if it's possible .
in any case there is a firebird database .gdb for each single website / process 
.


any idea is welcome , thanks .