RE: fixing/checking corrupted metadata?

2016-02-02 Thread Sean Broeder
+1 *From:* Roberta Marton [mailto:roberta.mar...@esgyn.com] *Sent:* Tuesday, February 2, 2016 4:06 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? May want to add this to our knowledgeware as an FAQ. Roberta *From:* Eric Owhadi

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Roberta Marton
May want to add this to our knowledgeware as an FAQ. Roberta *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 4:00 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? Awesome, bookmarked J. And yes it

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Eric Owhadi
Awesome, bookmarked J. And yes it solved the problem. Thanks all for the precious help, Eric *From:* Suresh Subbiah [mailto:suresh.subbia...@gmail.com] *Sent:* Tuesday, February 2, 2016 5:09 PM *To:* user@trafodion.incubator.apache.org *Subject:* Re: fixing/checking corrupted metadata? Here

Re: fixing/checking corrupted metadata?

2016-02-02 Thread Suresh Subbiah
look promising? > > Eric > > > > > > *From:* Anoop Sharma [mailto:anoop.sha...@esgyn.com] > *Sent:* Tuesday, February 2, 2016 4:54 PM > > *To:* user@trafodion.incubator.apache.org > *Subject:* RE: fixing/checking corrupted metadata? > > > > Dave mentioned

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Eric Owhadi
[mailto:anoop.sha...@esgyn.com] *Sent:* Tuesday, February 2, 2016 4:54 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? Dave mentioned ‘cleanup table customer’. You can use that if you know which table is messed up in metadata. Or one can use: cleanup

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Roberta Marton
Cleanup works good for me. Roberta *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:43 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? Only do that if you’re willing to get rid of your entire

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Anoop Sharma
documented in trafodion documentation which is a good place to check. anoop *From:* Sean Broeder [mailto:sean.broe...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:49 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? Right. I mentioned this only

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Sean Broeder
@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? Only do that if you’re willing to get rid of your entire database. *From:* Sean Broeder [mailto:sean.broe...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:41 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Dave Birdsall
Only do that if you’re willing to get rid of your entire database. *From:* Sean Broeder [mailto:sean.broe...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:41 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? You might want to try sqlci

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Sean Broeder
You might want to try sqlci initialize trafodion, drop; initialize trafodion; *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:36 PM *To:* user@trafodion.incubator.apache.org *Subject:* fixing/checking corrupted metadata? I have been playing on my

RE: fixing/checking corrupted metadata?

2016-02-02 Thread Dave Birdsall
do “cleanup table customer”. Actually, you can do this without cleaning up the hung transactions. Those can just stay there. Dave *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:36 PM *To:* user@trafodion.incubator.apache.org *Subject:* fixing/checking

fixing/checking corrupted metadata?

2016-02-02 Thread Eric Owhadi
I have been playing on my dev environment with this DDL: create table Customer ( c_customer_sk int not null, c_customer_id char(16) CHARACTER SET UTF8 not null, c_current_cdemo_sk int, c_current_hdemo_sk int, c_current_addr_sk int,