SDB报SDB_INVALIDARG,Invalid Argument等错误

使用更先进的浏览器访问效果更佳。

SDB报SDB_INVALIDARG,Invalid Argument等错误

Public_SDB

【问题详细描述】

用户在使用Java驱动时，有时候启动会有SDB_INVALIDARG,Invalid Argument 的报错，有时候执行应用功能会有com.sequoiadb.exception.BaseException: errorType:SDB_INVALIDSIZE,Invalid size错误，sdb版本：sequoiadb-1.12.4

用户的连接池程序如下：

 package com.zyt.core.service.impl; 
 import org.apache.log4j.Logger; 
 import java.util.ArrayList; 
 import java.util.List; 
 import com.sequoiadb.base.CollectionSpace; 
 import com.sequoiadb.base.Sequoiadb; 
 import com.sequoiadb.base.SequoiadbDatasource; 
 import com.sequoiadb.base.SequoiadbOption; 
 import com.sequoiadb.exception.BaseException; 
 import com.sequoiadb.net.ConfigOptions; 
 public class SequoiaDbSessionFactory { 
         /** 
          * Logger for this class 
          */ 
         private static final Logger logger = Logger.getLogger(SequoiaDbSessionFactory.class); 
         
         private String HOST; 
         private String USERNAME = ""; 
         private String PASSWORD = ""; 
         private String CS_NAME; 
         private int CONNTIMEOUT = 500; 
         private int TIMEOUT = 500; 
         private List hosts; 
         
         public SequoiaDbSessionFactory() { 
                 logger.info("HOST     ="+HOST); 
                 logger.info("CS_NAME     ="+CS_NAME); 
         } 
         public Sequoiadb getSequoiadb() throws BaseException, InterruptedException { 
                 if (logger.isDebugEnabled()) { 
                         logger.debug("getSequoiadb() - start"); //$NON-NLS-1$ 
                 } 
                 SequoiadbDatasource ds = null; 
                 ArrayList urls = new ArrayList(); 
                 ConfigOptions nwOpt = new ConfigOptions(); // 定义连接选项 
                 SequoiadbOption dsOpt = new SequoiadbOption(); // 定义连接池选项 
                 urls.add(HOST); 
                 for (String h : hosts) { 
                         logger.info("增加配机："+h); 
                         urls.add(h); 
                 } 
                 nwOpt.setConnectTimeout(CONNTIMEOUT); // 设置若连接失败，超时时间（ms） 
                 nwOpt.setMaxAutoConnectRetryTime(0); // 设置若连接失败，重试次数 
                 // 以下设置的都是 SequoiadbOption 的默认值 
                 dsOpt.setMaxConnectionNum(500); // 设置连接池最大连接数 
                 dsOpt.setInitConnectionNum(10); // 初始化连接池时，创建连接的数量 
                 dsOpt.setDeltaIncCount(10); // 当池中没有可用连接时，增加连接的数量 
                 dsOpt.setMaxIdeNum(10); // 周期清理多余的空闲连接时，应保留连接的数量 
                 dsOpt.setTimeout(5 * 1000); // 当已使用的连接数到达设置的最大连接数时（500），请求连接的等待时间。 
                 dsOpt.setAbandonTime(10 * 60 * 1000); // 连接存活时间，当连接空闲时间超过连接存活时间，将被连接池丢弃 
                 dsOpt.setRecheckCyclePeriod(1 * 60 * 1000); // 清除多余空闲连接的周期 
                 dsOpt.setRecaptureConnPeriod(10 * 60 * 1000); // 检测并取回异常地址的周期 
                 ds = new SequoiadbDatasource(urls, USERNAME, PASSWORD, nwOpt, dsOpt); // 创建连接池 
                 Sequoiadb returnSequoiadb = ds.getConnection(); 
                 if (logger.isDebugEnabled()) { 
                         logger.debug("getSequoiadb() - end"); //$NON-NLS-1$ 
                 } 
                 return returnSequoiadb; 
         } 
         public CollectionSpace getCollectionSpace() throws BaseException, 
                         InterruptedException { 
                 if (logger.isDebugEnabled()) { 
                         logger.debug("getCollectionSpace() - start"); //$NON-NLS-1$ 
                 } 
                 CollectionSpace returnCollectionSpace = getSequoiadb().getCollectionSpace(CS_NAME); 
                 if (logger.isDebugEnabled()) { 
                         logger.debug("getCollectionSpace() - end"); //$NON-NLS-1$ 
                 } 
                 return returnCollectionSpace; 
         } 
         public String getHOST() { 
                 return HOST; 
         } 
         public void setHOST(String hOST) { 
                 HOST = hOST; 
         } 
         public String getUSERNAME() { 
                 return USERNAME; 
         } 
         public void setUSERNAME(String uSERNAME) { 
                 USERNAME = uSERNAME; 
         } 
         public String getPASSWORD() { 
                 return PASSWORD; 
         } 
         public void setPASSWORD(String pASSWORD) { 
                 PASSWORD = pASSWORD; 
         } 
         public String getCS_NAME() { 
                 return CS_NAME; 
         } 
         public void setCS_NAME(String cS_NAME) { 
                 CS_NAME = cS_NAME; 
         } 
         public int getCONNTIMEOUT() { 
                 return CONNTIMEOUT; 
         } 
         public void setCONNTIMEOUT(int cONNTIMEOUT) { 
                 CONNTIMEOUT = cONNTIMEOUT; 
         } 
         public int getTIMEOUT() { 
                 return TIMEOUT; 
         } 
         public void setTIMEOUT(int tIMEOUT) { 
                 TIMEOUT = tIMEOUT; 
         } 
         public List getHosts() { 
                 return hosts; 
         } 
         public void setHosts(List hosts) { 
                 this.hosts = hosts; 
         } 
         
 }

SDB_INVALIDSIZE,Invalid size报错是用户在执行一个EXCEL导入的时候后台报的错误，错误信息如下

[ERROR] [http-8080-1 02:02:08] (SequoiaDBBaseDao.java:getCL:150) errorType:SDB_INVALIDSIZE,Invalid size Exception Detail:-2147481644 com.sequoiadb.exception.BaseException: errorType:SDB_INVALIDSIZE,Invalid size Exception Detail:-2147481644 at com.sequoiadb.util.SDBMessageHelper.msgExtractReply(SDBMessageHelper.java:655) at com.sequoiadb.base.Sequoiadb.adminCommand(Sequoiadb.java:1869) at com.sequoiadb.base.Sequoiadb.isCollectionSpaceExist(Sequoiadb.java:615) at com.sequoiadb.base.Sequoiadb.getCollectionSpace(Sequoiadb.java:595) at com.zyt.core.service.impl.SequoiaDbSessionFactory.getCollectionSpace(SequoiaDbSessionFactory.java:83) at com.zyt.core.service.impl.SequoiaDBBaseDao.getCL(SequoiaDBBaseDao.java:143) at com.zyt.core.service.impl.SequoiaDBBaseDao.insert(SequoiaDBBaseDao.java:41) at com.zyt.core.service.impl.BaseServiceImpl.add(BaseServiceImpl.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) java.nio.BufferUnderflowException at java.nio.Buffer.nextGetIndex(Buffer.java:498) [ERROR] [http-8080-1 04:50:10] (SequoiaDBBaseDao.java:getCL:150) errorType:SDB_INVALIDSIZE,Invalid size Exception Detail:0 at java.nio.HeapByteBuffer.getInt(HeapByteBuffer.java:355) at com.sequoiadb.util.SDBMessageHelper.msgExtractReply(SDBMessageHelper.java:652) at com.sequoiadb.base.CollectionSpace.adminCommand(CollectionSpace.java:257) at com.sequoiadb.base.CollectionSpace.isCollectionExist(CollectionSpace.java:108) at com.zyt.core.service.impl.SequoiaDBBaseDao.getCL(SequoiaDBBaseDao.java:143) at com.zyt.core.service.impl.SequoiaDBBaseDao.insert(SequoiaDBBaseDao.java:41) at com.zyt.core.service.impl.BaseServiceImpl.add(BaseServiceImpl.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.zyt.core.log.LogDevServiceAdvice.invoke(LogDevServiceAdvice.java:48) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy21.add(Unknown Source) at com.zyt.pms.product.service.impl.BatchImportProductServiceImpl.loadDataTableInfo(BatchImportProductServiceImpl.java:156) at com.zyt.pms.product.service.impl.BatchImportProductServiceImpl.uploadFile(BatchImportProductServiceImpl.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.zyt.core.log.LogDevServiceAdvice.invoke(LogDevServiceAdvice.java:48) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy22.uploadFile(Unknown Source) at com.zyt.pms.product.action.ImportProductAction.execute(ImportProductAction.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606)

【诉求】

帮忙寻找问题出错的原因。

【解决办法】

1、该代码不能准确定位到出错原因，需要了解具体的程序错误堆栈信息，及sequoiadb版本号（/opt/sequoiadb/bin/sequoiadb --version）

2、sequoiadb java驱动不是线程安全的，请检查你的程序，查看是否存在一个连接对象被放到多个线程中使用的情况。关于线程安全问题，可以参考这篇文章http://blog.csdn.net/shanks2048/article/details/47660371

3、关于java连接池的操作，建议只new一次连接池，然后从连接池中取连接，而getConnection（）每次都new一个连接池，这应该是没有必要的。建议将java连接池当做一个单例来使用，即一个客户端程序只用一个连接池，然后所有连接都从这一个连接池获取，用完连接之后，再把连接还回连接池。

【参考链接】

错误码

常见错误处理指南