search

uec / Issue.Tracker

Automatically exported from code.google.com/p/usc-epigenome-center
0 stars 0 forks source link

determine diff between beta and production #750

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
mysql> select geneusID_sample from sequencing_devel_zacktest.view_run_metric 
where sequencing_devel_zacktest.view_run_metric.geneusID_sample not in (select 
geneusID_sample from sequencing_devel_v4.view_run_metric)
    -> ;
+-----------------+
| geneusID_sample |
+-----------------+
| sicon           |
| sigat3          |
| sitcf           |
| SAMPLE1         |
| SRR11048551     |
| SRR11048481     |
| SRR11048561     |
| SRR11048571     |
+-----------------+
8 rows in set (5 min 27.72 sec)

mysql>

Original issue reported on code.google.com by zack...@gmail.com on 29 May 2014 at 8:54

GoogleCodeExporter commented 8 years ago 
ysql> select geneusID_sample, analysis_id from 
sequencing_devel_zacktest.view_run_metric where 
sequencing_devel_zacktest.view_run_metric.geneusID_sample not in (select 
geneusID_sample from sequencing_devel_v4.view_run_metric)
    -> ;
+-----------------+-------------------------------------------------------------
------------------------------------------------------------------+
| geneusID_sample | analysis_id                                                 
                                                                  |
+-----------------+-------------------------------------------------------------
------------------------------------------------------------------+
| sicon           | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/LijingAnalysi
s/RNAseq/results/lijingrna/lijingrna_1_sicon  |
| sigat3          | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/LijingAnalysi
s/RNAseq/results/lijingrna/lijingrna_1_sigat3 |
| sitcf           | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/LijingAnalysi
s/RNAseq/results/lijingrna/lijingrna_1_sitcf  |
| SAMPLE1         | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/ZackTesting/R
NAseq/results/ZACKTEST/ZACKTEST_1_SAMPLE1     |
| SRR11048551     | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/HuyDinh/SRA/r
esults/ramjan/ramjan_1_SRR11048551            |
| SRR11048481     | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/HuyDinh/SRA/r
esults/ramjan/ramjan_1_SRR11048481            |
| SRR11048561     | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/HuyDinh/SRA/r
esults/ramjan/ramjan_1_SRR11048561            |
| SRR11048571     | 
/storage/hpcc/uec-gs1/laird/shared/production/ga/external_analysis/HuyDinh/SRA/r
esults/ramjan/ramjan_1_SRR11048571            |
+-----------------+-------------------------------------------------------------
------------------------------------------------------------------+
8 rows in set (5 min 23.69 sec)

Original comment by zack...@gmail.com on 29 May 2014 at 9:00

GoogleCodeExporter commented 8 years ago 
Beta code and db is moved to production. Starting tomorrow, after tonight's 
update  eccpgxt will use it.

Original comment by natalia....@gmail.com on 3 Jun 2014 at 8:05

GoogleCodeExporter commented 8 years ago

Original comment by zack...@gmail.com on 5 Jun 2014 at 12:01