distributed-database

What happened?

In a Jepsen test run of five etcd 3.5.3 nodes, with process pauses (sending processes SIGSTOP and SIGCONT), compaction (performed via the admin API), and defragmentation (via etcdctl), one etcd process crashed with the following error message:

{"level":"panic","ts":"2022-06-13T14:11:27.870Z","caller":"etcdserver/apply.go:638","msg":"unexpected error during txn","error

Enhancement

We have many place to use the exp/slices to sort our struct. It can improve performance by using pdqsort and clean branch check. But We have many placement using the old sort. Please remove it. Here is the example .

BTW, You haven't to change the bazel.build. it can be updated by robot.

• #36061
• #360

We have metrics recoding flush related stats (number of flushes, duration), but
those only work when issuing explicit Flush request.

Some sinks (cloud storage) also flush based on other criteria (size) -- we should
add metrics to record those flushes as well.

Jira issue: CRDB-17659

Our CMake build process produces tarball packages using the cpack TGZ target. This produces a server and client package with a file layout meant to match where the various artifacts go.

Meanwhile, the packages we include on the download page are a flat archive of various binaries produced by the build process. This include one regular package and one debug package with debug symbols for a few

Jira Link: DB-2957

Description

To reduce memory consumption, coarse histograms generally only track avgs using sum/count. They don't track percentiles which may need using more buckets.

However, sometimes while debugging this may be useful.

Add a gflag

• to use a higher number of buckets for tracking p95s etc.
• to control whether o

Use case:

PosgreSQL client compatibility (e.g. Trino)
SQL compliance

CrateDB

CREATE TABLE doc.x (txt TEXT)
SELECT crate.doc.x.txt FROM crate.doc.x

PostgreSQL

postgres=# CREATE TABLE public.x (txt TEXT);
CREATE TABLE
postgres=# SELECT postgres.public.x.txt FROM postgres.public.x;
 txt 
-----
(0 rows)

[From PostgreSQL docs](https://www.postg

Enhancement

Sometimes we need to modify configurations like schedule_slot_num_per_path to accelerate balance or repair process. Currently, if we want to change the value of schedule_slot_num_per_path we need to restart FE leader which can be quiet user unfriendly.

The values array in List[int8] format is almost the same as that one in int8, except the null value.

If there is no NULL value in the null bitmap, we can extract the value array directly to implement the unnest.

https://github.com/singularity-data/risingwave/blob/8b18f7b367f43ed1332692e3fec5545b70aa8c99/src/common/src/array/list_array.rs#L352-L364

Description
Refactor EngineBuilder to remove duplicate code

Proposal
code:
https://github.com/CeresDB/ceresdb/blob/890fecf10848a3d09b485af52ff516deccf771fc/analytic_engine/src/setup.rs#L92
https://github.com/CeresDB/ceresdb/blob/890fecf10848a3d09b485af52ff516deccf771fc/analytic_engine/src/setup.rs#L120
https://github.com/CeresDB/ceresdb/blob/890fecf10848a3d09b485af52ff516deccf771f

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

Several showcase SQL requires the support of this function:


select DATE_FORMAT(b.measurement_time,'%Y-%m-%d') 

select DATE_FORMAT(FROM_UNIXTIME(tm.create_time), %Y%m%d)

Describe the feature you'd like