Feb  3 11:22:35 platon mysqld: Server version: 5.3.3-MariaDB-rc-mariadb108~squeeze-log
Feb  3 11:22:35 platon mysqld: key_buffer_size=0
Feb  3 11:22:35 platon mysqld: read_buffer_size=8388608
Feb  3 11:22:35 platon mysqld: max_used_connections=1
Feb  3 11:22:35 platon mysqld: max_threads=1026
Feb  3 11:22:35 platon mysqld: threads_connected=1
Feb  3 11:22:35 platon mysqld: It is possible that mysqld could use up to 
Feb  3 11:22:35 platon mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16823252 K
Feb  3 11:22:35 platon mysqld: bytes of memory
Feb  3 11:22:35 platon mysqld: Hope that's ok; if not, decrease some variables in the equation.
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: Thread pointer: 0x7f827bdccc10
Feb  3 11:22:35 platon mysqld: Attempting backtrace. You can use the following information to find out
Feb  3 11:22:35 platon mysqld: where mysqld died. If you see no messages after this, something went
Feb  3 11:22:35 platon mysqld: terribly wrong...
Feb  3 11:22:35 platon mysqld: stack_bottom = 0x7f8275010e98 thread_stack 0x40000
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x7f8275846c6e]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(handle_segfault+0x4cc) [0x7f82754484ac]
Feb  3 11:22:35 platon mysqld: /lib/libpthread.so.0(+0xeff0) [0x7f82739b5ff0]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN_CACHE::get_record_by_pos(unsigned char*)+0x90) [0x7f8275494390]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN_CACHE::get_record()+0xb5) [0x7f8275494965]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN_CACHE::join_matching_records(bool)+0x137) [0x7f8275493097]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN_CACHE::join_records(bool)+0xd0) [0x7f827548fd70]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN_CACHE::join_records(bool)+0x1ae) [0x7f827548fe4e]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN_CACHE::join_records(bool)+0x10d) [0x7f827548fdad]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(sub_select_cache(JOIN*, st_join_table*, bool)+0x7a) [0x7f82754bf8ba]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(+0x459c38) [0x7f82754bfc38]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(JOIN::exec()+0xa63) [0x7f82754d5ef3]
Feb  3 11:22:35 platon mysqld: /usr/sbin/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*)+0x112) [0x7f82754d78d2]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x15d) [0x7f82754d839d]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(+0x3edbca) [0x7f8275453bca]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x41e) [0x7f827545608e]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2c1) [0x7f827545b9e1]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xfc7) [0x7f827545d697]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(do_command(THD*)+0xf4) [0x7f827545de84]
Feb  3 11:22:35 platon mysqld: /usr/sbin/mysqld(handle_one_connection+0x1b5) [0x7f827544f635]
Feb  3 11:22:35 platon mysqld: /lib/libpthread.so.0(+0x68ca) [0x7f82739ad8ca]
Feb  3 11:22:35 platon mysqld: /lib/libc.so.6(clone+0x6d) [0x7f8272f7686d]
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: Trying to get some variables.
Feb  3 11:22:35 platon mysqld: Some pointers may be invalid and cause the dump to abort.
Feb  3 11:22:35 platon mysqld: Query (0x7f827be42c48): SELECT DISTINCT
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.TYPE_SID,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.ID#011#011#011#011#011BANNER_ID,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.WEIGHT#011#011#011#011BANNER_WEIGHT,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.SHOWS_FOR_VISITOR,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.FIX_CLICK,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.FIX_SHOW,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.KEYWORDS#011#011#011#011BANNER_KEYWORDS,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s')#011#011DATE_SHOW_FIRST,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s')#011#011#011DATE_SHOW_FROM,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s')#011#011#011DATE_SHOW_TO,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.FLYUNIFORM#011#011#011FLYUNIFORM,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.MAX_SHOW_COUNT#011#011MAX_SHOW_COUNT,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.SHOW_COUNT#011#011#011SHOW_COUNT,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011C.ID#011#011#011#011#011CONTRACT_ID,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011C.WEIGHT#011#011#011#011CONTRACT_WEIGHT,
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011C.KEYWORDS#011#011#011#011CONTRACT_KEYWORDS
Feb  3 11:22:35 platon mysqld: #011#011#011#011FROM
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011b_adv_type T
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_banner B ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011B.ACTIVE='Y'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and#011B.TYPE_SID = T.SID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and#011B.STATUS_SID = 'PUBLISHED'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='N')
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and#011(ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0))
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_banner_2_site BS ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011BS.BANNER_ID = B.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and BS.SITE_ID = 'en')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_contract C ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011C.ID = B.CONTRACT_ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and C.ACTIVE='Y'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and#011(ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0))
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_contract_2_site CS ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011CS.CONTRACT_ID = B.CONTRACT_ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and CS.SITE_ID = 'en')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_contract_2_type CT ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011CT.CONTRACT_ID = C.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID))
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_banner_2_weekday BW ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011BW.BANNER_ID = B.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and BW.C_WEEKDAY='FRIDAY'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and BW.C_HOUR = '11')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011INNER JOIN b_adv_contract_2_weekday CW ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011CW.CONTRACT_ID = C.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and CW.C_WEEKDAY='FRIDAY'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and CW.C_HOUR = '11')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_banner_2_group UG1 ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011(UG1.BANNER_ID = B.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011 and UG1.GROUP_ID in (1,2) and UG1.GROUP_ID<>2)
Feb  3 11:22:35 platon mysqld: #011#011#011#011)
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_banner_2_page BP1 ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011BP1.BANNER_ID = B.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and BP1.SHOW_ON_PAGE='Y')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_banner_2_page BP2 ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011BP2.BANNER_ID = B.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and BP2.SHOW_ON_PAGE='N'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and '/club/index.php' like concat(BP2.PAGE, '%'))
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_contract_2_page#011CP1 ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011CP1.CONTRACT_ID = C.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and CP1.SHOW_ON_PAGE='Y')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_contract_2_page CP2 ON (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011CP2.CONTRACT_ID = C.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and CP2.SHOW_ON_PAGE='N'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011and '/club/index.php' like concat(CP2.PAGE, '%'))
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_banner_2_stat_adv#011BA#011ON BA.BANNER_ID = B.ID
Feb  3 11:22:35 platon mysqld: #011#011#011#011LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011(
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011(B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY')
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011AND BC.COUNTRY_ID='UA'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011) OR (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011B.STAT_TYPE='REGION'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011AND BC.COUNTRY_ID='UA'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011AND BC.REGION=''
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011) OR (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011B.STAT_TYPE='CITY'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011#011AND BC.CITY_ID='2'
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011)
Feb  3 11:22:35 platon mysqld: #011#011#011#011)
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011WHERE
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011T.ACTIVE = 'Y'
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011and (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011B.STAT_COUNT is null
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011or B.STAT_COUNT = 0
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011or BC.BANNER_ID is not null
Feb  3 11:22:35 platon mysqld: #011#011#011#011)
Feb  3 11:22:35 platon mysqld: #011#011#011#011and BP2.ID is null
Feb  3 11:22:35 platon mysqld: #011#011#011#011and CP2.ID is null
Feb  3 11:22:35 platon mysqld: #011#011#011#011and (BP1.ID is null or '/club/index.php' like concat(BP1.PAGE, '%'))
Feb  3 11:22:35 platon mysqld: #011#011#011#011and (CP1.ID is null or '/club/index.php' like concat(CP1.PAGE, '%'))
Feb  3 11:22:35 platon mysqld: #011#011#011#011and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0')
Feb  3 11:22:35 platon mysqld: #011#011#011#011and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='UA')
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011 and
Feb  3 11:22:35 platon mysqld: #011#011#011#011 (
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011(B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null)
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011or
Feb  3 11:22:35 platon mysqld: #011#011#011#011#011(B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null)
Feb  3 11:22:35 platon mysqld: #011#011#011#011 )
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: #011#011#011#011ORDER BY B.TYPE_SID desc, C.ID desc
Feb  3 11:22:35 platon mysqld: Connection ID (thread ID): 2
Feb  3 11:22:35 platon mysqld: Status: NOT_KILLED
Feb  3 11:22:35 platon mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=off,mrr_cost_based=off,mrr_sort_keys=off,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
Feb  3 11:22:35 platon mysqld: 
Feb  3 11:22:35 platon mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Feb  3 11:22:35 platon mysqld: information that should help you find out what is causing the crash.
Feb  3 11:22:35 platon mysqld_safe: Number of processes running now: 0
Feb  3 11:22:35 platon mysqld_safe: mysqld restarted