Announcement

#1 2023-02-03 16:38:25

BigIsland270972
Member
Norway
2022-03-15
374

Gateway Timeout

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?

https://www.fotoarkiv.no//priv/timeout.png
https://www.fotoarkiv.no//priv/centos.png

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


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#2 2023-02-03 18:47:50

erAck
Only trying to help
2015-09-06
1998

Re: Gateway Timeout

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.


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2023-02-03 19:44:27

BigIsland270972
Member
Norway
2022-03-15
374

Re: Gateway Timeout

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)


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#4 2023-02-04 12:11:24

erAck
Only trying to help
2015-09-06
1998

Re: Gateway Timeout

More likely a PHP timeout, waiting for the database query to finish.


Running Piwigo at https://erack.net/gallery/

Offline

 

#5 2023-02-04 13:50:15

BigIsland270972
Member
Norway
2022-03-15
374

Re: Gateway Timeout

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


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#6 2023-02-04 13:52:48

BigIsland270972
Member
Norway
2022-03-15
374

Offline

 

#7 2023-02-04 14:22:05

BigIsland270972
Member
Norway
2022-03-15
374

Re: Gateway Timeout


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#8 2023-02-04 14:23:33

BigIsland270972
Member
Norway
2022-03-15
374

Re: Gateway Timeout

/etc/my.cnf

[mysqld]
wait_timeout= 28800
optimizer_search_depth = 0
skip-name-resolve


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact