File change detection broke

  • Resolved Woo-Cash

    (@woo-cash)


    10 years, 4 months ago

    I have a problem with file change detection. One day, few weeks ago, it stopped refreshing. It constantly shows me the same list.

    Check Time	Files Added	Files Deleted	Files Changed	Memory Used
2016-01-24 06:07:42	614	85	1963	25.02MB
2016-01-24 06:02:25	614	85	1963	24.53MB
2016-01-23 05:59:19	614	85	1963	24.53MB
2016-01-22 05:53:26	614	85	1963	24.53MB
2016-01-21 05:53:10	614	85	1963	29.19MB

    I investigated today a bit and found error during this job:

    [Sat Jan 23 06:01:32.503011 2016] [fcgid:warn] [pid 20872] [client 66.249.69.109:58832] mod_fcgid: stderr: B\xc5\x82\xc4\x85d Lost connection to MySQL server during query bazy danych WordPressa podczas wykonywania zapytania SHOW FULL COLUMNS FROM<changed>_optionswys\xc5\x82anego przez require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, ITSEC_File_Change->execute_file_check, update_site_option, update_network_option, update_option

    What can I do about it?

    https://wordpress.org/plugins/better-wp-security/

Viewing 7 replies - 1 through 7 (of 7 total)
  • dwinden

    (@dwinden)

    10 years, 4 months ago

    @woo-cash

    Probably a duplicate of this topic.

    If not already enabled, enable the Split file checking into chunks setting or increase the database max_allowed_packets variable (check its current value first using phpMyAdmin).

    dwinden

    Thread Starter Woo-Cash

    (@woo-cash)

    10 years, 4 months ago

    Thanks for reply. Variable is quite big:
    max allowed packet 67,108,864
    I enabled option for the split and will let you know tomorrow if it helped.

    dwinden

    (@dwinden)

    10 years, 4 months ago

    @woo-cash

    Ok, your symptoms are a little bit different.
    And max_allowed_packets is already pretty high (64MB).

    Looks like there is a problem inserting (file change detection) data into the wp_options table.
    WordPress tries to execute ‘SHOW FULL COLUMNS FROM wp_options’ first …
    which fails for some reason.
    Try and run ‘SHOW FULL COLUMNS FROM wp_options’ manually from phpMyAdmin and see what happens.

    What collation do the columns from this table use ? (utf8mb4_unicode_ci)

    dwinden

    Thread Starter Woo-Cash

    (@woo-cash)

    10 years, 4 months ago

    No problem with that query:

    Field 	Type 	Collation 	Null 	Key 	Default 	Extra 	Privileges 	Comment
option_id 	bigint(20) unsigned	NULL	NO 	PRI 	NULL	auto_increment 	select,insert,update,references
option_name 	varchar(191)	utf8mb4_unicode_ci 	YES 	UNI 	NULL		select,insert,update,references
option_value 	longtext	utf8mb4_unicode_ci 	NO 		NULL		select,insert,update,references
autoload 	varchar(20)	utf8mb4_unicode_ci 	NO 		yes		select,insert,update,references

    Collation for table is utf8mb4_unicode_ci.

    The problem started one day, it was working well before that. I don’t remember if I did anything on that particular day but I don’t think I did something big in database.

    dwinden

    (@dwinden)

    10 years, 4 months ago

    @woo-cash

    Ok. It looks like a database\connection issue.
    The ‘Lost connection to MySQL server during query …’ error seems to be generic. There are many many reasons why this can happen.
    There is some interesting and relevant info about it here.

    Hopefully using the File Change Detection split setting solves the issue.
    Let’s wait and see.

    dwinden

    Thread Starter Woo-Cash

    (@woo-cash)

    10 years, 3 months ago

    Yesterday I saw the same error and I think I din’t get any mail, but today I don’t see error and mail is quite different than earlier.

    Scan Time: Tuesday, January 26th 7:30 am UTC
    Files Added: 1468
    Files Deleted: 0
    Files Modified: 0
    Memory Used: 2.26 MB

    It showed me every WordPress file in root folder and all my own files, so maybe something restarted and now it will be OK. I’ll let you know tomorrow.

    Thread Starter Woo-Cash

    (@woo-cash)

    10 years, 3 months ago

    OK, I can confirm, it helped. Thanks a lot.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘File change detection broke’ is closed to new replies.