Questions tagged [hang]
The hang tag has no usage guidance.
18 questions
1
vote
1
answer
54
views
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 (...
- 23
1
vote
1
answer
257
views
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/...
0
votes
1
answer
183
views
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, ...
- 101
1
vote
2
answers
4k
views
Oracle 19c Installer hangs with endless Reading from the pipe output
I am attemping to install Oracle 19c on Windows 10 64 bit.
No Oracle products have ever been installed on this machine.
When I run setup.exe the cmd window launches, then the splash screen and then ...
- 11
0
votes
1
answer
543
views
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 ...
- 123
2
votes
0
answers
88
views
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 ...
- 21
1
vote
1
answer
2k
views
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 ...
- 173
5
votes
2
answers
777
views
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.
- 173
2
votes
1
answer
997
views
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 ...
- 311
0
votes
2
answers
389
views
What would cause an UPDATE statment to hang when executing from an .mdb file to SQL Server 2008 R2 over ODBC?
Is there anything that would cause an UPDATE statement INNER JOINed between a separate MS-Access linked table and an SQL Server 2008 R2 table to hang, when the values are being set on the SQL Server ...
- 1,722
5
votes
1
answer
1k
views
SQL Server 2014 SP1 stops responding [closed]
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 ...
- 151
1
vote
1
answer
202
views
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 ...
- 125
0
votes
1
answer
1k
views
MySQL: "CREATE DATABASE mydb" command hangs [closed]
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 ...
- 1,334
4
votes
1
answer
16k
views
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 ...
user3360578
2
votes
1
answer
2k
views
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 ...
- 245
2
votes
1
answer
2k
views
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 ...
- 477
0
votes
0
answers
627
views
How to detect when ORA-00604 occurred?
Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of some ...
- 729
3
votes
1
answer
3k
views
Why does Oracle hang on "ALTER TABLE ADD ... NOT NULL"? [closed]
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). ...
- 1,374