[Tickets #10578] horde-db-migrade doesn't run all scripts
bugs at horde.org
bugs at horde.org
Thu Sep 29 15:40:04 UTC 2011
BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE
E-MAIL-ADRESSE WERDEN NICHT GELESEN.
Ticket-URL: http://bugs.horde.org/ticket/10578
------------------------------------------------------------------------------
Ticket | 10578
Erstellt Von | michael at bigmichi1.de
Zusammenfassung | horde-db-migrade doesn't run all scripts
Warteschlange | Wicked
Version | 1.0-ALPHA1
Typ | Bug
Status | Unconfirmed
Priorität | 2. Medium
Milestone |
Patch |
Zuständige |
------------------------------------------------------------------------------
michael at bigmichi1.de (2011-09-29 15:40) hat geschrieben:
the schema isn't completly created when i try to run horde-db-migrade,
so the adminscreen says everytime schema not up to date and needs to
be run. so i deleted all wicked* tables and run horde-db-migrade from
command line:
root at server:~# /var/www/pear/horde-db-migrate wicked
[ INFO ] Migrating DB up.
[ INFO ] Current wicked schema version: 0
Migrating to WickedBaseTables (1)
== 1 WickedBaseTables: migrating
==============================================
-- tables()
-> 0.0017s
-- createTable(wicked_pages, array(autoincrementKey => false))
-> 0.0071s
-- addIndex(wicked_pages, array(0 => 'page_name'), array(unique => true))
-> 0.1798s
-- createTable(wicked_history, array(autoincrementKey => false))
-> 0.0000s
-- addIndex(wicked_history, array(0 => 'page_name'))
-> 0.0332s
-- addIndex(wicked_history, array(0 => 'page_majorversion', 1 =>
'page_minorversion'))
-> 0.0213s
-- createTable(wicked_attachments, array(autoincrementKey => false))
-> 0.0000s
-- createTable(wicked_attachment_history, array(autoincrementKey => false))
-> 0.0000s
-- addIndex(wicked_attachment_history, array(0 =>
'attachment_majorversion', 1 => 'attachment_minorversion'))
-> 0.0174s
== 1 WickedBaseTables: migrated (0.4735s)
=====================================
Migrating to WickedAutoIncrementPageId (2)
== 2 WickedAutoIncrementPageId: migrating
=====================================
-- changeColumn(wicked_pages, page_id, autoincrementKey)
-> 0.0355s
-- dropTable(wicked_pages_seq)
== 2 WickedAutoIncrementPageId: migrated (0.0848s)
============================
Migrating to WickedUnsignedInts (3)
== 3 WickedUnsignedInts: migrating
============================================
-- changeColumn(wicked_pages, page_id, integer, array(autoincrement =>
true, null => false, unsigned => true))
-> 0.0082s
-- changeColumn(wicked_pages, page_hits, integer, array(default => 0,
unsigned => true))
-> 0.0154s
-- changeColumn(wicked_pages, page_majorversion, integer, array(null
=> false, unsigned => true))
-> 0.0233s
-- changeColumn(wicked_pages, page_minorversion, integer, array(null
=> false, unsigned => true))
-> 0.0162s
-- changeColumn(wicked_pages, version_created, integer, array(null =>
false, unsigned => true))
-> 0.0195s
-- changeColumn(wicked_history, page_id, integer, array(null => false,
unsigned => true))
-> 0.0199s
-- changeColumn(wicked_history, page_majorversion, integer, array(null
=> false, unsigned => true))
-> 0.0144s
-- changeColumn(wicked_history, page_minorversion, integer, array(null
=> false, unsigned => true))
-> 0.0169s
-- changeColumn(wicked_history, version_created, integer, array(null
=> false, unsigned => true))
-> 0.0153s
-- changeColumn(wicked_attachments, page_id, integer, array(null =>
false, unsigned => true))
-> 0.0196s
-- changeColumn(wicked_attachments, attachment_hits, integer,
array(default => 0, unsigned => true))
-> 0.0137s
-- changeColumn(wicked_attachments, attachment_majorversion, integer,
array(null => false, unsigned => true))
-> 0.0169s
-- changeColumn(wicked_attachments, attachment_minorversion, integer,
array(null => false, unsigned => true))
-> 0.0270s
-- changeColumn(wicked_attachments, attachment_created, integer,
array(null => false, unsigned => true))
-> 0.0170s
-- changeColumn(wicked_attachment_history, page_id, integer,
array(null => false, unsigned => true))
-> 0.0475s
-- changeColumn(wicked_attachment_history, attachment_majorversion,
integer, array(null => false, unsigned => true))
-> 0.0321s
-- changeColumn(wicked_attachment_history, attachment_minorversion,
integer, array(null => false, unsigned => true))
-> 0.0158s
-- changeColumn(wicked_attachment_history, attachment_created,
integer, array(null => false, unsigned => true))
-> 0.0276s
== 3 WickedUnsignedInts: migrated (0.3722s)
===================================
Migrating to WickedSingleRevisions (4)
== 4 WickedSingleRevisions: migrating
=========================================
-- removePrimaryKey(wicked_history)
-> 0.0233s
-- addColumn(wicked_pages, page_version, integer, array(null => false))
-> 0.0169s
-- addColumn(wicked_history, page_version, integer, array(null => false))
-> 0.0277s
-- select(SELECT page_id, page_majorversion, page_minorversion FROM
wicked_history ORDER BY page_id, page_majorversion, page_minorversion)
-> 0.0227s
-- update(UPDATE wicked_pages SET page_version = 1 WHERE page_version = 0)
-> 0.0005s
-> 0 rows
-- addPrimaryKey(wicked_history, array(0 => 'page_id', 1 => 'page_version'))
-> 0.0393s
-- removeColumn(wicked_pages, page_majorversion)
-> 0.0261s
-- removeColumn(wicked_pages, page_minorversion)
-> 0.0103s
-- removeColumn(wicked_history, page_majorversion)
-> 0.0467s
-- removeColumn(wicked_history, page_minorversion)
-> 0.0104s
-- removePrimaryKey(wicked_attachment_history)
-> 0.0286s
-- addColumn(wicked_attachments, attachment_version, integer,
array(null => false))
-> 0.0203s
-- addColumn(wicked_attachment_history, attachment_version, integer,
array(null => false))
-> 0.0162s
-- select(SELECT page_id, attachment_name, attachment_majorversion,
attachment_minorversion FROM wicked_attachment_history ORDER BY
page_id, attachment_name, attachment_majorversion,
attachment_minorversion)
-> 0.0000s
-- addLimitOffset(SELECT attachment_version FROM
wicked_attachment_history WHERE page_id = ? AND attachment_name = ?
ORDER BY attachment_version DESC, array(limit => 1))
-> 0.0000s
-- select(SELECT page_id, attachment_name, attachment_majorversion,
attachment_minorversion FROM wicked_attachments)
-> 0.0000s
-- update(UPDATE wicked_attachments SET attachment_version = 1 WHERE
attachment_version = 0)
-> 0.0003s
-> 0 rows
-- addPrimaryKey(wicked_attachment_history, array(0 => 'page_id', 1 =>
'attachment_name', 2 => 'attachment_version'))
-> 0.0382s
-- removeColumn(wicked_attachments, attachment_majorversion)
-> 0.0140s
-- removeColumn(wicked_attachments, attachment_minorversion)
-> 0.0127s
-- removeColumn(wicked_attachment_history, attachment_majorversion)
-> 0.0188s
-- removeColumn(wicked_attachment_history, attachment_minorversion)
-> 0.0200s
== 4 WickedSingleRevisions: migrated (0.4009s)
================================
Migrating to WickedRenamePages (5)
== 5 WickedRenamePages: migrating
=============================================
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/AddingPages'))
-> 0.0007s
-- beginDbTransaction()
-> 0.0002s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/AddingPages', 1 => 'AddingPages'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/AddingPages', 1 => 'AddingPages'))
-> 0.0006s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/Usage'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Usage', 1 => 'HowToUseWiki'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Usage', 1 => 'HowToUseWiki'))
-> 0.0005s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/SandBox'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/SandBox', 1 => 'SandBox'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/SandBox', 1 => 'SandBox'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/Home'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Home', 1 => 'WikiHome'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Home', 1 => 'WikiHome'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/Page'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Page', 1 => 'WikiPage'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Page', 1 => 'WikiPage'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/TextFormat'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/TextFormat', 1 => 'WikiTextFormat'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/TextFormat', 1 => 'WikiTextFormat'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
== 5 WickedRenamePages: migrated (0.0168s)
====================================
[ INFO ] Ending wicked schema version: 5
after that when i run the command again i got:
root at server:~# /var/www/pear/horde-db-migrate wicked
[ INFO ] Migrating DB up.
[ INFO ] Current wicked schema version: 4
Migrating to WickedRenamePages (5)
== 5 WickedRenamePages: migrating
=============================================
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/AddingPages'))
-> 0.0005s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/AddingPages', 1 => 'AddingPages'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/AddingPages', 1 => 'AddingPages'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/Usage'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Usage', 1 => 'HowToUseWiki'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Usage', 1 => 'HowToUseWiki'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/SandBox'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/SandBox', 1 => 'SandBox'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/SandBox', 1 => 'SandBox'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/Home'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Home', 1 => 'WikiHome'))
-> 0.0003s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Home', 1 => 'WikiHome'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/Page'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Page', 1 => 'WikiPage'))
-> 0.0003s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/Page', 1 => 'WikiPage'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
-- selectValue(SELECT 1 FROM wicked_pages WHERE page_name = ?, array(0
=> 'Wiki/TextFormat'))
-> 0.0004s
-- beginDbTransaction()
-> 0.0001s
-- update(UPDATE wicked_pages SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/TextFormat', 1 => 'WikiTextFormat'))
-> 0.0004s
-> 0 rows
-- update(UPDATE wicked_history SET page_name = ? WHERE page_name = ?,
array(0 => 'Wiki/TextFormat', 1 => 'WikiTextFormat'))
-> 0.0004s
-> 0 rows
-- commitDbTransaction()
-> 0.0001s
== 5 WickedRenamePages: migrated (0.0159s)
====================================
[ INFO ] Ending wicked schema version: 5
that i can repeat many many times and nothing changed
More information about the bugs
mailing list