Thanks James, So to clarify: changing phoenix.query.timeoutMs via Ambari is insufficient. I have to add/adjust this value by hand on each of my region servers (I'm guessing that's what client-side means here).
Is that correct? -----Original Message----- From: James Taylor [mailto:[email protected]] Sent: Monday, June 15, 2015 1:58 PM To: user Subject: Re: How to increase call timeout/count rows? Hi Zack, Some good references are http://hbase.apache.org/book.html and https://phoenix.apache.org/tuning.html. Couple of issues: - property names are case sensitive, so make sure to use the correct/expected case (i.e. hbase.rpc.timeout). - not all of the properties are server-side properties. For example, phoenix.query.timeoutMs is client-side so you'll want to make sure to set that so that it's in effect from your client. Thanks, James On Mon, Jun 15, 2015 at 6:49 AM, Riesland, Zack <[email protected]> wrote: > Whenever I run a non-typical query (not filtered by the primary key), > I get an exception like this one. > > > > I tried modifying each of the following in custom hbase-site to > increase the > timeout: > > > > Hbase.client.scanner.timeout.period > > Hbase.regionserver.lease.period > > Hbase.rpc.shortoperation.timeout > > Hbase.rpc.timeout > > Phoenix.query.timeoutMs > > Zookeeper.timeout.session > > > > I set each of these to 180000 ms, but I still get a timeout after 60 > seconds. > > > > Does anyone know the solution? > > > > > > 0: jdbc:phoenix:<my server>> select count(*) from <my table>; > > +------------+ > > | COUNT(1) | > > +------------+ > > java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: > org.apache.phoenix.exception.PhoenixIOException: Failed after > attempts=36, > exceptions: > > Mon Jun 15 09:44:44 EDT 2015, null, java.net.SocketTimeoutException: > callTimeout=60000, callDuration=62368: row '' on table <my table>' at > region=<table>,,1433266684799.7461878881e30de657bd24287a9a0df3., > hostname=<host>,60020,1434375522489, seqNum=62 > > > > at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) > > at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) > > at sqlline.SqlLine.print(SqlLine.java:1735) > > at sqlline.SqlLine$Commands.execute(SqlLine.java:3683) > > at sqlline.SqlLine$Commands.sql(SqlLine.java:3584) > > at sqlline.SqlLine.dispatch(SqlLine.java:821) > > at sqlline.SqlLine.begin(SqlLine.java:699) > > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) > > at sqlline.SqlLine.main(SqlLine.java:424)
