• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes during the creation of the search observer queue for Oracle 19c:

In essence, the change repairs the following error:

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY SEARCH_OBSERVER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

16/7 PL/SQL: SQL Statement ignored

16/40 PL/SQL: ORA-00933: SQL command not properly ended

remove spurious parens

Handle potential race condition in search observer queue maintenance

In some cases, when e.g. objects are quicky deleted after updates, the

object might be already be deleted when being tried to trigger a

DELETE operation in the search queue. as a consequence, one can sometimes

observer errors like the one below. The new code double-checks now,

if the object for the DELETE operation still exists.

ERROR: insert or update on table "search_observer_queue" violates foreign key constraint "search_observer_queue_object_id_fk"

: DETAIL: Key (object_id)=(497509146) is not present in table "acs_objects".

: CONTEXT: SQL statement "insert into search_observer_queue (

    • -1
    • +16
    ./oracle/search-packages-create.sql
    • -10
    • +21
    ./postgresql/search-packages-create.sql
    • -0
    • +36
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d3-5.10.0d4.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

  1. … 520 more files in changeset.
- fix for bug #3238

  1. … 3 more files in changeset.
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -17
    • +29
    ./postgresql/search-packages-create.sql
    • -9
    • +18
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 18 more files in changeset.
Files removed on oacs-5-4, not removed on HEAD by the last merge

    • -15
    • +0
    ./oracle/search-index-from-scratch.sql
Merged from 5.4.2

    • -409
    • +1
    ./oracle/search-packages-create.sql
  1. … 282 more files in changeset.
Found some more intermedia stuff to remove.

    • -164
    • +1
    ./oracle/search-packages-create.sql
Remove intermedia specific files

    • -15
    • +0
    ./oracle/search-index-from-scratch.sql
    • -246
    • +1
    ./oracle/search-packages-create.sql
Fixed constraint naming error caught by automated testing.

Remove 'exit' lines that caused datamodel to be incompletely installed. Comment out creation of triggers for forums, static-portal, acs-events, faq, survey and photobook (should go in their own package)

    • -5
    • +0
    ./oracle/search-index-from-scratch.sql
    • -180
    • +179
    ./oracle/search-packages-create.sql
Remove reference to dotlrn

commiting search work from sloan

    • -14
    • +27
    ./oracle/search-from-scratch.sql
    • -270
    • +266
    ./oracle/search-packages-create.sql
    • -14
    • +32
    ./oracle/search-tables-create.sql
    • -0
    • +3
    ./oracle/syndication-drop.sql
  1. … 30 more files in changeset.
Added package_id to site_wide_index table

Added indexed_content field to the site_wide_index table. This

field will hold "textualized" content of binaries.

first draft for .lrn search. run load-site-wide-search shell script to install

    • -0
    • +48
    ./oracle/load-site-wide-search
    • -0
    • +41
    ./oracle/search-ctxsys.sql
    • -0
    • +49
    ./oracle/search-from-scratch.sql
    • -0
    • +152
    ./oracle/search-im-convert.sql
    • -0
    • +43
    ./oracle/search-index-create.sql
    • -0
    • +32
    ./oracle/search-index-drop.sql
    • -0
    • +20
    ./oracle/search-index-from-scratch.sql
    • -44
    • +476
    ./oracle/search-packages-create.sql
fix a couple typos for syndication

  1. … 1 more file in changeset.
add a syndication table which holds xml fragments which can be assembled to create rss feeds

    • -0
    • +15
    ./oracle/syndication-create.sql
    • -0
    • +3
    ./oracle/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
    • -0
    • +18
    ./postgresql/syndication-create.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  1. … 2 more files in changeset.
Put functions into a search:: namespace and make most private.

Add a search::queue and search::dequeue command

define_function_args/package_exec_plsql to avoid db specific xql files.

unset datasource when finished with it.

bump to 5.2.0d2 + postgresql upgrade script.

    • -4
    • +8
    ./postgresql/search-packages-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  1. … 5 more files in changeset.
Applied fix from Carsten Clasohm - now upgrade works on pg7.3 as well (tried it on 7.2 too). Fixes #631

    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 26 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

    • -1
    • +1
    ./postgresql/search-packages-create.sql
  1. … 37 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 53 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 53 more files in changeset.
merge from oacs-4-6

    • -4
    • +4
    ./postgresql/search-packages-create.sql
  1. … 28 more files in changeset.
changes to make search work with openfts 0.3

    • -4
    • +4
    ./postgresql/search-packages-create.sql
  1. … 4 more files in changeset.
renamed jon's upgrade file 4.5->4.5.1

    • -35
    • +0
    ./postgresql/upgrade/upgrade-4.2-4.5.1.sql
    • -0
    • +35
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql