gnomedb 0.2.90 and mysql

[Klaus Dahlke <klaus dahlke gmx de>]

Hi all,

I downloaded the tarballs for libgda, gnomedb and gASQL (0.2.90) and complied them successfully after some hasle with libgda (files like configure.guess, install.sh, mkinstalldirs missing, I took them from gnomedb). I configured two drivers, postgresql and mysql. For postgres everything works fine (gnomedb-de, gasql including changing table content), but mysql is a real pain.

I configured access to the mysql-database mysql (central administration database), 'test connection' at gnomedb-fe is successful. Then, open mysql shows the tables in mysql, switching directely to the sql-windows without marking any tables works fine and a simple sql-statement like 'select * from user' is processed normaly. Clicking on Views, Porcedures and Aggregates, the error 'Unknown schema type' occurs. Clicking on Type, all types are shown. But if I click on Tables onto 'user', gnomedb-fe crashes (see below for debug). Command line output is only:

Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x8179F68)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x8179F88)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x810C000)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x814B6F8)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x810C000)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x814B6F8)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x810C000)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x814B6F8)
Gtk-WARNING **: gtk_signal_disconnect_by_data(): could not find handler containing data (0x810C000)


When using gASQL with the database mysql, gASQL starts reading the data types. At about 75% of  'Updating the list of data types' the gasql stops. After stopping gasql, proccess like gconf, oaf, gda-mysql-srv still remain.

Command line output of gasql is:
GnomeUI-WARNING **: Could not open help topics file NULL
        New plugin (0x8122428/0x40920eb0): Test(V0.6.0)
        New plugin (0x8122820/0x40924a40): Picts(V0.6.0)
        New plugin (0x8124060/0x409282e0): NetAddr(V0.6.0)
GDA_Connection_open returns 0
gda_connection_open_schema: constraint value = 't'
CORBA seq: constraint->value = 't'
gda_connection_open_schema: constraint value = 't'
CORBA seq: constraint->value = 't'
gda-connection.c: 68: gda_connection_real_error called
gda-connection.c: 68: gda_connection_real_error called

** CRITICAL **: file gda-error.c: line 338 (gda_error_list_free): assertion `errors != 0' failed.

Does anyone have a similiar experience?

Regards,
Klaus


Crash Output:
gnomedb-components
[New Thread 1024 (LWP 25290)]
0x408155a9 in __wait4 () from /lib/libc.so.6
#0  0x408155a9 in __wait4 () from /lib/libc.so.6
#1  0x4087dad8 in __DTOR_END__ () from /lib/libc.so.6
#2  0x40682e37 in waitpid () from /lib/libpthread.so.0
#3  0x404823e7 in gnome_segv_handle (signum=11) at gnome-init.c:659
#4  0x4068089d in pthread_sighandler () from /lib/libpthread.so.0
#5  <signal handler called>
#6  0x40032a9f in g_strdup (str=0x1 <Address 0x1 out of bounds>)
    at gstrfuncs.c:87
#7  0x40671e14 in gda_stringify_value (bfr=0x0, maxlen=0, f=0x80d6df0)
    at gda-field.c:384
#8  0x405eeeed in timeout_callback (grid=0x80b5c50) at gnome-db-grid.c:314
#9  0x40029c23 in g_timeout_dispatch (source_data=0x80d6138,
    dispatch_time=0xbffff07c, user_data=0x80b5c50) at gmain.c:1302
#10 0x40028c46 in g_main_dispatch (dispatch_time=0xbffff07c) at gmain.c:656
#11 0x40029273 in g_main_iterate (block=1, dispatch=1) at gmain.c:877
#12 0x4002943c in g_main_run (loop=0x8093b58) at gmain.c:935
#13 0x400cf89c in gtk_main () at gtkmain.c:524
#14 0x403f17fd in bonobo_main () at bonobo-main.c:283
#15 0x405f12ad in gnome_db_main (ui_create_func=0x8050ac0 <prepare_app>)
    at gnome-db-init.c:74
#16 0x805085e in main (argc=3, argv=0xbffff1dc) at gnomedb-com-main.c:36
#17 0x4078cbaf in __libc_start_main () from /lib/libc.so.6
#0  0x408155a9 in __wait4 () from /lib/libc.so.6
No locals.
#1  0x4087dad8 in __DTOR_END__ () from /lib/libc.so.6
No symbol table info available.
#2  0x40682e37 in waitpid () from /lib/libpthread.so.0
No symbol table info available.
#3  0x404823e7 in gnome_segv_handle (signum=11) at gnome-init.c:659
estatus = 134900424
signum = -512
in_segv = 1
pid = 0
#4  0x4068089d in pthread_sighandler () from /lib/libpthread.so.0
No symbol table info available.
#5  <signal handler called>
No locals.
#6  0x40032a9f in g_strdup (str=0x1 <Address 0x1 out of bounds>)
    at gstrfuncs.c:87
str = (gchar *) 0x1 <Address 0x1 out of bounds>
new_str = (gchar *) 0x80d663c ""
#7  0x40671e14 in gda_stringify_value (bfr=0x0, maxlen=0, f=0x80d6df0)
    at gda-field.c:384
384                             retval = g_strdup (tmp);
retval = (gchar *) 0x0
tmp = "Dïÿ¿l\037g@ gg P\\\013\bTïÿ¿\204/g \025ù\000\000\025ù\000\000Tïÿ¿50g@"
stm = {tm_sec = 1074970862, tm_min = 1080518432, tm_hour = 134962256,
  tm_mday = 135088328, tm_mon = -1073746124, tm_year = 1080500106,
  tm_wday = 66069, tm_yday = -1073746124, tm_isdst = 1080500115,
  tm_gmtoff = 135097840, tm_zone = 0x10215 <Address 0x10215 out of bounds>}