Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
21 views

MySQL: Grant permissions for `start transaction` and “surroundings”

I have created a sample user with the following request: grant select, insert, update, delete on db.* to user@localhost identified by 'pass'; but that user does also need permission to use start ...
0
votes
0answers
56 views

Never ending transaction problems after mysql 5.0->5.6 upgrade

I upgraded our entire backend mysql db from 5.0 to 5.6, including changing a few tables to innodb, and we've been having nothing but problems with never ending transactions since. I still have a ...
2
votes
1answer
892 views

Why does “commit” appear in the mysql slow query log?

In our MySQL slow query logs I often see lines that just say "COMMIT". What causes a commit to take time? Another way to ask this question is: "How can I reproduce getting a slow commit; statement ...
1
vote
0answers
504 views

Connections being intermittently left open on JBoss for requests from clients

The issue I'm having is that occasionally a connection for a clientside request + the assosiated DB connection (using Oracle 10g RAC) get left open on JBoss EAP 4.3.0 CP10. Also a JBM JMS queue ...
4
votes
1answer
55 views

How to get transaction history for yum?

I would like to know how to get the transaction history of yum (i.e. get the installations, deletions, etc.), hopefully ordered from most to least recent. Is there a way to accomplish this? Thanks ...
2
votes
1answer
98 views

PostgreSQL 9.0 implicit transactions not rolling back

I'm using PostgreSQL 9.0 in production, and have started noticing that statement errors abort an implicit transaction that never gets rolled back. This same issue doesn't appear on my development box, ...
2
votes
4answers
175 views

Data consistency with RAID 5 and BBWC

I have a few questions about RAID 5, BBWC (Battery Backed Write Cache), filesystem (ext3) and optionally mysql. I have a hypothesis and I ask Server Fault community to validate or not this one: -The ...
1
vote
1answer
368 views

Monitoring MySQL Rollback Segments

I recently discovered the default open transaction ceiling of 1024 in MySQL. I have since increased the limit using innodb_extra_rsegments. However, I would like to keep my eye on this moving forward. ...
5
votes
1answer
493 views

MySQL transaction issue with Django and Amazon RDS

I'm having a problem with a MySQL 5.5 database instance running on Amazon RDS. Periodically (once every couple of days) a transaction will fail to complete and appears to leave the tables locked. ...
1
vote
1answer
1k views

What to do: Arjuna RecoveryManager startup failing: SocketProcessId.getpid could not get unique port

When starting up a fresh instance of JBoss 6.1, I get the following error from Arjuna Recovery Manager, which I believe is part of the jboss-ts transaction service package. This error blocks the web ...
1
vote
2answers
414 views

High Transaction System Recommendations [closed]

I am a SQL Server database administrator and developer and I also have many years experience as an application developer. I currently have a customer with a very big project who is looking to me for ...
1
vote
1answer
53 views

iSCSI and WAL for database (oracle 11g) performance

I am thinking about building a database system with iSCSI. But now I am thinking about the WAL. WAL shouldn't lag. WAL is implemented with a ring buffer, isn't it? So if I only care about the ...
0
votes
3answers
703 views

Synthetic transactions - converting From OneSight to Zabbix

We are currently in the process of converting our monitoring solution from OneSight to Zabbix. We have Zabbix up and running and monitoring our hardware, perf counters and software errors. We use ...
2
votes
2answers
120 views

SQL Server 2008 Transaction log

Monday afternoon a new database is created and set to the Full Recovery Model. During Mon - Thurs night a full back up is successfully created but no transaction log backups are ever performed. ...
2
votes
4answers
15k views

Setting a time limit for a transaction in MySQL/InnoDB

This sprang from this related question, where I wanted to know how to force two transactions to occur sequentially in a trivial case (where both are operating on only a single row). I got an ...
0
votes
2answers
331 views

Can transactions be forced to occur sequentially in MySQL?

Let's say that I have two servers that simultaneously initiate a transaction on a MySQL 5.5 database using InnoDB. Both transactions do the same thing: Read a single row, then update the row based on ...
1
vote
0answers
231 views

What is the linux equivalent of MSDTC?

Windows has MSDTC to coordinate transactions across different resources. What is the equivalent technology in Linux?
0
votes
2answers
768 views

MySQL Cluster transaction isolation level - READ_COMMITTED

I'm learning by mostly reading the documentation. Unfortunately, http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html#isolevel_read-committed doesn't say anything, while it says everything. ...
1
vote
1answer
74 views

What could be causing my code to sporadically fail to get a connection to a SQL Server?

I've been writing some test code for a program I'm developing. Some of my code performs operations that modify data on a SQL Server. In order to avoid cluttering my database with test data, I use ...
4
votes
1answer
4k views

MSDTC - Communication with the underlying transaction manager has failed (Firewall open, MSDTC network access on)

I'm having problems with my ASP.NET web forms system. It worked on our test server but now we are putting it live one of the servers is within a DMZ and the SQL server is outside of that (on our ...
0
votes
1answer
453 views

WS-AT Issue between WPS 6.2 and WAS 7.0

I have a BPEL running on WPS 6.2 trying to call a web service on developed on RAD 7.5, deployed on RAD test environment. I have setup WS Transaction policy on both client and server. I get an error ...
2
votes
1answer
403 views

Problem with Distributed Transactions between machines in different domains

We are tring to use an application that uses transactions. The machine running the code is on a stand alone Windows 2003 Server machine. The database server is a Windows 2003 Server with SQL Server ...
0
votes
1answer
663 views

Security risk of enabling MSDTC

MSDTC is disabled by default (windows 2003 - onwards) and I want to have it enabled for an application I'm developing that requires distributed transactions. I don't believe there are any security ...