[
https://issues.apache.org/jira/browse/TRAFODION-341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah resolved TRAFODION-341.
--------------------------------------
Resolution: Won't Fix
> LP Bug: 1325465 - All Trafodion SQL tables disappeared after recovery
> ---------------------------------------------------------------------
>
> Key: TRAFODION-341
> URL: https://issues.apache.org/jira/browse/TRAFODION-341
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
> Reporter: Marvin Anderson
> Assignee: Sean Broeder
> Priority: Blocker
>
> 1.Running on build 20140529_1530
> 2.Started 10 concurrent connections
> 3.Transactions were random singleton INSERT or singleton UPDATE statements
> followed by COMMIT WORK on table MARVIN1
> 4.Let them run for a little bit watching record count in table
> >>select count(*) from marvin1;
> (EXPR)
> --------------------
> 1004
> --- 1 row(s) selected.
> >>select count(*) from marvin1;
> (EXPR)
> --------------------
> 1051
> --- 1 row(s) selected.
> 5.Turned on test point
> [trafodion@centos-ah1 ~]$ dtm_stall
> Processing cluster.conf on local host centos-ah1
> [$Z000E4W] Shell/shell Version 1.0.1 Release 0.7.0 (Build debug
> [0.7.0rc0-7-g57e0bd3_Bld8], date 20140529_083000)
> [$Z000E4W] %set dtm_stall_phase_2=3
> [$Z000E4W] Configuration Change Notice for Group: CLUSTER Key:
> DTM_STALL_PHASE_2
> 6.waited for all 10 programs to hang on commit
> 7.Killed HMaster and all HBase RegionServers
> [andersma@centos-ah1 ~]$ ./kill_hbase
> ***INFO: killing HMaster and all HBase RegionServer processes
> ***WARNING: This may only work for Ambari/Hortonworks
> 8.Confirmed all HBase processes stopped
> 9.ckillall for Trafodion
> 10.restarted HBbase
> 11.restarted Trafodion after HBase was fully back up
> 12.All Trafodion SQL tables are gone. I had two tables (BIGHERO1 & MARVIN1)
> and only one, MARVIN1, was being used by the programs.
> >>select count(*) from marvin1;
> *** ERROR[4082] Object TRAFODION.SEABASE.MARVIN1 does not exist or is
> inaccessible.
> *** ERROR[8822] The statement was not prepared.
> >>get tables;
> --- SQL operation complete.
> >>
> 13.Although the tables are still in HBase
> hbase(main):001:0> list
> TABLE
>
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/usr/lib/hbase/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.4.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/usr/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> TRAFODION.SEABASE.BIGHERO1
>
> TRAFODION.SEABASE.MARVIN1
>
> TRAFODION._DTM_.TLOG0
>
> TRAFODION._DTM_.TLOG0_CONTROL_POINT
>
> TRAFODION._DTM_.TLOG1
>
> TRAFODION._DTM_.TLOG1_CONTROL_POINT
>
> TRAFODION._DTM_.TLOG2
>
> TRAFODION._DTM_.TLOG2_CONTROL_POINT
>
> TRAFODION._DTM_.TLOG3
>
> TRAFODION._DTM_.TLOG3_CONTROL_POINT
>
> TRAFODION._DTM_.TLOG4
>
> TRAFODION._DTM_.TLOG4_CONTROL_POINT
>
> TRAFODION._DTM_.TLOG5
>
> TRAFODION._DTM_.TLOG5_CONTROL_POINT
>
> TRAFODION._MD_.AUTHS
>
> TRAFODION._MD_.COLUMNS
>
> TRAFODION._MD_.DEFAULTS
>
> TRAFODION._MD_.INDEXES
>
> TRAFODION._MD_.KEYS
>
> TRAFODION._MD_.LIBRARIES
>
> TRAFODION._MD_.LIBRARIES_USAGE
>
> TRAFODION._MD_.OBJECTS
>
> TRAFODION._MD_.OBJECTS_UNIQ_IDX
>
> TRAFODION._MD_.REF_CONSTRAINTS
>
> TRAFODION._MD_.ROUTINES
>
> TRAFODION._MD_.TABLES
>
> TRAFODION._MD_.TABLE_CONSTRAINTS
>
> TRAFODION._MD_.TEXT
>
> TRAFODION._MD_.UNIQUE_REF_CONSTR_USAGE
>
> TRAFODION._MD_.VERSIONS
>
> TRAFODION._MD_.VIEWS
>
> TRAFODION._MD_.VIEWS_USAGE
>
> 32 row(s) in 0.7500 seconds
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
