Description: The program used for the attachment is commit 9ba5eb22, committed 2017-02-04, configured CC=ccache /usr/bin/gcc CXX=ccache /usr/bin/g++ --enable-option-checking=fatal --enable-dbgutil --enable-debug --without-system-postgresql --without-myspell-dicts --with-extra-buildid --without-doxygen --with-external-tar=/home/terry/lo_hacking/git/src --without-package-format built and running on debian-stretch. The observations in the following STR are collected from daily Linux dbgutil bibisect repository version 2017-03-07. Steps to Reproduce: (1) Download attached example.fdb. It is a firebird database with one table with one column and no records. (2) In the download directory, run LO with parameters --norestore --nologo --base. (3) In wizard step 1 "Select Database", click "Connect to existing database" and in the dropdown list select "Firebird File". Click <Next>. (4) In wizard step 2 "Connection settings", in "Datasource URL", type "file://example.fdb" without the quotes. (Yes, I know that this is an invalid URL.) Click <Next>. Observed : The wizard progresses to step 3. Expected : a complaint about the invalid URL. (5) In wizard step 3 "Save and proceed", click "No, do not register the database". Click <Finish>. (6) In "Save as" dialog, navigate to the download directory and enter file name "example". Click <Save>. Observed : The program closes "Save as" dialog, and starts to display the main database window, showing title bar and border, but the rest of the window is transparent. CPU usage is zero. The window does not respond to X-icon on the the toolbar. Expected : The program presents the main database window, complete and responsive. Actual Results: Described in step (6) above. Expected Results: Described in step (6) above. Reproducible: Always User Profile Reset: No Additional Info: Note some minor variations: - The local build shown in the attached gdb run did not get as far as showing a hint of the main database window. - The local build, given URL file://thing.fdb (when thing.fdb does not exist), shows a complete database main window, but it is equally unresponsive. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0
Created attachment 131743 [details] example.fdb
Created attachment 131744 [details] make debugrun with backtrace from hang
Hi Terrence, On my own master debug build : Version: 5.4.0.0.alpha0+ Build ID: 6de4ecbe1372c0242f406d45cf999969616f87dc Threads CPU : 2; Version de l'OS :Mac OS X 10.12.3; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group I see the following error message : Impossible d'établir la connexion à la source de données "FB3testincorrectfileurl". Code d'erreur: 1 firebird_sdbc error: *I/O error during "open O_CREAT" operation for file "/example.fdb" *Error while trying to create file *Permission denied caused by 'isc_create_database' This would appear to be the correct behaviour - I don't get a hang or crash...
Oh. Of course I avoided that error because I created the database myself. To create my database, on a system with firebird 3 installed, I put these commands into exmple_crt.sql ... -- a new database, please connect "example.fdb" ; drop database ; create database "example.fdb"; connect "example.fdb" ; -- and a table create table "authors" ( "author" char (50) primary key ) ; -- That's all, folks. commit ; and ran isql-fb -i example_crt.sql -e
(In reply to Terrence Enger from comment #4) > Oh. Of course I avoided that error because I created the database > myself. > Ah oK, well that's me out for the moment then, I don't have Firebird3 server installed on my OSX machine.
Tamás: can you look at this?
Hi Terrence, is this issue still reproducible in master ?
Thank you for the reminder, Xisco. With daily Linux dbgutil bibisect repository version 2018-01-22 running on debian-buster, when I try to save the new .odb, LO complains: The connection to the data source "a01" could not be established. Error code: 1 firebird_sdbc error: *I/O error during "open O_CREAT" operation for file "/vista/Users/terry/lo_hacking/notes/bug_10xxxx/bug_106427/example.fdb" *Error while trying to create file *File exists caused by 'isc_create_database' and the same problem happens when I try to test connection in the created .odb. The named file does exists, so the bug is that LO is trying to create the file. I am changing bug summary to "failure to diagnose invalid file: URL".
verified with Ubuntu 18.04 and 6.2 Alpha0 build on 6-28 Used the example.odb file from the attachment and started LibreOffice as described, entered the URL exactly as shown in the issue. The error generated is: firebird_sdbc error: *I/O error during "open O_CREAT" operation for file "/home/drew/Desktop/libreofficedev6.2/program/example.fdb" *Error while trying to create file *File exists caused by 'isc_create_database' the URL was translated to the correct file path, but as it says it is not finding it. The example.fdb is in that directory and can be updated (no rights issue). So, open the connection properties and change the url from "file://example.fdb" to "file:///home/drew/Desktop/libreofficedev6.2/program/example.fdb" and of course all is good.
Dear Terrence Enger, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I get results like Drew Jensen (comment # 9) with ... a local build of commit f34a525a, 2019-07-15, configured CC=ccache /usr/bin/gcc CXX=ccache /usr/bin/g++ CCFLAGS=-Wshadow --with-jdk-home=/usr/lib/jvm/default-java --enable-split-debug --enable-gdb-index --enable-ld=gold --enable-option-checking=fatal #--enable-dbgutil --enable-debug --without-system-postgresql --without-myspell-dicts --with-extra-buildid --without-doxygen --with-external-tar=/home/terry/lo_hacking/git/src --without-package-format built and running on debian-buster.
Dear Terrence Enger, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
In a local build of commit 631aa911, built and running on debian-buster, when I try to save the .odb, LO gives the message Error code: 1 firebird_sdbc error: *Unable to complete network request to host "file". *Failed to locate host machine. *The specified name was not found in the hosts file or Domain Name Services. caused by 'isc_create_database' /home/terry/lo_hacking/git/libo6/connectivity/source/drivers/firebird/Util.cxx:68 and LO gives the same message for "Test Connection". I am setting bug status RESOLVED WORKSFORME.