Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

DROP TABLE trigger continuously - How to identify ?

Hello Everyone

From Vertica end, I see following DROP_TABLE being trigger continuously. From the statment my guess is tableau might be making temporary tables which is DROP TABLE statement. Please correct me if my understanding is wrong ? But my main concern here since query is getting TRIGGER continusouly and because of this CPU usage has bome high. I wonder how can i do the exact finding for this and solve this ASAP other wise this might impact to ETL job as well due to slow performance. Please help how am i gonna stop the below mentioned query which i am getting continuously. PLEASE HELP.

 

user_name |  transaction_id   | S_ID |                            query                            | MemoyInGB | RD_MS |         start_timestamp

-----------+-------------------+------+-------------------------------------------------------------+-----------+-------+----------------------------------

prodbi   | 54043195541574153 |    1 | DROP TABLE "_tableau_0_vertica_srv3_12869_0x1cc2b2_1_connec |           |    14 | 2016-08-25 11:05:23.207804+05:45

prodbi   | 58546795179695979 |    1 | DROP TABLE "_tableau_0_vertica_srv4_9695_0x1cfee6_1_connect |           |    21 | 2016-08-25 11:05:20.584767+05:45

prodbi   | 58546795179695900 |    1 | DROP TABLE "_tableau_0_vertica_srv4_9695_0x1cfea4_1_connect |           |    10 | 2016-08-25 11:01:43.714954+05:45

prodbi   | 45035996303476306 |    1 | DROP TABLE "_tableau_0_vertica_srv1_6454_0x1c93e4_1_connect |           |     7 | 2016-08-25 10:59:35.907801+05:45

prodbi   | 54043195541574037 |    1 | DROP TABLE "_tableau_0_vertica_srv3_12869_0x1cc252_1_connec |           |    17 | 2016-08-25 10:59:18.727299+05:45

prodbi   | 45035996303476282 |    1 | DROP TABLE "_tableau_0_vertica_srv1_6454_0x1c93dc_1_connect |           |    60 |

 VERTICA LOG OUTPUT :- (THIS IS NOON TIME LATEST OUTPUT)

2016-08-25 14:31:43.541 Init Session:0x7f1fdc012a70-a0000001c6595a [Txn] <INFO> Begin Txn: a0000001c6595a 'DROP TABLE "_t
ableau_0_vertica_srv1_6454_0x1cca79_1_connect" CASCADE'
2016-08-25 14:31:43.558 Init Session:0x7f1fdc012a70-a0000001c6595a [Txn] <INFO> Starting Commit: Txn: a0000001c6595a 'DRO
P TABLE "_tableau_0_vertica_srv1_6454_0x1cca79_1_connect" CASCADE'
2016-08-25 14:35:56.383 DistCall Dispatch:0x7f1fbc00ee50-e000000106c6d0 [Txn] <INFO> Starting Commit: Txn: e000000106c6d0
 'DROP TABLE "_tableau_0_vertica_srv5_13596_0x2423ea_1_connect" CASCADE'
2016-08-25 14:37:04.211 Init Session:0x7f1fdc03e030 [Session] <INFO> [PQuery] TX:0(vertica-srv1-6454:0x1ccbb0) DROP TABLE
 "_tableau_0_vertica_srv1_6454_0x1ccbb0_1_connect" CASCADE
2016-08-25 14:37:04.212 Init Session:0x7f1fdc03e030 [Session] <INFO> [PQuery] TX:0(vertica-srv1-6454:0x1ccbb0) DROP TABLE
 "_tableau_0_vertica_srv1_6454_0x1ccbb0_1_connect" CASCADE
2016-08-25 14:37:04.213 Init Session:0x7f1fdc03e030 [Session] <INFO> [Query] TX:0(vertica-srv1-6454:0x1ccbb0) DROP TABLE
"_tableau_0_vertica_srv1_6454_0x1ccbb0_1_connect" CASCADE
2016-08-25 14:37:04.250 Init Session:0x7f1fdc03e030-a0000001c65a15 [Txn] <INFO> Begin Txn: a0000001c65a15 'DROP TABLE "_t
ableau_0_vertica_srv1_6454_0x1ccbb0_1_connect" CASCADE'
2016-08-25 14:37:04.264 Init Session:0x7f1fdc03e030-a0000001c65a15 [Txn] <INFO> Starting Commit: Txn: a0000001c65a15 'DRO
P TABLE "_tableau_0_vertica_srv1_6454_0x1ccbb0_1_connect" CASCADE'
2016-08-25 14:38:56.541 DistCall Dispatch:0x7f1fbc002a60-d00000016c8564 [Txn] <INFO> Starting Commit: Txn: d00000016c8564
 'DROP TABLE "_tableau_0_vertica_srv4_9695_0x1d3421_1_connect" CASCADE'
2016-08-25 14:41:42.664 DistCall Dispatch:0x7f1fbc01d0d0-d00000016c85ff [Txn] <INFO> Starting Commit: Txn: d00000016c85ff
 'DROP TABLE "_tableau_0_vertica_srv4_9695_0x1d379f_1_connect" CASCADE'
2016-08-25 14:42:29.596 DistCall Dispatch:0x7f1fbc00d750-e000000106c77f [Txn] <INFO> Starting Commit: Txn: e000000106c77f
 'DROP TABLE "_tableau_0_vertica_srv5_13596_0x242453_1_connect" CASCADE'
2016-08-25 14:42:38.048 DistCall Dispatch:0x7f1fbc013800-e000000106c78d [Txn] <INFO> Starting Commit: Txn: e000000106c78d
 'DROP TABLE "_tableau_0_vertica_srv5_13596_0x242419_1_connect" CASCADE'

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.