MariaDB Spider Engine UDF spider_bg_direct_sql can't find TEMPORARY table












0















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?



enter image description here



enter image description here



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?



enter image description here



enter image description here



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









share







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.

























    0















    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?



    enter image description here



    enter image description here



    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?



    enter image description here



    enter image description here



    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









    share







    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.























      0












      0








      0








      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?



      enter image description here



      enter image description here



      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?



      enter image description here



      enter image description here



      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









      share







      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?



      enter image description here



      enter image description here



      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?



      enter image description here



      enter image description here



      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





      share







      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.










      share







      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.








      share



      share






      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




      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.






















          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.










          draft saved

          draft discarded


















          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.










          draft saved

          draft discarded


















          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          Liste der Baudenkmale in Friedland (Mecklenburg)

          Single-Malt-Whisky

          Czorneboh