Hello/Hi/Greetings,
Hello. Have now moved my virtual server Centos 9 Stream to brand new PC; 12th gen. i9 CPU with 128 GB RAM and .M2 SSDs. And I still got the Gateway Timeout error when optimizing and repair database. What could possible cause this?
Piwigo URL: http://www.fotoarkiv.no
Piwigo 13.5.0 Check for upgrade
Installed on 11 april 2020, 2 years 9 months 3 weeks ago
Operating system: Linux
PHP: 7.4.33 (Show info) [2023-02-03 15:37:22]
MySQL: 5.5.5-10.5.16-MariaDB [2023-02-03 16:37:22]
Graphics Library: External ImageMagick 6.9.12-70
Cache size 116593.04 Mo calculated 2 days ago Refresh
Activated plugin list 48
Add < head > element
Additional Pages
Admin Tools
Advanced Menu Manager
Batch Downloader
Batch Manager Prefilters
Batch Manager, Description
BatchCustomDerivatives
Block search
Contact Form
Copyrights
Download by Size
Download Permissions
Evil_Blog
Extended Description
External Reference
FCK Editor
Force HTTPS
Grum Plugins Classes.3
GThumb+
LocalFiles Editor
Look_like_gbo2
Manage Properties Photos
Meta Open Graph
No Stats For Robots
OpenStreetMap
Permalink Generator
Perso Footer
Personal Favicon
Physical Photo Move
PiwigoClientWsExts
Posted Date Changer
Prepaid Credits
Properties Mass Update
PWG Stuffs
rightClick
RV autocomplete
RV Thumb Scroller
Scroll To Top
Security Headers
Social Buttons
Social Connect
SortOrders
Tag Recognition
Thumbnail Tooltip
UserAdvManager
VideoJS
Write Metadata
Offline
504 Gateway Timeout is nothing Piwigo specific, it may be any timeout between any of the network hops involved in the request. Might be a proxy server or router in your web hosting, or anything between the server accepting the browser request and the machine fulfilling the request, or a slow database connection between servers, or even some crappy cable.. Could also be a proxy server or router in your local network or a faulty DNS server, though unlikely if it happens only on optimizing the database.
Offline
erAck wrote:
504 Gateway Timeout is nothing Piwigo specific, it may be any timeout between any of the network hops involved in the request. Might be a proxy server or router in your web hosting, or anything between the server accepting the browser request and the machine fulfilling the request, or a slow database connection between servers, or even some crappy cable.. Could also be a proxy server or router in your local network or a faulty DNS server, though unlikely if it happens only on optimizing the database.
Ok. :-) This is on my LAN direct connection to virtual VMware Guest on the SAME PC. So its a timeout in browser?
Last edited by BigIsland270972 (2023-02-03 19:45:10)
Offline
More likely a PHP timeout, waiting for the database query to finish.
Offline
erAck wrote:
More likely a PHP timeout, waiting for the database query to finish.
here's my php.ini:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time = 10000
Offline
Offline
https://www.google.com/search?q=remove+ … p;dpr=1.25
I also tried this.
Offline
/etc/my.cnf
[mysqld]
wait_timeout= 28800
optimizer_search_depth = 0
skip-name-resolve
Offline