-
Notifications
You must be signed in to change notification settings - Fork 8
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
OracleText - Error #12
Comments
Hi Steffen, Thanks for informing this. I need check more deeply, but it might be bug in blog application or APEX. Regards, |
Hi Steffen, For me this sounds APEX bug. Maybe they have issue on upgrade to 23.2 or patch 23.2.1. Need try somehow reproduce this and raise SR. |
Hi Jari, |
What are the commands for drop and recreate the Oracle Text only? |
Don't delete existing admin app. Install another copy to new application id. When installing admin app to new id, you can select not to upgrade supporting objects. |
Here is commands:
|
What I did test, when installing application to apex.oracle.com, it works OK. In autonomous database, when I create text index that syncs every interval:
Run update
I can see error from all_scheduler_job_run_details when sync job runs
But index is synced ok If running
This seems to be some issue/bug on ATP. |
I can (unfortunately) confirm both - but I can add posts again without error on save with the index that syncs every interval. |
I have raised SR to Oracle regarding issue on Autonomous Database. |
Yes, but text index sync fails. And blog public app search will not include your new posts or changes to existing posts. |
I understand that, but it's not that important at the moment. It's bad when you can't blog on a blog ;-) |
Could you please show what is job names for those rows? |
Here is my simple test case that I did use for SR |
In that case you can disable sync totally
|
I think those success rows are when you have created text index and/or when sync happens and there isn't anything to sync. |
I can reproduce this - the first run is succeeded, the others are all failed... |
Maybe - you said that if indexing doesn't work, search doesn't find anything. I can still find my latest blog entry from before in the search, so the indexing must have worked?! |
When you have data on table and you create/recreate index, indexing words. |
Ok, then the workaround is to drop and recreate index after blogging. Not nice but ok for the moment. |
You don't need recreate text indexes. Manually sync works e.g. from SQL Developer, what I tested.
|
Ok. Then you can place a button somewhere in the admin app to do it manually 😉. Sometime in the next update... |
Manual sync is not working from APEX page process or APEX automation or dbms_scheduler job what I did test. :( |
This seems to be bug in always free ADB. In paid ADW and ATP text index sync works. |
Ok, maybe it will be fixed anytime 👍 |
Two months and Oracle still working on issue.... |
It seems this issue is now fixed in my Always Free ADB. In attachment recreate_text_indexes.zip is script to recreate text indexes. |
Hi Jari,
I have a problem that is only indirectly related to the blog.
My blog runs on the "Always Free Autonomous Database" in the Oracle Cloud.
There is the following error when I want to edit an entry
![Screenshot 2024-01-11 170522](https://private-user-images.githubusercontent.com/12970066/295981069-d230d07f-26bd-4f72-8f68-73469f02ad41.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjAzNjUwMTksIm5iZiI6MTcyMDM2NDcxOSwicGF0aCI6Ii8xMjk3MDA2Ni8yOTU5ODEwNjktZDIzMGQwN2YtMjZiZC00ZjcyLThmNjgtNzM0NjlmMDJhZDQxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzA3VDE1MDUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTU0YWE0MjhhZGNjMzI0M2U1Mzg3ZGFkMDFhMGM3MDExYjA3MGFiZTI3MjUzYTZjZjQ0NDg1OWNlYjJiNTRiZTQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.0gzltDaUAZFM_7YyACqclrLKkMJ9dbC7Cxjp2lh6SSg)
DRG-50850: drftsync on-commit internal error...
In MyOracleSupport I find for DRG-50850:
"Inserting into a table with a Text index with the SYNC ON COMMIT attribute fails"
Do you have any idea what I can do?
(How) can I customize the Oracle Text Index from "sync on commit" to for example "intervals"?
Can I disable / drop the Oracle Text Index? Is the app usable afterwards?
Thx
Steffen
The text was updated successfully, but these errors were encountered: