Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

pgsql-swoole driver can not prompt errors #9

Open
@wuxi889

Description

app/Controller/TestController.php

 #[RequestMapping(path: "create", methods: "get")]
 public function create(ResponseInterface $response)
 {
 $s = \App\Model\Session::create([
 'id' => '131',
 'store_id' => 111,
 'uuid' => 'abc',
 'visitor_id' => '321',
 'user_id' => '0',
 'fingerprint' => '11111111111',
 'client_ip' => '127.0.0.1',
 ]);
 var_dump($s);
 return $response->raw('create session'); 
 }

pgsql 日志

2023年04月23日 13:43:37.125 CST,"track","track",46662,"172.17.0.3:36156",6444c589.b646,7,"PARSE",2023年04月23日 13:43:37 CST,3/48,0,LOG,00000,"duration: 1.488 ms parse swoole_stmt_2: insert into ""sessions"" (""id"", ""store_id"", ""uuid"", ""visitor_id"", ""user_id"", ""fingerprint"", ""client_ip"", ""updated_at_gmt"", ""created_at_gmt"") values (1ドル, 2ドル, 3ドル, 4ドル, 5ドル, 6ドル, 7ドル, 8ドル, 9ドル)",,,,,,,,,"","client backend",,0
2023年04月23日 13:43:37.127 CST,"track","track",46662,"172.17.0.3:36156",6444c589.b646,8,"BIND",2023年04月23日 13:43:37 CST,3/49,0,LOG,00000,"duration: 0.839 ms bind swoole_stmt_2: insert into ""sessions"" (""id"", ""store_id"", ""uuid"", ""visitor_id"", ""user_id"", ""fingerprint"", ""client_ip"", ""updated_at_gmt"", ""created_at_gmt"") values (1ドル, 2ドル, 3ドル, 4ドル, 5ドル, 6ドル, 7ドル, 8ドル, 9ドル)","parameters: 1ドル = '131', 2ドル = '111', 3ドル = 'abc', 4ドル = '321', 5ドル = '0', 6ドル = '11111111111', 7ドル = '127.0.0.1', 8ドル = '2023-04-23 05:43:37', 9ドル = '2023-04-23 05:43:37'",,,,,,,,"","client backend",,0
2023年04月23日 13:43:37.127 CST,"track","track",46662,"172.17.0.3:36156",6444c589.b646,9,"INSERT",2023年04月23日 13:43:37 CST,3/49,0,LOG,00000,"execute swoole_stmt_2: insert into ""sessions"" (""id"", ""store_id"", ""uuid"", ""visitor_id"", ""user_id"", ""fingerprint"", ""client_ip"", ""updated_at_gmt"", ""created_at_gmt"") values (1ドル, 2ドル, 3ドル, 4ドル, 5ドル, 6ドル, 7ドル, 8ドル, 9ドル)","parameters: 1ドル = '131', 2ドル = '111', 3ドル = 'abc', 4ドル = '321', 5ドル = '0', 6ドル = '11111111111', 7ドル = '127.0.0.1', 8ドル = '2023-04-23 05:43:37', 9ドル = '2023-04-23 05:43:37'",,,,,,,,"","client backend",,0
2023年04月23日 13:43:37.128 CST,"track","track",46662,"172.17.0.3:36156",6444c589.b646,10,"INSERT",2023年04月23日 13:43:37 CST,3/49,1052,ERROR,23505,"duplicate key value violates unique constraint ""sessions_pkey""","Key (store_id, uuid)=(111, abc) already exists.",,,,,"insert into ""sessions"" (""id"", ""store_id"", ""uuid"", ""visitor_id"", ""user_id"", ""fingerprint"", ""client_ip"", ""updated_at_gmt"", ""created_at_gmt"") values (1ドル, 2ドル, 3ドル, 4ドル, 5ドル, 6ドル, 7ドル, 8ドル, 9ドル)",,,"","client backend",,0

响应结果

image

问题

当我的数据库驱动使用 pgsql-swoole 并使用 model 去创建新的数据时,无论写入的 SQL 在数据库里是否发生了错误。 model 总能返回一个正确的对象给我,但 pgsql 里却没有对应的数据。

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

        AltStyle によって変換されたページ (->オリジナル) /