Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Index activation error #8284

Open
ggreggory-hub opened this issue Oct 15, 2024 · 7 comments
Open

Index activation error #8284

ggreggory-hub opened this issue Oct 15, 2024 · 7 comments

Comments

@ggreggory-hub
Copy link

WI-V5.0.1.1469 Firebird 5.0

the sequence of actions:

  1. I am creating a database using the ddl.sql script
  2. I save the database in fbk
  3. I restore from fbk with the option "Deactivate indexes"
  4. I start multithreaded activation of indexes using plume (https://github.com/neozx/plume ):

plume -u SYSDBA -p masterkey -t 8 -d localhost:c:\database.fdb

activation fails with an error, some indexes are not activated. once there was an error "internal Firebird consistency check (partner index description not found (175), file: idx.cpp line: 189)"

ddl.zip

@ibaseru
Copy link

ibaseru commented Oct 15, 2024

seems that this bug related only to plume - it must activate first PK/UNIQUE indices, then FK indices, and only then other indices.

@hvlad
Copy link
Member

hvlad commented Oct 15, 2024

Actual bug is that while plume tries to create indexes in the correct order, it does not control that when creating of the FK is started, the corresponding PK\UK has already been created.

@hvlad hvlad closed this as not planned Won't fix, can't repro, duplicate, stale Oct 15, 2024
@ggreggory-hub
Copy link
Author

I apologize for misleading you. Error "internal Firebird consistency check (partner index description not found (175), file: idx.cpp line: 189)" was given in another example. In this example, this error was not returned.

@hvlad
Copy link
Member

hvlad commented Oct 15, 2024

It is not clear - if current example produce error (which?) or you have another one ?

@ggreggory-hub
Copy link
Author

An example without plume.

run the following bat file on the database obtained in step 1-3 from the top example

fbbug.zip

@hvlad
Copy link
Member

hvlad commented Oct 16, 2024

Will look at it, thanks.
What settings is changed in firebird.conf ?

@hvlad hvlad reopened this Oct 16, 2024
@hvlad
Copy link
Member

hvlad commented Oct 16, 2024

Can't reproduce any error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants