#
# Copyrights, SIA CoMinder, http://www.cominder.eu/, 2012-2013
#
# About:  CoMinder SpaceStat bugs and fix status
# 


# ============ Bugs Found ======================
0.55 - not yet 

0.54 
11.11.2012 bug 0.54.01
  Problem: not working code to create constraint: 
    alter table SPACESTAT.SPS_SNAP_DATA
    ***
    (snap_id, dbid, snap_type) references SPACESTAT.SPS_SNAPS_PK on delete cascade
  Solution: reference table, not PK costraint: 
  alter table SPACESTAT.SPS_SNAP_DATA
  ***
  (snap_id, dbid, snap_type) references SPACESTAT.SPS_SNAPS on delete cascade
  Status: fixed in 0.55, fix published in releas notes for 0.54 too. 
  
02.04.2013 bug 0.54.02
  Problem: Sometime can get errors during snap or purge like this:

  /u01/app/cominder/product/db/space_stat/sps_snap.sh: line 31: oraenv: No such file or directory
  /u01/app/cominder/product/db/space_stat/sps_snap.sh: line 38: sqlplus: command not found

  Cause: PATH to oraenv is not set in shell environment
       Note! can be different running in ssh session and cron started jobs
             even if script runner is defined #!/bin/bash
             
  Workaround: set PATH to oraenv in OS user profile
  Solution: check oraenv location is known, if no - check at default location.
  Status: Fixed in 0.55
--  
03.04.2013 bug 0.54.03, reported by Aris Muitinieks
  Problem: if installed from Linux/UNIX sql*plus then can get:
    grant select on V$DATABASE to SPACESTAT
                  *
    ERROR at line 1:
    ORA-02030: can only select from fixed tables/views
  Cause: Unix/Linux treat $ as special symbol
  Workaround: use: grant select on V_$DATABASE to SPACESTAT
              but this is problem if installed via sql*plusw on Windows:
                                *
              ERROR at line 1:
              ORA-00942: table or view does not exist  
  Solution: explicit use "_" as escape character  
            set escape '_';
            grant select on V_$DATABASE to SPACESTAT;
            set escape off
  Status: Fixed in 0.55
--
03.04.2013 bug 0.54.04, reported by Aris Muitinieks
  Problem: snapshoting is not working in 10g+ :
    > SQL> execute SPACESTAT.SPS_MAKE_SNAP('DBS');
    > BEGIN SPACESTAT.SPS_MAKE_SNAP('DBS'); END;
    >
    > *
    > ERROR at line 1:
    > ORA-00001: unique constraint (SPACESTAT.SPS_SNAP_DATA_PK) violated
    > ORA-06512: at "SPACESTAT.SPS_SNAP_SEGMENTS", line 3
    > ORA-06512: at "SPACESTAT.SPS_MAKE_SNAP", line 24
    > ORA-06512: at line 1
  Cause: 0.54 version was not supporting databases with partitions used.
              In 10g+ regardless of partitions used by user objects
              there are some used by RDBMS internally. In 9i there was too, 
              but really had only 1 partition per segment (at least on no-RAC DB)
  Root Cause: Developer of SpaceStat had not tested in 10g+ environment.
  Solution: re-create index and constraint to include PARTITION_NAME field
  Status: Fixed in 0.55                   

              
------------
0.53
07.08.2012 bug.0.53.1 
      Problem: Wrong "create table SPACESTAT.SPS_VERSION" in published version was missing some symbols 
      Status:  Fixed in 0.54, fix for 0.53 published in 0.53 Release Notes doc.