Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: ERROR: insufficient data for reading boolean array #247

Open
ZhiXingHeYiApple opened this issue Mar 25, 2024 · 1 comment
Open

[Bug]: ERROR: insufficient data for reading boolean array #247

ZhiXingHeYiApple opened this issue Mar 25, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@ZhiXingHeYiApple
Copy link

ZhiXingHeYiApple commented Mar 25, 2024

What's wrong?

I have a column table as follows, which periodically calls insert SQL to write data.

CREATE TABLE public.log_developer_api_code_msg (
	id bigserial NOT NULL,
	data_source text NULL,
	stat_date date NULL,
	stat_time int4 NULL,
	ent_id text NULL,
	client_id text NULL,
	api text NULL,
	code text NULL,
	message text NULL,
	count int4 NULL,
	create_time timestamp(3) NULL DEFAULT now(),
	update_time timestamp(3) NULL DEFAULT now(),
	CONSTRAINT log_developer_api_code_msg_pkey PRIMARY KEY (id)
) using columnar;

But after running for a while, I encountered the following query problem. What is certain is that it is normal for me to execute vacuum verbose log_developer_api_code_msg command.

uncategorized SQLException for SQL [select code, message, sum(count) as count from public.log_developer_api_code_msg where data_source = 'delta-developer-code-msg' and ent_id is not null and ent_id !='0' and code !='0' and code != '1' and code != '140001' and code != '200' and stat_date >= '2024-03-01' and stat_date <= '2024-03-01' group by code,message order by count desc limit 20]; 
SQL state [XX000]; error code [0]; ERROR: insufficient data for reading boolean array; nested exception is org.postgresql.util.PSQLException: ERROR: insufficient data for reading boolean array

I'm not sure what the source of this problem is? Does this error mean that the table is damaged? What steps should I take to resolve this issue? Thanks

@ZhiXingHeYiApple ZhiXingHeYiApple added the bug Something isn't working label Mar 25, 2024
@ZhiXingHeYiApple
Copy link
Author

The hydra version I'm using is 1.1.1.
docker image is PG15 ghcr.io/hydradatabase/hydra:15-dd0ef07209dd23b9fca213a152ee3ee13249bb34

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant