XF 1.4 Long wait times on thread creation, resulting in dup threads

[kontrabass]

Hi all,

So lately, in some of our more popular forums, we've been getting a lot of duplicate thread submissions. This is happening because it takes 10+ seconds for the thread to "go through". The progress bars appear, user waits, clicks "create thread" again, and the thread is posted twice (or 3 or 4 times heh). During peak hours, sometimes the user gets no confirmation the thread was posted (no drop-down, no redirect to the thread). The web server and db server loads are very low.

I can test this again and again, always the same wait. Oddly, this is only a problem in one or two subforums (our classifieds forums, which run a couple addons). I've tried disabling the addons, but there's no change. Here's the query list when the wait is occuring:

| 76052008 | xfdbuser  | 192.168.0.1:48566 | xenforodb | Execute        |       2 | update                                                                | INSERT INTO xf_data_registry
                (data_key, data_value)
            VALUES
                ('deferredRun', 'i:1417669409;')
            ON DUPLICATE KEY UPDATE
                data_value = VALUES(data_value) |    0.000 |
| 76052036 | xfdbuser  | 192.168.0.1:48602 | xenforodb | Execute        |       2 | update                                                                | INSERT INTO xf_data_registry
                (data_key, data_value)
            VALUES
                ('deferredRun', 'i:1417669409;')
            ON DUPLICATE KEY UPDATE
                data_value = VALUES(data_value) |    0.000 |
| 76052043 | xfdbuser  | 192.168.0.1:48611 | xenforodb | Execute        |       2 | update                                                                | INSERT INTO xf_data_registry
                (data_key, data_value)
            VALUES
                ('deferredRun', 'i:1417669409;')
            ON DUPLICATE KEY UPDATE
                data_value = VALUES(data_value) |    0.000 |
| 76052050 | xfdbuser  | 192.168.0.1:48619 | xenforodb | Execute        |       1 | update                                                                | INSERT INTO xf_data_registry
                (data_key, data_value)
            VALUES
                ('deferredRun', 'i:1417669410;')
            ON DUPLICATE KEY UPDATE
                data_value = VALUES(data_value) |    0.000 |
| 76052068 | xfdbuser  | 192.168.0.1:48647 | xenforodb | Execute        |       1 | update                                                                | INSERT INTO xf_data_registry
                (data_key, data_value)
            VALUES
                ('deferredRun', 'i:1417669410;')
            ON DUPLICATE KEY UPDATE
                data_value = VALUES(data_value) |    0.000 |
| 76052073 | xfdbuser  | 192.168.0.1:48654 | xenforodb | Execute        |       0 | update                                                                | INSERT INTO xf_data_registry
                (data_key, data_value)
            VALUES
                ('deferredRun', 'i:1417669411;')
            ON DUPLICATE KEY UPDATE
                data_value = VALUES(data_value) |    0.000 |

Any ideas?

Thanks!

 

[MattW]

(Now I get the fun job of telling our 2-3,000 daily app users that we're going to wipe the app)

I don't envy you having to do that!