Errores de Conexion
En estos días están siendo frecuentes estos errores
2005.Unknown MySQL server host 'mysql' (0)
2004.Can't create TCP/IP socket (24).
La aplicación maneja threads.Esta desarrollada en lenguaje C sobre Centos 5.3 Una breve descripcion del funcionamiento seria el sgte. Cada hilo se conecta a la base de datos. Realiza operaciones sobre tablas, cierra la conexión y termina el hilo.
Lo raro es que el momento del problema de conexión no es constante. Supongamos que quiero conectarme 1000 veces..
De esas 1000 veces son 250 la que tienen errores de conexion. Se dan de forma alternada.. 20 veces se conecta.. 2 no. Luego de nuevo 100 se conectan 15 no..
El comportamiento varia mucho.
Lo último que hice hoy fue probar solo la conexión a la base de datos. El resto del funcionamiento de la aplicación fue comentado(insert, update, delete, etc).
Sinceramente no se que puede ser.. que estaré haciendo mal....
Esta es la función que realiza la conexión.
int makeMysqlConnect(MYSQL *dbConn, const char *szHost, const char *szUser, const char *szPass,
const char *szDatabase, unsigned int iPort)
{
time_t hora_inic, hora_fin;
int temps;
hora_inic = time(NULL);
pthread_t tid = pthread_self();
printf("[%lu]szHost %s\n", tid,szHost);
printf("[%lu]szUser %s\n", tid,szUser);
printf("[%lu]szPass %s\n", tid,szPass);
printf("[%lu]iPort %d\n", tid,iPort);
if (mysql_init(dbConn))
{
if (mysql_real_connect(dbConn, szHost , szUser, szPass, NULL, iPort , NULL, 0))
{
if(!mysql_select_db(dbConn, szDatabase))
{
printf("[%lu]Fallo en seteo de autocommit = false. %u.%s\n", tid, mysql_errno(dbConn), mysql_error(dbConn));
closeMysql(dbConn);
return GENERIC_ERROR;
}
else
{
printf("[%lu]Fallo en la seleccion de base de datos. %u.%s\n", tid, mysql_errno(dbConn), mysql_error(dbConn));
closeMysql(dbConn);
return GENERIC_ERROR;
}
}
else
{
printf("[%lu]Fallo en la conexion a la base de datos. %u.%s\n", tid, mysql_errno(dbConn), mysql_error(dbConn));
closeMysql(dbConn);
return GENERIC_ERROR;
}
}
else
{
printf("[%lu]No se puedo crear el objeto MYSQL\n", tid);
return GENERIC_ERROR;
}
hora_fin = time(NULL);
temps=hora_fin - hora_inic;
printf("[%lu]Tiempo ejecucion en conectarse a la BD : %d segs\n",tid, temps);
return PROCESS_OK;
}
Estoy atenta a comentarios. Muchas Gracias!
Subject
Views
Written By
Posted
54902
July 11, 2006 07:51AM
8926
July 21, 2006 09:35AM
7125
July 24, 2006 08:37AM
4220
February 25, 2010 05:22PM
6120
May 17, 2010 02:44AM
3509
August 30, 2010 08:14AM
3522
September 15, 2010 04:21PM
3894
November 09, 2010 06:58AM
6092
June 07, 2010 03:05PM
4322
August 31, 2011 05:59AM
6609
July 28, 2006 08:22AM
5788
March 15, 2008 10:59AM
5283
March 17, 2008 04:10AM
14625
April 22, 2008 01:27PM
8761
June 16, 2008 04:40PM
6642
July 28, 2006 05:43PM
7850
August 30, 2006 09:33AM
6126
July 09, 2007 10:47AM
5284
May 23, 2008 12:34AM
8851
May 17, 2008 07:03AM
6942
May 22, 2008 12:07PM
5794
July 25, 2008 12:46PM
8821
November 14, 2007 03:15AM
8826
November 14, 2007 12:26PM
6284
January 10, 2008 10:39AM
5713
March 04, 2008 11:50AM
7532
June 03, 2008 10:58AM
7191
January 17, 2009 09:27PM
5488
January 18, 2009 07:33AM
5572
January 21, 2009 07:53PM
6209
January 24, 2009 09:09PM
5287
January 22, 2009 12:12AM
5362
January 23, 2009 04:52PM
3684
March 18, 2010 07:16PM
6672
January 21, 2008 02:07PM
5806
January 21, 2008 04:04PM
9452
January 22, 2008 10:56AM
6656
January 22, 2008 02:47PM
6119
February 09, 2008 05:56AM
8098
June 13, 2011 08:59AM
7946
February 09, 2008 05:58AM
6345
February 11, 2008 05:28PM
5533
May 11, 2008 12:31PM
12131
February 12, 2008 06:04PM
7908
March 11, 2008 05:17AM
4640
April 10, 2010 06:07PM
8919
August 25, 2008 07:22PM
9217
March 23, 2008 09:27AM
5695
April 19, 2008 05:08PM
5254
May 11, 2008 12:28PM
7887
March 28, 2008 10:20AM
6852
June 05, 2008 08:21AM
5183
May 20, 2009 06:30PM
5609
April 04, 2008 08:20AM
7908
April 18, 2008 12:52PM
5138
May 20, 2009 06:27PM
5983
April 29, 2008 04:17AM
8306
May 12, 2009 02:56PM
5869
May 13, 2009 01:26AM
5754
April 30, 2008 02:21PM
5486
June 05, 2008 08:02AM
7567
May 02, 2008 01:15PM
5562
May 08, 2008 08:13PM
5495
May 05, 2008 06:25AM
5808
May 08, 2008 09:05AM
7079
May 08, 2008 03:17PM
7985
June 04, 2008 01:47PM
7043
May 19, 2008 03:50AM
5139
May 29, 2008 04:34AM
5247
May 29, 2008 05:54AM
5489
June 02, 2008 11:47AM
12112
June 04, 2008 02:01PM
5378
June 05, 2008 06:07AM
6371
June 05, 2008 07:46AM
6823
June 09, 2008 02:31AM
4943
June 09, 2008 09:53AM
5280
June 11, 2008 10:47AM
5956
June 16, 2008 06:28AM
5406
June 24, 2008 08:32PM
4440
March 26, 2009 11:07AM
4693
March 26, 2009 12:15PM
7979
September 03, 2008 04:34PM
10056
September 05, 2008 04:09AM
5616
December 14, 2008 11:49AM
7989
May 19, 2009 08:31AM
5210
May 19, 2009 08:43AM
5597
August 30, 2009 09:27PM
6102
May 26, 2009 05:30PM
4531
June 12, 2009 04:14PM
4402
July 29, 2009 08:59AM
4384
August 02, 2009 09:19PM
5125
August 02, 2009 03:18PM
4813
August 28, 2009 06:55PM
8103
August 31, 2009 03:02PM
5480
September 07, 2009 03:51AM
4030
February 24, 2010 03:37PM
5169
September 14, 2009 01:54PM
Errores de Conexion
5266
September 24, 2009 09:43PM
4298
September 25, 2009 09:30AM
4661
October 07, 2009 01:51AM
6310
November 05, 2009 05:09PM
4643
November 25, 2009 06:51AM
7213
November 26, 2009 07:27AM
3727
November 26, 2009 04:13AM
4850
December 08, 2009 03:56PM
4163
December 28, 2009 10:31PM
4784
February 02, 2010 09:55AM
5207
February 11, 2010 12:06AM
11444
February 12, 2010 08:35AM
7466
February 12, 2010 09:20AM
4585
March 01, 2010 03:08PM
3870
March 03, 2010 08:23AM
5907
March 05, 2010 07:57AM
3417
March 06, 2010 04:37PM
4929
March 08, 2010 03:35PM
14107
March 29, 2010 10:12AM
4065
April 10, 2010 05:46PM
5375
April 13, 2010 03:43PM
3652
August 08, 2010 03:15PM
3468
August 08, 2010 03:54PM
2467
September 15, 2010 10:06AM
14147
September 18, 2010 10:24AM
3881
October 11, 2010 06:20PM
2733
October 10, 2010 10:05AM
2431
November 13, 2010 05:53AM
2756
October 18, 2010 04:05PM
2553
October 18, 2010 07:19PM
2262
October 18, 2010 07:34PM
2974
October 19, 2010 02:52PM
2930
October 25, 2010 09:30AM
2435
October 25, 2010 11:16AM
2246
January 14, 2011 05:37AM
2547
January 20, 2011 03:13PM
2632
January 23, 2011 09:41AM
3922
February 14, 2011 09:18AM
3482
January 31, 2011 04:19PM
3380
February 02, 2011 11:41AM
5209
March 03, 2011 02:57PM
2244
March 17, 2011 01:35PM
2735
July 30, 2011 10:51PM
1826
August 15, 2011 03:50PM
2889
September 20, 2011 10:54AM
1705
September 20, 2011 01:53PM
1744
October 14, 2011 08:21AM