Project

General

Profile

Actions
Copy link

Bug #247

closed

Databases are getting created without an ApSymmetryTable

Added by Neil Voss over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
High
Assignee:
Amber Herold
Category:
-
Target version:
Appion/Leginon 2.0.0
Start date:
03/25/2010
Due date:
% Done:

100%

Estimated time:
8.00 h
Affected Version:
Show in known bugs:
Workaround:

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

Screen_shot_2010-03-25_at_6.57.34_AM.png (94.1 KB) Screen_shot_2010-03-25_at_6.57.34_AM.png Neil Voss, 03/25/2010 09:23 AM

Related issues 1 (0 open — 1 closed)

Related to Appion - Bug #445: Creating a new database for a project does not work properlyClosedAmber Herold05/10/2010

Actions
Actions
Copy link
 #1

Updated by Neil Voss over 14 years ago

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

Actions
Copy link
 #2

Updated by Neil Voss over 14 years ago

  • 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.

Actions
Copy link
 #3

Updated by Neil Voss over 14 years ago

Now it does not create any tables. I have no way to debug this...

Actions
Copy link
 #4

Updated by Neil Voss over 14 years ago

  • Target version set to Appion/Leginon 2.0.0

Eric you have this finished can you post a link to the SVN revision

Actions
Copy link
 #5

Updated by Eric Hou over 14 years ago

r13374

Actions
Copy link
 #6

Updated by Eric Hou over 14 years ago

  • Status changed from Assigned to In Code Review
  • % Done changed from 0 to 100
  • Estimated time set to 4.00 h
Actions
Copy link
 #7

Updated by Eric Hou over 14 years ago

  • Status changed from In Code Review to In Test
Actions
Copy link
 #8

Updated by Eric Hou over 14 years ago

  • 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

Actions
Copy link
 #9

Updated by Amber Herold over 14 years ago

  • Status changed from In Test to Closed

The table is create but found a new bug #445 while testing this.

Actions
Copy link

Also available in: Atom PDF