{"action":"closed","issue":{"url":"https://api.github.com/repos/dotCMS/core/issues/5982","labels_url":"https://api.github.com/repos/dotCMS/core/issues/5982/labels{/name}","comments_url":"https://api.github.com/repos/dotCMS/core/issues/5982/comments","events_url":"https://api.github.com/repos/dotCMS/core/issues/5982/events","html_url":"https://github.com/dotCMS/core/issues/5982","id":38549549,"number":5982,"title":"Upgrade to 2.3.2 to 2.5.6 fails in Oracle","user":{"login":"joseorsini","id":1717110,"avatar_url":"https://avatars.githubusercontent.com/u/1717110?v=3","gravatar_id":"","url":"https://api.github.com/users/joseorsini","html_url":"https://github.com/joseorsini","followers_url":"https://api.github.com/users/joseorsini/followers","following_url":"https://api.github.com/users/joseorsini/following{/other_user}","gists_url":"https://api.github.com/users/joseorsini/gists{/gist_id}","starred_url":"https://api.github.com/users/joseorsini/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joseorsini/subscriptions","organizations_url":"https://api.github.com/users/joseorsini/orgs","repos_url":"https://api.github.com/users/joseorsini/repos","events_url":"https://api.github.com/users/joseorsini/events{/privacy}","received_events_url":"https://api.github.com/users/joseorsini/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dotCMS/core/labels/Merged","name":"Merged","color":"5319e7"},{"url":"https://api.github.com/repos/dotCMS/core/labels/Type%20:%20bug","name":"Type : bug","color":"006b75"},{"url":"https://api.github.com/repos/dotCMS/core/labels/WF%20:%20Passed%20QA","name":"WF : Passed QA","color":"e11d21"}],"state":"closed","locked":false,"assignee":{"login":"dotcmsCodeReview","id":1568120,"avatar_url":"https://avatars.githubusercontent.com/u/1568120?v=3","gravatar_id":"","url":"https://api.github.com/users/dotcmsCodeReview","html_url":"https://github.com/dotcmsCodeReview","followers_url":"https://api.github.com/users/dotcmsCodeReview/followers","following_url":"https://api.github.com/users/dotcmsCodeReview/following{/other_user}","gists_url":"https://api.github.com/users/dotcmsCodeReview/gists{/gist_id}","starred_url":"https://api.github.com/users/dotcmsCodeReview/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dotcmsCodeReview/subscriptions","organizations_url":"https://api.github.com/users/dotcmsCodeReview/orgs","repos_url":"https://api.github.com/users/dotcmsCodeReview/repos","events_url":"https://api.github.com/users/dotcmsCodeReview/events{/privacy}","received_events_url":"https://api.github.com/users/dotcmsCodeReview/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/dotCMS/core/milestones/25","html_url":"https://github.com/dotCMS/core/milestones/2.5.7","labels_url":"https://api.github.com/repos/dotCMS/core/milestones/25/labels","id":730683,"number":25,"title":"2.5.7","description":"This may never get released ","creator":{"login":"jtesser","id":1486445,"avatar_url":"https://avatars.githubusercontent.com/u/1486445?v=3","gravatar_id":"","url":"https://api.github.com/users/jtesser","html_url":"https://github.com/jtesser","followers_url":"https://api.github.com/users/jtesser/followers","following_url":"https://api.github.com/users/jtesser/following{/other_user}","gists_url":"https://api.github.com/users/jtesser/gists{/gist_id}","starred_url":"https://api.github.com/users/jtesser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jtesser/subscriptions","organizations_url":"https://api.github.com/users/jtesser/orgs","repos_url":"https://api.github.com/users/jtesser/repos","events_url":"https://api.github.com/users/jtesser/events{/privacy}","received_events_url":"https://api.github.com/users/jtesser/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":1,"state":"closed","created_at":"2014-07-24T11:23:42Z","updated_at":"2015-07-14T12:46:53Z","due_on":null,"closed_at":"2014-12-23T14:59:00Z"},"comments":2,"created_at":"2014-07-23T17:01:01Z","updated_at":"2015-07-14T12:46:53Z","closed_at":"2015-07-14T12:46:53Z","body":"Steps to reproduce.\r\n\r\n1. Create a clean install of 2.3.2 with an Oracle database. Stop this instance once the DB is completely created.\r\n2. Create a separate 2.5.6 build and point it to the recently created DB in step 1.\r\n3. Start the upgrade.\r\n\r\nProblem was detected here\r\n\r\nhttps://github.com/dotCMS/dotCMS/blob/2.5.6/src/com/dotmarketing/startup/runonce/Task01055CreatePushPublishEnvironmentTable.java#L104\r\n\r\nWe call a DROP SEQUENCE PUBLISHING_QUEUE_SEC twice: on line 102 and line 104. On the second call, query was already executed so it fails.\r\n\r\nStacktrace:\r\n\r\n```\r\n2014-07-23 16:36:42,138 FATAL com.dotmarketing.startup.StartupTasksExecutor - Unable to execute the upgrade task : Task01055CreatePushPublishEnvironmentTable \r\ncom.dotmarketing.exception.DotRuntimeException: ORA-02289: sequence does not exist \r\n\r\nat com.dotmarketing.startup.runonce.Task01055CreatePushPublishEnvironmentTable.executeUpgrade(Task01055CreatePushPublishEnvironmentTable.java:129) \r\nat com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:260) \r\nat com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117) \r\nat org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173) \r\nat org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993) \r\nat org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187) \r\nat org.apache.catalina.core.StandardContext.start(StandardContext.java:4496) \r\nat org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) \r\nat org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) \r\nat org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546) \r\nat org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637) \r\nat org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563) \r\nat org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498) \r\nat org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277) \r\nat org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321) \r\nat org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) \r\nat org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) \r\nat org.apache.catalina.core.StandardHost.start(StandardHost.java:785) \r\nat org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) \r\nat org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) \r\nat org.apache.catalina.core.StandardService.start(StandardService.java:519) \r\nat org.apache.catalina.core.StandardServer.start(StandardServer.java:710) \r\nat org.apache.catalina.startup.Catalina.start(Catalina.java:581) \r\nat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) \r\nat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) \r\nat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) \r\nat java.lang.reflect.Method.invoke(Method.java:606) \r\nat org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) \r\nat org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) \r\nCaused by: java.sql.SQLException: ORA-02289: sequence does not exist \r\n\r\nat oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) \r\nat oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) \r\nat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) \r\nat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) \r\nat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) \r\nat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) \r\nat oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) \r\nat oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936) \r\nat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) \r\nat oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) \r\nat oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) \r\nat oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298) \r\nat org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) \r\nat com.dotmarketing.common.db.DotConnect.executeStatement(DotConnect.java:214) \r\nat com.dotmarketing.startup.runonce.Task01055CreatePushPublishEnvironmentTable.recreatePublishingQueueTable(Task01055CreatePushPublishEnvironmentTable.java:104) \r\nat com.dotmarketing.startup.runonce.Task01055CreatePushPublishEnvironmentTable.executeUpgrade(Task01055CreatePushPublishEnvironmentTable.java:125) \r\n... 28 more \r\n```"}}