[CRUC-7721] Backup of Oracle DB fails due to unknown type TIMESTAMP (93)

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 4.0.4, 4.1.0
Affects Version/s: 4.0.0, 4.0.1, 4.0.2, 4.0.3
Component/s: Server administration
Labels:
- backup
- database
- oracle
- warranty

Bug Fix Policy:
View Atlassian Server bug fix policy

DB backup

When we try to backup FishEye with an Oracle DB, we fail on unsupported TIMESTAMP (93) type:

2016-04-08 15:30:33,220 INFO  [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - 245 rows written, 41 of 76 tables completed.
2016-04-08 15:30:33,223 INFO  [ThreadPool2 ] fisheye HibernateUtil-makeWritable - DB going writable.
2016-04-08 15:30:33,224 WARN  [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
2016-04-08 15:30:33,224 INFO  [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Backup failed
2016-04-08 15:30:33,224 WARN  [ThreadPool2 ] fisheye BackupManagerImpl$2-run - Backup failed.
java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
        at com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:82) [fisheye.jar:?]
        at com.atlassian.crucible.migration.BackupManagerImpl.createBackup(BackupManagerImpl.java:264) [fisheye.jar:?]
        at com.atlassian.crucible.migration.BackupManagerImpl.access$000(BackupManagerImpl.java:55) [fisheye.jar:?]
        at com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:153) [fisheye.jar:?]
        at com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:151) [fisheye.jar:?]
        at com.atlassian.crucible.maintenance.MaintenanceManager.doMaintenance(MaintenanceManager.java:111) [fisheye.jar:?]
        at com.atlassian.crucible.migration.BackupManagerImpl$2.run(BackupManagerImpl.java:151) [fisheye.jar:?]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_60]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_60]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_60]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_60]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60]
        at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60]
Caused by: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
        at com.atlassian.crucible.migration.item.DBExporter.throwCantEncodeJdbcType(DBExporter.java:343) [fisheye.jar:?]
        at com.atlassian.crucible.migration.item.DBExporter.access$400(DBExporter.java:35) [fisheye.jar:?]
        at com.atlassian.crucible.migration.item.DBExporter$OracleColumnExporter.export(DBExporter.java:297) [fisheye.jar:?]
        at com.atlassian.crucible.migration.item.DBExporter.exportRow(DBExporter.java:355) [fisheye.jar:?]
        at com.atlassian.crucible.migration.item.DBExporter.exportTable(DBExporter.java:164) [fisheye.jar:?]
        at com.atlassian.crucible.migration.item.DBExporter.exportData(DBExporter.java:103) [fisheye.jar:?]
        at com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:69) [fisheye.jar:?]
        ... 13 more

DB migration

Broken backup means also broken DB migration. When current DB type is Oracle and I try to move to Postgres, the migration fails:

Started
Starting ActiveObjects backup...
* Backing up Database Information
* Backing up Table Definitions
** Table count: 5
* Backing up Tables
** Backing up 'AO_2913F5_COMMENT_ISSUE'
** Backing up 'AO_38321B_CUSTOM_CONTENT_LINK'
** Backing up 'AO_8219D4_COMMIT_HOOK_CONFIG'
** Backing up 'AO_A0B856_WEB_HOOK_LISTENER_AO'
** Backing up 'AO_B434B9_WEB_HOOK'
ActiveObjects backup completed!
Dropping existing tables...
Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
Database migration failed: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql
Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql

FishEye instance correctly carries on using the old DB.

is cloned from

FE-6466 Backup of Oracle DB fails due to unknown type TIMESTAMP (93)

Closed

is related to

CRUC-7702 Backup of misconfigured SQL Server DB fails due to unknown type "datetime" (93)

Closed

FE-6521 Backup of misconfigured SQL Server DB fails due to unknown type "datetime" (93)

Closed

mentioned in: Page Failed to load

Form Name

Marek Parfianowicz made changes - 30/May/2019 8:38 PM

Component/s		New: Server administration [ 50891 ]
Component/s	Original: Backup & Restore [ 12831 ]

Owen made changes - 16/Oct/2018 8:14 AM

Workflow

Original: FE-CRUC Bug Workflow [ 2940047 ]

New: JAC Bug Workflow v3 [ 2955503 ]

Owen made changes - 16/Oct/2018 4:40 AM

Workflow

Original: FECRU Development Workflow - Triage - Restricted [ 1515241 ]

New: FE-CRUC Bug Workflow [ 2940047 ]

Owen made changes - 07/Jul/2016 6:36 AM

Workflow

Original: FECRU Development Workflow - Triage [ 1388888 ]

New: FECRU Development Workflow - Triage - Restricted [ 1515241 ]

Cezary Zawadka made changes - 11/May/2016 7:43 AM

Link

New: This issue is related to ~~CRUC-7722~~ [ ~~CRUC-7722~~ ]