[go: nahoru, domu]

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Error in processing request" red box on start. #13092

Closed
ethaniel opened this issue Mar 17, 2017 · 12 comments
Closed

"Error in processing request" red box on start. #13092

ethaniel opened this issue Mar 17, 2017 · 12 comments
Assignees
Labels
Bug A problem or regression with an existing feature
Milestone

Comments

@ethaniel
Copy link

Steps to reproduce

  1. Open main page.

Expected behaviour

No errors.

Actual behaviour

image

My debugger shows a 500 error when a POST request is sent to /db_structure.php?ajax_request=1&favorite_table=1&sync_favorite_tables=1
image

What's weird is when I do a normal GET request to that URL, I receive a response (and not a 500 error).

My php error logs are empty.

Any ideas?

Server configuration

Operating system:
Centos 6.7

Web server:
nginx

Database:
percona

PHP version:
5.6.30

phpMyAdmin version:
4.7.0-rc1

Client configuration

Browser:
Chrome

Operating system:
Mac OSX

@ethaniel
Copy link
Author

The problem went away when I installed the phpmyadmin storage database. But still, this error is confusing and I think it should not appear on a fresh installation.

@ibennetch
Copy link
Member
ibennetch commented Mar 17, 2017 via email

@nijel
Copy link
Contributor
nijel commented Mar 20, 2017

Can you please look to web server error logs to see what has caused the error?

@nijel
Copy link
Contributor
nijel commented Mar 20, 2017

I probably found where the problem is, but still having that confirmed would be nice...

@nijel nijel self-assigned this Mar 20, 2017
@nijel nijel added the Bug A problem or regression with an existing feature label Mar 20, 2017
@nijel nijel added this to the 4.7.0 milestone Mar 20, 2017
@ethaniel
Copy link
Author

Looks like phpMyAdmin has taken over the logging. I don't see any errors in my syslog (which php is configured to log by default).

@nijel nijel closed this as completed in cb691fa Mar 20, 2017
@nijel
Copy link
Contributor
nijel commented Mar 20, 2017

phpMyAdmin does not configure this, so it's most likely the PHP is not configured to do so (eg. if using fpm, you need to enable catch_workers_output to get useful logging from PHP).

@ethaniel
Copy link
Author

@nijel I added catch_workers_output to fpm, and it started giving me extra logs from my other systems. But none from phpMyAdmin.

I just upgraded to 4.7.0 and still see the dreaded error. Sometimes I get a "token mismatch" error.

I suppose that 500 Internal Server Error is coming from phpMyAdmin itself and not fpm.

Is it possible?

@nijel
Copy link
Contributor
nijel commented May 15, 2017

No, phpMyAdmin AFAIK does not return 500 on it's own, so it has to come from PHP or web server...

@ethaniel
Copy link
Author

@nijel guess what? phpMyAdmin does return 500 errors on it's own.

I managed to debug the XHR request and here's what I got:

<h1>phpMyAdmin - Error</h1>
<p>Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.<br /><br />session_start(): Failed to decode session object. Session has been destroyed</p>

@ethaniel
Copy link
Author

@nijel that means that phpMyAdmin takes over the errors and they don't hit my regular logging system. And the biggest problem is that if an error happens during an ajax request, there is no way of finding out which error it is without using special tools to check the reply.

I think this is a major problem that needs to be looked into.

@nijel
Copy link
Contributor
nijel commented May 23, 2017

Indeed it should properly report json in this case.

@nijel nijel reopened this May 23, 2017
@nijel nijel modified the milestones: 4.7.2, 4.7.0 Jun 8, 2017
@nijel
Copy link
Contributor
nijel commented Jun 8, 2017

This seems to be caused by fix for #12810...

@nijel nijel closed this as completed in f4ae5f0 Jun 8, 2017
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 22, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Bug A problem or regression with an existing feature
Projects
None yet
Development

No branches or pull requests

3 participants