We are experiencing hundreds of these errors in our log when cron tries to update the index on our site:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '301029995664 WHERE word = 'conducted'' at line 1 query: UPDATE sp_search_total SET count = 0,301029995664 WHERE word = 'conducted' in /www/htdocs/w00bdef4/drupal/drupal-6.17/modules/search/search.module in Zeile 287.

The error seems to be related to [...]SET count = 0,301029995664[...].
When I run a query with a decimal dot instead of the decimal comma [...]SET count = 0.301029995664[...] from myPHPAdmin, everythings works fine.

If that's the reason indexing fails: Why is search using a comma instead of a dot?

Related to this is: Those failed indexing attempts result in unclosed connections in the database, which eventually take down our sites, because max_user_connections for the database is exceeded.

Thanks

Jörg

Comments

dddave’s picture

Did you search for related issues? Cron failures while indexing are not that uncommon and can have various reasons.

Sidenote: Are you really using Drupal 6.9? This version is way behind not only security-wise.

joergvk’s picture

Version: 6.9 » 6.19

We are using 6.19, sorry for the mistake. Yes, I searched for related issues, but didn't find any.

dddave’s picture

You might wanna check out the irc support channel: http://drupal.org/irc for faster help. In case you are able to resolve the issue a quick write-up here would be nice.

Sorry that I cannot help you further.

joergvk’s picture

Will try irc. Interestingly we encounter these errors in only one of our three sites in the multisite install.

joergvk’s picture

No answers on irc. Issue persists.

joergvk’s picture

Error is now in logs of all sites.

joergvk’s picture

Status: Active » Closed (duplicate)

Created a bug issue for it and closed the support request.