Since you're deploying onto a vendor's platform, I suggest asking this question on the vendor's forum.
Cheers On Wed, Oct 25, 2017 at 3:59 AM, Sumanta Gh <sumanta...@tcs.com> wrote: > Hi, > I am trying to install phoenix-4.12.0 (HBase-1.1) on HDP 2.6.2.0. As per > installation guide, I have copied the phoenix-4.12.0-HBase-1.1-server.jar > inside HBase lib directory. After restarting HBase using Ambari and > connecting through SqlLine, I can see phoenix system tables are getting > created. I used HBase shell to check them. > > When I try to create a table, the region servers stops with the following > error. Could anyone please guide what is wrong here. > > thanks > sumanta > > > > DDL : > > CREATE TABLE V5.USER ( > ADMIN BOOLEAN, > KEYA VARCHAR, > KEYB VARCHAR, > ID INTEGER, > USERNAME VARCHAR, > CONSTRAINT PK PRIMARY KEY (KEYA)) *COLUMN_ENCODED_BYTES=0*; > > > *Region Server Error:* > > 2017-10-25 10:47:12,499 ERROR [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > coprocessor.CoprocessorHost: The coprocessor > org.apache.phoenix.hbase.index.Indexer > threw org.apache.hadoop.metrics2.MetricsException: Metrics source > RegionServer,sub=PhoenixIndexer already exists! > org.apache.hadoop.metrics2.MetricsException: Metrics source > RegionServer,sub=PhoenixIndexer already exists! > at org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.newSourceName( > DefaultMetricsSystem.java:144) > at org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.sourceName( > DefaultMetricsSystem.java:117) > at org.apache.hadoop.metrics2.impl.MetricsSystemImpl. > register(MetricsSystemImpl.java:229) > at org.apache.hadoop.hbase.metrics.BaseSourceImpl.<init>( > BaseSourceImpl.java:74) > at org.apache.phoenix.hbase.index.metrics.MetricsIndexerSourceImpl.<init>( > MetricsIndexerSourceImpl.java:49) > at org.apache.phoenix.hbase.index.metrics.MetricsIndexerSourceImpl.<init>( > MetricsIndexerSourceImpl.java:44) > at org.apache.phoenix.hbase.index.metrics.MetricsIndexerSourceFactory. > create(MetricsIndexerSourceFactory.java:34) > at org.apache.phoenix.hbase.index.Indexer.start(Indexer.java:251) > at org.apache.hadoop.hbase.coprocessor.CoprocessorHost$ > Environment.startup(CoprocessorHost.java:415) > > .... > 2017-10-25 10:47:12,499 FATAL [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.HRegionServer: ABORTING region server > ip-172-30-3-197,16020,1508926506368: > The coprocessor org.apache.phoenix.hbase.index.Indexer threw > org.apache.hadoop.metrics2.MetricsException: Metrics source > RegionServer,sub=PhoenixIndexer already exists! > org.apache.hadoop.metrics2.MetricsException: Metrics source > RegionServer,sub=PhoenixIndexer already exists! > at org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.newSourceName( > DefaultMetricsSystem.java:144) > at org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.sourceName( > DefaultMetricsSystem.java:117) > at org.apache.hadoop.metrics2.impl.MetricsSystemImpl. > register(MetricsSystemImpl.java:229) > at org.apache.hadoop.hbase.metrics.BaseSourceImpl.<init>( > BaseSourceImpl.java:74) > at org.apache.phoenix.hbase.index.metrics.MetricsIndexerSourceImpl.<init>( > MetricsIndexerSourceImpl.java:49) > at org.apache.phoenix.hbase.index.metrics.MetricsIndexerSourceImpl.<init>( > MetricsIndexerSourceImpl.java:44) > at org.apache.phoenix.hbase.index.metrics.MetricsIndexerSourceFactory. > create(MetricsIndexerSourceFactory.java:34) > at org.apache.phoenix.hbase.index.Indexer.start(Indexer.java:251) > at org.apache.hadoop.hbase.coprocessor.CoprocessorHost$ > Environment.startup(CoprocessorHost > > .... > 2017-10-25 10:47:12,499 FATAL [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.HRegionServer: RegionServer abort: loaded coprocessors are: > [org.apache.phoenix.coprocessor.MetaDataEndpointImpl, org.apache.phoenix. > coprocessor.ScanRegionObserver, org.apache.phoenix.coprocessor. > UngroupedAggregateRegionObserver, org.apache.phoenix.hbase.index.Indexer, > org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver, > org.apache.phoenix.coprocessor.ServerCachingEndpointImpl, > org.apache.hadoop.hbase.security.access.SecureBulkLoadEndpoint, > org.apache.hadoop.hbase.coprocessor.MultiRowMutationEndpoint] > 2017- > > ..... > 2017-10-25 10:47:12,511 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.HRegionServer: STOPPED: The coprocessor > org.apache.phoenix.hbase.index.Indexer threw > org.apache.hadoop.metrics2.MetricsException: > Metrics source RegionServer,sub=PhoenixIndexer already exists! > 2017-10-25 10:47:12,511 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.SplitLogWorker: Sending interrupt to > stop the worker thread > 2017-10-25 10:47:12,511 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HRegionServer: Stopping infoServer > 2017-10-25 10:47:12,511 INFO [SplitLogWorker-ip-172-30-3-197:16020] > regionserver.SplitLogWorker: SplitLogWorker interrupted. Exiting. > 2017-10-25 10:47:12,511 INFO [SplitLogWorker-ip-172-30-3-197:16020] > regionserver.SplitLogWorker: SplitLogWorker > ip-172-30-3-197,16020,1508926506368 > exiting > 2017-10-25 10:47:12,512 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.RegionCoprocessorHost: Loaded coprocessor org.apache.phoenix. > coprocessor.GroupedAggregateRegionObserver from HTD of V5.SENSOR > successfully. > 2017-10-25 10:47:12,512 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.RegionCoprocessorHost: Loaded coprocessor org.apache.phoenix. > coprocessor.ServerCachingEndpointImpl from HTD of V5.SENSOR successfully. > 2017-10-25 10:47:12,512 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.RegionCoprocessorHost: Loaded coprocessor > org.apache.phoenix.coprocessor.ScanRegionObserver > from HTD of V5.SENSOR successfully. > 2017-10-25 10:47:12,512 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] mortbay.log: Stopped SelectChannelConnector@0.0.0.0 > :16030 > 2017-10-25 10:47:12,550 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.RegionCoprocessorHost: Loaded coprocessor org.apache.phoenix. > coprocessor.UngroupedAggregateRegionObserver from HTD of V5.SENSOR > successfully. > 2017-10-25 10:47:12,562 INFO [StoreOpener-82ad4872c3e5354540025192dfc8faab-1] > hfile.CacheConfig: blockCache=LruBlockCache{blockCount=3, > currentSize=441552, freeSize=420666576, maxSize=421108128, heapSize=441552, > minSize=400052704, minFactor=0.95, multiSize=200026352, multiFactor=0.5, > singleSize=100013176, singleFactor=0.25}, cacheDataOnRead=true, > cacheDataOnWrite=false, cacheIndexesOnWrite=false, > cacheBloomsOnWrite=false, cacheEvictOnClose=false, > cacheDataCompressed=false, prefetchOnOpen=false > 2017-10-25 10:47:12,563 INFO [StoreOpener-82ad4872c3e5354540025192dfc8faab-1] > compactions.CompactionConfiguration: size [134217728, > 9223372036854775807); files [3, 10); ratio 1.200000; off-peak ratio > 5.000000; throttle point 2684354560; major period 604800000, major jitter > 0.500000, min locality to compact 0.000000; tiered compaction: max_age > 9223372036854775807, base window in milliseconds 21600000, windows per tier > 4,incoming window min 6 > 2017-10-25 10:47:12,567 INFO [StoreOpener-82ad4872c3e5354540025192dfc8faab-1] > hfile.CacheConfig: blockCache=LruBlockCache{blockCount=3, > currentSize=441552, freeSize=420666576, maxSize=421108128, heapSize=441552, > minSize=400052704, minFactor=0.95, multiSize=200026352, multiFactor=0.5, > singleSize=100013176, singleFactor=0.25}, cacheDataOnRead=true, > cacheDataOnWrite=false, cacheIndexesOnWrite=false, > cacheBloomsOnWrite=false, cacheEvictOnClose=false, > cacheDataCompressed=false, prefetchOnOpen=false > 2017-10-25 10:47:12,568 INFO [StoreOpener-82ad4872c3e5354540025192dfc8faab-1] > compactions.CompactionConfiguration: size [134217728, > 9223372036854775807); files [3, 10); ratio 1.200000; off-peak ratio > 5.000000; throttle point 2684354560; major period 604800000, major jitter > 0.500000, min locality to compact 0.000000; tiered compaction: max_age > 9223372036854775807, base window in milliseconds 21600000, windows per tier > 4,incoming window min 6 > 2017-10-25 10:47:12,579 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.HRegion: Onlined 82ad4872c3e5354540025192dfc8faab; next > sequenceid=2 > 2017-10-25 10:47:12,583 INFO [StoreCloserThread-V5.SENSOR,,1508928431856. > 82ad4872c3e5354540025192dfc8faab.-1] regionserver.HStore: Closed 0 > 2017-10-25 10:47:12,583 INFO [StoreCloserThread-V5.SENSOR,,1508928431856. > 82ad4872c3e5354540025192dfc8faab.-1] regionserver.HStore: Closed A > 2017-10-25 10:47:12,595 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > regionserver.HRegion: Closed V5.SENSOR,,1508928431856. > 82ad4872c3e5354540025192dfc8faab. > 2017-10-25 10:47:12,595 INFO [RS_OPEN_REGION-ip-172-30-3-197:16020-1] > coordination.ZkOpenRegionCoordination: Opening of region {ENCODED => > 82ad4872c3e5354540025192dfc8faab, NAME => 'V5.SENSOR,,1508928431856. > 82ad4872c3e5354540025192dfc8faab.', STARTKEY => '', ENDKEY => ''} failed, > transitioning from OPENING to FAILED_OPEN in ZK, expecting version 1 > 2017-10-25 10:47:12,613 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HeapMemoryManager: Stoping > HeapMemoryTuner chore. > 2017-10-25 10:47:12,613 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] flush.RegionServerFlushTableProcedureManager: > Stopping region server flush procedure manager abruptly. > 2017-10-25 10:47:12,613 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] snapshot.RegionServerSnapshotManager: Stopping > RegionServerSnapshotManager abruptly. > 2017-10-25 10:47:12,614 INFO [MemStoreFlusher.0] > regionserver.MemStoreFlusher: MemStoreFlusher.0 exiting > 2017-10-25 10:47:12,614 INFO [MemStoreFlusher.1] > regionserver.MemStoreFlusher: MemStoreFlusher.1 exiting > 2017-10-25 10:47:12,622 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HRegionServer: aborting server > ip-172-30-3-197,16020,1508926506368 > 2017-10-25 10:47:12,643 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] client.ConnectionManager$HConnectionImplementation: > Closing zookeeper sessionid=0x15f530637b40009 > 2017-10-25 10:47:12,645 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] zookeeper.ZooKeeper: Session: 0x15f530637b40009 closed > 2017-10-25 10:47:12,645 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.CompactSplitThread: Waiting for Split > Thread to finish... > 2017-10-25 10:47:12,649 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.CompactSplitThread: Waiting for Merge > Thread to finish... > 2017-10-25 10:47:12,649 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.CompactSplitThread: Waiting for Large > Compaction Thread to finish... > 2017-10-25 10:47:12,649 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.CompactSplitThread: Waiting for Small > Compaction Thread to finish... > 2017-10-25 10:47:12,649 INFO [regionserver/ip-172-30-3- > 197/172.30.3.197:16020-EventThread] zookeeper.ClientCnxn: EventThread > shut down > 2017-10-25 10:47:12,651 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HRegionServer: Waiting on 4 regions to > close > 2017-10-25 10:47:12,668 INFO [StoreCloserThread-SYSTEM. > FUNCTION,,1508848466919.f16413f64ee499782448437db87576c6.-1] > regionserver.HStore: Closed 0 > 2017-10-25 10:47:12,669 INFO [RS_CLOSE_REGION-ip-172-30-3-197:16020-1] > regionserver.HRegion: Closed SYSTEM.FUNCTION,,1508848466919. > f16413f64ee499782448437db87576c6. > 2017-10-25 10:47:12,669 INFO [StoreCloserThread-hbase:meta,,1.1588230740-1] > regionserver.HStore: Closed info > 2017-10-25 10:47:12,669 ERROR [RS_CLOSE_META-ip-172-30-3-197:16020-0] > regionserver.HRegion: Memstore size is 264 > 2017-10-25 10:47:12,670 INFO [StoreCloserThread-SYSTEM. > MUTEX,,1508848451514.f73d5cf23255c18ec828d51c60be867f.-1] > regionserver.HStore: Closed 0 > 2017-10-25 10:47:12,671 INFO [RS_CLOSE_META-ip-172-30-3-197:16020-0] > regionserver.HRegion: Closed hbase:meta,,1.1588230740 > 2017-10-25 10:47:12,671 INFO [RS_CLOSE_REGION-ip-172-30-3-197:16020-0] > regionserver.HRegion: Closed SYSTEM.MUTEX,,1508848451514. > f73d5cf23255c18ec828d51c60be867f. > 2017-10-25 10:47:12,671 INFO [StoreCloserThread-hbase: > namespace,,1508845641564.b7e3abbc6449bd697260f250745f6a20.-1] > regionserver.HStore: Closed info > 2017-10-25 10:47:12,672 INFO [RS_CLOSE_REGION-ip-172-30-3-197:16020-2] > regionserver.HRegion: Closed hbase:namespace,,1508845641564. > b7e3abbc6449bd697260f250745f6a20. > 2017-10-25 10:47:12,852 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HRegionServer: stopping server > ip-172-30-3-197,16020,1508926506368; all regions closed. > 2017-10-25 10:47:12,879 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.Leases: regionserver/ip-172-30-3-197/1 > 72.30.3.197:16020 closing leases > 2017-10-25 10:47:12,879 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.Leases: regionserver/ip-172-30-3-197/1 > 72.30.3.197:16020 closed leases > 2017-10-25 10:47:12,879 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] hbase.ChoreService: Chore service for: > ip-172-30-3-197,16020,1508926506368 had [[ScheduledChore: Name: > MovedRegionsCleaner for region ip-172-30-3-197,16020,1508926506368 > Period: 120000 Unit: MILLISECONDS], [ScheduledChore: Name: > ip-172-30-3-197,16020,1508926506368-MemstoreFlusherChore Period: 10000 > Unit: MILLISECONDS]] on shutdown > 2017-10-25 10:47:14,998 INFO > [RS_OPEN_META-ip-172-30-3-197:16020-0-MetaLogRoller] > regionserver.LogRoller: LogRoller exiting. > 2017-10-25 10:47:17,550 INFO [HBase-Metrics2-1] impl.MetricsSystemImpl: > Stopping HBase metrics system... > 2017-10-25 10:47:17,551 INFO [HBase-Metrics2-1] impl.MetricsSystemImpl: > HBase metrics system stopped. > 2017-10-25 10:47:18,052 INFO [HBase-Metrics2-1] impl.MetricsConfig: > loaded properties from hadoop-metrics2-hbase.properties > 2017-10-25 10:47:18,053 INFO [HBase-Metrics2-1] impl.MetricsSystemImpl: > Scheduled snapshot period at 10 second(s). > 2017-10-25 10:47:18,053 INFO [HBase-Metrics2-1] impl.MetricsSystemImpl: > HBase metrics system started > 2017-10-25 10:47:19,396 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020.logRoller] regionserver.LogRoller: LogRoller exiting. > 2017-10-25 10:47:19,396 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020.leaseChecker] regionserver.Leases: > regionserver/ip-172-30-3-197/172.30.3.197:16020.leaseChecker closing > leases > 2017-10-25 10:47:19,397 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020.leaseChecker] regionserver.Leases: > regionserver/ip-172-30-3-197/172.30.3.197:16020.leaseChecker closed leases > 2017-10-25 10:47:19,403 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] ipc.RpcServer: Stopping server on 16020 > 2017-10-25 10:47:19,403 INFO [RpcServer.listener,port=16020] > ipc.RpcServer: RpcServer.listener,port=16020: stopping > 2017-10-25 10:47:19,404 INFO [RpcServer.responder] ipc.RpcServer: > RpcServer.responder: stopped > 2017-10-25 10:47:19,404 INFO [RpcServer.responder] ipc.RpcServer: > RpcServer.responder: stopping > 2017-10-25 10:47:19,411 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] zookeeper.ZooKeeper: Session: 0x15f530637b40008 closed > 2017-10-25 10:47:19,411 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HRegionServer: stopping server > ip-172-30-3-197,16020,1508926506368; zookeeper connection closed. > 2017-10-25 10:47:19,411 INFO [regionserver/ip-172-30-3-197/ > 172.30.3.197:16020] regionserver.HRegionServer: > regionserver/ip-172-30-3-197/172.30.3.197:16020 exiting > 2017-10-25 10:47:19,411 ERROR [main] regionserver.HRegionServerCommandLine: > Region server exiting > java.lang.RuntimeException: HRegionServer Aborted > at org.apache.hadoop.hbase.regionserver.HRegionServerCommandLine.start( > HRegionServerCommandLine.java:68) > at org.apache.hadoop.hbase.regionserver.HRegionServerCommandLine.run( > HRegionServerCommandLine.java:87) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) > at org.apache.hadoop.hbase.util.ServerCommandLine.doMain( > ServerCommandLine.java:126) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > main(HRegionServer.java:2816) > 2017-10-25 10:47:19,411 INFO [main-EventThread] zookeeper.ClientCnxn: > EventThread shut down > 2017-10-25 10:47:19,415 INFO [pool-4-thread-1] regionserver.ShutdownHook: > Shutdown hook starting; hbase.shutdown.hook=true; fsShutdownHook=org.apache. > hadoop.fs.FileSystem$Cache$ClientFinalizer@6ea1bcdc > 2017-10-25 10:47:19,415 INFO [pool-4-thread-1] regionserver.ShutdownHook: > Starting fs shutdown hook thread. > 2017-10-25 10:47:19,416 INFO [pool-4-thread-1] regionserver.ShutdownHook: > Shutdown hook finished. > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > >