Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005487 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | minor | always | 2008-10-09 13:27 | 2009-03-18 11:02 | |||
| Reporter | gforcada | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | 1.6.0_07 | |||
| OS Version | Database version | 8.2 | Ant version | 1.7.0 | ||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005487: Check if database and user exists before cleaning/creating | |||||||
| Description | While 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 Reproduce | Create a new installation with a new database name and with a previously created postgreSQL user. | |||||||
| Proposed Solution | Before 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. | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |