Bug #99092 Auto Save Bug
Submitted: 27 Mar 2020 3:27 Modified: 23 May 2020 12:36
Reporter: Fernando Spizzca FHS Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.19 OS:Linux (Ubuntu 18.04 x86_64)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[27 Mar 2020 3:27] Fernando Spizzca FHS
Description:
Local server - XAMPP
MySql Workbench - 8.0
Linux Ubuntu - 18.04

Every time i try open or save any file .sql that message show up, "Could not save contents of tab xxxx. basic_filebuf::_M_convert_to_external conversion error: iostream error."

I set the encoding of database char-set to uft8 and collation to utf8_general_ci and also set the local instance Options File with char-set utf8mb4 and collation to utf8mb4_general_ci.

But nothing worked.

How to repeat:
Local server - XAMPP
MySql Workbench - 8.0
Linux Ubuntu - 18.04

Every time i try open or save any file .sql that message show up, "Could not save contents of tab xxxx. basic_filebuf::_M_convert_to_external conversion error: iostream error."

I set the encoding of database char-set to uft8 and collation to utf8_general_ci and also set the local instance Options File with char-set utf8mb4 and collation to utf8mb4_general_ci.

But nothing worked.
[27 Mar 2020 3:31] Fernando Spizzca FHS
Erro

Attachment: Captura de tela de 2020-03-27 00-06-37.png (image/png, text), 167.74 KiB.

[23 Apr 2020 8:24] Liu Yan
How to repeat in my situation:
* Create a table with at lease one Chinese character (probably at least any one multi-bytes characters, I'm not sure), say 
  CREATE TABLE test.COVID19新型冠状病毒 (a INT);
* Right click on the table in MySQL Workbench 8.0.x, then click 'Select Rows - Limit NNN'
* Wait for a few seconds, then this error message box will popup. And, it will popup again in another few seconds if you close this message box.

I guess it could be caused by the multi-bytes characters in tab title, because if I create a new SQL tab (tab title will be named as 'SQL File N') and type some Chinese characters in it, it will not caused this issue.
[23 Apr 2020 8:28] Liu Yan
Screenshot

Attachment: 2020-04-23 16-24-21屏幕截图.png (image/png, text), 55.36 KiB.

[23 Apr 2020 12:36] MySQL Verification Team
Hello Fernando,

Thank you for the bug report.
I tried to reproduce your issue on Ubuntu with workbench 8.0.19 using dummy table mentioned in the bug but I am not seeing any issues at my end. May I request you to provide sample data to reproduce the issue at my end? Thank you.

Regards,
Ashwini Patil
[24 Apr 2020 1:13] Liu Yan
Sample shell script to reproduce this bug

  touch /tmp/señorita小姐姐.mysql.sql
  touch /tmp/senorita.mysql.sql
  mysql-workbench /tmp/señorita小姐姐.mysql.sql
  mysql-workbench /tmp/senorita.mysql.sql

The file name contains 'ñ' character or other multi-bytes characters will trigger this bug at once when the file is opened via `mysql-workbench /tmp/señorita小姐姐.mysql.sql` command.

The file name without multi-byte characters ( /tmp/senorita.mysql.sql ) will not trigger this bug.
[24 May 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[14 Jun 2020 3:14] Krishnamurtir Amorim Furtado krisfurtado
My OS is Linux Fedora31 and the system language is Portuguese-brazil, so in portuguese language Desktop is Área de trabalho and the folder path  is "/home/user/Área\ de\ trabalho/".

To avoid this problem I changed the folder to "/home/user/Documentos" (Withou space and signs) .

It Worked for me.
[29 Oct 2020 11:20] Valdis Vitolins
I also got similar problem.
[29 Oct 2020 11:22] Valdis Vitolins
My system is Ubuntu 20.04, MySQL workbench 8.0.21.
[24 Sep 2021 6:57] Jialiang Wu
My system is manjaro20 ,Mysql is 8.0.21,and got the same bug.
[24 Nov 2021 22:01] LUCIANO BATISTA
Had the same problem with Ubuntu 20.04
In my case, this happened when I opened the files from the "Downloads" location. Put the file you are opening in the "Documents" directory for example and try to open it from there. For me it solved the bug
[12 Jan 2022 21:58] Jorick Pepin
Thank you Luciano, it worked for me !
[1 Nov 2022 9:30] Pixelia Builder
Same issue Ubuntu 20.04.4 LTS.
When save SQL-file to folder with cyrilic letters in path occurs this error:
MySQL Workbench Could not save contents of tab ... basic_filebuf::_M_convert_to_external conversion error: iostream error
[5 Jan 2023 0:52] Olaf Sikorskij
Hello dear, on my Ubuntu 22.04.1 the same problem. Cyrillic letters in address of sql script causes Auto-save bug.

The newest Workbench 
 mysql-workbench-community_8.0.31-1ubuntu22.04_amd64.deb
installed.