Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029402 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Analytics | major | always | 2015-03-25 13:08 | 2015-06-03 11:06 | |||
| Reporter | jecharri | View Status | public | |||||
| Assigned To | platform | |||||||
| Priority | high | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | egoitz | |||||||
| Regression introduced in release | ||||||||
| Summary | 0029402: Analytics does not work as real time reporting component | |||||||
| Description | Analytics does not work as real time reporting component. The problem is that Analytics is creating locks in database and for example if you are working with Web POS and analytics at the same time Web POS is not going to work and orders are going to finish in "Errors while importing POS data" window | |||||||
| Steps To Reproduce | -Configure background processes "Update Analytics Fact Tables" or "Mondrian Cache Preload" -Verify that in table pg_locks there are a lot of different kind of locks related to above processes This is generating big performance problems if you are executing during working hours and also is creating big problems with Web POS | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0078009) VictorVillar (manager) 2015-06-03 11:06 |
No change required. The locks have dissapeared with the new Postgres 9.3. The new appliances will include this new postgres version. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-03-25 13:08 | jecharri | New Issue | |
| 2015-03-25 13:08 | jecharri | Assigned To | => platform |
| 2015-03-25 13:08 | jecharri | Resolution time | => 1427752800 |
| 2015-04-27 13:24 | jonalegriaesarte | Resolution time | 1427752800 => 1433023200 |
| 2015-05-20 22:19 | dmitry_mezentsev | Priority | immediate => high |
| 2015-06-03 10:38 | ngarcia | Relationship added | related to 0029303 |
| 2015-06-03 11:06 | VictorVillar | Review Assigned To | => egoitz |
| 2015-06-03 11:06 | VictorVillar | Note Added: 0078009 | |
| 2015-06-03 11:06 | VictorVillar | Status | new => closed |
| 2015-06-03 11:06 | VictorVillar | Resolution | open => no change required |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |