Bug #247
closed
Databases are getting created without an ApSymmetryTable
Added by Neil Voss over 14 years ago.
Updated over 14 years ago.
Description
I do not know how this is happening, but there are appion databases without an ApSymmetryTable. This table is created when the database is created in the project tools and the values are inserted at that time. This table has fixed values that do not change and are not appended to.
This issue was reported by Becky Taurog (in Jack Johnson's lab) on database ap252. I looked further and noticed that databases ap257 does have it either, but databases ap251, ap253, ap255, and ap256 DO have the table.
Anyone know what is going on?
A good way to test if is missing the Symmetry info is to go to the page: myamiweb/processing/uploadmodel.php. If it works you will have a drop down list to select the symmetry if not you get an empty list.
Files
I've inserted a ApSymmetryData table for databases ap252 and ap257. Becky should be up and running, but we need to figure out how this happened.
Method to create table:
mysqldump -h cronus4 -u usr_object ap218 --tables ApSymmetryData > symdata.sql
mysql -h cronus4 -u usr_object ap252 < symdata.sql
mysql -h cronus4 -u usr_object ap256 < symdata.sql
- Status changed from New to Assigned
- Assignee set to Eric Hou
- Priority changed from Normal to High
This happened again on March 30. I created a processing DB using the myamiweb code and no ApSymmetryTable was created for ap262.
Now it does not create any tables. I have no way to debug this...
- Target version set to Appion/Leginon 2.0.0
Eric you have this finished can you post a link to the SVN revision
- Status changed from Assigned to In Code Review
- % Done changed from 0 to 100
- Estimated time set to 4.00 h
- Status changed from In Code Review to In Test
- Assignee changed from Eric Hou to Amber Herold
- Estimated time changed from 4.00 h to 8.00 h
To test this, create new ap database from web tool project section.
You should see ApSymmetryData table in that database.
Please remove the new database you created after you test. otherwise we will have too many unnecessary database in the server.
Thanks.
Eric
- Status changed from In Test to Closed
The table is create but found a new bug #445 while testing this.
Also available in: Atom
PDF
