RE: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

2017-12-22 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] 
That’s great – thanks! I can confirm this issue no longer exists in nightly 
build 3.0.3.32857 and InterBase 7.5.1 clients connect with protocol 10.  
Looking forward to moving ahead with our migration to Firebird in the new year 
:)

Steve

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, 21 December 2017 9:07 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird 3.0.3 no longer compatible with 
InterBase 7.5.1 clients



On 21-12-2017 08:49, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 21-12-2017 03:06, FSPAPA INCA Team i...@foodstuffs-si.co.nz
> [firebird-support] wrote:
>> I reckon this change to src/remote/server/server.cpp in commit
>> 2fdb281759299f24d47349246f3c800ec78971cc introduced an unintended effect:
>
> I think you're right. I'll create a ticket in the tracker for this.

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

Mark
--
Mark Rotteveel




Note:
This e-mail message has been inspected for malicious content.

Attention:
The information contained in this message and or attachments is intended only 
for the person
or entity to which it is addressed and may contain confidential and/or 
privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon,
this information by persons or entities other than the intended recipient is 
prohibited. If you
received this in error, please contact the sender and delete the material from 
any system and
destroy any copies.
Please note that the views and opinions expressed in this message may be those 
of the
individual and not necessarily those of Foodstuffs South Island Ltd.

Thank you.

Re: [firebird-support]Engine Error - Partner Index

2017-12-22 Thread Helen Borrie hele...@iinet.net.au [firebird-support] 
Hello Nico,

Friday, December 22, 2017, 10:29:05 PM, you wrote:

> Hello,

> I have a problem with inserting a row in table
> OrderTypeDescriptions. Here you can find the sql script for the
> tables OrderTypes and OrderTypeDescriptions.


> CREATE TABLE ORDERTYPES (

>   ID  INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

>   STOCKORDER  BOOLEAN DEFAULT FALSE NOT NULL,

>   ROWVERSION  TIMESTAMP,

>   /* Keys */

>   CONSTRAINT PK_ORDERTYPES

> PRIMARY KEY (ID)

> );



> CREATE TABLE ORDERTYPEDESCRIPTIONS (

>   IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

>   ORDERTYPEID   INTEGER NOT NULL,

>   ORDERTYPEDESCRIPTION  VARCHAR(100) COLLATE UNICODE_CI_AI,

>   LANGUAGEIDINTEGER NOT NULL,

>   ROWVERSIONTIMESTAMP,

>   /* Keys */

>   CONSTRAINT PK_ORDERTYPEDESCRIPTIONS

> PRIMARY KEY (ID),

>   /* Foreign keys */

>   CONSTRAINT FK_ORDERTYPEDESC_LANGUAGEID

> FOREIGN KEY (LANGUAGEID)

> REFERENCES LANGUAGES(ID) <--

> ON DELETE CASCADE,

>   CONSTRAINT FK_ORDERTYPEDESC_ORDERTYPEID

> FOREIGN KEY (ORDERTYPEID)

> REFERENCES ORDERTYPES(ID)

> ON DELETE CASCADE

> );



> CREATE INDEX IX_ORDERTYPEDESC_DESCRIPTION

>   ON ORDERTYPEDESCRIPTIONS

>   (ORDERTYPEID, LANGUAGEID);

> If I insert a row in table OrderType there is no problem.
> Id = 1
> Stockorder = true

> If I post a new row in table OrderTypeDescriptions I got a problem

Insert into OrderTypeDescriptions (OrderTypeId, OrderTypeDescription, 
LanguageId)

values (1, 'Test', 1)

> Problem
> Engine Error (code = 335544333): internal Firebird consistency
> check (partner index description not found (175), file: idx.cpp line: 1271).
> SQL error (code = -902): Unsuccessful execution caused by a system
> error that precludes successful execution of subsequent statements.

Where is the insert for the master record in LANGUAGES with
LANGUAGEID=1?

Also, don't forget that you must commit the DDL for the master tables
before you can define foreign keys that refer to them.  If you are
using isql then the default behaviour is to autocommit DDL statements.
 The same is likely to be untrue if you are using a third-party tool.

 After that, if you have uncommitted inserts to a referenced table in
one transaction, then those uncommitted records are not visible to a
transaction that is trying to insert into the detail table.

Note that isql does not autocommit DML statements.

Helen

RE: [firebird-support] info

2017-12-22 Thread hv...@users.sourceforge.net [firebird-support] 
> If I try the select, I don’t have any record where realindex is null 
 
 
   Check RDB$INDEX_INACTIVE for non-zero\not-null values
 

 Regards,
 Vlad

RE: [firebird-support] info

2017-12-22 Thread 'Paul Beach' 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] Engine Error - Partner Index

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 22-12-2017 13:27, Nico Speleers nico.spele...@carfac.com 
[firebird-support] wrote:
> I only see version 3.0.1. How can I see the digits after comma ?

There is no comma in the version number, but if you mean after the third 
dot, there are several ways:

- Flamerobin: right click on server, "Retrieve server version"
- Windows: right click on firebird.exe, Properties, Details, under "File 
version"
- A service / database info query for the version

In any case, 3.0.1 is not the latest version for 3.0.x, several bugs 
were fixed in 3.0.2 (or wait for 3.0.3, which is expected to be released 
soon). As far as I can tell, your is not a known (or fixed) bug, but you 
might want to try it anyway.

You might also want to check your database with gfix, see 
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html

Mark
-- 
Mark Rotteveel

RE: [firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support] 
If I try the select, I don’t have any record where realindex is null

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.spele...@carfac.com | 
www.carfac.be

[Facebook][LinkedIn][Twitter]




Van: 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] 
[mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 22 december 2017 13:16
Aan: firebird-support@yahoogroups.com
Onderwerp: RE: [firebird-support] info



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



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

RE: [firebird-support] Engine Error - Partner Index

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support] 
I only see version 3.0.1. How can I see the digits after comma ?

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.spele...@carfac.com | 
www.carfac.be

[Facebook][LinkedIn][Twitter]




Van: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
[mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 22 december 2017 13:20
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] Engine Error - Partner Index



On 22-12-2017 13:10, Nico Speleers nico.spele...@carfac.com
[firebird-support] wrote:
> We are using Firebird 3.0.

What is the full version (eg 3.0.2.32703)?

--
Mark Rotteveel



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

Re: [firebird-support] Engine Error - Partner Index

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 22-12-2017 13:10, Nico Speleers nico.spele...@carfac.com 
[firebird-support] wrote:
> We are using Firebird 3.0.

What is the full version (eg 3.0.2.32703)?

-- 
Mark Rotteveel

RE: [firebird-support] Engine Error - Partner Index

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support] 
We are using Firebird 3.0.

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.spele...@carfac.com | 
www.carfac.be

[Facebook][LinkedIn][Twitter]




Van: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
[mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 22 december 2017 12:56
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] info



On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com
[firebird-support] wrote:

> Problem
> Engine Error (code = 335544333): internal Firebird consistency check (partner 
> index description not found (175), file: idx.cpp line: 1271).
> SQL error (code = -902): Unsuccessful execution caused by a system error that 
> precludes successful execution of subsequent statements.
Which version of Firebird are you using (specify the full version, please).

Mark
--
Mark Rotteveel



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

RE: [firebird-support] info

2017-12-22 Thread 'Paul Beach' 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] info

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com 
[firebird-support] wrote:

This is the third topic you started with the non-descriptive subject 
"info". In the future, could you please come up with a succinct but 
informative subject when posting? Subjects should summarize your 
question or problem, it will help getting better attention to your 
questions.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] info

2017-12-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com 
[firebird-support] wrote:

> Problem
> Engine Error (code = 335544333): internal Firebird consistency check (partner 
> index description not found (175), file: idx.cpp line: 1271).
> SQL error (code = -902): Unsuccessful execution caused by a system error that 
> precludes successful execution of subsequent statements.
Which version of Firebird are you using (specify the full version, please).

Mark
-- 
Mark Rotteveel

[firebird-support] info

2017-12-22 Thread Rustam Musa-Akhunov rusta...@ukr.net [firebird-support] 
Try declare column ORDERTYPEDESCRIPTION without 'COLLATE UNICODE_CI_AI' and see 
results.

What default character set has your DB (used in CREATE DATABASE) and what 
character set you use at connection?

RE: [firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support] 
Insert into OrderTypeDescriptions (OrderTypeId, OrderTypeDescription, 
LanguageId)
values (1, 'Test', 1)

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.spele...@carfac.com | 
www.carfac.be

[Facebook][LinkedIn][Twitter]




Van: Рустам Муса-Ахунов rusta...@ukr.net [firebird-support] 
[mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 22 december 2017 10:38
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] info



Show you INSERT query for OrderTypeDescriptions table.



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

[firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support] 
Hello,

I have a problem with inserting a row in table OrderTypeDescriptions. Here you 
can find the sql script for the tables OrderTypes and OrderTypeDescriptions.


CREATE TABLE ORDERTYPES (

  ID  INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

  STOCKORDER  BOOLEAN DEFAULT FALSE NOT NULL,

  ROWVERSION  TIMESTAMP,

  /* Keys */

  CONSTRAINT PK_ORDERTYPES

PRIMARY KEY (ID)

);



CREATE TABLE ORDERTYPEDESCRIPTIONS (

  IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

  ORDERTYPEID   INTEGER NOT NULL,

  ORDERTYPEDESCRIPTION  VARCHAR(100) COLLATE UNICODE_CI_AI,

  LANGUAGEIDINTEGER NOT NULL,

  ROWVERSIONTIMESTAMP,

  /* Keys */

  CONSTRAINT PK_ORDERTYPEDESCRIPTIONS

PRIMARY KEY (ID),

  /* Foreign keys */

  CONSTRAINT FK_ORDERTYPEDESC_LANGUAGEID

FOREIGN KEY (LANGUAGEID)

REFERENCES LANGUAGES(ID)

ON DELETE CASCADE,

  CONSTRAINT FK_ORDERTYPEDESC_ORDERTYPEID

FOREIGN KEY (ORDERTYPEID)

REFERENCES ORDERTYPES(ID)

ON DELETE CASCADE

);



CREATE INDEX IX_ORDERTYPEDESC_DESCRIPTION

  ON ORDERTYPEDESCRIPTIONS

  (ORDERTYPEID, LANGUAGEID);

If I insert a row in table OrderType there is no problem.
Id = 1
Stockorder = true

If I post a new row in table OrderTypeDescriptions I got a problem

Problem
Engine Error (code = 335544333): internal Firebird consistency check (partner 
index description not found (175), file: idx.cpp line: 1271).
SQL error (code = -902): Unsuccessful execution caused by a system error that 
precludes successful execution of subsequent statements.

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.spele...@carfac.com | 
www.carfac.be

[Facebook][LinkedIn][Twitter]






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

[firebird-support] info

2017-12-22 Thread Рустам Муса-Ахунов rusta...@ukr.net [firebird-support] 
Attachments in you email is dropped. Try describe you problem with words.

[firebird-support] info

2017-12-22 Thread Nico Speleers nico.spele...@carfac.com [firebird-support] 
Hello,

I have a problem with inserting a row in table OrderTypeDescriptions. Here you 
can find the sql script for the tables OrderTypes and OrderTypeDescriptions.


CREATE TABLE ORDERTYPES (

  ID  INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

  STOCKORDER  BOOLEAN DEFAULT FALSE NOT NULL,

  ROWVERSION  TIMESTAMP,

  /* Keys */

  CONSTRAINT PK_ORDERTYPES

PRIMARY KEY (ID)

);



CREATE TABLE ORDERTYPEDESCRIPTIONS (

  IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

  ORDERTYPEID   INTEGER NOT NULL,

  ORDERTYPEDESCRIPTION  VARCHAR(100) COLLATE UNICODE_CI_AI,

  LANGUAGEIDINTEGER NOT NULL,

  ROWVERSIONTIMESTAMP,

  /* Keys */

  CONSTRAINT PK_ORDERTYPEDESCRIPTIONS

PRIMARY KEY (ID),

  /* Foreign keys */

  CONSTRAINT FK_ORDERTYPEDESC_LANGUAGEID

FOREIGN KEY (LANGUAGEID)

REFERENCES LANGUAGES(ID)

ON DELETE CASCADE,

  CONSTRAINT FK_ORDERTYPEDESC_ORDERTYPEID

FOREIGN KEY (ORDERTYPEID)

REFERENCES ORDERTYPES(ID)

ON DELETE CASCADE

);



CREATE INDEX IX_ORDERTYPEDESC_DESCRIPTION

  ON ORDERTYPEDESCRIPTIONS

  (ORDERTYPEID, LANGUAGEID);

Screenshot of a row in table OrderType. Here we have no problem.
[cid:image001.png@01D37B06.DF48D970]

Screenshot of a row in table OrderTypeDescriptions
[cid:image002.png@01D37B06.DF48D970]

After insert I've got following error.
[cid:image003.png@01D37B06.DF48D970]

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS 
(klein)]Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.spele...@carfac.com | 
www.carfac.be

[Facebook][LinkedIn][Twitter]






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