Hi Kristoffer,
Did something change on your cluster prior to the breaking of your
SELECT queries? Did it ever work?
Thanks,
James
On Mon, Sep 29, 2014 at 4:06 PM, Kristoffer Sjögren sto...@gmail.com wrote:
Thank for quick reply. Yes, we will try to upgrade as soon as we can get the
servers up on 2.2.3. If we can't then we go straight to upgrade.
The region servers are running phoenix-2.2.3-incubating.jar found in [1].
Are the clients suppose to use the exact same jar? The jar files have same
name but are indeed slightly different in size between client (1542522
bytes) and server (1540202 bytes). Bummer that the jar MANIFEST does not
provide enough build information.
I'm still puzzled why sqlline.sh [1] have the same problem though? Maybe
something with phoenix-2.2.3-incubating-client.jar?
[1]
http://apache.mirrors.spacedump.net/incubator/phoenix/phoenix-2.2.3-incubating/bin/phoenix-2.2.3-incubating.tar.gz
On Tue, Sep 30, 2014 at 12:34 AM, James Taylor jamestay...@apache.org
wrote:
Hi Kristoffer,
Did something change on your cluster prior to the breaking of your
SELECT queries? An upgrade of something?
From the look of the exceptions, it seems like the Phoenix client jar
and server jar are out-of-sync, because the client is sending
information in a format that's no longer understood by the server.
I do encourage you to upgrade, though, once you get your production
servers functioning again.
Thanks,
James
On Mon, Sep 29, 2014 at 3:17 PM, Kristoffer Sjögren sto...@gmail.com
wrote:
Hi
Our SELECT queries went broken just now and we're seeing the following
exception [1] using Apache Phoenix 2.2.3-incubating with HBase 0.94.6
(0.94.6-cdh4.4.0).
After a some testing I realized that sqlline.sh from the
2.2.3-incubating
tarball is also broken all of a sudden (with same error)?
Seems like SELECT ... WHERE queries are problematic whereas basic
queries
like SELECT * FROM COUNTERS LIMIT 1; works fine. Simple INSERT
statements
also seems to be working.
Is upgrading to phoenix-3.0.0-incubating an option? Or is there a way to
debug this further? I tried to enable DEBUG in log4j.properties using
the
'console' in sqlline but without success.
Our production servers are pretty much down at the moment...
Cheers,
-Kristoffer
[1] http://pastebin.com/H2a6xpBX