------------------------------- ERROR LOG ------------------------------- 081231 6:20:59 - mysqld got exception 0xc0000005 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=65536 max_used_connections=3 max_threads=235 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93067 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x2edd0300 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 0059C92D mysqld.exe!String::realloc()[sql_string.cc:86] 0059D05F mysqld.exe!copy_if_not_alloced()[sql_string.cc:756] 0048D730 mysqld.exe!Item_str_conv::val_str()[item_strfunc.cc:1070] 0048C26E mysqld.exe!Item_func_concat::val_str()[item_strfunc.cc:290] 0044E23A mysqld.exe!Item::field_type()[item.cc:4468] 006A167A mysqld.exe!innobase_release_temporary_latches()[ha_innodb.cc:543] 00443242 mysqld.exe!ha_release_temporary_latches()[handler.cc:1678] 00532082 mysqld.exe!select_send::send_data()[sql_class.cc:1559] 005711AF mysqld.exe!end_send()[sql_select.cc:11910] 0058ABA1 mysqld.exe!do_select()[sql_select.cc:10788] 0058BD29 mysqld.exe!JOIN::exec()[sql_select.cc:2182] 0058C383 mysqld.exe!mysql_select()[sql_select.cc:2363] 0058C7BB mysqld.exe!handle_select()[sql_select.cc:269] 005501B4 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:4888] 005512F6 mysqld.exe!mysql_execute_command()[sql_parse.cc:2184] 00556753 mysqld.exe!mysql_parse()[sql_parse.cc:5791] 00557234 mysqld.exe!dispatch_command()[sql_parse.cc:1202] 00558017 mysqld.exe!do_command()[sql_parse.cc:861] 005DA441 mysqld.exe!handle_one_connection()[sql_connect.cc:1115] 006401FB mysqld.exe!pthread_start()[my_winthread.c:85] 00724593 mysqld.exe!_callthreadstart()[thread.c:293] F773E900 Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 2CB6C080=SELECT DATE_FORMAT(fecha,GET_FORMAT(DATE,'EUR')) as fecha, hora, concat(upper(up.apellido),', ', up.nombre) as paciente, concat(upper(ue.apellido),', ', ue.nombre) as profesional,e.especialidad FROM turnos t LEFT JOIN usuarios up ON t.paciente_idusuario = up.idusuario LEFT JOIN especialidades_empleados ON t.idespecialidad_empleado = especialidades_empleados.idespecialidad_empleado LEFT JOIN usuarios ue ON especialidades_empleados.idusuario = ue.idusuario LEFT JOIN especialidades e ON especialidades_empleados.idespecialidad = e.idespecialidad WHERE t.idturno=643 thd->thread_id=465 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 090102 6:31:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090102 6:31:19 InnoDB: Started; log sequence number 0 16059995 090102 6:31:19 [Note] Event Scheduler: Loaded 0 events 090102 6:31:19 [Note] D:\Archivos de programa\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL) 090105 8:48:16 - mysqld got exception 0xc0000005 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=65536 max_used_connections=2 max_threads=235 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93067 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x2cb927a8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 7C82A648 ntdll.dll!wcslen() 007221A0 mysqld.exe!malloc()[malloc.c:163] 0062F215 mysqld.exe!my_malloc()[my_malloc.c:34] 006347B6 mysqld.exe!init_io_cache()[mf_iocache.c:238] 00603D75 mysqld.exe!mi_extra()[mi_extra.c:140] 005FED09 mysqld.exe!ha_myisam::extra()[ha_myisam.cc:1792] 005AF305 mysqld.exe!select_union::create_result_table()[sql_union.cc:127] 005398A2 mysqld.exe!mysql_derived_prepare()[sql_derived.cc:171] 005216CF mysqld.exe!lock_tables()[sql_base.cc:5356] 005277A5 mysqld.exe!open_and_lock_tables_derived()[sql_base.cc:4974] 00550072 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:4853] 005512F6 mysqld.exe!mysql_execute_command()[sql_parse.cc:2184] 00556753 mysqld.exe!mysql_parse()[sql_parse.cc:5791] 00557234 mysqld.exe!dispatch_command()[sql_parse.cc:1202] 00558017 mysqld.exe!do_command()[sql_parse.cc:861] 005DA441 mysqld.exe!handle_one_connection()[sql_connect.cc:1115] 006401FB mysqld.exe!pthread_start()[my_winthread.c:85] 00724593 mysqld.exe!_callthreadstart()[thread.c:293] F773E900 Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 2EEA3FC0=Select count(*) as cantcampos from ( SELECT usuarios.idInstitucionDefault, usuarios.idusuario, usuarios.nombreUsuario, usuarios.clave, usuarios.apellido, usuarios.nombre, usuarios.idtipodedocumento, usuarios.dni, usuarios.idlocalidad, usuarios.email, usuarios.fechanacimiento,pacientes.apellidomaterno, pacientes.idcategoria_carnet, pacientes.codigocarnet, pacientes.fechaemision, pacientes.fechavencimiento, pacientes.idestado_civil, pacientes.idgruposanguineo, pacientes.aptodonante, pacientes.donantesangre, pacientes.donanteorganos, pacientes.sexo,pacientes.observaciones,tiposdedocumento.tipodedocumento, localidades.localidad, categorias_carnet.categorias_carnet, estados_civiles.estadocivil, grupos_sanguineos.gruposanguineo, grupos_sanguineos.factor FROM (usuarios INNER JOIN pacientes ON usuarios.idusuario = pacientes.idusuario LEFT JOIN tiposdedocumento ON usuarios.idtipodedocumento = tiposdedocumento.idtipodedocument thd->thread_id=1138 thd->killed=NOT_KILLED The manual page at c contains information that should help you find out what is causing the crash. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 090105 9:08:21 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090105 9:08:25 InnoDB: Started; log sequence number 0 16514075 090105 9:08:28 [Note] Event Scheduler: Loaded 0 events 090105 9:08:29 [Note] D:\Archivos de programa\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL) 090105 9:08:40 [Note] D:\Archivos de programa\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown 090105 9:08:40 [Note] Event Scheduler: Purging the queue. 0 events 090105 9:08:40 InnoDB: Starting shutdown... 090105 9:08:41 InnoDB: Shutdown completed; log sequence number 0 16514075 090105 9:08:41 [Note] D:\Archivos de programa\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete 090105 9:08:44 InnoDB: Started; log sequence number 0 16514075 090105 9:08:44 [Note] Event Scheduler: Loaded 0 events 090105 9:08:44 [Note] D:\Archivos de programa\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)