You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@maven.apache.org by "Richard C. L. Li (JIRA)" <ji...@codehaus.org> on 2006/11/04 10:56:31 UTC
[jira] Created: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
New indexes created during continuum startup when using postgresql
------------------------------------------------------------------
Key: CONTINUUM-994
URL: http://jira.codehaus.org/browse/CONTINUUM-994
Project: Continuum
Issue Type: Bug
Components: Database
Affects Versions: 1.0.3
Reporter: Richard C. L. Li
I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Closed: (CONTINUUM-994) New indexes created during continuum
startup when using postgresql
Posted by "Richard C. L. Li (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=all ]
Richard C. L. Li closed CONTINUUM-994.
--------------------------------------
Resolution: Won't Fix
Fix Version/s: 1.1
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
> Fix For: 1.1
>
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Closed: (CONTINUUM-994) New indexes created during continuum
startup when using postgresql
Posted by "Jesse McConnell (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesse McConnell closed CONTINUUM-994.
-------------------------------------
Resolution: Fixed
this was fixed with the jpox release of 1.1.6 which in turn created some other issues with postgres (but not this one :), however there is a new jpox version coming very soon which fixes those issues which we will upgrade to promptly
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
> Fix For: 1.1-alpha-1
>
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Reopened: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Emmanuel Venisse reopened CONTINUUM-994:
----------------------------------------
Reopen, we'll close it when jpox 1.1.6 will be used
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
> Fix For: 1.1
>
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Andy Jefferson (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=comments#action_82571 ]
Andy Jefferson commented on CONTINUUM-994:
------------------------------------------
JPOX had an issue of this form some time ago. This was fixed (JPOX releases are now up to 1.1.5 so perhaps using something recent would help). All recent versions dont have it.
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Richard C. L. Li (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_85955 ]
Richard C. L. Li commented on CONTINUUM-994:
--------------------------------------------
Continuum will generate an exception when using with postgresql and JPOX 1.1.6 upon browsing the web page at the first time, the problem is resides in plexus:
{panel}
http://jira.codehaus.org/browse/PLX-322
{panel}
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
> Fix For: 1.1
>
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Richard C. L. Li (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=comments#action_82840 ]
Richard C. L. Li commented on CONTINUUM-994:
--------------------------------------------
Will new release upgrade the dependencies to 1.1.5?
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Andy Jefferson (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_85784 ]
Andy Jefferson commented on CONTINUUM-994:
------------------------------------------
Was fixed in JPOX 1.1.6
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
> Fix For: 1.1
>
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Richard C. L. Li (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=comments#action_82844 ]
Richard C. L. Li commented on CONTINUUM-994:
--------------------------------------------
I just tried to build the continuum ffrom trunk and replace the jpox from 1.1.1 to 1.1.5, this problem still persists. Any idea?
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-994) New indexes created during
continuum startup when using postgresql
Posted by "Richard C. L. Li (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=comments#action_85299 ]
Richard C. L. Li commented on CONTINUUM-994:
--------------------------------------------
After some investigation, I figure out that the problem is in jpox. When using Upper Case for identifiers, postgresql jdbc driver will response all identifier with quotes, but quoting identifiers will trigger a bug in jpox that it cannot identify existing indexes and recreating them. To work around, simply set the use of identifiers to use Lower Case and problem solved.
Edit the file <continuum home>/apps/continuum/webapp/WEB-INF/classes/META-INF/plexus/application.xml and add the property org.jpox.identifier.case in the jpox component definition.
{code:xml}
<component>
<role>org.codehaus.plexus.jdo.JdoFactory</role>
<role-hint>users</role-hint>
<implementation>org.codehaus.plexus.jdo.DataSourceConfigurableJdoFactory</implementation>
<configuration>
<connectionFactoryName>java:comp/env/jdbc/users</connectionFactoryName>
<shutdownConnectionFactoryName>java:comp/env/jdbc/usersShutdown</shutdownConnectionFactoryName>
<!-- JPOX and JDO configuration -->
<persistenceManagerFactoryClass>org.jpox.PersistenceManagerFactoryImpl</persistenceManagerFactoryClass>
<otherProperties>
<property>
<name>org.jpox.autoCreateSchema</name>
<value>true</value>
</property>
<property>
<name>org.jpox.validateTables</name>
<value>false</value>
</property>
<property>
<name>org.jpox.validateConstraints</name>
<value>false</value>
</property>
<property>
<name>org.jpox.validateColumns</name>
<value>false</value>
</property>
<property>
<name>org.jpox.autoStartMechanism</name>
<value>None</value>
</property>
<property>
<name>org.jpox.transactionIsolation</name>
<value>READ_UNCOMMITTED</value>
</property>
<property>
<name>org.jpox.poid.transactionIsolation</name>
<value>READ_UNCOMMITTED</value>
</property>
<property>
<name>org.jpox.rdbms.dateTimezone</name>
<value>JDK_DEFAULT_TIMEZONE</value>
</property>
<property>
<name>org.jpox.identifier.case</name>
<value>LowerCase</value>
</property>
</otherProperties>
</configuration>
</component>
<component>
<role>org.codehaus.plexus.jdo.JdoFactory</role>
<implementation>org.codehaus.plexus.jdo.DataSourceConfigurableJdoFactory</implementation>
<role-hint>continuum</role-hint>
<configuration>
<connectionFactoryName>java:comp/env/jdbc/continuum</connectionFactoryName>
<shutdownConnectionFactoryName>java:comp/env/jdbc/continuum_shutdown</shutdownConnectionFactoryName>
<persistenceManagerFactoryClass>org.jpox.PersistenceManagerFactoryImpl</persistenceManagerFactoryClass>
<otherProperties>
<property>
<name>org.jpox.autoCreateSchema</name>
<value>true</value>
</property>
<property>
<name>org.jpox.validateTables</name>
<value>false</value>
</property>
<property>
<name>org.jpox.validateColumns</name>
<value>false</value>
</property>
<property>
<name>org.jpox.validateConstraints</name>
<value>false</value>
</property>
<property>
<name>org.jpox.autoStartMechanism</name>
<value>None</value>
</property>
<property>
<name>org.jpox.transactionIsolation</name>
<value>READ_UNCOMMITTED</value>
</property>
<property>
<name>org.jpox.identifier.case</name>
<value>LowerCase</value>
</property>
</otherProperties>
</configuration>
</component>
{code}
> New indexes created during continuum startup when using postgresql
> ------------------------------------------------------------------
>
> Key: CONTINUUM-994
> URL: http://jira.codehaus.org/browse/CONTINUUM-994
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.0.3
> Reporter: Richard C. L. Li
> Fix For: 1.1
>
>
> I used postgresql 8.1.4 with continuum and everytime when continuum startup, it creates a set of indexes. I configured to restart continuum once a day and after 2 months it generated tens of indexes in every table.
> I guessed this maybe the problem of the the UPPER CASE of the table and column names, this may make the detection of indexes fails and the JDO recreate everytime it startup.
> Workaround: after starting continuum for the first time and set the property org.jpox.autoCreateSchema to false so that indexes will not recreated.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira