Bug 111929 - Base: firebird plugin does not come up with LibreOffice 32bit
Summary: Base: firebird plugin does not come up with LibreOffice 32bit
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.4.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 111985 (view as bug list)
Depends on:
Blocks:
 
Reported: 2017-08-20 23:49 UTC by mhonline
Modified: 2017-09-19 13:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
engine12 failed to start (81.58 KB, image/jpeg)
2017-08-20 23:49 UTC, mhonline
Details
screenshots inside zip (187.13 KB, application/zip)
2017-08-21 15:59 UTC, mhonline
Details
typo in FB-settings ? (119.46 KB, image/jpeg)
2017-08-22 15:46 UTC, mhonline
Details
java-starting (5.46 KB, text/plain)
2017-09-12 13:25 UTC, mhonline
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mhonline 2017-08-20 23:49:16 UTC
Created attachment 135681 [details]
engine12 failed to start

Well, I know, that firebird is at actual weak, uncomplet and not for wor work, however, the server-engine needs to start allways, not unreproducable casewise. At actual I hace a firebird-odb, which can not be used, because the firebird/Engine12-plugin does not start (btw: whre is the plugin-manager of the old days?)
At actual, the file is treaten as broken and "repair" will result in LO-crash.
pls see attached file

martin
Comment 1 mhonline 2017-08-21 00:02:06 UTC
btw
Although not clearly explained somewhere (in the Wiki?), the concept of fbclient - firebird-sdbcio - firebird/Engine12 - seems to be understandable - when using this inside of LO only. 
However, regarding the weakness of FB within LO at actual, I intend to use(and manipulate)  the same .fbk from within LO and with other tools from the outside. But there seems to be no concept within LO how this can be done, how to use LO as a real frontend. pls put more infos on the wiki. thanks.

m.
Comment 2 Alex Thurgood 2017-08-21 07:14:47 UTC
@mhonline : please describe clearly the steps you are effecting in order to reproduce what you consider to be buggy behaviour - I currently don't understand what you are trying to achieve, nor why you think that this is a problem with LibreOffice.

Setting NEEDINFO until detailed steps enabling reproduction of the issue are provided.
Comment 3 mhonline 2017-08-21 15:55:26 UTC
Do not know what further infos I can give - as you can see, the formerly with LO and FB-embedded made .odb can not be opend and crashed LO. a new test (see attached screenshots) crashed LO immidiatly.

m
Comment 4 mhonline 2017-08-21 15:59:04 UTC
Created attachment 135704 [details]
screenshots inside zip
Comment 5 Alex Thurgood 2017-08-22 07:56:58 UTC
@mhonline :

- the formerly "made-with-LO-embedded-firebird-odb" - are we talking about FB2 or FB3 ?

- FB2 embedded databases are no longer supported in current release versions of LibreOffice see for example bug 104957

- there are a number of already known problems with the embedded Firebird implementation, I am trying to understand whether the problem you are experiencing is one of the already known ones.
Comment 6 Alex Thurgood 2017-08-22 08:00:08 UTC
See also bug 85146, which seems to be similar to what you are describing
Comment 7 mhonline 2017-08-22 15:46:54 UTC
Created attachment 135735 [details]
typo in FB-settings ?

yes, bug 85146 looks quite similar, and as stated there, the errormessage is reflecting the LO-problem with the non-started driver, not comng from the FB-driver itself.

For your guidance:
LO 5.4.0/32 portable on  Win10, with Java 1.8.-131 portable -
FB 3.0(=engine12) (as buildin LO)

btw:
looking into the extended/expert-settings, I found this (see attached). loading a driver by ":*" looks strange.
Comment 8 Alex Thurgood 2017-08-23 07:47:33 UTC
@Tamas : any idea ?
Comment 9 Alex Thurgood 2017-08-23 07:47:52 UTC
Would appear to be windows specific ?
Comment 10 Alex Thurgood 2017-08-23 07:49:13 UTC
@mhonline : Does this also show in the 64bit build of LibreOffice for Windows ? Am wondering whether the problem is just limited to 32bit version ?
Comment 11 Alex Thurgood 2017-08-23 07:51:25 UTC
FWIW, the ODB file you provided in the zip attachment opens fine for me on:

Version: 5.4.0.3
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; 
Locale: fr-FR (fr_FR.UTF-8); Calc: group

so no repro for me.
Comment 12 Alex Thurgood 2017-08-23 07:52:40 UTC
Hmmm, or maybe the problem is with LibreOffice-portable 32bit ?
Comment 13 mhonline 2017-08-24 01:46:29 UTC
FB in LO : I gave it a try with
- LO 527 port under WinXO/32 - works - can not be opend in LO 540/Win10 - FB Version-difference (engine11) - error-message
- LO 5411 under Ubuntu - works - can not be opend in LO in LO 540/Win10 - full crash

test-scenario: 
- open .odb
- try open table for enter data (this is, where the crash happens)
- try open table for change layout

looks as config-problem within LO (LO540/32 on Win10/64-machine)

m.
Comment 14 Tamas Bunth 2017-08-24 08:47:33 UTC
(In reply to mhonline from comment #1)
> However, regarding the weakness of FB within LO at actual, I intend to
> use(and manipulate)  the same .fbk from within LO and with other tools from
> the outside. But there seems to be no concept within LO how this can be
> done, how to use LO as a real frontend. pls put more infos on the wiki.
> thanks.

Do you use these tools simultaneously? Someone here had the same issue:

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

Could you please check that you cannot open the ODB file attached even if there are no other tools running?

'Engine12' is a library containing the database engine, which is loaded by library 'fbclient'. 'fbclient' is loaded by LibreOffice.

From that point of view I'd rather consider this as a bug in Firebird.
Comment 15 Alex Thurgood 2017-08-25 07:13:40 UTC
*** Bug 111985 has been marked as a duplicate of this bug. ***
Comment 16 Alex Thurgood 2017-09-07 09:39:14 UTC
@mhonline : could you answer Tmas' questions please (if possible).

Setting to NEEDINFO
Comment 17 mhonline 2017-09-12 13:24:20 UTC
@ alex t

in parallel testing I gave it a try with LO 5.4. within a virtualbox:
XP Sp3/32 with full install of Java 7-80: worked

open that odb-file on the Host failed and crashed LO immidiatly.
So - for the recap:
  Win10/64 H (build 1703)
  LO 5.4. portable - running as LO 32-bit
  Jportable 1.8-131 
no further tools/data-drivers running, FB is not installed separatly

starting other java-related functions within LO (calc/function-wizzard) works.
What I have is the last log-file from starting java in last session, before LO crashed (see attached (JavaDeployReg.log)

martin
Comment 18 mhonline 2017-09-12 13:25:39 UTC
Created attachment 136199 [details]
java-starting
Comment 19 mhonline 2017-09-19 11:16:58 UTC
The problem seems to be solved with update to 5.4.1 portable, the working .odb-files made with other system-configurations can be opend now. 

martin
Comment 20 Alex Thurgood 2017-09-19 13:31:20 UTC
Per comment 19, WFM. Closing.