[Info-Ingres] write error

DATABASE

    Sponsored Links

    Next

  • 1. [Info-ingres] Ingres 2.0 upgrade to 2.6
    Hello, I'm planning on making the above upgrade in the very near future and wanted to ask for gotchas/suggestions, before starting. I've got the 2.6 SP2 from CA and the Migration Guide, which indicates an upgradedb is the preferred method for this task. This will be running on Win2000. Aside from iidbdb and imadb, there's only one other db, mk, with 2775 tables. There are 325 views, a couple of procedures, and that's about it. Any thoughts you can offer will be greatly appreciated! We've got several MK users in our group who are talking of moving from Ingres to SQL, but since our move to new hardware last summer, that kind of talk around here has fallen by the wayside. Cheers, Mike Ossing IT Mgr Rodem, Inc. 513-922-6140 x147 ========================================= This GroupWise e-mail message was scanned using Beginfinite's Guinevere Antivirus program and F-Prot Antivirus software. The virus definitions used by F-Prot to block e-mail viruses are updated on a regular basis, thus insuring that no e-mail is infected. Should you have any questions about the content of this e-mail, or are not the intended recipient, please contact the Rodem e-mail Administrator at this address: XXXX@XXXXX.COM . =========================================
  • 2. VMS script on_switch_log
    Hi Marty I think you're close. Your script should work. Anyway there is no danger in testing it... But mayby it can be simplified. II_SYSTEM is a concealed logical on every node with an Ingres installation. So why not use this in your script? Greetings Willem van de Zande
  • 3. Problem with JDBC/EDBC date/time field
    Hi all ! I am with the following problem. I am trying to retrieve some records in a data base CA-Ingres, using JDBC.EDBC driver. The code that I am executing is the code below. StringBuffer sql = new StringBuffer() ; sql.append("SELECT *') ; sql.append("FROM myTable "); sql.append("WHERE myDateTimeField = ? ") ; sql.append("AND myStringField = ? ") ; PreparedStatement pstmt = getConnection().prepareStatement(sql.toString()); pstmt.setTimestamp(1,vo.getMyTimeStampValue()) ; pstmt.setString (2,vo.getMyStringValue()) ; ResultSet rs ; rs = pstmt.executeQuery() ; if (rs.next()) System.out.println("YES !!!"); else System.out.println("NO ..."); The values that are being passed for clausula WHERE are correct. The SQL statment is : SELECT * FROM myTable WHERE myDateTimeField = '2005-1-17 16:58:48' AND myStringField = 'WEEMINAX638NSRQTMUZCIQF5hECGU3Y2WH5H' and this statment works fine !!!! Then, what of it has made a mistake with this code? Please give examples. Thanks in advance, your help is appreciated. Ronaldo.

[Info-Ingres] write error

Postby Armand Pirvu » Fri, 10 Sep 2004 04:23:26 GMT

i folks,

This is what I got today. First section is from errlog.log second from iidbms*.log
WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM9713_SR_WRITE_ERROR Error occurred writing to sort work file -- path = /har/mkwork/ingres/work/default/mk, block 65535.
WDCUSMK0::[32907 , 5f472060]: Wed Sep 8 10:14:03 2004 E_DM9713_SR_WRITE_ERROR Error occurred writing to sort work file -- path = /har/mkwork/ingres/work/default/mk, block 65535.
WDCUSMK0::[32907 , 5efad560]: Wed Sep 8 10:30:45 2004 E_DM9713_SR_WRITE_ERROR Error occurred writing to sort work file -- path = /har/mkwork/ingres/work/default/mk, block 65535.
WDCUSMK0::[32907 , 61430040]: Wed Sep 8 11:08:05 2004 E_DM9713_SR_WRITE_ERROR Error occurred writing to sort work file -- path = /har/mkwork/ingres/work/default/mk, block 65535.

!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM9713_SR_WRITE_ERROR Error occurred writing to sort
!work file -- path = /har/mkwork/ingres/work/default/mk, block 65535.
'
!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM9703_SR_WRITE_ERROR Error occurred writing a sort w
!ork file. Check disk space and quota
on the sorting device(s).
'
!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM970D_SORT_WRITE_RECORD Error occurred writing a rec
!ord to the sort work file.'
!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM970B_SORT_PUT Error occurred adding a record to be
!sorted.'
!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM9275_DM2R_LOAD Error adding a record to a sort tabl
!e.'
!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_DM008B_ERROR_PUTTING_RECORD Error trying to put a rec
!ord.'
!ERsend--->'WDCUSMK0::[32907 , 5e624040]: Wed Sep 8 09:23:19 2004 E_QE007D_ERROR_PUTTING_RECORD Error trying to put a rec
!ord.'
!REPOSITION after waiting for row lock for table 12716 tid 2,0 acc 4
!REPOSITION after waiting for row lock for table 12716 tid 2,0 acc 4
!REPOSITION after waiting for row lock for table 12716 tid 2,0 acc 4
!REPOSITION after waiting for row lock for table 12716 tid 2,0 acc 4
!ERsend--->'WDCUSMK0::[32907 , 60267040]: Wed Sep 8 09:46:35 2004 E_DM9043_LOCK_TIMEOUT Timeout occurred during ROW 0 (of
! page 2) lock request on table mk.ttoifc000115 in database mk with mode 5. Resource held by session [25640 5e169e20].
'
Well, the repositioning I doubt that it's related to the disk errors, but rather to the timeouts.
I asked the sysadmin if any errors on the storage (EMC Clarion , which SP's crashed a couple of times and well of course the marvelous RAID5), and he told that nothing unsual.

Any input is appreciated.

Thanks a lot,
Armand


---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
<DIV>Hi folks,</DIV>
<DIV> </DIV>
<DIV>This is what I got today. First section is from errlog.log second from iidbms*.log</DIV>
<DIV>WDCUSMK0::[32907           , 5e624040]: Wed Sep  8 09:23:19 2004 E_DM9713_SR_WRITE_ERROR        Error occurred writing to sort work file -- path = /har/mkwork/ingres/work/de

Similar Threads:

1.[Info-Ingres] write error

2.[Info-Ingres] logstat write vs dual write

Hi Everyone,

Does anyone have a strong feeling on how much attention I should be 
paying to discrepancies in the Log Write and Dual Log Write figures in
logstat?

I've always checked that these numbers are much the same - seems 
like a reasonable thing to do. Fact is I have a monitor program that
sounds an alarm if they are more than 10 writes apart.

On most of the systems I've got, I see these numbers never being more 
than
a few writes out, and that over time they tend to always agree to a very
small percentage. So my monitor very rarely pings at me.

But on some hosts, the writes slowly drift further apart - generally as a
result of load, and never seem to come back into agreement. The 
percentage
difference is small, but troubling.

eg.
On the 5th Jan at 10:51:
    write complete         868522        dual write complete    868523

Now:
    write complete        2587889        dual write complete   2587759

The system drifted in response to heavy usage of the log file on the 5th
Jan. I've checked in the OS system logs and there is no sign of a 
problem
on the disk holding the dual log.

Martin Bowes
Random Duckman Quote #26:
Cornfed - Duckman had been reduced to the state of a gibbering, 
mindless idiot. In many ways this was an improvement - but his pro 
country music attitude was starting to worry me.


3.[Info-Ingres] Emma McGrattan : Men Write Code from Mars, Women Write More Helpful Code from Venus

4.[Info-Ingres] log writes vs dual log writes

5.[Info-ingres] 3rd party tools for writing/managing Ingres rules and procedures (amongst other things)

6. [Info-Ingres] Writing CSV files using COPY...INTO

7. [Info-ingres] Need query writing help

8. [Info-ingres] Write behind of group buffers



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 14 guest