Logo

Contents:

  • Getting Started
    • Preparing Your Machine to Install SQreamDB
    • Installing SQreamDB
    • Executing Statements in SQreamDB
    • Performing Basic SQream Operations
      • Running the SQream SQL Client
      • Creating Your First Table
      • Listing Tables
      • Inserting Rows
      • Running Queries
      • Deleting Rows
      • Saving Query Results to a CSV or PSV File
    • Hardware Guide
    • Staging and Development Hardware Guide
  • Installation Guides
    • Installing and Launching SQreamDB
      • Pre-Installation Configuration
      • Installing SQream Using Binary Packages
      • Installing Monit
      • Launching SQream with Monit
    • Installing SQream Studio
      • Installing Studio on a Stand-Alone Server
      • Installing an NGINX Proxy Over a Secure Connection
    • Upgrade Guides
      • Version Upgrade
      • Upgrade-Related Configuration Changes
  • SQreamDB on AWS
  • Operational Guides
    • Access Control
      • Overview
      • Password Policy
      • Managing Roles
      • Permissions
      • Departmental Example
    • Creating or Cloning Storage Clusters
    • Working with External Data
    • Foreign Tables
    • Health Monitoring
    • Deleting Data
    • Logging
    • Query Split
    • Monitoring Query Performance
    • Security
    • Saved Queries
    • Optimization and Best Practices
    • Oracle Migration Guide
  • Configuration Guides
    • Configuring SQream
      • Cluster and Session
      • Workers
      • Modification Methods
      • Parameter Values
      • Showing All Flags in the Catalog Table
    • LDAP
    • Single Sign-On
  • Architecture
    • Internals and Architecture
    • Filesystem and Usage
    • Sizing
  • Acceleration Studio
    • Getting Started with SQream Acceleration Studio
    • Executing Statements and Running Queries from the Editor
    • Viewing Logs
    • Creating, Assigning, and Managing Roles and Permissions
    • Configuring Your Instance of SQreams
  • Connecting to SQreamDB
    • Client Platforms
      • Denodo Platform
      • Informatica Cloud Services
      • MicroStrategy
      • Pentaho Data Integration
      • PHP
      • BI Desktop
      • R
      • SAP BusinessObjects
      • SAS Viya
      • Semarchy
      • SQL Workbench
      • Tableau
      • Talend
      • TIBCO Spotfire
    • Client Drivers
      • SQreamNET
      • Dataiku
      • JDBC
      • Node.JS
      • ODBC
        • Install and Configure ODBC on Windows
        • Install and configure ODBC on Linux
      • Python (pysqream)
      • Spark
      • Trino
  • Data Ingestion Sources
    • Overview
    • Avro
    • CSV
    • Parquet
    • ORC
    • JSON
    • SQLoader As a Service
      • Preparing Oracle for Data Migration
  • External Storage Platforms
    • Azure Blob Storage
    • Google Cloud Platform
    • HDFS Environment
    • Amazon Web Services
  • Feature Guides
    • Query Healer
    • Compression
    • Python User-Defined Functions
    • Workload Manager
    • Concurrency and Locks
    • Data Encryption
      • Overview
      • Encryption Methods
      • Data Types
      • Syntax
      • Examples
      • Limitations
      • Permissions
  • References
    • SQL Statements and Syntax
      • SQL Syntax Features
      • SQL Statements
      • SQL Functions
        • Built-In Scalar Functions
        • User-Defined Functions
        • Aggregate Functions
        • Window Functions
    • Catalog Reference
      • Catalog Tables
      • Additional Tables
      • Examples
    • Command line programs
      • metadata_server
      • sqreamd
      • Multi-Platform Sqream SQL
      • SqreamDB Console
      • Server Picker
      • SqreamStorage
      • sqream sql
      • upgrade_storage
    • SQL Feature Checklist
  • Data Types
    • Supported Data Types
      • Primitive Data Types
      • Array
    • Casts and Conversions
    • Supported Casts
      • Numeric
      • Boolean
      • Integer
      • Floating Point
      • String
      • Date
      • DateTime2
  • Release Notes
    • SQDB release policy
    • 4.x Release Notes
      • Release Notes 4.3
      • Release Notes 4.5
      • Release Notes 4.8
      • Release Notes 4.9
      • Release Notes 4.10
      • Release Notes 4.11
  • Troubleshooting
    • Remedying Slow Queries
    • Resolving Common Issues
    • Identifying Configuration Issues
    • Lock Related Issues
    • Log Related Issues
    • Core Dumping Related Issues
    • Retrieving Execution Plan Output Using SQreamDB Studio
    • Gathering Information for SQream Support
  • Glossary
SQreamDB
  • Troubleshooting
  • Lock Related Issues

Lock Related Issues

Sometimes, a rare situation can occur where a lock is never freed.

The workflow for troubleshooting locks is:

  1. Identify which statement has obtained locks.

  2. Understand if the statement is itself stuck, or waiting for another statement.

  3. Try to stop the offending statement, as in the following example:

SELECT STOP_STATEMENT(2484923);
Previous Next

© Copyright 2025 SQreamDB.