View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000191 | Pgpool-II | Bug | public | 2016-04-13 15:28 | 2016-04-14 10:45 |
| Reporter | alp | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | sometimes |
| Status | assigned | Resolution | open | ||
| Summary | 0000191: pgpool-II shouldn't forward set default_transaction_isolation to 'serializable' to Hot Standby slaves | ||||
| Description | When pgpool is configured as pooler between PostgreSQL master-slave cluster and it receives "set default_transaction_isolation to 'serializable'" , it can forward this statement to hot standby PostgreSQL server. PostgreSQL 9.5 generates the following error message after this: ERROR: 0A000: cannot use serializable mode in a hot standby DETAIL: "default_transaction_isolation" is set to "serializable". HINT: You can use "SET default_transaction_isolation = 'repeatable read'" to change the default. db DB, client IP, user USER LOCATION: GetSerializableTransactionSnapshot, predicate.c:1588 STATEMENT: DISCARD ALL | ||||
| Tags | No tags attached. | ||||
