Activity
From 04/21/2014 to 05/20/2014
05/20/2014
- 05:46 PM Revision 13498: inputs/.TNRS/schema.sql: MatchedTaxon, etc.: added accepted_morphospecies_binomial derived field
- 05:40 PM Revision 13497: bugfix: schemas/util.sql: restore_views(): need to specify view name for a manual existence check, in case the view definition becomes invalid, which would produce a nonstandard (uncatchable) exception
- 05:33 PM Revision 13496: bugfix: schemas/util.sql: explain(): don't display any log messages printed by IMMUTABLE functions in the query, which EXPLAIN apparently runs
- 05:21 PM Revision 13495: schemas/util.sql: create_if_not_exists(): added relation param, which can be used to ensure that a standard exception is always generated if the relation exists, even if the table definition would be invalid (which generates a variety of exceptions)
- 04:26 PM Task #929 (New): change TNRS client to store metadata
- * see details in [[2013-06-13 conference call#include-TNRS-version-and-settings-in-TNRS-cache]]
* after implementi... - 04:17 PM Task #928 (New): switch to new TNRS setup
- # #927 (part of #915)
# #917
# #916 (using rescrubbed names)
# #915
# -#929 (metadata)- _postponed_ - 03:26 PM Task #927 (Resolved): move morphospecies name formation to normalized DB
- * currently, it's only in the analytical_stem view
- 02:39 PM Revision 13494: /README.TXT: to back up the vegbiendev databases: added step to review diff before performing backup, in case the backup scripts break and try to synchronize things incorrectly
05/19/2014
- 09:08 PM Revision 13493: bugfix: schemas/util.sql: try_cast(), is_castable(): also need to handle syntax_error_or_access_rule_violation, which is thrown by ::regclass
- 08:52 PM Revision 13492: schemas/util.sql: added relation_exists()
- 08:27 PM Revision 13491: schemas/util.sql: save_drop_views()/restore_views(): store the view path in addition to the definition so it can be used in restoring
- 08:24 PM Revision 13490: bugfix: schemas/util.sql: in_reverse(): can't use `SELECT *` for composite types because this expands them
- 08:21 PM Revision 13489: bugfix: schemas/util.sql: array_reverse(): can't use `SELECT *` for composite types because this expands them
- 07:50 PM Revision 13488: schemas/util.sql: save_drop_views()/restore_views(): use opaque return type so it can be changed without changing the local var type in functions that use this
- 07:22 PM Revision 13487: schemas/util.sql: force_recreate(): recreate_users_cmds: renamed to restore_views_info since this is now whatever is needed by util.restore_views()
- 07:16 PM Revision 13486: schemas/util.sql: added restore_views() and use it in force_recreate()
- 02:07 AM Revision 13485: bugfix: schemas/util.sql: save_drop_views(): views must be *dropped* in reverse dependency order, but *returned* in forward dependency order
- 01:36 AM Revision 13484: bugfix: schemas/util.sql: force_recreate(): dependent views need to be re-created in *forward* dependency order. this is done by reversing the dependencies only for save_drop_views().
- 12:48 AM Revision 13483: bugfix: schemas/util.sql: mk_set_comment(): need to use VIEW instead of TABLE for views
- 12:29 AM Revision 13482: bugfix: schemas/util.sql: show_create_view(): also need to include view comment
- 12:24 AM Revision 13481: fix: schemas/util.sql: mk_set_comment(): added ;
- 12:20 AM Revision 13480: fix: schemas/util.sql: show_set_comment(): don't display a COMMENT ON statement if no comment, because this will be appended to table defs, etc. and would create clutter
- 12:16 AM Revision 13479: bugfix: schemas/util.sql: mk_set_comment(): need to handle NULL comment properly
- 12:06 AM Revision 13478: schemas/util.sql: added show_set_comment(regclass)
05/18/2014
- 11:57 PM Revision 13477: schemas/util.sql: set_comment(): use util.mk_set_comment()
- 11:48 PM Revision 13476: schemas/Makefile: added vegbien/install, vegbien/uninstall which also handle TNRS
05/17/2014
- 06:26 PM Revision 13475: fix: schemas/Makefile: vegbien.sql: also remake inputs/.TNRS/schema.sql since its contents change along with vegbien.sql
- 06:22 PM Revision 13474: schemas/util.sql: added mk_set_comment()
- 06:22 PM Revision 13473: bugfix: lib/runscripts/util.run: $is_runscript: unexport so don't pass it to invoked scripts
- 06:01 PM Revision 13472: backups/pg_snapshot: documented runtime for initial backup (4 h)
- 05:36 PM Revision 13471: bugfix: schemas/util.sql: force_recreate(): recreate_users_cmds: use create_if_not_exists() rather than eval(), because cmd might manually re-create a deleted dependent view, causing it to already exist
- 05:27 PM Revision 13470: bugfix: schemas/util.sql: save_drop_view(): util.show_create_view(): don't include `OR REPLACE` because that causes nonuniform errors (eg. invalid_table_definition), instead of the standard duplicate_table exception caught by util.create_if_not_exists()
- 05:25 PM Revision 13469: fix: schemas/util.sql: show_create_view(): removed extra trailing ; because pg_get_viewdef() now includes one
- 05:24 PM Revision 13468: schemas/util.sql: show_create_view(): made inclusion of `OR REPLACE` configurable
- 05:10 PM Revision 13467: schemas/util.sql: save_drop_view(): use util.drop_view()
- 03:40 PM Revision 13466: /README.TXT: Maintenance: added steps to back up the vegbiendev databases
- 02:15 PM Revision 13465: bugfix: lib/runscripts/util.run: run_args_cmd(): don't prepend main to args if no args, because for a non-runscript, all args will be passed to main(), leading `main` to be doubled
- 01:30 PM Revision 13464: lib/tnrs.py: use the TNRS dev server (with private URL in tnrs.url) instead of the live server, since that contains datasources that we need
- 01:29 PM Revision 13463: lib/streams.py: added file_get_contents()
- 01:14 PM Revision 13462: lib/tnrs.py: configure the server separately from the base URL
- 01:12 PM Revision 13461: lib/: svn:ignore tnrs.url so the TNRS dev server URL does not become public
05/16/2014
05/15/2014
- 11:57 PM Revision 13459: bugfix: web/.phpPgAdmin/.htaccess: custom pages: need to handle in query string because .php filename would be treated as path element
- 11:32 PM Revision 13458: web/.phpPgAdmin/.htaccess: support custom .php pages
- 10:30 AM Revision 13457: planning/meetings/BIEN conference call availability.xlsx: updated
- 09:43 AM Task #917: TNRS: Instructions for new version with TPL
- Aaron, for now (next couple of months, this must be done on the development TNRS web app since TPL is only on the dev...
05/13/2014
- 02:32 PM Task #917 (New): TNRS: Instructions for new version with TPL
- From Brad:
I’ve given some thought to the TPL matter. The algorithm isn’t hard, but Aaron will have to do the sort... - 11:19 AM Revision 13456: schemas/util.sql: save_drop_views(): return text[] instead of concatenated text so that the queries will be run individually and be easier to debug
- 11:00 AM Revision 13455: schemas/util.sql: added eval(queries text[])
- 09:43 AM Revision 13454: bugfix: schemas/util.sql: force_recreate(): need to drop users in reverse to avoid dependencies that block the drop
- 09:25 AM Revision 13453: schemas/util.sql: added array_reverse()
- 09:25 AM Revision 13452: schemas/util.sql: added in_reverse()
- 08:39 AM Revision 13451: bugfix: schemas/util.sql: force_recreate(): need to use [[:lower:]], not [:lower:]
- 08:34 AM Revision 13450: schemas/util.sql: force_recreate(): debug-print PG_EXCEPTION_DETAIL, users to assist in debugging
- 08:33 AM Revision 13449: fix: schemas/util.sql: debug_print_value(): added trailing newline to visually distinguish the printed value
- 08:27 AM Revision 13448: schemas/util.sql: added debug_print_var()
- 07:06 AM Revision 13447: schemas/util.sql: debug_print_return_value(): use new util.debug_print_value()
- 06:59 AM Revision 13446: schemas/util.sql: added debug_print_value()
- 05:45 AM Revision 13445: fix: schemas/util.sql: util.force_recreate(): also support dropping things besides tables
- 04:50 AM Revision 13444: inputs/.TNRS/schema.sql: MatchedTaxon.Accepted_name_species: mapped to accepted_species_binomial
- 04:09 AM Revision 13443: fix: inputs/.TNRS/schema.sql: COMMENTs: always include newline before and after
- 03:50 AM Revision 13442: bugfix: schemas/public_.sql: _plots_20_tnrs_names: tnrs_accepted_*: use new accepted_*, *not* scrubbed_*, as scrubbed_* does *not* contain only the accepted name (as implied by the tnrs_accepted_* column name)
- 03:46 AM Revision 13441: bugfix: inputs/.TNRS/schema.sql: taxon_scrub, etc.: undid rename of accepted name columns to scrubbed_* (r13435), because these are actually *not* the same (scrubbed_* is the combination of accepted and no-opinion names). the accepted name columns will now be named accepted_*, following the standard naming scheme.
- 03:28 AM Revision 13440: bugfix: schemas/public_.sql: _plots_20_tnrs_names: morphospeciesSuffix must still be called morphospecies_suffix, not taxon_morphospecies, because that column has not been updated to the taxon_morphospecies yet (fixes r13435)
- 03:13 AM Revision 13439: fix: inputs/.TNRS/schema.sql: taxon_scrub, etc.: scrubbed_*: use columns from MatchedTaxon whenever possible, to as much as possible avoid the need to join to taxon_scrub.scrubbed_unique_taxon_name.*
- 02:53 AM Revision 13438: schemas/Makefile: vegbien.sql: exclude the same set of Source tables excluded by inputs/.TNRS/schema.sql, so that reinstalling TNRS doesn't change the contents of this file
- 02:29 AM Revision 13437: bugfix: inputs/.TNRS/grants.sql: added GRANT statements from schema.sql because these aren't run by `make inputs/.TNRS/reinstall`
05/12/2014
- 07:06 PM Revision 13436: lib/tnrs.py: retrieval_request_template: taxonomic_constraint, source_sorting: documented their meaning and why they need to be on/off
- 05:03 PM Task #916: Taxon name validation: VegBank
- regarding:
Line 617: TNRS gives a synonym for Aronia prunifolia in a different genus, but this is missed here
L... - 04:35 PM Task #916 (New): Taxon name validation: VegBank
- Hi Aaron,
Bob only had time to get part way through the VegBank taxon validation file you sent, but there are some... - 04:28 PM Revision 13435: schemas/public_.sql: _plots_20_tnrs_names: changed to set of columns requested by Martha
- 03:13 PM Task #915 (New): Taxon Name Validation
- 1. Please correct the following in taxonMorphospecies:
1.1. -Family should be included in taxonMorphospecies only ...
05/10/2014
- 09:32 PM Revision 13434: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB
- 09:17 PM Revision 13433: schemas/public_.sql: _plots_20_tnrs_names: added morphospecies suffix in order to also validate it
- 09:13 PM Revision 13432: schemas/public_.sql: _plots_20_tnrs_names: added verbatim name in order to also validate the formation of the concatenated name
- 08:49 PM Revision 13431: schemas/public_.sql: merged _plots_20_tnrs_input_names, _plots_21_tnrs_output_names into _plots_20_tnrs_names so the input and output names can be compared side-by-side
- 08:10 PM Revision 13430: schemas/vegbien.sql: synced to DB, which adds Source.errors table indexes added in the import
05/09/2014
- 07:27 PM Revision 13429: /README.TXT: Full database import: for test import, turn off DB backup: added () after after_import to show that it's a function
- 07:24 PM Revision 13428: /README.TXT: Full database import: refer to the shell instead of screen because it's also possible to use a nested shell for this
- 02:51 AM Revision 13427: bugfix: /README.TXT: Full database import: to import just a subset of the datasources: need to set @inputs separately from declaring it, because declare does not support () on Mac
- 02:16 AM Revision 13426: fix: /README.TXT: Full database import: on local machine: need to allow logging output to go to log files
- 02:05 AM Revision 13425: /README.TXT: Full database import: for test import, added step to turn off DB backup
- 01:48 AM Revision 13424: fix: /README.TXT: Full database import: setting $version: moved to inside screen to avoid affecting the outer shell
- 01:46 AM Revision 13423: /README.TXT: Full database import: screen: added alternative for a small import (just use nested shell)
- 01:42 AM Revision 13422: fix: /README.TXT: Full database import: clear any limit set in .profile: moved to inside screen because it must happen within screen to avoid affecting the outer shell
- 01:40 AM Revision 13421: fix: /README.TXT: Full database import: added step to clear any limit set in .profile (applicable to local machine)
- 01:35 AM Revision 13420: bugfix: schemas/Makefile: `%/install: public_.sql`: also need to replace `public` when preceded by ( , as it is in the validations queries
05/07/2014
- 08:14 PM Revision 13419: bugfix: /Makefile: install: use schemas/public/*re*install because schemas/public/install would errexit if the public schema already exists
- 07:17 PM Revision 13418: bugfix: inputs/input.Makefile: $(datasrc_schema_exists): need to use $(datasrc), not $(schema), as $schema is only what this var is called in the runscripts
- 06:48 PM Revision 13417: bugfix: inputs/analytical_db/: need dummy table.run file to cause a schema to be created for this datasource
- 06:44 PM Revision 13416: fix: inputs/input.Makefile: $(sortFile): don't print the "add any missing tables to $(sortFile)" message every time the Makefile is run
- 06:44 PM Revision 13415: bugfix: inputs/input.Makefile: install: only run this for datasource dirs
- 05:18 PM Revision 13414: inputs/input.Makefile: install: use ./run's install target for clarity
- 05:18 PM Revision 13413: lib/runscripts/import.run: added install() target
- 04:56 PM Revision 13412: bugfix: inputs/input.Makefile: install: made it idempotent (using new $(datasrc_schema_exists)) so that it could be run by `make install` on an existing system
- 04:02 PM Revision 13411: bugfix: inputs/input.Makefile: $(datasrc_schema_exists): need to use $(shell ...)
- 03:31 PM Revision 13410: inputs/input.Makefile: added $(datasrc_schema_exists)
- 03:29 PM Revision 13409: lib/runscripts/in_datasrc_dir.run: use new local.run
- 03:25 PM Revision 13408: added lib/runscripts/local.run
05/06/2014
- 03:39 PM Revision 13407: web/links/index.htm: updated to Firefox bookmarks: iPlant links: fixed broken links
- 03:34 PM Revision 13406: web/links/index.htm: updated to Firefox bookmarks: starscream links: removed favicons so they wouldn't wake the Mac up on network access whenever someone opens the links page
05/03/2014
- 05:30 PM Task #909 (New): in aggregating validations pipeline, support using input result sets from CSVs instead of only by querying the staging tables
- * allows using input query results run on the raw data rather than the preprocessed staging tables
* enables providi... - 04:15 PM Revision 13405: added validation/aggregating/bien3_validation_sequence.xlsx from Brad
- 03:17 PM Revision 13404: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed disabling of enable_hashjoin (the lack of an additional join now makes `SET enable_seqscan = off;` sufficient to prevent a slow hash join)
- 03:10 PM Revision 13403: bugfix: schemas/util.sql: explain2notice_msg_if_can(): don't use util.is_explainable() because the list provided by Postgres (http://www.postgresql.org/docs/9.3/static/sql-explain.html#AEN77691) excludes some query types that are in fact EXPLAIN-able
- 02:03 PM Revision 13402: added inputs/VegBank/verify/outputBien.log.url
- 02:03 PM Revision 13401: inputs/input.Makefile: add: verify/: also svn:ignore *.log
- 12:44 PM Revision 13400: added validation/aggregating/plots/VegBank/bien3_validations_salvias_db_original_adjToVegBank.txt from Mike Lee
- 01:39 AM Revision 13399: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB
- 01:37 AM Revision 13398: schemas/public_.sql: _plots_20_tnrs_input_names, _plots_21_tnrs_output_names: added Brad's comments
- 01:28 AM Revision 13397: bugfix: schemas/util.sql: materialize_query(): contents generated from: need to include search_path so query is runnable
- 01:05 AM Revision 13396: planning/meetings/BIEN conference call availability.xlsx: updated
- 12:47 AM Revision 13395: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed setting of join_collapse_limit (the column now used does not involve an additional join)
05/02/2014
- 11:34 PM Revision 13394: schemas/vegbien.sql: _plots_21_tnrs_output_names: use scrubbed_unique_taxon_name (concatenated output name) because this is more similar to the concatenated name used in _plots_20_tnrs_input_names
- 11:22 PM Revision 13393: bugfix: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: needs to be run with `SET join_collapse_limit = DEFAULT; SET enable_hashjoin = off;` to produce the right query plan
- 10:57 PM Revision 13392: fix: lib/util.py: dict_subset(): raise an error if collections.OrderedDict isn't available, because some callers may depend on this. note that using dict instead of OrderedDict may be the cause of the joining on the wrong columns bug (issue #902).
- 10:42 PM Revision 13391: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB
- 10:01 PM Revision 13390: bugfix: schemas/public_.sql: _plots_21_tnrs_output_names: need to use TNRS output rather than input name
- 09:54 PM Revision 13389: schemas/public_.sql: added _plots_20_tnrs_input_names, _plots_21_tnrs_output_names
- 06:17 PM Revision 13388: schemas/public_.sql: public_validations: schema comment: documented how to run just the output queries on a particular datasource
- 04:53 PM Revision 13387: fix: schemas/public_.sql: rm_all_queries(): also remove output-only result tables
- 04:50 PM Revision 13386: schemas/public_.sql: query_view_regexp(): also match auxiliary tables
- 04:14 PM Revision 13385: schemas/public_.sql: added remake_output_tables(datasource_schema, prefix)
- 03:53 PM Revision 13384: schemas/util.sql: added loop_ignore_errors()
05/01/2014
- 10:38 PM Revision 13383: schemas/public_.sql: added output_queries(prefix)
- 10:27 PM Revision 13382: schemas/public_.sql: validation_views(): added prefix param, which can be used for additional subsetting
- 10:13 PM Revision 13381: schemas/public_.sql: query_relations(): removed no longer used max_prefix_len default param
- 10:05 PM Revision 13380: schemas/public_.sql: query_relations(): use new public_validations.truncated_prefixed_name_regexp(), which does not require passing in a max_prefix_len
- 10:03 PM Revision 13379: schemas/vegbien.sql: added public_validations.truncated_prefixed_name_regexp(), which does not require passing in a max_prefix_len
- 08:55 PM Revision 13378: schemas/public_.sql: rm_output_queries(), validation_views(): use public_validations.query_view_regexp()
- 08:42 PM Revision 13377: schemas/public_.sql: added public_validations.query_view_regexp()
- 08:06 PM Revision 13376: bugfix: schemas/public_.sql: public_validations.rm_output_queries(): default regexp needs to be anchored at beginning of string, and should match the regexp in public_validations.validation_views()
- 01:58 PM Revision 13375: bugfix: inputs/input.Makefile: %/postprocess: invoke runscript if it exists
- 01:37 PM Revision 13374: lib/runscripts/validations.pg.sql.run: export_(): make the export idempotent for easier re-runnability
- 01:37 PM Revision 13373: bugfix: lib/runscripts/validations.pg.sql.run: updated to reflect that validations.sql is now located inside a subdir, not the datasrc dir
- 01:29 PM Revision 13372: fix: lib/runscripts/file.pg.sql.run: removed include of in_datasrc_dir.run, because this location does not apply to all .sql export scripts
- 01:15 PM Revision 13371: bugfix: inputs/input.Makefile: validations.sql must be in a subdir so it won't get run by sql/install
- 01:11 PM Revision 13370: bugfix: inputs/input.Makefile: validations.sql must be in a subdir so it won't get run by sql/install
- 05:20 AM Revision 13369: inputs/input.Makefile: install: also run validate/install
- 04:44 AM Revision 13368: inputs/input.Makefile: added validate/install
- 04:09 AM Revision 13367: lib/runscripts/validations.pg.sql.run: export_(): make the export idempotent for easier re-runnability
- 03:22 AM Revision 13366: bugfix: inputs/SALVIAS/validations.sql: need to cast character varying to text so that the types of each side of if() match
- 03:14 AM Revision 13365: bugfix: lib/sh/db.sh: pg_dump(): need use_pg to import $pg_database before checking for existence of $database
- 03:11 AM Revision 13364: lib/sh/util.sh: import_vars: documented that it's idempotent
04/30/2014
- 07:10 PM Revision 13363: /Makefile: python-Linux: removed ordereddict, since OrderedDict is now obtained from `collections`
- 07:06 PM Revision 13362: web/links/index.htm: updated to Firefox bookmarks: fixed broken links
- 06:58 PM Revision 13361: bugfix: lib/util.py: use OrderedDict from collections rather than ordereddict to work with Mac OS X 10.8 Mountain Lion (http://vegpath.org/links/#OrderedDict)
- 06:42 PM Revision 13360: /Makefile: apache-Linux: updated for Ubuntu 14.04, which includes Apache 2.4 in the distribution
- 06:23 PM Revision 13359: /Makefile: install: documented that schemas/public/install also tests that a clean public schema will be installable by full-database import
- 06:12 PM Revision 13358: /Makefile: install: skip the test step at the end because this is not needed for the installation (it can be run separately if desired)
- 05:46 PM Revision 13357: bugfix: **/postprocess.sql: don't use the public schema, because this creates an unsatisfied dependency while the database is being installed, and breaks `make install`
- 05:36 PM Revision 13356: schemas/public_.sql: _km_to_m(): made it a wrapper around util._km_to_m() so this function is only in one place
- 05:32 PM Revision 13355: schemas/util.sql: added _km_to_m() for use when public._km_to_m() is not defined yet
- 02:33 PM Task #908 (New): generate the source-general derived columns directly on the denormalized staging table
- * avoids needing to run the full Python import, which is the part that is currently buggy
* see [[New-style_import#s...
04/29/2014
- 11:36 PM Revision 13354: bugfix: benign_does_not_exist_error(): removed ignore_e=3, because this exit status is also used for other errors
- 11:35 PM Revision 13353: fix: lib/sh/db.sh: benign_does_not_exist_error(): use benign_error=1, which is now supported properly by stderr_matches()
- 11:34 PM Revision 13352: bugfix: lib/sh/util.sh: stderr_matches(): support $benign_error properly, by handling exit status logging in this func instead
- 11:03 PM Revision 13351: bugfix: lib/sh/db.sh: pg_schema_exists(): also need to benignify "does not exist" error if returns false
- 10:42 PM Revision 13350: bugfix: lib/sh/util.sh: stderr_matches(): need to separately display errors that were incorrectly suppressed due to $benign_error
- 10:36 PM Revision 13349: bugfix: lib/sh/util.sh: is_err(): rethrow must be inverted (rethrow->*false* if error)
- 10:32 PM Revision 13348: lib/sh/util.sh: added is_err()
- 09:53 PM Revision 13347: lib/sh/local.sh: public_schema_exists(): moved to lib/sh/db.sh since this no longer depends on BIEN-specific configurations
- 09:42 PM Revision 13346: bugfix: lib/sh/db.sh: public_schema_exists(): don't hide the function call tree so it's clear which function is running the psql commands
- 09:40 PM Revision 13345: bugfix: lib/sh/db.sh: public_schema_exists(): don't hide the function call tree so it's clear which function is running the psql commands
- 09:38 PM Revision 13344: fix: *{.sh,run}: stderr_matches() callers: added benign_error=1 where needed
- 09:36 PM Revision 13343: fix: *{.sh,run}: stderr_matches() callers: usage: documented that they may require benign_error=1
- 09:35 PM Revision 13342: fix: lib/sh/util.sh: stderr_matches(): usage: documented that this may require benign_error=1
- 09:33 PM Revision 13341: fix: /README.TXT: Mac backup: exclude ~/VirtualBox VMs/Ubuntu/Ubuntu.vdi, to avoid it being re-uploaded twice each time, due to an rsync verification error (https://projects.nceas.ucsb.edu/nceas/issues/907)
- 09:23 PM Revision 13340: bugfix: lib/sh/db.sh: pg_cmd(): updated for new echo_vars log_level
- 09:14 PM Revision 13339: fix: lib/sh/db.sh: pg_schema_exists(): display the function name so it's clear which function is running the psql commands
- 05:46 PM Task #907 (Resolved): troubleshoot rsync verification errors
- * normally only happens when a file is concurrently modified, but this file was not in use
* this may indicate disk ... - 05:37 PM Revision 13338: fix: lib/sh/db.sh: pg_schema_exists(): don't use log++ because it hides the command that produces the benign error
- 04:42 PM Revision 13337: /README.TXT: changed "then rerun with l=1 ..." to "then review diff, and rerun with `l=1` prepended" to ensure that user reviews diff before syncing
- 04:40 PM Revision 13336: /README.TXT: to synchronize a Mac's settings with my testing machine's: removed separate step to upload just the VirtualBox VMs, because that is now part of the main upload
- 04:40 PM Revision 13335: fix: /README.TXT: to synchronize a Mac's settings with my testing machine's: need to sync VirtualBox VMs with inplace=1 because they are very large files
- 03:47 PM Revision 13334: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: rsync: documented that this breaks use of ~ to reference the remote user's home dir
- 03:26 PM Revision 13333: /README.TXT: to back up the version history: back up first on the local machine, because often only the svnsync command gets run, and that way it will get backed up immediately to Dropbox (and hourly to Time Machine), while vegbiendev only gets backed up daily to tape
- 03:23 PM Revision 13332: bugfix: /README.TXT: to back up the version history: use absolute path for vegbiendev commands because the Ubuntu 14.04 version of rsync doesn't expand ~ properly
- 02:36 PM Revision 13331: /README.TXT: to back up the version history: use $HOME to make paths platform-independent
- 01:18 PM Revision 13330: bugfix: exports/.rsync_filter.upload: *.csv: need to use `protect` rather than `hide` to prevent overwriting
04/28/2014
04/25/2014
- 11:38 PM Revision 13328: fix: lib/sh/db.sh: psql(): removed debugging changes
- 11:36 PM Revision 13327: bugfix: lib/sh/util.sh: highlight_log_msg(): when not can_highlight_log_msg, need to remove any surrounding formatting
- 11:01 PM Revision 13326: fix: lib/sh/util.sh: die_error_hidden(): always log local vars at same log_level as echo_func
- 10:56 PM Revision 13325: fix: *{.sh,run}: always log kw_params at same log_level as echo_func
- 06:27 PM Revision 13324: lib/sh/util.sh: split_lines(): usage: matched up and synced different syntaxes
- 06:22 PM Revision 13323: bugfix: lib/sh/util.sh: log_msg!(): split_lines does not support being invoked by wrapper; need to use `declare lines; wrapper "split_lines" str` instead
- 06:21 PM Revision 13322: fix: lib/sh/util.sh: split_lines(): usage: documented different syntax for when using wrapper
- 06:09 PM Revision 13321: bugfix: lib/sh/util.sh: die_error_hidden(): echo_func to assist debugging
- 06:07 PM Revision 13320: bugfix: lib/sh/util.sh: split(): need to limit the effects of IFS to just the splitting, so it doesn't cause strange errors in other functions
- 03:20 PM Revision 13319: bugfix: stderr2stdout(): fd 2 *must* be redirected back to fd 2, not log-filtered, in case there are other errors in addition to the benign error. this fixes a bug in pg_schema_exists(), where errors about the DB being down were not displayed because they were log-filtered out.
- 06:15 AM Revision 13318: lib/sh/make.sh: set_make_vars: don't display make vars at verbosity 2 to avoid clutter
- 05:58 AM Task #905 (Resolved): narrow down the cause of the import bug (incorrect join columns and disk space leak)
- _see #887, #902_
h3. -alternate OS approach-
p(. _tried, and problem also occurs on Mac, so using other approac...
04/24/2014
- 05:34 PM Revision 13317: bugfix: lib/sh/make.sh: begin_target: don't echo_func twice
- 05:29 PM Revision 13316: inputs/GBIF/_MySQL/.rsync_ignore: added GBIFPortalDB-*.data.sql.gz, because these are intermediate files
- 05:02 PM Revision 13315: bugfix: /Makefile: $(pg_ctl-Darwin): need to call the command rather than echoing it, as is needed for the Linux version
- 04:59 PM Revision 13314: bugfix: /Makefile: $(pg_ctl-Darwin): need to `cd /` because due to pg_ctl bug, current directory must be accessible by it
- 03:49 PM Revision 13313: bugfix: lib/runscripts/util.run: a non-runscript should have all args passed to main(). this fixes a bug in backups/*_snapshot where "main" would need to be prepended to any args for the script to run correctly.
- 03:43 PM Revision 13312: bugfix: lib/runscripts/util.run: $wrap_fn: invoked script must always run as runscript so that wrapped command is run
- 03:40 PM Revision 13311: lib/runscripts/util.run: added $is_runscript, for use by $wrap_fn
- 03:36 PM Revision 13310: bugfix: lib/runscripts/util.run: $wrap_fn: $top_script doesn't need to be world-executable for most uses of sudo (only if sudoing to non-root)
04/23/2014
- 10:01 PM Revision 13309: bin/in_place: diff: use --brief to avoid scanning the entire file for large files
- 09:57 PM Revision 13308: bin/in_place: added $preserve_mtime flag
- 07:22 PM Task #887: fix disk space leak that fills the disk and crashes the import
- VM upgraded to Ubuntu 14.04 and using the official Ubuntu version of Postgres, but problem still occurs
- 07:16 PM Revision 13307: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: Apache: documented that MultiViews is actually only broken for redirects with the filename "index"
- 07:11 PM Revision 13306: web/.htaccess: for dirs, redirect to index.*: document it is actually just the filename "index" that MultiViews is broken for, other filenames work fine
- 06:06 PM Task #903 (Resolved): fix Ubuntu 14.04 upgrade bug that prevents Apache from displaying vegbiendev.nceas.ucsb.edu properly
- 06:00 PM Task #903: fix Ubuntu 14.04 upgrade bug that prevents Apache from displaying vegbiendev.nceas.ucsb.edu properly
- added workaround for broken MultiViews
- 04:14 PM Task #903 (Resolved): fix Ubuntu 14.04 upgrade bug that prevents Apache from displaying vegbiendev.nceas.ucsb.edu properly
- this consists of 2 problems:
# -http://vegbiendev.nceas.ucsb.edu/index.php now includes the VegCore wiki page inst... - 06:02 PM Revision 13305: bugfix: web/index.php: full directory index: only display if invoked as "vegpath.org/", not "vegpath.org/index.php"
- 05:58 PM Revision 13304: bugfix: web/.htaccess: for dirs, redirect to index.*: added workaround for Ubuntu 14.04, which breaks MultiViews
- 05:56 PM Revision 13303: /Makefile: postgres-Linux: updated to use the official version that comes with Ubuntu 14.04
- 05:53 PM Revision 13302: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: Apache: documented that this breaks MultiViews, so you need to rewrite .htaccess files to avoid using MultiViews
- 05:24 PM Revision 13301: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: added Postgres upgrading instructions
- 05:05 PM Revision 13300: _license/non-open-source/applies_to.txt: Brad: added "anything he created while not working for iPlant, from 2013-7-1..10-31"
- 04:53 PM Revision 13299: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade
- 04:47 PM Revision 13298: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: added phpMyAdmin fixing instructions
- 04:45 PM Revision 13297: web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: added phpMyAdmin fixing instructions
- 04:42 PM Task #904 (Resolved): add MySQL public user to allow accessing the normalized VegCore data dictionary
- __* see "normalized VegCore data dictionary":http://vegbiendev.nceas.ucsb.edu/vegbiendev/db/my/VegCore
- 04:31 PM Revision 13296: web/links/index.htm: updated to Firefox bookmarks: Ubuntu: Ubuntu 14.04 upgrade: added things broken by it. PostgreSQL: fixed links.
- 04:00 PM Task #884 (Rejected): fix Postgres bug that causes query planner to use seq scans and slow sorts instead of index scans in the import
- duplicate of #902: slow sorts are caused by joining on the wrong columns, not query planner settings
- 03:52 PM Task #902 (Resolved): fix bug that causes joining on the wrong columns in the import
- _bug fixed in r14074_
h3. issue
* in some queries, the columns being joined on are completely the wrong set (co... - 03:16 PM Task #901: schedule regular pg_dump backups of the DB
- see @backups/pg_snapshot@, @backups/mysql_snapshot@
- 01:08 PM Revision 13295: /Makefile: postgres-Linux: added warning that the install commands were designed to run on Ubuntu 12.04, which is no longer the version used by vegbiendev (it is now 14.04)
- 12:09 PM Revision 13294: backups/mysql_snapshot: documented initial vegbiendev->jupiter upload time for GBIF/raw_occurrence_record.MYD (7 h for 91 GB = 3.7 MB/s)
- 12:12 AM Revision 13293: fix: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: wal_keep_segments method: clarified how to determine the value of wal_keep_segments. filesystem-level backups: documented the advantages of filesystem-level backups over traditional database-level backups with pg_dump.
04/22/2014
- 11:32 PM Revision 13292: fix: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: wal_keep_segments: restored annotations
- 11:26 PM Revision 13291: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: documented how to set up online and offline backups (with two possible approaches for online backups)
- 11:24 PM Revision 13290: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: documented how to set up online and offline backups (with two possible approaches for online backups)
- 11:21 PM Revision 13289: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: documented how to set up online and offline backups (with two possible approaches for online backups)
- 10:33 PM Revision 13288: lib/sh/db.sh: pg_snapshot(): perform online backup if possible, to avoid needing to restart the server
- 10:31 PM Revision 13287: lib/sh/db.sh: added pg_start_backup(), pg_stop_backup()
- 10:29 PM Revision 13286: lib/sh/db.sh: psql(): only set redirs if can redirect
- 10:17 PM Revision 13285: bugfix: psql(): when as_root is on, need to avoid redirections as these are not passed through by sudo
- 08:14 PM Revision 13284: /README.TXT: use `sudo -u ... -i` instead of `sudo su - ...` to avoid using two commands to accomplish the login
- 06:01 PM Revision 13283: bugfix: lib/sh/db.sh: psql(): don't use `--file /dev/fd/40` when can't redirect
- 05:59 PM Revision 13282: fix: lib/sh/db.sh: psql(): when using sudo with custom $stdin, raise error that this is not supported
- 05:50 PM Revision 13281: lib/sh/db.sh: psql(): $data_bypasses_filter: renamed to $data2stdout for clarity
- 05:29 PM Revision 13280: lib/sh/db.sh: psql(): $bypass_ok: renamed to $can_redir for clarity
- 05:22 PM Revision 13279: lib/sh/db.sh: psql(): usage: $stdin: documented that can also use process substitution for this
- 04:45 PM Revision 13278: bugfix: lib/sh/util.sh: `type` calls: need -- before cmd in case it starts with -
- 04:44 PM Revision 13277: lib/sh/util.sh: cmd2rel_path: use is_extern()
- 04:00 PM Revision 13276: lib/sh/sync.sh: db_snapshot(): use `end_try` as specified in `try` usage
- 03:59 PM Revision 13275: lib/sh/util.sh: try: usage: added location of finally block
- 03:57 PM Revision 13274: schemas/postgresql.conf: wal_level: set to hot_standby to enable online backup with pg_start_backup()
- 03:04 PM Revision 13273: lib/sh/sync.sh: upload(): always print the function and kw_params
- 04:00 AM Revision 13272: added backups/mysql_snapshot, pg_snapshot
04/21/2014
- 08:21 PM Revision 13271: bugfix: lib/sh/util.sh: type(): need to handle options before command name
- 08:21 PM Revision 13270: lib/sh/util.sh: added 1st_non_opt()
- 08:07 PM Revision 13269: lib/sh/util.sh: unalias(): use self_builtin, which is now defined before it
- 08:01 PM Revision 13268: lib/runscripts/util.run: sudo(): avoid slow $wrap_fn when using `command` (ie. always executable)
- 07:59 PM Revision 13267: lib/sh/util.sh: unalias(): use self_builtin, which is now defined before it
- 07:57 PM Revision 13266: bugfix: lib/sh/util.sh: commands: `type` calls: need to account for the fact that any alias is already expanded
- 07:56 PM Revision 13265: lib/sh/util.sh: functions: moved before commands since commands are more complex
- 07:38 PM Revision 13264: lib/sh/sync.sh: db_copy() and callers: pass args as rsync options
- 07:28 PM Revision 13263: fix: lib/sh/sync.sh: db_copy(): need to exclude files which prevent tape backup
- 07:22 PM Revision 13262: lib/sh/db.sh: added pg_ctl(), pg_snapshot()
- 07:17 PM Revision 13261: lib/sh/sync.sh: db_snapshot(): copy changes before stopping DB to minimize the time that it's shut down
- 07:12 PM Revision 13260: lib/sh/sync.sh: db_snapshot(): factored copy operation out into separate db_copy() function
- 07:03 PM Revision 13259: lib/sh/db.sh: mysql_snapshot(): use new db_snapshot()
- 07:02 PM Revision 13258: lib/sh/sync.sh: added db_snapshot()
- 05:55 PM Revision 13257: lib/Firefox_bookmarks.reformat.csv: changed "page's own description" to "page's self-description" for clarity
- 05:50 PM Revision 13256: web/links/index.htm: updated to Firefox bookmarks: removed dead links
- 05:43 PM Revision 13255: web/links/index.htm: updated to Firefox bookmarks: updated favicons
- 05:28 PM Revision 13254: web/links/index.htm: updated to Firefox bookmarks: modifying a running shell script: updated to document that `svn up` actually *does* use two-stage save automatically
- 04:46 PM Revision 13253: lib/sh/db.sh: mysql_snapshot(): for large files, don't re-copy entire file
- 04:44 PM Revision 13252: lib/sh/db.sh: mysql_snapshot(): use live mode as the default
- 04:30 PM Revision 13251: fix: lib/sh/db.sh: mysql_snapshot(): need to create dest dir if doesn't exist
- 04:27 PM Revision 13250: bugfix: lib/sh/db.sh: mysql_snapshot(): try: need to use split syntax with prep_try instead, to work with prefix vars
- 04:23 PM Revision 13249: bugfix: lib/sh/db.sh: mysql_snapshot(): try: need to use split syntax with prep_try instead, to work with prefix vars
- 04:20 PM Revision 13248: fix: lib/sh/util.sh: try usage: documented that the split syntax with prep_try is meant to be used with vars before the cmd
- 03:37 PM Revision 13247: fix: lib/sh/util.sh: echo_vars(): also need to print unset vars (including unset kw_params)
- 03:31 PM Revision 13246: lib/sh/util.sh: echo_vars(): put loop var on same line as `for`
- 02:59 PM Revision 13245: bugfix: lib/sh/util.sh: sudo(): need to preserve PATH separately because -E does not preserve this
- 02:17 PM Revision 13244: lib/sh/util.sh: echo_redirs_cmd(): inline the function alias since it's only used in one place
- 02:15 PM Revision 13243: bugfix: lib/sh/util.sh: redir(): need to load new aliases before it
- 02:13 PM Revision 13242: lib/sh/util.sh: echo_redirs_cmd(): log $PATH to facilitate troubleshooting
- 01:54 PM Revision 13241: lib/sh/util.sh: echo_redirs_cmd(): documented what the $(...) section does
- 01:50 PM Revision 13240: lib/sh/util.sh: echo_redirs_cmd(): moved comment about <>file redirs to line that it applies to
- 01:47 PM Revision 13239: lib/sh/util.sh: moved echo_redirs_cmd() to right before redir() which uses it
- 02:55 AM Revision 13238: lib/sh/util.sh: catch(): log at higher log_level, since this is internal code
- 02:43 AM Revision 13237: fix: lib/sh/util.sh: die_e(): treat SIGPIPE as benign error
- 02:32 AM Revision 13236: lib/sh/util.sh: removed no longer used ignore_sig(). use ignore() instead, which now supports SIG*.
- 02:32 AM Revision 13235: lib/sh/util.sh: piped_cmd(): use ignore, which now supports SIG*
- 02:31 AM Revision 13234: lib/sh/util.sh: signals: catch(): added echo_func
- 02:28 AM Revision 13233: lib/sh/util.sh: set_global_fds(): debug to global stderr in case stderr filtered
- 02:26 AM Revision 13232: lib/sh/util.sh: debugging: use configurable debug_fd (set to $err_fd)
- 02:13 AM Revision 13231: lib/sh/util.sh: signals: override catch() to support SIG* as exception type
- 02:11 AM Revision 13230: lib/sh/util.sh: moved primitives sections before more complex sections that depend on them
- 02:07 AM Revision 13229: lib/sh/util.sh: 2nd functions section: moved to 1st functions section
- 01:16 AM Revision 13228: bugfix: lib/sh/util.sh: added workaround for bash bug where exit sometimes inxeplicably ignores $?
- 01:15 AM Revision 13227: fix: lib/sh/util.sh: self_builtin: avoid $() so that $? isn't modified
- 01:07 AM Revision 13226: lib/sh/util.sh: use new self_builtin
- 01:06 AM Revision 13225: lib/sh/util.sh: added self_builtin
- 12:50 AM Revision 13224: lib/sh/util.sh: pv(), pf(): moved to debugging section
- 12:48 AM Revision 13223: bugfix: lib/sh/util.sh: stderr_matches(): also need to handle any filter error, such as caused by Ctrl+C
- 12:26 AM Revision 13222: lib/sh/util.sh: stderr_matches(): echo_vars @PIPESTATUS_ to assist debugging
Also available in: Atom