jira.codehaus.org

  • Log In Access more options
    • Online Help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What?s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Sonar
  • SONAR-160

Database migration fails from v1.0.2 to v1.1-beta1

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.1
  • Fix Version/s: 1.1
  • Component/s: None
  • Labels:
    None
  • Environment:
    Oracle 10g Rel.2

Description

After migrating from Sonar v1.0.2 to v1.1-beta1 like explained in the docs, I run the Sonar plugin ("mvn org.codehaus.sonar:sonar-maven-plugin:1.1-beta1:sonar") and received the following exception:

[ERROR] Cannot execute the command org.codehaus.sonar:sonar-core-maven-plugin:1.1-beta1:collect
org.apache.maven.lifecycle.LifecycleExecutionException: DB model exception occured
[...]
Caused by: org.hibernate.HibernateException: Wrong column type: created_at, expected: timestamp

Reason is probably that the "snapshots" and "snapshot_groups" tables have a column "created_at" of type "date". After changing these two columns (see SQL statement below) everything worked fine...

alter table snapshot_groups modify created_at timestamp(6);
alter table snapshots modify created_at timestamp(6);

(note that I am running Sonar on a Oracle 10g database)

  • Options
    • Sort By Name
    • Sort By Date
    • Ascending
    • Descending
    • Download All

Attachments

  1. Text File
    stacktrace.txt
    31/Jan/08 3:48 AM
    5 kB
    Martin Ehrnhoefer

Activity

  • All
  • Comments
  • Work Log
  • History
  • Activity
Hide
Permalink
Simon Brandhof added a comment - 20/Feb/08 8:16 AM

Fixed. I rename the ticket because we experimented another problem during 1.1 migration.

Show
Simon Brandhof added a comment - 20/Feb/08 8:16 AM Fixed. I rename the ticket because we experimented another problem during 1.1 migration.

People

  • Assignee:
    Simon Brandhof
    Reporter:
    Martin Ehrnhoefer
Vote (0)
Watch (0)

Dates

  • Created:
    31/Jan/08 3:48 AM
    Updated:
    21/Feb/08 2:05 PM
    Resolved:
    20/Feb/08 8:16 AM
  • Atlassian JIRA (v5.0.4#731-sha1:3aa7374)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.