search

takoyakisoba / isucon-practice-20220716

2022/07/16 (Sat) ISUCON練習会 (ISUCON 11 予選)
0 stars 0 forks source link

conditionの取得のN1解消 #17

Closed cureseven closed 2 years ago

cureseven commented 2 years ago

1

GET /api/trend

cureseven commented 2 years ago 
    github.com/isucon/isucandar.(*BenchmarkStep).AddError
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark_step.go:30
    github.com/isucon/isucandar.(*Benchmark).Start
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:104
    main.main
        /home/isucon/bench/main.go:438
    runtime.main
        /home/isucon/local/go/src/runtime/proc.go:225
  - critical:
    github.com/isucon/isucon11-qualify/bench/scenario.(*Scenario).prepareCheck
        /home/isucon/bench/scenario/prepare.go:117
    github.com/isucon/isucon11-qualify/bench/scenario.(*Scenario).Prepare
        /home/isucon/bench/scenario/prepare.go:82
    github.com/isucon/isucandar.(*Benchmark).Start.func2
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:98
    github.com/isucon/isucandar.panicWrapper
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:204
    github.com/isucon/isucandar.(*Benchmark).Start
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:98
  - アプリケーション互換性チェックに失敗しました
16:24:14.776055 score: 0(0 - 0) : Critical error
16:24:14.776133 deduction: 0 / timeout: 0
16:24:14.776182 <=== sendResult finish
pinkumohikan commented 2 years ago

7月 17 17:08:34 isucon11q-03 isucondition[22627]: {"time":"2022-07-17T17:08:34.5690888+09:00","level":"ERROR","prefix":"echo","file":"main.go","line":"1186","message":"db error: sql: expected 0 arguments, got 1"}

cureseven commented 2 years ago 
cd ../bench && ./bench -all-addresses 127.0.0.11 -target 127.0.0.11:443 -tls -jia-service-url http://127.0.0.1:4999
17:14:07.275131 ISUCON11 benchmarker
17:14:07.275662 ===> PREPARE
17:14:07.275679 start: load initial data
17:14:07.279959 finish: load initial data
17:14:07.284398 ERR: prepare: critical: initializeに失敗しました
17:14:07.284521 ERR: prepare: http: Post "https://127.0.0.11:443/initialize": x509: certificate is valid for sub.mishima.tokyo, not isucondition-1.t.isucon.dev
17:14:07.284694 SCORE: 00.StartBenchmark       : 0
17:14:07.284897 SCORE: 01.GraphGood            : 0
17:14:07.284918 SCORE: 02.GraphNormal          : 0
17:14:07.284924 SCORE: 03.GraphBad             : 0
17:14:07.285032 SCORE: 04.GraphWorst           : 0
17:14:07.285194 SCORE: 05.TodayGraphGood       : 0
17:14:07.285215 SCORE: 06.TodayGraphNormal     : 0
17:14:07.285382 SCORE: 07.TodayGraphBad        : 0
17:14:07.285442 SCORE: 08.TodayGraphWorst      : 0
17:14:07.285495 SCORE: 09.ReadInfoCondition    : 0
17:14:07.285546 SCORE: 10.ReadWarningCondition : 0
17:14:07.285597 SCORE: 11.ReadCriticalCondition: 0
17:14:07.285647 SCORE: _1.IsuInitialize        : 0
17:14:07.285715 SCORE: _2.NormalUserInitialize : 0
17:14:07.285767 SCORE: _3.ViewerInitialize     : 0
17:14:07.285819 SCORE: _5.ViewerDropout        : 0
17:14:07.285869 SCORE: _6.RepairIsu            : 0
17:14:07.285932 SCORE: _7.PostInfoCondition    : 0
17:14:07.285983 SCORE: _8.PostWarningCondition : 0
17:14:07.286058 SCORE: _9.PostCriticalCondition: 0
17:14:07.286109 SCORE: 00.StartBenchmark       : 0
17:14:07.286159 SCORE: 01.GraphGood            : 0
17:14:07.286208 SCORE: 02.GraphNormal          : 0
17:14:07.286259 SCORE: 03.GraphBad             : 0
17:14:07.286308 SCORE: 04.GraphWorst           : 0
17:14:07.286357 SCORE: 05.TodayGraphGood       : 0
17:14:07.286406 SCORE: 06.TodayGraphNormal     : 0
17:14:07.286455 SCORE: 07.TodayGraphBad        : 0
17:14:07.286504 SCORE: 08.TodayGraphWorst      : 0
17:14:07.286553 SCORE: 09.ReadInfoCondition    : 0
17:14:07.286602 SCORE: 10.ReadWarningCondition : 0
17:14:07.286651 SCORE: 11.ReadCriticalCondition: 0
17:14:07.286834 Critical error because: prepare:
    github.com/isucon/isucandar.(*BenchmarkStep).AddError
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark_step.go:30
    github.com/isucon/isucon11-qualify/bench/scenario.(*Scenario).Prepare
        /home/isucon/bench/scenario/prepare.go:72
    github.com/isucon/isucandar.(*Benchmark).Start.func2
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:98
    github.com/isucon/isucandar.panicWrapper
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:204
    github.com/isucon/isucandar.(*Benchmark).Start
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:98
  - critical:
    github.com/isucon/isucon11-qualify/bench/scenario.(*Scenario).Prepare
        /home/isucon/bench/scenario/prepare.go:72
    github.com/isucon/isucandar.(*Benchmark).Start.func2
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:98
    github.com/isucon/isucandar.panicWrapper
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:204
    github.com/isucon/isucandar.(*Benchmark).Start
        /home/isucon/go/pkg/mod/github.com/isucon/isucandar@v0.0.0-20210821075549-ee64d0785035/benchmark.go:98
    main.main
        /home/isucon/bench/main.go:438
  - initializeに失敗しました
17:14:07.286887 score: 0(0 - 0) : Critical error
17:14:07.287054 deduction: 0 / timeout: 0
17:14:07.287162 <=== sendResult finish
cureseven commented 2 years ago 
MariaDB [isucondition]> select * from isu where isu.character = 'おくびょう';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    135
Current database: isucondition

+-----+--------------------------------------+-----------------------------+-------+-----------------+-----------------------+----------------------------+----------------------------+-------------------+
| id  | jia_isu_uuid                         | name                        | image | character       | jia_user_id           | created_at                 | updated_at                 | use_default_image |
+-----+--------------------------------------+-----------------------------+-------+-----------------+-----------------------+----------------------------+----------------------------+-------------------+
|   3 | 8469e6f6-0d29-4052-87cf-dd9bfde45014 | リビングサイコー            |       | おくびょう      | isucon1               | 2021-06-03 15:58:09.000000 | 2022-07-17 17:22:55.534148 |                 0 |
|  37 | cfc96ae7-0ed2-4f6e-b814-60a855cefb16 | 北欧風座布団                | NULL  | おくびょう      | sharp_albattani       | 2022-07-17 17:23:00.920438 | 2022-07-17 17:23:00.973943 |                 0 |
|  38 | 2696230b-d95c-4392-8725-4e5e5278bcb4 | ISUCONカウチ                | NULL  | おくびょう      | stupefied_nightingale | 2022-07-17 17:23:00.922344 | 2022-07-17 17:23:00.975114 |                 0 |
| 122 | 943b0b9f-435c-4139-a6cf-320141e697d0 | シャア専用一脚              | NULL  | おくびょう      | affectionate_hypatia  | 2022-07-17 17:23:36.324275 | 2022-07-17 17:23:36.395689 |                 0 |
| 147 | f3725f64-9706-4bbb-af30-5671bc97baef | エルゴノミクスポチ          | NULL  | おくびょう      | focused_hellman       | 2022-07-17 17:23:47.404838 | 2022-07-17 17:23:47.538806 |                 0 |
| 151 | 7f0a7120-87cb-45a6-b863-f507cfe75269 | ダイニング四脚              | NULL  | おくびょう      | sad_gates             | 2022-07-17 17:23:51.508063 | 2022-07-17 17:23:51.587194 |                 0 |
| 155 | 25f72343-c7a8-447a-b7dd-99d0ff4d8270 | オフィスMk-Ⅱ                | NULL  | おくびょう      | sad_gates             | 2022-07-17 17:23:51.987973 | 2022-07-17 17:23:52.100789 |                 1 |
| 182 | da38ab32-9ab0-4904-b5b7-fe3ec63f874a | はりぼてサイコー            | NULL  | おくびょう      | tender_torvalds       | 2022-07-17 17:23:58.737543 | 2022-07-17 17:23:58.809177 |                 0 |
+-----+--------------------------------------+-----------------------------+-------+-----------------+-----------------------+----------------------------+----------------------------+-------------------+
8 rows in set (0.007 sec)

MariaDB [isucondition]> select * from isu where isu.character = 'おくびょう';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    42
Current database: isucondition

+----+--------------------------------------+--------------------------+-------+-----------------+-------------+----------------------------+----------------------------+-------------------+
| id | jia_isu_uuid                         | name                     | image | character       | jia_user_id | created_at                 | updated_at                 | use_default_image |
+----+--------------------------------------+--------------------------+-------+-----------------+-------------+----------------------------+----------------------------+-------------------+
|  3 | 8469e6f6-0d29-4052-87cf-dd9bfde45014 | リビングサイコー         |       | おくびょう      | isucon1     | 2021-06-03 15:58:09.000000 | 2022-07-17 17:25:13.890011 |                 0 |
+----+--------------------------------------+--------------------------+-------+-----------------+-------------+----------------------------+----------------------------+-------------------+
1 row in set (0.013 sec)
cureseven commented 2 years ago 
17:42:58.788652 score: 118909(118914 - 5) : pass
17:42:58.788669 deduction: 3 / timeout: 24
17:42:58.788714 <=== sendResult finish
pinkumohikan commented 2 years ago

素晴らしい

cureseven commented 2 years ago

18