504 Error When Trying to Access Tab 2.2 in WPSolr Admin

  • cbarwin
    Participant
    12 months ago #28474

    I’m getting a 504 Error when I’m trying to access Tab 2.2 in the WPSolr admin area of my WordPress website.
    This is the Define Your Search > Data screen.
    I have hundreds of thousands of products with lots of metadata. Could this be why this issue is occurring?

    Thanks.

    wpsolr
    Keymaster
    12 months ago #28475

    Probably.
    This page is gathering all custom fields with a group by from the wp_postmeta.
    If this table is huge, the SQL query can overwhelm the SQL server resources.

    cbarwin
    Participant
    12 months ago #28477

    Do you have any suggestions for how I might go about accessing the page? In theory, what would allow me to access it? More server resources? Do you think it’s timing out in AWS, or something with my server environment? Anything I could do to manually write the options into the database?

    Thanks for any direction you could give me.

    wpsolr
    Keymaster
    12 months ago #28478

    Increasing the timeout session time on your Web server/Load balancer could solve the 504 error.

    https://docs.aws.amazon.com/elasticloadbalancing/latest/classic/ts-elb-error-message.html

    tientq
    Participant
    7 months ago #29666

    find class-wpsolr-model-meta-type-post.php and add query limit to 50

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.