Hello,
Recently I've installed Spambot 7.x-1.4 and enabled Scan existing accounts feature by entering 10 in Maximum number of user accounts to scan per cron field. I have also enabled Scan blocked accounts checkbox and selected None, just log it as the action.

During the first cron run there began endless job restarts (Attempting to re-run cron while it is already running errors once per minute or two). This continued for about 4 hours, when I decided to stop this by disabling Spambot module, which helped. Next day after enabling Spambot again the problem returned. I could get rid of it only by disabling the whole module or accounts scanning (by setting Maximum number of user accounts to scan per cron to 0).

The Scan status section says

Accounts checked: 4, Accounts remaining: 164
The last checked user account is: xxx (uid 28)

while the last user was reported as spammer (possibly by IP). So the scanner did nothing since it found the first spammer, causing cron restarts.

Hopefully there is some obvious solution for this problem.

Comments

c470ip created an issue. See original summary.

kala4ek’s picture

kala4ek
Primary language Russian
Location 🇷🇺 Novosibirsk
commented
Priority: Normal » Major
kala4ek’s picture

kala4ek
Primary language Russian
Location 🇷🇺 Novosibirsk
commented
Assigned: Unassigned » kala4ek
kala4ek’s picture

kala4ek
Primary language Russian
Location 🇷🇺 Novosibirsk
commented
Assigned: kala4ek » Unassigned
Status: Active » Postponed (maintainer needs more info)

Hello @c470ip,

I tried to reproduce it, but cannot.
Can you specify, how your cron is configured? How often it starts? Did you user default cron from code or some other module, like elysia cron?

c470ip’s picture

c470ip commented

Hello kala4ek,

Thanks for your help. I use default cron from core. It's configured to start every 3 hours and normally seems to work without any problems. I had this endless restart when installing module on production site, now I plan to reproduce this on local setup.

cwsmith1701’s picture

cwsmith1701 commented

I'm getting a similar issue on stable 1.4 and on the current dev release. Turned off the cron auto run and ran cron in terminal through drush.

Reset the uid listing to 0 to start over. This is the error I got in drush.

fanbards@fanbards.net [~/public_html]# drush cron
Error while sending QUERY packet. PID=3830 database.inc:2171         [warning]
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array
(
    [:db_insert_placeholder_0] => 0
    [:db_insert_placeholder_1] => cron
    [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file).
    [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:237:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression
FROM
{variable} variable
WHERE ( (name = :db_condition_placeholder_0) ); Array
(
    [:db_condition_placeholder_0] => spambot_last_checked_uid
)
";s:9:"%function";s:14:"variable_set()";s:5:"%file";s:49:"/home/fanbards/public_html/includes/bootstrap.inc";s:5:"%line";i:991;s:14:"severity_level";i:3;}
    [:db_insert_placeholder_4] => 3
    [:db_insert_placeholder_5] =>
    [:db_insert_placeholder_6] => http://default/index.php
    [:db_insert_placeholder_7] =>
    [:db_insert_placeholder_8] => 127.0.0.1
    [:db_insert_placeholder_9] => 1463965857
)
 in dblog_watchdog() (line 163 of /home/fanbards/public_html/modules/dblog/dblog.module).
Drush command terminated abnormally due to an unrecoverable error.   [error]
Error: PHP Startup: Unable to load dynamic library
'/usr/local/lib/php/extensions/no-debug-non-zts-20121212/apc.so' -
/usr/local/lib/php/extensions/no-debug-non-zts-20121212/apc.so:
cannot open shared object file: No such file or directory in Unknown,
line 0

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in /home/fanbards/public_html/includes/database/database.inc:2171
Stack trace:
#0 /home/fanbards/public_html/includes/database/database.inc(2171): PDOStatement->execute(Array)
#1 /home/fanbards/public_html/includes/database/database.inc(683): DatabaseStatementBase->execute(Array, Array)
#2 /home/fanbards/public_html/includes/database/database.inc(2350): DatabaseConnection->query('SELECT expire, ...', Array, Array)
#3 /home/fanbards/public_html/includes/lock.inc(167): db_query('SELECT expire, ...', Array)
#4 /home/fanbards/public_html/includes/lock.inc(146): lock_may_be_available('schema:runtime:...')
#5 /home/fanbards/public_html/includes/bootstrap.inc(433): lock_acquire('schema:runtime:...')
#6 /home/fanbards/public_html/includes/bootstrap.inc(455): DrupalCacheArray->set(Array)
#7 [internal function]: DrupalCacheArray->__destruct()
#8 {main}
  thrown in /home/fanbards/public_html/includes/database/database.inc on line 2171

IT could be an issue in my database, or with some kind of timeout, I'm not sure especially since it's also rerunning solr indexing.

kala4ek’s picture

kala4ek
Primary language Russian
Location 🇷🇺 Novosibirsk
commented
Assigned: Unassigned » kala4ek
Status: Postponed (maintainer needs more info) » Active
nickdickinsonwilde’s picture

nickdickinsonwilde
He/Him/His
Primary language English
Location Victoria, BC (T'So-uke lands)
commented
Status: Active » Closed (outdated)

Drupal 7 is long out of support and ticket has sat for many years with no patch

Now that this issue is closed, please review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, please credit people who helped resolve this issue.