171: APPLICATION ERROR #2503 Upgrading the plugin schema failed in block #0.

(235)
Aaron Montgomery (reporter)
2010-08-06 14:05

Should have included the OS. This is running on a Mac OS X (10.5) installation.

(237)
treeboy (reporter)
2010-08-31 15:12

I meet exactly this on Debian Sid too, with the same versions of Mantis and Source Integration.

If I switch on mysql logging, I can see that it attempts to create the mantis_plugin_Source_repository_table, but doesn't seem to succeed. I do not see it attempt to drop that table,but it does not exist.

If I run the query manually, it works perfectly well.

The Mantis query debugging doesn't show the attempt to create this table.

The mysql log shows:

=== BEGIN LOG
100831 23:07:11 213 Connect mantis@localhost on
                  213 Init DB mantis
                  213 Query SET NAMES UTF8
                  213 Query SELECT *
                                  FROM mantis_user_table
                                  WHERE cookie_string='08f4817c1b925e922e0896f1206bcf692baecce8c4957f718b0e7296008e6757'
                  213 Query SELECT *
                                  FROM mantis_user_pref_table
                                  WHERE user_id=3 AND project_id=0
                  213 Query SHOW TABLES
                  213 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
                  213 Query DELETE FROM mantis_tokens_table WHERE 1283292431 > expiry
                  213 Query SELECT * FROM mantis_tokens_table
                                        WHERE type=5 AND owner=3
                  213 Query SELECT * FROM mantis_tokens_table
                                        WHERE type=4 AND owner=3
                  213 Query SELECT id
                                FROM mantis_tokens_table
                                WHERE id=34 LIMIT 1
                  213 Query UPDATE mantis_tokens_table
                                        SET expiry=1283292731
                                        WHERE id=34
                  213 Query SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
                  213 Query INSERT INTO mantis_plugin_table ( basename, enabled )
                                VALUES ( 'Source', '1' )
                  213 Query SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
                  213 Query select version()
                  213 Query CREATE TABLE mantis_plugin_Source_repository_table (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
type VARCHAR(8) NOT NULL DEFAULT '',
name VARCHAR(128) NOT NULL DEFAULT '',
url VARCHAR(250) DEFAULT '',
info LONGTEXT NOT NULL,
                 PRIMARY KEY (id, type, name)
)DEFAULT CHARSET=utf8
                  213 Query SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent
                                  FROM mantis_project_table p
                                  LEFT JOIN mantis_project_hierarchy_table ph
                                    ON ph.child_id = p.id
                                  WHERE p.enabled = 1
                                  ORDER BY p.name
                  213 Query SELECT DISTINCT p.id, p.name, ph.parent_id
                                          FROM mantis_project_table p
                                          LEFT JOIN mantis_project_hierarchy_table ph
                                            ON ph.child_id = p.id
                                          WHERE p.enabled = 1 AND
                                                 ph.parent_id IS NOT NULL
                                          ORDER BY p.name
                  213 Query UPDATE mantis_user_table
                                  SET last_visit= 1283292431
                                  WHERE id=3
                  213 Quit

=== END LOG

The Mantis query log shows:

=== BEGIN LOG
1 0.0002 database_api.php:105 db_connect()
SET NAMES UTF8
2 0.0007 authentication_api.php:759 auth_is_cookie_valid()
SELECT * FROM mantis_user_table WHERE cookie_string='08f4817c1b925e922e0896f1206bcf692baecce8c4957f718b0e7296008e6757'
3 0.0004 user_pref_api.php:171 user_pref_cache_row()
SELECT * FROM mantis_user_pref_table WHERE user_id=3 AND project_id=0
4 0.0003 config_api.php:124 config_get()
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
5 0.0004 tokens_api.php:263 token_purge_expired()
DELETE FROM mantis_tokens_table WHERE 1283292431 > expiry
6 0.0003 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=3
7 0.0005 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=3
8 0.0003 tokens_api.php:43 token_exists()
SELECT id FROM mantis_tokens_table WHERE id=34
9 0.0003 tokens_api.php:137 token_touch()
UPDATE mantis_tokens_table SET expiry=1283292731 WHERE id=34
10 0.0005 plugin_api.php:529 plugin_is_installed()
SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
11 0.0003 plugin_api.php:556 plugin_install()
INSERT INTO mantis_plugin_table ( basename, enabled ) VALUES ( 'Source', '1' )
12 0.0003 plugin_api.php:529 plugin_is_installed()
SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
13 0.0007 project_hierarchy_api.php:157 project_hierarchy_cache()
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name
14 0.0003 user_api.php:948 user_get_accessible_subprojects()
SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name
15 0.0003 user_api.php:1148 user_update_last_visit()
UPDATE mantis_user_table SET last_visit= 1283292431 WHERE id=3
    0.0058 SQL Queries Total Time
    0.1429 Page Request Total Time

Powered by Mantis Bugtracker
=== END LOG

(238)
treeboy (reporter)
2010-08-31 15:15

I should add that query 12 in the Mantis query log is in red whereas all of the rest are in black.

(241)
hippyjim (reporter)
2010-09-27 11:36

I had this same problem - it was fixed by making sure that the MySQL user mantis uses had sufficient permissions to alter & create tables on the database (allowing the required changes to the DB the plugin needed)

(243)
Aaron Montgomery (reporter)
2010-09-28 06:56

Have played with the permissions. I am still getting the error even when I give the MySQL user mantis all possible permissions. However, I will poke it a few more times to see if some other setting is off.

(283)
Karl Reichert (reporter)
2011-04-07 09:29

This is a duplicate of 162

Please note my comment in this bug for a workaround!

Notes
(235) Aaron Montgomery (reporter) 2010-08-06 14:05	Should have included the OS. This is running on a Mac OS X (10.5) installation.

(237) treeboy (reporter) 2010-08-31 15:12	I meet exactly this on Debian Sid too, with the same versions of Mantis and Source Integration. If I switch on mysql logging, I can see that it attempts to create the mantis_plugin_Source_repository_table, but doesn't seem to succeed. I do not see it attempt to drop that table,but it does not exist. If I run the query manually, it works perfectly well. The Mantis query debugging doesn't show the attempt to create this table. The mysql log shows: === BEGIN LOG 100831 23:07:11 213 Connect mantis@localhost on 213 Init DB mantis 213 Query SET NAMES UTF8 213 Query SELECT * FROM mantis_user_table WHERE cookie_string='08f4817c1b925e922e0896f1206bcf692baecce8c4957f718b0e7296008e6757' 213 Query SELECT * FROM mantis_user_pref_table WHERE user_id=3 AND project_id=0 213 Query SHOW TABLES 213 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 213 Query DELETE FROM mantis_tokens_table WHERE 1283292431 > expiry 213 Query SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=3 213 Query SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=3 213 Query SELECT id FROM mantis_tokens_table WHERE id=34 LIMIT 1 213 Query UPDATE mantis_tokens_table SET expiry=1283292731 WHERE id=34 213 Query SELECT COUNT() FROM mantis_plugin_table WHERE basename='Source' 213 Query INSERT INTO mantis_plugin_table ( basename, enabled ) VALUES ( 'Source', '1' ) 213 Query SELECT COUNT() FROM mantis_plugin_table WHERE basename='Source' 213 Query select version() 213 Query CREATE TABLE mantis_plugin_Source_repository_table ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, type VARCHAR(8) NOT NULL DEFAULT '', name VARCHAR(128) NOT NULL DEFAULT '', url VARCHAR(250) DEFAULT '', info LONGTEXT NOT NULL, PRIMARY KEY (id, type, name) )DEFAULT CHARSET=utf8 213 Query SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name 213 Query SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name 213 Query UPDATE mantis_user_table SET last_visit= 1283292431 WHERE id=3 213 Quit === END LOG The Mantis query log shows: === BEGIN LOG 1 0.0002 database_api.php:105 db_connect() SET NAMES UTF8 2 0.0007 authentication_api.php:759 auth_is_cookie_valid() SELECT * FROM mantis_user_table WHERE cookie_string='08f4817c1b925e922e0896f1206bcf692baecce8c4957f718b0e7296008e6757' 3 0.0004 user_pref_api.php:171 user_pref_cache_row() SELECT * FROM mantis_user_pref_table WHERE user_id=3 AND project_id=0 4 0.0003 config_api.php:124 config_get() SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 5 0.0004 tokens_api.php:263 token_purge_expired() DELETE FROM mantis_tokens_table WHERE 1283292431 > expiry 6 0.0003 tokens_api.php:78 token_get() SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=3 7 0.0005 tokens_api.php:78 token_get() SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=3 8 0.0003 tokens_api.php:43 token_exists() SELECT id FROM mantis_tokens_table WHERE id=34 9 0.0003 tokens_api.php:137 token_touch() UPDATE mantis_tokens_table SET expiry=1283292731 WHERE id=34 10 0.0005 plugin_api.php:529 plugin_is_installed() SELECT COUNT() FROM mantis_plugin_table WHERE basename='Source' 11 0.0003 plugin_api.php:556 plugin_install() INSERT INTO mantis_plugin_table ( basename, enabled ) VALUES ( 'Source', '1' ) 12 0.0003 plugin_api.php:529 plugin_is_installed() SELECT COUNT() FROM mantis_plugin_table WHERE basename='Source' 13 0.0007 project_hierarchy_api.php:157 project_hierarchy_cache() SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name 14 0.0003 user_api.php:948 user_get_accessible_subprojects() SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name 15 0.0003 user_api.php:1148 user_update_last_visit() UPDATE mantis_user_table SET last_visit= 1283292431 WHERE id=3 0.0058 SQL Queries Total Time 0.1429 Page Request Total Time Powered by Mantis Bugtracker === END LOG

(238) treeboy (reporter) 2010-08-31 15:15	I should add that query 12 in the Mantis query log is in red whereas all of the rest are in black.

(241) hippyjim (reporter) 2010-09-27 11:36	I had this same problem - it was fixed by making sure that the MySQL user mantis uses had sufficient permissions to alter & create tables on the database (allowing the required changes to the DB the plugin needed)

(243) Aaron Montgomery (reporter) 2010-09-28 06:56	Have played with the permissions. I am still getting the error even when I give the MySQL user mantis all possible permissions. However, I will poke it a few more times to see if some other setting is off.

(283) Karl Reichert (reporter) 2011-04-07 09:29	This is a duplicate of 162 Please note my comment in this bug for a workaround!

Issue History
Date Modified	Username	Field	Change
2010-08-06 13:59	Aaron Montgomery	New Issue
2010-08-06 14:05	Aaron Montgomery	Note Added: 235
2010-08-31 15:12	treeboy	Note Added: 237
2010-08-31 15:15	treeboy	Note Added: 238
2010-09-27 11:36	hippyjim	Note Added: 241
2010-09-28 06:56	Aaron Montgomery	Note Added: 243
2011-04-07 09:29	Karl Reichert	Note Added: 283

Relationships