Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: N/A
-
Component/s: None
-
Labels:None
-
Environment:CentOS release 6.3 (Final) 2.6.32-279.el6.x86_64
5.5.31-MariaDB-log
Description
140421 10:07:23 InnoDB: Assertion failure in thread 47429123118848 in file btr0pcur.c line 254 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 140421 10:07:23 [ERROR] mysqld got signal 6 ; 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. To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 5.5.31-MariaDB-log key_buffer_size=2147483648 read_buffer_size=4194304 max_used_connections=60 max_threads=3002 thread_count=43 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 39039253 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x8a80f920 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 = 0x2b22f4090e20 thread_stack 0x48000 (my_addr_resolve failure: fork) /apps/svr/mariadb5/bin/mysqld(my_print_stacktrace+0x2e) [0xb059fe] /apps/svr/mariadb5/bin/mysqld(handle_fatal_signal+0x422) [0x6eb552] /lib64/libpthread.so.0() [0x348bc0f500] /lib64/libc.so.6(gsignal+0x35) [0x348b8328a5] /lib64/libc.so.6(abort+0x175) [0x348b834085] /apps/svr/mariadb5/bin/mysqld() [0x8da6cb] /apps/svr/mariadb5/bin/mysqld() [0x886ce4] /apps/svr/mariadb5/bin/mysqld() [0x88b2bd] /apps/svr/mariadb5/bin/mysqld() [0x85aea1] /apps/svr/mariadb5/bin/mysqld(handler::read_range_next()+0xf3) [0x6efee3] /apps/svr/mariadb5/bin/mysqld(handler::multi_range_read_next(void**)+0xd2) [0x682ad2] /apps/svr/mariadb5/bin/mysqld(Mrr_simple_index_reader::get_next(void**)+0x20) [0x682b20] /apps/svr/mariadb5/bin/mysqld(Mrr_ordered_rndpos_reader::refill_from_index_reader()+0x74) [0x685074] /apps/svr/mariadb5/bin/mysqld(Mrr_ordered_rndpos_reader::refill_buffer(bool)+0x54) [0x685194] /apps/svr/mariadb5/bin/mysqld(DsMrr_impl::dsmrr_next(void**)+0x45) [0x682d75] /apps/svr/mariadb5/bin/mysqld(QUICK_RANGE_SELECT::get_next()+0x52) [0x7e23e2] /apps/svr/mariadb5/bin/mysqld() [0x801b9d] /apps/svr/mariadb5/bin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x13c) [0x5cd36c] /apps/svr/mariadb5/bin/mysqld() [0x5cda4d] /apps/svr/mariadb5/bin/mysqld(JOIN::exec()+0xaf3) [0x5e0193] /apps/svr/mariadb5/bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x1c8) [0x5e26d8] /apps/svr/mariadb5/bin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x2b4) [0x5e3324] /apps/svr/mariadb5/bin/mysqld() [0x58d8a8] /apps/svr/mariadb5/bin/mysqld(mysql_execute_command(THD*)+0x1e99) [0x591929] /apps/svr/mariadb5/bin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x1b0) [0x596d80] /apps/svr/mariadb5/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x15da) [0x59836a] /apps/svr/mariadb5/bin/mysqld(do_command(THD*)+0xdb) [0x59870b] /apps/svr/mariadb5/bin/mysqld(do_handle_one_connection(THD*)+0x144) [0x6529c4] /apps/svr/mariadb5/bin/mysqld(handle_one_connection+0x4c) [0x652afc] /apps/svr/mariadb5/bin/mysqld() [0xa79458] /lib64/libpthread.so.0() [0x348bc07851] /lib64/libc.so.6(clone+0x6d) [0x348b8e767d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b22fc002c38): SELECT T.TMS_ORDER_ID, T.CUST_CODE FROM TMS_ORDER T use index (IND_ORDER_N1) WHERE T.ORDER_SUB_TYPE = 11 AND T.BUYER_CITY IS NOT NULL AND T.BUYER_AREA_ID IS NOT NULL AND T.BUYER_STATE IS NOT NULL AND T.CREATED_OFFICE = 'VIP_NH' AND (T.CARRIAGE IS NULL OR T.CARRIAGE = 0) AND T.BUYER_ADDRESS = ' . . 92 1201' AND T.BUYER_AREA_ID = '104104119002' AND ( (T.BUY_TOWN IS NULL ) OR (T.BUY_TOWN = null)) AND ( ( T.TRANSPORT_DAY IS NULL ) OR (T.TRANSPORT_DAY = ' ( / )')) -- AND T.BUYER is not null AND ( (T.MOBILE IS NULL) OR (T.MOBILE = '18664055899')) AND ( ( T.BUYER_TEL IS NULL ) OR (T.BUYER_TEL = '')) AND ( ( T.TRANSPORT_TYPE IS NULL ) OR (T.TRANSPORT_TYPE = 0)) AND (T.IS_COD = 1) AND T.ADD_TIME > TIMESTAMPADD(DAY, -14, CURRENT_TIMESTAMP) LIMIT 1 Connection ID (thread ID): 25474 Status: KILL_QUERY Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=on,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off 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. 140421 10:07:24 mysqld_safe Number of processes running now: 0 140421 10:07:24 mysqld_safe mysqld restarted 140421 10:07:24 InnoDB: The InnoDB memory heap is disabled 140421 10:07:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140421 10:07:24 InnoDB: Compressed tables use zlib 1.2.3 140421 10:07:24 InnoDB: Using Linux native AIO 140421 10:07:24 InnoDB: Initializing buffer pool, size = 80.0G 140421 10:07:29 InnoDB: Completed initialization of buffer pool 140421 10:07:29 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1557115877541 140421 10:07:29 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... InnoDB: Doing recovery: scanned up to log sequence number 1557121120256 InnoDB: Doing recovery: scanned up to log sequence number 1557126363136 InnoDB: Doing recovery: scanned up to log sequence number 1557131606016 InnoDB: Doing recovery: scanned up to log sequence number 1557133065602 140421 10:07:31 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 140421 10:07:38 InnoDB: Waiting for the background threads to start 140421 10:07:39 Percona XtraDB (http://www.percona.com) 5.5.31-MariaDB-30.2 started; log sequence number 1557133065602 140421 10:07:39 [Note] Recovering after a crash using /apps/dbdat/mariadb5_data3306/log/mysql-bin 140421 10:07:39 [Note] Starting crash recovery... 140421 10:07:39 [Note] Crash recovery finished. 140421 10:07:39 [Note] Server socket created on IP: '0.0.0.0'. 140421 10:07:39 [Warning] 'user' entry 'root@GD6G2S113' ignored in --skip-name-resolve mode. 140421 10:07:39 [Warning] 'user' entry '@GD6G2S113' ignored in --skip-name-resolve mode. 140421 10:07:39 [Warning] 'proxies_priv' entry '@ root@GD6G2S113' ignored in --skip-name-resolve mode. 140421 10:07:39 [Note] /apps/svr/mariadb5/bin/mysqld: ready for connections. Version: '5.5.31-MariaDB-log' socket: '/tmp/mysql3306.sock' port: 3306 MariaDB Server 140421 10:07:39 [Note] Event Scheduler: scheduler thread started with id 1
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Is the crash repeatable?
----yes
Table: TMS_ORDER
Create Table: CREATE TABLE `tms_order` (
`tms_order_id` varchar(50) NOT NULL,
`return_box_time` datetime DEFAULT NULL,
`purchase_order_id` varchar(30) DEFAULT NULL,
`is_count_fee` int(1) DEFAULT NULL,
`easybreak` int(1) DEFAULT NULL,
`vip_club_name` varchar(30) DEFAULT NULL,
`user_type_name` varchar(30) DEFAULT NULL,
`transport_type_name` varchar(100) DEFAULT NULL,
`surplus` decimal(18,4) DEFAULT NULL,
`carriage` decimal(18,4) DEFAULT NULL,
`join_time` datetime DEFAULT NULL,
`total_pack` bigint(10) DEFAULT NULL,
`order_sn` varchar(30) DEFAULT NULL,
`is_pay` int(1) DEFAULT NULL,
`order_no` varchar(30) DEFAULT NULL,
`is_cod` int(1) DEFAULT NULL,
`resend_type` int(3) DEFAULT NULL,
`user_id` varchar(50) DEFAULT NULL,
`buyer` varchar(50) DEFAULT NULL,
`vendor_code` varchar(20) DEFAULT NULL,
`vendor_name` varchar(40) DEFAULT NULL,
`buyer_address` varchar(200) DEFAULT NULL,
`post_code` varchar(10) DEFAULT NULL,
`buyer_area_id` varchar(20) DEFAULT NULL,
`buyer_address2` varchar(200) DEFAULT NULL,
`buyer_address3` varchar(200) DEFAULT NULL,
`buyer_city` varchar(20) DEFAULT NULL,
`buyer_state` varchar(20) DEFAULT NULL,
`buyer_country_id` varchar(20) DEFAULT NULL,
`buyer_tel` varchar(200) DEFAULT NULL,
`po_type` int(3) DEFAULT NULL,
`po_period_valid` varchar(50) DEFAULT NULL,
`po_buyer` varchar(40) DEFAULT NULL,
`mobile` varchar(50) DEFAULT NULL,
`transport_id` int(3) DEFAULT NULL,
`transport_type` varchar(50) DEFAULT NULL,
`add_time` datetime DEFAULT NULL,
`pay_type` varchar(50) DEFAULT NULL,
`transport_day` varchar(200) DEFAULT NULL,
`remark` varchar(500) DEFAULT NULL,
`order_type` varchar(20) DEFAULT NULL,
`vip_club` int(3) DEFAULT NULL,
`invoice` varchar(128) DEFAULT NULL,
`goods_money` decimal(18,4) DEFAULT NULL,
`money` decimal(18,4) DEFAULT NULL,
`aigo` decimal(10,2) DEFAULT NULL,
`favourable_money` decimal(18,4) DEFAULT NULL,
`ex_fav_money` decimal(18,4) DEFAULT NULL,
`user_type` int(3) DEFAULT NULL,
`ex_pay_money1` decimal(18,4) DEFAULT NULL,
`ex_pay_money2` decimal(18,4) DEFAULT NULL,
`ex_pay_money3` decimal(18,4) DEFAULT NULL,
`is_hold` int(1) DEFAULT NULL,
`old_order_sn` varchar(30) DEFAULT NULL,
`iud_flag` int(1) DEFAULT NULL,
`transport_no` varchar(30) DEFAULT NULL,
`original_service_level` decimal(10,2) DEFAULT NULL,
`original_volume` decimal(18,4) DEFAULT NULL,
`original_volume_unit` varchar(50) DEFAULT NULL,
`original_weight` decimal(18,4) DEFAULT NULL,
`original_weight_unit` varchar(50) DEFAULT NULL,
`original_amount` decimal(18,4) DEFAULT NULL,
`transport_worker_name` varchar(30) DEFAULT NULL,
`amount_unit` varchar(50) DEFAULT NULL,
`order_sub_type` int(3) DEFAULT NULL,
`order_status` int(3) DEFAULT NULL,
`sign_in_man` varchar(30) DEFAULT NULL,
`is_autopicked` int(3) DEFAULT NULL,
`jion_cust_worker` varchar(30) DEFAULT NULL,
`accept_manipulat_matc_time` datetime DEFAULT NULL,
`cust_number` bigint(10) DEFAULT NULL,
`is_track` int(1) DEFAULT NULL,
`is_exceptional` int(1) DEFAULT NULL,
`is_insurance` int(1) DEFAULT NULL,
`close_man` varchar(30) DEFAULT NULL,
`rejection_time` datetime DEFAULT NULL,
`sign_in_time` datetime DEFAULT NULL,
`is_closed` int(1) DEFAULT NULL,
`circular_worker_name` varchar(30) DEFAULT NULL,
`close_time` datetime DEFAULT NULL,
`close_man_code` varchar(20) DEFAULT NULL,
`is_circular` int(1) DEFAULT NULL,
`circular_worker` varchar(20) DEFAULT NULL,
`eta` datetime DEFAULT NULL,
`atd` datetime DEFAULT NULL,
`circular_time` datetime DEFAULT NULL,
`ori_city` varchar(20) DEFAULT NULL,
`tms_original_order_id` varchar(50) DEFAULT NULL,
`return_type` int(3) DEFAULT NULL,
`returnno` varchar(30) DEFAULT NULL,
`created_by_user` varchar(50) DEFAULT NULL,
`created_office` varchar(50) DEFAULT NULL,
`created_dtm_loc` datetime DEFAULT NULL,
`created_time_zone` varchar(50) DEFAULT NULL,
`updated_office` varchar(50) DEFAULT NULL,
`updated_by_user` varchar(50) DEFAULT NULL,
`updated_dtm_loc` datetime DEFAULT NULL,
`is_refuce` int(1) DEFAULT NULL,
`cust_code` varchar(20) DEFAULT NULL,
`current_delivery_point` varchar(20) DEFAULT NULL,
`delivery_point` varchar(50) DEFAULT NULL,
`updated_time_zone` varchar(50) DEFAULT NULL,
`record_version` bigint(10) NOT NULL,
`cust_type` int(3) DEFAULT NULL,
`is_delete` int(1) DEFAULT NULL,
`aux1` varchar(30) DEFAULT NULL,
`aux2` varchar(30) DEFAULT NULL,
`aux3` varchar(30) DEFAULT NULL,
`aux4` varchar(30) DEFAULT NULL,
`aux5` varchar(30) DEFAULT NULL,
`is_feed_back` int(1) DEFAULT NULL,
`auto_freight` int(1) DEFAULT NULL,
`fiscal_year` varchar(10) DEFAULT NULL,
`is_update` int(1) DEFAULT NULL,
`is_special_return` int(3) DEFAULT NULL,
`cust_counter_amount` decimal(18,4) DEFAULT NULL,
`cust_claim_amount` decimal(18,4) DEFAULT NULL,
`insurance_claim_amount` decimal(18,4) DEFAULT NULL,
`oqc_date` datetime DEFAULT NULL,
`return_goods_contact` varchar(40) DEFAULT NULL,
`return_goods_phone` varchar(50) DEFAULT NULL,
`return_goods_type` int(3) DEFAULT NULL,
`brand` varchar(512) DEFAULT NULL,
`merchants_interface` varchar(40) DEFAULT NULL,
`merchants_interface_phone` varchar(50) DEFAULT NULL,
`return_special_requirements` varchar(500) DEFAULT NULL,
`payment` int(3) DEFAULT NULL,
`return_vendor_contact` varchar(40) DEFAULT NULL,
`delivery_mode` int(3) DEFAULT NULL,
`received_unit` varchar(100) DEFAULT NULL,
`transport_mode` int(3) DEFAULT NULL,
`deliver_goods_man_link` varchar(40) DEFAULT NULL,
`deliver_goods_man_phone` varchar(50) DEFAULT NULL,
`is_in_station` int(1) DEFAULT NULL,
`buy_town` varchar(20) DEFAULT NULL,
`cancel_status` int(3) DEFAULT NULL,
`way_of_settlement` varchar(20) DEFAULT NULL,
`ldp_join_time` datetime DEFAULT NULL,
`re_billing_remark` varchar(500) DEFAULT NULL,
`ext_pay_type` int(2) DEFAULT NULL,
`appraised_time` datetime DEFAULT NULL,
`order_batch_no` varchar(50) DEFAULT NULL,
`order_main_cust` varchar(20) DEFAULT NULL,
`b2c_user_name` varchar(20) DEFAULT NULL COMMENT '会员姓名',
`MERGE_ORDER_SNS` varchar(2000) DEFAULT NULL COMMENT '合并订单明细',
`MERGE_PARENT_ORDER_SN` varchar(50) DEFAULT NULL COMMENT '所属合并订单',
`MERGE_PARENT_ORDER_NO` varchar(50) DEFAULT NULL COMMENT '所属合并物流单',
`MERGE_FLAG` int(2) DEFAULT '0' COMMENT '合并标识',
`IS_SECOND_MATCH` decimal(1,0) DEFAULT NULL COMMENT '是否二配',
`IS_SECOND_MATCH_APPRAISE` tinyint(1) DEFAULT NULL COMMENT '是否二配考核',
`SECOND_MATCH_APPRAISE_TIME` datetime DEFAULT NULL COMMENT '二配考核时间',
`IS_INTERCEPT` int(1) DEFAULT '0' COMMENT '是否拦截(1-拦截)',
`INTERCEPT_OPERATOR` varchar(50) DEFAULT NULL COMMENT '拦截操作人',
`INTERCEPT_TIME` datetime DEFAULT NULL COMMENT '拦截时间点',
`CRM_CUST_POINT_ID` varchar(50) DEFAULT NULL COMMENT '站点ID',
PRIMARY KEY (`tms_order_id`),
UNIQUE KEY `IXU_TMS_ORDER_ORDER_NO` (`order_no`),
KEY `IND_TMS_ORDER_UPDATEDTIME` (`updated_dtm_loc`),
KEY `IND_TMS_ORDER_M` (`order_status`,`created_office`,`is_autopicked`,`order_sub_type`),
KEY `IND_TMS_ORDER_JOIN_TIME` (`join_time`),
KEY `IND_TMS_ORDER_BT` (`buyer_state`,`order_sub_type`,`cust_code`),
KEY `IND_ORDER_N1` (`add_time`,`buyer_state`),
KEY `IDX_ACCEPT_MANIPULAT_MATC_TIME` (`accept_manipulat_matc_time`),
KEY `IND_IS_AUTOPICKED` (`is_autopicked`),
KEY `IND_ORDER_SUB_TYPE` (`order_sub_type`),
KEY `IND_BUYER_CITY` (`buyer_city`),
KEY `IND_BUYER_AREA_ID` (`buyer_area_id`),
KEY `IND_ORDER_STATUS` (`order_status`),
KEY `IDX_TMS_ORDER_TRANSPORT_NO` (`transport_no`),
KEY `IND_CURRENT_DELIVERY_POINT` (`current_delivery_point`),
KEY `IXU_TMS_ORDER_ORDER_SN` (`order_sn`),
KEY `IND_CREATED_DTM_LOC` (`created_dtm_loc`),
KEY `IDX_ORDER_SN_sub_type` (`order_sn`,`order_sub_type`),
KEY `IDX_TMS_ORDER_CREATED_OFFICE_JOIN_TIME` (`created_office`,`join_time`),
KEY `IDX_order_batch_no` (`order_batch_no`),
KEY `IDX_CUST_CODE` (`cust_code`),
KEY `IDX_C_J_S_O` (`cust_code`,`join_time`,`order_sub_type`,`created_office`),
KEY `IDX_STATUS_CUST_CODE_SUB_TYPE` (`order_status`,`cust_code`,`order_sub_type`,`add_time`),
KEY `IDX_ORDER_MAIN_CUST` (`order_main_cust`),
KEY `IX_merge_parent_order_no` (`MERGE_PARENT_ORDER_NO`),
KEY `IDX_MERGE_PARENT_ORDER_SN` (`MERGE_PARENT_ORDER_SN`),
KEY `IDX_O_S_C_A` (`created_office`,`order_sub_type`,`order_status`,`add_time`),
KEY `IX_TMS_ORDER_INTERCEPT_OPERATOR` (`INTERCEPT_OPERATOR`),
KEY `IX_TMS_ORDER_INTERCEPT_TIME` (`INTERCEPT_TIME`),
KEY `IDX_TMS_ORDER_POINT` (`CRM_CUST_POINT_ID`),
KEY `idx_office_oqc_date` (`created_office`,`oqc_date`) USING BTREE,
KEY `IDX_TMSOD_PURORID` (`purchase_order_id`),
KEY `IDX_TMSOD_REJECTM` (`rejection_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
Name: tms_order
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 13094637
Avg_row_length: 1060
Data_length: 13891534848
Max_data_length: 0
Index_length: 37474713600
Data_free: 886046720
Auto_increment: NULL
Create_time: 2014-04-03 16:29:16
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| aria_block_size | 8192 | |
| aria_checkpoint_interval | 30 | |
| aria_checkpoint_log_activity | 1048576 | |
| aria_force_start_after_recovery_failures | 0 | |
| aria_group_commit | none | |
| aria_group_commit_interval | 0 | |
| aria_log_file_size | 1073741824 | |
| aria_log_purge_type | immediate | |
| aria_max_sort_file_size | 9223372036853727232 | |
| aria_page_checksum | ON | |
| aria_pagecache_age_threshold | 300 | |
| aria_pagecache_buffer_size | 134217728 | |
| aria_pagecache_division_limit | 100 | |
| aria_recover | NORMAL | |
| aria_repair_threads | 1 | |
| aria_sort_buffer_size | 134217728 | |
| aria_stats_method | nulls_unequal | |
| aria_sync_log_dir | NEWFILE | |
| aria_used_for_temp_tables | ON | |
| auto_increment_increment | 1 | |
| auto_increment_offset | 1 | |
| autocommit | ON | |
| automatic_sp_privileges | ON | |
| back_log | 300 | |
| basedir | /apps/svr/mariadb5 | |
| big_tables | OFF | |
| binlog_annotate_row_events | OFF | |
| binlog_cache_size | 262144 | |
| binlog_checksum | NONE | |
| binlog_direct_non_transactional_updates | OFF | |
| binlog_format | ROW | |
| binlog_optimize_thread_scheduling | ON | |
| binlog_stmt_cache_size | 32768 | |
| bulk_insert_buffer_size | 8388608 | |
| character_set_client | utf8 | |
| character_set_connection | utf8 | |
| character_set_database | utf8 | |
| character_set_filesystem | utf8 | |
| character_set_results | utf8 | |
| character_set_server | utf8 | |
| character_set_system | utf8 | |
| character_sets_dir | /apps/svr/mariadb-5.5.31-linux-x86_64/share/charsets/ | |
| collation_connection | utf8_general_ci | |
| collation_database | utf8_general_ci | |
| collation_server | utf8_general_ci | |
| completion_type | NO_CHAIN | |
| concurrent_insert | AUTO | |
| connect_timeout | 10 | |
| datadir | /apps/dbdat/mariadb5_data3306/ | |
| date_format | %Y-%m-%d | |
| datetime_format | %Y-%m-%d %H:%i:%s | |
| deadlock_search_depth_long | 15 | |
| deadlock_search_depth_short | 4 | |
| deadlock_timeout_long | 50000000 | |
| deadlock_timeout_short | 10000 | |
| debug_no_thread_alarm | OFF | |
| default_storage_engine | InnoDB | |
| default_week_format | 0 | |
| delay_key_write | ON | |
| delayed_insert_limit | 100 | |
| delayed_insert_timeout | 300 | |
| delayed_queue_size | 1000 | |
| div_precision_increment | 4 | |
| engine_condition_pushdown | OFF | |
| error_count | 0 | |
| event_scheduler | ON | |
| expensive_subquery_limit | 100 | |
| expire_logs_days | 3 | |
| external_user | ||
| extra_max_connections | 1 | |
| extra_port | 0 | |
| flush | OFF | |
| flush_time | 0 | |
| foreign_key_checks | ON | |
| ft_boolean_syntax | + -><()~*:""& | |
| ft_max_word_len | 84 | |
| ft_min_word_len | 4 | |
| ft_query_expansion_limit | 20 | |
| ft_stopword_file | (built-in) | |
| general_log | OFF | |
| general_log_file | GD10-DB-TMS-008-db-mysql.log | |
| group_concat_max_len | 10240 | |
| have_compress | YES | |
| have_crypt | YES | |
| have_csv | YES | |
| have_dynamic_loading | YES | |
| have_geometry | YES | |
| have_innodb | YES | |
| have_ndbcluster | NO | |
| have_openssl | DISABLED | |
| have_partitioning | YES | |
| have_profiling | YES | |
| have_query_cache | YES | |
| have_rtree_keys | YES | |
| have_ssl | DISABLED | |
| have_symlink | YES | |
| hostname | GD10-DB-TMS-008-db-mysql.idc.vipshop.com | |
| identity | 0 | |
| ignore_builtin_innodb | OFF | |
| ignore_db_dirs | ||
| in_transaction | 0 | |
| init_connect | ||
| init_file | ||
| init_slave | ||
| innodb_adaptive_flushing | ON | |
| innodb_adaptive_flushing_method | estimate | |
| innodb_adaptive_hash_index | ON | |
| innodb_adaptive_hash_index_partitions | 1 | |
| innodb_additional_mem_pool_size | 33554432 | |
| innodb_autoextend_increment | 32 | |
| innodb_autoinc_lock_mode | 1 | |
| innodb_blocking_buffer_pool_restore | OFF | |
| innodb_buffer_pool_instances | 4 | |
| innodb_buffer_pool_populate | OFF | |
| innodb_buffer_pool_restore_at_startup | 0 | |
| innodb_buffer_pool_shm_checksum | ON | |
| innodb_buffer_pool_shm_key | 0 | |
| innodb_buffer_pool_size | 85899345920 | |
| innodb_change_buffering | inserts | |
| innodb_checkpoint_age_target | 0 | |
| innodb_checksums | ON | |
| innodb_commit_concurrency | 0 | |
| innodb_concurrency_tickets | 500 | |
| innodb_corrupt_table_action | assert | |
| innodb_data_file_path | ibdata1:1000M:autoextend | |
| innodb_data_home_dir | /apps/dbdat/mariadb5_data3306 | |
| innodb_dict_size_limit | 0 | |
| innodb_doublewrite | ON | |
| innodb_doublewrite_file | ||
| innodb_fake_changes | OFF | |
| innodb_fast_checksum | OFF | |
| innodb_fast_shutdown | 1 | |
| innodb_file_format | Barracuda | |
| innodb_file_format_check | ON | |
| innodb_file_format_max | Antelope | |
| innodb_file_per_table | ON | |
| innodb_flush_log_at_trx_commit | 2 | |
| innodb_flush_method | O_DIRECT | |
| innodb_flush_neighbor_pages | area | |
| innodb_force_load_corrupted | OFF | |
| innodb_force_recovery | 0 | |
| innodb_ibuf_accel_rate | 100 | |
| innodb_ibuf_active_contract | 1 | |
| innodb_ibuf_max_size | 42949640192 | |
| innodb_import_table_from_xtrabackup | 0 | |
| innodb_io_capacity | 1200 | |
| innodb_kill_idle_transaction | 0 | |
| innodb_large_prefix | OFF | |
| innodb_lazy_drop_table | 0 | |
| innodb_lock_wait_timeout | 45 | |
| innodb_locking_fake_changes | ON | |
| innodb_locks_unsafe_for_binlog | OFF | |
| innodb_log_block_size | 512 | |
| innodb_log_buffer_size | 8388608 | |
| innodb_log_file_size | 1048576000 | |
| innodb_log_files_in_group | 4 | |
| innodb_log_group_home_dir | /apps/dbdat/mariadb5_data3306 | |
| innodb_max_bitmap_file_size | 104857600 | |
| innodb_max_changed_pages | 1000000 | |
| innodb_max_dirty_pages_pct | 50 | |
| innodb_max_purge_lag | 0 | |
| innodb_merge_sort_block_size | 1048576 | |
| innodb_mirrored_log_groups | 1 | |
| innodb_old_blocks_pct | 25 | |
| innodb_old_blocks_time | 3000 | |
| innodb_open_files | 4096 | |
| innodb_page_size | 16384 | |
| innodb_print_all_deadlocks | OFF | |
| innodb_purge_batch_size | 20 | |
| innodb_purge_threads | 1 | |
| innodb_random_read_ahead | OFF | |
| innodb_read_ahead | linear | |
| innodb_read_ahead_threshold | 56 | |
| innodb_read_io_threads | 4 | |
| innodb_recovery_stats | OFF | |
| innodb_recovery_update_relay_log | OFF | |
| innodb_replication_delay | 0 | |
| innodb_rollback_on_timeout | OFF | |
| innodb_rollback_segments | 128 | |
| innodb_show_locks_held | 10 | |
| innodb_show_verbose_locks | 0 | |
| innodb_spin_wait_delay | 12 | |
| innodb_stats_auto_update | 1 | |
| innodb_stats_method | nulls_unequal | |
| innodb_stats_on_metadata | OFF | |
| innodb_stats_sample_pages | 32 | |
| innodb_stats_update_need_lock | 1 | |
| innodb_strict_mode | OFF | |
| innodb_support_xa | ON | |
| innodb_sync_spin_loops | 90 | |
| innodb_table_locks | ON | |
| innodb_thread_concurrency | 32 | |
| innodb_thread_concurrency_timer_based | OFF | |
| innodb_thread_sleep_delay | 10000 | |
| innodb_track_changed_pages | OFF | |
| innodb_use_atomic_writes | OFF | |
| innodb_use_fallocate | OFF | |
| innodb_use_global_flush_log_at_trx_commit | ON | |
| innodb_use_native_aio | ON | |
| innodb_use_sys_malloc | ON | |
| innodb_use_sys_stats_table | OFF | |
| innodb_version | 5.5.31-MariaDB-30.2 | |
| innodb_write_io_threads | 4 | |
| insert_id | 0 | |
| interactive_timeout | 600 | |
| join_buffer_size | 131072 | |
| join_buffer_space_limit | 67108864 | |
| join_cache_level | 2 | |
| keep_files_on_create | OFF | |
| key_buffer_size | 2147483648 | |
| key_cache_age_threshold | 300 | |
| key_cache_block_size | 4096 | |
| key_cache_division_limit | 20 | |
| key_cache_segments | 0 | |
| large_files_support | ON | |
| large_page_size | 0 | |
| large_pages | OFF | |
| last_insert_id | 0 | |
| lc_messages | en_US | |
| lc_messages_dir | ||
| lc_time_names | en_US | |
| license | GPL | |
| local_infile | ON | |
| lock_wait_timeout | 600 | |
| locked_in_memory | OFF | |
| log | OFF | |
| log_bin | ON | |
| log_bin_trust_function_creators | ON | |
| log_error | /apps/logs/mysql/error3306.log | |
| log_output | FILE | |
| log_queries_not_using_indexes | OFF | |
| log_slave_updates | OFF | |
| log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | |
| log_slow_queries | ON | |
| log_slow_rate_limit | 1 | |
| log_slow_verbosity | innodb,query_plan | |
| log_warnings | 0 | |
| long_query_time | 2.000000 | |
| low_priority_updates | OFF | |
| lower_case_file_system | OFF | |
| lower_case_table_names | 1 | |
| master_verify_checksum | OFF | |
| max_allowed_packet | 67108864 | |
| max_binlog_cache_size | 1073741824 | |
| max_binlog_size | 536870912 | |
| max_binlog_stmt_cache_size | 268435456 | |
| max_connect_errors | 100000 | |
| max_connections | 3000 | |
| max_delayed_threads | 20 | |
| max_error_count | 64 | |
| max_heap_table_size | 134217728 | |
| max_insert_delayed_threads | 20 | |
| max_join_size | 18446744073709551615 | |
| max_length_for_sort_data | 4096 | |
| max_long_data_size | 67108864 | |
| max_prepared_stmt_count | 16382 | |
| max_relay_log_size | 0 | |
| max_seeks_for_key | 4294967295 | |
| max_sort_length | 1024 | |
| max_sp_recursion_depth | 0 | |
| max_tmp_tables | 32 | |
| max_user_connections | 2980 | |
| max_write_lock_count | 10000 | |
| metadata_locks_cache_size | 1024 | |
| min_examined_row_limit | 0 | |
| mrr_buffer_size | 67108864 | |
| multi_range_count | 256 | |
| myisam_block_size | 4096 | |
| myisam_data_pointer_size | 6 | |
| myisam_max_sort_file_size | 10737418240 | |
| myisam_mmap_size | 18446744073709551615 | |
| myisam_recover_options | DEFAULT | |
| myisam_repair_threads | 1 | |
| myisam_sort_buffer_size | 33554432 | |
| myisam_stats_method | nulls_unequal | |
| myisam_use_mmap | OFF | |
| net_buffer_length | 8192 | |
| net_read_timeout | 3 | |
| net_retry_count | 2 | |
| net_write_timeout | 6 | |
| old | OFF | |
| old_alter_table | OFF | |
| old_passwords | OFF | |
| open_files_limit | 262143 | |
| optimizer_prune_level | 1 | |
| optimizer_search_depth | 62 | |
| optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=on,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off | |
| performance_schema | ON | |
| performance_schema_events_waits_history_long_size | 10000 | |
| performance_schema_events_waits_history_size | 10 | |
| performance_schema_max_cond_classes | 80 | |
| performance_schema_max_cond_instances | 1000 | |
| performance_schema_max_file_classes | 50 | |
| performance_schema_max_file_handles | 32768 | |
| performance_schema_max_file_instances | 10000 | |
| performance_schema_max_mutex_classes | 200 | |
| performance_schema_max_mutex_instances | 1000000 | |
| performance_schema_max_rwlock_classes | 30 | |
| performance_schema_max_rwlock_instances | 1000000 | |
| performance_schema_max_table_handles | 100000 | |
| performance_schema_max_table_instances | 50000 | |
| performance_schema_max_thread_classes | 50 | |
| performance_schema_max_thread_instances | 1000 | |
| pid_file | /apps/dbdat/mariadb5_data3306/mysql.pid | |
| plugin_dir | /apps/svr/mariadb5/lib/plugin/ | |
| plugin_maturity | unknown | |
| port | 3306 | |
| preload_buffer_size | 32768 | |
| profiling | OFF | |
| profiling_history_size | 5 | |
| progress_report_time | 56 | |
| protocol_version | 10 | |
| proxy_user | ||
| pseudo_slave_mode | OFF | |
| pseudo_thread_id | 9014862 | |
| query_alloc_block_size | 8192 | |
| query_cache_limit | 0 | |
| query_cache_min_res_unit | 4096 | |
| query_cache_size | 0 | |
| query_cache_strip_comments | OFF | |
| query_cache_type | OFF | |
| query_cache_wlock_invalidate | OFF | |
| query_prealloc_size | 8192 | |
| rand_seed1 | 0 | |
| rand_seed2 | 0 | |
| range_alloc_block_size | 4096 | |
| read_buffer_size | 4194304 | |
| read_only | ON | |
| read_rnd_buffer_size | 8388608 | |
| relay_log | relay-bin | |
| relay_log_index | relay-bin.index | |
| relay_log_info_file | relay-log.info | |
| relay_log_purge | ON | |
| relay_log_recovery | OFF | |
| relay_log_space_limit | 107374182400 | |
| replicate_annotate_row_events | OFF | |
| replicate_do_db | ||
| replicate_do_table | ||
| replicate_events_marked_for_skip | replicate | |
| replicate_ignore_db | ||
| replicate_ignore_table | ||
| replicate_wild_do_table | ||
| replicate_wild_ignore_table | ||
| report_host | ||
| report_password | ||
| report_port | 3306 | |
| report_user | ||
| rowid_merge_buff_size | 8388608 | |
| rpl_recovery_rank | 0 | |
| rpl_semi_sync_slave_enabled | ON | |
| rpl_semi_sync_slave_trace_level | 32 | |
| secure_auth | OFF | |
| secure_file_priv | ||
| server_id | 2 | |
| skip_external_locking | ON | |
| skip_name_resolve | ON | |
| skip_networking | OFF | |
| skip_replication | OFF | |
| skip_show_database | OFF | |
| slave_compressed_protocol | OFF | |
| slave_exec_mode | STRICT | |
| slave_load_tmpdir | /apps/tmp | |
| slave_max_allowed_packet | 1073741824 | |
| slave_net_timeout | 30 | |
| slave_skip_errors | OFF | |
| slave_sql_verify_checksum | ON | |
| slave_transaction_retries | 10 | |
| slave_type_conversions | ||
| slow_launch_time | 2 | |
| slow_query_log | ON | |
| slow_query_log_file | /apps/logs/mysql/slow3306.log | |
| socket | /tmp/mysql3306.sock | |
| sort_buffer_size | 8388608 | |
| sql_auto_is_null | OFF | |
| sql_big_selects | ON | |
| sql_big_tables | OFF | |
| sql_buffer_result | OFF | |
| sql_log_bin | ON | |
| sql_log_off | OFF | |
| sql_low_priority_updates | OFF | |
| sql_max_join_size | 18446744073709551615 | |
| sql_mode | ||
| sql_notes | ON | |
| sql_quote_show_create | ON | |
| sql_safe_updates | OFF | |
| sql_select_limit | 18446744073709551615 | |
| sql_slave_skip_counter | 0 | |
| sql_warnings | OFF | |
| ssl_ca | ||
| ssl_capath | ||
| ssl_cert | ||
| ssl_cipher | ||
| ssl_key | ||
| storage_engine | InnoDB | |
| stored_program_cache | 256 | |
| sync_binlog | 0 | |
| sync_frm | ON | |
| sync_master_info | 0 | |
| sync_relay_log | 0 | |
| sync_relay_log_info | 0 | |
| system_time_zone | CST | |
| table_definition_cache | 1024 | |
| table_open_cache | 1024 | |
| thread_cache_size | 512 | |
| thread_concurrency | 10 | |
| thread_handling | one-thread-per-connection | |
| thread_pool_idle_timeout | 60 | |
| thread_pool_max_threads | 500 | |
| thread_pool_oversubscribe | 3 | |
| thread_pool_size | 32 | |
| thread_pool_stall_limit | 500 | |
| thread_stack | 294912 | |
| time_format | %H:%i:%s | |
| time_zone | SYSTEM | |
| timed_mutexes | OFF | |
| timestamp | 1399277567.649010 | |
| tmp_table_size | 134217728 | |
| tmpdir | /apps/tmp | |
| transaction_alloc_block_size | 8192 | |
| transaction_prealloc_size | 4096 | |
| tx_isolation | READ-COMMITTED | |
| unique_checks | ON | |
| updatable_views_with_limit | YES | |
| userstat | ON | |
| version | 5.5.31-MariaDB-log | |
| version_comment | MariaDB Server | |
| version_compile_machine | x86_64 | |
| version_compile_os | Linux | |
| wait_timeout | 600 | |
| warning_count | 0 |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
430 rows in set (0.00 sec)
Thank you for the info.
So, by the problem being repeatable you mean that this query always crashes, right?
Would it be possible to run
EXPLAIN EXTENDED <query>; SHOW WARNINGS;
?
But please be aware that if the query crashes, EXPLAIN can crash also, so if you cannot afford another crash, please don't do it.
Is it production/confidential data? If not so much, would you be able to upload the data dump to our ftp ftp.askmonty.org/private?
(Uploading to the private section means that only MariaDB developers will have access to it).
Also, please note that 5.5.31 version is rather old, and there were various bugs fixed since then. We will try to investigate the problem to see whether it still exists, but if you can upgrade the MariaDB server, please by all means do so.
From all I see, this problem was fixed in MariaDB 5.5.32, particularly by the following revision:
revno: 3836 [merge]
revision-id: sergii@pisem.net-20130716173039-j2k1nrkd0gmdmsd9
parent: sergii@pisem.net-20130716170954-d1ku0nrr100t6red
parent: sergii@pisem.net-20130716125547-2uhpbn6jtf1v2dbi
committer: Sergei Golubchik <sergii@pisem.net>
branch nick: 5.5
timestamp: Tue 2013-07-16 19:30:39 +0200
message:
merge Percona-Server-5.5.32-rel31.0.tar.gz
------------------------------------------------------------
revno: 0.12.63
revision-id: sergii@pisem.net-20130716125547-2uhpbn6jtf1v2dbi
parent: sergii@pisem.net-20130508075254-p3uhct92y4pr5b47
committer: Sergei Golubchik <sergii@pisem.net>
branch nick: xtradb-mergetree-5.5
timestamp: Tue 2013-07-16 14:55:47 +0200
message:
Percona-Server-5.5.32-rel31.0.tar.gz
At least I can quite easily reproduce the assertion failure up to revno 3835, but cannot starting from 3836.
I suppose in Percona Server, in turn, it was fixed by a merge of the bugfix for http://bugs.mysql.com/bug.php?id=68051.
So, I'm closing it as fixed in 5.5.32 for now, recommending upgrade. If you keep experiencing this problem after the upgrade, please comment and the bug will be re-opened.
Hi,
Is the crash repeatable?
Could you please paste the result of the commands below?
Thanks.