Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.1.1
    • Fix Version/s: 3.1.7-RC1
    • Component/s: ACP
    • Labels:
      None
    • Environment:
      PHP 5.5.18, PostgreSQL 9.3.5 on x86_64-redhat-linux-gnu (Fedora 20), Firefox 31.0

      Description

      I wish to reduce the size of my test database by pruning inactive users. In Prune users, I selected the following parameters:

      Username: *
      Last active: Before 2014-06-30
      Delete pruned user posts: Yes
      Deactivate or delete: Delete

      After waiting 15 minutes, I received the confirmation page listing 33526 members, all boxes are checked.

      Then, are you sure you wish to carry out this operation? Yes

      I am immediately taken the the Forums --> Prune forum entry screen in the administration control panel. There are no messages, no prune operation is performed.

      The prune operation has failed silently. No other problems are experienced.

      My statistics:
      PostgreSQL database size: 12 GB
      Total posts: 2076723
      Total topics: 136982
      Total members 37742

      ======================
      I attempted a similar operation on my 3.0.12 database. The prune operation starts, then fails 2 hours later with:

      General Error
      SQL ERROR [ postgres ]

      ERROR: stack depth limit exceeded HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate. []

      SQL

      SELECT search_key FROM search_results WHERE search_keywords...(a very long message)

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/includes/db/dbal.php
      LINE: 754
      CALL: trigger_error()

      FILE: [ROOT]/includes/db/postgres.php
      LINE: 211
      CALL: dbal->sql_error()

      FILE: [ROOT]/includes/search/search.php
      LINE: 283
      CALL: dbal_postgres->sql_query()

      FILE: [ROOT]/includes/search/fulltext_native.php
      LINE: 1337
      CALL: search_backend->destroy_cache()

      FILE: [ROOT]/includes/functions_admin.php
      LINE: 868
      CALL: fulltext_native->index_remove()

      FILE: [ROOT]/includes/functions_user.php
      LINE: 496
      CALL: delete_posts()

      FILE: [ROOT]/includes/acp/acp_prune.php
      LINE: 261
      CALL: user_delete()

      FILE: [ROOT]/includes/acp/acp_prune.php
      LINE: 44
      CALL: acp_prune->prune_users()

      FILE: [ROOT]/includes/functions_module.php
      LINE: 507
      CALL: acp_prune->main()

      FILE: [ROOT]/adm/index.php
      LINE: 74
      CALL: p_master->load_active()
      ===============================
      Based on the above results, the phpBB 3.1.1 operation should have failed with an error message.

      This problem is posted in https://www.phpbb.com/community/viewtopic.php?f=466&t=2271696.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                prototech prototech [X] (Inactive)
                Reporter:
                Lady_G Lady_G
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: