MySQL: Erro ao executar uma view no MySQL Query Browser.

[fabioal]

Senhores,

Eu preciso de uma ajuda no mysql-query-browser, vou explicar o que está acontecendo.

Na empresa, tenho um computador rodando o Ubuntu 7.04 como servidor. Nele está instalado o Apache, PHP e MySQL.

Eu uso o MySQL ligando as consultas em planilhas, onde eu gero os relatórios, até aí tudo funciona perfeitamente.

Fiz um backup da base de dados pelo MySQL Administrator, em um computador rodando o Windows Vista, trouxe para casa e restaurei no meu micro, rodando o Ubuntu 8.10.

Quando eu abro qualquer query salva ele não executa, diz que tem erro na query, mas se eu digitar toda a string da query novamente, funciona.

Tem várias views na base de dados e quando executo qualquer uma das views o MySQL Query Browser fecha sem aviso nenhum, se eu editar a view e copiar o select todo e colar no query browser, funciona normal.

No console o erro que aparece é esse:

Código Selecionar Expandir

*** glibc detected *** mysql-query-browser: free(): invalid next size (fast): 0xb2fa1390 ***
======= Backtrace: =========
/lib/tls/i686/cmov/libc.so.6[0xb6af83f4]
/lib/tls/i686/cmov/libc.so.6(cfree+0x96)[0xb6afa456]
/usr/lib/libglib-2.0.so.0(g_free+0x36)[0xb6d90c06]
mysql-query-browser[0x8188165]
mysql-query-browser(_ZN15MQResultSetView11query_errorEP13MYX_RESULTSETP20MYX_MYSQL_ERROR_MSGS13myx_lib_error+0x1c3)[0x80acde3]
mysql-query-browser(_ZN4sigc8internal10slot_call3INS_18bound_mem_functor3Iv15MQResultSetViewP13MYX_RESULTSETP20MYX_MYSQL_ERROR_MSGS13myx_lib_errorEEvS5_S7_S8_E7call_itEPNS0_8slot_repERKS5_RKS7_RKS8_+0x37)[0x80b7c47]
mysql-query-browser[0x8097a5a]
mysql-query-browser(_ZN17MQQueryDispatcher19handle_query_resultEv+0x52)[0x8095b12]
mysql-query-browser(_ZN4sigc8internal10slot_call0INS_18bound_mem_functor0Iv17MQQueryDispatcherEEvE7call_itEPNS0_8slot_repE+0x1c)[0x809994c]
/usr/lib/libglibmm-2.4.so.1(_ZN4Glib16DispatchNotifier15pipe_io_handlerENS_11IOConditionE+0x13a)[0xb715044a]
/usr/lib/libglibmm-2.4.so.1(_ZN4sigc8internal10slot_call1INS_18bound_mem_functor1IbN4Glib16DispatchNotifierENS3_11IOConditionEEEbS5_E7call_itEPNS0_8slot_repERKS5_+0x25)[0xb71505b5]
/usr/lib/libglibmm-2.4.so.1(_ZN4Glib8IOSource8dispatchEPN4sigc9slot_baseE+0x42)[0xb7152322]
/usr/lib/libglibmm-2.4.so.1(_ZN4Glib6Source14dispatch_vfuncEP8_GSourcePFiPvES3_+0x69)[0xb71524b9]
/usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x1e8)[0xb6d886f8]
/usr/lib/libglib-2.0.so.0[0xb6d8bda3]
/usr/lib/libglib-2.0.so.0(g_main_loop_run+0x1d2)[0xb6d8c2c2]
/usr/lib/libgtk-x11-2.0.so.0(gtk_main+0xb9)[0xb72e43a9]
/usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk4Main8run_implEv+0x17)[0xb77a64c7]
/usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk4Main3runEv+0x22)[0xb77a62c2]
mysql-query-browser[0x808ab66]
/lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe5)[0xb6a9f685]
mysql-query-browser(_ZN3Gtk10TextBuffer8on_eraseERKNS_8TextIterES3_+0x49)[0x8088801]
======= Memory map: ========
08048000-0827b000 r-xp 00000000 08:13 312729     /usr/bin/mysql-query-browser
0827b000-08293000 r--p 00233000 08:13 312729     /usr/bin/mysql-query-browser
08293000-08296000 rw-p 0024b000 08:13 312729     /usr/bin/mysql-query-browser
08296000-08297000 rw-p 08296000 00:00 0
09343000-0b164000 rw-p 09343000 00:00 0          [heap]
b2100000-b2194000 rw-p b2100000 00:00 0
b2194000-b2200000 ---p b2194000 00:00 0
b2300000-b2500000 rw-p b2300000 00:00 0
b2500000-b2600000 rw-p b2500000 00:00 0
b2900000-b2b00000 rw-p b2900000 00:00 0
b2b00000-b2d00000 rw-p b2b00000 00:00 0
b2d00000-b2f00000 rw-p b2d00000 00:00 0
b2f00000-b3100000 rw-p b2f00000 00:00 0
b3100000-b3300000 rw-p b3100000 00:00 0
b3300000-b3500000 rw-p b3300000 00:00 0
b3500000-b3700000 rw-p b3500000 00:00 0
b3700000-b3900000 rw-p b3700000 00:00 0
b3900000-b3a00000 rw-p b3900000 00:00 0
b3b00000-b3d00000 rw-p b3b00000 00:00 0
b3d00000-b3f00000 rw-p b3d00000 00:00 0
b3f00000-b4000000 rw-p b3f00000 00:00 0
b4100000-b4300000 rw-p b4100000 00:00 0
b4300000-b4500000 rw-p b4300000 00:00 0
b4500000-b4700000 rw-p b4500000 00:00 0
b4700000-b4900000 rw-p b4700000 00:00 0
b4900000-b4a00000 rw-p b4900000 00:00 0
b4a00000-b4b00000 rw-p b4a00000 00:00 0
b4c00000-b4d00000 rw-p b4c00000 00:00 0
b4d6d000-b4d6e000 ---p b4d6d000 00:00 0
b4d6e000-b556e000 rw-p b4d6e000 00:00 0
b556e000-b557a000 r--p 00000000 08:13 431778     /usr/share/fonts/truetype/ttf-bitstream-vera/VeraMoBd.ttf
b557a000-b55da000 rw-s 00000000 00:09 2457653    /SYSV00000000 (deleted)
b55da000-b56de000 rw-p b55da000 00:00 0
b56de000-b5767000 r--p 00000000 08:13 431783     /usr/share/fonts/truetype/ttf-dejavu/DejaVuSans-Bold.ttf
b5767000-b5768000 ---p b5767000 00:00 0
b5768000-b5f68000 rw-p b5768000 00:00 0
b5f68000-b5fc8000 rw-s 00000000 00:09 2261042    /SYSV00000000 (deleted)
b5fc8000-b5fd7000 r-xp 00000000 08:13 138486     /lib/libbz2.so.1.0.4
b5fd7000-b5fd8000 r--p 0000f000 08:13 138486     /lib/libbz2.so.1.0.4
b5fd8000-b5fd9000 rw-p 00010000 08:13 138486     /lib/libbz2.so.1.0.4
b5fd9000-b600a000 r-xp 00000000 08:13 311223     /usr/lib/libcroco-0.6.so.3.0.1
b600a000-b600d000 rw-p 00030000 08:13 311223     /usr/lib/libcroco-0.6.so.3.0.1
b600d000-b603d000 r-xp 00000000 08:13 311500     /usr/lib/libgsf-1.so.114.0.8
b603d000-b603f000 r--p 0002f000 08:13 311500     /usr/lib/libgsf-1.so.114.0.8
b603f000-b6040000 rw-p 00031000 08:13 311500     /usr/lib/libgsf-1.so.114.0.8
b6040000-b6041000 rw-p b6040000 00:00 0
b6041000-b6072000 r-xp 00000000 08:13 311862     /usr/lib/librsvg-2.so.2.22.3
b6072000-b6073000 r--p 00030000 08:13 311862     /usr/lib/librsvg-2.so.2.22.3
b6073000-b6074000 rw-p 00031000 08:13 311862     /usr/lib/librsvg-2.so.2.22.3
b6076000-b6083000 r--p 00000000 08:13 431780     /usr/share/fonts/truetype/ttf-bitstream-vera/VeraMono.ttf
b6083000-b609b000 r-xp 00000000 08:13 342052     /usr/lib/gio/modules/libgvfsdbus.so
b609b000-b609c000 r--p 00017000 08:13 342052     /usr/lib/gio/modules/libgvfsdbus.so
b609c000-b609d000 rw-p 00018000 08:13 342052     /usr/lib/gio/modules/libgvfsdbus.so
b609d000-b60aa000 r-xp 00000000 08:13 311593     /usr/lib/libgvfscommon.so.0.0.0
b60aa000-b60ab000 r--p 0000d000 08:13 311593     /usr/lib/libgvfscommon.so.0.0.0
b60ab000-b60ac000 rw-p 0000e000 08:13 311593     /usr/lib/libgvfscommon.so.0.0.0
b60b1000-b60b2000 r-xp 00000000 08:13 342176     /usr/lib/gtk-2.0/2.10.0/loaders/svg_loader.so
b60b2000-b60b3000 r--p 00000000 08:13 342176     /usr/lib/gtk-2.0/2.10.0/loaders/svg_loader.so
b60b3000-b60b4000 rw-p 00001000 08:13 342176     /usr/lib/gtk-2.0/2.10.0/loaders/svg_loader.so
b60b4000-b60cb000 r--s 00000000 08:13 383900     /usr/share/mime/mime.cache
b60cb000-b60d0000 r-xp 00000000 08:13 342163     /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-gif.so
b60d0000-b60d1000 r--p 00004000 08:13 342163     /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-gif.so
b60d1000-b60d2000 rw-p 00005000 08:13 342163     /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-gif.so
b60d3000-b60d4000 r-xp 00000000 08:13 342145     /usr/lib/gtk-2.0/2.10.0/immodules/im-cedilla.so
b60d4000-b60d5000 r--p 00000000 08:13 342145     /usr/lib/gtk-2.0/2.10.0/immodules/im-cedilla.so
b60d5000-b60d6000 rw-p 00001000 08:13 342145     /usr/lib/gtk-2.0/2.10.0/immodules/im-cedilla.so
b60d6000-b61da000 rw-p b60d6000 00:00 0
b61da000-b61dc000 r-xp 00000000 08:13 376354     /usr/lib/pango/1.6.0/modules/pango-basic-fc.so
b61dc000-b61dd000 r--p 00001000 08:13 376354     /usr/lib/pango/1.6.0/modules/pango-basic-fc.so
b61dd000-b61de000 rw-p 00002000 08:13 376354     /usr/lib/pango/1.6.0/modules/pango-basic-fc.so
b61de000-b6273000 r--p 00000000 08:13 431784     /usr/share/fonts/truetype/ttf-dejavu/DejaVuSans.ttf
b6273000-b6279000 r--s 00000000 08:13 410595     /var/cache/fontconfig/945677eb7aeaf62f1d50efc3fb3ec7d8-x86.cache-2
b6279000-b627c000 r--s 00000000 08:13 410757     /var/cache/fontconfig/e383d7ea5fbe662a33d9b44caf393297-x86.cache-2
b627c000-b627d000 r--s 00000000 08:13 410754     /var/cache/fontconfig/4c73fe0c47614734b17d736dbde7580a-x86.cache-2
b627d000-b6280000 r--s 00000000 08:13 410760     /var/cache/fontconfig/a755afe4a08bf5b97852ceb7400b47bc-x86.cache-2
b6280000-b6283000 r--s 00000000 08:13 410756     /var/cache/fontconfig/6d41288fd70b0be22e8c3a91e032eec0-x86.cache-2
b6283000-b6286000 r--s 00000000 08:13 410759     /var/cache/fontconfig/de156ccd2eddbdc19d37a45b8b2aac9c-x86.cache-2
b6286000-b628e000 r--s 00000000 08:13 410755     /var/cache/fontconfig/e3de0de479f42330eadf588a55fb5bf4-x86.cache-2
b628e000-b6299000 r--s 00000000 08:13 410767     /var/cache/fontconfig/0f34bcd4b6ee430af32735b75db7f02b-x86.cache-2
b6299000-b62bb000 r--s 00000000 08:13 410842     /var/cache/fontconfig/365b55f210c0a22e9a19e35191240f32-x86.cache-2
b62bb000-b62be000 r--s 00000000 08:13 410761     /var/cache/fontconfig/de9486f0b47a4d768a594cb4198cb1c6-x86.cache-2
b62be000-b62c5000 r--s 00000000 08:13 410762     /var/cache/fontconfig/d52a8644073d54c13679302ca1180695-x86.cache-2
b62c5000-b62cb000 r--s 00000000 08:13 410589     /var/cache/fontconfig/089dead882dea3570ffc31a9898cfb69-x86.cache-2
b62cb000-b62d2000 r--s 00000000 08:13 410841     /var/cache/fontconfig/e13b20fdb08344e0e664864cc2ede53d-x86.cache-2
b62d2000-b62d6000 r-xp 00000000 08:13 342168     /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so
b62d6000-b62d7000 r--p 00003000 08:13 342168     /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so
b62d7000-b62d8000 rw-p 00004000 08:13 342168     /usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so
b62d8000-b62e2000 r--p 00000000 08:13 459741     /usr/share/locale-langpack/pt_BR/LC_MESSAGES/glib20.mo
b62e2000-b62e3000 r--s 00000000 08:13 410763     /var/cache/fontconfig/4794a0821666d79190d59a36cb4f44b5-x86.cache-2
b62e3000-b62e6000 r--p 00000000 08:13 459731     /usr/share/locale-langpack/pt_BR/LC_MESSAGES/atk10.mo
b62e6000-b62fd000 r--p 00000000 08:13 525934     /usr/share/locale-langpack/pt/LC_MESSAGES/libc.mo
b62fd000-b631c000 r--p 00000000 08:13 459766     /usr/share/locale-langpack/pt_BR/LC_MESSAGES/libc.mo
b631c000-b633b000 r-xp 00000000 08:13 342136     /usr/lib/gtk-2.0/2.10.0/engines/libmurrine.so
b633b000-b633c000 r--p 0001e000 08:13 342136     /usr/lib/gtk-2.0/2.10.0/engines/libmurrine.so
b633c000-b633d000 rw-p 0001f000 08:13 342136     /usr/lib/gtk-2.0/2.10.0/engines/libmurrine.so
b633d000-b6363000 r--p 00000000 08:13 525406     /usr/share/locale-langpack/pt/LC_MESSAGES/gtk20-properties.mo
b6363000-b636b000 r--p 00000000 08:13 525829     /usr/share/locale-langpack/pt/LC_MESSAGES/libgnome-2.0.mo
b636b000-b6373000 r--p 00000000 08:13 459609     /usr/share/locale-langpack/pt_BR/LC_MESSAGES/libgnome-2.0.mo
b6373000-b6398000 r--p 00000000 08:13 458782     /usr/share/locale-langpack/pt_BR/LC_MESSAGES/gtk20-properties.mo
b6398000-b63a9000 r--p 00000000 08:13 525870     /usr/share/locale-langpack/pt/LC_MESSAGES/gtk20.mo
b63a9000-b63bb000 r--p 00000000 08:13 459696     /usr/share/locale-langpack/pt_BR/LC_MESSAGES/gtk20.mo
b63bb000-b63fa000 r--p 00000000 08:13 342970     /usr/lib/locale/pt_BR.utf8/LC_CTYPE
b63fa000-b63fb000 r--p 00000000 08:13 342733     /usr/lib/locale/pt_BR.utf8/LCCancelado


Será que eu vou ter que abrir todas as querys salvas e as views e criar novamente? Parece que o Ubuntu não está reconhecendo o texto como texto (agora eu acho que confundi tudo...  )

Se alguém souber o que eu posso fazer, eu agradeço.

[]'s