[Libreoffice-bugs] [Bug 127040] New: Database HSQLDB to Firebird automated migration Failure

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127040
           Summary: Database HSQLDB to Firebird automated migration
                    Failure
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: paul at sonicviz.com

Description:
Get the following errors trying to migrate a database to Firebird.

I suspect the first two below are caused by the third one:
*unsuccessful metadata update
*new record size of 116772 bytes is too big

I don't think you should be forcing a new database change like this unless it
is 100% stable. This seems extremely flaky to replace a perfectly working db
engine with one where a. it doesn't even migrate successfully and b. doesn't
migrate forms etc. 

>From HSQLDB to Firebird automated migration

Error code: 1

firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Table1 failed
*SQL error code = -607
*Invalid command
*Table Table1 does not exist
caused by
'ALTER TABLE "Table1" ALTER COLUMN "ID" RESTART WITH 140'

Error code: 1

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -204
*Table unknown
*Table1
*At line 1, column 8
caused by
'isc_dsql_prepare'

Error code: 1

firebird_sdbc error:
*unsuccessful metadata update
*new record size of 116772 bytes is too big
*TABLE Table1
caused by
'CREATE TABLE "Table1" ( "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START
WITH -1), "Song#" VARCHAR(255), "SongID" VARCHAR(255), "SongName" VARCHAR(255),
"SongGenre" VARCHAR(255), "SongKey" VARCHAR(255), "SongBPM" VARCHAR(255),
"SongNotes" VARCHAR(1000), "MasterEffect" VARCHAR(255), "MasterPatch"
VARCHAR(255), "VocalEffects" VARCHAR(255), "VocalPatch" VARCHAR(255),
"VocalNotes" VARCHAR(1000), "GuitarType" VARCHAR(255), "GuitarTuning"
VARCHAR(255), "GuitarKey" VARCHAR(255), "GuitarEffects" VARCHAR(255),
"GuitarPatch" VARCHAR(255), "GuitarNotes" VARCHAR(1000), "HarpKey"
VARCHAR(255), "HarpPosition" VARCHAR(255), "HarpEffects" VARCHAR(255),
"HarpPatch" VARCHAR(255), "HarpNotes" VARCHAR(1000), "BassUsedFlag" BOOLEAN,
"BassInstrument" VARCHAR(255), "BassPatch" VARCHAR(255), "BassNotes"
VARCHAR(1000), "DrumsUsedFlag" BOOLEAN, "DrumInstrument" VARCHAR(255),
"DrumPatch" VARCHAR(255), "DrumNotes" VARCHAR(1000), "DAWNotes" VARCHAR(1000),
"SongLyrics1" VARCHAR(5000), "SongLyrics2" VARCHAR(5000), "SongLyrics3"
VARCHAR(5000), "OnlineCollabFlag" BOOLEAN, "OnlineCollabNotes" VARCHAR(1000),
"Copyright" VARCHAR(255), "OriginalFlag" BOOLEAN, "PublicDomainFlag" BOOLEAN,
"TimeSig" VARCHAR(50),PRIMARY KEY("ID"))'


Steps to Reproduce:
1.Open database
2.Try to migrate to Firebird from HSQLDB
3.FAIL to migrate

Actual Results:
Error code: 1

firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Table1 failed
*SQL error code = -607
*Invalid command
*Table Table1 does not exist
caused by
'ALTER TABLE "Table1" ALTER COLUMN "ID" RESTART WITH 140'

Error code: 1

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -204
*Table unknown
*Table1
*At line 1, column 8
caused by
'isc_dsql_prepare'

Error code: 1

firebird_sdbc error:
*unsuccessful metadata update
*new record size of 116772 bytes is too big
*TABLE Table1
caused by
'CREATE TABLE "Table1" ( "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START
WITH -1), "Song#" VARCHAR(255), "SongID" VARCHAR(255), "SongName" VARCHAR(255),
"SongGenre" VARCHAR(255), "SongKey" VARCHAR(255), "SongBPM" VARCHAR(255),
"SongNotes" VARCHAR(1000), "MasterEffect" VARCHAR(255), "MasterPatch"
VARCHAR(255), "VocalEffects" VARCHAR(255), "VocalPatch" VARCHAR(255),
"VocalNotes" VARCHAR(1000), "GuitarType" VARCHAR(255), "GuitarTuning"
VARCHAR(255), "GuitarKey" VARCHAR(255), "GuitarEffects" VARCHAR(255),
"GuitarPatch" VARCHAR(255), "GuitarNotes" VARCHAR(1000), "HarpKey"
VARCHAR(255), "HarpPosition" VARCHAR(255), "HarpEffects" VARCHAR(255),
"HarpPatch" VARCHAR(255), "HarpNotes" VARCHAR(1000), "BassUsedFlag" BOOLEAN,
"BassInstrument" VARCHAR(255), "BassPatch" VARCHAR(255), "BassNotes"
VARCHAR(1000), "DrumsUsedFlag" BOOLEAN, "DrumInstrument" VARCHAR(255),
"DrumPatch" VARCHAR(255), "DrumNotes" VARCHAR(1000), "DAWNotes" VARCHAR(1000),
"SongLyrics1" VARCHAR(5000), "SongLyrics2" VARCHAR(5000), "SongLyrics3"
VARCHAR(5000), "OnlineCollabFlag" BOOLEAN, "OnlineCollabNotes" VARCHAR(1000),
"Copyright" VARCHAR(255), "OriginalFlag" BOOLEAN, "PublicDomainFlag" BOOLEAN,
"TimeSig" VARCHAR(50),PRIMARY KEY("ID"))'


Expected Results:
Successful table migration


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190820/555ec3aa/attachment.html>