0:031> !analyze -vvvvv ******************************************************************************* * * * Exception Analysis * * * ******************************************************************************* FAULTING_IP: mysqld!do_select+103 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 11416] 00000001`40198673 4889440a78 mov qword ptr [rdx+rcx+78h],rax EXCEPTION_RECORD: ffffffffffffffff -- (.exr 0xffffffffffffffff) ExceptionAddress: 0000000140198673 (mysqld!do_select+0x0000000000000103) ExceptionCode: c0000005 (Access violation) ExceptionFlags: 00000000 NumberParameters: 2 Parameter[0]: 0000000000000001 Parameter[1]: 0000000000000078 Attempt to write to address 0000000000000078 FAULTING_THREAD: 00000000000019d8 BUILD_VERSION_STRING: 5.2.3790.4480 (srv03_sp2_gdr.090321-1244) PROCESS_NAME: mysqld.exe ERROR_CODE: (NTSTATUS) 0xc0000005 - The instruction at "0x%08lx" referenced memory at "0x%08lx". The memory could not be "%s". EXCEPTION_CODE_STR: c0000005 WRITE_ADDRESS: 0000000000000078 WATSON_BKT_PROCVER: 5.5.10.0 WATSON_BKT_PROCSTAMP: 4d77aabb WATSON_BKT_MODULE: mysqld.exe WATSON_BKT_MODVER: 5.5.10.0 WATSON_BKT_MODSTAMP: 4d77aabb WATSON_BKT_MODOFFSET: 198673 NTGLOBALFLAG: 40000400 APPLICATION_VERIFIER_FLAGS: 0 LAST_CONTROL_TRANSFER: from 000000014019b1b9 to 0000000140198673 STACK_TEXT: 00000000`0e3cd5b0 00000001`4019b1b9 : 00000000`0b72bdd8 00000000`00000000 00000000`0b779e90 00000000`00000000 : mysqld!do_select+0x103 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 11416] 00000000`0e3cd600 00000001`4014d016 : 00000000`0e3cd6a0 00000000`0b49a7b8 00000000`00000001 00000001`4021348a : mysqld!JOIN::exec+0x11d9 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 2363] 00000000`0e3cd680 00000001`4014bee7 : 00000000`00000000 00000000`0b77b7d0 00000000`0b7381d8 00000001`40025fbd : mysqld!subselect_single_select_engine::exec+0x2f6 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\item_subselect.cc @ 1987] 00000000`0e3cd8b0 00000001`4014c772 : 00000000`00000001 00000000`0b77e088 00000000`0b6f8960 00000001`40195af6 : mysqld!Item_subselect::exec+0x37 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\item_subselect.cc @ 275] 00000000`0e3cd8e0 00000001`40039d69 : 00000000`0b77b7d0 00000000`0b6f8960 00000000`0b6fd1a8 00000001`402fe790 : mysqld!Item_exists_subselect::val_bool+0x12 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\item_subselect.cc @ 799] 00000000`0e3cd910 00000001`4017fe07 : 00000000`00000000 00000000`00000001 00000000`0b7381d8 00000001`4018056a : mysqld!Item_func_not::val_int+0x19 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\item_cmpfunc.cc @ 290] 00000000`0e3cd940 00000001`4018625b : 00000000`0b77b7d0 00000000`0b6f8960 00000000`00000000 00000001`40237fb6 : mysqld!evaluate_join_record+0xa7 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 11744] 00000000`0e3cd990 00000001`40198749 : 00000000`00000000 00000000`0b7381d8 00000000`0b7381d8 00000001`40155362 : mysqld!sub_select+0xab [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 11698] 00000000`0e3cd9c0 00000001`4019a4e2 : 00000000`0b49a8c0 00000000`00000000 00000000`0b7381d8 00000000`00000000 : mysqld!do_select+0x1d9 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 11458] 00000000`0e3cda10 00000001`4019b527 : 00000000`0b498c10 00000000`0b498c10 00000000`00000000 00000000`0b49a7b8 : mysqld!JOIN::exec+0x502 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 1971] 00000000`0e3cda90 00000001`4019b926 : 00000000`0b49a1b0 00000000`0b49a988 00000000`0b49a108 00000000`0b738140 : mysqld!mysql_select+0x2b7 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 2573] 00000000`0e3cdb20 00000001`40063912 : 00000000`00000000 00000000`0b49a108 00000000`0b498c10 00000000`00000080 : mysqld!handle_select+0x116 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 297] 00000000`0e3cdbc0 00000001`400662ea : 00000000`0b49a108 00000000`0b49a108 00000000`0e3cf1e0 00000000`0b498c10 : mysqld!mysql_execute_command+0x1532 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_parse.cc @ 2858] 00000000`0e3cf030 00000001`4006709a : 00000000`0b49b521 00000000`00000003 00000000`0b498c10 00000000`00000003 : mysqld!mysql_parse+0x10a [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_parse.cc @ 5514] 00000000`0e3cf090 00000001`40067e9c : 00000000`00000000 00000000`00000000 00000000`0b498c10 00000000`0b499779 : mysqld!dispatch_command+0x6da [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_parse.cc @ 1038] 00000000`0e3cfda0 00000001`4008ce7a : 00000000`00000000 00000000`00000000 00000000`0b498c10 00000000`0b498c10 : mysqld!do_command+0xec [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_parse.cc @ 772] 00000000`0e3cfdd0 00000001`4008d0e4 : 00000000`0b498c00 00000000`0b498c10 00000000`00000004 00000000`0000000b : mysqld!do_handle_one_connection+0x34a [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_connect.cc @ 748] 00000000`0e3cfec0 00000001`402103ee : 00000000`0b498c10 00000000`00000000 00000000`00000000 00000000`00000000 : mysqld!handle_one_connection+0x44 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_connect.cc @ 686] 00000000`0e3cfef0 00000001`403b193b : 00000000`01db5ce0 00000000`00000000 00000000`00000000 00000000`00000000 : mysqld!pthread_start+0x1e [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\mysys\my_winthread.c @ 63] 00000000`0e3cff20 00000001`403b19ef : 00000000`01db5ce0 00000000`00000000 00000001`403b1950 00000000`00000000 : mysqld!_callthreadstartex+0x17 [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\threadex.c @ 348] 00000000`0e3cff50 00000000`77d6b71a : 00000000`77d6b6e0 00000000`00000000 00000000`00000000 00000000`0e3cffa8 : mysqld!_threadstartex+0x9f [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\threadex.c @ 326] 00000000`0e3cff80 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadStart+0x3a FOLLOWUP_IP: mysqld!do_select+103 [g:\pb2\build\sb_0-3071094-1299687147.19\mysql-5.5.10\sql\sql_select.cc @ 11416] 00000001`40198673 4889440a78 mov qword ptr [rdx+rcx+78h],rax FAULT_INSTR_CODE: a448948 FAULTING_SOURCE_CODE: 11412: /* Set up select_end */ 11413: Next_select_func end_select= setup_end_select_func(join); 11414: if (join->tables) 11415: { >11416: join->join_tab[join->tables-1].next_select= end_select; 11417: 11418: join_tab=join->join_tab+join->const_tables; 11419: } 11420: join->send_records=0; 11421: if (join->tables == join->const_tables) SYMBOL_STACK_INDEX: 0 SYMBOL_NAME: mysqld!do_select+103 FOLLOWUP_NAME: MachineOwner MODULE_NAME: mysqld IMAGE_NAME: mysqld.exe DEBUG_FLR_IMAGE_TIMESTAMP: 4d77aabb THREAD_ATTRIBUTES: [ GLOBAL ] Global PID: [5316] Global Thread_Count: [70] Global PageSize: [4096] Global ProcessName: [mysqld.exe] Global CommandLine Global Desktop_Name: [WinSta0\Default] Global CPU_ProcessorCount: [1] Global CPU_MHZ: [2247] Global CPU_Architecture: [AMD64] Global CPU_Family: [15] Global CPU_Model: [15] Global CPU_Stepping: [2] Global CPU_VendorString: [] Global ProcessBeingDebugged Global GFlags: [1073742848] Global Application_Verifer_Flags: [0] Global SystemUpTime: [9 days 5:53:57.000] Global SystemUpTime: [798837] Global ProcessUpTime: [0 days 0:07:45.000] Global ProcessUpTime: [465] Global CurrentTimeDate: [Fri Apr 1 13:43:06.000 2011 (GMT+2)] Global CurrentTimeDate: [1301658186] Global ProductType: [1] Global SuiteMask: [272] Global ModList_SHA1_Hash: [6e0ad5b72f1b62d2da16dc8baf983d72effc04a6] [ THREAD ] 31 Id: 14c4.19d8 Frame[00] Is_OriginalExceptionThread Frame[00] Number_of_Stack_Frames: [0x16] Frame[00] NotSysEnter PROBLEM_CLASSES: NULL_CLASS_PTR_DEREFERENCE Tid [0x1f] Frame [00] DEFAULT_BUCKET_ID: NULL_CLASS_PTR_DEREFERENCE PRIMARY_PROBLEM_CLASS: NULL_CLASS_PTR_DEREFERENCE BUGCHECK_STR: APPLICATION_FAULT_NULL_CLASS_PTR_DEREFERENCE STACK_COMMAND: ~31s ; kb FAILURE_BUCKET_ID: X64_APPLICATION_FAULT_NULL_CLASS_PTR_DEREFERENCE_mysqld!do_select+103 BUCKET_ID: X64_APPLICATION_FAULT_NULL_CLASS_PTR_DEREFERENCE_mysqld!do_select+103 Followup: MachineOwner ---------