Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 7 years ago. Improve this question I need to communicate server1 to server2. Server1 should have to fetch some records from Server2 when we execute program.exe will make server1 … Read more
Greetings, Not sure if this is one for here or stackoverflow but here goes: I have deployed a J2EE application on JBoss 4.2 with a MySQL backend. While stress testing the application I’ve discovered many: org.jboss.tm.JBossTransactionRolledbackException: Contention on read lock promotion for bean. Exception in second transaction; nested exception is: javax.ejb.EJBException: Contention on read lock … Read more
We transferred an old ASP application from Windows 2000 to Windows 2008 R2 to upgrade its performance. We only transfer the ASP application, the database is still the same. After successful transfer, the users of the web application encounters a deadlock from SQL. Transaction [Process ID XX] was deadlocked on lock | communication buffer resources … Read more
select * from INFORMATION_SCHEMA.INNODB_TRX\G; *************************** 1. row *************************** trx_id: 41844623 trx_state: RUNNING trx_started: 2016-11-23 15:40:42 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 71 trx_mysql_thread_id: 0 trx_query: NULL trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 6 trx_lock_structs: 7 trx_lock_memory_bytes: 1136 trx_rows_locked: 1 trx_rows_modified: 64 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_adaptive_hash_latched: 0 trx_adaptive_hash_timeout: 10000 trx_is_read_only: … Read more
I will try to be as detailed as possible. Up until now I was only using Stack Overflow and other sites like this but never posting. I was always able to find the answer to my question. But not this time. I have a Mu Online game server setup and running fine.A part of this … Read more
In WebSphere 8.5.5.13 I have some out of memory errors and the database connections get maxed out. It seems to me this is due to thread starvation (I have some processes trying to do something with a timeout of 10 seconds and other tasks that usually take ~200ms that actually take ~10200ms). But I think … Read more
We have a vendor app that has a SQL Server 2005 database. During data entry, app writes data to a table that has no clustered indexes on it. It has a number of indexes on the table, though. I used the Maintenance Plan wizard to rebuild the indexes on that table. During performance testing, we … Read more
I’m using tomcat server 7 with apache mode_proxy_ajp module to serve a website. Here is my ajp connector config: <Connector port=”8009″ protocol=”AJP/1.3″ redirectPort=”8443″ connectionTimeout=”20000″ minSpareThreads=”10″ maxThreads=”512″ executor=”tomcatThreadPool_1″ acceptCount=”128″ acceptorThreadCount=”2″ maxKeepAliveRequests=”50″ keepAliveTimeout=”10000″ URIEncoding=”UTF-8″/> & here is executer config: <Executor name=”tomcatThreadPool_1″ namePrefix=”catalina-exec-” connectionTimeout=”20000″ minSpareThreads=”10″ maxSpareThreads=”50″ maxThreads=”512″ acceptCount=”128″/> now the problem is that many times I see many … Read more
What’s the best way to monitor SQL Server Conccurency issues? Specifically my goal is to reduce or prevent deadlocks and blocking and to catch potential concerns before they become a problem. For example if I were to monitor windows performance counters for memory usage, I would be able to predict when memory issues would become … Read more
I’m in the process of recovering a dying hard-drive with ddrescue. The utility works very well in the parts of the drive that have not problems but in the parts of the drive with problems it goes very slow and seems to be causing a deadlock in some kernel module. Firstly: my system, $ uname … Read more
