Inconsistent 09024 Error SQLBase 12.0

[akshey.dixit]

I am using SQLTalk for Windows 12.0.0.10579. This is connecting to the local SQLBase server, both are installed on a Windows 10 Enterprise machine.

Running a simple select query as below would start giving me errors, however it only happens every so often.

Code: Select all

select * from product;

The first time it will give me an 09024 error

select * from product
^
Error: 09024 GCI SEA Session ended abnormally

Any subsequent runs will give me a 03806 error

select * from product
^
Error: 03806 RSO SCT Session closed/terminated

What could be the cause of the session terminating and not being able to reconnect even if I disconnect/reconnect via SQLTalk ?

SQLBase Process activity only indicates that the session keeps getting terminated immediately.

Code: Select all

3> Database process created
3> Stack Usage For Database Process 3: Total 11000 Used 1000 Free 10000
3> Database Process terminated
3> Database process created
5> Database process created
5> Stack Usage For Database Process 5: Total 11000 Used 1000 Free 10000
5> Database Process terminated
5> Database process created
5> Stack Usage For Database Process 5: Total 11000 Used 1000 Free 10000
5> Database Process terminated
5> Database process created
5> Stack Usage For Database Process 5: Total 11000 Used 1000 Free 10000
5> Database Process terminated
3> Stack Usage For Database Process 3: Total 11000 Used 1000 Free 10000
3> Database Process terminated

SQL.ini is as below.

Code: Select all

[dbntsrv]
dbname=XXXXX
ANSIJoinSyntax=1
centurydefaultmode=1
cache=64000
NamedPipes=LocalOnly
tempdir=F:\data\
dbdir=F:\data\
ipv4listenaddress=127.0.0.1:2155
servername=SERVER1


AUDIT=GLOBAL,SBCCGLBL,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,1,1,,1,4,5,6,7,8,9,10
AUDIT=PERFM,SBCCPRFM,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,2,1,,1,2,3
[dbntsrv.gui]

[dbntsrv.dll]
comdll=sqlws32
;comdll=sqlapipe

[dbntsrv.apipe]

[dbntsrv.ws32]
ListenPort=2155


[win32client]
clientname=Win32User
transports=npipe,tcp,apipe
clientruntimedir=C:\Program Files (x86)\Gupta\SQLBase 12.0


[win32client.dll]
;comdll=sqlws32
comdll=sqlapipe

[win32client.npipe]
serverpath=SERVER1,127.0.0.1

[win32client.apipe]

[win32client.ws32]
serverpath=SERVER1,127.0.0.1:2155/XXXXX

[win32client.tcp]
serverpath=SERVER1,127.0.0.1:2155/XXXXX

[FRBhote]

Any fail.sql created?

What are the last few lines in the audit files?

[akshey.dixit]

Thanks for responding!

No fail.sql created. Not sure which audit files you are referring to but here are the last few lines from the SBCCPRFM.1. log file

Code: Select all

001,26-AUG-20 15:49:01.16,CONNECT,dbname,SYSADM,SBCCNTR-workstation-name,0.00
002,26-AUG-20 15:49:01.27,EXECUTE,dbname,SYSADM,SBCCNTR-workstation-name,0.00,
select
*
from SYSADM.PRODUCT
003,26-AUG-20 15:49:01.36,ROLLBACK,dbname,SYSADM,,56.35
003,26-AUG-20 15:49:01.36,ROLLBACK,dbname,SYSADM,,0.00
003,26-AUG-20 15:49:01.36,COMMIT,dbname,SYSADM,,0.00

I have also ran a

Code: Select all

check database

and

Code: Select all

Update Statistics on Database

I am gettting a feeling that the database is corrupted as I ran an unload on the problematic table and it unloaded unsuccessfully.

[FRBhote]

The audit file are:

AUDIT=GLOBAL,SBCCGLBL,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,1,1,,1,4,5,6,7,8,9,10
AUDIT=PERFM,SBCCPRFM,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,2,1,,1,2,3

Perhaps having the same parameter repeated causes a problem?

Come to think of it - do you really require all of them?

[Igor Ivanovic]

Run this:

Code: Select all

unload database nul log <your log location>;

This will touch every corner of your database and if there is a corruption you will know where.

[tom_bond]

Same here.
The database is ok. Error 9024 with SQLTalk. Startet with SQLTalk Plus there is more info like this:

select * from hkinf;

An error has occurred, please report the following message to OpenText:
Methode nicht gefunden: "Void Gupta.SQLBase.Data.SQLBaseException..ctor(Gupta.SQLBase.Data.SQLBaseError, Int32, System.Exception, System.Collections.Generic.List`1<System.String>, System.Object)".
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.<ExecuteStatement>d__51.MoveNext()
bei System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.ExecuteStatement(Object obj)
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.<ExecuteStatementEvent>d__50.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.<ExecuteStatementAtPosition>d__54.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
bei System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
bei System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

[akshey.dixit]

Run this:

Code: Select all

unload database nul log <your log location>;

This will touch every corner of your database and if there is a corruption you will know where.

Hi Igor, thanks for the information.

I have run the unload twice now on different days and time and both have completed successfully. I couldn't find any mention of any corrupted indexes or tables and manully checked the log entries with the problematic tables for any other errors.

Would you have any ideas on any other checks or auditing that can be done to see why the SQLTalk would crash?

Thanks,

Akshey