Options
DB Designer failing to deploy projections
Hi,
I created table in my vertica cluster, loaded it with data, created queries file with the list of queries we are using in our application and started DB designer (Comprehencive, optimized for queries). Designer finished but not deployed projections. See output below:
Database Designer started.
For large databases a design session could take a long time; allow it to complete uninterrupted.
Use Ctrl+C if you must cancel the session.
Setting up design session...
Examining table data...
Loading queries from '/home/ec2-user/q'.
Processed 7 SQL statement(s), all accepted and considered in the design.
No existing projections found.
Creating design and deploying projections...
[100%] Analyzing data statistics... Completed of .
[100%] Optimizing query performance... Completed of .
[100%] Design in progress... Completed of .
[100%] Optimizing storage footprint... Completed of .
Query optimization results...ent script...
Query 1 optimization ratio or status is 1
Query 2 optimization ratio or status is 1
Query 3 optimization ratio or status is 1
Query 4 optimization ratio or status is 1
Query 5 optimization ratio or status is 1
Query 6 optimization ratio or status is 1
Query 7 optimization ratio or status is FULLY OPTIMIZED BY EXISTING PROJECTIONS
Deploying and generating deployment script...
[ 0%] Deploying/Dropping projections... Completed 0 of 9 projections.
Completed 0 of 9 projections.
WARNING: Count mismatch. Some tables/projections could have been dropped by user before deployment or while deploying
Design script is located in /home/ec2-user/designer/admp_design.sql
Deployment script is located in /home/ec2-user/designer/admp_deploy.sql
Database Designer finished.
Press <Enter> to return to the Administration Tools menu.
What should I do now in order to make projections deployed. Why this is happenning ?
0
Comments
Hi
Normally this kind of issue occurs if you run any ddll,dml commands in between the database designer run.So will suggest you to kindly re-run DBD once again & make sure no other task should be performed in between.
Let me know if still faces any issues after re-running the same.
Regards
Rahul
Hi,
I tried the same on fresh install of the cluster with the same data and still have same error:
Hi
Can kindly provide the output of below query:
=> Select design_phase,event_time,phase_complete_percent,phase_step from design_status order by event_time desc;
Also I would suggest you drop dbd workspace & re-run it again:
=> dbd_drop_all_workspaces('<DESIGNER>');
Also please keep the system idle and don't run anything while performing this operation.
Regards
Rahul
I can not provide info as I already killed that cluster. Therefore I found the cause of the issue: not enough space on data volume.
That was not a very intuitive error messege
hehehehehe