[TYPO3-Solr] Index Queue Worker with no progress & tx_solr_indexqueue_item->errors-field

[Gordon Fidora]

Good morning,

I got followed 2 notes/problems mentioned the SOLR-Extension:

First: Table-Structure of "tx_solr_indexqueue_item"
The column "errors" has automatically been created with NULL-value (via Extension Installation).

If I started the Index-Queue-Worker-Task yesterday...it always stopped after
1 second with no indexing - although there were more than 500 entries in this table.

So I started debugging and found the following database-query in method "getItemsToIndex" from claas tx_solr_indexqueue_Queue:

$indexQueueItemRecords = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(
                                                                       '*',
                                                                       'tx_solr_indexqueue_item',
                                                                       'root = ' . $site->getRootPageId()
                                                                                              . ' AND changed > indexed'
                                                                                              . ' AND changed <= ' . time()
                                                                                              . ' AND errors = \'\'',
                                                                       '',
                                                                       'indexing_priority DESC, changed DESC, uid DESC',
                                                                       intval($limit)
                                               );
The result was always empty. The field "errors" will always be checked for an empty string, but not for NULL.
After changing this field in table-structure everything was fine.

I didn't change the structure before. Can the reason be the configuration of the mysql-server (e.g. on create table process)?



Second: Index-Queue-Worker-Task doesn't stop, but not progress
If I start the Index Queue Worker task manually or via Cronjob...I got some progress...but after some
time nothing more happens...e.g.: progress bar is on 10%, but nothing happens. The task still runs.
I have to stop the task manually and after that I can start again. If I don't do that...no Cronjob will be started automatically...
So I have to start and stop for more than 500times...if I want to get all pages indexed....

So what can I do?

Best Regards

Gordon









Dipl.-Inf.(FH) Gordon Fidora
Software-Engineer Web Development
PROFILE MEDIA GmbH
Luisenstr. 1
32052 Herford

Fon 0 52 21 - 9 24 97 22
Fax 0 52 21 - 9 24 97 11
g.fidora at profile-media.de<mailto:g.fidora at profile-media.de>
www.profile-media.de<http://www.profile-media.de/>
Vertreten durch die Geschäftsführerin: Dipl.-Ing. Ursula Schmid
Registergericht: AG Bad Oeynhausen | HR B 6253 | Ust-ID DE 811871252