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

Report more details for "object in use" errors [CORE4386] #4708

Closed
firebird-issue-importer opened this issue Apr 5, 2014 · 11 comments
Closed

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Apr 5, 2014

Submitted by: @dyemanov

Block progress on QA600

Votes: 3

While a proper metadata naming convention surely helps, the engine could be polite enough to report not only the name of the used object but its type (table/index/procedure/etc) as well. Also, for used indices currently a string "INDEX" is reported instead of the index name.

Thinking about this more, it would be great to have an original DDL command (or at least its shorthand) reported for any DFW error happening during commit. This would radically simplify debugging of multi-command DDL scripts.

Commits: fa22d85 6296318 a24fa92 FirebirdSQL/fbt-repository@4cbbdb1 FirebirdSQL/fbt-repository@9d08d40 FirebirdSQL/fbt-repository@b2cac4d

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 5, 2014

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 5, 2014

Commented by: @dyemanov

The simplest solution (e.g. "object INDEX "TEST_PK" is in use") is committed into v2.1 and v2.5, a more advanced solution is to be developed for v3.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 5, 2014

Modified by: @dyemanov

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 2.1.6 [ 10460 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 9, 2014

Modified by: @dyemanov

Fix Version: 3.0 Beta 2 [ 10586 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 21, 2014

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 3, 2015

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Deferred

Test Details: Question in rus. forum: http://sql.ru/forum/1159875/vliyanie-commit-rollback-empty-line-pri-ddl-oshibkah-vnutri-execute-block-ah-na-stderr

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 25, 2015

Modified by: @pcisar

Link: This issue block progress on QA600 [ QA600 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 23, 2018

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

Test Details: Question in rus. forum: http://sql.ru/forum/1159875/vliyanie-commit-rollback-empty-line-pri-ddl-oshibkah-vnutri-execute-block-ah-na-stderr => Sent letter to dimitr, 19.06.2018 09:33 (checked on WI-V3.0.4.32988)
Empty name of procedure which is to be dropped but currently is used by another transaction, i.e.:

- lock conflict on no wait transaction
- unsuccessful metadata update
- object PROCEDURE "" is in use

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 7, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

Test Details: Sent letter to dimitr, 19.06.2018 09:33 (checked on WI-V3.0.4.32988)
Empty name of procedure which is to be dropped but currently is used by another transaction, i.e.:

- lock conflict on no wait transaction
- unsuccessful metadata update
- object PROCEDURE "" is in use

=>

Empty name of procedure which is to be dropped but currently is used by another transaction, i.e.:

- lock conflict on no wait transaction
- unsuccessful metadata update
- object PROCEDURE "" is in use

Sent letter to dimitr, 19.06.2018 09:33 (checked on WI-V3.0.4.32988).
Still reproduced on WI-V3.0.6.33240; WI-T4.0.0.1763 (07.02.2020).

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 7, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Deferred => Done successfully

Test Details: Empty name of procedure which is to be dropped but currently is used by another transaction, i.e.:

- lock conflict on no wait transaction
- unsuccessful metadata update
- object PROCEDURE "" is in use

Sent letter to dimitr, 19.06.2018 09:33 (checked on WI-V3.0.4.32988).
Still reproduced on WI-V3.0.6.33240; WI-T4.0.0.1763 (07.02.2020).

=>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 7, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

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

No branches or pull requests

2 participants