phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pedro Gandola <pedro.gand...@gmail.com>
Subject Create new local index failed!
Date Tue, 19 Jan 2016 00:51:50 GMT
Hi,

I'm trying to create a new local index on *Phoenix4.4* over an existing
table containing ~2 billion rows. During the process I get a some warnings
and then after  ~1 hour I get an error from Phoenix.

My table has TTL defined and I'm assuming the warnings might be caused by
expired data.

*Warnings:*

16/01/18 23:36:43 WARN client.ScannerCallable: Ignore, probably already
> closed
> org.apache.hadoop.hbase.UnknownScannerException:
> org.apache.hadoop.hbase.UnknownScannerException: Name: 1856, already closed?
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2223)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at
> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)


Error:

Error: org.apache.phoenix.exception.PhoenixIOException: Failed after
> attempts=36, exceptions:
> Mon Jan 18 23:38:04 UTC 2016, null, java.net.SocketTimeoutException:
> callTimeout=60000, callDuration=1200304: row '' on table 'BIDDING_EVENTS'
> at region=BIDDING_EVENTS,,1452643348711.a4970d6e22f8c0accc39e9ec746a05fa.,
> hostname=ip-10-5-4-22.ec2.internal,16020,1452867025003, seqNum=11131841
> (state=08000,code=101)
> org.apache.phoenix.exception.PhoenixIOException:
> org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36,
> exceptions:
> Mon Jan 18 23:38:04 UTC 2016, null, java.net.SocketTimeoutException:
> callTimeout=60000, callDuration=1200304: row '' on table 'BIDDING_EVENTS'
> at region=BIDDING_EVENTS,,1452643348711.a4970d6e22f8c0accc39e9ec746a05fa.,
> hostname=ip-10-5-4-222.ec2.internal,16020,1452867025003, seqNum=11131841


After this, I get into a state where I can see the table on phoenix typing
*!tables* but I can't see the table on HBase. The state of the index is
BUILDING.

BTW, Is there a way to check the state of an index (BUILDING, USABLE,
etc..) via command line?

Any thoughts?

Thank you,
Cheers
Pedro

Mime
View raw message