FB_LOCK_PRINT(1)

💅 FB_LOCK_PRINT — bestie edition ✨

okay so you're here because something in your Firebird database is being messy with locks and you need the tea. fb_lock_print is a section-1 (user command) manual page from the Firebird documentation set, and it's literally your lock forensics bestie. 🕵️♀️🦋

---

🌸 NAME 🌸

fb_lock_print — all the info about Firebird database locks, no cap 💖

---

✨ SYNOPSIS ✨

fb_lock_print -d database [option...]
fb_lock_print -f lockfile [option...]

two ways in, bestie: point it at a database, or point it at a lockfile. pick your fighter. 💅

---

🎀 DESCRIPTION 🎀

so fb_lock_print is the tool that displays the information from the Firebird lock system. that's it, that's the vibe. and like… it's genuinely useful when you're debugging lock contention / conflict / performance problems, because you can literally see who's holding what and why nobody's moving. it's giving main character energy in your debugging session. 🔥

---

👑 OPTIONS 👑

• -d database — print lock information about the specified database. 🗄️
• -f lockfile — print lock information from the specified lockfile. and heads up bestie, Firebird lock files live in /tmp/firebird. 📂
• -o | -p — print info about lock owner blocks. this one is on by default, so it's already doing the thing unless you say otherwise. ✨
• -c — consistency mode. blocks the lock manager so that no changes to the lock blocks can be made while the information is gathered. lowkey invasive but that's the point 🛑
• -l — print info about lock blocks. 🔒
• -r — print info about lock request blocks. 🙋♀️
• -h — print info about lock history. 📜
• -a — print info about owner blocks, lock blocks, request blocks and history. same as "-o -l -r -h". the whole combo meal 🍓
• -s num — print info about lock series num. 🔢
• -i[filter] interval count — enter interactive mode and continuously display lock counters per second. so you just… watch the numbers go 📈
  • possible filters are:
    • a — lock acquires
    • o — lock operations: enqueues, conversions, downgrades, dequeues, reads, writes and queries
    • t — lock operations by type.
    • w — lock waits
  • if no filter is given, all activity is shown. (the [filter] being in brackets is a lil hint that it's optional, iykyk 🫶)
  • interval is the interval in seconds between displays. count instructs fb_lock_print to exit after that many displays — so it's not an infinite loop situation, it'll actually let you go. 🌈
• -w — print a recursive list of locks each lock waits for. the dependency tree of doom, iconic 💀
• -m — HTML output. yes queen, format it 🌐

---

📝 AUTHOR & COPYRIGHT 📝

Copyright (C) Damyan Ivanov, 2009.

this manpage was written by Damyan Ivanov for the Debian project but may be used by others. permission is granted to use this document, with or without modifications, provided that this notice is retained. and — direct quote vibes — if we meet some day, and you think this stuff is worth it, you can buy me a beer in return. 🍺 (an absolute legend, fr fr)

---

reminder bestie: this manpage is part of the Firebird 4.0 documentation, dated 2026-06-28, and it's filed under FB_LOCK_PRINT(1).

okay that's the whole page, go forth and debug your locks, you've got this 💖✨🦋