0000283: New database schema fails for mysql features reporters

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000283

Rosetta

[All Projects] Crash

public

2013-06-17 05:58

2013-06-17 14:29

Reporter

jwillis0720

Assigned To

delucasl

Priority

high

Severity

major

Reproducibility

always

Status

assigned

Resolution

open

Platform

X86

Linux

OS Version

CentOS

Product Version

Trunk

Fixed in Version

Summary

0000283: New database schema fails for mysql features reporters

Description

Fails on bad foreign key constraint whenever trying to use mysql database features reporter.

So far I have found that it fails for scores and residue type features reporters:

<feature name=ScoreTypeFeatures/>
<feature name=ResidueFeatures/>
<feature name=ResidueTotalScoresFeatures scorefxn=score12/>
<feature name=ResidueScoresFeatures scorefxn=score12/>

Getting this error:
ERROR: cppdb::mysql::Cannot add or update a child row: a foreign key constraint fails (`production_run_no_tys`.`batch_reports`, CONSTRAINT `batch_reports_ibfk_2` FOREIGN KEY (`report_name`) REFERENCES `features_reporters` (`report_name`))
ERROR:: Exit from: src/basic/database/sql_utils.cc line: 553

Steps To Reproduce

Must have mysql server running:

Then a short xml:
<dock_design>
    <SCOREFXNS>
    </SCOREFXNS>
    <FILTERS>
        </FILTERS>
    <TASKOPERATIONS>
    </TASKOPERATIONS>
        <MOVERS>
        <ReportToDB name=features database_mode=mysql database_name="production_run_no_tys" batch_description="primary">
        <feature name=ScoreTypeFeatures/>
        <feature name=ResidueFeatures/>
        <feature name=ResidueTotalScoresFeatures scorefxn=score12/>
         <feature name=ResidueScoresFeatures scorefxn=score12/>
        <feature name=StructureScoresFeatures scorefxn=score12/>
    </ReportToDB>
    </MOVERS>
        <APPLY_TO_POSE>
        </APPLY_TO_POSE>
        <PROTOCOLS>
            <Add mover_name=features/>
        </PROTOCOLS>
</dock_design>

and a flags file:
-parser
    -protocol scoring_to_db.xml
-database path/to/db
-inout:dbms
    -mode mysql
    -host vacseq.mc.vanderbilt.edu
    -user root
    -port 37201
    -password ******
    -database_name production_run_no_tys
-out
    -use_database
-jd2
    -delete_old_poses

Any protein will work.

Additional Information

I have checked this pre_talaris, and post talaris. It is found after the major database scheme changes.

Bug is found in both mpi and regular build.

Tags

database, mysql, rosetta_scripts

Application(s) Affected

rosetta_scripts

Command Line Used

rosetta_scripts.mpimysql and rosetta_scripts.mysql

Developer Options

Confirmed As Bug

Fixed in SVN Version

Attached Files

Relationships

Notes
(0000303) delucasl (Administrator) 2013-06-17 14:28	If you remove these 3 lines: <feature name=ResidueTotalScoresFeatures scorefxn=score12/> <feature name=ResidueScoresFeatures scorefxn=score12/> <feature name=StructureScoresFeatures scorefxn=score12/> From the XML, it works, so its definitely a problem with one of those. I'm swamped right now i'll look, at this again in a few days

Issue History
Date Modified	Username	Field	Change
2013-06-17 05:58	jwillis0720	New Issue
2013-06-17 14:28	jwillis0720	Tag Attached: database
2013-06-17 14:28	jwillis0720	Tag Attached: mysql
2013-06-17 14:28	jwillis0720	Tag Attached: rosetta_scripts
2013-06-17 14:28	jwillis0720	Assigned To	=> delucasl
2013-06-17 14:28	jwillis0720	Status	new => assigned
2013-06-17 14:28	delucasl	Note Added: 0000303
2013-06-17 14:29	delucasl	Developer Options	=> Confirmed As Bug