| Bug #32102 | Problem with resultset output as XLS | ||
|---|---|---|---|
| Submitted: | 5 Nov 2007 11:24 | Modified: | 26 May 2009 13:15 |
| Reporter: | Slava Vetluzhskikh | Email Updates: | |
| Status: | Unsupported | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S3 (Non-critical) |
| Version: | 1.2.12 | OS: | Linux (ASPLinux 11.2) |
| Assigned to: | CPU Architecture: | Any | |
[9 Nov 2007 16:06]
MySQL Verification Team
Thank you for the bug report. On Fedora Core 6.0 32-bit it creates the .xls file but quits with the below backtrace: [miguel@skybr ~]$ mysql-query-browser *** glibc detected *** /usr/bin/mysql-query-browser-bin: munmap_chunk(): invalid pointer: 0x0828cc1a *** ======= Backtrace: ========= /lib/libc.so.6(cfree+0x1bb)[0xb9a67b] /lib/libglib-2.0.so.0(g_free+0x31)[0xd0a5f1] /usr/bin/mysql-query-browser-bin[0x8188ae4] /usr/bin/mysql-query-browser-bin[0x819bd2e] /usr/bin/mysql-query-browser-bin[0x80acc29] /usr/bin/mysql-query-browser-bin[0x80ccc69] /usr/lib/libglibmm-2.4.so.1(_ZN4Glib17SignalProxyNormal19slot0_void_callbackEP8_GObjectPv+0x4a)[0xa8a57a] /lib/libgobject-2.0.so.0(g_cclosure_marshal_VOID__VOID+0x49)[0xd9b259] /lib/libgobject-2.0.so.0(g_closure_invoke+0x12b)[0xd8df0b] /lib/libgobject-2.0.so.0[0xd9f171] /lib/libgobject-2.0.so.0(g_signal_emit_valist+0x89f)[0xda037f] /lib/libgobject-2.0.so.0(g_signal_emit+0x29)[0xda0539] /usr/lib/libgtk-x11-2.0.so.0(gtk_widget_activate+0x94)[0x329a4b4] /usr/lib/libgtk-x11-2.0.so.0(gtk_menu_shell_activate_item+0x118)[0x318edc8] /usr/lib/libgtk-x11-2.0.so.0[0x3190392] /usr/lib/libgtk-x11-2.0.so.0[0x3187f65] /usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk12Widget_Class29button_release_event_callbackEP10_GtkWidgetP15_GdkEventButton+0x5b)[0x503481b] /usr/lib/libgtk-x11-2.0.so.0[0x31820c0] /lib/libgobject-2.0.so.0[0xd8c6f9] /lib/libgobject-2.0.so.0(g_closure_invoke+0x12b)[0xd8df0b] /lib/libgobject-2.0.so.0[0xd9f4d3] /lib/libgobject-2.0.so.0(g_signal_emit_valist+0x667)[0xda0147] /lib/libgobject-2.0.so.0(g_signal_emit+0x29)[0xda0539] /usr/lib/libgtk-x11-2.0.so.0[0x3296118] /usr/lib/libgtk-x11-2.0.so.0(gtk_propagate_event+0x183)[0x317b563] /usr/lib/libgtk-x11-2.0.so.0(gtk_main_do_event+0x317)[0x317c767] /usr/lib/libgdk-x11-2.0.so.0[0x2f3c0ea] /lib/libglib-2.0.so.0(g_main_context_dispatch+0x182)[0xd03342] /lib/libglib-2.0.so.0[0xd0631f] /lib/libglib-2.0.so.0(g_main_loop_run+0x1a9)[0xd066c9] /usr/lib/libgtk-x11-2.0.so.0(gtk_main+0xb4)[0x317cbe4] /usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk4Main8run_implEv+0x17)[0x4fba047] /usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk4Main3runEv+0x22)[0x4fb9e32] /usr/bin/mysql-query-browser-bin[0x807363c] /lib/libc.so.6(__libc_start_main+0xdc)[0xb46f2c] /usr/bin/mysql-query-browser-bin[0x8070b11] ======= Memory map: ======== 00101000-00110000 r-xp 00000000 03:03 386090 /usr/lib/libXext.so.6.4.0 00110000-00111000 rwxp 0000e000 03:03 386090 /usr/lib/libXext.so.6.4.0 00113000-0013a000 r-xp 00000000 03:03 386081 /usr/lib/libfontconfig.so.1.1.0 0013a000-00142000 rwxp 00027000 03:03 386081 /usr/lib/libfontconfig.so.1.1.0 00144000-0015a000 r-xp 00000000 03:03 386077 /usr/lib/libgdk_pixbuf-2.0.so.0.1000.4 0015a000-0015b000 rwxp 00016000 03:03 386077 /usr/lib/libgdk_pixbuf-2.0.so.0.1000.4 0015b000-0015f000 r-xp 00000000 03:03 621114 /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so 0015f000-00160000 rwxp 00003000 03:03 621114 /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so 00162000-0017b000 r-xp 00000000 03:03 4543929 /lib/ld-2.5.so 0017b000-0017c000 r-xp 00018000 03:03 4543929 /lib/ld-2.5.so 0017c000-0017d000 rwxp 00019000 03:03 4543929 /lib/ld-2.5.so 0017f000-00194000 r-xp 00000000 03:03 4543948 /lib/libselinux.so.1 00194000-00196000 rwxp 00014000 03:03 4543948 /lib/libselinux.so.1 00198000-001d3000 r-xp 00000000 03:03 4543947 /lib/libsepol.so.1 001d3000-001d4000 rwxp 0003b000 03:03 4543947 /lib/libsepol.so.1 001d4000-001de000 rwxp 001d4000 00:00 0 001e0000-001f2000 r-xp 00000000 03:03 4543941 /lib/libnsl-2.5.so 001f2000-001f3000 r-xp 00012000 03:03 4543941 /lib/libnsl-2.5.so 001f3000-001f4000 rwxp 00013000 03:03 4543941 /lib/libnsl-2.5.so 001f4000-001f6000 rwxp 001f4000 00:00 0 001f8000-00207000 r-xp 00000000 03:03 4543943 /lib/libresolv-2.5.so 00207000-00208000 r-xp 0000e000 03:03 4543943 /lib/libresolv-2.5.so 00208000-00209000 rwxp 0000f000 03:03 4543943 /lib/libresolv-2.5.so 00209000-0020b000 rwxp 00209000 00:00 0 0020d000-00329000 r-xp 00000000 03:03 4543945 /lib/libcrypto.so.0.9.8b 00329000-0033b000 rwxp 0011c000 03:03 4543945 /lib/libcrypto.so.0.9.8b 0033b000-0033f000 rwxp 0033b000 00:00 0 00341000-00343000 r-xp 00000000 03:03 4543944 /lib/libcom_err.so.2.1 00343000-00344000 rwxp 00001000 03:03 4543944 /lib/libcom_err.so.2.1 00346000-003ba000 r-xp 00000000 03:03 4543942 /lib/libdbus-1.so.3.0.0 003ba000-003bb000 rwxp 00073000 03:03 4543942 /lib/libdbus-1.so.3.0.0 003bd000-00442000 r-xp 00000000 03:03 386114 /usr/lib/libkrb5.so.3.2 00442000-00444000 rwxp 00084000 03:03 386114 /usr/lib/libkrb5.so.3.2 00446000-0044d000 r-xp 00000000 03:03 386112 /usr/lib/libkrb5support.so.0.1 0044d000-0044e000 rwxp 00006000 03:03 386112 /usr/lib/libkrb5support.so.0.1 00450000-0047a000 r-xp 00000000 03:03 386115 /usr/lib/libgssapi_krb5.so.2.2 0047a000-0047b000 rwxp 00029000 03:03 386115 /usr/lib/libgssapi_krb5.so.2.2 0047d000-004a2000 r-xp 00000000 03:03 386113 /usr/lib/libk5crypto.so.3.0 004a2000-004a3000 rwxp 00025000 03:03 386113 /usr/lib/libk5crypto.so.3.0 004a5000-004a8000 r-xp 00000000 03:03 4543940 /lib/libcap.so.1.10 004a8000-004a9000 rwxp 00002000 03:03 4543940 /lib/libcap.so.1.10 004ab000-004af000 r-xp 00000000 03:03 4541606 /lib/libgthread-2.0.so.0.1200.3 004af000-004b0000 rwxp 00003000 03:03 4541606 /lib/libgthread-2.0.so.0.1200.3 004b2000-004f3000 r-xp 00000000 03:03 4543946 /lib/libssl.so.0.9.8b 004f3000-004f7000 rwxp 00040000 03:03 4543946 /lib/libssl.so.0.9.8b 004f9000-00500000 r-xp 00000000 03:03 386125 /usr/lib/libpopt.so.0.0.0 00500000-00501000 rwxp 00006000 03:03 386125 /usr/lib/libpopt.so.0.0.0 00503000-0051f000 r-xp 00000000 03:03 386111 /usr/lib/libdbus-glib-1.so.2.0.0 0051f000-00520000 rwxp 0001c000 03:03 386111 /usr/lib/libdbus-glib-1.so.2.0.0 00522000-00570000 r-xp 00000000 03:03 386109 /usr/lib/libORBit-2.so.0.1.0 00570000-0057a000 rwxp 0004d000 03:03 386109 /usr/lib/libORBit-2.so.0.1.0 0057c000-005af000 r-xp 00000000 03:03 386110 /usr/lib/libgconf-2.so.4.1.0 005af000-005b2000 rwxp 00032000 03:03 386110 /usr/lib/libgconf-2.so.4.1.0 005b4000-005b6000 r-xp 00000000 03:03 4543949 /lib/libutil-2.5.so 005b6000-005b7000 r-xp 00001000 03:03 4543949 /lib/libutil-2.5.so 005b7000-005b8000 rwxp 00002000/usr/bin/mysql-query-browser: line 103: 1935 Aborted $PRG-bin $args [miguel@skybr ~]$
[12 Nov 2007 9:36]
Slava Vetluzhskikh
From Your comment I am not sure that you have caught the problem.... The problem is that an XLS file IS created, but it is NOT XLS file, and because of that, it can not be openned by means of Open Office in Linux, though it CAN open the SAME file while in Windows using MS Office. The resulted file is not PURELY XLS file, OO does not understand it, while files created by MS Office Excel it opens without priblem. Regards,
[26 May 2009 13:15]
Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here: http://www.mysql.com/support/supportedplatforms/tools.html More informations about MySQL Workbench you will find here: http://dev.mysql.com/workbench/
Description: Such a problem: in MySql Browser I choose to export the resultset as Excel file. Finally, I have got the necessary file on a local machine. BUT I can not properly open it if in Linux e.g. using OpenOffice's Calc. It opens it as just text file. The only solution is to open it in Excel when in Windows. Other words, the resulted .xls file produced by MySql Browser is not USUAL excel file and, as a result, it can not be opened properly by Calc. Finally: ther is no sence in such an option in Linux version if you can not open the result under Linux. How to repeat: To try to save any result set if under Linux and than open it there using OpenOffice. Suggested fix: I think something should be ammended in the structure of the output file, just to provide it can be properly understanded by OpenOffice as Excel file. Possibly, it could be usefull to add another option: save as OO Calc's file.