[Libreoffice-bugs] [Bug 121069] New: "unsuccessful metadata update" during migration to Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121069

            Bug ID: 121069
           Summary: "unsuccessful metadata update" during migration to
                    Firebird
           Product: LibreOffice
           Version: 6.2.0.0.alpha1+ Master
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lo_bugs at iseries-guru.com

This arises from poking into bug 120126, which is reported for Mac
OS/X.  Perhaps this is the same bug showing up differently and earlier
in Linux.

My observations are on debian-buster and daily Linux dbgutil bibisect
repository version 2018-10-30, commit 2e184378:

    Version: 6.2.0.0.alpha1+
    Build ID: 2e184378da6058af14acf208d6469fadf44d04ed
    CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3; 
    Locale: en-CA (en_CA.utf8); Calc: threaded

STR

(0) Download Iglesias_before.odb, "ddbb before migrating"
    <https://bugs.documentfoundation.org/attachment.cgi?id=145480"
    attached to bug 120126 "Base error after migrating to Firebird".

(1) Open the downloaded file. Observe in status bar of the database
    window "HSQLDB Embedded".

(2) In Database pane, click <Tables>.  Program presents dialog
    "Confirm Migration".

(3) At prompt "Confirm Migration" click <Yes>.

    Expected:
        An embedded Firebird database with some tables showing in the
        lower right pane.

    Observed:
        Terminal messages
           
warn:connectivity.firebird:22678:22678:connectivity/source/drivers/firebird/Statement.cxx:122:
isc_dsql_execute failed
           
warn:connectivity.firebird:22678:22678:connectivity/source/drivers/firebird/Util.cxx:55:
firebird_sdbc error:
            *unsuccessful metadata update
            *ALTER TABLE Iglesias failed
            *Unknown columns in index SYS_FK_78
            caused by
            'ALTER TABLE "Iglesias" ADD CONSTRAINT SYS_FK_78 FOREIGN
KEY("Denominaci\u00f3n") REFERENCES "Denominaciones"("ID")'

           
warn:dbaccess:22678:22678:dbaccess/source/filter/hsqldb/hsqlimport.cxx:372:
Error during migration
        and 
            message box with the database error messages.

(4) In dialog click <OK>.  The status bar shows "Firebird Embedded"
    and the Tables pane shows 5 tables.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181030/ae433c4d/attachment.html>