Super User
Super User

Questions tagged [transaction]

9 questions
3
votes
1 answer

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the transaction logs. After that, everything was back…
nate
  • 1,202
3
votes
2 answers

Format with TexFAT filesystem

Is it possible to format a device (USB stick or hard disk) with a TexFAT or TxF file system? If so, how? Is a special driver or program required for XP or Vista to be able to do this? I can find no download links, and no normal method of formating I…
Nicholas
  • 1,143
2
votes
1 answer

What do I need to know before buying a domain from an individual seller?

What steps do I need to take in order to ensure a successful transaction and protect myself from getting scammed?
zildjohn01
  • 2,337
2
votes
1 answer

PCI Express - Memory Addressing vs Physical Memory in Memory Read/Write Transactions

I'm trying to find the link between Memory BARs (Base Address Registers) and Physical Memory in a PCI Express Transactions. In my last question I started to understand what happens when a CPU reads/writes at a certain memory address, now I need to…
Jacopo Reggiani
  • 95
  • 1
  • 2
  • 4
1
vote
4 answers

Will the Microsoft SQL transaction log by default be enabled during install?

I was asked this question in an interview? Does it depend on version of the server or is it always same (enabled or disabled by default)?
annunarcist
  • 115
  • 4
1
vote
0 answers

Event ID 7034 The IBM CICS Transaction Gateway service terminated unexpectedly

I'm getting several errors in the logs every couple of days on a Windows 2003 Server that has to be rebooted to resolve this issue. The system cannot be rebuilt at this moment but will eventually once projects and time are available for the…
Brad
  • 250
1
vote
0 answers

Rollbacks in transactional DDL statements for innodb in MySQL 8.0

System: MySQL 8.0, Storage engine - Innodb In a given scenario, I obtain an explicit transaction in application layer, and run some DDL and DML statements. If tx fails, I roll-back it. But only DML statements roll-back. Do I need to explicitly…
uzumas
  • 111
0
votes
1 answer

Transactions per second in a database (say PostgreSQL)

I refer to 2 documentation pages on PostgreSQL's site: #1 and #2. From these, we see the transaction log is flushed to disk 5 times per second (wal_writer_delay = 200ms), and we also see the RDBMS won't report a transaction as successful until it…
IamIC
  • 155
0
votes
1 answer

Is it save to power off a PC without shutting down?

Is all software nowadays writing data transnational to disk? So that if it is interrupted during writing there won't be a corrupt file? Let's say I have a PC running Windows or Debian. And some well known programs like Firefox and LibreOffice. Is it…
zomega
  • 1,310