OpenACS / openacs-4 / packages / search

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 13:09
Commits this week: 0
Total Lines of Code (LoC): 113
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 14 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 13 Feb 2022
1:10 pm

gustafn

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

Options
    • -4
    • +5
    ./oracle/search-packages-create.sql
Tuesday 02 Mar 2021
9:08 am

gustafn

remove spurious parens

Options
    • -2
    • +2
    ./oracle/search-packages-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
Monday 01 Mar 2021
7:20 pm

gustafn

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 (

Options
    • -1
    • +16
    ./oracle/search-packages-create.sql
    • -0
    • +50
    ./oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
    • -10
    • +21
    ./postgresql/search-packages-create.sql
    • -0
    • +36
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  5. … 1 more file in changeset.