QPROF: Incorrect copy of tables table

[yakirgb]

Hi,
Using version 1.0.1-1—01152024-a06640a3cc5a69a826c00f030c49fd89905827b8,
Running:

qprof = QueryProfiler( 
"SELECT ...",
    target_schema='v_temp_schema',
    key_id='yakir_1',
    overwrite=True
    )

But there is incorrect on copy of last tables like qprof_storage_containers_yakir_1:

[/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693](https://file+.vscode-resource.vscode-cdn.net/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693): UserWarning: NOTICE 4788: Statement is being profiled
HINT: Select * from v_monitor.execution_engine_profiles where transaction_id=67553994455538757 and statement_id=3;
  warnings.warn(notice)
[/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693](https://file+.vscode-resource.vscode-cdn.net/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693): UserWarning: NOTICE 3557: Initiator memory for query: [on pool sysquery: 3061094 KB, minimum: 3061094 KB]
  warnings.warn(notice)
[/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693](https://file+.vscode-resource.vscode-cdn.net/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693): UserWarning: NOTICE 5077: Total memory required by query: [15374342 KB]
  warnings.warn(notice)
Searching the performance tables...
100%
21/21 [02:05<00:00, 3.52s/it]
Copy of v_internal.dc_requests_issued created in v_temp_schema.qprof_dc_requests_issued_yakir_1
[/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693](https://file+.vscode-resource.vscode-cdn.net/usr/local/lib/python3.9/site-packages/vertica_python/vertica/connection.py:693): UserWarning: NOTICE 4185: Nothing was dropped
  warnings.warn(notice)
Copy of v_internal.dc_query_executions created in v_temp_schema.qprof_dc_query_executions_yakir_1
Copy of v_internal.dc_explain_plans created in v_temp_schema.qprof_dc_explain_plans_yakir_1
Copy of v_monitor.execution_engine_profiles created in v_temp_schema.qprof_execution_engine_profiles_yakir_1
Copy of v_monitor.query_events created in v_temp_schema.qprof_query_events_yakir_1
Copy of v_monitor.query_plan_profiles created in v_temp_schema.qprof_query_plan_profiles_yakir_1
Copy of v_monitor.query_profiles created in v_temp_schema.qprof_query_profiles_yakir_1
Copy of v_monitor.resource_pool_status created in v_temp_schema.qprof_resource_pool_status_yakir_1
Copy of v_monitor.host_resources created in v_temp_schema.qprof_host_resources_yakir_1
Copy of v_internal.dc_plan_activities created in v_temp_schema.qprof_dc_plan_activities_yakir_1
Copy of v_internal.dc_lock_attempts created in v_temp_schema.qprof_dc_lock_attempts_yakir_1
Copy of v_internal.dc_plan_resources created in v_temp_schema.qprof_dc_plan_resources_yakir_1
Copy of v_monitor.configuration_parameters created in v_temp_schema.qprof_configuration_parameters_yakir_1
Copy of v_monitor.projection_storage created in v_temp_schema.qprof_projection_storage_yakir_1
Copy of v_monitor.projection_usage created in v_temp_schema.qprof_projection_usage_yakir_1
Copy of v_monitor.query_consumption created in v_temp_schema.qprof_query_consumption_yakir_1
Copy of v_monitor.resource_acquisitions created in v_temp_schema.qprof_resource_acquisitions_yakir_1
Copy of v_monitor.storage_containers created in v_temp_schema.qprof_storage_containers_yakir_1
Copy of v_catalog.projections created in v_temp_schema.qprof_storage_containers_yakir_1
Copy of v_catalog.projection_columns created in v_temp_schema.qprof_storage_containers_yakir_1
Copy of v_catalog.resource_pools created in v_temp_schema.qprof_storage_containers_yakir_1
[/Users/yakir.g/git/VerticaPy/verticapy/performance/vertica/qprof.py:1298](https://file+.vscode-resource.vscode-cdn.net/Users/yakir.g/git/VerticaPy/verticapy/performance/vertica/qprof.py:1298): Warning: An error occurs during the creation of the relation v_temp_schema.qprof_storage_containers_yakir_1.
Tips: To overwrite the tables, set the parameter overwrite=True.
You can also set create_table=False to skip the table creation and to use the existing ones.

Error Details:
Severity: ERROR, Message: Syntax error at or near "EOL", Sqlstate: 42601, Position: 7, Routine: base_yyerror, File: [/data/jenkins/workspace/RE-DevBuilds/RE-Build-Dev-Pipeline/server/vertica/Parser/scan.l](https://file+.vscode-resource.vscode-cdn.net/data/jenkins/workspace/RE-DevBuilds/RE-Build-Dev-Pipeline/server/vertica/Parser/scan.l), Line: 1058, Error Code: 4856, SQL: 'CREATE'
  warnings.warn(warning_message, Warning)
[/Users/yakir.g/git/VerticaPy/verticapy/performance/vertica/qprof.py:1372](https://file+.vscode-resource.vscode-cdn.net/Users/yakir.g/git/VerticaPy/verticapy/performance/vertica/qprof.py:1372): Warning: 
Some transactions are missing:

(67553994455538757, 3) -> v_temp_schema.qprof_dc_plan_resources_yakir_1
(67553994455538757, 3) -> v_temp_schema.qprof_projection_usage_yakir_1
This could potentially lead to incorrect computations or errors. Please review the various tables and investigate why this data was modified or is missing. It may have been wrongly imported, accidentally deleted or automatically removed, especially if you are directly working on the performance tables.
  warnings.warn(warning_message, Warning)

Thank you ,
Yakir Gibraltar
Taboola

[oualib]

@yakirgb it should be good for now. Can you please try the latest version?

[yakirgb]

Hi @oualib , tested, looks good.
You can close this bug.
Thank you.