090327 13:36:55 mysqld_safe Starting mysqld daemon with databases from /data/mysql-6.0/var 090327 13:36:56 [Note] Event Scheduler: Loaded 0 events 090327 13:36:56 [Note] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld: ready for connections. Version: '6.0.10-alpha' socket: '/tmp/mysql.sock' port: 3306 Source distribution === Scavenge Cycle 1 - FALCON_MASTER - 0 seconds === Scavenge Cycle 2 - FALCON_MASTER - 0 seconds === Scavenge Cycle 3 - FALCON_MASTER - 0 seconds === Scavenge Cycle 4 - FALCON_MASTER - 0 seconds === Scavenge Cycle 5 - FALCON_MASTER - 0 seconds === Scavenge Cycle 6 - FALCON_MASTER - 1 seconds === Scavenge Cycle 7 - FALCON_MASTER - 1 seconds === Scavenge Cycle 8 - FALCON_MASTER - 1 seconds === Scavenge Cycle 9 - FALCON_MASTER - 2 seconds === Scavenge Cycle 10 - FALCON_MASTER - 2 seconds === Scavenge Cycle 11 - FALCON_MASTER - 1 seconds === Scavenge Cycle 12 - FALCON_MASTER - 1 seconds === Scavenge Cycle 13 - FALCON_MASTER - 2 seconds === Scavenge Cycle 14 - FALCON_MASTER - 2 seconds === Scavenge Cycle 15 - FALCON_MASTER - 2 seconds === Scavenge Cycle 16 - FALCON_MASTER - 3 seconds === Scavenge Cycle 17 - FALCON_MASTER - 3 seconds === Scavenge Cycle 18 - FALCON_MASTER - 3 seconds === Scavenge Cycle 19 - FALCON_MASTER - 3 seconds === Scavenge Cycle 20 - FALCON_MASTER - 4 seconds === Scavenge Cycle 21 - FALCON_MASTER - 4 seconds Cycle=21 Base Generation=1 Scavenge Generation=0 Forced=0 Low Memory=0 Cycle=21 Oldest Active Transaction=503 Cycle=21 Threshold=2147483648 Floor=1073741824 Now=816913928 Cycle=21 Age=1 Size=816913928 Cycle=21 Very Old Records=0 Size=0 Cycle=21 Inventory; Total records=2190516 containing 816915296 bytes Cycle=21 Inventory; Pruneable records=8 containing 1368 bytes Cycle=21 Inventory; Retireable records=2170508 containing 809443728 bytes Cycle=21 Inventory; unScavengeable records=20000 containing 7470200 bytes Cycle=21 Results; Pruned 8 records, 1368 bytes in 4 seconds Cycle=21 Results; Retired 0 records, 0 bytes in 0 seconds Cycle=21 Results; Remaining 2190508 Records, 816913928 remaining bytes Cycle=21 Results; Active memory at Scavenge Start=811326464 Cycle=21 Results; Active memory after Pruning Records=816913928 Cycle=21 Results; Active memory after Retiring Records=816913928 === Scavenge Cycle 22 - FALCON_MASTER - 4 seconds === Scavenge Cycle 23 - FALCON_MASTER - 5 seconds === Scavenge Cycle 24 - FALCON_MASTER - 4 seconds === Scavenge Cycle 25 - FALCON_MASTER - 4 seconds === Scavenge Cycle 26 - FALCON_MASTER - 4 seconds === Scavenge Cycle 27 - FALCON_MASTER - 6 seconds === Scavenge Cycle 28 - FALCON_MASTER - 5 seconds === Scavenge Cycle 29 - FALCON_MASTER - 7 seconds === Scavenge Cycle 30 - FALCON_MASTER - 6 seconds === Scavenge Cycle 31 - FALCON_MASTER - 7 seconds === Scavenge Cycle 32 - FALCON_MASTER - 8 seconds === Scavenge Cycle 33 - FALCON_MASTER - 9 seconds === Scavenge Cycle 34 - FALCON_MASTER - 10 seconds === Scavenge Cycle 35 - FALCON_MASTER - 10 seconds === Scavenge Cycle 36 - FALCON_MASTER - 11 seconds === Scavenge Cycle 37 - FALCON_MASTER - 12 seconds === Scavenge Cycle 38 - FALCON_MASTER - 12 seconds === Scavenge Cycle 39 - FALCON_MASTER - 13 seconds === Scavenge Cycle 40 - FALCON_MASTER - 27 seconds Cycle=40 Base Generation=5 Scavenge Generation=1 Forced=0 Low Memory=0 Cycle=40 Oldest Active Transaction=1609 Cycle=40 Threshold=2147483648 Floor=1073741824 Now=964411832 Cycle=40 Age=5 Size=479579208 Cycle=40 Age=4 Size=180730152 Cycle=40 Age=3 Size=119129784 Cycle=40 Age=2 Size=153260720 Cycle=40 Age=1 Size=1236764008 Cycle=40 Very Old Records=0 Size=0 Cycle=40 Inventory; Total records=7809815 containing 2169465232 bytes Cycle=40 Inventory; Pruneable records=0 containing 0 bytes Cycle=40 Inventory; Retireable records=7671502 containing 2137377192 bytes Cycle=40 Inventory; unScavengeable records=138313 containing 32088040 bytes Cycle=40 Results; Pruned 0 records, 0 bytes in 13 seconds Cycle=40 Results; Retired 3539185 records, 1236764008 bytes in 14 seconds Cycle=40 Results; Remaining 0 Records, 0 remaining bytes Cycle=40 Results; Active memory at Scavenge Start=2138552008 Cycle=40 Results; Active memory after Pruning Records=2169859400 Cycle=40 Results; Active memory after Retiring Records=964411832 === Scavenge Cycle 41 - FALCON_MASTER - 8 seconds Cycle=41 Base Generation=5 Scavenge Generation=0 Forced=0 Low Memory=0 Cycle=41 Oldest Active Transaction=1671 Cycle=41 Threshold=2147483648 Floor=1073741824 Now=990759144 Cycle=41 Age=5 Size=537157056 Cycle=41 Age=4 Size=180730152 Cycle=41 Age=3 Size=119129784 Cycle=41 Age=2 Size=153260720 Cycle=41 Very Old Records=0 Size=0 Cycle=41 Inventory; Total records=4518106 containing 990279072 bytes Cycle=41 Inventory; Pruneable records=6 containing 1360 bytes Cycle=41 Inventory; Retireable records=4432323 containing 970308584 bytes Cycle=41 Inventory; unScavengeable records=85777 containing 19969128 bytes Cycle=41 Results; Pruned 6 records, 1360 bytes in 8 seconds Cycle=41 Results; Retired 0 records, 0 bytes in 0 seconds Cycle=41 Results; Remaining 4518100 Records, 990277712 remaining bytes Cycle=41 Results; Active memory at Scavenge Start=972633952 Cycle=41 Results; Active memory after Pruning Records=990759144 Cycle=41 Results; Active memory after Retiring Records=990759144 === Scavenge Cycle 42 - FALCON_MASTER - 8 seconds === Scavenge Cycle 43 - FALCON_MASTER - 9 seconds === Scavenge Cycle 44 - FALCON_MASTER - 9 seconds === Scavenge Cycle 45 - FALCON_MASTER - 9 seconds === Scavenge Cycle 46 - FALCON_MASTER - 10 seconds === Scavenge Cycle 47 - FALCON_MASTER - 11 seconds === Scavenge Cycle 48 - FALCON_MASTER - 11 seconds === Scavenge Cycle 49 - FALCON_MASTER - 12 seconds === Scavenge Cycle 50 - FALCON_MASTER - 13 seconds === Scavenge Cycle 51 - FALCON_MASTER - 13 seconds === Scavenge Cycle 52 - FALCON_MASTER - 13 seconds === Scavenge Cycle 53 - FALCON_MASTER - 13 seconds === Scavenge Cycle 54 - FALCON_MASTER - 15 seconds === Scavenge Cycle 55 - FALCON_MASTER - 15 seconds === Scavenge Cycle 56 - FALCON_MASTER - 15 seconds === Scavenge Cycle 57 - FALCON_MASTER - 16 seconds === Scavenge Cycle 58 - FALCON_MASTER - 18 seconds === Scavenge Cycle 59 - FALCON_MASTER - 18 seconds === Scavenge Cycle 60 - FALCON_MASTER - 20 seconds === Scavenge Cycle 61 - FALCON_MASTER - 20 seconds Cycle=61 Base Generation=5 Scavenge Generation=0 Forced=0 Low Memory=0 Cycle=61 Oldest Active Transaction=2797 Cycle=61 Threshold=2147483648 Floor=1073741824 Now=2322699576 Cycle=61 Age=5 Size=1864050712 Cycle=61 Age=4 Size=180730152 Cycle=61 Age=3 Size=119129784 Cycle=61 Age=2 Size=153260720 Cycle=61 Very Old Records=0 Size=0 Cycle=61 Inventory; Total records=10228768 containing 2317171600 bytes Cycle=61 Inventory; Pruneable records=1 containing 232 bytes Cycle=61 Inventory; Retireable records=10052323 containing 2276237280 bytes Cycle=61 Inventory; unScavengeable records=176444 containing 40934088 bytes Cycle=61 Results; Pruned 1 records, 232 bytes in 18 seconds Cycle=61 Results; Retired 0 records, 0 bytes in 2 seconds Cycle=61 Results; Remaining 10228767 Records, 2317171368 remaining bytes Cycle=61 Results; Active memory at Scavenge Start=2277926056 Cycle=61 Results; Active memory after Pruning Records=2317577600 Cycle=61 Results; Active memory after Retiring Records=2322699576 === Scavenge Cycle 62 - FALCON_MASTER - 19 seconds === Scavenge Cycle 63 - FALCON_MASTER - 21 seconds === Scavenge Cycle 64 - FALCON_MASTER - 20 seconds === Scavenge Cycle 65 - FALCON_MASTER - 22 seconds === Scavenge Cycle 66 - FALCON_MASTER - 21 seconds === Scavenge Cycle 67 - FALCON_MASTER - 22 seconds === Scavenge Cycle 68 - FALCON_MASTER - 22 seconds === Scavenge Cycle 69 - FALCON_MASTER - 22 seconds === Scavenge Cycle 70 - FALCON_MASTER - 24 seconds === Scavenge Cycle 71 - FALCON_MASTER - 24 seconds === Scavenge Cycle 72 - FALCON_MASTER - 24 seconds === Scavenge Cycle 73 - FALCON_MASTER - 24 seconds === Scavenge Cycle 74 - FALCON_MASTER - 26 seconds === Scavenge Cycle 75 - FALCON_MASTER - 25 seconds === Scavenge Cycle 76 - FALCON_MASTER - 26 seconds === Scavenge Cycle 77 - FALCON_MASTER - 26 seconds === Scavenge Cycle 78 - FALCON_MASTER - 27 seconds === Scavenge Cycle 79 - FALCON_MASTER - 28 seconds === Scavenge Cycle 80 - FALCON_MASTER - 27 seconds === Scavenge Cycle 81 - FALCON_MASTER - 30 seconds Cycle=81 Base Generation=5 Scavenge Generation=0 Forced=0 Low Memory=0 Cycle=81 Oldest Active Transaction=3733 Cycle=81 Threshold=2147483648 Floor=1073741824 Now=3427753128 Cycle=81 Age=5 Size=2966769152 Cycle=81 Age=4 Size=180730152 Cycle=81 Age=3 Size=119129784 Cycle=81 Age=2 Size=153260720 Cycle=81 Very Old Records=0 Size=0 Cycle=81 Inventory; Total records=14981859 containing 3419890040 bytes Cycle=81 Inventory; Pruneable records=1 containing 232 bytes Cycle=81 Inventory; Retireable records=14722323 containing 3359676520 bytes Cycle=81 Inventory; unScavengeable records=259535 containing 60213288 bytes Cycle=81 Results; Pruned 1 records, 232 bytes in 27 seconds Cycle=81 Results; Retired 0 records, 0 bytes in 3 seconds Cycle=81 Results; Remaining 14981858 Records, 3419889808 remaining bytes Cycle=81 Results; Active memory at Scavenge Start=3361603992 Cycle=81 Results; Active memory after Pruning Records=3420045480 Cycle=81 Results; Active memory after Retiring Records=3427753128 === Scavenge Cycle 82 - FALCON_MASTER - 29 seconds === Scavenge Cycle 83 - FALCON_MASTER - 29 seconds === Scavenge Cycle 84 - FALCON_MASTER - 30 seconds === Scavenge Cycle 85 - FALCON_MASTER - 32 seconds === Scavenge Cycle 86 - FALCON_MASTER - 31 seconds === Scavenge Cycle 87 - FALCON_MASTER - 31 seconds === Scavenge Cycle 88 - FALCON_MASTER - 32 seconds === Scavenge Cycle 89 - FALCON_MASTER - 31 seconds === Scavenge Cycle 90 - FALCON_MASTER - 31 seconds === Scavenge Cycle 91 - FALCON_MASTER - 33 seconds === Scavenge Cycle 92 - FALCON_MASTER - 31 seconds === Scavenge Cycle 93 - FALCON_MASTER - 31 seconds === Scavenge Cycle 94 - FALCON_MASTER - 32 seconds === Scavenge Cycle 95 - FALCON_MASTER - 31 seconds === Scavenge Cycle 96 - FALCON_MASTER - 32 seconds === Scavenge Cycle 97 - FALCON_MASTER - 31 seconds === Scavenge Cycle 98 - FALCON_MASTER - 32 seconds === Scavenge Cycle 99 - FALCON_MASTER - 31 seconds === Scavenge Cycle 100 - FALCON_MASTER - 31 seconds === Scavenge Cycle 101 - FALCON_MASTER - 33 seconds === Scavenge Cycle 102 - FALCON_MASTER - 31 seconds 090327 14:24:38 [Note] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld: Normal shutdown 090327 14:24:38 [Note] Event Scheduler: Purging the queue. 0 events === Scavenge Cycle 103 - FALCON_MASTER - 18 seconds 090327 14:25:39 [Note] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld: Shutdown complete 090327 14:25:43 mysqld_safe mysqld from pid file /data/mysql-6.0/var/saemrmb2.pid ended 090327 14:31:19 mysqld_safe Starting mysqld daemon with databases from /data/mysql-6.0/var 090327 14:31:20 [Note] Event Scheduler: Loaded 0 events 090327 14:31:20 [Note] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld: ready for connections. Version: '6.0.10-alpha' socket: '/tmp/mysql.sock' port: 3306 Source distribution === Scavenge Cycle 1 - FALCON_MASTER - 0 seconds === Scavenge Cycle 2 - FALCON_MASTER - 0 seconds === Scavenge Cycle 3 - FALCON_MASTER - 0 seconds 090327 14:32:29 - mysqld got signal 8 ; 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=8384512 read_buffer_size=131072 max_used_connections=1 max_threads=1601 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3508787 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x1746626c0 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... stack_bottom = ffffffff7c83ff38 thread_stack 0x40000 /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'my_print_stacktrace+0x18 [0x100552ee4] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'handle_segfault+0x45c [0x100227d28] /lib/sparcv9/libc.so.1'__sighndlr+0xc [0xffffffff7edc30d8] /lib/sparcv9/libc.so.1'call_user_handler+0x1a0 [0xffffffff7edb6e00] /lib/sparcv9/libc.so.1'sigacthandler+0x4c [0xffffffff7edb72e0] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN7SectionC1EP3Dbbij+0x98 [0x1004e306c] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN3Dbb11findSectionEi+0x80 [0x100484f04] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN5Table12findSectionsEv+0x15c [0x100449214] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN5Table9fetchNextEi+0x758 [0x100451f14] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN15StorageDatabase7nextRowEP12StorageTableib+0xb8 [0x10043ac9c] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN16StorageInterface8rnd_nextEPh+0x6c [0x10042ebcc] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z13rr_sequentialP11READ_RECORD+0x20 [0x10033388c] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z21join_init_read_recordP13st_join_table+0x70 [0x100291334] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z10sub_selectP4JOINP13st_join_tableb+0x8c [0x1002a5508] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z9do_selectP4JOINP4ListI4ItemEP5TABLEP9Procedure+0x44c [0x1002a6388] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_ZN4JOIN4execEv+0x16c0 [0x1002bb428] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1a4 [0x1002bcb14] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z13handle_selectP3THDP3LEXP13select_resultm+0x128 [0x1002bd694] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z21execute_sqlcom_selectP3THDP10TABLE_LIST+0x94 [0x10023701c] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z21mysql_execute_commandP3THD+0x1ad8 [0x10023b5b8] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z11mysql_parseP3THDPKcjPS2_+0x238 [0x10023fe94] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z16dispatch_command19enum_server_commandP3THDPcj+0x980 [0x100240824] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'_Z10do_commandP3THD+0x90 [0x1002412a8] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld'handle_one_connection+0x1ac [0x100233fa0] /lib/sparcv9/libc.so.1'_lwp_start+0x0 [0xffffffff7edc2fe0] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 1746d86c8 = select count(*) from customer thd->thread_id=1 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. 090327 14:32:29 mysqld_safe mysqld restarted 090327 14:32:30 [Note] Event Scheduler: Loaded 0 events 090327 14:32:30 [Note] /export/vcarbone/myopt/mysql-6.0.10-alpha/libexec/mysqld: ready for connections. Version: '6.0.10-alpha' socket: '/tmp/mysql.sock' port: 3306 Source distribution === Scavenge Cycle 1 - FALCON_MASTER - 0 seconds === Scavenge Cycle 2 - FALCON_MASTER - 0 seconds === Scavenge Cycle 3 - FALCON_MASTER - 0 seconds === Scavenge Cycle 4 - FALCON_MASTER - 0 seconds