[prev in list] [next in list] [prev in thread] [next in thread]
List: sonar-user
Subject: Re: [sonar-user] Error upgrading to 3.1 from 3.0.1
From: "Larry Shatzer, Jr." <larrys () gmail ! com>
Date: 2012-06-28 14:00:12
Message-ID: CAPr6TnS=pWVJ-F4BhCLZE7fer-3V7cRWpdVBp_mQbedMm2PjDg () mail ! gmail ! com
[Download RAW message or body]
Upgrade went smooth now. That check for multiple jdbc drivers probably
should happen sooner (before the upgrade) if possible to avoid this issue
in the future and alert the admin of the potential problem.
-- Larry
On Wed, Jun 27, 2012 at 1:30 PM, Larry Shatzer, Jr. <larrys@gmail.com>wrote:
> Oops, I checked the older version's directory. Now I see both. My copy
> command I used to copy over the extensions directory copied the jdbc driver
> again, and it looks like you upgraded jdbc drivers. I'll be more careful in
> copying over the stuff in extensions in the future.
>
> I'll test my upgrade again soon and let you know.
>
>
> On Wed, Jun 27, 2012 at 12:57 PM, Freddy Mallet <freddy.mallet@gmail.com>wrote:
>
> > Hi Larry,
> >
> > I've double checked the Sonar source code and this exception can occur in
> > only one case: you do have several jar files in
> > this /opt/sonar/sonar-3.1/extensions/jdbc-driver/mysql directory. One
> > possible explanation is that one of them is a hidden file starting with the
> > "." character.
> >
> > Kind regards,
> > Freddy
> >
> > -----
> > twitter.com/FreddyMallet
> > Sonar for Continuous Inspection
> >
> >
> >
> > On Tue, Jun 26, 2012 at 6:38 PM, Larry Shatzer, Jr. <larrys@gmail.com>wrote:
> >
> > > Any other thoughts on this? I'm working through some other issues on
> > > other things, so I've not had a chance to try this again from scratch with
> > > a copy of my production version of Sonar.
> > >
> > >
> > > On Thu, Jun 21, 2012 at 7:51 AM, Larry Shatzer, Jr. <larrys@gmail.com>wrote:
> > >
> > > > Freddy,
> > > >
> > > > I tried to restart it and only got the error about multiple jdbc
> > > > drivers, no hibernate error about concurrent modification.
> > > >
> > > > I always extract to a new directory, copy over sonar.properties, and
> > > > copy over the plugins and stuff inside of extensions that needs to be
> > > > copied.
> > > >
> > > > Thanks,
> > > >
> > > > Larry
> > > >
> > > >
> > > > On Thu, Jun 21, 2012 at 6:56 AM, Freddy Mallet <freddy.mallet@gmail.com
> > > > > wrote:
> > > >
> > > > > Hi Larry,
> > > > >
> > > > > Do you encounter those two same issues each time you relaunch the
> > > > > Sonar server ?
> > > > >
> > > > > Do you confirm that you're using the Sonar server standalone one and
> > > > > that you've installed Sonar 3.1 in a fully new directory ?
> > > > >
> > > > > thanks
> > > > > Freddy
> > > > > -----
> > > > > twitter.com/FreddyMallet
> > > > > Sonar for Continuous Inspection
> > > > >
> > > > >
> > > > >
> > > > > On Wed, Jun 20, 2012 at 4:41 PM, Larry Shatzer, Jr. \
> > > > > <larrys@gmail.com>wrote:
> > > > > > Got past the migrations, but Hibernate is throwing an exception when
> > > > > > initialized:
> > > > > >
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | == AddGlobalToDashboards:
> > > > > > migrating ==========================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | -- add_column("dashboards",
> > > > > > "is_global", :boolean)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | -> 0.1660s
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | -> 7 rows
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | == AddGlobalToDashboards:
> > > > > > migrated (0.1700s) =================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 |
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | == AddResourceIdToWidgets:
> > > > > > migrating =========================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | -- add_column("widgets",
> > > > > > "resource_id", :integer, {:null=>true})
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | -> 0.0100s
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | -> 57 rows
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | == AddResourceIdToWidgets:
> > > > > > migrated (0.0110s) ================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 |
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:09 | ==
> > > > > > CreateGlobalDashboardsForFilter: migrating \
> > > > > > ================================ INFO | jvm 1 | 2012/06/20 08:26:10 \
> > > > > > | -- drop_table("active_filters")
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -> 0.0040s
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -> 0 rows
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | ==
> > > > > > CreateGlobalDashboardsForFilter: migrated (1.4130s) \
> > > > > > ======================= INFO | jvm 1 | 2012/06/20 08:26:10 |
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | == AddReviewData:
> > > > > > migrating ==================================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -- add_column("reviews",
> > > > > > "data", :string, {:null=>true, :limit=>4000})
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -> 0.0460s
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -> 104 rows
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | == AddReviewData: migrated
> > > > > > (0.0460s) =========================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 |
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | == AddKeyToFilters:
> > > > > > migrating ================================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -- add_column("filters",
> > > > > > "kee", :string, {:null=>true, :limit=>100})
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -> 0.0090s
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:10 | -> 12 rows
> > > > > > 2012.06.20 08:26:11 INFO org.sonar.INFO Start components...
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 | == AddKeyToFilters:
> > > > > > migrated (0.8120s) =======================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 |
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 | == IgnoreLoadedFilters:
> > > > > > migrating ============================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 | == IgnoreLoadedFilters:
> > > > > > migrated (0.0170s) ===================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 |
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 | == IgnoreLoadedDashboards:
> > > > > > migrating =========================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 | == IgnoreLoadedDashboards:
> > > > > > migrated (0.0070s) ================================
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:11 |
> > > > > > 2012.06.20 08:26:11 INFO o.s.j.s.AbstractDatabaseConnector
> > > > > > Initializing Hibernate
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | 2012-06-20
> > > > > > 08:26:14.057:WARN::/setup
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 |
> > > > > > java.util.ConcurrentModificationException
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > java.util.AbstractList$Itr.next(AbstractList.java:343)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > java.util.Collections$UnmodifiableCollection$1.next(Collections.java:1010)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.picocontainer.DefaultPicoContainer.getComponentAdapters(DefaultPicoContainer.java:423)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.picocontainer.DefaultPicoContainer.getComponentAdapters(DefaultPicoContainer.java:414)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.picocontainer.DefaultPicoContainer.getComponentAdapter(DefaultPicoContainer.java:377)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.picocontainer.DefaultPicoContainer.getComponentAdapter(DefaultPicoContainer.java:366)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:645)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:671)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.sonar.api.platform.ComponentContainer.getComponentByType(ComponentContainer.java:113)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.sonar.server.ui.DatabaseSessionFilter.doFilter(DatabaseSessionFilter.java:36)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:78)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:131)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.Server.handle(Server.java:326)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
> > > > > > INFO | jvm 1 | 2012/06/20 08:26:14 | at
> > > > > > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
> > > > > >
> > > > > >
> > > > > >
> > > > > > Then it continues to try to load Sonar, and I get this:
> > > > > >
> > > > > > 2012.06.20 08:26:39 INFO org.sonar.INFO Activate default profile
> > > > > > for java
> > > > > > 2012.06.20 08:26:39 ERROR o.s.s.p.Platform The directory
> > > > > > /opt/sonar/sonar-3.1/extensions/jdbc-driver/mysql accepts only a single \
> > > > > > JAR file
> > > > > > org.sonar.server.platform.ServerStartException: The directory
> > > > > > /opt/sonar/sonar-3.1/extensions/jdbc-driver/mysql accepts only a single \
> > > > > > JAR file
> > > > > > at
> > > > > > org.sonar.server.platform.DefaultServerFileSystem.getJdbcDriver(DefaultServerFileSystem.java:138)
> > > > > > ~[classes/:na]
> > > > > > at
> > > > > > org.sonar.server.startup.JdbcDriverDeployer.start(JdbcDriverDeployer.java:37)
> > > > > > ~[classes/:na]
> > > > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > Method) ~[na:1.6.0_15]
> > > > > > at
> > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > > > > > ~[na:1.6.0_15]
> > > > > > at
> > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > > > > > ~[na:1.6.0_15]
> > > > > > at java.lang.reflect.Method.invoke(Method.java:597)
> > > > > > ~[na:1.6.0_15]
> > > > > > at
> > > > > > org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at org.picocontainer.behaviors.Stored.start(Stored.java:110)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1009)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1002)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:760)
> > > > > > ~[picocontainer-2.14.1.jar:na]
> > > > > > at
> > > > > > org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:70)
> > > > > > ~[sonar-plugin-api-3.1.jar:na]
> > > > > > at
> > > > > > org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:244)
> > > > > > ~[classes/:na]
> > > > > > at
> > > > > > org.sonar.server.platform.Platform.start(Platform.java:120) \
> > > > > > ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > Method) ~[na:1.6.0_15]
> > > > > > at
> > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > > > > > ~[na:1.6.0_15]
> > > > > > [snip]
> > > > > >
> > > > > > And looking in the jdbc-driver directory I only see one jar!
> > > > > >
> > > > > >
> > > > > > On Wed, Jun 20, 2012 at 2:53 AM, Freddy Mallet <
> > > > > > freddy.mallet@gmail.com> wrote:
> > > > > >
> > > > > > > Indeed Larry, by removing this row in the active_filters table, the
> > > > > > > problem should vanish. I don't known how this is possible to be in such
> > > > > > > context but I've created a JIRA ticket to prevent encountering this \
> > > > > > > issue during migration : http://jira.codehaus.org/browse/SONAR-3594.
> > > > > > >
> > > > > > > Kind regards,
> > > > > > > Freddy
> > > > > > > -----
> > > > > > > twitter.com/FreddyMallet
> > > > > > > Sonar for Continuous Inspection
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > On Tue, Jun 19, 2012 at 12:50 AM, Larry Shatzer, Jr. <
> > > > > > > larrys@gmail.com> wrote:
> > > > > > >
> > > > > > > > I get the following when trying to upgrade from 3.0.1 to 3.1
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | ==
> > > > > > > > AddGlobalToDashboards: migrating
> > > > > > > > ==========================================
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | --
> > > > > > > > add_column("dashboards", "is_global", :boolean)
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | -> 0.1460s
> > > > > > > >
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | -> 7 rows
> > > > > > > >
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | ==
> > > > > > > > AddGlobalToDashboards: migrated (0.1510s)
> > > > > > > > =================================
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 |
> > > > > > > >
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | ==
> > > > > > > > AddResourceIdToWidgets: migrating
> > > > > > > > =========================================
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | -- add_column("widgets",
> > > > > > > > "resource_id", :integer, {:null=>true})
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | -> 0.0110s
> > > > > > > >
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | -> 57 rows
> > > > > > > >
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | ==
> > > > > > > > AddResourceIdToWidgets: migrated (0.0110s)
> > > > > > > > ================================
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 |
> > > > > > > >
> > > > > > > >
> > > > > > > > INFO | jvm 1 | 2012/06/18 16:31:53 | ==
> > > > > > > > CreateGlobalDashboardsForFilter: migrating
> > > > > > > > ================================
> > > > > > > > 2012.06.18 16:31:54 ERROR o.s.s.ui.JRubyFacade Fail to render:
> > > > > > > > http://sonar.company.com:9000/setup/setup_database
> > > > > > > >
> > > > > > > > An error has occurred, all later migrations canceled:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Couldn't find CreateGlobalDashboardsForFilter::Filter with ID=19
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:1586:in
> > > > > > > > `find_one'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:1569:in
> > > > > > > > `find_from_ids'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:616:in
> > > > > > > > `find'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/db/migrate/302_create_global_dashboards_for_filter.rb:81:in
> > > > > > > > `activate_dashboards'
> > > > > > > > org/jruby/RubyArray.java:1602:in `each'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/db/migrate/302_create_global_dashboards_for_filter.rb:80:in
> > > > > > > > `activate_dashboards'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/db/migrate/302_create_global_dashboards_for_filter.rb:46:in
> > > > > > > > `up'
> > > > > > > > org/jruby/RubyKernel.java:2052:in `send'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:282:in
> > > > > > > > `migrate'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:293:in
> > > > > > > > `measure'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:282:in
> > > > > > > > `migrate'
> > > > > > > > org/jruby/RubyKernel.java:2056:in `send'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:365:in
> > > > > > > > `migrate'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:486:in
> > > > > > > > `migrate'
> > > > > > > > org/jruby/RubyProc.java:268:in `call'
> > > > > > > >
> > > > > > > >
> > > > > > > > org/jruby/RubyProc.java:228:in `call'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:562:in
> > > > > > > > `ddl_transaction'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:485:in
> > > > > > > > `migrate'
> > > > > > > > org/jruby/RubyArray.java:1602:in `each'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:472:in
> > > > > > > > `migrate'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:400:in
> > > > > > > > `up'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:383:in
> > > > > > > > `migrate'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/database_version.rb:63:in
> > > > > > > > `upgrade_and_start'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/app/models/database_migration_manager.rb:109:in
> > > > > > > > `start_migration'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/app/controllers/setup_controller.rb:46:in
> > > > > > > > `setup_database'
> > > > > > > > org/jruby/RubyKernel.java:2052:in `send'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in
> > > > > > > > `perform_action'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in
> > > > > > > > `call_filters'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in
> > > > > > > > `perform_action_with_filters'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in
> > > > > > > > `perform_action_with_benchmark'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in
> > > > > > > > `ms'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:308:in
> > > > > > > > `realtime'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in
> > > > > > > > `ms'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in
> > > > > > > > `perform_action_with_benchmark'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in
> > > > > > > > `perform_action_with_rescue'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in
> > > > > > > > `perform_action_with_flash'
> > > > > > > > org/jruby/RubyKernel.java:2052:in `send'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:532:in
> > > > > > > > `process'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in
> > > > > > > > `process_with_filters'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:391:in
> > > > > > > > `process'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:386:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in
> > > > > > > > `dispatch'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in
> > > > > > > > `_call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in
> > > > > > > > `build_middleware_stack'
> > > > > > > > org/jruby/RubyProc.java:268:in `call'
> > > > > > > >
> > > > > > > >
> > > > > > > > org/jruby/RubyProc.java:228:in `call'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in
> > > > > > > > `cache'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in
> > > > > > > > `cache'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/head.rb:9:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/methodoverride.rb:24:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/session_store.rb:42:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/adapter/rails.rb:36:in
> > > > > > > > `serve_rails'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/adapter/rails.rb:41:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/rails.rb:185:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > > file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/handler/servlet.rb:19:in
> > > > > > > > `call'
> > > > > > > >
> > > > > > > >
> > > > > > > > I looked in the database and in active_filters I have a row that
> > > > > > > > has filter_id of 19, but there is no filter defined with an id of 19. \
> > > > > > > > Do I just delete this row and try again? Also, are there any other \
> > > > > > > > checks/select statements to find similar issues?
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
[Attachment #3 (text/html)]
Upgrade went smooth now. That check for multiple jdbc drivers probably should happen \
sooner (before the upgrade) if possible to avoid this issue in the future and alert \
the admin of the potential problem.<div><br></div><div>
-- Larry<br><br><div class="gmail_quote">On Wed, Jun 27, 2012 at 1:30 PM, Larry \
Shatzer, Jr. <span dir="ltr"><<a href="mailto:larrys@gmail.com" \
target="_blank">larrys@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Oops, I checked the older version's directory. Now I see \
both. My copy command I used to copy over the extensions directory copied the jdbc \
driver again, and it looks like you upgraded jdbc drivers. I'll be more careful \
in copying over the stuff in extensions in the future.<div>
<br></div><div>I'll test my upgrade again soon and let you know.<div><div \
class="h5"><br><br><div class="gmail_quote">On Wed, Jun 27, 2012 at 12:57 PM, Freddy \
Mallet <span dir="ltr"><<a href="mailto:freddy.mallet@gmail.com" \
target="_blank">freddy.mallet@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi Larry,<div><br></div><div>I've double checked the \
Sonar source code and this exception can occur in only one case: you do have several \
jar files in this /opt/sonar/sonar-3.1/extensions/jdbc-driver/mysql directory. One \
possible explanation is that one of them is a hidden file starting with the \
"." character. </div>
<div><br></div><div>Kind regards,</div><div>Freddy</div><div><div><br \
clear="all"><div><span \
style="font-size:13px;font-family:arial,sans-serif">-----</span></div><div><a \
href="https://twitter.com/FreddyMallet" style="font-family:arial,sans-serif" \
target="_blank">twitter.com/FreddyMallet</a></div>
<div><span>Sonar for Continuous Inspection</span></div><br>
<br><br></div><div><div><div class="gmail_quote">On Tue, Jun 26, 2012 at 6:38 PM, \
Larry Shatzer, Jr. <span dir="ltr"><<a href="mailto:larrys@gmail.com" \
target="_blank">larrys@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Any other thoughts on this? I'm working through some \
other issues on other things, so I've not had a chance to try this again from \
scratch with a copy of my production version of Sonar.<div><div> <br><br><div \
class="gmail_quote"> On Thu, Jun 21, 2012 at 7:51 AM, Larry Shatzer, Jr. <span \
dir="ltr"><<a href="mailto:larrys@gmail.com" \
target="_blank">larrys@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
Freddy,<div><br></div><div>I tried to restart it and only got the error about \
multiple jdbc drivers, no hibernate error about concurrent \
modification.<div><br></div><div>I always extract to a new directory, copy over \
sonar.properties, and copy over the plugins and stuff inside of extensions that needs \
to be copied.</div>
<div><br></div><div>Thanks,</div><div><br></div><div>Larry<div><div><br><br><div \
class="gmail_quote">On Thu, Jun 21, 2012 at 6:56 AM, Freddy Mallet <span \
dir="ltr"><<a href="mailto:freddy.mallet@gmail.com" \
target="_blank">freddy.mallet@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi Larry,<div><br></div><div>Do you encounter those two same \
issues each time you relaunch the Sonar server ? </div><div>
<br></div><div>Do you confirm that you're using the Sonar server standalone one \
and that you've installed Sonar 3.1 in a fully new directory ?</div> \
<div><br></div><div>thanks</div><div><div>Freddy<br clear="all"><div><span \
style="font-size:13px;font-family:arial,sans-serif">-----</span></div><div><a \
href="https://twitter.com/FreddyMallet" style="font-family:arial,sans-serif" \
target="_blank">twitter.com/FreddyMallet</a></div>
<div><span>Sonar for Continuous Inspection</span></div><br>
<br><br></div><div><div><div class="gmail_quote">On Wed, Jun 20, 2012 at 4:41 PM, \
Larry Shatzer, Jr. <span dir="ltr"><<a href="mailto:larrys@gmail.com" \
target="_blank">larrys@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Got past the migrations, but Hibernate is throwing an \
exception when initialized:<div><br></div><div><div>INFO | jvm 1 | 2012/06/20 \
08:26:09 | == AddGlobalToDashboards: migrating \
==========================================</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:09 | -- add_column("dashboards", \
"is_global", :boolean)</div><div>INFO | jvm 1 | 2012/06/20 08:26:09 | \
-> 0.1660s</div><div>INFO | jvm 1 | 2012/06/20 08:26:09 | -> 7 \
rows</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:09 | == AddGlobalToDashboards: migrated \
(0.1700s) =================================</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:09 |</div><div>INFO | jvm 1 | 2012/06/20 08:26:09 | == \
AddResourceIdToWidgets: migrating =========================================</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:09 | -- add_column("widgets", \
"resource_id", :integer, {:null=>true})</div><div>INFO | jvm 1 | \
2012/06/20 08:26:09 | -> 0.0100s</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:09 | -> 57 rows</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:09 | == AddResourceIdToWidgets: migrated \
(0.0110s) ================================</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:09 |</div><div>INFO | jvm 1 | 2012/06/20 08:26:09 | == \
CreateGlobalDashboardsForFilter: migrating ================================</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:10 | -- \
drop_table("active_filters")</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:10 | -> 0.0040s</div><div>INFO | jvm 1 | 2012/06/20 08:26:10 | \
-> 0 rows</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:10 | == CreateGlobalDashboardsForFilter: \
migrated (1.4130s) =======================</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:10 |</div><div>INFO | jvm 1 | 2012/06/20 08:26:10 | == AddReviewData: \
migrating ==================================================</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:10 | -- add_column("reviews", \
"data", :string, {:null=>true, :limit=>4000})</div><div>INFO | jvm \
1 | 2012/06/20 08:26:10 | -> 0.0460s</div><div>
INFO | jvm 1 | 2012/06/20 08:26:10 | -> 104 rows</div><div>INFO | jvm 1 \
| 2012/06/20 08:26:10 | == AddReviewData: migrated (0.0460s) \
=========================================</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:10 |</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:10 | == AddKeyToFilters: migrating \
================================================</div><div>INFO | jvm 1 | \
2012/06/20 08:26:10 | -- add_column("filters", "kee", :string, \
{:null=>true, :limit=>100})</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:10 | -> 0.0090s</div><div>INFO | \
jvm 1 | 2012/06/20 08:26:10 | -> 12 rows</div><div><a \
href="tel:2012.06.20%2008" value="+12012062008" target="_blank">2012.06.20 \
08</a>:26:11 INFO <a href="http://org.sonar.INFO" target="_blank">org.sonar.INFO</a> \
Start components...</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:11 | == AddKeyToFilters: migrated \
(0.8120s) =======================================</div><div>INFO | jvm 1 | \
2012/06/20 08:26:11 |</div><div>INFO | jvm 1 | 2012/06/20 08:26:11 | == \
IgnoreLoadedFilters: migrating ============================================</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:11 | == IgnoreLoadedFilters: migrated \
(0.0170s) ===================================</div><div>INFO | jvm 1 | \
2012/06/20 08:26:11 |</div><div>INFO | jvm 1 | 2012/06/20 08:26:11 | == \
IgnoreLoadedDashboards: migrating =========================================</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:11 | == IgnoreLoadedDashboards: migrated \
(0.0070s) ================================</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:11 |</div><div><a href="tel:2012.06.20%2008" value="+12012062008" \
target="_blank">2012.06.20 08</a>:26:11 INFO o.s.j.s.AbstractDatabaseConnector \
Initializing Hibernate</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | 2012-06-20 \
08:26:14.057:WARN::/setup</div><div>INFO | jvm 1 | 2012/06/20 08:26:14 | \
java.util.ConcurrentModificationException</div><div>INFO | jvm 1 | 2012/06/20 \
08:26:14 | at java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
java.util.AbstractList$Itr.next(AbstractList.java:343)</div><div>INFO | jvm 1 | \
2012/06/20 08:26:14 | at \
java.util.Collections$UnmodifiableCollection$1.next(Collections.java:1010)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.picocontainer.DefaultPicoContainer.getComponentAdapters(DefaultPicoContainer.java:423)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.picocontainer.DefaultPicoContainer.getComponentAdapters(DefaultPicoContainer.java:414)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.picocontainer.DefaultPicoContainer.getComponentAdapter(DefaultPicoContainer.java:377)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.picocontainer.DefaultPicoContainer.getComponentAdapter(DefaultPicoContainer.java:366)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:645)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:671)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.sonar.api.platform.ComponentContainer.getComponentByType(ComponentContainer.java:113)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.sonar.server.ui.DatabaseSessionFilter.doFilter(DatabaseSessionFilter.java:36)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:78)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:131)</div><div>INFO | jvm 1 \
| 2012/06/20 08:26:14 | at \
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.Server.handle(Server.java:326)</div><div>INFO | jvm 1 | \
2012/06/20 08:26:14 | at \
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)</div><div>INFO | \
jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)</div>
<div>INFO | jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)</div><div>INFO \
| jvm 1 | 2012/06/20 08:26:14 | at \
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)</div>
<div><br></div><div><br></div><div><br></div><div>Then it continues to try to load \
Sonar, and I get this:</div><div><br></div><div><div><a href="tel:2012.06.20%2008" \
value="+12012062008" target="_blank">2012.06.20 08</a>:26:39 INFO <a \
href="http://org.sonar.INFO" target="_blank">org.sonar.INFO</a> Activate default \
profile for java</div>
<div><a href="tel:2012.06.20%2008" value="+12012062008" target="_blank">2012.06.20 \
08</a>:26:39 ERROR o.s.s.p.Platform The directory \
/opt/sonar/sonar-3.1/extensions/jdbc-driver/mysql accepts only a single JAR \
file</div>
<div>org.sonar.server.platform.ServerStartException: The directory \
/opt/sonar/sonar-3.1/extensions/jdbc-driver/mysql accepts only a single JAR \
file</div> <div> at \
org.sonar.server.platform.DefaultServerFileSystem.getJdbcDriver(DefaultServerFileSystem.java:138) \
~[classes/:na]</div><div> at \
org.sonar.server.startup.JdbcDriverDeployer.start(JdbcDriverDeployer.java:37) \
~[classes/:na]</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) \
~[na:1.6.0_15]</div><div> at \
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) \
~[na:1.6.0_15]</div><div> at \
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) \
~[na:1.6.0_15]</div>
<div> at java.lang.reflect.Method.invoke(Method.java:597) \
~[na:1.6.0_15]</div><div> at \
org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110) \
~[picocontainer-2.14.1.jar:na]</div>
<div> at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89) \
~[picocontainer-2.14.1.jar:na]</div><div> at \
org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84) \
~[picocontainer-2.14.1.jar:na]</div>
<div> at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169) \
~[picocontainer-2.14.1.jar:na]</div><div> at \
org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132) \
~[picocontainer-2.14.1.jar:na]</div>
<div> at org.picocontainer.behaviors.Stored.start(Stored.java:110) \
~[picocontainer-2.14.1.jar:na]</div><div> at \
org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1009) \
~[picocontainer-2.14.1.jar:na]</div>
<div> at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1002) \
~[picocontainer-2.14.1.jar:na]</div><div> at \
org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:760) \
~[picocontainer-2.14.1.jar:na]</div>
<div> at org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:70) \
~[sonar-plugin-api-3.1.jar:na]</div><div> at \
org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:244) \
~[classes/:na]</div>
<div> at org.sonar.server.platform.Platform.start(Platform.java:120) \
~[classes/:na]</div><div> at \
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_15]</div><div> \
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) \
~[na:1.6.0_15]</div>
</div><div>[snip]</div><div><br></div><div>And looking in the jdbc-driver directory I \
only see one jar!</div><div><div><div><br></div><br><div class="gmail_quote">On Wed, \
Jun 20, 2012 at 2:53 AM, Freddy Mallet <span dir="ltr"><<a \
href="mailto:freddy.mallet@gmail.com" \
target="_blank">freddy.mallet@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Indeed Larry, by removing this row in the active_filters \
table, the problem should vanish. I don't known how this is possible to be in \
such context but I've created a JIRA ticket to prevent encountering this issue \
during migration : <a href="http://jira.codehaus.org/browse/SONAR-3594" \
target="_blank">http://jira.codehaus.org/browse/SONAR-3594</a>. <div>
<br></div><div>Kind regards,</div><div>Freddy<br clear="all"><div><span \
style="font-size:13px;font-family:arial,sans-serif">-----</span></div><div><a \
href="https://twitter.com/FreddyMallet" style="font-family:arial,sans-serif" \
target="_blank">twitter.com/FreddyMallet</a></div>
<div><span>Sonar for Continuous Inspection</span></div><div><div><br>
<br><br><div class="gmail_quote">On Tue, Jun 19, 2012 at 12:50 AM, Larry Shatzer, Jr. \
<span dir="ltr"><<a href="mailto:larrys@gmail.com" \
target="_blank">larrys@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
<div>I get the following when trying to upgrade from 3.0.1 to \
3.1</div><div><br></div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | == \
AddGlobalToDashboards: migrating ========================================== \
</div>
<div>INFO | jvm 1 | 2012/06/18 16:31:53 | -- add_column("dashboards", \
"is_global", :boolean) \
</div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | -> 0.1460s \
</div>
<div>INFO | jvm 1 | 2012/06/18 16:31:53 | -> 7 rows \
</div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | == AddGlobalToDashboards: \
migrated (0.1510s) ================================= \
</div>
<div>INFO | jvm 1 | 2012/06/18 16:31:53 | \
</div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | == AddResourceIdToWidgets: \
migrating ========================================= \
</div>
<div>INFO | jvm 1 | 2012/06/18 16:31:53 | -- add_column("widgets", \
"resource_id", :integer, {:null=>true}) \
</div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | -> 0.0110s \
</div>
<div>INFO | jvm 1 | 2012/06/18 16:31:53 | -> 57 rows \
</div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | == AddResourceIdToWidgets: \
migrated (0.0110s) ================================ \
</div>
<div>INFO | jvm 1 | 2012/06/18 16:31:53 | \
</div><div>INFO | jvm 1 | 2012/06/18 16:31:53 | == \
CreateGlobalDashboardsForFilter: migrating ================================ \
</div>
<div><a href="tel:2012.06.18%2016" value="+12012061816" target="_blank">2012.06.18 \
16</a>:31:54 ERROR o.s.s.ui.JRubyFacade Fail to render: <a \
href="http://sonar.company.com:9000/setup/setup_database" \
target="_blank">http://sonar.company.com:9000/setup/setup_database</a> \
</div>
<div>An error has occurred, all later migrations canceled: \
</div><div> \
</div>
<div>Couldn't find CreateGlobalDashboardsForFilter::Filter with ID=19 \
</div><div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:1586:in \
`find_one' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:1569:in \
`find_from_ids' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:616:in \
`find' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/db/migrate/302_create_global_dashboards_for_filter.rb:81:in \
`activate_dashboards' </div><div> \
org/jruby/RubyArray.java:1602:in `each' \
</div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/db/migrate/302_create_global_dashboards_for_filter.rb:80:in \
`activate_dashboards' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/db/migrate/302_create_global_dashboards_for_filter.rb:46:in \
`up' </div>
<div> org/jruby/RubyKernel.java:2052:in `send' \
</div><div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:282:in \
`migrate' </div>
<div> file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:293:in \
`measure' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:282:in \
`migrate' </div>
<div> org/jruby/RubyKernel.java:2056:in `send' \
</div><div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:365:in \
`migrate' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:486:in \
`migrate' </div><div> \
org/jruby/RubyProc.java:268:in `call' \
</div>
<div> org/jruby/RubyProc.java:228:in `call' \
</div><div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:562:in \
`ddl_transaction' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:485:in \
`migrate' </div><div> \
org/jruby/RubyArray.java:1602:in `each' \
</div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:472:in \
`migrate' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:400:in \
`up' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:383:in \
`migrate' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/database_version.rb:63:in \
`upgrade_and_start' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/app/models/database_migration_manager.rb:109:in \
`start_migration' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/app/controllers/setup_controller.rb:46:in \
`setup_database' </div>
<div> org/jruby/RubyKernel.java:2052:in `send' \
</div><div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in \
`perform_action' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in \
`call_filters' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in \
`perform_action_with_filters' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in \
`perform_action_with_benchmark' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in \
`ms' </div>
<div> file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:308:in \
`realtime' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in \
`ms' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in \
`perform_action_with_benchmark' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in \
`perform_action_with_rescue' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in \
`perform_action_with_flash' </div><div> \
org/jruby/RubyKernel.java:2052:in `send' \
</div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:532:in \
`process' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in \
`process_with_filters' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:391:in \
`process' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:386:in \
`call' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in \
`call' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in \
`dispatch' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in \
`_call' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in \
`build_middleware_stack' </div>
<div> org/jruby/RubyProc.java:268:in `call' \
</div><div> org/jruby/RubyProc.java:228:in `call' \
</div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in \
`call' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in \
`cache' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in \
`cache' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in \
`call' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in \
`call'</div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in \
`call' </div>
<div> file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/head.rb:9:in \
`call' </div><div> \
file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/methodoverride.rb:24:in \
`call' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in \
`call' </div><div> \
file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/session_store.rb:42:in \
`call' </div>
<div> /opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in \
`call' </div><div> \
/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in \
`call' </div>
<div> file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/adapter/rails.rb:36:in \
`serve_rails' </div><div> \
file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/adapter/rails.rb:41:in \
`call' </div>
<div> file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/rails.rb:185:in \
`call' </div><div> \
file:/opt/sonar/sonar-3.1/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/handler/servlet.rb:19:in \
`call' </div>
<div><br></div><div><br></div><div>I looked in the database and in active_filters I \
have a row that has filter_id of 19, but there is no filter defined with an id of 19. \
Do I just delete this row and try again? Also, are there any other checks/select \
statements to find similar issues?</div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></div></div></div>
</blockquote></div><br>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic