Thunderstone Support Forums

We have one search application running on one server. Now we need to run another search application with the different configuration. So two different urls for Search would open different search applications but from the same server.

The issues we will face is, it would not be possible to check-in the same modules for different applications having different configuration. Also our vortex front end scripts are stored at one path "/usr/local/apache/scripts/webinator" but if I compile the front-end scripts for the second search application, it would over write the first one.

I hope you understood what I am trying to ask.

Hi Team,

I need your help. We need to run two instances of search application on one server with different configuration.

Will that be possible to install two texis engines on one server. One would be using one apache web server and second would be using another.

Please let me know if that would be possible. Else kindly let me know if there is another solution for the same.

Thanks

No I did not do that, Just now I have dropped this table and its indexes and rebuilt them. Now, new data would be populated into this table in few hours.

If we again face this issue, I will do whatever is being suggested by you to repair.

Thanks for the help.

Thanks for the quick reply.

By any chance, can this error be related to multibyte characters in the tables/indexes?

As suggested by you, when I was creating the new table, My screen got filled with the same error:

005 Corrupt block header at 0x77c75a64c in KDBF file DBpath/files1_1_0.blb in the function read_head

Dear Team,

Suddenly, I found the following error in one of my Table when I query something:

005 Corrupt block header at 0xb50795f60 in KDBF file DB-path/files1_1_0.blb in the function read_head
005 Corrupt block header at 0xb50795f60 in KDBF file DB-path/files1_1_0.blb in the function read_head

After doing "kdbfchk" for the mentioned(files1_1_0.blb) index, I got free tree error.

Can you please suggest me, if deleting the indexes and rebuilding them will help?

will this error go away from my table?

Please Advise!

The current situation is, I took the code from other instance where it is working fine.

The values for "Prod in ( h:▒▒ )" is coming perfectly. And logs does not show any error.

Now, the issue is, from the front-end of our application, when we try to search something, we are not getting the results and the records are indexed properly aswell in the texis database.

Here I need your advise on what could be the possible reason.

Mark/John,

I replaced the code for that particular file(search) with the working one. Now there is no error in the logs.

But still my public scripts(front-end) are not able to fetch the records from texis DB.

Do you have any idea for this?

Thanks

I kept sqltrace ON and below query is getting executed:

select Prod, ProdName, Busid, SubBusid, SupCommFlag, comm_hits, Desc, Keywords from community where ProdName\esc\Keywords likep ? and ( ( CommRstdFlag=0 or Prod in ( h:▒▒ )) ) ; FAILED

It says Prod in (h:) but "Prod in" must have few id's. Example (Prod in(1232,2434))

This "Prod in" query data is coming from RAM Table and it is the part of $comsqlquery.

Sorry, I did not get the path where we will run your mentioned query("select count(*) ic from " $tablename ") for RAM Table.

Yes, RAM table is present only in that process.

Can you please tell me if there is any particular PATH/Location to run this select query for RAM Table?