View Issue Details

IDProjectCategoryView StatusLast Update
0000013Pgpool-IIBugpublic2012-05-23 08:27
ReporterbabyyellowAssigned Tot-ishii 
PriorityhighSeverityfeatureReproducibilityalways
Status closedResolutionduplicate 
Platformlinux OSredhat linux OS Version5.4
Product Version 
Target VersionFixed in Version 
Summary0000013: ERROR: portal "" does not exist {prepstmnt 1698892272
Descriptionjpa java app resin 3.x , postgresql 9.1.3

streaming replication

pgpool-II-3.1.3 load balance .

run preparedstements java throw errors :

   at java.lang.Thread.run(Thread.java:619)
[05-11 16:38:23.204] org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: portal "" does not exist {prepstmnt 1698892272 SELECT t0.version,



if no pgpool , all is fine .

and this issure can be recreated .



================
Connection con = EnvUtils.getEnv().getConnection();
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs=ps.executeQuery();





TagsNo tags attached.

Activities

babyyellow

2012-05-11 18:19

reporter  

stderr(2).txt (4,766 bytes)
    at java.lang.Thread.run(Thread.java:619)
[05-11 16:38:23.204] org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: portal "" does not exist {prepstmnt 1698892272 SELECT t0.version, t0.ALIPAY_LOGISTICS_TYPE, t0.CREATE_BY, t0.CREATE_DATE, t0.LAST_UPDATE_BY, t0.LAST_UPDATE_DATE, t0.LOGISTICS_COMPANY, t0.LOGISTICS_FEE, t0.LOGISTICS_NUMBER, t0.LOGISTICS_PAYMENT, t0.LOGISTICS_TYPE, t0.ORDER_ID, t0.RECEIVE_ADDRESS, t0.RECEIVE_CITY, t0.RECEIVE_DISTRICT, t0.RECEIVE_MOBILE, t0.RECEIVE_NAME, t0.RECEIVE_PHONE, t0.RECEIVE_PROVINCE, t0.RECEIVE_ZIP, t0.SEND_ADDRESS, t0.SEND_CITY, t0.SEND_DISTRICT, t0.SEND_MOBILE, t0.SEND_NAME, t0.SEND_PHONE, t0.SEND_PROVINCE, t0.SEND_ZIP FROM ENT_ORDER_LOGISTICS t0 WHERE t0.ORDER_ID = ? [params=(long) 70814]} [code=0, state=34000]
[05-11 16:38:23.204]    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
[05-11 16:38:23.204]    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
[05-11 16:38:23.204]    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
[05-11 16:38:23.204]    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
[05-11 16:38:23.204]    at org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:520)
[05-11 16:38:23.204]    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
[05-11 16:38:23.204]    at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1513)
[05-11 16:38:23.204]    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
[05-11 16:38:23.204]    at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:496)
[05-11 16:38:23.205]    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
[05-11 16:38:23.205]    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
[05-11 16:38:23.205]    at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:441)
[05-11 16:38:23.205]    at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:307)
[05-11 16:38:23.205]    at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:277)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111)
[05-11 16:38:23.205]    at org.apache.openjpa.datacache.DataCacheStoreManager.initialize(DataCacheStoreManager.java:340)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:894)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:852)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:774)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.AbstractPCData.toRelationField(AbstractPCData.java:212)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.AbstractPCData.toNestedField(AbstractPCData.java:146)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.AbstractPCData.toField(AbstractPCData.java:123)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.PCDataImpl.loadField(PCDataImpl.java:197)
[05-11 16:38:23.205]    at org.apache.openjpa.kernel.PCDataImpl.load(PCDataImpl.java:167)
[05-11 16:38:23.206]    at org.apache.openjpa.datacache.DataCacheStoreManager.load(DataCacheStoreManager.java:387)
[05-11 16:38:23.206]    at org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:116)
[05-11 16:38:23.206]    at org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)
[05-11 16:38:23.206]    at org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:2920)
[05-11 16:38:23.206]    at org.apache.openjpa.kernel.StateManagerImpl.loadField(StateManagerImpl.java:2998)
[05-11 16:38:23.206]    at org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1492)
[05-11 16:38:23.206]    at org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1477)
[05-11 16:38:23.206]    at cn.com.pconline.enterprise.domain.Order.pcGetbuyer(Order.java)
[05-11 16:38:23.206]    at cn.com.pconline.enterprise.domain.Order.getBuyer(Order.java:347)
stderr(2).txt (4,766 bytes)

t-ishii

2012-05-22 18:45

developer   ~0000028

I think this is same issue as 0000014.

Issue History

Date Modified Username Field Change
2012-05-11 18:19 babyyellow New Issue
2012-05-11 18:19 babyyellow File Added: stderr(2).txt
2012-05-22 18:44 t-ishii Assigned To => t-ishii
2012-05-22 18:44 t-ishii Status new => assigned
2012-05-22 18:45 t-ishii Note Added: 0000028
2012-05-22 18:46 t-ishii Resolution open => duplicate
2012-05-23 08:27 t-ishii Status assigned => closed