#315 Viewing sites causes a PersistentSet reorder.

version 2.x
closed-fixed
nobody
6
2008-08-01
2008-08-01
Adam Franco
No

When viewing sites, often a PersistentSet (possibly relating to Plugins) has items added. Sometimes multiple requests to the same page by different users can collide leading to a duplicate-key collision.

Backtrace:

# File Line Call
0 MySQLDatabase.class.php 289 MySQLDatabase->_query(String: "INSERT INTO sets (id, item_id, item_order) VALUES ('468880', '468896', '1') ");
1 DBHandler.class.php 276 MySQLDatabase->query(Object: InsertQuery);
2 PersistentOrderedSet.class.php 94 DBHandler->query(Object: InsertQuery, Integer: 0);
3 SeguePluginsDriver.abstract.php 1532 PersistentOrderedSet->addItem(Object: HarmoniId);
4 SeguePluginsDriver.abstract.php 1271 SeguePluginsDriver->_loadData();
5 SeguePluginsDriver.abstract.php 1158 SeguePluginsDriver->setAsset(Object: HarmoniAsset);
6 PluginManager.class.php(375) : eval()'d code 1 SeguePluginsDriver::newInstance(Object: HarmoniAsset, Object: ConfigurationProperties);
7 PluginManager.class.php 375 eval();
8 ViewModeSiteVisitor.class.php 236 PluginManager->getPlugin(Object: HarmoniAsset);
9 ViewModeSiteVisitor.class.php 202 ViewModeSiteVisitor->getPluginContent(Object: AssetBlockSiteComponent);
10 AssetBlockSiteComponent.class.php 246 ViewModeSiteVisitor->visitBlock(Object: AssetBlockSiteComponent);
11 ViewModeSiteVisitor.class.php 627 AssetBlockSiteComponent->acceptVisitor(Object: ViewModeSiteVisitor);
12 AssetFlowOrganizerSiteComponent.class.php 255 ViewModeSiteVisitor->visitFlowOrganizer(Object: AssetFlowOrganizerSiteComponent);
13 ViewModeSiteVisitor.class.php 579 AssetFlowOrganizerSiteComponent->acceptVisitor(Object: ViewModeSiteVisitor);
14 AssetFixedOrganizerSiteComponent.class.php 322 ViewModeSiteVisitor->visitFixedOrganizer(Object: AssetFixedOrganizerSiteComponent);
15 ViewModeSiteVisitor.class.php 579 AssetFixedOrganizerSiteComponent->acceptVisitor(Object: ViewModeSiteVisitor);
16 AssetFixedOrganizerSiteComponent.class.php 322 ViewModeSiteVisitor->visitFixedOrganizer(Object: AssetFixedOrganizerSiteComponent);
17 ViewModeSiteVisitor.class.php 579 AssetFixedOrganizerSiteComponent->acceptVisitor(Object: ViewModeSiteVisitor);
18 ViewModeSiteVisitor.class.php 604 ViewModeSiteVisitor->visitFixedOrganizer(Object: AssetNavOrganizerSiteComponent);
19 AssetNavOrganizerSiteComponent.class.php 51 ViewModeSiteVisitor->visitNavOrganizer(Object: AssetNavOrganizerSiteComponent);
20 ViewModeSiteVisitor.class.php 527 AssetNavOrganizerSiteComponent->acceptVisitor(Object: ViewModeSiteVisitor);
21 AssetSiteNavBlockSiteComponent.class.php 62 ViewModeSiteVisitor->visitSiteNavBlock(Object: AssetSiteNavBlockSiteComponent);
22 html.act.php 213 AssetSiteNavBlockSiteComponent->acceptVisitor(Object: ViewModeSiteVisitor);
23 html.act.php 97 htmlAction->addSiteContent(Object: Container);
24 ClassesActionSource.class.php 115 htmlAction->execute();
25 ActionHandler.class.php 209 ClassesActionSource->executeAction(String: "view", String: "html");
26 ActionHandler.class.php 176 ActionHandler->_execute(String: "view", String: "html");
27 Harmoni.class.php 378 ActionHandler->execute(String: "view", String: "html");
28 index.php 80 Harmoni->execute();
REQUEST_URI: /view/html/node/481280
HTTP_REFERER: https://segue2.middlebury.edu/view/html/node/481252
GET:

Array
(
)

POST:

Array
(
)

HTTP_USER_AGENT:

Opera/9.24 (Macintosh; Intel Mac OS X; U; en)

Discussion

  • Adam Franco

    Adam Franco - 2008-08-01

    Logged In: YES
    user_id=789554
    Originator: YES

    Plugins: Deprecated 'Plugin data-arrays' support as it was causing hundreds
    of excess reordering queries every page load and not being used anyway.

     
  • Adam Franco

    Adam Franco - 2008-08-01
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks