Fabiano,
> I’m testing the new Firebird 3.0 build 31369 and trying to restore a big
> database and at some point, creating an index gbak.exe crashes and
> database restore is interrupted.
>
> In the firebird.log I got 2 entries:
>
> FABIANOWed Oct 22 15:46:42 2014
>
>
classic mode (started via xinetd) broken in FB3 Beta 1
--
Key: CORE-4588
URL: http://tracker.firebirdsql.org/browse/CORE-4588
Project: Firebird Core
Issue Type: Bug
Components: En
Hi,
While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha 2), I
get this error:
action cancelled by trigger (3) to preserve data integrity
object has non-SQL security class defined
Exiting before completion due to errors
SQL state: 27000
SQL code: -901
FB version: WI-T3.0.0.31
27.10.2014 12:30, Robbert-Jan wrote:
> While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha
> 2), I get this error:
> action cancelled by trigger (3) to preserve data integrity
> object has non-SQL security class defined
Can you provide us with this backup?
Dmitry
On Firebird conference Dmitry Yemanov was presenting new features in FB 3.0.
He mentioned something called "Finalize API for Delphi and Free Pascal
programmers".
However he also said that he do not know the details because Alex implemented
it.
Could we get more info about this topic?
Is it con
I sent to you an email, thank you.
-Mensagem original-
De: Dmitry Yemanov [mailto:firebi...@yandex.ru]
Enviada em: segunda-feira, 27 de outubro de 2014 05:19
Para: For discussion among Firebird Developers
Assunto: Re: [Firebird-devel] Firebird 3.0 Build 31369 gbak crash
Fabiano,
> I'm t
27.10.2014 11:10, Wodzu wrote:
> Is it connected to this issue
> perhaps?http://tracker.firebirdsql.org/browse/CORE-3826
No, it is connected to this issue:
http://bugs.freepascal.org/view.php?id=26593 which
makes FPC to produce wrong assemble code for 64 bits versions.
--
WBR, SD.
Hi Dmitry,
Sure, I'm happy to.
As long as I can put it somewhere privately (i.e. not on the internet) and
you're willing to destroy it after analyzing/fixing.
I use the database mainly for testing, but it still contains some data i
rather not want to share with the general public.
Where can I pu
On 10/27/14 13:10, Wodzu wrote:
> On Firebird conference Dmitry Yemanov was presenting new features in FB 3.0.
> He mentioned something called "Finalize API for Delphi and Free Pascal
> programmers".
>
> However he also said that he do not know the details because Alex implemented
> it.
>
> Could
27.10.2014 13:34, Robbert-Jan wrote:
>
> Sure, I'm happy to.
> As long as I can put it somewhere privately (i.e. not on the internet) and
> you're willing to destroy it after analyzing/fixing.
I will destroy it for sure.
> Where can I put it?
Do you have FTP server in your company?
> The size o
Am 27.10.2014 um 10:45 schrieb Dmitry Yemanov:
> 27.10.2014 12:30, Robbert-Jan wrote:
>
>> While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha
>> 2), I get this error:
>> action cancelled by trigger (3) to preserve data integrity
>> object has non-SQL security class defined
>
>
Hi,
Download beta 1 on Win32.
1) installer usability failure
- cannot start the installer with a Firebird service (1.5 & 2.5) running, even
though I’d like to install as a separate instance
- a warning would be fine, but even if it’s Firebird 3 running, it should be
possible to install as an ad
Hi,
I noticed this in a recent nightly build last Saturday, it’s still there in
Beta 1.
I have a package, with a routine, when I tried modifying the body, it returns
an error:
8<
unsuccessful metadata update
RECREATE PACKAGE BODY C_INVOICE failed
Procedure ADD_ORDER_TO_INVOICE has a si
27.10.2014 12:50, Martijn Tonies (Upscene Productions) wrote:
> What now? Same issue as above: multiple instances is supported, so why this
> warning?
Multiple instances are supposed to be supported, but actually they aren't.
--
WBR, SD.
--
Hi,
Two questions with regard to using additional security databases:
1)
I added the following to the databases.conf:
FBConf2014 = e:/temp/2014 FB Conference.fdb
{
SecurityDatabase = e:/temp/sec.fdb
}
“sec.fdb” is a copy of “security3.fdb”.
When connecting, I get:
Missing security contex
Hi Frank and Dimitry,
Yes, that must be it.
Indeed I granted some time ago a privilege on a package (as part of my
testing of apha2).
Now, I've just revoked this privilege (under alpha2), made a new backup, and
restored it succesfully under beta1.
At least, I can now continue testing beta1;)
B
Hi,
Has something been decided with regard to this issue yet?
With regards,
Martijn Tonies
Upscene Productions
09.10.2014 17:24, Adriano dos Santos Fernandes wrote:
> On 09/10/2014 10:34, Martijn Tonies (Upscene Productions) wrote:
>> >You could use FIELD_NAME, for backwards compatibility, bu
>> What now? Same issue as above: multiple instances is supported, so why
>> this warning?
>
> Multiple instances are supposed to be supported, but actually they
> aren't.
I'm not sure what to make of this statement.
With regards,
Martijn Tonies
Upscene Productions
--
27.10.2014 14:30, Martijn Tonies (Upscene Productions) wrote:
> I'm not sure what to make of this statement.
Take it as a confirmation that current installer's behavior is correct: if
it continue
to set up registry entries and system service it will break existing Firebird
2.5
installation.
Just a few quick comments...
o The bottom line here is that multiple instances are not supported by the
installer and never have been. You have to do that manually. You could file a
bug report/feature request to add this perhaps but the aim with the installer
has always been to keep it as sim
27.10.2014 15:20, Robbert-Jan wrote:
> But do I have to create a issue in the tracker for this? I guess not, if it
> only applies to converting from alpha2 to beta1.
I can now confirm this being an incompatibility in the backup format
introduced between Alpha 2 and Beta 1. This affects packages
Hi Martijn,
Thanks for report, we'll go through things you listed.
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
Download beta 1 on Win32.
1) installer usability failure
- cannot start the installer with a Firebird service (1.5 & 2.5)
running, even though I’d like to install as a separate instance
-
Hello Paul,
Good to see you're back. ;)
>Just a few quick comments...
>
> o The bottom line here is that multiple instances are not supported by the
>installer and never have been. You have to do that manually. You could file
>a
>bug report/feature request to add this perhaps but the aim with th
27.10.2014 15:04, Martijn Tonies (Upscene Productions) wrote:
> Just a note: MySQL allows this, it allows you to define service name, port,
> a few configuration options etc.
Could you describe what are instances good for generally?
I know that in Oracle they are used to bypass limitation "o
>> Just a note: MySQL allows this, it allows you to define service name,
>> port,
>> a few configuration options etc.
>
> Could you describe what are instances good for generally?
Obviously for testing. ;)
But also for small(er) companies that won't do a separate server for each
product, but u
Hi Martijn,
Maybe it is too obvious, but it looks like your body has four routines and your
header only three (CHECK_INVOICE_EXISTS is missing), hence the signutare
mismatch.
Kind regards,
Robert
From: Martijn Tonies (Upscene Productions)
Sent: Monday, October 27, 2014 12:54 PM
To: firebird-dev
Obviously it is possible to add support for multiple installs, although it
does add complexity to the installer and we don't really have a way at the
moment to deal with uninstallation because we don't have a mechanism in place
to track what instances of firebird are running on which ports. I r
Hello Robbert-Jan,
Private functions not exposed to the outside is one of the things you can
do with packages.
Mind you, the error message explicitly tells me there’s a mismatch for
routine ADD_ORDER_TO_INVOICE
Also mind you, the package ALREADY EXISTS with the exact same definition,
I just adde
Hello Paul,
>Obviously it is possible to add support for multiple installs, although it
>does add complexity to the installer and we don't really have a way at the
>moment to deal with uninstallation because we don't have a mechanism in
>place
>to track what instances of firebird are running on w
On Monday 27 October 2014 17:28:27 Martijn Tonies (Upscene Productions) wrote:
>
> I know next to nothing about Firebird engine development, but at least
> in Windows, many applications set a mutex (or other shared structure)
> that's being checked against in the Uninstaller (like InnoSetup can do
> Obviously it is possible to add support for multiple installs, although it
> does add complexity to the installer and we don't really have a way at the
> moment to deal with uninstallation because we don't have a mechanism in place
> to track what instances of firebird are running on which ports.
Hello Paul,
>From: Paul Reeves
>On Monday 27 October 2014 17:28:27 Martijn Tonies (Upscene Productions)
>wrote:
>>
>> I know next to nothing about Firebird engine development, but at least
>> in Windows, many applications set a mutex (or other shared structure)
>> that's being checked against in
NaN field Fix
--
Key: CORE-4589
URL: http://tracker.firebirdsql.org/browse/CORE-4589
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.3
Environment: NaN select error
Reporter: Daniel Cunha
When we decided not to validate constraints on declaration, our reasoning
was that computations and database access were expensive and any decent
application programmer or DBA would always validate constraints before
declaring them and control access to the constrained items until the
constraint wa
Hello,
does the following reflect the real status quo on what needs to be done
for Beta 2?
http://tracker.firebirdsql.org/browse/CORE/fixforversion/10586
Thanks,
Thomas
--
Firebird-Devel mailing list, web interface at
> When we decided not to validate constraints on declaration, our
> reasoning was that computations and database access were expensive and
> any decent application programmer or DBA would always validate
> constraints before declaring them and control access to the constrained
> items until the con
28.10.2014 00:09, Thomas Steinmaurer wrote:
>
> does the following reflect the real status quo on what needs to be done
> for Beta 2?
> http://tracker.firebirdsql.org/browse/CORE/fixforversion/10586
More or less. Some items from that list can be postponed and some minor
tasks may be not in the li
27.10.2014 19:58, Paul Reeves wrote:
>> What is - currently - the reason to keep supporting the cpl applet? Does it
>> do anything more than just starting/stopping the service?
>
> It has always allowed switching the guardian on and off, as well as switching
> between running as an app or a servic
If, in Firebird 4, you're going to look at indexes, I have four suggestions.
1) Indexes with large keys
An index key that's a significant fraction of the page size leads to
inefficient indexes (or infinite depth), so rules about index size aren't
just the revenge of database management system de
If, in Firebird 4, you're going to look at indexes, I have four suggestions.
1) Indexes with large keys
An index key that's a significant fraction of the page size leads to
inefficient indexes (or infinite depth), so rules about index size aren't
just the revenge of database management system de
Change type of returning value of OCTET_LENGTH() to bigint
--
Key: CORE-4590
URL: http://tracker.firebirdsql.org/browse/CORE-4590
Project: Firebird Core
Issue Type: Improvement
41 matches
Mail list logo
