Issue: Cannot Create New Wiki Pages

Editing existing pages is fine.

No errors in server log.

Will check NGINX

xxx - - [11/Feb/2021:21:36:02 +0000] "GET /Folklore/Sandbox:another-test HTTP/2.0" 301 369 "https://chroniclesrp.net/Folklore/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"

xxx - - [11/Feb/2021:21:36:02 +0000] "GET /Folklore/ HTTP/2.0" 200 28146 "https://chroniclesrp.net/Folklore/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"

xxx - - [11/Feb/2021:21:36:03 +0000] "POST /index.php?Folklore-ajax/&c=feed HTTP/2.0" 200 3992 "https://chroniclesrp.net/Folklore/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"

xxx - - [11/Feb/2021:21:36:05 +0000] "GET /service_worker.js HTTP/2.0" 304 265 "https://chroniclesrp.net/service_worker.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"

No clues there

I've taken the emergency step of rolling back all files to patch 1

I can now create new pages again, but cant access the new pages created with patch 2.

I will attempt to recover these from the database

Goodness what is the xf_vw_defer table and why is it by a significant fraction the largest table in my database?

Right only one page it seems, found the relevant revision but it's not stored as text

| 16463 | Ceridwen | ZVLLbtswELzrK/bUnGJZclzLRdXCSfNokRRBUyAHwQhW4sokTJECSUcVoI/vynbSIgEE8KGd2ZlZFoGaVmOg9XdT29L+eaokOqwCuWhQDW4olyG0/lMcV8JMhPKVdQLbdlLZJsYQsJINmeDjRZali2S5TJJ5ms0+fkzSOJsu52 mySObZ2exsls6nWZxO0+l0mSyektlZkiaT1myiwWBDefGMbn2/ur78ubq7LOLxFA2lckGyvoryGwyVJAHKwBXqk5UQ6KNhFDjPokFapvjv3 o2QB4ktealqdgOncO1UXSsTDRsyglx+RQ1qYiypjQx5NDToPS8SleOFeh pPfqsML7aqdi0GZU1+szPBkecunVNMzX8rR5yh4B0+Y0CXr0yQzp4eWwK 6MAqwWpDprK7JjPlF0c2uQQO1dQ1cvOTOhReuHy/hG3YGyh5+WE+thDvFwyENt8p4wwMq4tfpRY+jFEDwu6ZBhrfMtnHIKCzt LkBvdw5eZwuSHEWFzNP1qm2Jb01FRSzX0edzp6jWPQjylVMlQSfxHVxbu/Wg1Za+HFgetkprD2gErEqlVVDkD3y3ygfWVVMHW+rBHwrfykF/JLon561BZugP+MexvXqLOPHQ/qvcK/m6Z0jW58rujffwAW6tO9r6LZmDv250fiATFFBpflLlK6JjcbCxE7gizrl 2RBAs8KhaTRxvGEk8VeMzgDF3t3eMQoxlin2+cybombRt/VHcL6q5P4d9SCcqHIfNCa2L+GX3Fw== | | | | 1613075905 | 0 | 2395 | 0 | 4479 | Ceridwen | 915 | 19 | 915 | 1 | | 0 | | on_nl2br | 1 | 31,32 | [] | 0 | 388547 | -2 | 0 | 0 | | 0 | 0 | 0.00 |

Managed to drag the raw html for the lost page from the xf_vw_parsed table

I've left some broken articles here: https://chroniclesrp.net/Folklore/Sandbox

The rest I'm removing

I don't see an obvious reason for this, based on the code that was changed in PL 2.

You mentioned that the xf_vw_defer table was unexpectedly large. Please check that you are not approaching filling up the disk partition. I had this happen to me in the past and had strange issues like that. If this is occurring you can safely remove xf_vw_defer records WHERE completed = 1. Those are basically just log records at this point. I will see about improving the pruning on this table for the next version.

I will attempt a review of your site today. Maybe I can determine what data is missing or corrupted on the remaining "lost pages" which might give some clues.

Disk is fine, it's only 0.5gb, but that's a significant chunk of the 2.5Gb database.

All the other storage is offloaded to object-level storage services now.

I also did a quick compare of the two code bases (someone spotted a typo in the word attributes I see) and tried rolling back a few individual files. However when I rolled the entire filestore back to Patch 1 I could make new pages again.

select * from xf_vw_defer order by deferid desc limit 10;
+---------+------------+--------+------+-----------+--------+-------------+--------------------------------------------------------------------------------------------------------------------------------+
| deferid | dateline | locked | hold | completed | defer | action | data |
+---------+------------+--------+------+-----------+--------+-------------+--------------------------------------------------------------------------------------------------------------------------------+
| 755330 | 1613143199 | 0 | 0 | 1 | totals | delete | {"condition":true,"item":false,"queueid":52072,"info":{"a ction":"delete","isDelete":true,"cut":1613143124,"purpose ":"totDel"}} |
| 755329 | 1613143124 | 0 | 0 | 1 | totals | ratings | {"condition":true,"item":false,"queueid":52072,"info":{"a ction":"ratings","cut":1613143124,"purpose":"totRate"}} |
| 755328 | 1613143124 | 0 | 0 | 1 | totals | discussions | {"condition":true,"item":false,"queueid":52072,"info":{"a ction":"discussions","cut":1613143124,"purpose":"totTalks "}} |
| 755327 | 1613143124 | 0 | 0 | 1 | totals | edits | {"condition":true,"item":false,"queueid":52072,"info":{"a ction":"edits","cut":1613143124,"purpose":"totEdits"}} |
| 755326 | 1613143124 | 0 | 0 | 1 | totals | routes | {"condition":true,"item":false,"queueid":52072,"info":{"a ction":"routes","cut":1613143124,"purpose":"totRoutes"}} |
| 755288 | 1613139538 | 0 | 0 | 1 | totals | delete | {"condition":true,"item":false,"queueid":52071,"info":{"a ction":"delete","isDelete":true,"cut":1613139537,"purpose ":"totDel"}} |
| 755287 | 1613139537 | 0 | 0 | 1 | totals | ratings | {"condition":true,"item":false,"queueid":52071,"info":{"a ction":"ratings","cut":1613139537,"purpose":"totRate"}} |
| 755286 | 1613139537 | 0 | 0 | 1 | totals | discussions | {"condition":true,"item":false,"queueid":52071,"info":{"a ction":"discussions","cut":1613139537,"purpose":"totTalks "}} |
| 755285 | 1613139537 | 0 | 0 | 1 | totals | edits | {"condition":true,"item":false,"queueid":52071,"info":{"a ction":"edits","cut":1613139537,"purpose":"totEdits"}} |
| 755284 | 1613139537 | 0 | 0 | 1 | totals | routes | {"condition":true,"item":false,"queueid":52071,"info":{"a ction":"routes","cut":1613139537,"purpose":"totRoutes"}} |
+---------+------------+--------+------+-----------+--------+-------------+--------------------------------------------------------------------------------------------------------------------------------+

755000 entries

91569 rows remaining that are all marked as completed.

Well that's 25% of my database cleared out with one query.

Updated the current patch. This should affect all platforms using 4.1.1 PL 2, where new pages created under the patch would have vw_route.pathid = 0 even though Friendly URLs are turned on, resulting in the new page not being found at its URL, being redirected to the page at the next level up. There are other side effects, such as counters and metadata never updating on affected pages, not appearing in search results, and more.

(It was not occurring on the XF demo due to Friendly URLs being turned off.)

Affected users looking for a quick edit: you can fix the issue for future new pages by editing src/addons/vw/vw/_core/controller/dm/vw.php. Find:
Replace with:
You can repair the URLs of affected pages by running Maintenance > Rebuild Counters / Caches > Rebuild Content URLs. You can repair other side effects by running the following query:
And issuing a subsequent edit that includes a history-eligible change.

Thanks for that!

Before I download and reinstall patch 2 do you know if https://www.vaultwiki.org/issues/6148/ has been fixed in that release or if I will need to do it again?

diffs show that is also fixed.

When I run the query, I get:
Error
Table 'my_database_vw_counter' doesn't exist