Solr reindex fails

[Xiao Zhao]

Hello

I just imported the database of a BibApp instance into another.

Just tried reindexing; it ran for a while, then fails with

rake aborted!

500 "Illegal_character_CTRLCHAR_code_2__at_rowcol_unknownsource_884128__comctcwstxexcWstxUnexpectedCharException_Illegal_character_CTRLCHAR_code_2 ...

The target BibApp instance is pretty old, I guess it needs some files.

Maybe some bad characters exists in the db? I can't locate them.

Thanks for the help.

Xiao

[Jason Stirnaman]

Xiao,

Were both databases configured as UTF8? It sounds like an encoding error.

Jason

Xiao

--
You received this message because you are subscribed to the Google Groups "bibapp" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bibapp+un...@googlegroups.com.
To post to this group, send email to bib...@googlegroups.com.
Visit this group at http://groups.google.com/group/bibapp?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Xiao Zhao]

I've looked at both through mysql workbench; it shows both have latin-1 default collation.

I changed the target one to utf-8 collation, but it didn't work. I guess the source needs to change too, but I hesitate to do it.

Any other suggestions? Thanks Jason.

[Jason Stirnaman]

I'm not positive this will solve it, but you can try making a UTF8 copy of your database: http://docs.moodle.org/23/en/Converting_your_MySQL_database_to_UTF8#Converting_a_database_containing_tables

[Xiao Zhao]

Thanks for the tips; now it says "Connection reset by peer" for some reason. This too, comes after a while.

[Jason Stirnaman]

Xiao,

That sounds like a Solr connection problem. Is Solr actually running at the address and port that you expect?

Jason

[Xiao Zhao]

Hi Jason

I've ran it again; and solr did index some works/people, but it failed with "connection reset by peer".

Really not sure why; it was complaining with the illegal char error before, and suddenly switched to connection error.

But, I still take solr over sphinx; had more pain dealing with the latter.

Xiao

[Xiao Zhao]

Ah it looks Okay now. Thanks for the help.

I've added a new work_subclass model, and now solr complains 

The single-table inheritance mechanism failed to locate the subclass: 'Image3D'

How to fix this?

[Xiao Zhao]

Looks like that's okay now. Thanks for all the help.