Upgrading database stuck at 91%

[scosaunders]

I am trying to upgrade from version 2.2.11 to 2.2.12. It gets stuck at step three. The current system is running Ubuntu 7.04, php 5.2.1, and mysql 5.0.38. This problem seemed similar to this older post: http://forums.timetrex.com/viewtopic.ph ... ht=upgrade, but dropping the db and then restoring it from backup did not make any difference for me. This is what is found in the iframe when debug verbosity level is set to 11:

(mysqlt): SHOW TABLES

91 %
(mysqlt): SET AUTOCOMMIT=0 (mysqlt): BEGIN (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_T' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A' (mysqlt): SHOW TABLES (mysqlt): select * from system_setting where name = 'schema_version_group_A'

I don't see any errors myself and am stumped on what the problem here is. I appreciate any help you can send my way. From what I've read I may decide to go with a postgres db but I'd like to be able to run a successful upgrade with this current install if possible. thx

[shaunw]

Are you sure you got all the debug information? There should be several pages worth. Sometimes you may have to right click near the graph and view source, then copy and paste that entire page to get all the debug text. The error will be right at the bottom.

[scosaunders]

I've checked 3 times. It has always been this. I even let it run overnight. This is the last there is on that page frame source:
<hr />

<script type="text/javascript">self.setprogress("p_7377b6_",9,"91 %",0); </script><hr />
(mysqlt): SHOW TABLES &nbsp;
<hr />
<hr />
(mysqlt):
select *
from system_setting
where name = 'schema_version_group_A'
&nbsp;
<hr />

no errors.

[scosaunders]

http://myhostname/timetrex_standard_2.2 ... installer=
This is the last path shown in the address bar. Should external_installer have a value assigned it?

[scosaunders]

Ok, I just tried a new install of timetrex version 2.2.11 this time with postgresql as the selected choice of database. when i went to do the upgrade to version 2.2.12 the behavior was exactly the same - stuck at 91% during the database upgrade. Something interesting to notice here was that the page is not still loading - it shows 'Done' in the status bar. For this step during the install (before the upgrade naturally) I recall seeing the page continue to load as the progress bar progressed until it reached 100% and then forwarded onto the next page. Anyway here is the frame output after uncommenting the debug line in DatabaseSchema.php:

(postgres7): select datname from pg_database where datname not in ('template0','template1') order by 1 (postgres7): select version() (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema')

91 %
(postgres7): select datname from pg_database where datname not in ('template0','template1') order by 1 (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_T') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ] (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): select * from system_setting where name = ? [ (name=>'schema_version_group_A') ]

nothing more, nothing less, that's all that is there. I also just tried dumping the database and restoring from my backup with the same results. Any help? I am lost as to what might be causing this and it doesn't look like anyone else has had this exact behavior.

[scosaunders]

using postgresql version 8.2.6

[scosaunders]

Ok Shaun, it appears I made the mistake of only setting the verbosity level to 11 in DatabaseSchema.php and not in the timetrex.ini.php file. After setting the verbosity to 11 there, these warnings appeared after all the stuff I posted earlier from the iframe.

Warning: InstallSchema::include_once(/var/www/default/timetrex_pg/classes/modules/core/../../..//classes/modules/install/InstallSchema_1024A.class.php) [function.InstallSchema-include-once]: failed to open stream: Permission denied in /var/www/default/timetrex_pg/classes/modules/install/InstallSchema.class.php on line 51

Warning: InstallSchema::include_once() [function.include]: Failed opening '/var/www/default/timetrex_pg/classes/modules/core/../../..//classes/modules/install/InstallSchema_1024A.class.php' for inclusion (include_path='/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/core:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/pear:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/company:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/users:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/punch:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/schedule:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/department:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/help:/var/www/default/timetrex_pg/classes/modules/core/../../../classes/modules/client:/var/www/default/timetrex_pg/classes/modules/core/../. in /var/www/default/timetrex_pg/classes/modules/install/InstallSchema.class.php on line 51

Fatal error: Class 'InstallSchema_1024A' not found in /var/www/default/timetrex_pg/classes/modules/install/InstallSchema.class.php on line 55

So, when i looked in the classes/modules/install folder, InstallSchema_1024A.class.php and InstallSchema_1025A.class.php where not owned by www-data which is odd because when I moved everything to this new timetrex location I did a recursive chown. I can only guess that when moving the version 2.2.12 files I neglected to do the same recursive chown and any new files would result in permission denied. Anyway after applying ownership of all files to the correct web server user the install went smoothly without any problems. Everything looks good.

Quick question about this note given at upgrade time:
NOTE: In order to access new features you may need to re-apply the Administrator permission preset to each administrator employee in TimeTrex.
This is a little unclear to me but by 're-apply' might this mean set them to a regular employee and then back to administrator?

[shaunw]

That re-apply permission preset means going into the Permission Groups, editing the Administrator group, selecting the Administrator Preset and applying that again to the Administrator Group.

You don't need to worry about it for minor version upgrades though.