session closing abnormally

Moderator: NorbertKrupa

Post Reply
bhupal
Newbie
Newbie
Posts: 11
Joined: Wed Apr 03, 2013 9:30 am

session closing abnormally

Post by bhupal » Tue Apr 23, 2013 12:17 pm

hi all,

oracle is my source and vertica is target. my source is having 30 millions of records. here i wrote sql query on 11 table in source qualifier of informatica. when i am loading data into the vertica session got closed by server after loading 370000 records, again i truncated the table and loaded the data into vertica , here also it got closed by the server after loading 370000 records. here session is running above 5 hours of time, some times running 6 hours after that its getting failed because of server closing the session. after that i tried with partition , it loaded 20 lakh records and got failed after 6 hours.( frequently its getting fail after runnig 5-6 hours).

i found that it getting fail because of server closing session. but i dont know why vertica server closing session after 5-6 hours run of session. is there any solution for this problem. can anybody help me why its getting close by server. and also how to improve the session performance when we have vertica as target.

the actual error i am getting in session log is
{server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.}

thanks in advance.

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: session closing abnormally

Post by nnani » Wed Apr 24, 2013 5:40 am

Hi Bhupal,

Maybe this post can help you.

http://www.vertica-forums.com/viewtopic ... meout#p712
nnani........
Long way to go

You can check out my blogs at vertica-howto

bhupal
Newbie
Newbie
Posts: 11
Joined: Wed Apr 03, 2013 9:30 am

Re: session closing abnormally

Post by bhupal » Wed Apr 24, 2013 6:34 am

thank you nnani.

ajay.pulavarti
Newbie
Newbie
Posts: 1
Joined: Tue Apr 23, 2013 10:59 pm

Re: session closing abnormally

Post by ajay.pulavarti » Wed Apr 24, 2013 4:16 pm

Hi
bhupal and nnani - I am new to vertica. can I contact you thru phone or email please? if so, can you please pass on those to me? Any help on this really helpful.

regards
Ajay

bhupal
Newbie
Newbie
Posts: 11
Joined: Wed Apr 03, 2013 9:30 am

Re: session closing abnormally

Post by bhupal » Thu Apr 25, 2013 5:13 am

Hi Ajay,

I am also new to vertica. it is better to together with nnani. still if u want to connect with me,u can reach by mail.

mail id: bhupalreddy200@gmail.com

Post Reply

Return to “New to Vertica”