I have a MySQL table (tbl_test) with 4 columns - id, url, title & description. There are 39409 rows in the table. I would like to index this table into Opensearchserver v1.5.3, I have created a new index with the 'web crawler' template and my database crawler settings are as follows:-
Driver class: com.mysql.jdbc.Driver
JDBC url: jdbc:mysql://localhost/test_db
Isolation level: TRANSACTION_READ_COMMITTED
Buffer size: 100
Sleep (ms): 0
Primary key: id
Unique key (for deletion): id
SQL Select: SELECT * FROM tbl_test
SQL Update: (blank)
SQL Column Index Field
When I save settings and execute the crawl process i get the following:-
Name Execution time Duration Status Info
test_crawl 8:47:44 PM 0:00:00 Complete 0 (0) / 39409 (0)
No documents are added to the index. Please will you let me know where I'm going wrong.
Could you please select TRANSACTION_SERIALIZABLE for field "Isolation level", and leave empty field "Unique key (for deletion)" and then try again indexation?
You also have to add a field mapping between the primary key of your table with a field of your schema.
Can you tell me if those changes work?
Thank you very much Alexandre, the new settings are working perfectly!
Log in to post a comment.