When i ran testMasterDetail from LDI sources, i in all probability (50% or more) i got ora-600 error.
More likely it's happed on second time. when index was created before and then dropped. But i am not sure.
Something like this:
*** Running SQLUnit file: C:\Shared\lucene-install-3.3.0.1.0\lucene-odi\db\testMasterDetail
[sqlunit] sqlunit-ant: Error setting transaction property error (java.sql.SQLException): Закрытое соединение
: No rows example (63ms)
Running test[3]: Add new rows (562ms)
Running test[4]: Adding rows to detail table (16ms)
Running test[5]: Update master table (172ms)
Running test[6]: Update datail table (31ms)
Running test[7]: Add new rows on master table (109ms)
Running test[8]: Add new rows on detail table (16ms)
Running test[9]: Add new rows on master table (94ms)
Running test[10]: Add new rows on detail table (94ms)
Assertion "exception-matches" failed (result != exception)
*** expected:
<result/>
*** but got:
<result><exception><code>600</code><message>ORA-00600: internal error code, arguments: [ktcxbr0_1], [0xAC9A4444], [67112451], [2097152], [], [], [], [], [], [], [], []
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 152
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 388
ORA-25228: timeout or end-of-fetch during message dequeue from LUCENE.IT1$Q
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 279
ORA-06512: at line 1</message></exception></result>
Error adding new rows
Running test[11]: Update master table (94ms)
Error setting transaction property error (java.sql.SQLException): Закрытое соединение
Running test[12]: two row select (94ms)
I prepared a test case where i tried to throw away all not important and increase probability of getting error:
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as LUCENE@FMS_TEST
1. Create table t1
4. sample usage of user data stores
6. Force to re-index all
7. alter index
8. Add new rows (1)
9. Adding rows to detail table (1)
10. Add new rows (2)
11. Adding rows to detail table (2)
12. Add new rows on master table (3)
13. Add new rows on detail table (3)
14. Add new rows on master table (4)
15. Add new rows on detail table (4)
BEGIN
LuceneDomainIndex.sync('IT1');
END;
ORA-00600: internal error code, arguments: [ktcxbr0_1], [0xAC9A4444], [67112451], [2097152], [], [], [], [], [], [], [], []
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 152
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 388
ORA-25228: timeout or end-of-fetch during message dequeue from LUCENE.IT1$Q
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 279
ORA-06512: at line 3
16. Add new rows on master table (5)
17. Add new rows on detail table (5)
18. Add new rows on master table (6)
19. Add new rows on detail table (6)
20. Add new rows on master table (7)
21. Add new rows on detail table (7)
21. Add new rows on master table (8)
22. Add new rows on detail table (8)
BEGIN
LuceneDomainIndex.sync('IT1');
END;
ORA-00600: internal error code, arguments: [ktcxbr0_1], [0xAC9A4444], [67112451], [2097152], [], [], [], [], [], [], [], []
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 152
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 388
ORA-25228: timeout or end-of-fetch during message dequeue from LUCENE.IT1$Q
ORA-06512: at "LUCENE.LUCENEDOMAININDEX", line 279
ORA-06512: at line 3
23. Add new rows on master table (9)
24. Add new rows on detail table (9)
29. drop
I reproduced it for LDI 3.0 and 3.3 on Oracle 11.2.0.1.0 and 11.2.0.2.0 under window and Linux platforms.
Could anybody try to repeat this results?
I tried to find this bug on oracle metalink but there i didn't find anything. Google keep silent too.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've seen this exact error with the newest LDI 3.5.0.1.0 and 11.2.0.3 on Win64 & Linux (RHEL 5.6). I can provide the incident dump if someone wants to troubleshoot.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi:
First sorry for the delay, I was on summer vacations.
Unfortunately I can't reproduce the error on my Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 Linux :(
Here the output of the test case:
[mochoa@localhost odi]$ sqlplus LUCENE/LUCENE@test @/tmp/testcase.sql
SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 7 08:36:39 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
1. Create table t1
Table created.
1 row created.
1 row created.
Table created.
1 row created.
1 row created.
4. sample usage of user data stores
Index created.
Index altered.
Index altered.
Index altered.
6. Force to re-index all
Index altered.
7. alter index
Index altered.
8. Add new rows (1)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
9. Adding rows to detail table (1)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
10. Add new rows (2)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
11. Adding rows to detail table (2)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
12. Add new rows on master table (3)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
13. Add new rows on detail table (3)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
14. Add new rows on master table (4)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
15. Add new rows on detail table (4)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
16. Add new rows on master table (5)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
17. Add new rows on detail table (5)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
18. Add new rows on master table (6)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
19. Add new rows on detail table (6)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
20. Add new rows on master table (7)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
21. Add new rows on detail table (7)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
21. Add new rows on master table (8)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
22. Add new rows on detail table (8)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
23. Add new rows on master table (9)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
24. Add new rows on detail table (9)
1 row created.
1 row created.
PL/SQL procedure successfully completed.
29. drop
Table dropped.
Table dropped.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
If you have a way to post a link for downloading the incident file I can take a quick look to see what is a problem. Usually an ora-0600 errors is attached to a RDBMS bug, but looking at the code that throws the error may there is a workaround for LDI.
Best regards, Marcelo.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello
When i ran testMasterDetail from LDI sources, i in all probability (50% or more) i got ora-600 error.
More likely it's happed on second time. when index was created before and then dropped. But i am not sure.
Something like this:
I prepared a test case where i tried to throw away all not important and increase probability of getting error:
i gave gotten next:
I reproduced it for LDI 3.0 and 3.3 on Oracle 11.2.0.1.0 and 11.2.0.2.0 under window and Linux platforms.
Could anybody try to repeat this results?
I tried to find this bug on oracle metalink but there i didn't find anything. Google keep silent too.
I've seen this exact error with the newest LDI 3.5.0.1.0 and 11.2.0.3 on Win64 & Linux (RHEL 5.6). I can provide the incident dump if someone wants to troubleshoot.
Hi:
First sorry for the delay, I was on summer vacations.
Unfortunately I can't reproduce the error on my Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 Linux :(
Here the output of the test case:
If you have a way to post a link for downloading the incident file I can take a quick look to see what is a problem. Usually an ora-0600 errors is attached to a RDBMS bug, but looking at the code that throws the error may there is a workaround for LDI.
Best regards, Marcelo.