cancel
Showing results for 
Search instead for 
Did you mean: 

SPS09 - statisticserver - regular error in trace: SQLDBC error -10821: Session not connected.

0 Kudos

Hello all,

since the update to SPS09 (patchlevel 91) im having this error message every 5 minutes in the statisticserver-trace-file:

-------------------------------------------------------------------------

[8955]{-1}[-1/-1] 2015-01-29 00:34:14.659357 e StatsServ        ResourceGuard.cpp(00020) : Exception caught while cleaning-up resource:

exception  1: no.9002001  (StatisticsServerAsSQLClient/connection/OKAssurer.hpp:93)

    SQLDBC error -10821: Session not connected. SQLState: .

exception throw location:

1: 0x00007fa77ddca609 in StatisticsService::StatisticsServerException::StatisticsServerException(char const*, int, ltt::error_code const&)+0x5 at Exceptions.cpp:65 (libstatisticsserver.so)

2: 0x00007fa77ddce7da in StatisticsService::SQLDBCException::SQLDBCException(char const*, int, SQLDBC::SQLDBC_ErrorHndl const&)+0x36 at Exceptions.cpp:103 (libstatisticsserver.so)

3: 0x00007fa77dd72e4e in StatisticsService::OKAssurer<StatisticsService::GuardedConnection>::~OKAssurer()+0x6a at OKAssurer.hpp:93 (libstatisticsserver.so)

4: 0x00007fa77dd7e139 in StatisticsService::GuardedConnectionConnector::~GuardedConnectionConnector()+0x35 at GuardedConnection.cpp:165 (libstatisticsserver.so)

5: 0x00007fa77ddd7b6d in StatisticsService::CollectorThread::run(void*&)+0x889 at CollectorThread.cpp:216 (libstatisticsserver.so)

6: 0x00007fa765096759 in Execution::Thread::staticMainImp(void**)+0x875 at Thread.cpp:492 (libhdbbasis.so)

7: 0x00007fa7650973bd in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)

-------------------------------------------------------------------------


Has anybody any idea what this means and how to get rid of this?


Many thanks in advance for your help.


Regards,

Robert

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

Ok, gut feeling tells me that there is a kind of session timeout kicking out your statistics server session after some time.

I recommend to migrate the statistics server to the embedded statistics service and avoid this problem altogether.

- Lars

Former Member
0 Kudos

Hello Lars,

Any idea what kicks the statistics server session, we have the same issue and couldn't find any lead on this error.

Also, what will be the effect of this error on other services(indexserver, nameserver . . .) and other 3rd party systems connected to HANA?

We are experiencing slowness in a 3rd party system connected to HANA, is this SQLDBC error might be the reason for slowness?

Any help will be appreciated.

Regards,

Dheeraj

lbreddemann
Active Contributor
0 Kudos

The same recommendation still applies - use the integrated statistics services instead of statistic server.

I'm under the impression that for the error posted by the OP the statistics server was actually not causing the issue, but suffering a consequence of it.

Anyhow, I don't see any indication here that any other services or clients would be affected by this statistics server problem.

In case you cannot get headroom on the issue, the standard recommendation applies as well: open a support incident and have the support colleagues look into it.

- Lars