sathish GT
asked on
Error: 12301, Severity: 20, State: 1 00:0002:00000:00211:2017/12/13 17:57:16.79 server Internal error: the index (id = 2) and the data for row (26710892, 25) in table 'BUT000', database 4 are incons
Dear Team,
Following is the error is received in the ASE errorlog,
Error: 12301, Severity: 20, State: 1
00:0002:00000:00211:2017/1 2/13 17:57:16.79 server Internal error: the index (id = 2) and the data for row (26710892, 25) in table 'BUT000', database 4 are inconsistent; data is marked deleted but index is not. Aborting the transaction.
After that not able to connect dataserver, below is the error,
--Server is up and running but i'm getting below error Read from the server has timed out.
$isql -U -S -P
CT-LIBRARY error:
ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
Following is the error is received in the ASE errorlog,
Error: 12301, Severity: 20, State: 1
00:0002:00000:00211:2017/1
After that not able to connect dataserver, below is the error,
--Server is up and running but i'm getting below error Read from the server has timed out.
$isql -U -S -P
CT-LIBRARY error:
ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
ASKER
Hi David,
After recycle the server, I'm able to connect through isql and also i have increased the number of user connections. But since i don't understand why it is happens after increase number of user connections, In one month i faced this problem twice, Please suggest any best idea to debug.
Thanks in advance!
Regards,
sathishgt
After recycle the server, I'm able to connect through isql and also i have increased the number of user connections. But since i don't understand why it is happens after increase number of user connections, In one month i faced this problem twice, Please suggest any best idea to debug.
Thanks in advance!
Regards,
sathishgt
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Resolving index inconsistencies usually requires a database repair. I run these every night on all my MariaDB databases.
Sybase provides a similar facility. Likely best to place this into a CRON job to run nightly.
Sybase Database Repair describes how to fix most database problems.
The CT-LIBRARY error looks to be unrelated. Likely due to a mismatch in port number or domain socket name between client + server.
I don't have access to a Sybase system right now + the way I'd debug this is to discover how the server was listening + direct isql to explicitly connect to server's listening mechanism (IP/port or unix domain socket, whichever is used).