Red Hat Bugzilla – Bug 187913
Review Request: mysql-query-browser
Last modified: 2007-11-30 17:11:29 EST
Spec Name or Url: http://ausil.us/packages/mysql-query-browser.spec
SRPM Name or Url: http://ausil.us/packages/mysql-query-browser-1.1.18-1.src.rpm
The MySQL Query Browser is a graphical tool provided by MySQL AB for creating,
executing, and optimizing queries in a graphical environment. Where the MySQL
Administrator is designed to administer a MySQL server, the MySQL Query
Browser is designed to help you query and analyze data stored within your MySQL
Fix for fc4 it needs a slightly different configure switch
Looks good, couple of things.
- Source0 does not exist:
- %find_lang requres gettext (This prevents a successful mock build)
- Duplicate BuildRequires: openssl-devel is provided by mysql-devel
- Duplicate BuildRequires: libglade2-devel is provided gtkhtml3-devel
It seems mysql has removed the ability to download directly from them. they
are forcing you to choose a mirror. so i chose pair networks as they are
listed as one of the two primary mirrors.
fixed the Build Requires though i built in mock ok on fc4 and fc5 on both
X86_64 and i386
It works fine for me on i386, but under x86_64, attempting to actually use a
database causes a segfault:
/usr/bin/mysql-query-browser: line 20: 16829 Segmentation fault $PRG-bin
hmm kinda strange. i have run succesfully on ppc, x86 and x86_64 can you
please get me a strace of when you load the program. I may be slow to reply as
im in Australia on vacation.
I was unable to re-create this error on my FC5 box. Everything seemed fine.
Michel Alandre Salim: did you happen to notice any errors/warnings when you
compiled the package?
FE-NEW -> FE-REVIEW? Status is already "assigned".
*** Bug 189959 has been marked as a duplicate of this bug. ***
Can anyone else re-create this error? If not I'm going to wipe my 64 machine
with a clean install and try it again. If it works I'm going to approve this.
im unable to recreate it i just did a select query on a table returning over
100,000 rows on my x86_64 box
Pretty close, under buildrequires you need to add desktop-file-utils. Without
it this package will fail to build in mock.
i could have sworn i had desktop-file-utils in there. but it is now thanks:)
Created attachment 128746 [details]
I'm able to reproduce the segfault on x86_64. It only happens when I try to
connect to remote mysql server. It seems that it fials to find libc.mo locale
file on my system. Connecting to localhost works ok.
not that it is neccesarily the answer but what version of mysql is your
remote server? AFAIK the mysql tools are intended to support version 4 and 5
DB's only. I have version 5 DB's here
I've played a bit with the query browser and first I made the following symlink:
ln -s /usr/share/locale/en_GB/LC_MESSAGES/libc.mo
just to make sure that it can find the libc.mo file, but it didn't solve the
problem (still segfault at line 20). I removed the database name in "Default
Schema" field and I was able to connect sucessfully. However when I click on the
database name in the Schemata panel the segfault occurs. The mysql server
version is 4.0.23
Additionally the Windows version of mysql-query-browser (ver: 1.1.20) seems to
work ok with the remote server.
I have run mysql-query-browser on my FC5 system through gdb with the following
Starting program: /usr/bin/mysql-query-browser-bin
[Thread debugging using libthread_db enabled]
[New Thread 46912496382720 (LWP 32391)]
Detaching after fork from child process 32394.
[New Thread 1084229968 (LWP 32398)]
[Thread 1084229968 (LWP 32398) exited]
[New Thread 1084229968 (LWP 32399)]
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1084229968 (LWP 32399)]
0x0000003009e41b36 in mysql_select_db () from
#0 0x0000003009e41b36 in mysql_select_db () from
#1 0x0000000000510f04 in myx_use_schema (mysql=0x0, schema=Variable "schema" is
) at myx_library.c:743
#2 0x000000000050e3f4 in use_schema_store_old_one (mysql=0xa90530,
old_schema_name=0x40a000c0) at myx_catalogs.c:112
#3 0x000000000050f871 in myx_get_schema_tables (mysql=0xa90530,
catalog_name=Variable "catalog_name" is not available.
) at myx_catalogs.c:156
#4 0x0000000000439928 in TableFetchRequest::execute (this=Variable "this" is
) at MQQueryDispatcher.cc:122
#5 0x000000000043658a in MQQueryDispatcher::mysql_query_thread (this=0xc5a4a0)
#6 0x000000300b02d30f in Glib::Thread::create () from /usr/lib64/libglibmm-2.4.so.1
#7 0x0000003002642e04 in g_thread_create_full () from /usr/lib64/libglib-2.0.so.0
#8 0x0000003001e062ea in start_thread () from /lib64/libpthread.so.0
#9 0x0000003000dcb73d in clone () from /lib64/libc.so.6
#10 0x0000000000000000 in ?? ()
also I found a related bug in mysql bugzilla:
I can reproduce this connecting to a fc3 box running
mysql-server-3.23.58-16.FC3.1 but I am unable to reproduce connecting to
4.1.x or 5.x servers.
I am going to install 4.0.x on a test box and see what happens
This blocks FC-REVIEW and not FE-REVIEW. This seems wrong. So the correct number
to block would be 163778 instead of 188267.
Sorry bout that.
Has anyone made any headway on this?
I still havent been able to figure out why it crashes when connecting 64bit
client to old 32 bit servers. In my day to day use it works fine.
Sorry for the delay, I didn't realize this was an upstream bug.
- Looks good
- Builds in mock
- Matches packaging guidelines
- contains required files
- contains desktop
rpmlint no output for binaries see below
rpmlint from the srpm:
W: mysql-query-browser mixed-use-of-spaces-and-tabs
Too late i think....
MySQL does not continue providing update for this tools.
The new bundle "MySQL GUI Tools" provide MySQL Administrator, Query Browser and
Workbench (and FC5 RPM).
Including the suite in the Extras still a great idea, at least for non i386 arch
and for rawhide.
All built and pushed.
as for MySQL gui tools. yes i am aware of them and have started work on
packaging them. they have written it to use lua 5.0 we have available lua
5.1 so i need to learn whats needed to port it over. The tarball for
mysql-gui-tools contails beta and alpha software.
But I do intend to get the whole gammut of mysql auite of tools in.