Project

General

Profile

Activity

From 06/30/2012 to 07/29/2012

07/20/2012

06:32 AM Task #424: Finish translating XML functions to SQL functions for column-based import
Core XML functions have been translated.
Sandboxing has been added to allow SQL functions to throw exceptions.
Aaron Marcuse-Kubitza
06:31 AM Task #378: create automated feedback mechanism
SQL function errors are now also saved using this mechanism. Aaron Marcuse-Kubitza

07/19/2012

05:56 PM Task #446 (New): fix deadlock in INSERT IGNORE replacement
h3. Possible solutions
# -retry query on TransactionRollbackError-: _done, but doesn't fix the underlying problem ...
Aaron Marcuse-Kubitza

07/17/2012

03:58 PM Task #443 (Resolved): back up staging tables
They have now been backed up as part of the full DB backup[1].
fn1. @make backups/vegbien.backup &@
Aaron Marcuse-Kubitza
03:51 PM Task #442 (Resolved): test restoring of import backups
I tested restoring by extracting the compressed, custom-format backup to a plain text SQL script[1]. This is much fas... Aaron Marcuse-Kubitza
03:39 PM Task #444 (Resolved): test backing up entire DB
Aaron Marcuse-Kubitza
03:35 PM Task #444: test backing up entire DB
Full DB backup is 2.5 GB (compressed) and takes ~45 min[1]. Testing takes 3.5 min[2].
fn1. @make backups/vegbien.bac...
Aaron Marcuse-Kubitza

07/16/2012

04:20 PM Task #442: test restoring of import backups
Options:
* "testing if the export can be restored":http://www.linuxquestions.org/questions/linux-software-2/testing-...
Aaron Marcuse-Kubitza
02:53 PM Task #442: test restoring of import backups
Google techniques for this Aaron Marcuse-Kubitza
02:52 PM Task #442 (Resolved): test restoring of import backups
Aaron Marcuse-Kubitza
02:52 PM Task #444 (Resolved): test backing up entire DB
* run time
* storage space
Aaron Marcuse-Kubitza
02:52 PM Task #443 (Resolved): back up staging tables
Aaron Marcuse-Kubitza
02:51 PM Task #441 (Resolved): import CTFS data using JOINs from DB export, not VegX
Aaron Marcuse-Kubitza
02:50 PM Task #440: aggregating validations of imports
Have the # of:
* records
* plots
* specimens
* taxonomic categories
* species
* locations
Aaron Marcuse-Kubitza
02:49 PM Task #440: aggregating validations of imports
update for current schema Aaron Marcuse-Kubitza
02:48 PM Task #440 (New): aggregating validations of imports
Aaron Marcuse-Kubitza

07/02/2012

12:03 PM Task #426 (Resolved): Reload DB using column-based import
Has been reloaded once, and is being reloaded again Aaron Marcuse-Kubitza
 

Also available in: Atom