SAP Knowledge Base Article - Preview

2911708 - ERROR [SQL-301] unique constraint violated: Table(STATISTICS_PROPERTIES)

Symptom

Statisticsserver is disabled immediately after re-activating it. You can see similar error message from indexserver trace.

[<ThreadID>]{-1}[-1/-1] <Timestamp> i STATS_WORKER SQLInterfaceEAPI.cpp(00297) : createObject: <create trigger _SYS_STATISTICS.statistics_switch_profile
after update on _SYS_STATISTICS.statistics_properties
referencing new row mynewrow, old row myoldrow
begin
if :mynewrow.key = 'internal.sizing.profile'
then
if :mynewrow.value != :myoldrow.value
then
call _SYS_STATISTICS.shared_copy_profiles (:myoldrow.value, :mynewrow.value);
end if;
end if;
end> ERROR [SQL-446] cannot use duplicate trigger name: STATISTICS_SWITCH_PROFILE: line 1 col 32 (at pos 31) at ptime/query/checker/check_id.cc:226
exception 1: no.71000446 (ptime/query/checker/check_id.cc:226) TID: <ThreadID>
STATISTICS_SWITCH_PROFILE
NO exception throw location recorded. Stack generation suppressed.
[<ThreadID>]{-1}[-1/-1] <Timestamp> i TraceContext TraceContext.cpp(01218) : UserName=
[<ThreadID>]{-1}[-1/-1] <Timestamp> i STATS_WORKER SQLInterfaceEAPI.cpp(00297) : createObject: <insert into _SYS_STATISTICS.statistics_properties (key, value) values ('internal.sizing.profile', '')> ERROR [SQL-301] unique constraint violated: Table(STATISTICS_PROPERTIES), Index(_SYS_TREE_RS_#146168_#0_#P0) at RowEngine/Operator/Impl/TreeIndexOperator.cc:208
exception 1: no.71000301 (RowEngine/Operator/Impl/TreeIndexOperator.cc:208) TID: <ThreadID>
Table(STATISTICS_PROPERTIES), Index(_SYS_TREE_RS_#146168_#0_#P0)
NO exception throw location recorded. Stack generation suppressed.
[<ThreadID>]{-1}[-1/-1] <Timestamp> i TraceContext TraceContext.cpp(01218) : UserName=
[<ThreadID>]{-1}[-1/-1] <Timestamp> e STATS_CTRL NameServerControllerThread.cpp(00539) : error installing: exception 1: no.9002004 (StatisticsServerAsSQLScript/global/CallInterfaceDirect.cpp:265) TID: <ThreadID>
Error during installation: SQL error $code$: $text$..
exception throw location:
1: 0x00007fa30b9ac3d2 in StatisticsService::CallInterfaceDirect::install()+0x400 at CallInterfaceDirect.cpp:265 (libstatisticsserver2.so)
2: 0x00007fa30a782ffe in StatisticsService::NameServerControllerThread::run(void*)+0x30a at NameServerControllerThread.cpp:508 (libhdbns.so)
3: 0x00007fa2ea22f89f in TrexThreads::PoolThread::run()+0x78b at PoolThread.cpp:462 (libhdbbasement.so)
4: 0x00007fa2ea2323b0 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:143 (libhdbbasement.so)
5: 0x00007fa2e53310ef in Execution::Thread::staticMainImp(Execution::Thread*)+0x54b at Thread.cpp:528 (libhdbbasis.so)
6: 0x00007fa2e5320368 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x164 at ThreadInterposition.cpp:633 (libhdbbasis.so)
7: 0x00007fa2e4ad4724 in start_thread+0xc0 (libpthread.so.0)
8: 0x00007fa2e335fe8d in __clone+0x69 (libc.so.6)
[<ThreadID>]{-1}[-1/-1] <Timestamp> e STATS_CTRL NameServerControllerThread.cpp(00543) : disable Embedded Statistics Server


Read more...

Environment

HANA Platform 2.0

Product

SAP HANA, platform edition 2.0

Keywords

ESS, STATISTICS_PROPERTIES, drop, de-activate, duplication, unique violation , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.