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

mysql> CREATE TABLE t1 (
    -> risk_id varchar(32) NOT NULL,
    -> tran_id int NOT NULL,
    -> KEY (`risk_id`)
    -> );

mysql> CREATE TABLE t2 (
    -> risk_id varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
    -> -- risk_id varchar(32) NOT NULL,
    -> tran_id int NOT NULL,
    -> KEY (`risk_id`)
    -> );

mysql> explain select /*+ hash_join(t1) */ t1.ris

Is your feature request related to a problem? Please describe.

When debugging lease placement issues, it's instructive to look at the count for the number of raft leaders that aren't leaseholders. That metric however skips over replicas that hold invalid leases, which can mask the problem of a store holding a set of invalid leases and those leases not being actively acquired elsewhere. We s

• Add fixture: JDBCRepositoryFixture implements JDBCRepository
• Add test case with mock

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-3084

Description

We can just disable the pushdown on json column in MongoDB connector. TestMongoTypeMapping needs a new test method for json type when fixing this issue.

CREATE TABLE test (c1 json);
INSERT INTO test VALUES (json '{"id":0,"name":"user_0"}');

SELECT * FROM test WHERE c1 = json '{"id":0,"name":"user_0"}';
java.lang.UnsupportedOperationException
	at io.trino.spi.predicate.ValueSet.

Search before asking

• I had searched in the issues and found no similar issues.

Description

As title.

In BE, there are some many Substitute stringstream, we can replace them with fmt/format

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR

Use case:

Get the total duration over many events. Something like select sum(age(ended, started)) from myevents or select sum(ended - started) from myevents - depending on crate/crate#12479

See https://github.com/crate/crate/blob/dc3ce297b1597d482949a2e57479890feb3adbf4/server/src/main/java/io/crate/execution/engine/aggregation/impl/SumAggregation.java#L67

Real behavior (Required)

java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=9030)(type=master) : (conn=0) could not load system variables

	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197)