質問編集履歴

新たなコードの追記

2018/06/25 04:52

投稿

n_oshiumi

スコア16

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -251,3 +251,139 @@
 phalcon_mariadb | 2018-06-20  3:30:38 140096783243008 [Note] InnoDB: Buffer pool(s) load completed at 180620  3:30:38
 ```
+## 追記 Docer-compose.yml
+```Docer-compose.yml
+version: '3.4'
+services:
+  mysql:
+    restart: always
+    image: mariadb:10.2
+    container_name: phalcon_mariadb
+    ports:
+      - 3306:3306
+    environment:
+      MYSQL_DATABASE: test
+      MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
+    volumes:
+      - mysql:/var/lib/mysql
+  php:
+    restart: always
+    build: ./
+    container_name: phalcon_php
+    ports:
+      # php-fpm
+      - 9000:9000
+    environment:
+      APP_ENV: 'development'
+      XDEBUG_REMOTE_HOST: 'host.docker.internal'
+      XDEBUG_REMOTE_PORT: '9005'
+      XDEBUG_IDE: 'VSCODE'
+      DB_HOST: 'mysql'
+    volumes:
+      - ./php:/app/php
+      - ./html:/app/html
+      - ./config/www.conf:/usr/local/etc/php-fpm.d/www.conf
+      - ./config/phalcon.ini:/usr/local/etc/php/conf.d/phalcon.ini
+    depends_on:
+      - mysql
+  nginx:
+    restart: always
+    image: phalconphp/nginx:1.10
+    container_name: phalcon_nginx
+    ports:
+      - 80:80
+    volumes:
+      - ./config/nginx.conf:/etc/nginx/conf.d/test.template
+      - ./src:/app/src
+      - ./html:/app/html
+    environment:
+      HOST_NAME: 'test.local'
+      PHP_CONTAINER: 'php'
+    command: >
+      sh -c "envsubst \"`env | awk -F = '{printf \" $$%s\", $$1}'`\"
+      < /etc/nginx/conf.d/test.template
+      > /etc/nginx/conf.d/default.conf
+      && nginx -g 'daemon off;'"
+    depends_on:
+      - php
+# docker volume create --name=mysql
+volumes:
+  mysql:
+    external: true
+```

エラーログの追記

2018/06/25 04:52

投稿

n_oshiumi

スコア16

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -135,3 +135,119 @@
 ```
+## ログの追記
+PHPのエラーログ
+```
+phalcon_php | 172.18.0.4 -  20/Jun/2018:03:34:43 +0000 "GET /index.php" 200
+phalcon_php | [20-Jun-2018 03:34:44] WARNING: [pool www] child 8 exited on signal 4 (SIGILL) after 6.481382 seconds from start
+phalcon_php | [20-Jun-2018 03:34:44] NOTICE: [pool www] child 9 started
+```
+nginxのエラーログ
+```
+phalcon_nginx | 172.18.0.1 - - [20/Jun/2018:03:36:35 +0000] "GET / HTTP/1.1" 200 394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_
+5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36" "-"
+phalcon_nginx | 172.18.0.1 - - [20/Jun/2018:03:36:36 +0000] "GET /favicon.ico HTTP/1.1" 200 1150 "http://test.local/" "Mozilla/5.0 (
+Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36" "-"
+phalcon_nginx | 172.18.0.1 - - [20/Jun/2018:03:36:36 +0000] "GET /api/initialize?timezone=Asia/Tokyo HTTP/1.1" 502 568 "http://test.
+local/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36" "-"
+phalcon_nginx | 2018/06/20 03:36:36 [error] 13#13: *26 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 172.18.0.1, server: test.local, request: "GET /api/initialize?timezone=Asia/Tokyo HTTP/1.1", upstream: "fastcgi://172.18.0.3:9000", host: "test.local", referrer: "http://test.local/"
+```
+mysqlのエラーログ
+今実行してもmysqlのエラーは何も出ないのですが、知らないうちにエラーが溜まっていました。
+```
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Compressed tables use zlib 1.2.8                           [0/139]
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Using Linux native AIO
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Number of pools: 1
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Using SSE2 crc32 instructions
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk
+size = 128M
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Completed initialization of buffer pool
+phalcon_mariadb | 2018-06-20  3:30:36 140097225074432 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread pr
+iority can be changed. See the man page of setpriority().
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Highest supported file format is Barracuda.
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: 128 out of 128 rollback segments are active.
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Creating shared tablespace for temporary tables
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file
+ full; Please wait ...
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: Waiting for purge to start
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] InnoDB: 5.7.22 started; log sequence number 172722127
+phalcon_mariadb | 2018-06-20  3:30:36 140096783243008 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] Plugin 'FEEDBACK' is disabled.
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] Server socket created on IP: '::'.
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Warning] 'proxies_priv' entry '@% root@273f5a19507c' ignored in --skip-name-reso
+lve mode.
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] Reading of all Master_info entries succeded
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] Added new Master_info '' to hash table
+phalcon_mariadb | 2018-06-20  3:30:36 140097962047360 [Note] mysqld: ready for connections.
+phalcon_mariadb | Version: '10.2.15-MariaDB-10.2.15+maria~jessie'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binar
+y distribution
+phalcon_mariadb | 2018-06-20  3:30:38 140096783243008 [Note] InnoDB: Buffer pool(s) load completed at 180620  3:30:38
+```

誤字

2018/06/20 03:42

投稿

n_oshiumi

スコア16

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -13,14 +13,6 @@
 Docker for Macで環境構築をして、アプリケーションを動かしたいのですが、なぜか502エラーが出ました。
-```
-phalcon_php | [18-Jun-2018 00:06:33] WARNING: [pool www] child 6 exited on signal 4 (SIGILL) after 549.851562 seconds from start
-phalcon_nginx | 2018/06/18 00:06:33 [error] 5#5: *3 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 172.18.0.1, server: test.local, request: "GET /api/initialize?timezone=Asia/Tokyo HTTP/1.1", upstream: "fastcgi://172.18.0.4:9000", host: "test.local", referrer: "http://test.local/"
-```
@@ -143,7 +135,3 @@
 ```
-- DBの稼働状況

誤字

2018/06/19 01:42

投稿

n_oshiumi

スコア16

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -104,7 +104,7 @@
                 'password' => '',
-                'dbname' => 'reachat',
+                'dbname' => 'test',
                 'persistent' => true

エラーが発生しているソース、DB接続情報を追記しました。

2018/06/18 05:48

投稿

n_oshiumi

スコア16

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -39,3 +39,111 @@
 ご回答よろしくお願いします。。
+# 追記
+- 実際にエラーが発生しているソース
+$WritingTotalPointsは、ブログの一ヶ月間の文字数の合計です。
+$columnsと$startOfMonth, $startOfNextMonthはXdebugを使って変数にちゃんとデータが入っていることを確認しました。
+dockerのコンテナに入り、blogテーブルとそれぞれのデータがあることは確認しました。
+execute(); で失敗しています。
+```indexController.php
+$WritingTotalPoints = \Blog::query()
+            ->columns($columns)
+            ->innerJoin('Site', 'Site.id = Blog.siteId')
+            ->where("Blog.contentDueDate >= '{$startOfMonth}' AND Blog.contentDueDate < '{$startOfNextMonth}'")
+            ->execute();
+```
+- DB接続情報
+セキュリティ的にはよくないかもしれませんが、そこはスルーで、、、。
+```app.php
+'database' => [
+        'isAutoCast' => true,
+        'mysql' => [
+            'development' => [
+                'adapter' => 'Mysql',
+                'host' => getenv('DB_HOST') ?: 'localhost',
+                'username' => 'root',
+                'password' => '',
+                'dbname' => 'reachat',
+                'persistent' => true
+            ],
+            'production' => [
+                'adapter' => 'Mysql',
+                'host' => getenv('DB_HOST'),
+                'username' => getenv('DB_USER'),
+                'password' => getenv('DB_PASS'),
+                'dbname' => getenv('DB_NAME'),
+                'persistent' => true
+            ]
+        ],
+        'results' => [
+            'flatten' => true,
+            'masterValues' => 'extract', // null | extract
+            'scope' => 'public', // null | public | protected | private
+        ]
+    ],
+```
+- DBの稼働状況