Comments (3)
The failure was due to incorrect username / password in application.properties. After correction the import succeeded. However, the status code returned from the process execution should be checked, and an error message should be output to the user if the mysql program exits with a non-zero status code. [Or .. we should adjust the code to do true database interactions instead of the external .sql scripts]
from g2s.
I also added the exit status ;)
from g2s.
Exit status checks are working, but the program is continuing execution after the error is detected.
I modified the database creation script to have an incorrect fieldname in the pdb_ensembl_alignment table. Then I ran:
java -jar -Xmx7000m pdb-alignment-pipeline/target/pdb-alignment-pipeline-0.1.0.jar init
The output is below. An insert script was generated, failed to execute, an error condition was reported on the console and in the log, but the program continued to execute. If the execution of any insert script execution fails, the program should stop at that point, without deleting the insert script or doing any other processing. It should report that it stopped because of an error during <description_of_stage_of_processing>.
2016-08-12 18:05:32 INFO PdbScriptsPipelineMakeSQL:123 - [BLAST] Insert statements after parsing 0th xml : 26706
2016-08-12 18:05:32 INFO CommandProcessUtil:138 - [MYSQL] Running mysql command insert /Users/sheridar/repos/sheridancbio/pdb-annotation/pdb-alignment-pipeline/src/main/resources/pdb.sql...
2016-08-12 18:05:32 INFO CommandProcessUtil:158 - [SHELL] Command mysql completed
2016-08-12 18:05:32 INFO CommandProcessUtil:138 - [MYSQL] Running mysql command insert /Users/sheridar/repos/sheridancbio/pdb-annotation/gsoc_3d_testing/insert_Ensembl.sql...
2016-08-12 18:05:33 INFO CommandProcessUtil:158 - [SHELL] Command mysql completed
2016-08-12 18:05:33 INFO CommandProcessUtil:138 - [MYSQL] Running mysql command insert /Users/sheridar/repos/sheridancbio/pdb-annotation/gsoc_3d_testing/insert.sql.0...
2016-08-12 18:05:33 ERROR CommandProcessUtil:27 - [Process] Process Error in mysql:java.lang.UNIXProcess@159d944f
2016-08-12 18:05:33 ERROR CommandProcessUtil:33 - [Process] Error: 109 121 115 113 108 58 32 91 87 97 114 110 105 110 103 93 32 85 115 105 110 103 32 97 32 112 97 115 115 119 111 114 100 32 111 110 32 116 104 101 32 99 111 109 109 97 110 100 32 108 105 110 101 32 105 110 116 101 114 102 97 99 101 32 99 97 110 32 98 101 32 105 110 115 101 99 117 114
2016-08-12 18:05:33 INFO CommandProcessUtil:158 - [SHELL] Command mysql completed
2016-08-12 18:05:33 INFO PdbScriptsPipelineRunCommand:171 - [PIPELINE] Start cleaning up in filesystem
2016-08-12 18:05:33 INFO CommandProcessUtil:126 - [SHELL] Gzip file from /Users/sheridar/repos/sheridancbio/pdb-annotation/gsoc_3d_testing/insert_Ensembl.sql ...
2016-08-12 18:05:33 INFO CommandProcessUtil:158 - [SHELL] Command gzip completed
2016-08-12 18:05:33 INFO CommandProcessUtil:126 - [SHELL] Gzip file from /Users/sheridar/repos/sheridancbio/pdb-annotation/gsoc_3d_testing/insert.sql.0 ...
2016-08-12 18:05:33 INFO CommandProcessUtil:158 - [SHELL] Command gzip completed
2016-08-12 18:05:33 INFO CommandProcessUtil:147 - [SHELL] Running rm command at/Users/sheridar/repos/sheridancbio/pdb-annotation/gsoc_3d_testing/pdb_seqres_50000.xml.0...
2016-08-12 18:05:33 INFO CommandProcessUtil:158 - [SHELL] Command rm completed
2016-08-12 18:05:33 INFO PdbScriptsPipelineStarter:85 - [Pipeline] Pipeline Successfully Ended. The Execution time is 382.467 seconds
from g2s.
Related Issues (20)
- PdbScriptsPipelineMakeSQL.java should be improved if we are keeping it HOT 2
- typo in PdbScriptsPipelineRunCommand.java (dataVesrsion) HOT 2
- runwithRedirectFrom() call needs error checking and output stream handling HOT 3
- PdbScriptsPipelineRunCommand.java is too big HOT 1
- Does the "updateweekly" mode work correctly currently? HOT 1
- Rewording some messages HOT 1
- gzip external process for insert archiving is broken HOT 1
- Rev2: changes to the gsoc project completion wiki page HOT 1
- Web API does not report exceptions
- change front page text
- Clean up endpoints
- support genome build version in ID instead of id_type
- adding new query sequences dynamically
- Deploy beta to production
- support querying dbsnp
- add page parameters to api endpoints HOT 3
- Support only Human Uniprot and remove alignment limitation of 50
- Add POST of bulk query using genome nexus POST
- mapping issues from genomic to pdb
- Repo still alive?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from g2s.