MySQL Bugs: #60276: Error executing task 'ascii' codec can't decode byte 0xe6 in position 2: ordinal

Bug #60276	Error executing task 'ascii' codec can't decode byte 0xe6 in position 2: ordinal
Submitted:	28 Feb 2011 9:08	Modified:	22 Jul 2013 2:33
Reporter:	a a	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S1 (Critical)
Version:	5.2.33, 5.2.36, 5.2.37, 5.2.40	OS:	Any (fedora14, Windows)
Assigned to:		CPU Architecture:	Any
Tags:	export to self-contained file

Description:
Error executing task 'ascii' codec can't decode byte 0xe6 in position 2: ordinal not in range(128)
16时55分26秒 Export of /home/fengchen/dumps/Dump20110228.sql has finished

How to repeat:
no

can you attach a list of the schema names and objects that are being dumped?

i686
The dbs are default.

Please, check if this problem is still repeatable with a newer version, 5.2.33.

log

Attachment: wb.log (application/octet-stream, text), 4.78 KiB.

There is still a error

As requested above, please attach the list of schema names being dumped. Preferably a full dump of schema info, created with mysqldump.

As requested above, please attach the list of schema names being dumped. Preferably a full dump of schema info, created with mysqldump.

backup files of all the dbs.my fedora14 LANG=zh_CN

Attachment: mysql_back.dbs (application/octet-stream, text), 491.10 KiB.

Please, check if this problem still happens with a newer version, 5.2.34. If it does, please, specify the exact server version used, x.y.z.

i also meet this problem
the logs:
--------------------------------
10:18:03 Dumping aajm (veet_t)

Error executing task: 'ascii' codec can't decode byte 0xd6 in position 32: ordinal not in range(128)

Error executing task [Error 32] : 'c:\\users\\\xd6\xec\xce\xc4\xe7\xf7\\appdata\\local\\temp\\tmp2hdzj4.cnf'

10:18:03 Export of E:\8-8.sql has finished

seems that if the task temp folder cotains utf8 character, the execution will fail, and i have no way to change the task temp folder.

Please check version 5.2.35. Thanks.

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".

09:53:17 Restoring C:\Users\实验室\Desktop\zhao\zhao.sql

Error executing task: 'ascii' codec can't decode byte 0xca in position 32: ordinal not in range(128)

Error executing task [Error 32] : 'c:\\users\\\xca\xb5\xd1\xe9\xca\xd2\\appdata\\local\\temp\\tmpfxju01.cnf'

09:53:18 Import of C:\Users\实验室\Desktop\zhao\zhao.sql has finished

5.2.36

The self-contained file is exported on a Win 7 machine 
it's OK to import it on a Win 7 machine, but when I try to import it on my vista machine , I encounter this error

Please try version 5.2.37. Thanks.

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".

still get error
Error executing task: 'ascii' codec can't decode byte 0xd6 in position 34: 
ordinal not in range(128)

mysql workbench 5.2.37
win 7
my windows is chinese

Hi:

We are unable to reproduce this bug in WB 5.2.37. Can you give us more details so we can work on this? We have tried both exporting and importing with non-ASCII paths and everything works normally.

Can you paste here whatever is shown in the output window (View -> Output in main menu)?

Other than your OS being in Chinese, can you think of any other thing language related or unusual that might be triggering this behavior?

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".

Workbench: 5.2.40 CE Rev. 8790, running on XP Pro SP3 (eng)
MySQL: 5.1.61-0+squeeze1

21:54:08 Dumping XXXXXXXXXXX (comment)
Running: mysqldump.exe --defaults-extra-file="c:\docume~1\admini~1\locals~1\temp\tmp4qlari.cnf"  --max_allowed_packet=1G --host=XXXXXXXXX --flush-logs=TRUE --user=XXXXXX --port=3306 --default-character-set=utf8 "XXXXXXXX" "comment"
Error executing task: 'ascii' codec can't encode character u'\xa4' in position 9: ordinal not in range(128)
Error executing task [Error 32] The process cannot access the file because it is being used by another process: 'c:\\docume~1\\admini~1\\locals~1\\temp\\tmp4qlari.cnf'
21:54:09 Export of c:\temp\dp2 has finished

I'm running my Workbench on a vmware virtual machine....I can put it on my server for you to download to reproduce the problem ;-) ?

Does the schema or object names you're dumping have any non-ascii character? What are they?

See prior question.

I have the same problem using MySQL Workbench 5.2.42 win32 and MySQL Server 5.5.27 x64 on Windows 7 x64 SP1 Chinese.

All object names (schema name, table names, field names and export path) are English, only some field contents are UTF-8.
The original dump file was exported from Workbench 5.2.35 and MySQL Server 5.5.16 running on XP SP3. 
It can be imported to Win 7 machine without problem.

Error reported when exporting:
Unhandled exception: 'ascii' codec can't decode byte 0xa4 in position 10: ordinal not in range(128)

Tried upgrade Workbench on XP Chinese to 5.2.42, it can successfully export data (remotely) from MySQL Server 5.5.27 running on Windows 7 x64 Chinese.
That means the problem only occurs when Workbench win32 running on Windows 7 x64 Chinese OS. 
Just select the option "Data Export" will produce the error, nothing to do with a particular schema.

Rayson, does your username contain chinese chars? Anything in your program files or users folder paths?

Alfredo, thanks for your reply!
The user name and all folder names (all default path) are English. However the user's home folder path (such as Users and Documents) are displayed in Chinese characters when viewing under Windows Explorer. Using command line interface, I can cd C:\Users\username\Documents\Dumps directly. The display of Chinese characters should be Explorer's own feature under Chinese Windows 7 rather than the actual path.

Rayson, what about time values? Do they show with hour/min/sec captions in chinese?

Also, what if you change the date format in Windows Control panel to English instead of Chinese? Does the problem still occur?

Changed date and time format to UK (English) and reboot. Same error message returned.

Alfredo, I followed your line of thought and changed Non Unicode Program Language to UK English. The error message on clicking Data Export was gone. Seems like the code page information for Workbench is causing the problem. You can try change it to Unicode.

However, another error pop up after I selected a schema and run the export:

Error Checking mysqldump.exe Version
Could not parse version number from mysqldump.exe:
'cmd.exe' is not recognized as an internal or external command, operable program or batch file.

I can still go to command prompt by entering "cmd" from Start though.

Any fix available?

Please try version 5.2.47. Thanks.

I had this same error when importing into workbench.

My database password (the one it asks for when your start import) contained a "£" character, I removed it and import worked fine.

So if your MySQL password has these type of characters try changing or removing it. 

Thanks

Mark
www.assertdesign.co.uk

I don't have special character in password. Tried 5.2.47, problem fixed. Thanks!

Original reporter, can you confirm whether it's working in 5.2.47, as Rayson has reported?

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".