Bug 77902 - Device I/O error when appending to log file from Linux to Samba share
Summary: Device I/O error when appending to log file from Linux to Samba share
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Network
  Show dependency treegraph
Reported: 2014-04-24 17:03 UTC by Jeff H
Modified: 2020-10-22 04:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

Attempts an append to a log file on a Samba share (9.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-24 17:03 UTC, Jeff H
BasicIOError.png: screenshot of the error message from 6.0alpha1 (6.74 KB, image/png)
2017-10-21 16:16 UTC, Justin L

Note You need to log in before you can comment on or make changes to this bug.
Description Jeff H 2014-04-24 17:03:35 UTC
Created attachment 97912 [details]
Attempts an append to a log file on a Samba share

Running LO (release version) on Linux Mint 16, when I run LO BASIC code that attempts to append some text to a log file on a Samba share, I get a Device I/O error. No, there are no access or permission issues - I can read the log file just fine, and I can create files in that directory using Nautilus.

The attached Calc file has a button that runs some sample code. On my network, I can run the program fine from a Windows machine - it reads the first few lines from the log file, then appends a line at the end of the log file. When I run the code on a Linux machine, the following line gives me a Device I/O error:

Open sPath For Append As #1

But the Open sPath For Input As #1 just above that line works fine.

Obviously if others want to test this code, you would need to change the path to a Samba server that you have access to on your network. On my Linux systems, I access our server using smb://cdb.sil.org/server. Just FYI, the ConvertToURL line in the code changes the "//cdb.sil.org/server" path to different things on different OS's. On Windows it changes it to "file://cdb.sil.org/server" and on Linux it changes it to "smb://cdb.sil.org/server".

This is NOT a duplicate of bug#67527. I also had some problems with LO not creating lock files on our Samba share and applied the workaround in Comment #15, and that solved that problem. With that workaround applied, however, the bug described here still occurs.
Comment 1 Jeff H 2014-05-16 10:46:23 UTC
I have found a work-around to this bug, but it is messy and probably very dependent on the version of Linux being used. The work-around is described here:

I would appreciate it if someone could confirm this bug, so that maybe we could move towards a solution.

To recap, I access our server from Calc BASIC with a path like this: "file://cdb.sil.org/server/folder/file". I run this path through ConvertToURL before using it; on Windows machines the "file:" prefix stays the same, on Linux machines it changes to "smb:". In this way, all of our API file accesses to our server (StoreAsURL, StoreToURL, LoadComponentFromURL, etc.) work on both systems. But if I use the basic Open For Append or Open For Output BASIC commands with these same paths, Linux access to the "smb://cdb..." paths will fail with a Device I/O error. I can use Open For Input with the "smb://cdb..." paths successfully, but not Append or Output.

My work-around starts with the fact that any Linux "smb://" access on a mounted share actually has a "normal" file access somewhere in the system, if you can find it. On our Linux Mint 16 systems, the Samba file access to our server gets converted at some level to this "normal" Linux path:


So my work-around code manually builds up this server path, and whenever I want to use smb:// (which LibreOffice refuses to convert for the Open Append or Output commands), I manually put in this long, messy path for direct access to the file.
Comment 2 Joel Madero 2014-11-20 18:33:38 UTC
Jeff - I'm going to attempt this one probably over the weekend (no promise though...might be December as I'm swamped). That being said - clearer reproducible steps would be helpful....I don't use Samba generally so I'll be setting it up and what not....assume I know nothing - how do I reproduce the problem.
Comment 3 Justin L 2014-11-21 05:25:04 UTC
This also happens against a regular windows share - so you can test without Samba.  Just have a windows machine available with a share that you can interactively browse to "smb://myServer/myShare" in your file manager.

Steps I took to reproduce.
1.)  Open Test Append.ods
2.)  Edit Macros (Tools->Macros->Organize Macros->LibreOffice Basic, Edit Main macro in Module1
3.)  change 	sPath = "//<myServer>/<myShare>/"
4.)  Run Macro

Msgbox:  smb://myServer/myShare/Reconcile.log  (OK)
crash to Macro IDE on line "Open sPath For Append As #1":  LibreOffice  BASIC runtime error. Device I/O error. (OK)
Comment 4 Jeff H 2014-11-21 14:19:20 UTC
Thanks for your efforts to fix this bug. I am not in a place right now where I have the equipment to be able to test this bug. Hopefully Justin's comments can help you move things along.
Comment 5 Joel Madero 2014-11-21 16:38:35 UTC
What about if you mount the server share through fstab? Does it also happen with NFS?
Comment 6 Joel Madero 2014-11-21 17:26:58 UTC
I'm still really confused about this one. I changed the location to a local folder and got the same error...are we 100% sure that this is related to anything dealing with a network? Have either one of you tried pointing it to a local folder to see what happens?
Comment 7 Justin L 2014-11-21 19:00:42 UTC
I tried pointing to /tmp (sPath = "/tmp/") and it works.

I tried pointing incorrectly (sPath = "/tmp") without the ending slash, and get the same "Basic Runtime Error. Device I/O Error." since it is trying to write to the root directory where I have no permission.

OK.  Back to network stuff.
If I mount the path, it works.  (mount -o username=myuser,password=mypassword,uid=myUnixName "//myServer/myShare" /mnt/myMount) [sPath = "/mnt/myMount/"].   Reconcile.log is read and appended to with no error message.

If I browse with Nautilus/Nemo to "smb://myServer/myShare", verify that I can access and write to Reconcile.log, and then set sPath = "//myServer/myShare/", I get the error.

P.S.  For this macro example to work, either Reconcile.log should NOT already exist, or else it should have AT LEAST three lines in it.  Otherwise you will get an error about not being able to read the first three lines before even getting to the "append" error.  (The error message is different: Reading exceeds EOF.)

About NFS:  Sorry - I've never setup or used NFS.
Comment 8 Justin L 2014-11-21 19:13:51 UTC
/etc/fstab worked fine too.

//myServer/myShare    /mnt/myMount    cifs    username=myUser,password=myPassword,uid=myUnixName
Comment 9 QA Administrators 2015-12-20 16:10:04 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2017-01-03 19:47:23 UTC Comment hidden (obsolete, spam)
Comment 11 Justin L 2017-10-21 16:16:18 UTC
Created attachment 137189 [details]
BasicIOError.png: screenshot of the error message from 6.0alpha1

bibisect43all shows that this has always happened.  Still happening in Ubuntu 16.04 and LO6.0alpha1.
Comment 12 QA Administrators 2018-10-22 02:51:05 UTC Comment hidden (obsolete, spam)
Comment 13 QA Administrators 2020-10-22 04:29:51 UTC
Dear Jeff H,

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