[Tickets #12998] Re: git HEAD: DB migration fails

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12998
------------------------------------------------------------------------------
  Ticket             | 12998
  Updated By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | git HEAD: DB migration fails
  Queue              | Horde Base
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2014-02-27 10:24) wrote:

I've modified the code that outputs the SQL query error to show a stack trace:

2014-02-27T11:22:20+01:00 ERR: HORDE [horde] SQL STACK TRACE: #0  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php(197):  
PDO->query('CREATE TEMPORAR...')
#1 [internal function]: Horde_Db_Adapter_Pdo_Base->execute('CREATE  
TEMPORAR...', NULL, NULL)
#2  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Sqlite.php(182):  
call_user_func_array(Array, Array)
#3  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Sqlite.php(134):  
Horde_Db_Adapter_Pdo_Sqlite->_catchSchemaChanges('execute', Array)
#4 [internal function]: Horde_Db_Adapter_Pdo_Sqlite->execute('CREATE  
TEMPORAR...')
#5  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/Schema.php(166):  
call_user_func_array(Array, Array)
#6  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/Schema.php(569):  
Horde_Db_Adapter_Base_Schema->__call('execute', Array)
#7  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/Schema.php(569):  
Horde_Db_Adapter_Sqlite_Schema->execute('CREATE TEMPORAR...')
#8  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/TableDefinition.php(203):  
Horde_Db_Adapter_Base_Schema->endTable(Object(Horde_Db_Adapter_Base_TableDefinition))
#9  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(624):  
Horde_Db_Adapter_Base_TableDefinition->end()
#10  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(557): Horde_Db_Adapter_Sqlite_Schema->_copyTable('turba_shares', 'altered_turba_s...', Array,  
NULL)
#11  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(529): Horde_Db_Adapter_Sqlite_Schema->_moveTable('turba_shares', 'altered_turba_s...',  
Array)
#12  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(308): Horde_Db_Adapter_Sqlite_Schema->_alterTable('turba_shares', Array,  
'?lambda_1')
#13 [internal function]:  
Horde_Db_Adapter_Sqlite_Schema->changeColumn('turba_shares',  
'share_parents', 'string', Array)
#14  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base.php(255):  
call_user_func_array(Array, Array)
#15 [internal function]: Horde_Db_Adapter_Base->__call('changeColumn', Array)
#16 [internal function]:  
Horde_Db_Adapter_Pdo_Sqlite->changeColumn('turba_shares',  
'share_parents', 'string', Array)
#17  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Base.php(86):  
call_user_func_array(Array, Array)
#18  
/datastore/DEVEL/horde/turba/migration/11_turba_upgrade_parents.php(31):  
Horde_Db_Migration_Base->__call('changeColumn', Array)
#19  
/datastore/DEVEL/horde/turba/migration/11_turba_upgrade_parents.php(31):  
TurbaUpgradeParents->changeColumn('turba_shares', 'share_parents',  
'string', Array)
#20  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Base.php(121):  
TurbaUpgradeParents->up()
#21  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Migrator.php(182):  
Horde_Db_Migration_Base->migrate('up')
#22  
/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Migrator.php(102):  
Horde_Db_Migration_Migrator->_doMigrate()
#23 /datastore/DEVEL/horde/horde/admin/config/index.php(126):  
Horde_Db_Migration_Migrator->up()
#24 {main}
         CREATE TEMPORARY TABLE "altered_turba_shares" ( "share_id" INTEGER
           PRIMARY KEY AUTOINCREMENT NOT NULL(I, I) NOT NULL, "share_name"
           varchar(255) NOT NULL, "share_owner" varchar(255) NOT NULL,
           "share_flags" int NOT NULL DEFAULT 0, "perm_creator" int NOT NULL
           DEFAULT 0, "perm_default" int NOT NULL DEFAULT 0,  
"perm_guest" int NOT
           NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL,
           "attribute_desc" varchar(255), "attribute_params" text,
           "share_parents" text )  [pid 5590 on line 201 of  
"/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"]