MariaDB Spider Engine UDF spider_bg_direct_sql can't find TEMPORARY table
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
enter code hereHi,
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
Variable_name Value
spider_auto_increment_mode -1
spider_bgs_first_read -1
spider_bgs_mode -1
spider_bgs_second_read -1
spider_bka_engine
spider_bka_mode -1
spider_bka_table_name_type -1
spider_block_size 16384
spider_bulk_size -1
spider_bulk_update_mode -1
spider_bulk_update_size -1
spider_casual_read -1
spider_conn_recycle_mode 0
spider_conn_recycle_strict 0
spider_conn_wait_timeout 10
spider_connect_error_interval 1
spider_connect_mutex OFF
spider_connect_retry_count 1000
spider_connect_retry_interval 1000
spider_connect_timeout -1
spider_crd_bg_mode -1
spider_crd_interval -1
spider_crd_mode -1
spider_crd_sync -1
spider_crd_type -1
spider_crd_weight -1
spider_delete_all_rows_type -1
spider_direct_dup_insert -1
spider_direct_order_limit -1
spider_dry_access OFF
spider_error_read_mode -1
spider_error_write_mode -1
spider_first_read -1
spider_force_commit 1
spider_general_log OFF
spider_index_hint_pushdown OFF
spider_init_sql_alloc_size -1
spider_internal_limit -1
spider_internal_offset -1
spider_internal_optimize -1
spider_internal_optimize_local -1
spider_internal_sql_log_off -1
spider_internal_unlock OFF
spider_internal_xa OFF
spider_internal_xa_id_type 0
spider_internal_xa_snapshot 0
spider_load_crd_at_startup -1
spider_load_sts_at_startup -1
spider_local_lock_table OFF
spider_lock_exchange OFF
spider_log_result_error_with_sql 0
spider_log_result_errors 0
spider_low_mem_read -1
spider_max_connections 0
spider_max_order -1
spider_multi_split_read -1
spider_net_read_timeout -1
spider_net_write_timeout -1
spider_ping_interval_at_trx_start 3600
spider_quick_mode -1
spider_quick_page_size -1
spider_read_only_mode -1
spider_remote_access_charset
spider_remote_autocommit -1
spider_remote_default_database
spider_remote_sql_log_off -1
spider_remote_time_zone
spider_remote_trx_isolation -1
spider_reset_sql_alloc -1
spider_same_server_link OFF
spider_second_read -1
spider_select_column_mode -1
spider_selupd_lock_mode -1
spider_semi_split_read -1
spider_semi_split_read_limit -1
spider_semi_table_lock 1
spider_semi_table_lock_connection -1
spider_semi_trx ON
spider_semi_trx_isolation -1
spider_skip_default_condition -1
spider_skip_parallel_search -1
spider_split_read -1
spider_store_last_crd -1
spider_store_last_sts -1
spider_sts_bg_mode -1
spider_sts_interval -1
spider_sts_mode -1
spider_sts_sync -1
spider_support_xa ON
spider_sync_autocommit ON
spider_sync_trx_isolation ON
spider_table_crd_thread_count 10
spider_table_init_error_interval 1
spider_table_sts_thread_count 10
spider_udf_ct_bulk_insert_interval -1
spider_udf_ct_bulk_insert_rows -1
spider_udf_ds_bulk_insert_rows -1
spider_udf_ds_table_loop_mode -1
spider_udf_ds_use_real_table -1
spider_udf_table_lock_mutex_count 20
spider_udf_table_mon_mutex_count 20
spider_use_all_conns_snapshot OFF
spider_use_consistent_snapshot OFF
spider_use_default_database ON
spider_use_flash_logs OFF
spider_use_handler -1
spider_use_pushdown_udf -1
spider_use_snapshot_with_flush_tables 0
spider_use_table_charset -1
spider_version 3.3.13
spider_xa_register_mode 1
mariadb temporal-tables spider
asked 5 mins ago
Toby ChenToby Chen
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
enter code hereHi,
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
Variable_name Value
spider_auto_increment_mode -1
spider_bgs_first_read -1
spider_bgs_mode -1
spider_bgs_second_read -1
spider_bka_engine
spider_bka_mode -1
spider_bka_table_name_type -1
spider_block_size 16384
spider_bulk_size -1
spider_bulk_update_mode -1
spider_bulk_update_size -1
spider_casual_read -1
spider_conn_recycle_mode 0
spider_conn_recycle_strict 0
spider_conn_wait_timeout 10
spider_connect_error_interval 1
spider_connect_mutex OFF
spider_connect_retry_count 1000
spider_connect_retry_interval 1000
spider_connect_timeout -1
spider_crd_bg_mode -1
spider_crd_interval -1
spider_crd_mode -1
spider_crd_sync -1
spider_crd_type -1
spider_crd_weight -1
spider_delete_all_rows_type -1
spider_direct_dup_insert -1
spider_direct_order_limit -1
spider_dry_access OFF
spider_error_read_mode -1
spider_error_write_mode -1
spider_first_read -1
spider_force_commit 1
spider_general_log OFF
spider_index_hint_pushdown OFF
spider_init_sql_alloc_size -1
spider_internal_limit -1
spider_internal_offset -1
spider_internal_optimize -1
spider_internal_optimize_local -1
spider_internal_sql_log_off -1
spider_internal_unlock OFF
spider_internal_xa OFF
spider_internal_xa_id_type 0
spider_internal_xa_snapshot 0
spider_load_crd_at_startup -1
spider_load_sts_at_startup -1
spider_local_lock_table OFF
spider_lock_exchange OFF
spider_log_result_error_with_sql 0
spider_log_result_errors 0
spider_low_mem_read -1
spider_max_connections 0
spider_max_order -1
spider_multi_split_read -1
spider_net_read_timeout -1
spider_net_write_timeout -1
spider_ping_interval_at_trx_start 3600
spider_quick_mode -1
spider_quick_page_size -1
spider_read_only_mode -1
spider_remote_access_charset
spider_remote_autocommit -1
spider_remote_default_database
spider_remote_sql_log_off -1
spider_remote_time_zone
spider_remote_trx_isolation -1
spider_reset_sql_alloc -1
spider_same_server_link OFF
spider_second_read -1
spider_select_column_mode -1
spider_selupd_lock_mode -1
spider_semi_split_read -1
spider_semi_split_read_limit -1
spider_semi_table_lock 1
spider_semi_table_lock_connection -1
spider_semi_trx ON
spider_semi_trx_isolation -1
spider_skip_default_condition -1
spider_skip_parallel_search -1
spider_split_read -1
spider_store_last_crd -1
spider_store_last_sts -1
spider_sts_bg_mode -1
spider_sts_interval -1
spider_sts_mode -1
spider_sts_sync -1
spider_support_xa ON
spider_sync_autocommit ON
spider_sync_trx_isolation ON
spider_table_crd_thread_count 10
spider_table_init_error_interval 1
spider_table_sts_thread_count 10
spider_udf_ct_bulk_insert_interval -1
spider_udf_ct_bulk_insert_rows -1
spider_udf_ds_bulk_insert_rows -1
spider_udf_ds_table_loop_mode -1
spider_udf_ds_use_real_table -1
spider_udf_table_lock_mutex_count 20
spider_udf_table_mon_mutex_count 20
spider_use_all_conns_snapshot OFF
spider_use_consistent_snapshot OFF
spider_use_default_database ON
spider_use_flash_logs OFF
spider_use_handler -1
spider_use_pushdown_udf -1
spider_use_snapshot_with_flush_tables 0
spider_use_table_charset -1
spider_version 3.3.13
spider_xa_register_mode 1
mariadb temporal-tables spider
asked 5 mins ago
Toby ChenToby Chen
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
enter code hereHi,
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
Variable_name Value
spider_auto_increment_mode -1
spider_bgs_first_read -1
spider_bgs_mode -1
spider_bgs_second_read -1
spider_bka_engine
spider_bka_mode -1
spider_bka_table_name_type -1
spider_block_size 16384
spider_bulk_size -1
spider_bulk_update_mode -1
spider_bulk_update_size -1
spider_casual_read -1
spider_conn_recycle_mode 0
spider_conn_recycle_strict 0
spider_conn_wait_timeout 10
spider_connect_error_interval 1
spider_connect_mutex OFF
spider_connect_retry_count 1000
spider_connect_retry_interval 1000
spider_connect_timeout -1
spider_crd_bg_mode -1
spider_crd_interval -1
spider_crd_mode -1
spider_crd_sync -1
spider_crd_type -1
spider_crd_weight -1
spider_delete_all_rows_type -1
spider_direct_dup_insert -1
spider_direct_order_limit -1
spider_dry_access OFF
spider_error_read_mode -1
spider_error_write_mode -1
spider_first_read -1
spider_force_commit 1
spider_general_log OFF
spider_index_hint_pushdown OFF
spider_init_sql_alloc_size -1
spider_internal_limit -1
spider_internal_offset -1
spider_internal_optimize -1
spider_internal_optimize_local -1
spider_internal_sql_log_off -1
spider_internal_unlock OFF
spider_internal_xa OFF
spider_internal_xa_id_type 0
spider_internal_xa_snapshot 0
spider_load_crd_at_startup -1
spider_load_sts_at_startup -1
spider_local_lock_table OFF
spider_lock_exchange OFF
spider_log_result_error_with_sql 0
spider_log_result_errors 0
spider_low_mem_read -1
spider_max_connections 0
spider_max_order -1
spider_multi_split_read -1
spider_net_read_timeout -1
spider_net_write_timeout -1
spider_ping_interval_at_trx_start 3600
spider_quick_mode -1
spider_quick_page_size -1
spider_read_only_mode -1
spider_remote_access_charset
spider_remote_autocommit -1
spider_remote_default_database
spider_remote_sql_log_off -1
spider_remote_time_zone
spider_remote_trx_isolation -1
spider_reset_sql_alloc -1
spider_same_server_link OFF
spider_second_read -1
spider_select_column_mode -1
spider_selupd_lock_mode -1
spider_semi_split_read -1
spider_semi_split_read_limit -1
spider_semi_table_lock 1
spider_semi_table_lock_connection -1
spider_semi_trx ON
spider_semi_trx_isolation -1
spider_skip_default_condition -1
spider_skip_parallel_search -1
spider_split_read -1
spider_store_last_crd -1
spider_store_last_sts -1
spider_sts_bg_mode -1
spider_sts_interval -1
spider_sts_mode -1
spider_sts_sync -1
spider_support_xa ON
spider_sync_autocommit ON
spider_sync_trx_isolation ON
spider_table_crd_thread_count 10
spider_table_init_error_interval 1
spider_table_sts_thread_count 10
spider_udf_ct_bulk_insert_interval -1
spider_udf_ct_bulk_insert_rows -1
spider_udf_ds_bulk_insert_rows -1
spider_udf_ds_table_loop_mode -1
spider_udf_ds_use_real_table -1
spider_udf_table_lock_mutex_count 20
spider_udf_table_mon_mutex_count 20
spider_use_all_conns_snapshot OFF
spider_use_consistent_snapshot OFF
spider_use_default_database ON
spider_use_flash_logs OFF
spider_use_handler -1
spider_use_pushdown_udf -1
spider_use_snapshot_with_flush_tables 0
spider_use_table_charset -1
spider_version 3.3.13
spider_xa_register_mode 1
mariadb temporal-tables spider
asked 5 mins ago
Toby ChenToby Chen
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
enter code hereHi,
I am trying a spider Engine in mariadb. The version mariadb-10.1.12-linux-x86_64 this UDF can work, but There has some issues I want to upgrades to newer version. However, mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 those udf spider_bg_direct_sql can not find TEMPORARY table event if I can select that temporary table in a database.
Is any one know how to solve it?
My spider setting:
Variable_name Value
spider_auto_increment_mode -1
spider_bgs_first_read -1
spider_bgs_mode -1
spider_bgs_second_read -1
spider_bka_engine
spider_bka_mode -1
spider_bka_table_name_type -1
spider_block_size 16384
spider_bulk_size -1
spider_bulk_update_mode -1
spider_bulk_update_size -1
spider_casual_read -1
spider_conn_recycle_mode 0
spider_conn_recycle_strict 0
spider_conn_wait_timeout 10
spider_connect_error_interval 1
spider_connect_mutex OFF
spider_connect_retry_count 1000
spider_connect_retry_interval 1000
spider_connect_timeout -1
spider_crd_bg_mode -1
spider_crd_interval -1
spider_crd_mode -1
spider_crd_sync -1
spider_crd_type -1
spider_crd_weight -1
spider_delete_all_rows_type -1
spider_direct_dup_insert -1
spider_direct_order_limit -1
spider_dry_access OFF
spider_error_read_mode -1
spider_error_write_mode -1
spider_first_read -1
spider_force_commit 1
spider_general_log OFF
spider_index_hint_pushdown OFF
spider_init_sql_alloc_size -1
spider_internal_limit -1
spider_internal_offset -1
spider_internal_optimize -1
spider_internal_optimize_local -1
spider_internal_sql_log_off -1
spider_internal_unlock OFF
spider_internal_xa OFF
spider_internal_xa_id_type 0
spider_internal_xa_snapshot 0
spider_load_crd_at_startup -1
spider_load_sts_at_startup -1
spider_local_lock_table OFF
spider_lock_exchange OFF
spider_log_result_error_with_sql 0
spider_log_result_errors 0
spider_low_mem_read -1
spider_max_connections 0
spider_max_order -1
spider_multi_split_read -1
spider_net_read_timeout -1
spider_net_write_timeout -1
spider_ping_interval_at_trx_start 3600
spider_quick_mode -1
spider_quick_page_size -1
spider_read_only_mode -1
spider_remote_access_charset
spider_remote_autocommit -1
spider_remote_default_database
spider_remote_sql_log_off -1
spider_remote_time_zone
spider_remote_trx_isolation -1
spider_reset_sql_alloc -1
spider_same_server_link OFF
spider_second_read -1
spider_select_column_mode -1
spider_selupd_lock_mode -1
spider_semi_split_read -1
spider_semi_split_read_limit -1
spider_semi_table_lock 1
spider_semi_table_lock_connection -1
spider_semi_trx ON
spider_semi_trx_isolation -1
spider_skip_default_condition -1
spider_skip_parallel_search -1
spider_split_read -1
spider_store_last_crd -1
spider_store_last_sts -1
spider_sts_bg_mode -1
spider_sts_interval -1
spider_sts_mode -1
spider_sts_sync -1
spider_support_xa ON
spider_sync_autocommit ON
spider_sync_trx_isolation ON
spider_table_crd_thread_count 10
spider_table_init_error_interval 1
spider_table_sts_thread_count 10
spider_udf_ct_bulk_insert_interval -1
spider_udf_ct_bulk_insert_rows -1
spider_udf_ds_bulk_insert_rows -1
spider_udf_ds_table_loop_mode -1
spider_udf_ds_use_real_table -1
spider_udf_table_lock_mutex_count 20
spider_udf_table_mon_mutex_count 20
spider_use_all_conns_snapshot OFF
spider_use_consistent_snapshot OFF
spider_use_default_database ON
spider_use_flash_logs OFF
spider_use_handler -1
spider_use_pushdown_udf -1
spider_use_snapshot_with_flush_tables 0
spider_use_table_charset -1
spider_version 3.3.13
spider_xa_register_mode 1
mariadb temporal-tables spider
mariadb temporal-tables spider
asked 5 mins ago
Toby ChenToby Chen
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 mins ago
Toby ChenToby Chen
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 mins ago
Toby ChenToby Chen
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 mins ago
Toby ChenToby Chen
1
asked 5 mins ago
Toby ChenToby Chen
1
1
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Toby Chen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Toby Chen is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f227929%2fmariadb-spider-engine-udf-spider-bg-direct-sql-cant-find-temporary-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Toby Chen is a new contributor. Be nice, and check out our Code of Conduct.
Toby Chen is a new contributor. Be nice, and check out our Code of Conduct.
Toby Chen is a new contributor. Be nice, and check out our Code of Conduct.
Toby Chen is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f227929%2fmariadb-spider-engine-udf-spider-bg-direct-sql-cant-find-temporary-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
