# SQL script cause database to lock block

**URL:** <https://forum.inductiveautomation.com/t/sql-script-cause-database-to-lock-block/79246>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 16, 2023, 1:37am UTC](https://forum.inductiveautomation.com/t/sql-script-cause-database-to-lock-block/79246 "2023-09-16T01:37:24Z")\
**Posts on this page:** 1\
**Showing post:** 52

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 30, 2023, 11:13pm UTC](https://forum.inductiveautomation.com/t/sql-script-cause-database-to-lock-block/79246/52 "2023-11-30T23:13:24Z")

</div>

The ranking of log levels is exactly as pictured in that dropdown - trace \< debug \< info \< warn \< error \< fatal (which we never use in Ignition).

If you log a message in your script, it is logged to the gateway system log (per the `logback.xml` file in the gateway install directory) as well as output to `stdout`, which is captured by the 'service wrapper' process and dumped to the `wrapper.log` automatically rolling journal (which can be configured via the `ignition.conf` file).

The setting on the gateway webpage only controls what is shown on that particular page.

There are a few rare use cases where an individual logger uses the `logger.isTraceEnabled()` or `isDebugEnabled()` methods to check the _global_ state of a particular logger (which _is_ configurable on that page in the settings menu, or via [`system.util.setLoggingLevel`](https://docs.inductiveautomation.com/display/DOC81/system.util.setLoggingLevel)), but that's rare and not the primary action you'd undertake on that page.

Finally, if you're looking to interact with the `system_logs.idb`, or a diagnostics bundle, or a variety of other file formats Ignition can export that are useful for troubleshooting/diagnostics, may I not-so-humbly plug [Kindling](https://forum.inductiveautomation.com/t/kindling-a-collection-of-tools-to-help-with-ignition/54689), a tool I originally created to help our internal support team that has since been publicly released and semi-officially blessed.

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-script-cause-database-to-lock-block/79246)._