Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005487
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminoralways2008-10-09 13:272025-01-09 03:52
ReportergforcadaView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version1.6.0_07
OS VersionDatabase version8.2Ant version1.7.0
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005487: Check if database and user exists before cleaning/creating

DescriptionWhile trying to install Openbravo 2.40 I found this:

      [sql] Executing commands
      [sql] Failed to execute: DROP DATABASE openbravo240
      [sql] org.postgresql.util.PSQLException: ERROR: database "openbravo240" does not exist
      [sql] 0 of 1 SQL statements executed successfully

I didn't have used a database named openbravo240 it displays an error while trying to clean it

      [sql] Failed to execute: DROP ROLE tad
      [sql] org.postgresql.util.PSQLException: ERROR: role "tad" cannot be dropped because some objects depend on it
      [sql] Detail: owner of database openbravo
      [sql] 1963 objects in database openbravo
      [sql] 0 of 1 SQL statements executed successfully

prepare.database:

POSTGRE.structure:
      [sql] Executing commands
      [sql] Failed to execute: CREATE ROLE tad LOGIN PASSWORD 'TAD' SUPERUSER CREATEDB CREATEROLE VALID UNTIL 'infinity'
      [sql] org.postgresql.util.PSQLException: ERROR: role "tad" already exists
      [sql] 1 of 2 SQL statements executed successfully

I have a previous installation the user already exists so revoking permissions and creating gives errors.


I mark this issue as minor since this errors doesn't block the installation, but they should be fixed.
Steps To ReproduceCreate a new installation with a new database name and with a previously created postgreSQL user.
Proposed SolutionBefore cleaning the database it should be checked if the database exists.

And before revoking and creating the user it should be checked if the user already exists.
Tagsdbsm_migrate
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0002712 closedmarvintm ant install.source tries to delete role under postgresql 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2008-10-09 13:27 gforcada New Issue
2008-12-06 16:49 jpabloae Relationship added duplicate of 0002712
2008-12-06 16:49 jpabloae Status new => closed
2008-12-06 16:49 jpabloae Duplicate ID 0 => 2712
2008-12-06 16:49 jpabloae Resolution open => duplicate
2008-12-06 16:49 jpabloae Assigned To => jpabloae
2008-12-18 12:38 jpabloae Sticky Issue No => Yes
2008-12-18 12:39 jpabloae Sticky Issue Yes => No
2008-12-18 12:39 jpabloae Tag Attached: dbsm_migrate
2008-12-18 12:41 jpabloae Project @4@ => Openbravo ERP
2008-12-18 12:41 jpabloae Category => Y. DBSourceManager
2008-12-18 12:43 jpabloae Assigned To jpabloae => marvintm
2009-03-18 11:02 anonymous sf_bug_id 0 => 2691355
2024-10-21 05:57 RonnieMRey Note Added: 0170607
2025-01-09 03:52 annajenny Note Added: 0173923

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker