The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
26 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 ...
0
votes
1answer
66 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 ...
0
votes
1answer
96 views

Multiple left join hangs server

I have a problem with left join query. It connects 3 tables and calculates sales value for categories. Query: SELECT categories.name, categories.id, ...
0
votes
0answers
193 views

SSMS 2012 Application Hang on start up

This morning I had to unsafely shut my computer down, unfortunately SSMS 2012 was open at the time. Now when I open SSMS I get no database connection popup and everytime I click on the window I hear ...
2
votes
1answer
903 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 ...
2
votes
1answer
754 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 ...
2
votes
1answer
846 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 ...
0
votes
0answers
554 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 ...
3
votes
0answers
842 views

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). ...