This is an automated email from the ASF dual-hosted git repository.

hello-stephen pushed a commit to branch reduce-audit-log-roll-size
in repository https://gitbox.apache.org/repos/asf/doris.git

commit b6c7b8b64a1ed0b24646d08f0946c0adc1a0ae5b
Author: lidongyang <[email protected]>
AuthorDate: Thu Jul 2 10:55:03 2026 +0800

    Reduce audit log SQL length to 1/5 of defaults in pipeline session_variables
    
    Set audit_plugin_max_sql_length = 419430 (~410KB, was 2MB) and
    audit_plugin_max_insert_stmt_length = 429496729 (~410MB, was 
Integer.MAX_VALUE)
    in pipeline session_variables.sql files to reduce audit log size.
    
    The effective truncation length for INSERT statements is 
min(insert_stmt_length,
    sql_length) = 419430 (~410KB).
    
    Affected pipeline directories: cloud_p0, cloud_p1, vault_p0, performance
    
    Co-Authored-By: Claude <[email protected]>
---
 regression-test/pipeline/cloud_p0/conf/session_variables.sql    | 2 ++
 regression-test/pipeline/cloud_p1/conf/session_variables.sql    | 4 +++-
 regression-test/pipeline/performance/conf/session_variables.sql | 2 ++
 regression-test/pipeline/vault_p0/conf/session_variables.sql    | 2 ++
 4 files changed, 9 insertions(+), 1 deletion(-)

diff --git a/regression-test/pipeline/cloud_p0/conf/session_variables.sql 
b/regression-test/pipeline/cloud_p0/conf/session_variables.sql
index b2e30361957..d36f8cb2b7f 100644
--- a/regression-test/pipeline/cloud_p0/conf/session_variables.sql
+++ b/regression-test/pipeline/cloud_p0/conf/session_variables.sql
@@ -1 +1,3 @@
 -- set those session variables before run cloud p0 regression
+set global audit_plugin_max_sql_length = 419430;
+set global audit_plugin_max_insert_stmt_length = 429496729;
diff --git a/regression-test/pipeline/cloud_p1/conf/session_variables.sql 
b/regression-test/pipeline/cloud_p1/conf/session_variables.sql
index b38279c9b42..913c7978510 100644
--- a/regression-test/pipeline/cloud_p1/conf/session_variables.sql
+++ b/regression-test/pipeline/cloud_p1/conf/session_variables.sql
@@ -3,4 +3,6 @@ set global insert_visible_timeout_ms=60000;
 set global enable_auto_analyze=false;
 set global enable_audit_plugin=true;
 set global enable_memtable_on_sink_node=false;
-set global enable_pipeline_x_engine=false;
\ No newline at end of file
+set global enable_pipeline_x_engine=false;
+set global audit_plugin_max_sql_length = 419430;
+set global audit_plugin_max_insert_stmt_length = 429496729;
\ No newline at end of file
diff --git a/regression-test/pipeline/performance/conf/session_variables.sql 
b/regression-test/pipeline/performance/conf/session_variables.sql
index 89163ec48b1..562321ee4b7 100644
--- a/regression-test/pipeline/performance/conf/session_variables.sql
+++ b/regression-test/pipeline/performance/conf/session_variables.sql
@@ -1 +1,3 @@
 set global enable_sql_cache=false;
+set global audit_plugin_max_sql_length = 419430;
+set global audit_plugin_max_insert_stmt_length = 429496729;
diff --git a/regression-test/pipeline/vault_p0/conf/session_variables.sql 
b/regression-test/pipeline/vault_p0/conf/session_variables.sql
index b2e30361957..d36f8cb2b7f 100644
--- a/regression-test/pipeline/vault_p0/conf/session_variables.sql
+++ b/regression-test/pipeline/vault_p0/conf/session_variables.sql
@@ -1 +1,3 @@
 -- set those session variables before run cloud p0 regression
+set global audit_plugin_max_sql_length = 419430;
+set global audit_plugin_max_insert_stmt_length = 429496729;


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to