Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [hang]

17 questions
5
votes
2 answers

Kill infinite loop plperl

How can I kill session with infinite looped plperl function? Both pg_terminate_backend and pg_cancel_backend had no effect. kill -1 pid did nothing as well and kill -9 pid crashed server.
Łukasz Kamiński
  • 173
  • 5
5
votes
1 answer

SQL Server 2014 SP1 stops responding

Recently I have upgraded my development machine to Windows 10 and SQL Server 2014 SP1 Express (12.0.4213). Then I noticed that my application sometimes crashes with a timeout exception. It is quite a small .NET application with a 100MB database and…
Dark Daskin
  • 151
  • 4
4
votes
1 answer

MySQL hangs in killed state

I have a strange situation where a mysql OPTIMIZE query will never end. After killinh it, it remains in the "killed" state. Scenario to reproduce: OS: CentOS 6.5 MySQL: 5.6 Engine: MyISAM (with at least one BLOB/LONGTEXT column) mysql config…
user3360578
3
votes
1 answer

Why does Oracle hang on "ALTER TABLE ADD ... NOT NULL"?

Using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0, the operations below have completely stumped me. The first locks up (table has DDL lock, finally killed query after 20+ minute wait). The second does not. ###This hangs: ALTER TABLE…
TML
  • 1,374
  • 13
  • 21
2
votes
1 answer

SSIS execute task running wscript.exe hangs when started from SQL Server Agent

I have a problem with sql server 2012 SSIS package which has execute step running wscript.exe utility. When I run this package from BIDS everything works fine, when I start package from SSIS it also starts without any problem. But once I start this…
Johnny_D
  • 245
  • 1
  • 3
  • 10
2
votes
1 answer

SQL Server Error 833 On LDF File

I'm getting error 833 on my ldf file and i'm getting it a lot. Please see the following. When this happens, my application is hang already. I know error 833 has been reported a lot, but what does it mean if it is consistently pointing to my LDF file…
grassbl8d
  • 477
  • 2
  • 5
  • 14
2
votes
0 answers

MSSQL 2012 SP4 11.0.7493 periodically unresponsive until cluster failed over

I have a production MSSQL 2012 Standard SP4 (11.0.7493) database that periodically (non-deterministically, but anywhere from every few days to every few weeks) becomes unresponsive to queries made by clients using SQL Server Native Client 11.…
Jaegermeiste
  • 21
  • 1
2
votes
1 answer

Are there known parallelism issues with Sql Server 2016?

Looking for anything such as known bugs in Sql Server 2016 SP1, CU4 and CU5 (both have same issue) on windows 2012 R2 on vmware. Esp. if where parallel threads wait on each other. Issue: After going production we have one specific query in an…
Saxman
  • 311
  • 2
  • 11
1
vote
1 answer

Mariadb semi-freezing while writing gigabytes per second according to iotop

Recently, I've had a crash of mariadb that started a nightmare. When I restored dumps I had sometimes the daemon hang during bulk inserts. This happened only on the few "big" innodb tables (I have many small dbs that really don't contain much data…
meh
  • 33
  • 1
  • 1
  • 5
1
vote
1 answer

MySQL 5.7 --> MariaDB 10.8 switch: mysqlcheck --check --extended hangs on table

Recently I switched from MySQL 5.7 to MariaDB 10.8 and it's been generally great as a drop-in replacement, but I've run into a problem: the process for a cron job that daily runs /usr/bin/nice /usr/bin/ionice -c3 \ /usr/bin/mysqlcheck \ …
AJ Livingston
  • 13
  • 2
1
vote
1 answer

DROP TABLE IF EXISTS hangs on Waiting for table metadata lock

I'm using a dockerized MySQL 5.7.13 as part of an integration test of an application. The way the system works is as follows: I start up the main application. It opens up a connection to MySQL, but does not perform any queries. I start the…
JohnEye
  • 173
  • 9
1
vote
1 answer

How to get postgres to resume processes after it hangs when the RAID drive hosting the tablespace times out

Nearly once per day I'm getting a timeout that shows up in console like: 7:1:36 PM kernel: Areca RAID volume scsi command timeout (target=0 lun=0) which corresponds exactly to when all postgres processes hang. I'm reluctant to terminate pids…
dkitchel
  • 135
  • 5
0
votes
1 answer

MySQL: "CREATE DATABASE mydb" command hangs

On my MySQL 5.6 server, when logged in as root, the command CREATE DATABASE hangs. No error message - nothing. The MySQL error log doesn't show anything special either. What could I look into to troubleshoot the problem?
dr_
  • 1,334
  • 4
  • 19
  • 40
0
votes
1 answer

Postgres (9.6) hangs on start after storage upgrade

I have been running Postgres on a Linode with the data directory mapped to an external volume. Yesterday Linode prompted me to upgrade my storage to NVMe so I did. Unfortunately, following that, Postgres is unable to start. When I attempt to start…
Cory
  • 101
  • 2
0
votes
1 answer

SQL Server 2017 freezing during bulk insert of large file into in-memory staging table

Running SQL Server 2017 CU20 Standard on a dedicated Dell PowerEdge with 28 cores and 192GB of RAM. I have a stored procedure that processes large files (~7GB each) in a loop by bulk inserting them one by one into a memory-optimized staging table…
eek
  • 133
  • 1
  • 5
1
2