GalaxyEngine is a MySQL branch originated from Alibaba Group, especially supports large-scale distributed database system.

Overview

GalaxyEngine

GalaxyEngine is a MySQL branch originated from Alibaba Group. It is based on the MySQL official release and has many features and performance enhancements, GalaxyEngine has proven to be very stable and efficient in production environment. It can be used as a free, fully compatible, enhanced and open source drop-in replacement for MySQL.

GalaxyEngine has been an open source project since October 2021. It is being actively developed by engineers from Alibaba Group, Everyone is welcomed to get involved.

For further information on GalaxyEngine or additional documentation, visit:
GalaxyEngine Overview

Issues
  • ‘TRUE’ was not declared in this scope

    ‘TRUE’ was not declared in this scope

    The lastest commit log is

    commit 99986fccd58f8bdad0c59145a122ace52a812338 (HEAD -> main, origin/main, origin/HEAD)
    Author: [email protected] <[email protected]>
    Date:   Wed Oct 20 20:21:19 2021 +0800
    
        [Bugfix] Fix build warning
    

    The error message of make -j8 is

    [ 78%] Building CXX object sql/CMakeFiles/sql_main.dir/trans_proc/implicit_savepoint.cc.o
    In file included from /home/ubuntu/develop/galaxyengine/include/template_utils.h:28:0,
                     from /home/ubuntu/develop/galaxyengine/include/m_ctype.h:46,
                     from /home/ubuntu/develop/galaxyengine/sql/sql_parse.h:30,
                     from /home/ubuntu/develop/galaxyengine/sql/trans_proc/implicit_savepoint.cc:21:
    /home/ubuntu/develop/galaxyengine/sql/trans_proc/implicit_savepoint.cc: In member function ‘virtual bool im::Sql_cmd_trans_proc_implicit_savepoint::pc_execute(THD*)’:
    /home/ubuntu/develop/galaxyengine/sql/trans_proc/implicit_savepoint.cc:59:17: error: ‘TRUE’ was not declared in this scope
         DBUG_RETURN(TRUE);
                     ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/trans_proc/implicit_savepoint.cc:65:17: error: ‘TRUE’ was not declared in this scope
         DBUG_RETURN(TRUE);
    
    opened by hiseeyoulater 3
  • TRUE & FALSE not defined

    TRUE & FALSE not defined

    You have lost you TRUE AND FALSE defined in my_global.h file

    #ifndef MY_GLOBAL_INCLUDED #define MY_GLOBAL_INCLUDED

    /* Define some general constants / #ifndef TRUE #define TRUE (1) / Logical true / #define FALSE (0) / Logical false */ #endif

    #endif // MY_GLOBAL_INCLUDED

    opened by pengan1990 3
  • I encountered some questions when compiling project on Ubuntu 20.04

    I encountered some questions when compiling project on Ubuntu 20.04

    CMake Error at mysys/CMakeLists.txt:179 (ADD_DEPENDENCIES):
      The dependency target "libcrypto" of target "mysys" does not exist.
    
    
    CMake Error at mysys/CMakeLists.txt:179 (ADD_DEPENDENCIES):
      The dependency target "libssl" of target "mysys" does not exist.
    
    
    CMake Error at router/src/http/src/CMakeLists.txt:44 (ADD_DEPENDENCIES):
      The dependency target "libcrypto" of target "http_common" does not exist.
    
    
    CMake Error at router/src/http/src/CMakeLists.txt:44 (ADD_DEPENDENCIES):
      The dependency target "libssl" of target "http_common" does not exist.
    
    
    -- Generating done
    CMake Generate step failed.  Build files cannot be regenerated correctly.
    

    The compiler version is GCC9.4.0, I have installed libssl and libcrypto.

    opened by Sunday361 2
  • A crash caused by Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed

    A crash caused by Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed

    POC: create databse test2; use test2; CREATE TABLE v0 ( CHECK ( ( + '' ) / CONVERT ( DEFAULT ( v2 ) , REAL ) IS NULL IS NULL IS NULL IS UNKNOWN ) , v3 BINARY COLLATE BINARY AS ( 'x' ) STORED , v2 MEDIUMINT NULL SERIAL DEFAULT VALUE SERIAL DEFAULT VALUE , v1 LONGBLOB ) ; INSERT DELAYED IGNORE INTO v0 ( ) VALUES ( -1 , 63144147.000000 , 'x' ) ; SELECT * FROM v0 WHERE v2 IN ( SELECT v3 FROM v0 ) ORDER BY v0 . v3 ;

    [email protected] ~/w/P/g/build (main) [1]# ./bin/mysqld --defaults-file=my.cnf --user=root 2021-10-22T01:39:33.275212-00:00 0 [Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 1024 (request: 615350) 2021-10-22T01:39:33.275229-00:00 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 214 (requested 36000) 2021-10-22T01:39:33.275244-00:00 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 400 (requested 32768) 2021-10-22T01:39:33.402336-00:00 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release. 2021-10-22T01:39:33.402369-00:00 0 [Warning] [MY-011069] [Server] The syntax '--master-info-file' is deprecated and will be removed in a future release. 2021-10-22T01:39:33.402458-00:00 0 [Warning] [MY-011069] [Server] The syntax '--log-bin-use-v1-row-events' is deprecated and will be removed in a future release. 2021-10-22T01:39:33.402639-00:00 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-10-22T01:39:33.402678-00:00 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release. 2021-10-22T01:39:33.402873-00:00 0 [Warning] [MY-010084] [Server] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set 2021-10-22T01:39:33.402888-00:00 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-10-22T01:39:33.403035-00:00 0 [System] [MY-010116] [Server] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld (mysqld 8.0.18-debug-asan) starting as process 62434 2021-10-22T01:39:33.405560-00:00 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-10-22T01:39:33.406470-00:00 0 [Warning] [MY-010108] [Server] setrlimit could not change the size of core files to 'infinity'; We may not be able to generate a core file on signals 2021-10-22T01:39:33.423468-00:00 0 [Warning] [MY-012364] [InnoDB] innodb_open_files should not be greater than the open_files_limit.

    2021-10-22T01:39:40.456316-00:00 0 [System] [MY-010229] [Server] Starting crash recovery... 2021-10-22T01:39:40.469962-00:00 0 [System] [MY-010232] [Server] Crash recovery finished. 2021-10-22T01:39:40.708335-00:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2021-10-22T01:39:40.765125-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_polarx_port=32886'. 2021-10-22T01:39:40.766398-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_polarx_max_connections=5000'. 2021-10-22T01:39:40.767610-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-info=127.0.0.1:[email protected]'. 2021-10-22T01:39:40.768802-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-id=5431'. 2021-10-22T01:39:40.769966-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_enable_gts=1'. 2021-10-22T01:39:40.771134-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_log_sql_info=1'. 2021-10-22T01:39:40.772369-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_log_sql_info_index=1'. 2021-10-22T01:39:40.773577-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_indexstat=1'. 2021-10-22T01:39:40.774776-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_tablestat=1'. 2021-10-22T01:39:40.776004-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_slave_pr_mode=TABLE'. 2021-10-22T01:39:40.777239-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_large_trx=ON'. 2021-10-22T01:39:40.778468-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus-io-thread_cnt=8'. 2021-10-22T01:39:40.779707-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus-worker-thread_cnt=8'. 2021-10-22T01:39:40.780999-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_max_delay_index=10000'. 2021-10-22T01:39:40.782251-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus-election-timeout=10000'. 2021-10-22T01:39:40.783519-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_max_packet_size=131072'. 2021-10-22T01:39:40.784800-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_max_log_size=20M'. 2021-10-22T01:39:40.786067-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_auto_leader_transfer=ON'. 2021-10-22T01:39:40.787349-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_log_cache_size=536870912'. 2021-10-22T01:39:40.788652-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_prefetch_cache_size=268435456'. 2021-10-22T01:39:40.789952-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_prefetch_window_size=100'. 2021-10-22T01:39:40.791255-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_auto_reset_match_index=ON'. 2021-10-22T01:39:40.792581-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-mts-recover-use-index=ON'. 2021-10-22T01:39:40.793905-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_async_commit_thread_count=128'. 2021-10-22T01:39:40.795241-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_commit_lock_done_count=1'. 2021-10-22T01:39:40.796568-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-log-type-node=OFF'. 2021-10-22T01:39:40.797917-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_log_slow_verbosity=full'. 2021-10-22T01:39:40.799270-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_rds_check_core_file_enabled=ON'. 2021-10-22T01:39:40.800650-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_boost_pk_access=1'. 2021-10-22T01:39:40.802019-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_io_state=1'. 2021-10-22T01:39:40.803405-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_use_myfs=0'. 2021-10-22T01:39:40.804773-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_daemon_memcached_values_delimiter=:;:'. 2021-10-22T01:39:40.806172-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_daemon_memcached_option=-t 32 -c 8000 -p15506'. 2021-10-22T01:39:41.106212-00:00 0 [System] [MY-010931] [Server] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld: ready for connections. Version: '8.0.18-debug-asan' socket: '/root/workspace/PolarDB/galaxyengine/build/run/mysql.sock' port: 4886 Source distribution. 2021-10-22T01:39:41.312444-00:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 32886 socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060 mysqld: sql/field.cc:3618: virtual double Field_medium::val_real() const: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed. 01:42:56 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x62700042f100 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 = 7fd3cb6dcbd0 thread_stack 0x100000 /usr/lib/x86_64-linux-gnu/libasan.so.4(+0x566d0) [0x7fd4193606d0] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0xa9) [0x55f92b92a06d] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(handle_fatal_signal+0x523) [0x55f929e3c20e] /lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7fd4192fc3c0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7fd41894b18b] /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7fd41892a859] /lib/x86_64-linux-gnu/libc.so.6(+0x25729) [0x7fd41892a729] /lib/x86_64-linux-gnu/libc.so.6(+0x36f36) [0x7fd41893bf36] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Field_medium::val_real() const+0x112) [0x55f928fbc5f0] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_field::val_real()+0xf2) [0x55f929016104] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_typecast_real::val_real()+0x7f) [0x55f9290c7a61] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_div::real_op()+0x121) [0x55f9290d4421] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_numhybrid::val_real()+0x4ce) [0x55f9290c322e] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item::evaluate(THD*, String*)+0x440) [0x55f929028ff4] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item::update_null_value()+0x100) [0x55f9290291fa] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_numhybrid::is_null()+0x11) [0x55f9291035e1] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_isnull::update_used_tables()+0x21f) [0x55f9292cdbd1] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_isnull::resolve_type(THD*)+0xcc) [0x55f9292d4dea] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_fields(THD*, Item**)+0x2f4) [0x55f9290d2b72] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_isnull::fix_fields(THD*, Item**)+0xc2) [0x55f9292e0fb8] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_func_arg(THD*, Item**)+0x26d) [0x55f9290d2725] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_fields(THD*, Item**)+0x325) [0x55f9290d2ba3] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_isnull::fix_fields(THD*, Item**)+0xc2) [0x55f9292e0fb8] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_func_arg(THD*, Item**)+0x26d) [0x55f9290d2725] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_fields(THD*, Item**)+0x325) [0x55f9290d2ba3] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_isnull::fix_fields(THD*, Item**)+0xc2) [0x55f9292e0fb8] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_func_arg(THD*, Item**)+0x26d) [0x55f9290d2725] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func::fix_fields(THD*, Item**)+0x325) [0x55f9290d2ba3] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Item_func_isnull::fix_fields(THD*, Item**)+0xc2) [0x55f9292e0fb8] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0x7d96744) [0x55f929ca6744] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(unpack_value_generator(THD*, TABLE*, Value_generator**, Value_generator_source, char const*, Field*, bool, bool*)+0x8d0) [0x55f929cb1a4b] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*)+0x2485) [0x55f929cb448f] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, bool, bool, dd::Table*, bool, HA_CREATE_INFO*)+0x305) [0x55f929164e42] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0x7c6df6d) [0x55f929b7df6d] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0x7c9b060) [0x55f929bab060] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_create_table_no_lock(THD*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, unsigned int, bool, bool*, handlerton**)+0xec3) [0x55f929bac2e2] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_create_table(THD*, TABLE_LIST*, HA_CREATE_INFO*, Alter_info*)+0xb4a) [0x55f929bbdc24] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Sql_cmd_create_table::execute(THD*)+0x116b) [0x55f92988992b] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_execute_command(THD*, bool)+0x3820) [0x55f929a2a598] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_parse(THD*, Parser_state*)+0xa0c) [0x55f929a31d71] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1f61) [0x55f929a3469f] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(do_command(THD*)+0xaa6) [0x55f929a37e0f] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0x7ef4819) [0x55f929e04819] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0xa63f4c4) [0x55f92c54f4c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7fd4192f0609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7fd418a27293]

    Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (61200020e568): CREATE TABLE v0 ( CHECK ( ( + '' ) / CONVERT ( DEFAULT ( v2 ) , REAL ) IS NULL IS NULL IS NULL IS UNKNOWN ) , v3 BINARY COLLATE BINARY AS ( 'x' ) STORED , v2 MEDIUMINT NULL SERIAL DEFAULT VALUE SERIAL DEFAULT VALUE , v1 LONGBLOB ) Connection ID (thread ID): 9 Status: 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. Writing a core file fish: './bin/mysqld --defaults-file=my…' terminated by signal SIGABRT (Abort)

    opened by WLLS253 1
  • A signal crash caused by assertion failure

    A signal crash caused by assertion failure

    PoC: create database test; use test; CREATE TABLE v0 ( v1 TIMESTAMP , NONE YEAR ZEROFILL COMMENT 'x' ) ; CREATE TRIGGER v0 BEFORE INSERT ON v0 FOR EACH ROW DROP TABLESPACE MASTER_PASSWORD WAIT ; INSERT INTO v0 VALUES ( 127 , 'x' SOUNDS LIKE v1 IS TRUE ) , ( NULL , NULL ) ;

    Log: 2021-10-22T01:19:36.289847-00:00 0 [Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 1024 (request: 615350) 2021-10-22T01:19:36.289862-00:00 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 214 (requested 36000) 2021-10-22T01:19:36.289880-00:00 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 400 (requested 32768) 2021-10-22T01:19:36.410489-00:00 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release. 2021-10-22T01:19:36.410524-00:00 0 [Warning] [MY-011069] [Server] The syntax '--master-info-file' is deprecated and will be removed in a future release. 2021-10-22T01:19:36.410622-00:00 0 [Warning] [MY-011069] [Server] The syntax '--log-bin-use-v1-row-events' is deprecated and will be removed in a future release. 2021-10-22T01:19:36.410803-00:00 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-10-22T01:19:36.410845-00:00 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release. 2021-10-22T01:19:36.411057-00:00 0 [Warning] [MY-010084] [Server] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set 2021-10-22T01:19:36.411072-00:00 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-10-22T01:19:36.411227-00:00 0 [System] [MY-010116] [Server] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld (mysqld 8.0.18-debug-asan) starting as process 61191 2021-10-22T01:19:36.413769-00:00 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-10-22T01:19:36.414683-00:00 0 [Warning] [MY-010108] [Server] setrlimit could not change the size of core files to 'infinity'; We may not be able to generate a core file on signals 2021-10-22T01:19:36.551597-00:00 0 [Warning] [MY-012364] [InnoDB] innodb_open_files should not be greater than the open_files_limit.

    2021-10-22T01:19:44.507074-00:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2021-10-22T01:19:44.612162-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_polarx_port=32886'. 2021-10-22T01:19:44.613246-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_polarx_max_connections=5000'. 2021-10-22T01:19:44.614205-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-info=127.0.0.1:[email protected]'. 2021-10-22T01:19:44.615177-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-id=5431'. 2021-10-22T01:19:44.616156-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_enable_gts=1'. 2021-10-22T01:19:44.617143-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_log_sql_info=1'. 2021-10-22T01:19:44.618121-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_log_sql_info_index=1'. 2021-10-22T01:19:44.619103-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_indexstat=1'. 2021-10-22T01:19:44.620110-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_tablestat=1'. 2021-10-22T01:19:44.621126-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_slave_pr_mode=TABLE'. 2021-10-22T01:19:44.622147-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_large_trx=ON'. 2021-10-22T01:19:44.623175-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus-io-thread_cnt=8'. 2021-10-22T01:19:44.624217-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus-worker-thread_cnt=8'. 2021-10-22T01:19:44.625256-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_max_delay_index=10000'. 2021-10-22T01:19:44.626288-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus-election-timeout=10000'. 2021-10-22T01:19:44.627350-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_max_packet_size=131072'. 2021-10-22T01:19:44.628391-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_max_log_size=20M'. 2021-10-22T01:19:44.629446-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_auto_leader_transfer=ON'. 2021-10-22T01:19:44.630512-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_log_cache_size=536870912'. 2021-10-22T01:19:44.631583-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_prefetch_cache_size=268435456'. 2021-10-22T01:19:44.632664-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_prefetch_window_size=100'. 2021-10-22T01:19:44.633729-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_consensus_auto_reset_match_index=ON'. 2021-10-22T01:19:44.634822-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-mts-recover-use-index=ON'. 2021-10-22T01:19:44.635915-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_async_commit_thread_count=128'. 2021-10-22T01:19:44.637022-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_commit_lock_done_count=1'. 2021-10-22T01:19:44.638140-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_cluster-log-type-node=OFF'. 2021-10-22T01:19:44.639272-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_log_slow_verbosity=full'. 2021-10-22T01:19:44.640411-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_rds_check_core_file_enabled=ON'. 2021-10-22T01:19:44.641540-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_boost_pk_access=1'. 2021-10-22T01:19:44.642692-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_io_state=1'. 2021-10-22T01:19:44.643842-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_use_myfs=0'. 2021-10-22T01:19:44.645026-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_daemon_memcached_values_delimiter=:;:'. 2021-10-22T01:19:44.646197-00:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose_daemon_memcached_option=-t 32 -c 8000 -p15506'. 2021-10-22T01:19:45.101253-00:00 0 [System] [MY-010931] [Server] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld: ready for connections. Version: '8.0.18-debug-asan' socket: '/root/workspace/PolarDB/galaxyengine/build/run/mysql.sock' port: 4886 Source distribution. 2021-10-22T01:19:45.369035-00:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 32886 socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060 mysqld: sql/sql_parse.cc:3034: int mysql_execute_command(THD*, bool): Assertion `!thd->in_sub_stmt' failed. 01:35:07 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x627000380100 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 = 7fc98f5abbd0 thread_stack 0x100000 /usr/lib/x86_64-linux-gnu/libasan.so.4(+0x566d0) [0x7fc9dbe7b6d0] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0xa9) [0x559f563f106d] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(handle_fatal_signal+0x523) [0x559f5490320e] /lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7fc9dbe173c0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7fc9db46618b] /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7fc9db445859] /lib/x86_64-linux-gnu/libc.so.6(+0x25729) [0x7fc9db445729] /lib/x86_64-linux-gnu/libc.so.6(+0x36f36) [0x7fc9db456f36] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_execute_command(THD*, bool)+0x1348) [0x559f544ef0c0] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0xe4) [0x559f541f1f6a] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x303) [0x559f541f5d23] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x28b) [0x559f541f6a3d] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x30b) [0x559f541f7ed5] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(sp_head::execute(THD*, bool)+0xe14) [0x559f541e0462] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x7f6) [0x559f541e1a32] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Trigger::execute(THD*)+0x1ea) [0x559f5479f3e2] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Trigger_chain::execute_triggers(THD*)+0xb3) [0x559f547a2ead] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x15c) [0x559f5479062a] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(call_before_insert_triggers(THD*, TABLE*, enum_trigger_event_type, MY_BITMAP*)+0x87) [0x559f5428f59d] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(fill_record_n_invoke_before_triggers(THD*, Field**, List&, TABLE*, enum_trigger_event_type, int)+0x39c) [0x559f5426a2e2] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0xfa6) [0x559f5443f37c] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x74d) [0x559f545d1d15] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_execute_command(THD*, bool)+0x3820) [0x559f544f1598] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(mysql_parse(THD*, Parser_state*)+0xa0c) [0x559f544f8d71] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1f61) [0x559f544fb69f] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(do_command(THD*)+0xaa6) [0x559f544fee0f] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0x7ef4819) [0x559f548cb819] /root/workspace/PolarDB/galaxyengine/build/bin/mysqld(+0xa63f4c4) [0x559f570164c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7fc9dbe0b609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7fc9db542293]

    Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (6070016f0e18): DROP TABLESPACE MASTER_PASSWORD WAIT Connection ID (thread ID): 9 Status: 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. Writing a core file fish: './bin/mysqld --defaults-file=my…' terminated by signal SIGABRT (Abort)

    opened by WLLS253 1
  • Build error in Debian

    Build error in Debian

    Build in Debian 10 g++ (Debian 7.4.0-6) 7.4.0 gcc (Debian 7.4.0-6) 7.4.0

    Error message is : In file included from /root/ApsaraDB/galaxyengine/sql/sys_vars.cc:44:0: /root/ApsaraDB/galaxyengine/sql/sys_vars.cc:6785:66: error: ‘FALSE’ was not declared in this scope SESSION_ONLY(sequence_read_skip_cache), NO_CMD_LINE, DEFAULT(FALSE), ^ /root/ApsaraDB/galaxyengine/sql/sys_vars.h:102:20: note: in definition of macro ‘DEFAULT’ #define DEFAULT(X) X ^ /root/ApsaraDB/galaxyengine/sql/sys_vars.cc:6785:66: note: suggested alternative: ‘FILE’ SESSION_ONLY(sequence_read_skip_cache), NO_CMD_LINE, DEFAULT(FALSE), ^ /root/ApsaraDB/galaxyengine/sql/sys_vars.h:102:20: note: in definition of macro ‘DEFAULT’ #define DEFAULT(X) X ^ /root/ApsaraDB/galaxyengine/sql/sys_vars_ext.cc:263:48: error: ‘FALSE’ was not declared in this scope DEFAULT(FALSE), NO_MUTEX_GUARD, ^ /root/ApsaraDB/galaxyengine/sql/sys_vars.h:102:20: note: in definition of macro ‘DEFAULT’ #define DEFAULT(X) X ^ /root/ApsaraDB/galaxyengine/sql/sys_vars_ext.cc:263:48: note: suggested alternative: ‘FILE’ DEFAULT(FALSE), NO_MUTEX_GUARD, ^ /root/ApsaraDB/galaxyengine/sql/sys_vars.h:102:20: note: in definition of macro ‘DEFAULT’ #define DEFAULT(X) X ^ make[2]: *** [sql/CMakeFiles/sql_main.dir/build.make:3055: sql/CMakeFiles/sql_main.dir/sys_vars.cc.o] Error 1 make[2]: *** Waiting for unfinished jobs.... make[1]: *** [CMakeFiles/Makefile2:11487: sql/CMakeFiles/sql_main.dir/all] Error 2 make: *** [Makefile:163: all] Error 2

    opened by turbokernel 1
  • ARM平台make error

    ARM平台make error

    平台:Kylin Linux Advanced Server release V10 (Tercel) gcc:gcc (GCC) 7.3.0 报错信息:

    [ 56%] Building CXX object storage/xengine/CMakeFiles/xengine_se.dir/core/memtable/art.cc.o
    In file included from /data/GalaxyDB/galaxyengine/storage/xengine/core/memtable/art.h:17:0,
                     from /data/GalaxyDB/galaxyengine/storage/xengine/core/memtable/art.cc:15:
    /data/GalaxyDB/galaxyengine/storage/xengine/core/memtable/art_node.h:28:10: fatal error: x86intrin.h: No such file or directory
     #include <x86intrin.h>
              ^~~~~~~~~~~~~
    compilation terminated.
    make[2]: *** [storage/xengine/CMakeFiles/xengine_se.dir/build.make:1194: storage/xengine/CMakeFiles/xengine_se.dir/core/memtable/art.cc.o] Error 1
    make[1]: *** [CMakeFiles/Makefile2:3836: storage/xengine/CMakeFiles/xengine_se.dir/all] Error 2
    

    查了下,应该是arm平台上gcc里不包含<x86intrin.h>这个头文件(包括下面的<emmintrin.h>,<immintrin.h>),尝试改为clang,报错信息更多

    opened by Hoxxx 1
  • make -j8 failed

    make -j8 failed

    OS: Ubuntu 20.04 LTS (GNU/Linux 5.4.0-42-generic x86_64)

    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xprotocol_impl.cc.o
    In file included from /home/ubuntu/develop/galaxyengine/sql/sql_cmd.h:31:0,
                     from /home/ubuntu/develop/galaxyengine/sql/sql_plugin.h:34,
                     from /home/ubuntu/develop/galaxyengine/include/mysql/plugin.h:35,
                     from /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:29:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘bool ha_sequence::setup_base_engine()’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:623:15: error: ‘FALSE’ was not declared in this scope
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:623:15: note: suggested alternative: ‘FILE’
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:626:15: error: ‘TRUE’ was not declared in this scope
       DBUG_RETURN(TRUE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘bool ha_sequence::setup_base_handler(MEM_ROOT*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:662:17: error: ‘TRUE’ was not declared in this scope
         DBUG_RETURN(TRUE);
                     ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:664:15: error: ‘FALSE’ was not declared in this scope
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:664:15: note: suggested alternative: ‘FILE’
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘bool ha_sequence::get_from_handler_file(const char*, MEM_ROOT*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:678:27: error: ‘FALSE’ was not declared in this scope
       if (m_file) DBUG_RETURN(FALSE);
                               ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:678:27: note: suggested alternative: ‘FILE’
       if (m_file) DBUG_RETURN(FALSE);
                               ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:682:15: error: ‘FALSE’ was not declared in this scope
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:682:15: note: suggested alternative: ‘FILE’
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:685:15: error: ‘TRUE’ was not declared in this scope
       DBUG_RETURN(TRUE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘bool ha_sequence::new_handler_from_sequence_info(MEM_ROOT*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:704:17: error: ‘TRUE’ was not declared in this scope
         DBUG_RETURN(TRUE);
                     ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:706:15: error: ‘FALSE’ was not declared in this scope
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:706:15: note: suggested alternative: ‘FILE’
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘bool ha_sequence::initialize_sequence(MEM_ROOT*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:722:19: error: ‘TRUE’ was not declared in this scope
           DBUG_RETURN(TRUE);
                       ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:725:17: error: ‘TRUE’ was not declared in this scope
         DBUG_RETURN(TRUE);
                     ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:730:17: error: ‘TRUE’ was not declared in this scope
         DBUG_RETURN(TRUE);
                     ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:172:7: note: in definition of macro ‘DBUG_EXECUTE_IF’
           a1                                 \
           ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:730:5: note: in expansion of macro ‘DBUG_RETURN’
         DBUG_RETURN(TRUE);
         ^
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:733:15: error: ‘FALSE’ was not declared in this scope
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:733:15: note: suggested alternative: ‘FILE’
       DBUG_RETURN(FALSE);
                   ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘virtual int ha_sequence::create(const char*, TABLE*, HA_CREATE_INFO*, dd::Table*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:1154:68: error: ‘TRUE’ was not declared in this scope
       if (get_from_handler_file(name, ha_thd()->mem_root)) DBUG_RETURN(TRUE);
                                                                        ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘virtual int ha_sequence::delete_table(const char*, const dd::Table*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:1193:68: error: ‘TRUE’ was not declared in this scope
       if (get_from_handler_file(name, ha_thd()->mem_root)) DBUG_RETURN(TRUE);
                                                                        ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc: In member function ‘virtual int ha_sequence::rename_table(const char*, const char*, const dd::Table*, dd::Table*)’:
    /home/ubuntu/develop/galaxyengine/sql/ha_sequence.cc:1307:68: error: ‘TRUE’ was not declared in this scope
       if (get_from_handler_file(from, ha_thd()->mem_root)) DBUG_RETURN(TRUE);
                                                                        ^
    /home/ubuntu/develop/galaxyengine/include/my_dbug.h:156:13: note: in definition of macro ‘DBUG_RETURN’
         return (a1);                              \
                 ^~
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xrow_impl.cc.o
    make[2]: *** [sql/CMakeFiles/sequence.dir/build.make:63: sql/CMakeFiles/sequence.dir/ha_sequence.cc.o] Error 1
    make[1]: *** [CMakeFiles/Makefile2:10502: sql/CMakeFiles/sequence.dir/all] Error 2
    make[1]: *** Waiting for unfinished jobs....
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xquery_result_impl.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient.dir/xcompression_impl.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xsession_impl.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient.dir/xrow.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient.dir/validator/capability_compression_validator.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient.dir/galaxy_protocol_string.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient.dir/__/__/__/sql-common/net_ns.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xconnection_impl.cc.o
    [ 61%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xcompression_negotiator.cc.o
    [ 62%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xcompression_impl.cc.o
    [ 62%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/xrow.cc.o
    [ 62%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/validator/capability_compression_validator.cc.o
    [ 62%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/galaxy_protocol_string.cc.o
    [ 62%] Building CXX object plugin/x/client/CMakeFiles/mysqlxclient_lite.dir/__/__/__/sql-common/net_ns.cc.o
    [ 62%] Linking CXX static library libmysqlxclient.a
    [ 62%] Built target mysqlxclient
    [ 62%] Linking CXX static library libmysqlxclient_lite.a
    [ 62%] Built target mysqlxclient_lite
    make: *** [Makefile:163: all] Error 2
    
    opened by guimingyue 0
  • compiling failed according to development doc

    compiling failed according to development doc

    Complile GalaxyEngine according to https://github.com/ApsaraDB/galaxysql/blob/main/docs/en/quickstart-development.md. got some errors when running cmake and make. cmake .
    -DFORCE_INSOURCE_BUILD=ON
    -DWITH_DEBUG=ON
    -DSYSCONFDIR="/u01/mysql"
    -DCMAKE_INSTALL_PREFIX="/u01/mysql"
    -DMYSQL_DATADIR="/u01/mysql/data"
    -DWITH_XENGINE_STORAGE_ENGINE=OFF
    -DWITH_BOOST="./extra/boost/boost_1_70_0.tar.gz"

    image image

    opened by demian0110 1
  • Is it necessary to configure large write buffers for good performance of X-Engine?

    Is it necessary to configure large write buffers for good performance of X-Engine?

    Hi galaxyengine developers,

    I found some large configurations for write buffers of X-Engine in:

    storage/xengine/core/pt_beilou.sh
    storage/xengine/tools/sysbench_benchmark/rds_my.cnf
    

    Like:

    xengine_write_buffer_size=512M
    xengine_max_write_buffer_number=1000
    xengine_max_write_buffer_number_to_maintain=1000
    xengine_db_write_buffer_size=100G
    xengine_db_total_write_buffer_size=100G
    

    These options make much memory be used in memtables, which seems pretty more than that in RocskDB's benchmark.

    It is said that larger memtables result in longer recovery time. And the write throughput is finally decided by compaction.

    Could you tell us more about your considerations on these buffer configurations? Is it necessary to configure large write buffers for good performance of X-Engine?

    Thanks.

    opened by iyupeng 4
  • ARM 服务器编译 DN 失败

    ARM 服务器编译 DN 失败

    平台:Linux 4.19.90-2003.4.0.0036.oe1.aarch64 https://github.com/ApsaraDB/galaxyengine/issues/1 SMP Mon Mar 23 19:06:43 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux gcc: gcc (GCC) 10.2.1 报错信息:

    /usr/include/c++/10/bits/hashtable.h: In instantiation of ‘class std::_Hashtable<long int, std::pair<const long int, xengine::storage::AsyncRandomAccessExtent*>, xengine::memory::stl_adapt_allocator<std::pair<long int, xengine::storage::AsyncRandomAccessExtent*>, 14>, std::__detail::_Select1st, std::equal_to, std::hash, std::__detail::_Mod_range_hashing, std::__detail::_Default_ranged_hash, std::__detail::_Prime_rehash_policy, std::__detail::_Hashtable_traits<false, false, true> >’: /usr/include/c++/10/bits/unordered_map.h:105:18: required from ‘class std::unordered_map<long int, xengine::storage::AsyncRandomAccessExtent*, std::hash, std::equal_to, xengine::memory::stl_adapt_allocator<std::pair<long int, xengine::storage::AsyncRandomAccessExtent*>, 14> >’ middleware/galaxyengine/storage/xengine/core/compact/compaction.h:589:21: required from here /usr/include/c++/10/bits/hashtable.h:192:21: error: static assertion failed: unordered container must have the same value_type as its allocator 192 | static_assert(is_same<typename _Alloc::value_type, _Value>{}, | ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ cc1plus: all warnings being treated as errors make[2]: *** [storage/xengine/CMakeFiles/xengine_se.dir/build.make:80: storage/xengine/CMakeFiles/xengine_se.dir/handler/ha_xengine.cc.o] Error 1 make[1]: *** [CMakeFiles/Makefile2:5298: storage/xengine/CMakeFiles/xengine_se.dir/all] Error 2 make: *** [Makefile:180: all] Error 2 你好,在上述服务器环境,遇到了同样的问题,请问有没有快速修复的方法? #5

    opened by wsm12138 0
  • x-engine  run db_bench coredump

    x-engine run db_bench coredump

    I want to run the x-engine db_bench alone.

    BUILD

    git clone https://github.com/ApsaraDB/galaxyengine.git
    cd galaxyengine/storage/xengine/core
    sh build.sh -t release -g asan
    

    RUN

    ./db_bench - coredump
    
    xengine::tools::Benchmark::OpenDb ([email protected]=0x7fffffffca70, options=..., db_name=..., [email protected]=0x7fffffffcaa8) at /media/ssd2/zhanghuigui/galaxyengine/storage/xengine/core/tools/db_bench_tool.cc:4035
    4035            db->cfh.push_back(dbimpl->DefaultColumnFamily());
    Missing separate debuginfos, use: debuginfo-install libaio-0.3.109-13.el7.x86_64 libgcc-4.8.5-39.el7.x86_64
    (gdb) bt
    #0  xengine::tools::Benchmark::OpenDb ([email protected]=0x7fffffffca70, options=..., db_name=..., [email protected]=0x7fffffffcaa8) at /galaxyengine/storage/xengine/core/tools/db_bench_tool.cc:4035
    #1  0x0000000000655699 in xengine::tools::Benchmark::InitializeOptionsGeneral ([email protected]=0x7fffffffca70, [email protected]=0x7fffffffcb68)
        at /galaxyengine/storage/xengine/core/tools/db_bench_tool.cc:3967
    #2  0x0000000000656c49 in xengine::tools::Benchmark::Open (opts=0x7fffffffcb68, this=0x7fffffffca70) at /galaxyengine/storage/xengine/core/tools/db_bench_tool.cc:3987
    #3  xengine::tools::Benchmark::Run ([email protected]=0x7fffffffca70) at /galaxyengine/storage/xengine/core/tools/db_bench_tool.cc:2932
    #4  0x00000000006252b9 in xengine::tools::db_bench_tool (argc=<optimized out>, argv=<optimized out>) at /galaxyengine/storage/xengine/core/tools/db_bench_tool.cc:7773
    #5  0x00007ffff6945c05 in __libc_start_main () from /lib64/libc.so.6
    #6  0x00000000005f595e in _start ()
    
    opened by BaronStack 1
  • xengine core dump with simple put

    xengine core dump with simple put

    the simple code like this would coredump:

    // Copyright (c) 2011-present, Facebook, Inc.  All rights reserved.
    //  This source code is licensed under both the GPLv2 (found in the
    //  COPYING file in the root directory) and Apache 2.0 License
    //  (found in the LICENSE.Apache file in the root directory).
    
    #include <cstdio>
    #include <string>
    // #include <gflags/gflags.h>
    #include "xengine/db.h"
    #include "xengine/statistics.h"
    
    #include "cache/lru_cache.h"
    #include "db/column_family.h"
    #include "db/internal_stats.h"
    #include "xengine/slice.h"
    #include "xengine/options.h"
    #include "xengine/table.h"
    #include <iostream>
    using namespace std;
    using namespace xengine;
    using namespace xengine::db;
    using namespace xengine::common;
    using namespace xengine::cache;
    using namespace xengine::table;
    
    std::string kDBPath = "/tmp/rocksdb_simple_example";
    
    
    int main(int argc, char* argv[]) {
    
    
      xengine::db::DB* db;
      common::Options options;
      table::BlockBasedTableOptions table_options;
      table_options.filter_policy.reset(NewBloomFilterPolicy(10, true));  
      table_options.cache_index_and_filter_blocks =true;  
    
      options.table_factory.reset(
          xengine::table::NewExtentBasedTableFactory(table_options));  
      options.create_if_missing = true;
    
      // open DB
      Status s = DB::Open(options, kDBPath, &db);
      assert(s.ok());
      WriteOptions wop;
      wop.disableWAL = true;
      for(int i=0;i<100;i++){
        // Put key-value
        string value;
        value.assign(1024*1024,'a');
        s = db->Put(wop, "key11" + std::to_string(i), value);
        if(!s.ok()){
          cout <<"put not ok:"<< s.ToString()<<endl;      
        }
      }
    
      cout <<"-----------------------begin flush-------------------------------"<<endl;  
      s = db->Flush(FlushOptions(),db->DefaultColumnFamily());
      if(!s.ok()){
          cout <<"put not ok:"<< s.ToString()<<endl;      
      }
    
    
      delete db;
    
      return 0;
    }
    
    
    
    (gdb) 
    #0  0x00007fafa9377428 in __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:54
    #1  0x00007fafa937902a in __GI_abort () at abort.c:89
    #2  0x00007fafa93b97ea in __libc_message ([email protected]=2, [email protected]=0x7fafa94d2ed8 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/posix/libc_fatal.c:175
    #3  0x00007fafa93c237a in malloc_printerr (ar_ptr=<optimized out>, ptr=<optimized out>, str=0x7fafa94d2fe8 "double free or corruption (out)", action=3) at malloc.c:5006
    #4  _int_free (av=<optimized out>, p=<optimized out>, have_lock=0) at malloc.c:3867
    #5  0x00007fafa93c653c in __GI___libc_free (mem=<optimized out>) at malloc.c:2968
    #6  0x00000000004c26fe in main (argc=1, argv=0x7ffd3122c3b8) at simple_example.cc:64
    (gdb) 
    

    Working on ·Ubuntu 16.04.4 LTS ,by using cmd: g++ -ggdb --std=c++11 simple_example.cc -I/root/tmp/galaxyengine/storage/xengine/core/build/include -I../ -DROCKSDB_PLATFORM_POSIX ../libxengine.a -lpthread -laio 。

    and the options is:

    [2021-12-23 06:58:47.379836] INFO  [25571] [XENGINE] DumpDBFileSummary(db_info_dumper.cc:129) Write Ahead Log file in /tmp/rocksdb_simple_example: 
    [2021-12-23 06:58:47.379843] INFO  [25571] [XENGINE] Dump(db_options.cc:109)                         Options.error_if_exists: 0
    [2021-12-23 06:58:47.379849] INFO  [25571] [XENGINE] Dump(db_options.cc:111)                       Options.create_if_missing: 1
    [2021-12-23 06:58:47.379854] INFO  [25571] [XENGINE] Dump(db_options.cc:113)                         Options.paranoid_checks: 1
    [2021-12-23 06:58:47.379860] INFO  [25571] [XENGINE] Dump(db_options.cc:115)                                     Options.env: 0xa71be0
    [2021-12-23 06:58:47.379865] INFO  [25571] [XENGINE] Dump(db_options.cc:117)                          Options.max_open_files: -1
    [2021-12-23 06:58:47.379870] INFO  [25571] [XENGINE] Dump(db_options.cc:119)                Options.max_file_opening_threads: 16
    [2021-12-23 06:58:47.379876] INFO  [25571] [XENGINE] Dump(db_options.cc:121)                               Options.use_fsync: 0
    [2021-12-23 06:58:47.379881] INFO  [25571] [XENGINE] Dump(db_options.cc:124)                       Options.max_log_file_size: 0
    [2021-12-23 06:58:47.379887] INFO  [25571] [XENGINE] Dump(db_options.cc:127)                  Options.max_manifest_file_size: 18446744073709551615
    [2021-12-23 06:58:47.379892] INFO  [25571] [XENGINE] Dump(db_options.cc:130)                   Options.log_file_time_to_roll: 0
    [2021-12-23 06:58:47.379897] INFO  [25571] [XENGINE] Dump(db_options.cc:133)                       Options.keep_log_file_num: 1000
    [2021-12-23 06:58:47.379903] INFO  [25571] [XENGINE] Dump(db_options.cc:136)                    Options.recycle_log_file_num: 0
    [2021-12-23 06:58:47.379908] INFO  [25571] [XENGINE] Dump(db_options.cc:138)                         Options.allow_fallocate: 1
    [2021-12-23 06:58:47.379914] INFO  [25571] [XENGINE] Dump(db_options.cc:140)                        Options.allow_mmap_reads: 0
    [2021-12-23 06:58:47.379919] INFO  [25571] [XENGINE] Dump(db_options.cc:142)                       Options.allow_mmap_writes: 0
    [2021-12-23 06:58:47.379924] INFO  [25571] [XENGINE] Dump(db_options.cc:144)                        Options.use_direct_reads: 0
    [2021-12-23 06:58:47.379930] INFO  [25571] [XENGINE] Dump(db_options.cc:148)                        Options.use_direct_io_for_flush_and_compaction: 0
    [2021-12-23 06:58:47.379936] INFO  [25571] [XENGINE] Dump(db_options.cc:150)          Options.create_missing_column_families: 0
    [2021-12-23 06:58:47.379941] INFO  [25571] [XENGINE] Dump(db_options.cc:152)                              Options.db_log_dir: 
    [2021-12-23 06:58:47.379947] INFO  [25571] [XENGINE] Dump(db_options.cc:154)                                 Options.wal_dir: /tmp/rocksdb_simple_example
    [2021-12-23 06:58:47.379952] INFO  [25571] [XENGINE] Dump(db_options.cc:156)                Options.table_cache_numshardbits: 7
    [2021-12-23 06:58:47.379957] INFO  [25571] [XENGINE] Dump(db_options.cc:159)                      Options.max_subcompactions: 1
    [2021-12-23 06:58:47.379963] INFO  [25571] [XENGINE] Dump(db_options.cc:161)                  Options.max_background_flushes: 1
    [2021-12-23 06:58:47.379968] INFO  [25571] [XENGINE] Dump(db_options.cc:164)                         Options.WAL_ttl_seconds: 0
    [2021-12-23 06:58:47.379973] INFO  [25571] [XENGINE] Dump(db_options.cc:167)                       Options.WAL_size_limit_MB: 0
    [2021-12-23 06:58:47.379979] INFO  [25571] [XENGINE] Dump(db_options.cc:170)             Options.manifest_preallocation_size: 4194304
    [2021-12-23 06:58:47.379984] INFO  [25571] [XENGINE] Dump(db_options.cc:172)                     Options.is_fd_close_on_exec: 1
    [2021-12-23 06:58:47.379990] INFO  [25571] [XENGINE] Dump(db_options.cc:174)                   Options.advise_random_on_open: 1
    [2021-12-23 06:58:47.379995] INFO  [25571] [XENGINE] Dump(db_options.cc:177)                    Options.db_write_buffer_size: 0
    [2021-12-23 06:58:47.380000] INFO  [25571] [XENGINE] Dump(db_options.cc:180)              Options.db_total_write_buffer_size: 0
    [2021-12-23 06:58:47.380005] INFO  [25571] [XENGINE] Dump(db_options.cc:182)         Options.access_hint_on_compaction_start: 1
    [2021-12-23 06:58:47.380011] INFO  [25571] [XENGINE] Dump(db_options.cc:184)  Options.new_table_reader_for_compaction_inputs: 0
    [2021-12-23 06:58:47.380016] INFO  [25571] [XENGINE] Dump(db_options.cc:187)               Options.compaction_readahead_size: 0
    [2021-12-23 06:58:47.380022] INFO  [25571] [XENGINE] Dump(db_options.cc:190)           Options.random_access_max_buffer_size: 1048576
    [2021-12-23 06:58:47.380027] INFO  [25571] [XENGINE] Dump(db_options.cc:193)           Options.writable_file_max_buffer_size: 1048576
    [2021-12-23 06:58:47.380033] INFO  [25571] [XENGINE] Dump(db_options.cc:195)                      Options.use_adaptive_mutex: 0
    [2021-12-23 06:58:47.380038] INFO  [25571] [XENGINE] Dump(db_options.cc:197)                            Options.rate_limiter: (nil)
    [2021-12-23 06:58:47.380044] INFO  [25571] [XENGINE] Dump(db_options.cc:200)     Options.sst_file_manager.rate_bytes_per_sec: 0
    [2021-12-23 06:58:47.380050] INFO  [25571] [XENGINE] Dump(db_options.cc:203)                          Options.bytes_per_sync: 0
    [2021-12-23 06:58:47.380056] INFO  [25571] [XENGINE] Dump(db_options.cc:206)                      Options.wal_bytes_per_sync: 0
    [2021-12-23 06:58:47.380061] INFO  [25571] [XENGINE] Dump(db_options.cc:208)                       Options.wal_recovery_mode: 1
    [2021-12-23 06:58:47.380066] INFO  [25571] [XENGINE] Dump(db_options.cc:210)                       Options.enable_aio_wal_reader: 1
    [2021-12-23 06:58:47.380071] INFO  [25571] [XENGINE] Dump(db_options.cc:212)                       Options.parallel_wal_recovery: 1
    [2021-12-23 06:58:47.380076] INFO  [25571] [XENGINE] Dump(db_options.cc:214)                       Options.parallel_recovery_thread_num: 0
    [2021-12-23 06:58:47.380082] INFO  [25571] [XENGINE] Dump(db_options.cc:216)                  Options.enable_thread_tracking: 0
    [2021-12-23 06:58:47.380088] INFO  [25571] [XENGINE] Dump(db_options.cc:218)         Options.allow_concurrent_memtable_write: 1
    [2021-12-23 06:58:47.380093] INFO  [25571] [XENGINE] Dump(db_options.cc:220)      Options.enable_write_thread_adaptive_yield: 1
    [2021-12-23 06:58:47.380098] INFO  [25571] [XENGINE] Dump(db_options.cc:223)             Options.write_thread_max_yield_usec: 100
    [2021-12-23 06:58:47.380104] INFO  [25571] [XENGINE] Dump(db_options.cc:226)            Options.write_thread_slow_yield_usec: 3
    [2021-12-23 06:58:47.380110] INFO  [25571] [XENGINE] Dump(db_options.cc:233)                               Options.row_cache: None
    [2021-12-23 06:58:47.380115] INFO  [25571] [XENGINE] Dump(db_options.cc:237)                              Options.wal_filter: None
    [2021-12-23 06:58:47.380120] INFO  [25571] [XENGINE] Dump(db_options.cc:240)             Options.avoid_flush_during_recovery: 0
    [2021-12-23 06:58:47.380126] INFO  [25571] [XENGINE] Dump(db_options.cc:242)                         Options.compaction_type: Stream
    [2021-12-23 06:58:47.380131] INFO  [25571] [XENGINE] Dump(db_options.cc:244)                         Options.compaction_mode: 0
    [2021-12-23 06:58:47.380137] INFO  [25571] [XENGINE] Dump(db_options.cc:246)               Options.cpu_compaction_thread_num: 8
    [2021-12-23 06:58:47.380142] INFO  [25571] [XENGINE] Dump(db_options.cc:248)              Options.fpga_compaction_thread_num: 8
    [2021-12-23 06:58:47.380147] INFO  [25571] [XENGINE] Dump(db_options.cc:250)                          Options.fpga_device_id: 0
    [2021-12-23 06:58:47.380152] INFO  [25571] [XENGINE] Dump(db_options.cc:252)                        Options.table_cache_size: 1073741824
    [2021-12-23 06:58:47.380158] INFO  [25571] [XENGINE] Dump(db_options.cc:326)             Options.base_background_compactions: 1
    [2021-12-23 06:58:47.380164] INFO  [25571] [XENGINE] Dump(db_options.cc:328)              Options.max_background_compactions: 1
    [2021-12-23 06:58:47.380169] INFO  [25571] [XENGINE] Dump(db_options.cc:330)             Options.avoid_flush_during_shutdown: 0
    [2021-12-23 06:58:47.380175] INFO  [25571] [XENGINE] Dump(db_options.cc:333)                      Options.delayed_write_rate: 16777216
    [2021-12-23 06:58:47.380181] INFO  [25571] [XENGINE] Dump(db_options.cc:336)                      Options.max_total_wal_size: 0
    [2021-12-23 06:58:47.380186] INFO  [25571] [XENGINE] Dump(db_options.cc:339)     Options.delete_obsolete_files_period_micros: 21600000000
    [2021-12-23 06:58:47.380192] INFO  [25571] [XENGINE] Dump(db_options.cc:341)                   Options.stats_dump_period_sec: 600
    [2021-12-23 06:58:47.380197] INFO  [25571] [XENGINE] Dump(db_options.cc:344)             Options.batch_group_slot_array_size: 5
    [2021-12-23 06:58:47.380203] INFO  [25571] [XENGINE] Dump(db_options.cc:347)              Options.batch_group_max_group_size: 80
    [2021-12-23 06:58:47.380208] INFO  [25571] [XENGINE] Dump(db_options.cc:350)     Options.batch_group_max_leader_wait_time_us: 200
    [2021-12-23 06:58:47.380214] INFO  [25571] [XENGINE] Dump(db_options.cc:353)     Options.concurrent_writable_file_buffer_num: 4
    [2021-12-23 06:58:47.380219] INFO  [25571] [XENGINE] Dump(db_options.cc:356) Options.concurrent_writable_file_single_buffer_size: 4194304
    [2021-12-23 06:58:47.380225] INFO  [25571] [XENGINE] Dump(db_options.cc:359) Options.concurrent_writable_file_buffer_switch_limit: 524288
    [2021-12-23 06:58:47.380231] INFO  [25571] [XENGINE] Dump(db_options.cc:362)                Options.use_direct_write_for_wal: 1
    [2021-12-23 06:58:47.380236] INFO  [25571] [XENGINE] Dump(db_options.cc:365)                  Options.query_trace_enable_count: 1
    [2021-12-23 06:58:47.380242] INFO  [25571] [XENGINE] Dump(db_options.cc:368)                 Options.query_trace_print_stats: 0
    [2021-12-23 06:58:47.380248] INFO  [25571] [XENGINE] Dump(db_options.cc:371)            Options.mutex_backtrace_threshold_ns: 100000000
    [2021-12-23 06:58:47.380253] INFO  [25571] [XENGINE] Dump(db_options.cc:374)            Options.auto_shrink_enabled: 1)
    [2021-12-23 06:58:47.380259] INFO  [25571] [XENGINE] Dump(db_options.cc:377)            Options.max_free_extent_percent: 10)
    [2021-12-23 06:58:47.380265] INFO  [25571] [XENGINE] Dump(db_options.cc:380)            Options.shrink_allocate_interval: 3600)
    [2021-12-23 06:58:47.380270] INFO  [25571] [XENGINE] Dump(db_options.cc:383)            Options.max_shrink_extent_count: 512)
    [2021-12-23 06:58:47.380276] INFO  [25571] [XENGINE] Dump(db_options.cc:386)            Options.total_max_shrink_extent_count: 7680)
    [2021-12-23 06:58:47.380281] INFO  [25571] [XENGINE] Dump(db_options.cc:389)            Options.idle_tasks_schedule_time: 60)
    [2021-12-23 06:58:47.380287] INFO  [25571] [XENGINE] Dump(db_options.cc:392)            Options.auto_shrink_schedule_interval: 3600)
    [2021-12-23 06:58:47.380293] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:157) Compression algorithms supported:
    [2021-12-23 06:58:47.380299] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:158)    Snappy supported: 0
    [2021-12-23 06:58:47.380305] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:159)    Zlib supported: 0
    [2021-12-23 06:58:47.380310] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:160)    Bzip supported: 0
    [2021-12-23 06:58:47.380316] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:161)    LZ4 supported: 0
    [2021-12-23 06:58:47.380322] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:162)    ZSTD supported: 0
    [2021-12-23 06:58:47.380327] INFO  [25571] [XENGINE] DumpSupportInfo(db_impl.cc:164) Fast CRC32 supported: 
    
    opened by dongdongwcpp 0
Kunlun distributed DBMS is a NewSQL OLTP relational distributed database management system

Kunlun distributed DBMS is a NewSQL OLTP relational distributed database management system. Application developers can use Kunlun to build IT systems that handles terabytes of data, without any effort on their part to implement data sharding, distributed transaction processing, distributed query processing, crash safety, high availability, strong consistency, horizontal scalability. All these powerful features are provided by Kunlun.

zettadb 99 Jun 24, 2022
Simple-MySQL-API is a free and easy API to manipulate MySQL with C99 and GCC compiler under GNU/Linux OS.

Simple-MySQL-API is a free and easy API to manipulate MySQL with C99 and GCC compiler under GNU/Linux OS.

Neptune 7 Apr 24, 2022
A friendly and lightweight C++ database library for MySQL, PostgreSQL, SQLite and ODBC.

QTL QTL is a C ++ library for accessing SQL databases and currently supports MySQL, SQLite, PostgreSQL and ODBC. QTL is a lightweight library that con

null 155 Jun 26, 2022
Config and tools for config of tasmota devices from mysql database

tasmota-sql Tools for management of tasmota devices based on mysql. The tasconfig command can load config from tasmota and store in sql, or load from

RevK 3 Jan 8, 2022
Trilogy is a client library for MySQL-compatible database servers, designed for performance, flexibility, and ease of embedding.

Trilogy is a client library for MySQL-compatible database servers, designed for performance, flexibility, and ease of embedding.

GitHub 248 Jun 11, 2022
Nebula Graph is a distributed, fast open-source graph database featuring horizontal scalability and high availability

Nebula Graph is an open-source graph database capable of hosting super large scale graphs with dozens of billions of vertices (nodes) and trillions of edges, with milliseconds of latency.

vesoft inc. 807 Jun 30, 2022
YugabyteDB is a high-performance, cloud-native distributed SQL database that aims to support all PostgreSQL features

YugabyteDB is a high-performance, cloud-native distributed SQL database that aims to support all PostgreSQL features. It is best to fit for cloud-native OLTP (i.e. real-time, business-critical) applications that need absolute data correctness and require at least one of the following: scalability, high tolerance to failures, or globally-distributed deployments.

yugabyte 6.6k Jul 1, 2022
OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards.

What is OceanBase database OceanBase Database is a native distributed relational database. It is developed entirely by Alibaba and Ant Group. OceanBas

OceanBase 4.4k Jun 27, 2022
BaikalDB, A Distributed HTAP Database.

BaikalDB supports sequential and randomised realtime read/write of structural data in petabytes-scale. BaikalDB is compatible with MySQL protocol and it supports MySQL style SQL dialect, by which users can migrate their data storage from MySQL to BaikalDB seamlessly.

Baidu 953 Jun 20, 2022
A mini database for learning database

A mini database for learning database

Chuckie Tan 3 Nov 3, 2021
Sistema de gestão corporativa em interface de linha de comando, para banco de dados MySQL/MariaDB

SimpleERP Sistema de gestão corporativa em interface de linha de comando, para banco de dados MySQL/MariaDB Autores Miguel Nischor - Project Lead Como

Code Brasil 4 Jun 14, 2021
Flashback mysql data to any point

一、简介 MyFlash是由美团点评公司技术工程部开发维护的一个回滚DML操作的工具。该工具通过解析v4版本的binlog,完成回滚操作。相对已有的回滚工具,其增加了更多的过滤选项,让回滚更加容易。 该工具已经在美团点评内部使用 二、详细说明 安装 使用 测试用例 三、限制 binlog格式必须为r

美团 1k Jun 23, 2022
Reading, thinking and coding about MySQL,InnoDB and MGR

MySQL 8.0.27 Review by adzfolc Notifications In this doc, I will make the rules of my code review and period summary for later review. This chapter ma

null 5 Jun 25, 2022
Simple constant key/value storage library, for read-heavy systems with infrequent large bulk inserts.

Sparkey is a simple constant key/value storage library. It is mostly suited for read heavy systems with infrequent large bulk inserts. It includes bot

Spotify 965 Jun 19, 2022
DuckDB is an in-process SQL OLAP Database Management System

DuckDB is an in-process SQL OLAP Database Management System

DuckDB 5.4k Jun 27, 2022
PolarDB for PostgreSQL (PolarDB for short) is an open source database system based on PostgreSQL.

PolarDB for PostgreSQL (PolarDB for short) is an open source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication. PolarDB is designed to add values and new features to PostgreSQL in dimensions of high performance, scalability, high availability, and elasticity. At the same time, PolarDB remains SQL compatibility to single-node PostgreSQL with best effort.

Alibaba 2.3k Jun 30, 2022
MillenniumDB is a graph oriented database management system

Millennium DB MillenniumDB is a graph oriented database management system developed by the Millennium Institute for Foundational Research on Data (IMF

null 21 Jun 20, 2022
Database system project based on CMU 15-445/645 (FALL 2020)

Database system project based on CMU 15-445/645 (FALL 2020)

null 14 Jun 10, 2022
FoundationDB - the open source, distributed, transactional key-value store

FoundationDB is a distributed database designed to handle large volumes of structured data across clusters of commodity servers. It organizes data as

Apple 11.5k Jun 29, 2022