Menu
▾
▴
postgres-xc-developers
|
From: Afonso B. <aag...@gm...> - 2013-08-01 09:14:39
|
Dear friends, I´d like to ask your help once again to continue the installation of Moodle, I just created the database in all nodes successfully. But In moodle installation got this error message: *Debug info:* ERROR: Cannot create index whose evaluation cannot be enforced to remote nodes CREATE UNIQUE INDEX mdl_conf_nam_uix ON mdl_config (name) Error code: ddlexecuteerror *Stack trace:* - line 432 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown - line 248 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end() - line 646 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end() - line 88 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure() - line 77 of /lib/ddl/database_manager.php: call to database_manager->execute_sql() - line 415 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr() - line 367 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure() - line 1428 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file() - line 180 of /admin/index.php: call to install_core() Can you help me? Best Regards |
|
From: Michael P. <mic...@gm...> - 2013-08-01 23:52:00
|
On Thu, Aug 1, 2013 at 6:14 PM, Afonso Bione <aag...@gm...> wrote: > Dear friends, > > I´d like to ask your help once again to continue the installation of > Moodle, > I just created the database in all nodes successfully. But In moodle > installation got this error message: > > *Debug info:* ERROR: Cannot create index whose evaluation cannot be > enforced to remote nodes > CREATE UNIQUE INDEX mdl_conf_nam_uix ON mdl_config (name) > Change the distribution of your table. In XC, a unique index evaluation needs to be done at the Datanode level and cannot be done on Coordinators. So in this case, you need either to change mdl_conf_nam_uix to a replicated table (in this case you impact performance, but create all kinds of indexes), or have its distribution key set up as "name" to be sure that the uniqueness of a given column value is evaluated on a single remote Datanode. -- Michael |
|
From: Tomasz S. <str...@gm...> - 2013-08-01 09:45:25
|
Hi, Is there chance to create "save point" functionality?. Now this is very important for me, because i can't use postgres xc without this functionality. Regards |
|
From: Michael P. <mic...@gm...> - 2013-08-02 00:23:12
|
On Thu, Aug 1, 2013 at 6:45 PM, Tomasz Straszewski < str...@gm...> wrote: > Is there chance to create "save point" functionality?. Now this is very > important for me, because i can't use postgres xc without this > functionality. > It shouldn't be that hard to implement, just that this projects lacks active developers (who perhaps themselves lack time...) that could spend time on it. I recall that the priority for this feature very not that high, but this can evolve based on demand. Regards, -- Michael |
|
From: 鈴木 幸市 <ko...@in...> - 2013-08-02 01:36:43
|
Yes. We had similar ML thread on this. Implementation will not be too tough so I'm curious about the use case and how serious it is. Regards; --- Koichi Suzuki On 2013/08/02, at 9:23, Michael Paquier <mic...@gm...> wrote: > > > > On Thu, Aug 1, 2013 at 6:45 PM, Tomasz Straszewski <str...@gm...> wrote: > Is there chance to create "save point" functionality?. Now this is very > important for me, because i can't use postgres xc without this > functionality. > It shouldn't be that hard to implement, just that this projects lacks active developers (who perhaps themselves lack time...) that could spend time on it. I recall that the priority for this feature very not that high, but this can evolve based on demand. > > Regards, > -- > Michael > ------------------------------------------------------------------------------ > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk_______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers |
|
From: Tomasz S. <str...@gm...> - 2013-08-02 06:35:32
|
Hi, I am working with alfresco system and i want postgresxc as database to increase performence. Alfresco use funcionality "save point" when is working with database and i don't want interfere in source code because much modules and core use this funcionality. Regards W dniu 2013-08-02 03:36, 鈴木 幸市 pisze: > Yes. > > We had similar ML thread on this. Implementation will not be too > tough so I'm curious about the use case and how serious it is. > > Regards; > --- > Koichi Suzuki > > On 2013/08/02, at 9:23, Michael Paquier <mic...@gm... > <mailto:mic...@gm...>> wrote: > >> >> >> >> On Thu, Aug 1, 2013 at 6:45 PM, Tomasz Straszewski >> <str...@gm... <mailto:str...@gm...>> >> wrote: >> >> Is there chance to create "save point" functionality?. Now this >> is very >> important for me, because i can't use postgres xc without this >> functionality. >> >> It shouldn't be that hard to implement, just that this projects lacks >> active developers (who perhaps themselves lack time...) that could >> spend time on it. I recall that the priority for this feature very >> not that high, but this can evolve based on demand. >> >> Regards, >> -- >> Michael >> ------------------------------------------------------------------------------ >> Get your SQL database under version control now! >> Version control is standard for application code, but databases havent >> caught up. So what steps can you take to put your SQL databases under >> version control? Why should you start doing it? Read more to find out. >> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk_______________________________________________ >> Postgres-xc-developers mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers > |
|
From: Nikhil S. <ni...@st...> - 2013-08-02 13:18:33
|
Typical systems have configuration parameters to enable/disable the use of savepoints. Like in Django, AFAIR, it also uses savepoints by default, but then you can turn if off via a configuration parameter. Regards, Nikhils On Fri, Aug 2, 2013 at 12:05 PM, Tomasz Straszewski < str...@gm...> wrote: > Hi, > > I am working with alfresco system and i want postgresxc as database to > increase performence. Alfresco use funcionality "save point" when is > working with database and i don't want interfere in source code because > much modules and core use this funcionality. > > Regards > > W dniu 2013-08-02 03:36, 鈴木 幸市 pisze: > > Yes. > > We had similar ML thread on this. Implementation will not be too tough > so I'm curious about the use case and how serious it is. > > Regards; > --- > Koichi Suzuki > > On 2013/08/02, at 9:23, Michael Paquier <mic...@gm...> > wrote: > > > > > On Thu, Aug 1, 2013 at 6:45 PM, Tomasz Straszewski < > str...@gm...> wrote: > >> Is there chance to create "save point" functionality?. Now this is very >> important for me, because i can't use postgres xc without this >> functionality. >> > It shouldn't be that hard to implement, just that this projects lacks > active developers (who perhaps themselves lack time...) that could spend > time on it. I recall that the priority for this feature very not that high, > but this can evolve based on demand. > > Regards, > -- > Michael > > ------------------------------------------------------------------------------ > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk_______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers > > > > > > ------------------------------------------------------------------------------ > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers > > -- StormDB - http://www.stormdb.com The Database Cloud |
|
From: Tomasz S. <str...@gm...> - 2013-08-02 18:09:19
|
Hi, Thanks for your response. I know that but alfresco doesn't have that capability... Regards Tomek W dniu 2013-08-02 15:18, Nikhil Sontakke pisze: > Typical systems have configuration parameters to enable/disable the > use of savepoints. > > Like in Django, AFAIR, it also uses savepoints by default, but then > you can turn if off via a configuration parameter. > > Regards, > Nikhils > > On Fri, Aug 2, 2013 at 12:05 PM, Tomasz Straszewski > <str...@gm... <mailto:str...@gm...>> > wrote: > > Hi, > > I am working with alfresco system and i want postgresxc as > database to increase performence. Alfresco use funcionality "save > point" when is working with database and i don't want interfere in > source code because much modules and core use this funcionality. > > Regards > > W dniu 2013-08-02 03:36, 鈴木 幸市 pisze: >> Yes. >> >> We had similar ML thread on this. Implementation will not be too >> tough so I'm curious about the use case and how serious it is. >> >> Regards; >> --- >> Koichi Suzuki >> >> On 2013/08/02, at 9:23, Michael Paquier >> <mic...@gm... <mailto:mic...@gm...>> wrote: >> >>> >>> >>> >>> On Thu, Aug 1, 2013 at 6:45 PM, Tomasz Straszewski >>> <str...@gm... >>> <mailto:str...@gm...>> wrote: >>> >>> Is there chance to create "save point" functionality?. Now >>> this is very >>> important for me, because i can't use postgres xc without this >>> functionality. >>> >>> It shouldn't be that hard to implement, just that this projects >>> lacks active developers (who perhaps themselves lack time...) >>> that could spend time on it. I recall that the priority for this >>> feature very not that high, but this can evolve based on demand. >>> >>> Regards, >>> -- >>> Michael >>> ------------------------------------------------------------------------------ >>> Get your SQL database under version control now! >>> Version control is standard for application code, but databases >>> havent >>> caught up. So what steps can you take to put your SQL databases >>> under >>> version control? Why should you start doing it? Read more to >>> find out. >>> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk_______________________________________________ >>> Postgres-xc-developers mailing list >>> Pos...@li... >>> <mailto:Pos...@li...> >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers >> > > > ------------------------------------------------------------------------------ > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > <mailto:Pos...@li...> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers > > > > > -- > StormDB - http://www.stormdb.com > The Database Cloud |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X