Error displayed at production env, yii\web\DbSession, line 184

[pastuhov]

What steps will reproduce the problem?

1. Production
2. Using vendor/yiisoft/yii2/web/DbSession.php
3. Problem with insert statment (Integrity constraint violation: SQLSTATE[23505]: Unique violation: 7 ERROR)

What is the expected result?

Error logged to error log (error_log()) and NO output to browser (no echo())

What do you get instead?

Error displayed

Additional info

Q	A
Yii version	2.0.8
PHP version	7.0.7-1
Operating system	Debian

Go deeper

1. File vendor/yiisoft/yii2/web/DbSession.php
2. Line 184 echo $exception;
3. Why? 😃

[samdark]

It's not possible to move any further with the data provided. How to reproduce it?

[cebe]

please also provide the stack trace of the error

[cebe]

Is your application using on one server or are multiple servers using the same database?

[deadkrolik]

I have the same issue. I just want to disable any errors display on production, but can't do it.

I set YII_DEBUG to false, YII_ENV to prod, created light layout for errors. But can't avoid that message after template is rendered.

[pastuhov]

@samdark & @cebe use mater/slave + time lag or ather problem

[samdark]

@pastuhov do you have master/slave for sessions?

[deadkrolik]

Example to reproduce issue:

1. Add this code to controller's action

\Yii::$app->session->get('azaza');
return;

1. Change user name for database connection.
2. Set YII_DEBUG to false
3. Refresh page

You will get the error Database Exception: SQLSTATE[42000] [1044] Access denied for user 'X'@'localhost' to database 'Y' at the and of page.

Disabling any errors is useful on production server. User shouldn't be able to see such detailed information for security reasons.

[samdark]

I cannot reproduce that:

[samdark]

Ah, indeed it's in the page source.

[samdark]

Fixed. Thanks for helping with reproducing it.