Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

timesten-22 -{System call select() failed with OS error 110.}

Gasimov HafizFeb 27 2023 — edited Feb 27 2023

Dear all. Could you provide any solution for this issue?

I have TimesTen Release 22.1.1.9.0 (64 bit Linux/x86_64) version and my sys.odbc.ini file content as below

[tt_hafiz]
Driver=/home/timesten-22/instance1/install/lib/libtten.so
DataStore=/home/timesten-22/instance1/DataStore/tt_hafiz
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
PermSize=12000
TempSize=8192
AutoCreate=1
Logging=1
DurableCommits=0
LockLevel=0
LockWait=600
Temporary=0
LogBufMB=2048
LogFileSize=2048
LogDir=/home/timesten-22/instance1/logs
LogBufParallelism=32
LogPurge=1
PrivateCommands=1
CkptFrequency=3600
CkptLogVolume=2048
Isolation=1
Connections=1024
SQLQueryTimeout=1800
PLSQL_TIMEOUT=1800
PLSQL_CONN_MEM_LIMIT=1024
PLSQL_MEMORY_SIZE=1024

so , my problem is bulk insert, during inserts on table , i get error as below, what is solution this problem?

Caused by: java.sql.SQLException: [TimesTen][TimesTen 11.2.2.8.0 CLIENT]Communication link failure. System call select() failed with OS error 110. This operation has Timed Out. Try increasing your ODBC timeout attribute or check to make sure the target TimesTen Server is running

insert data failed!java.sql.BatchUpdateException: Batch command 0 failed: [TimesTen][TimesTen 11.2.2.8.0 CLIENT]Communication link failure. System call select() failed with OS error 110. This operation has Timed Out. Try increasing your ODBC timeout attribute or check to make sure the target TimesTen Server is running. Row :5000, Last row values:1:1148015, 2:A, 3:2017-04-12 06:54:43.0,

This post has been answered by ChrisJenkins-Oracle on Aug 28 2023
Jump to Answer
Comments
Post Details
Added on Feb 27 2023
2 comments
66 views