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
DBD Deployment error
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: DBD Deployment error
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.