Hi, Solved my problem.
A little while ago JIRA Trafodion-1729 (pull request 258) was merged in (well, I think I was the one who committed it actually). I think I picked up this change when I updated my instance today. That code assumes the existence of a file $MY_SQROOT/etc/traf_coprocessor.properties. My instance lacked this file. I will guess that it is created at install time. The traf_coprocessor.properties file exists in $MY_SQROOT/sql/scripts/traf_coprocessor.properties, and is copied to $MY_SQROOT/etc by the sqgen script. Since I ran sqgen before I had this change, that explains why I lacked that file. I manually copied this file, and now initialize trafodion works for me. So, if you run into this issue, you can do the same (a manual copy), or just re-run sqgen. Dave -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Tuesday, February 9, 2016 12:45 PM To: '[email protected]' <[email protected]> Subject: RE: initialize trafodion after upgrade Spoke too soon. I still get this: [birdsall@edev03 ustat]$ sqlci Apache Trafodion Conversational Interface 2.0.0 Copyright (c) 2015 Apache Software Foundation >>initialize trafodion; *** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::create() returned error HBASE_CREATE_ERROR(701). Cause: java.lang.NullPointerException java.lang.String.contains(String.java:2076) org.trafodion.sql.CoprocessorUtils.addCoprocessor(CoprocessorUtils.java:76) org.trafodion.sql.HBaseClient.createk(HBaseClient.java:490) . --- SQL operation failed with errors. >> -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Tuesday, February 9, 2016 12:43 PM To: '[email protected]' <[email protected]> Subject: RE: initialize trafodion after upgrade Hi, I found a script, "update_hbase", in the sql/scripts directory. Tried running that. No luck. Anu suggested to me that I delete what was under the "hdfs:" subdirectory in the local_hadoop directory. No luck either. Finally went for the gold and did swuninstall_local_hadoop followed by install_local_hadoop. That worked. Thanks to all who helped. Dave -----Original Message----- From: Roberta Marton [mailto:[email protected]] Sent: Tuesday, February 9, 2016 12:17 PM To: [email protected] Subject: RE: initialize trafodion after upgrade I had the same issue yesterday but was not sure if it was my problem (I am fixing some data corruption issues). Anyway, I ended up uninstalling and reinstalling the Hadoop eco-system to get things to work again. Also rebuilt everything. Hopefully, there is a better solution. Roberta -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Tuesday, February 9, 2016 12:03 PM To: [email protected] Subject: initialize trafodion after upgrade Hi, This morning I brought an existing development instance up-to-date (did the git fetch –all, and created a new branch, did an sqstop, make clean, make all). When I brought the instance back up, it complained that I needed to do an initialize trafodion, drop + an initialize trafodion. I did the initialize trafodion, drop without problems. But the initialize trafodion fails as follows: Apache Trafodion Conversational Interface 2.0.0 Copyright (c) 2015 Apache Software Foundation >>initialize trafodion; *** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::create() returned error HBASE_CREATE_ERROR(701). Cause: java.lang.NullPointerException java.lang.String.contains(String.java:2076) org.trafodion.sql.CoprocessorUtils.addCoprocessor(CoprocessorUtils.java:76) org.trafodion.sql.HBaseClient.createk(HBaseClient.java:490) . --- SQL operation failed with errors. >>exit; So, I’m guessing the coprocessor jars need to be brought up-to-date. Is there a convenient script to do this? Or must I bite the bullet and do a swuninstall + install_local_hadoop? Thanks, Dave
