why object table is in use?

[ablogic]

When opening a report, table of the report remain in use after closing the report and it is impossible to delete the table
Error:
firebird_sdbc error:
*unsuccessful metadata update
*object TABLE “test2” is in use
caused by
‘DROP TABLE"test2"’

Environment:
Debian buster
LO Version: 6.1.5.2
test_fb.odb

[Ratslinger]

@ablogic,

Have had Firebird embedded running in base for a few years now. Currently on TDF v7.0.3.1 and have used under various deb distros. Have not seen this problem. If you are using a distro version, you may need to report to them.

[ablogic]

@Ratslinger,
Thank you for answer. But i got same problem on W7 + LO 6.1.6.3. So I think it is specific to Firebird embedded. Perhaps a bug?

[Ratslinger]

@ablogic,

Have Firebird embedded in use for multiple years on different OS’s and do not have you problem. Can’t say it is a bug. Would need to see the Base file.

[ablogic]

@Ratslinger,
Can I send my test.odb for testing on your platform?

[Ratslinger]

@ablogic,

Just edit your question and attach there. See → How do I attach a file to my question/answer?

[ablogic]

@Ratsllinger,
OK I attached my test.odb. Thanks for trying on your computer. Just open the report test, close it and then try to delete table test2 (table of the report)

[Ratslinger]

@ablogic,

Just saw your last comment. Deleted my comment. Will examine sample closer.

[Ratslinger]

@ablogic,

Yes it is a bug and you should report here → Bugzilla.

If, after running the report, you close then re-open the Base file, the table can be deleted.

[ablogic]

@Ratsllinger,
Thank you for help. I have reported to bugzilla

[Ratslinger]

@ablogic,

Please post reported Bug # here for others to find.

Also you spell my user name incorrectly - only one l

[ablogic]

@Ratslinger,
Bug number is tdf#138201
Sorry for mispelling your name

[Ratslinger]

@ablogic,

Just edited your comment to apply tdf# before number. For future reference, this sets it as a link.