Segmentation Fault in mysql_server_init() while using Embedded server

[Satheesh Ganapathi Subramanian]

Hi All

I'm trying to create a new database using the embedded server (MySQL 4.0.13). I 
compiled the source distribution on linux as follows:

./configure --prefix=/fs32/b/sgsubram/bin/MySQL-with-new-hash/LINUX --enable-assembler 
--with-mysqld-ldflags=-all-static 
--localstatedir=/fs32/b/sgsubram/bin/MySQL-with-new-hash/LINUX/data 
--with-client-ldflags=-all-static -enable-thread-safe-client --enable-local-infile 
--with-extra-charsets=complex

gmake; gmake install

The installation went smoothly without any problems. I tested the sample 
test_libmysqld.c program and it went through fine.

Then I tried the following. I changed the code for the functions db_connect and main 
in test_libmysqld.c to create a new database if there is no database by that name. 

The changed code segment is as follows (changes are in bold):

int
main(int argc, char **argv)
{
  MYSQL *one, *two;
  mysql_server_init(argc, argv, (char **)server_groups);
  one = db_connect("hello");
  two = db_connect(NULL);
  db_do_query(one, "SHOW TABLE STATUS");
  db_do_query(two, "SHOW DATABASES");
  mysql_close(two);
  mysql_close(one);
  /* This must be called after all other mysql functions */
  mysql_server_end();
  exit(EXIT_SUCCESS);
}

MYSQL *
db_connect(const char *dbname)
{
  MYSQL *db = mysql_init(NULL);
  if (!db)
    die(db, "mysql_init failed: no memory");
  /*
   * Notice that the client and server use separate group names.
   * This is critical, because the server will not accept the
   * client's options, and vice versa.
   */
  mysql_options(db, MYSQL_READ_DEFAULT_GROUP, "test_libmysqld_CLIENT");
  if (!mysql_real_connect(db, NULL, NULL, NULL, dbname, 0, NULL, 0)) {
    char query[1024];
    sprintf(query, "CREATE DATABASE %s", dbname);
    if (mysql_query(db, query) != 0) {
      die(db, "mysql_real_connect failed: %s", mysql_error(db));
    } else {
      if (!mysql_real_connect(db, NULL, NULL, NULL, dbname, 0, NULL, 0)) {
        die(db, "mysql_real_connect failed: %s", mysql_error(db));
      }
    }
  }
  return db;
}

There is no database by name "hello". The crash happens in mysql_server_init(). The 
crash does not happen if I try to connect to an existing database by name "test". The 
stack trace that I get when I run it inside gdb is as follows:

(gdb) where
#0  0x0828c416 in __sigsuspend (set=0xbfffb870) at 
../sysdeps/unix/sysv/linux/sigsuspend.c:45
#1  0x082804b5 in __pthread_wait_for_restart_signal (self=0x83c4900) at pthread.c:978
#2  0x08280591 in __pthread_create_2_1 (thread=0xbfffba10, attr=0xbfffba14, 
start_routine=0x81eaa00 <io_handler_thread>, arg=0x841bba0) at restart.h:34
#3  0x081a171f in os_thread_create ()
#4  0x081ebecb in innobase_start_or_create_for_mysql ()
#5  0x08051672 in innobase_init ()
#6  0x08058f44 in ha_init ()
#7  0x080500b4 in mysql_server_init ()
#8  0x080481eb in main (argc=1, argv=0xbfffc434) at test_libmysqld.c:45
#9  0x082885f2 in __libc_start_main (main=0x80481d0 <main at test_libmysqld.c:20>, 
argc=1, ubp_av=0xbfffc434, init=0x80480b4 <_init>, fini=0x82ff480 <_fini>, 
rtld_fini=0, stack_end=0xbfffc42c) at ../sysdeps/generic/libc-start.c:129

Any help with this problem would be greatly appreciated.

Thanks
Satheesh


____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005