js
root@VM-8-13-ubuntu:~# curl -vI https://xbd.iftballs.com/
*   Trying 146.56.132.194:443...
* Connected to xbd.iftballs.com (146.56.132.194) port 443 (#0)
* ALPN, offering h2
* ALPN, offering http/1.1
*  CAfile: /etc/ssl/certs/ca-certificates.crt
*  CApath: /etc/ssl/certs
* TLSv1.0 (OUT), TLS header, Certificate Status (22):
* TLSv1.3 (OUT), TLS handshake, Client hello (1):
* TLSv1.2 (IN), TLS header, Certificate Status (22):
* TLSv1.3 (IN), TLS handshake, Server hello (2):
* TLSv1.2 (IN), TLS header, Finished (20):
* TLSv1.2 (IN), TLS header, Supplemental data (23):
* TLSv1.3 (IN), TLS handshake, Encrypted Extensions (8):
* TLSv1.2 (IN), TLS header, Supplemental data (23):
* TLSv1.3 (IN), TLS handshake, Certificate (11):
* TLSv1.2 (OUT), TLS header, Unknown (21):
* TLSv1.3 (OUT), TLS alert, certificate expired (557):
* SSL certificate problem: certificate has expired
* Closing connection 0
curl: (60) SSL certificate problem: certificate has expired
More details here: https://curl.se/docs/sslcerts.html

执行处理数据时，报错：

js
ERROR 1292 (22007) at line 4: Incorrect datetime value: '' for column 'end_time' at row 3

经过，排查发现从原始数据抓取后的数据，发生了变化，需要进行修改处理。

01

十年前的夏天，年轻人不愿当公务员，国考人数锐减36万，热帖称“机关钱少活多”。

那年全国毕业生700余万，就业率超九成，复旦学生租游艇办毕业舞会，女孩们花两千元买晚礼服，夜游江海。

那年世界的齿轮咬合稳定，中美迎来建交35周年。美国民调中，超72%年轻人，将中国视为“朋友”。

夏天前，奥巴马夫人到访，体验了长城、紫禁城与成都火锅。

慕田峪长城上，总统夫人看燕山起伏，觉得一切宽阔且美妙，“长城的长度几乎相当于从美国缅因州到俄勒冈州的四倍”。

宝塔面板nginx配置下载文件

js
server {
    listen 80;
    server_name dwload.iftballs.com;
    if ($host ~ "dwload.iftballs.com$") {
    rewrite ^/(.)$ https://dwload.iftballs.com/ permanent;
    }
}

server
{
    listen 127.0.0.1:8454 ssl http2;
    server_name dwload.iftballs.com;
    ssl_certificate '/www/server/panel/vhost/cert/dwload.iftballs.com/fullchain.pem';
    ssl_certificate_key '/www/server/panel/vhost/cert/dwload.iftballs.com/privkey.pem';
    ssl_protocols TLSv1.1 TLSv1.2 TLSv1.3;
    ssl_prefer_server_ciphers   on;
    ssl_session_timeout '64m';
    #index index.php index.html index.htm default.php default.htm default.html;
    root /www/wwwroot/dwload.iftballs.com/download;
    

项目postgres 连接不上， 所有连接报错 ：psql: FATAL: sorry, too many clients already

原由：

• 程序使用连接未及时释放， 连接一直处于 idle 状态