Thanks for your advice.
I tried it with the higher value (3M) but the program broke down
like before.
I increased the other buffer values too after that and am
testing now if this helps.
Greetings,
Daniel
Gelu Gogancea wrote:
Hi,
Maybe it's a good ideea to increase the value of max_allowed_packet(from
my.cnf configuration file) to 2M.By default is 1MB.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Daniel Wetzler" <[EMAIL PROTECTED]>
To: "MySQL Mailing Liste" <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:54 AM
Subject: Problem using the C-API for MySQL Program breakdown after about 1
Mio SQL-statements
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
