react docker build遇到的问题

Sunny

react docker build遇到的问题

failed to solve with frontend dockerfile.v0: failed to read dockerfile: open /var/lib/docker/tmp/buildkit-mount155848331/Dockerfile: no such file or directory

意思是没找到dockerfile, 那么我们可以指定dockerfile去 build

1. docker build . -f dockerfile.dev

复制代码

Sunny

1. react-server   | node:events:504
   
2. react-server   |       throw er; // Unhandled 'error' event
   
3. react-server   |       ^
   
4. react-server   |
   
5. react-server   | Error: Connection lost: The server closed the connection.
   
6. react-server   |     at Protocol.end (/app/server/node_modules/mysql/lib/protocol/Protocol.js:112:13)
   
7. react-server   |     at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:94:28)
   
8. react-server   |     at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:526:10)
   
9. react-server   |     at Socket.emit (node:events:538:35)
   
10. react-server   |     at endReadableNT (node:internal/streams/readable:1345:12)
    
11. react-server   |     at processTicksAndRejections (node:internal/process/task_queues:83:21)
    
12. react-server   | Emitted 'error' event on Connection instance at:
    
13. react-server   |     at Connection._handleProtocolError (/app/server/node_modules/mysql/lib/Connection.js:423:8)
    
14. react-server   |     at Protocol.emit (node:events:526:28)
    
15. react-server   |     at Protocol._delegateError (/app/server/node_modules/mysql/lib/protocol/Protocol.js:398:10)
    
16. react-server   |     at Protocol.end (/app/server/node_modules/mysql/lib/protocol/Protocol.js:116:8)
    
17. react-server   |     at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:94:28)
    
18. react-server   |     [... lines matching original stack trace ...]
    
19. react-server   |     at processTicksAndRejections (node:internal/process/task_queues:83:21) {
    
20. react-server   |   fatal: true,
    
21. react-server   |   code: 'PROTOCOL_CONNECTION_LOST'
    
22. react-server   | }
    
23. react-server exited with code 1

复制代码

在做数据库相关查询时间,遇到PROTOCOL_CONNECTION_LOST问题,虽然做了控制,但debug log还是会出现,以我知解决方法有两个,
一个是出现code: PROTOCOL_CONNECTION_LOST后重连
第二个是使用connection pool处理,下面是demo

1. var mysql = require("mysql");
   
2. var pool = mysql.createPool({
   
3.     host: 'your host',
   
4.     user:'your account',
   
5.     password:'your password',
   
6.     database:'your database',
   
7.     connectionLimit : 10,
   
8. });

复制代码

查询数据库,重点conn.query后一定要conn.release()

1. var query = function(sql, options, callback) {
   
2. 
   
3.     pool.getConnection(function(err, conn){
   
4.         if (err) {
   
5.             callback(err, null, null);
   
6.         } else {
   
7.             conn.query(sql, options, function(err, results, fields){
   
8. 
   
9.             });
   
10.             // release connection。
    
11. 
    
12.             conn.release();
    
13.         }
    
14.     });
    
15. };

复制代码