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, [email protected] <[email protected]> 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: [email protected] > > Website: www.certusnet.com.cn
