This bug report arises from my poking into bug 117732. These observations are collected from daily Linux dbgutil bibisect repository version 2018-07-01 running on debian-buster. From 2018-07-06 on, the conversion fails silently and the .odb retains the HSQL database. STR --- Once only: (1) Preparation: (1.1) Download date_time_test.zip <https://bugs.documentfoundation.org/attachment.cgi?id=142236> attached to tdf#117732 "Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)" (1.2) extract moreTime_hsql.odb (1.3) rename moreTime_hsql.odb to moreTime_hsql.odb_received Per test: (2) Copy moreTime_hsql.odb_received to moreTime_sql.odb (3) Open moreTime_hsql.odb. Program presents database window. (4) In Database pane, click <Tables>. Program presents dialog Confirm Migration. (5) In Confirm Migration prompt, click <Yes>. Expected: Database window. Table tst_data has 7 rows. Observed: Message firebird_sdbc error: *value exceeds the range for a valid time caused by 'isc_dsql_execute' (6) Click <OK>. Program presents database window. Expected: Table tst_data contains 7 rows. Observed: Table tst_data has only 1 row.
Testing with Version: 6.2.0.0.alpha0+ Build ID: b8658c0e847afe1ed199c5fa7a2dd5d1d61ccbac CPU threads: 4; OS: Mac OS X 10.13.6; UI render: default; Locale: fr-FR (fr_FR.UTF-8); Calc: threaded I see no error message, but then again, no migration is performed, irrespective of the number of times I press on the "Yes" button (Experimental options activated).
Sorry, Alex. I was slow updating bugzilla. This message is not visible now. Bug 119669 reports a message to the terminal instead (and no migration performed). I am leaving this report open in the expectation that this problem will reappear when migration proceeds.
(In reply to Terrence Enger from comment #2) > Sorry, Alex. I was slow updating bugzilla. > > This message is not visible now. Bug 119669 reports a message to the > terminal instead (and no migration performed). > > I am leaving this report open in the expectation that this problem > will reappear when migration proceeds. Which is today - today's build picked up the patch that gets it running again. Using Ubuntu 18.04 and Version: 6.2.0.0.alpha0+ Build ID: dff829e863fd05bedd5bcb713cd80c10fa582932 TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-09-03_05:45:17 The error displayed is: firebird_sdbc error: *value exceeds the range for a valid time caused by 'isc_dsql_execute' Yes only one record is migrated, the other six are dropped.
I have a patch waiting of gerrit: <https://gerrit.libreoffice.org/#/c/60048/>
Terrence Enger committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4d7dd4e1e4e072db8bcfe4d52b8c185187353e74 tdf#119625: coerce migrated Time between 0 and 24 hours It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
A polite ping to Terrence Enger: Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing? Thanks
Thank you, Xisco, for the reminder. I am setting status RESOLVED FIXED. As I am the reporter of the bug, it would normally fall to me to set status VERIFIED FIXED. However, I suggest that someone else should do that with this bug. Julian, would you volunteer for this?
(In reply to Terrence Enger from comment #7) >... > As I am the reporter of the bug, it would normally fall to me to set > status VERIFIED FIXED. However, I suggest that someone else should do > that with this bug. Julian, would you volunteer for this? I can't verify it since I remember that for some tests I did about a fix, it worked, for others it didn't work.
@Julian, Can you recall or recreate the failing tests? I am worried that that bug may not be fixed after all.