You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn> on 2014/08/12 11:25:27 UTC

Using Squirrel Sql Client to connect Phoenix

Hi,
    I got a severe problem when using Squirrel Sql Client to connect Phoenix. When I added phoenix-4.0.0-incubating-client.jar to the lib of squirrel sql client, and trying to list drivers in the squirrel sql client, then the sql client encountered a breakdown and cannot work any more. I referred to the log and the following information may be available. Hoping any guys can give me some hints. I would be really appreciated.
2014-08-12 16:14:36,278 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.DropTableStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:37,816 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.HintNode$Hint in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:39,404 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.ParseNodeRewriter$4 in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:40,685 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.CaseParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:41,919 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.ParseException in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:42,889 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.CreateTableStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:44,135 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.NamedNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:45,702 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.ParseNodeRewriter$1 in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:46,954 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.FloorParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:48,183 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.IndexKeyConstraint in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:49,751 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.CreateSequenceStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:50,679 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.TableName in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:51,959 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.SumAggregateParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:53,270 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.UnaryParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:54,503 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.ConcreteTableNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:55,839 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.CeilParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:57,789 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.NotEqualParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:14:59,152 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.DelegateConstantToCountParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:01,021 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.SingleTableStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:02,308 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.AndParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:04,297 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.DropColumnStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:05,588 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.PhoenixSQLLexer in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:07,453 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.FamilyWildcardParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:09,327 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.ParseNodeRewriter$7 in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:10,607 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.CurrentTimeParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:12,486 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.SelectStatementRewriter$1 in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:14,427 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.SelectStatementRewriter$2 in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:16,328 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.SQLParser$CaseInsensitiveReaderStream in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:18,193 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.MutableStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:19,419 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.CreateIndexStatement in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:21,270 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.SubqueryParseNode in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:22,539 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.PhoenixSQLLexer$DFA18 in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
2014-08-12 16:15:23,760 [Thread-3] INFO net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to load org.apache.phoenix.parse.PrimaryKeyConstraint in D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError: PermGen space 
CertusNet 
赛特斯信息科技股份有限公司
 
孙福林
Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
Mobile: 15850710386
Mail: sunfl@certusnet.com.cn   
Website: www.certusnet.com.cn

Re: Re: Using Squirrel Sql Client to connect Phoenix

Posted by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>.
Hi,
Really appreciate your hints and it did work finally. 





CertusNet 
赛特斯信息科技股份有限公司
 
孙福林
Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
Mobile: 15850710386
Mail: sunfl@certusnet.com.cn   
Website: www.certusnet.com.cn
 
From: Gabriel Reid
Date: 2014-08-12 20:50
To: user
Subject: Re: Using Squirrel Sql Client to connect Phoenix
Hi,
 
This is due to the permgen space (a pre-allocated portion of memory
set up by the JVM) being too small. It looks like you're on Windows,
and I'm guessing that you're using a client-mode VM, which I think
mean your permgen is 32 MB.
 
I'm not really familiar with SQuirreL on windows, but from what I
understand from [1], you start squirrel up with the squirrel-sql.bat.
If you add the argument -XX:PermSize=64m to the start command within
squirrel-sql.bat, it should resolve this.
 
1. http://squirrel-sql-client.10976.n7.nabble.com/Squirrel-Memory-Allocation-td1477.html
 
- Gabriel
 
 
On Tue, Aug 12, 2014 at 11:25 AM, sunfl@certusnet.com.cn
<su...@certusnet.com.cn> wrote:
>
> Hi,
>     I got a severe problem when using Squirrel Sql Client to connect
> Phoenix. When I added phoenix-4.0.0-incubating-client.jar to the lib of
> squirrel sql client, and trying to list drivers in the squirrel sql client,
> then the sql client encountered a breakdown and cannot work any more. I
> referred to the log and the following information may be available. Hoping
> any guys can give me some hints. I would be really appreciated.
> 2014-08-12 16:14:36,278 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DropTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:37,816 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.HintNode$Hint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:39,404 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$4 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:40,685 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CaseParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:41,919 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseException in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:42,889 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:44,135 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.NamedNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:45,702 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$1 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:46,954 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.FloorParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:48,183 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.IndexKeyConstraint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:49,751 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateSequenceStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:50,679 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.TableName in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:51,959 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SumAggregateParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:53,270 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.UnaryParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:54,503 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ConcreteTableNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:55,839 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CeilParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:57,789 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.NotEqualParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:59,152 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DelegateConstantToCountParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:01,021 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SingleTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:02,308 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.AndParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:04,297 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DropColumnStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:05,588 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PhoenixSQLLexer in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:07,453 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.FamilyWildcardParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:09,327 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$7 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:10,607 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CurrentTimeParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:12,486 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SelectStatementRewriter$1 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:14,427 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SelectStatementRewriter$2 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:16,328 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SQLParser$CaseInsensitiveReaderStream in
> D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar
> to check if it is assignable to java.sql.Driver. Reason:
> java.lang.OutOfMemoryError: PermGen space
> 2014-08-12 16:15:18,193 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.MutableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:19,419 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateIndexStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:21,270 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SubqueryParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:22,539 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PhoenixSQLLexer$DFA18 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:23,760 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PrimaryKeyConstraint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
>
> CertusNet
>
> 赛特斯信息科技股份有限公司
>
>
>
> 孙福林
>
> Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
>
> Mobile: 15850710386
> Mail: sunfl@certusnet.com.cn
>
> Website: www.certusnet.com.cn
 
 
 

Re: Re: Using Squirrel Sql Client to connect Phoenix

Posted by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>.
Really appreciating your help. It finally works.





CertusNet 
赛特斯信息科技股份有限公司
 
孙福林
Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
Mobile: 15850710386
Mail: sunfl@certusnet.com.cn   
Website: www.certusnet.com.cn
 
From: Gabriel Reid
Date: 2014-08-12 20:50
To: user
Subject: Re: Using Squirrel Sql Client to connect Phoenix
Hi,
 
This is due to the permgen space (a pre-allocated portion of memory
set up by the JVM) being too small. It looks like you're on Windows,
and I'm guessing that you're using a client-mode VM, which I think
mean your permgen is 32 MB.
 
I'm not really familiar with SQuirreL on windows, but from what I
understand from [1], you start squirrel up with the squirrel-sql.bat.
If you add the argument -XX:PermSize=64m to the start command within
squirrel-sql.bat, it should resolve this.
 
1. http://squirrel-sql-client.10976.n7.nabble.com/Squirrel-Memory-Allocation-td1477.html
 
- Gabriel
 
 
On Tue, Aug 12, 2014 at 11:25 AM, sunfl@certusnet.com.cn
<su...@certusnet.com.cn> wrote:
>
> Hi,
>     I got a severe problem when using Squirrel Sql Client to connect
> Phoenix. When I added phoenix-4.0.0-incubating-client.jar to the lib of
> squirrel sql client, and trying to list drivers in the squirrel sql client,
> then the sql client encountered a breakdown and cannot work any more. I
> referred to the log and the following information may be available. Hoping
> any guys can give me some hints. I would be really appreciated.
> 2014-08-12 16:14:36,278 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DropTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:37,816 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.HintNode$Hint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:39,404 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$4 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:40,685 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CaseParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:41,919 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseException in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:42,889 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:44,135 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.NamedNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:45,702 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$1 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:46,954 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.FloorParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:48,183 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.IndexKeyConstraint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:49,751 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateSequenceStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:50,679 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.TableName in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:51,959 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SumAggregateParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:53,270 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.UnaryParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:54,503 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ConcreteTableNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:55,839 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CeilParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:57,789 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.NotEqualParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:59,152 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DelegateConstantToCountParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:01,021 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SingleTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:02,308 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.AndParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:04,297 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DropColumnStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:05,588 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PhoenixSQLLexer in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:07,453 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.FamilyWildcardParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:09,327 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$7 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:10,607 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CurrentTimeParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:12,486 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SelectStatementRewriter$1 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:14,427 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SelectStatementRewriter$2 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:16,328 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SQLParser$CaseInsensitiveReaderStream in
> D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar
> to check if it is assignable to java.sql.Driver. Reason:
> java.lang.OutOfMemoryError: PermGen space
> 2014-08-12 16:15:18,193 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.MutableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:19,419 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateIndexStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:21,270 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SubqueryParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:22,539 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PhoenixSQLLexer$DFA18 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:23,760 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PrimaryKeyConstraint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
>
> CertusNet
>
> 赛特斯信息科技股份有限公司
>
>
>
> 孙福林
>
> Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
>
> Mobile: 15850710386
> Mail: sunfl@certusnet.com.cn
>
> Website: www.certusnet.com.cn
 
 
 

Re: Using Squirrel Sql Client to connect Phoenix

Posted by Gabriel Reid <ga...@gmail.com>.
Hi,

This is due to the permgen space (a pre-allocated portion of memory
set up by the JVM) being too small. It looks like you're on Windows,
and I'm guessing that you're using a client-mode VM, which I think
mean your permgen is 32 MB.

I'm not really familiar with SQuirreL on windows, but from what I
understand from [1], you start squirrel up with the squirrel-sql.bat.
If you add the argument -XX:PermSize=64m to the start command within
squirrel-sql.bat, it should resolve this.

1. http://squirrel-sql-client.10976.n7.nabble.com/Squirrel-Memory-Allocation-td1477.html

- Gabriel


On Tue, Aug 12, 2014 at 11:25 AM, sunfl@certusnet.com.cn
<su...@certusnet.com.cn> wrote:
>
> Hi,
>     I got a severe problem when using Squirrel Sql Client to connect
> Phoenix. When I added phoenix-4.0.0-incubating-client.jar to the lib of
> squirrel sql client, and trying to list drivers in the squirrel sql client,
> then the sql client encountered a breakdown and cannot work any more. I
> referred to the log and the following information may be available. Hoping
> any guys can give me some hints. I would be really appreciated.
> 2014-08-12 16:14:36,278 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DropTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:37,816 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.HintNode$Hint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:39,404 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$4 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:40,685 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CaseParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:41,919 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseException in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:42,889 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:44,135 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.NamedNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:45,702 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$1 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:46,954 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.FloorParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:48,183 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.IndexKeyConstraint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:49,751 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateSequenceStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:50,679 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.TableName in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:51,959 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SumAggregateParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:53,270 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.UnaryParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:54,503 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ConcreteTableNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:55,839 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CeilParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:57,789 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.NotEqualParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:14:59,152 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DelegateConstantToCountParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:01,021 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SingleTableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:02,308 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.AndParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:04,297 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.DropColumnStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:05,588 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PhoenixSQLLexer in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:07,453 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.FamilyWildcardParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:09,327 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.ParseNodeRewriter$7 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:10,607 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CurrentTimeParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:12,486 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SelectStatementRewriter$1 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:14,427 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SelectStatementRewriter$2 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:16,328 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SQLParser$CaseInsensitiveReaderStream in
> D:\Program Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar
> to check if it is assignable to java.sql.Driver. Reason:
> java.lang.OutOfMemoryError: PermGen space
> 2014-08-12 16:15:18,193 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.MutableStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:19,419 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.CreateIndexStatement in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:21,270 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.SubqueryParseNode in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:22,539 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PhoenixSQLLexer$DFA18 in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
> 2014-08-12 16:15:23,760 [Thread-3] INFO
> net.sourceforge.squirrel_sql.client.gui.db.DriverInternalFrame - Failed to
> load org.apache.phoenix.parse.PrimaryKeyConstraint in D:\Program
> Files\squirrel-sql-3.5.3\lib\phoenix-3.0.0-incubating-client.jar to check if
> it is assignable to java.sql.Driver. Reason: java.lang.OutOfMemoryError:
> PermGen space
>
> CertusNet
>
> 赛特斯信息科技股份有限公司
>
>
>
> 孙福林
>
> Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
>
> Mobile: 15850710386
> Mail: sunfl@certusnet.com.cn
>
> Website: www.certusnet.com.cn