往PG14中灌入数据时报错org.postgresql.util.PSQLException: ERROR: syntax error at or near "\"

[hybench@VM-8-9-opencloudos hybench]$ ./hybench -t sql -f conf/load_data_pg.sql -c conf/pg.props
=============================================
|  _    _       ____                  _      |
| | |  | |     |  _ \                | |     |
| | |__| |_   _| |_) | ___ _ __   ___| |__   |
| |  __  | | | |  _ < / _ \ '_ \ / __| '_ \  |
| | |  | | |_| | |_) |  __/ | | | (__| | | | |
| |_|  |_|\__, |____/ \___|_| |_|\___|_| |_| |
|          __/ |                             |
|         |___/                              |
=============================================
2025-08-10 17:49:18.390 [main] INFO  HyBench:327 - Hi~Bench, HyBench
2025-08-10 17:49:18.399 [main] INFO  ConfigLoader:57 - ===============configuration==================
2025-08-10 17:49:18.400 [main] INFO  ConfigLoader:59 - classname_ap = org.postgresql.Driver
2025-08-10 17:49:18.400 [main] INFO  ConfigLoader:59 - at2_percent = 25
2025-08-10 17:49:18.401 [main] INFO  ConfigLoader:59 - at1_percent = 35
2025-08-10 17:49:18.401 [main] INFO  ConfigLoader:59 - apclient = 1
2025-08-10 17:49:18.401 [main] INFO  ConfigLoader:59 - at4_percent = 15
2025-08-10 17:49:18.402 [main] INFO  ConfigLoader:59 - url_tp = jdbc:postgresql://localhost:5433/hybench_sf1x
2025-08-10 17:49:18.404 [main] INFO  ConfigLoader:59 - runMins = 1
2025-08-10 17:49:18.404 [main] INFO  ConfigLoader:59 - url = jdbc:postgresql://localhost:5433/hybench_sf1x
2025-08-10 17:49:18.404 [main] INFO  ConfigLoader:59 - at3_percent = 15
2025-08-10 17:49:18.405 [main] INFO  ConfigLoader:59 - contention_num = 100
2025-08-10 17:49:18.405 [main] INFO  ConfigLoader:59 - password = Hello@123456
2025-08-10 17:49:18.406 [main] INFO  ConfigLoader:59 - tpclient = 1
2025-08-10 17:49:18.406 [main] INFO  ConfigLoader:59 - sf = 1x
2025-08-10 17:49:18.406 [main] INFO  ConfigLoader:59 - username_ap = pg1414
2025-08-10 17:49:18.407 [main] INFO  ConfigLoader:59 - classname = org.postgresql.Driver
2025-08-10 17:49:18.407 [main] INFO  ConfigLoader:59 - password_ap = Hello@123456
2025-08-10 17:49:18.407 [main] INFO  ConfigLoader:59 - at5_percent = 7
2025-08-10 17:49:18.408 [main] INFO  ConfigLoader:59 - db = postgreSQL
2025-08-10 17:49:18.408 [main] INFO  ConfigLoader:59 - username = pg1414
2025-08-10 17:49:18.408 [main] INFO  ConfigLoader:59 - url_ap = jdbc:postgresql://localhost:5433/hybench_sf1x
2025-08-10 17:49:18.409 [main] INFO  ConfigLoader:59 - at6_percent = 3
2025-08-10 17:49:18.409 [main] INFO  ConfigLoader:61 - ===============configuration==================
2025-08-10 17:49:18.409 [main] INFO  ConfigLoader:62 - 
2025-08-10 17:49:18.767 [main] INFO  ExecSQL:58 - execute query:\copy customer from 'Data_1x/customer.csv' CSV DELIMITER ',' ;
org.postgresql.util.PSQLException: ERROR: syntax error at or near "\"
  Position: 1
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:290)
	at com.hybench.load.ExecSQL.execute(ExecSQL.java:59)
	at com.hybench.HyBench.main(HyBench.java:353)
[hybench@VM-8-9-opencloudos hybench]$

HyBench/Hybench

内容风险标识

评论 (0)

HyBench/Hybench .gitee-modal { width: 500px !important; }

内容风险标识