Skip to content

Update SQLite3 to 3.51.2#2761

Merged
DL6ER merged 1 commit into
developmentfrom
update/sqlite3_51_2
Jan 11, 2026
Merged

Update SQLite3 to 3.51.2#2761
DL6ER merged 1 commit into
developmentfrom
update/sqlite3_51_2

Conversation

@DL6ER

@DL6ER DL6ER commented Jan 10, 2026

Copy link
Copy Markdown
Member

What does this implement/fix?

This is a bugfix release for SQLite3 released earlier today.

CHANGELOG:

  • Fix an obscure deadlock in the new broken-posix-lock detection logic in item 17 above.
  • Fix multiple problems in the EXISTS-to-JOIN optimization that was added as part of optimization item 6b above.
  • Other minor bug fixes.

17 was part of 3.51.0:

  1. Improved resistance to database corruption caused by an application breaking Posix advisory locks using close().

6b as well:

  1. Performance enhancements:
    6b. Early detection of joins that return no rows due to one or more of the tables containing no rows.

Related issue or feature (if applicable): N/A

Pull request in docs with documentation (if applicable): N/A

By submitting this pull request, I confirm the following:

  1. I have read and understood the contributors guide, as well as this entire template. I understand which branch to base my commits and Pull Requests against.
  2. I have commented my proposed changes within the code.
  3. I am willing to help maintain this change if there are issues with it later.
  4. It is compatible with the EUPL 1.2 license
  5. I have squashed any insignificant commits. (git rebase)

Checklist:

  • The code change is tested and works locally.
  • I based my code and PRs against the repositories development branch.
  • I signed off all commits. Pi-hole enforces the DCO for all contributions
  • I signed all my commits. Pi-hole requires signatures to verify authorship
  • I have read the above and my PR is ready for review.

@DL6ER
Update SQLite3 to 3.51.2
90313fd 
Signed-off-by: Dominik <dl6er@dl6er.de>
@DL6ER DL6ER requested a review from a team as a code owner January 10, 2026 10:09
@DL6ER DL6ER added the SQLite3 label Jan 10, 2026
@DL6ER DL6ER merged commit 25ac53d into development Jan 11, 2026
17 checks passed
@DL6ER DL6ER deleted the update/sqlite3_51_2 branch January 11, 2026 18:41
sawsanders added a commit to sawsanders/FTL that referenced this pull request Jan 11, 2026
@sawsanders
Merge pull request #192 from sawsanders/development
7bc3d5e 
Merge pull request pi-hole#2761 from pi-hole/update/sqlite3_51_2
@PromoFaux PromoFaux mentioned this pull request Feb 15, 2026
Merged
alfi0812 pushed a commit to trueforge-org/truecharts that referenced this pull request Feb 21, 2026
@truecharts-admin
BREAKING CHANGE(pihole): Update image ghcr.io/pi-hole/pihole 2025.11.…
9976abe 
…1 → 2026.02.0 (#45320)

This PR contains the following updates:

| Package | Update | Change |
|---|---|---|
|
[ghcr.io/pi-hole/pihole](https://redirect.github.com/pi-hole/docker-pi-hole)
| major | `91dc91d` → `ee34852` |

---

> [!WARNING]
> Some dependencies could not be looked up. Check the [Dependency
Dashboard](../issues/18710) for more information.

Add the preset `:preserveSemverRanges` to your config if you don't want
to pin your dependencies.

---

### Release Notes

<details>
<summary>pi-hole/docker-pi-hole (ghcr.io/pi-hole/pihole)</summary>

###
[`v2026.02.0`](https://redirect.github.com/pi-hole/docker-pi-hole/releases/tag/2026.02.0)

[Compare
Source](https://redirect.github.com/pi-hole/docker-pi-hole/compare/2025.11.1...2026.02.0)

<!-- Release notes generated using configuration in .github/release.yml
at master -->

#### What's Changed (Docker Specific)

- Pin base image by sha to catch silent rebuilds by
[@&#8203;yubiuser](https://redirect.github.com/yubiuser) in
[#&#8203;1965](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1965)
- Set fixed buildx version to mitigate issues with buildx version 0.31.1
by [@&#8203;yubiuser](https://redirect.github.com/yubiuser) in
[#&#8203;1987](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1987)

**Full Changelog**:
<pi-hole/docker-pi-hole@2025.11.1...2026.02.0>

***

<!-- Release notes generated using configuration in .github/release.yml
at development -->

#### What's Changed (FTL v6.5)

- Tweak undocumented wait-for option subtly by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2707](https://redirect.github.com/pi-hole/FTL/pull/2707)
- update gravity - improve domain validation processing speed by
[@&#8203;rrobgill](https://redirect.github.com/rrobgill) in
[pi-hole/FTL#2710](https://redirect.github.com/pi-hole/FTL/pull/2710)
- Update embedded SQLite3 to 3.51.1 by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2731](https://redirect.github.com/pi-hole/FTL/pull/2731)
- Update embedded dnsmasq to 2.92rc1 by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2730](https://redirect.github.com/pi-hole/FTL/pull/2730)
- Fix documentation - Do not use equal sign with `pihole-FTL --config`
command by
[@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in
[pi-hole/FTL#2736](https://redirect.github.com/pi-hole/FTL/pull/2736)
- Add dns.cache.rrtype by
[@&#8203;Manakuremati](https://redirect.github.com/Manakuremati) in
[pi-hole/FTL#2740](https://redirect.github.com/pi-hole/FTL/pull/2740)
- Enhancements to the documentation markdown generator by
[@&#8203;PromoFaux](https://redirect.github.com/PromoFaux) in
[pi-hole/FTL#2741](https://redirect.github.com/pi-hole/FTL/pull/2741)
- Network Overview - obtain MAC and hostname from dhcp.leases by
[@&#8203;rrobgill](https://redirect.github.com/rrobgill) in
[pi-hole/FTL#2727](https://redirect.github.com/pi-hole/FTL/pull/2727)
- fix: make `get_domains` parameters optional by
[@&#8203;tien](https://redirect.github.com/tien) in
[pi-hole/FTL#2278](https://redirect.github.com/pi-hole/FTL/pull/2278)
- Escape unprintable characters in invalid host names by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2601](https://redirect.github.com/pi-hole/FTL/pull/2601)
- Implement better allOf handling in API verifier by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2745](https://redirect.github.com/pi-hole/FTL/pull/2745)
- Update build containers to Alpine 3.23 by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2743](https://redirect.github.com/pi-hole/FTL/pull/2743)
- Add option to hide network connection errors by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2749](https://redirect.github.com/pi-hole/FTL/pull/2749)
- Harden default Content Security Policy (CSP) by
[@&#8203;Erasure5959](https://redirect.github.com/Erasure5959) in
[pi-hole/FTL#2754](https://redirect.github.com/pi-hole/FTL/pull/2754)
- Fix computation of NTP server's root delay by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2760](https://redirect.github.com/pi-hole/FTL/pull/2760)
- Teleporter: Fix for custom gravity.db path by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2758](https://redirect.github.com/pi-hole/FTL/pull/2758)
- Upgrade embedded Lua to 5.5 by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2626](https://redirect.github.com/pi-hole/FTL/pull/2626)
- Add missing \[forwarded] property in GET /api/history/database by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2750](https://redirect.github.com/pi-hole/FTL/pull/2750)
- Update SQLite3 to 3.51.2 by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2761](https://redirect.github.com/pi-hole/FTL/pull/2761)
- Low-memory hardware optimizations by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2757](https://redirect.github.com/pi-hole/FTL/pull/2757)
- Reduce startup delay by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2725](https://redirect.github.com/pi-hole/FTL/pull/2725)
- home.arpa and internal TLDs may be non-local without revServer by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/FTL#2772](https://redirect.github.com/pi-hole/FTL/pull/2772)

#### New Contributors

- [@&#8203;Erasure5959](https://redirect.github.com/Erasure5959) made
their first contribution in
[pi-hole/FTL#2754](https://redirect.github.com/pi-hole/FTL/pull/2754)

**Full Changelog**:
<pi-hole/FTL@v6.4.1...v6.5>

<!-- Release notes generated using configuration in .github/release.yml
at development -->

#### What's Changed (Web v6.4.1)

- Set the end date for live query update to end of epoch by
[@&#8203;rrobgill](https://redirect.github.com/rrobgill) in
[pi-hole/web#3677](https://redirect.github.com/pi-hole/web/pull/3677)
- Improve initial loading of Query Log by
[@&#8203;DL6ER](https://redirect.github.com/DL6ER) in
[pi-hole/web#3715](https://redirect.github.com/pi-hole/web/pull/3715)

Also fixes two security advisories:

-
<GHSA-6xp4-jw73-f4qp>:
fixed with
[pi-hole/web@`d328f14`](https://redirect.github.com/pi-hole/web/commit/d328f143718022d82dc94c8751121ca41be3b996)
-
<GHSA-8rw8-vjgp-rwj6>:
fixed with
[pi-hole/web@`1a0c6f4`](https://redirect.github.com/pi-hole/web/commit/1a0c6f4fe6d0116fd2846b2adaae95996b7f194d)

**Full Changelog**:
<pi-hole/web@v6.4...v6.4.1>

<!-- Release notes generated using configuration in .github/release.yml
at development -->

#### What's Changed (Core v6.4)

- Remove wget from alpine dependencies by
[@&#8203;darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx)
in
[pi-hole/pi-hole#6484](https://redirect.github.com/pi-hole/pi-hole/pull/6484)
- Remove custom FTL FirewallD zone checks from debug log by
[@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in
[pi-hole/pi-hole#6481](https://redirect.github.com/pi-hole/pi-hole/pull/6481)
- Add Alpine 3.23 to test suite by
[@&#8203;yubiuser](https://redirect.github.com/yubiuser) in
[pi-hole/pi-hole#6488](https://redirect.github.com/pi-hole/pi-hole/pull/6488)
- Debug log - Add colors to gravity tables by
[@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in
[pi-hole/pi-hole#6485](https://redirect.github.com/pi-hole/pi-hole/pull/6485)
- Use configured location for web repo when updating or repairing by
[@&#8203;rrobgill](https://redirect.github.com/rrobgill) in
[pi-hole/pi-hole#6470](https://redirect.github.com/pi-hole/pi-hole/pull/6470)
- Add missing `-g` to the message in gravity recovery command by
[@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in
[pi-hole/pi-hole#6513](https://redirect.github.com/pi-hole/pi-hole/pull/6513)
- Don't install unused /usr/local/share/man/man5 by
[@&#8203;darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx)
in
[pi-hole/pi-hole#6526](https://redirect.github.com/pi-hole/pi-hole/pull/6526)

**Full Changelog**:
<pi-hole/pi-hole@v6.3...v6.4>

</details>

---

### Configuration

📅 **Schedule**: Branch creation - At any time (no schedule defined),
Automerge - At any time (no schedule defined).

🚦 **Automerge**: Disabled by config. Please merge this manually once you
are satisfied.

♻ **Rebasing**: Whenever PR becomes conflicted, or you tick the
rebase/retry checkbox.

🔕 **Ignore**: Close this PR and you won't be reminded about this update
again.

---

- [ ] <!-- rebase-check -->If you want to rebase/retry this PR, check
this box

---

This PR has been generated by [Renovate
Bot](https://redirect.github.com/renovatebot/renovate).

<!--renovate-debug:eyJjcmVhdGVkSW5WZXIiOiI0My4yNi4xIiwidXBkYXRlZEluVmVyIjoiNDMuMjkuMiIsInRhcmdldEJyYW5jaCI6Im1hc3RlciIsImxhYmVscyI6WyJhcHAvcGlob2xlIiwicmVub3ZhdGUvY29udGFpbmVyIiwidHlwZS9tYWpvciJdfQ==-->
github-actions Bot pushed a commit to bigbeartechworld/big-bear-universal-apps that referenced this pull request Feb 26, 2026
@renovate
chore(deps): update bigbeartechworld/big-bear-pihole-unbound docker t…
c76083c 
…ag to v2026

This PR contains the following updates:

| Package | Update | Change |
|---|---|---|
| [bigbeartechworld/big-bear-pihole-unbound](https://redirect.github.com/pi-hole/docker-pi-hole) | major | `2025.11.1` → `2026.02.0` |

---

> [!WARNING]
> Some dependencies could not be looked up. Check the [Dependency Dashboard](../issues/17) for more information.

---

### Release Notes

<details>
<summary>pi-hole/docker-pi-hole (bigbeartechworld/big-bear-pihole-unbound)</summary>

### [`v2026.02.0`](https://redirect.github.com/pi-hole/docker-pi-hole/releases/tag/2026.02.0)

[Compare Source](https://redirect.github.com/pi-hole/docker-pi-hole/compare/2025.11.1...2026.02.0)

<!-- Release notes generated using configuration in .github/release.yml at master -->

#### What's Changed (Docker Specific)

- Pin base image by sha to catch silent rebuilds by [@&#8203;yubiuser](https://redirect.github.com/yubiuser) in [#&#8203;1965](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1965)
- Set fixed buildx version to mitigate issues with buildx version 0.31.1 by [@&#8203;yubiuser](https://redirect.github.com/yubiuser) in [#&#8203;1987](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1987)

**Full Changelog**: <pi-hole/docker-pi-hole@2025.11.1...2026.02.0>

***

<!-- Release notes generated using configuration in .github/release.yml at development -->

#### What's Changed (FTL v6.5)

- Tweak undocumented wait-for option subtly by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2707](https://redirect.github.com/pi-hole/FTL/pull/2707)
- update gravity - improve domain validation processing speed by [@&#8203;rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2710](https://redirect.github.com/pi-hole/FTL/pull/2710)
- Update embedded SQLite3 to 3.51.1 by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2731](https://redirect.github.com/pi-hole/FTL/pull/2731)
- Update embedded dnsmasq to 2.92rc1 by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2730](https://redirect.github.com/pi-hole/FTL/pull/2730)
- Fix documentation - Do not use equal sign with `pihole-FTL --config` command by [@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/FTL#2736](https://redirect.github.com/pi-hole/FTL/pull/2736)
- Add dns.cache.rrtype by [@&#8203;Manakuremati](https://redirect.github.com/Manakuremati) in [pi-hole/FTL#2740](https://redirect.github.com/pi-hole/FTL/pull/2740)
- Enhancements to the documentation markdown generator by [@&#8203;PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2741](https://redirect.github.com/pi-hole/FTL/pull/2741)
- Network Overview - obtain MAC and hostname from dhcp.leases by [@&#8203;rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2727](https://redirect.github.com/pi-hole/FTL/pull/2727)
- fix: make `get_domains` parameters optional by [@&#8203;tien](https://redirect.github.com/tien) in [pi-hole/FTL#2278](https://redirect.github.com/pi-hole/FTL/pull/2278)
- Escape unprintable characters in invalid host names by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2601](https://redirect.github.com/pi-hole/FTL/pull/2601)
- Implement better allOf handling in API verifier by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2745](https://redirect.github.com/pi-hole/FTL/pull/2745)
- Update build containers to Alpine 3.23 by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2743](https://redirect.github.com/pi-hole/FTL/pull/2743)
- Add option to hide network connection errors by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2749](https://redirect.github.com/pi-hole/FTL/pull/2749)
- Harden default Content Security Policy (CSP) by [@&#8203;Erasure5959](https://redirect.github.com/Erasure5959) in [pi-hole/FTL#2754](https://redirect.github.com/pi-hole/FTL/pull/2754)
- Fix computation of NTP server's root delay by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2760](https://redirect.github.com/pi-hole/FTL/pull/2760)
- Teleporter: Fix for custom gravity.db path by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2758](https://redirect.github.com/pi-hole/FTL/pull/2758)
- Upgrade embedded Lua to 5.5 by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2626](https://redirect.github.com/pi-hole/FTL/pull/2626)
- Add missing \[forwarded] property in GET /api/history/database by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2750](https://redirect.github.com/pi-hole/FTL/pull/2750)
- Update SQLite3 to 3.51.2 by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2761](https://redirect.github.com/pi-hole/FTL/pull/2761)
- Low-memory hardware optimizations by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2757](https://redirect.github.com/pi-hole/FTL/pull/2757)
- Reduce startup delay by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2725](https://redirect.github.com/pi-hole/FTL/pull/2725)
- home.arpa and internal TLDs may be non-local without revServer by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2772](https://redirect.github.com/pi-hole/FTL/pull/2772)

#### New Contributors

- [@&#8203;Erasure5959](https://redirect.github.com/Erasure5959) made their first contribution in [pi-hole/FTL#2754](https://redirect.github.com/pi-hole/FTL/pull/2754)

**Full Changelog**: <pi-hole/FTL@v6.4.1...v6.5>

<!-- Release notes generated using configuration in .github/release.yml at development -->

#### What's Changed (Web v6.4.1)

- Set the end date for live query update to end of epoch by [@&#8203;rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/web#3677](https://redirect.github.com/pi-hole/web/pull/3677)
- Improve initial loading of Query Log by [@&#8203;DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/web#3715](https://redirect.github.com/pi-hole/web/pull/3715)

Also fixes two security advisories:

- <GHSA-6xp4-jw73-f4qp>: fixed with [pi-hole/web@`d328f14`](https://redirect.github.com/pi-hole/web/commit/d328f143718022d82dc94c8751121ca41be3b996)
- <GHSA-8rw8-vjgp-rwj6>: fixed with [pi-hole/web@`1a0c6f4`](https://redirect.github.com/pi-hole/web/commit/1a0c6f4fe6d0116fd2846b2adaae95996b7f194d)

**Full Changelog**: <pi-hole/web@v6.4...v6.4.1>

<!-- Release notes generated using configuration in .github/release.yml at development -->

#### What's Changed (Core v6.4)

- Remove wget from alpine dependencies by [@&#8203;darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx) in [pi-hole/pi-hole#6484](https://redirect.github.com/pi-hole/pi-hole/pull/6484)
- Remove custom FTL FirewallD zone checks from debug log by [@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/pi-hole#6481](https://redirect.github.com/pi-hole/pi-hole/pull/6481)
- Add Alpine 3.23 to test suite by [@&#8203;yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/pi-hole#6488](https://redirect.github.com/pi-hole/pi-hole/pull/6488)
- Debug log - Add colors to gravity tables by [@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/pi-hole#6485](https://redirect.github.com/pi-hole/pi-hole/pull/6485)
- Use configured location for web repo when updating or repairing by [@&#8203;rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6470](https://redirect.github.com/pi-hole/pi-hole/pull/6470)
- Add missing `-g` to the message in gravity recovery command by [@&#8203;rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/pi-hole#6513](https://redirect.github.com/pi-hole/pi-hole/pull/6513)
- Don't install unused /usr/local/share/man/man5 by [@&#8203;darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx) in [pi-hole/pi-hole#6526](https://redirect.github.com/pi-hole/pi-hole/pull/6526)

**Full Changelog**: <pi-hole/pi-hole@v6.3...v6.4>

</details>

---

### Configuration

📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 **Automerge**: Disabled by config. Please merge this manually once you are satisfied.

♻ **Rebasing**: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 **Ignore**: Close this PR and you won't be reminded about this update again.

---

 - [ ] <!-- rebase-check -->If you want to rebase/retry this PR, check this box

---

This PR was generated by [Mend Renovate](https://mend.io/renovate/). View the [repository job log](https://developer.mend.io/github/bigbeartechworld/big-bear-universal-apps).
<!--renovate-debug:eyJjcmVhdGVkSW5WZXIiOiI0My4zNi4yIiwidXBkYXRlZEluVmVyIjoiNDMuMzYuMiIsInRhcmdldEJyYW5jaCI6Im1haW4iLCJsYWJlbHMiOlsiZGVwZW5kZW5jaWVzIiwicmVub3ZhdGUiXX0=-->
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@PromoFaux PromoFaux PromoFaux approved these changes

Assignees

No one assigned

Labels

SQLite3

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@DL6ER @PromoFaux