What does stv_fdisk_stats table do?

0

I see a repetition of this query throughout the day and night:
select node_num,value from stv_fdisk_stats where name='blocks_allocated_total';

I get permissions errors if i try to run the query myself; I am asking because it's the only stl_query happening at the exact time of a 'conflict with concurrent transaction' error affecting our normal nightly processing.

hislop
질문됨 4년 전223회 조회
1개 답변
0

This query is run by an internal metrics service. It is definitively not the cause of your error.

If there are no queries running, it's likely that some previous operation left a transaction open on the resources used by your failing query. This may have happened because a remote process became stuck and left it's connection open without running ROLLBACK or COMMIT.

I have also seen this happen in instances where a user accidentally disabled the auto commit option in their query tool.

답변함 4년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠