r2dbc-postgresql icon indicating copy to clipboard operation
r2dbc-postgresql copied to clipboard

Published 20 hours ago • verified publisher icon pgjdbc

Always execute some SQL

Open zhuangzibin opened this issue 3 years ago • 0 comments
trafficstars

Bug Report

Versions

  • Driver:0.9.1
  • Database:postgresql
  • Java:17
  • OS:Linux、MacOs
  • Other:SpringBoot 2.7.2、WebFlux、SpringDataJpa、r2dbc

Current Behavior

When i executed my sql once time,the server executed some sql multiple times.It can be repeated every time.

// your stack trace here
2022-08-09 11:11:12.435-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:12.465-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:12.496-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: select 1
2022-08-09 11:11:12.525-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.PARAM [Loggers.java:250] - Bind parameter [0] to: adipisicing eu reprehenderit nisi
2022-08-09 11:11:12.530-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: select id from equipment_factory_user_record where account = $1 and deleted = false
2022-08-09 11:11:13.553-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.557-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.559-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.570-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.572-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.574-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.577-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.580-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.582-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SHOW TRANSACTION ISOLATION LEVEL
2022-08-09 11:11:13.583-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.584-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.585-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.594-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.595-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.596-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.597-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.598-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')
2022-08-09 11:11:13.599-19177-[[019fc610e53cea0b],[019fc610e53cea0b],[]]-[reactor-tcp-kqueue-3] DEBUG io.r2dbc.postgresql.QUERY [Loggers.java:250] - Executing query: SELECT oid, typname FROM pg_catalog.pg_type WHERE typname IN ('hstore','geometry')

Table schema

Input Code 
-- your SQL here;
create table equipment_factory_user_record
(
    id              bigserial
        constraint equipment_factory_user_record_pk
            primary key,
    account         varchar(19)           not null,
    created         timestamp             not null,
    created_by      bigint                not null,
    updated         timestamp,
    updated_by      bigint,
    organization_id bigint,
    deleted         boolean default false not null
);

Steps to reproduce

post -> controller -> server -> repository -> database

Input Code 
// your code here;
@Data
@ToString
@NoArgsConstructor
@AllArgsConstructor
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = true)
@Table("equipment_factory_user_record")
public class EquipmentFactoryUserRecord extends BaseEntity {

    public static final String COLUMN_ID = "id";
    public static final String COLUMN_ACCOUNT = "account";

    @Id
    @Column(COLUMN_ID)
    private Long id;

    @Column(COLUMN_ACCOUNT)
    private String account;

}

Expected behavior/code

do not execute this sql everyTime

Possible Solution

Additional context

zhuangzibin avatar Aug 09 '22 03:08 zhuangzibin