<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Database HSQLDB to Firebird automated migration Failure"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127040">127040</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Database HSQLDB to Firebird automated migration Failure
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>paul@sonicviz.com
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>