home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!olivea!isc-br!tau-ceti!dejavu!salnick
- From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
- Newsgroups: comp.databases.ingres
- Subject: Re: Transaction Log File
- Message-ID: <salnick.082v@dejavu.spk.wa.us>
- Date: 8 Jan 93 14:00:35 GMT
- References: <1993Jan7.145532.4404@sei.cmu.edu>
- Organization: Not Organized
- Lines: 40
-
- In article <1993Jan7.145532.4404@sei.cmu.edu> djk@sei.cmu.edu (David Kaplan) writes:
- >
- >I'm having some intermittent problems with the Trasaction Log File. Or,
- >rather, it's having trouble with me? In either case, the following error
- >occurs when running a rather long set of queries:
- >
- >**** ERROR: E_US1262 Your transaction has been aborted due to the transaction
- > log file having reached one of the limits set by the system administrator.
- > These limits are log_full, force_abort, and 90 percent of force_abort
- > when using the fast_commit option to start DBMS servers.
- > (Thu Jan 7 12:21:39 1993)
- >
- >What's this all about. I mentioned intermittent because some days I get the
- >error, and other days I don't?! There are commits after each query (all
- >creation and insertion commands), and the queries are broken up just about as
- >far as we can get them.
- >
- >Could this error be an indicator that something else is wrong? The fact that
- >it is intermittant EVEN when the data being used has not change is what really
- >has me puzzled.
-
- In an Ingres installation, it is normal for all transactions to be made
- against the log file instead of the actual database (fast commit thread
- moves stuff from the log to the disk). What this means is that the log
- file has to be large enough to hold everything which is going on
- simultaneously.
-
- The fact that you have an intermittent problem only tells me that you
- have different sets of concurrent users (no surprise there).
-
- Before anyone could judge whether there is something wrong, it would be
- instructive to know how big your log file is...
-
- BTW, you can change it via the iibuild script.
-
- bob
- --
- RW Salnick, Spokane,WA | Home: salnick@dejavu.spk.wa.us
- Amiga 1000, WB 1.3 | Work: mfgsys!salnick@kaiser.spk.wa.us
- WA9BVE |
-