DBD Deployment error

Moderator: NorbertKrupa

Post Reply
Simo_Bond
Newbie
Newbie
Posts: 3
Joined: Mon Jul 28, 2014 5:01 pm

DBD Deployment error

Post by Simo_Bond » Mon Sep 08, 2014 3:51 pm

Hi,
in both the automatic and manual case, when I try to deploy a database design, after building phase has been done successfully, it fails.
Here I leave an extract (the output from "SELECT * FROM V_MONITOR.DEPLOY_STATUS;" ):

vmartdb=> SELECT * FROM V_MONITOR.DEPLOY_STATUS;
event_time | user_name | deploy_name | deploy_step | deploy_step_status | deploy_step_complete_percent | deploy_complete_percent | error_message
---------------------+-----------+-------------+----------------------------+--------------------+------------------------------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2014-09-08 10:01:55 | dbadmin | test3 | create_deployment | success | | | N/A
2014-09-08 10:01:55 | dbadmin | test3 | populate_deployment | started | | | N/A
2014-09-08 10:01:59 | dbadmin | test3 | populate_deployment | success | | | N/A
2014-09-08 10:01:59 | dbadmin | test3 | deployment_script | started | | | N/A
2014-09-08 10:02:00 | dbadmin | test3 | run_deployment | success | | | N/A
2014-09-08 10:02:00 | dbadmin | test3 | deployment_script | success | | | N/A
2014-09-08 10:02:00 | dbadmin | test3 | deployment | completed | | | N/A
2014-09-08 10:04:59 | dbadmin | test3 | run_deployment | success | | | N/A
2014-09-08 10:23:52 | dbadmin | test3 | run_deployment | success | | | N/A
2014-09-08 10:23:58 | dbadmin | test3 | run_deployment | error | | | Error during projection creation: Unavailable: [Txn 0xa00000000b1fb0] S lock table - timeout error Timed out S locking Table:public.test2. I held by [user dbadmin (SELECT * FROM Test2;)]. Your current transaction isolation level is SERIALIZABLE
2014-09-08 10:24:34 | dbadmin | test3 | run_deployment | error | | | Projection test_DBD_1_rep_test3 to be refreshed was dropped
2014-09-08 10:25:41 | dbadmin | test3 | run_deployment | error | | | Projection test_DBD_1_rep_test3 to be refreshed was dropped
2014-09-08 10:28:22 | dbadmin | test3 | add: test_DBD_1_rep_test3 | | | 200 | N/A
2014-09-08 10:28:22 | dbadmin | test3 | add: test_DBD_1_rep_test3 | | | 200 | N/A
2014-09-08 10:28:22 | dbadmin | test3 | add: test2_DBD_2_rep_test3 | error | 100 | 200 | Unavailable: [Txn 0xa00000000b2165] S lock table - timeout error Timed out S locking Table:public.test2. I held by [user dbadmin (SELECT * FROM Test2;)]. Your current transaction isolation level is SERIALIZABLE
2014-09-08 10:28:22 | dbadmin | test3 | add: test2_DBD_2_rep_test3 | error | 100 | 200 | Unavailable: [Txn 0xa00000000b2165] S lock table - timeout error Timed out S locking Table:public.test2. I held by [user dbadmin (SELECT * FROM Test2;)]. Your current transaction isolation level is SERIALIZABLE
2014-09-08 10:28:23 | dbadmin | test3 | run_deployment | error | | | Error during projection creation: Unavailable: [Txn 0xa00000000b2165] S lock table - timeout error Timed out S locking Table:public.test2. I held by [user dbadmin (SELECT * FROM Test2;)]. Your current transaction isolation level is SERIALIZABLE
(17 rows)

What should I do? I'm new to Vertica and I haven't found this error on other threads.
Thanks in advance to all,
SB

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: DBD Deployment error

Post by NorbertKrupa » Mon Sep 08, 2014 4:34 pm

The error is pretty self explanatory. Make sure that there are no other sessions requesting data (SELECT * FROM Test2;) otherwise exclude projection creation on this table.
timeout error Timed out S locking Table:public.test2. I held by [user dbadmin (SELECT * FROM Test2;)].
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica”