Problem using the C-API for MySQL Program breakdown after about 1Mio SQL-statements

[Daniel Wetzler]

Hallo,

I apologize for my bad english.
Im desperate about the followwing problem :

I'm using the MySQL C-API for accesssing a database with about 1.2 Mio
SQL-Statemants.
Therefor I make a connect to the database and after that a loop
starts a Subprogram about 1.2 Mio times in which a SQL-statement is sent
to the database. My problem is that the program breaks down after about
1 Mio iterations with a Bus error and Segmentation fault.
If I analyse the core dump with a debugger I get the following statements :
The program breaks down at line :

if (mysql_query(mysql2, abfrage)) {
printf ("Fehler bei der Abfrage ! Fehler : %s \n %s \n", mysql_error(mysql2), abfrage);
exit(1);



Program terminated with signal 10, Bus Error.
#0 0xff35a90c in vio_is_blocking () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10
(gdb) up
#1 0xff35a4e0 in net_clear () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10
(gdb) up
#2 0xff356abc in simple_command () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10
(gdb) up
#3 0xff3594e8 in mysql_real_query () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10
(gdb) up
#4 0x11728 in read_coor (i=1065778) at nclu-datenbank.c:279
(gdb) up


I checked the SQL statement which is sent at that time an it is ok
and leads to suitable result.



Does any one have an idea why my program breaks down ?


Greetings,


Daniel








P.S :


Here is my code for accessing the database :


(some code............. )

mysql2 = mysql_init(NULL);

if (mysql2 == NULL){
printf ("mysql_init() fehlgeschlagen (kein Speicher ?)\n");
exit (1);
}

if (mysql_real_connect( mysql2, def_host_name, def_user_name, def_password, def_db_name, 0, NULL, 0) == NULL){
printf("Datenbankverbindung hat nicht geklappt.\n");
}
printf ("Datenbankverbindung 1 ok\n");


while(ergebnisarray[zaehler] != NULL) {
/*printf ("zahl = %i\n", ergebnisarray[zaehler]);*/

j=read_coor(ergebnisarray[zaehler]);
/* This is my fuction which sends the SQL-statements accessed 1.2 Mio times */
zaehler++;

}

mysql_close(mysql2);



(some code....................)





In my function I access the database with the following lines :




(some code)..................


for (seglaengenzaehler = 1; seglaengenzaehler <= seglength; seglaengenzaehler ++) {

sprintf (abfrage, "select xkoor, ykoor, zkoor, id from %iloop inner join pdbmolekuel on m%i=molekuelnr inner join pdbatom on molekuelnr = molekuelzuordnung where loopnummer = %i", seglength, seglaengenzaehler, i);


if (mysql_query(mysql2, abfrage)) {
printf ("Fehler bei der Abfrage ! Fehler : %s \n %s \n", mysql_error(mysql2), abfrage);
exit(1);
}
else {
ergebnis = mysql_use_result(mysql2);
}
}

if (ergebnis == NULL) {
printf ("Fehler beim show tables !\n Fehler : %s ", mysql_error(mysql2));
}
else {
/*printf ("Alles in Ordnung !\n");*/

while((myzeile = mysql_fetch_row(ergebnis)))
{

if ( strcmp(myzeile[3],"CA")==0 || strcmp(myzeile[3],"N") == 0 || strcmp(myzeile[3],"C") == 0 ||
strcmp(myzeile[3],"O") == 0)
{
// Es werden nur die Atome CA, N, C und O beachtet

coor[j] = atof(myzeile[0]);
coor[j+1] = atof(myzeile[1]);
coor[j+2] = atof(myzeile[2]);
j += 3;

}
}
mysql_free_result (ergebnis);
}
resno = j/12;
}



(some code)................






---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php