java.sql.BatchUpdateException: IO Error: Connection reset
posted @ 2017-02-20 09:28 InPractice 閱讀(1312) | 評論 (0) | 編輯 收藏
隨筆 - 53, 文章 - 0, 評論 - 3, 引用 - 0
|
java.sql.BatchUpdateException: IO Error: Connection reset
during analysis of "IO Error: Connection reset", many articles mentioned that it could be caused by java security code (accessing /dev/random) used in JDBC connection. However it is not the root cause in my case.
In my environment, Java already use /dev/urandom.
1. $JAVA_HOME/jre/lib/security/java.security
securerandom.source=file:/dev/./urandom
2. check with strace.
only -Djava.security.egd=file:/dev/../dev/urandom will trigger system call (read on /dev/urandom)
all other other path format like below are OK.
-Djava.security.egd=file:/dev/./urandom
-Djava.security.egd=file:///dev/urandom
3. Keep checking the retropy size, I have never seen it is exhaused.
while [ 1 ];
do
cat /proc/sys/kernel/random/entropy_avail
sleep 1
done
usually the avail is in the range from 1000 to 3000.
so far, there is no clue about the root cause of "IO Error: Connection reset".
posted @ 2017-02-20 09:28 InPractice 閱讀(1312) | 評論 (0) | 編輯 收藏 Lessons learned - Oracle GI and Database Installation on SUSE 12
I encountered many issue during installation of Oracle Grid Infrastructure(GI) and Database;
with the help of ariticle and documents found through Google search engine,
I finally made it. for records, here is the details issues encountered and solutions applied.
Major issues were encountered during GI installation.
Pre-installation tasks.
Issue 1: swapspace is not big enough; (1.3.1 Verify System Requirements)
grep MemTotal /proc/meminfo
264G
grep SwapTotal /proc/meminfo
2G
during OS installation, I take default option and swap space is only 2G.
Oracle recommend to have more than 16G swap space in case of more that 32G RAM.
dd if=/dev/zero of=/home/swapfile bs=1024 count=33554432
33554432+0 records in
33554432+0 records out
34359738368 bytes (34 GB) copied
mkswap /home/swapfile
mkswap /home/swapfile
chmod 0600 /home/swapfile
lessons learned: setup swap space properly according to DB requirement when installing OS.
Issue 2: cannot find oracleasm-kmp-default from Oracle site.
(1.3.6 Prepare Storage for Oracle Automatic Storage Management)
install oracleasmlib and oracleasm-support is easy, just download them from Oracle and install them;
Originally oracleasm kernel is provided by Oracle, but now I cannot find it from Oracle; finally I
realized that oracleasm kernel is now provided by OS vendor;
In my case, it should be installed from SUSE disk;
a. to get its name oracleasm-kmp-default
zypper se oracle
b. map dvd and install
zypper in oracleasm-kmp-default
rpm -qa|grep oracleasm
oracleasm-kmp-default-2.0.8_k3.12.49_11-3.20.x86_64
oracleasm-support-2.1.8-1.SLE12.x86_64
oracleasmlib-2.0.12-1.SLE12.x86_64
asm configure -i
asm createdisk DATA /dev/<...>
asm listdisks
--DATA
ls /dev/oracleasm/disks
Installation tasks:
Issue 3: always failed due to user equivalence check after starting installer OUI with user oracle.
however if I manully check with runcluvfy, no issue found at all.
./runcluvfy.sh stage -pre crsinst -n
posted @ 2016-07-28 16:55 InPractice 閱讀(268) | 評論 (0) | 編輯 收藏 卸載Ubuntu需要注意的地方很多年前裝了Ubuntu和Windows的雙系統,最近因為有了專門的電腦來裝Ubuntu,所以把原先電腦上的Ubuntu卸載了,結果系統不能引導了。因為GRUB的原理是控制權從MBR到Ubuntu系統盤,然后Ubuntu系統盤再提供對windows的引導。現在Ubuntu系統被卸載了。這個啟動的鏈條也就斷了。 posted @ 2011-04-11 18:19 InPractice 閱讀(649) | 評論 (1) | 編輯 收藏 使用GMail的困惑
用Gmail的時候不小心點了"存檔"按鈕,一封重要的郵件就此消失了好幾天,今天才機緣巧合找到。
在網絡上查到的解釋是: 存檔會將郵件從收件箱移至所有郵件,這樣您不必刪除郵件就可以整理收件箱。 難以理解,坦率地說,這個功能對我來說是徒增煩惱。看來任何工具都需要你去適應,磨合。 posted @ 2011-02-11 11:02 InPractice 閱讀(254) | 評論 (0) | 編輯 收藏 華容道游戲的解決
最近買了一個叫做“華容道”的玩具給兒子晚。這個游戲雖然號稱是中國四大古典智力游戲之一。其實不過百年歷史,而且是從國外引進的。不過本地化做得非常好,也算是創造性地吸收國外文明。
手工解決這個游戲有點難度,當然已經有人給出了解法;不過我還是自己用編程的方式解決了一遍。發現自己在這方面的編程還是比較弱。大部分時間花在了調試上。 剛開始是用的深度優先搜索。大致知道了答案應該長什么樣。后來改進為廣度優先搜索,得到了最優的解法。還有一個就是原先只考慮每次最多移動一格。后來發現傳統的定義是一個塊的所有連續移動都算作一步。相應地修改了實現算法。 最難的是做界面。為了調試,隨便寫了個Applet。但是給我兒子玩,就覺得拿不出手了。 posted @ 2010-08-16 13:49 InPractice 閱讀(336) | 評論 (0) | 編輯 收藏 Meta Information
Just use this blog to share some meta information.
git://github.com/ueddieu/mmix.git http://github.com/ueddieu/mmix.git posted @ 2010-06-05 06:44 InPractice 閱讀(194) | 評論 (0) | 編輯 收藏 |
|