Conference eps::oracle

1517.0. "What parameter'd affect ERROR on update buffer?" by EPS::NGUYEN (Without fools there would be no wisdom.) Wed Feb 19 1997 13:35

Hello all,

When installing a third party software, who's using 
Oracle 7.3.2.3 as database on DU 4.0b, I got the 
error during buffered updates in transaction commiting.

Here are various log messages:
----------------------------------------------------------------
97-02-19[13:10:43]root: ******* S T A R T of Log message *******
97-02-19[13:10:43]root: Log message called from bdb_fun.c,v $ $Revision: 1.19 $:
 #1040 keyword: DB error
97-02-19[13:10:43]root: Pid 3797 Uid 0 Euid 0 Gid 1 Egid 1
97-02-19[13:10:43]root: user_type S language 2 user_name root tty 6 locale ISO88
591/NULL
97-02-19[13:10:43]root: Errno 0 bdb_errno 520 (Error during buffered updates)
97-02-19[13:10:43]root: Log_mesg: Error 4114 (Error during buffered updates) on
tttxt010000 in commit_trans
97-02-19[13:10:43]root: ********** E N D of Log message **********
----------------------------------------------------------------
------ Log Fatal SQL Statement -----
User    : root (pid 3844)
Date    : 97-02-19[13:10:42]
SQL     :
LOCK TABLE triton.ttttxt010000 IN ROW SHARE MODE NOWAIT
------ End of Log Message -----
----------------------------------------------------------------
97-02-19[13:10:43]root: ******* S T A R T of Log message *******
97-02-19[13:10:43]root: Log message called from ora_native.c,v $ $Revision: 1.9
$: #993 keyword: Oracle Error
97-02-19[13:10:43]root: Pid 3844 Uid 0 Euid 0 Gid 1 Egid 1
97-02-19[13:10:43]root: user_type S language 2 user_name root tty 6 locale ISO88
591/NULL
97-02-19[13:10:43]root: Errno 2 (No such file or directory) bdb_errno 0
97-02-19[13:10:43]root: Error 4113 occurred:
97-02-19[13:10:43]root: Error ORA-3113 occurred during execute.
97-02-19[13:10:43]root: ORA-03113: end-of-file on communication channel
97-02-19[13:10:43]root:
97-02-19[13:10:43]root: Error BDB-4113 returned.
97-02-19[13:10:43]root: Info: peo 0, sql 35, oci 4, warn 0, osd 0, rpc 0
97-02-19[13:10:43]root: Error during execute insert (triton.ttttxt010000).
97-02-19[13:10:43]root: See fatal SQL statement in '/usr/bse/log/log.ora.sql'.
97-02-19[13:10:43]root: Flushed at ora_row.c,v $ $Revision: 1.5 $ : #1011.
97-02-19[13:10:43]root: ********** E N D of Log message **********
----------------------------------------------------------------

And here are my system info.

	AlphaServer 2100 4/275-2
	Memory 640 Mb
	
parameters in init<SID>.ora:
	db_file_multiblock_read_count = 32 
	db_block_buffers = 3200
	shared_pool_size = 9000000  
	processes = 100  
	dml_locks = 500   
	sequence_cache_entries = 100         
	sequence_cache_hash_buckets = 23     

Any suggestion/information of how to fix this is greatly appreciated.

Thank you in advance.
Gina