History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: OX-3651
Type: Bug Bug
Status: Needs Verification Needs Verification
Priority: Critical Critical
Assignee: Unassigned-Adserver
Reporter: Arlen Coupland
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
OpenX Ad Server

UPGRADE FAILED: tables_core_538, error adding constraint zone_id_date_time

Created: 29/Jul/08 12:44 PM   Updated: 11/Sep/09 05:54 PM
Component/s: OXP: Installation & Upgrade System
Affects Version/s: OpenX 2.6.0
Fix Version/s: None
Security Level: Public (All users can see these issues)

Time Tracking:
Not Specified


 Description  « Hide
http://forum.openx.org/index.php?showtopic=503420921
Ignoring reports of integrity issues, the main cause on this seems to be failure to create an index on date_time

There is also failure to rollback due to: failed to drop table: tables_core:537:phpads_audit (needs a ticket?)

This is the content of the openads_upgrade_2.5.42_2008_07_23_04_32_43.log ::

2008-07-23 04:32:43
to version: 538
timing: constructive
schema file found: /home/public_html/ads/etc/changes/schema_tables_core_538.xml
schema definition from cache TRUE
successfully parsed the schema
schema name: openads
schema version: 538
schema status: final
changeset definition from cache TRUE
successfully parsed the changeset
changeset name: openads
changeset version: 538
changeset comments: Timezone support
schema and changeset versions match
constructive changes found
destructive changes found
migration file found: /home/public_html/ads/etc/changes/migration_tables_core_538.php
migration class Migration_538 instantiated
target database: ********
table prefix: phpads_
successfully initialised DB Upgrade
verifying constructive changes
verifying/creating constructive tasklist
checking field: phpads_data_intermediate_ad date_time
task found: doAddField__data_intermediate_ad__date_time
checking field: phpads_data_summary_ad_hourly date_time
task found: doAddField__data_summary_ad_hourly__date_time
task found: doAddIndex__data_intermediate_ad__ad_id_date_time
task found: doAddIndex__data_intermediate_ad__zone_id_date_time
task found: doAddIndex__data_intermediate_ad__date_time
task found: doAddIndex__data_intermediate_ad__interval_start
task found: doAddIndex__data_summary_ad_hourly__date_time
task found: doAddIndex__data_summary_ad_hourly__ad_id_date_time
task found: doAddIndex__data_summary_ad_hourly__zone_id_date_time
executing constructive tasks
executing task 0 : phpads_data_intermediate_ad => alter
successfully altered table phpads_data_intermediate_ad
executing task 1 : phpads_data_summary_ad_hourly => alter
successfully altered table phpads_data_summary_ad_hourly
success creating index phpads_data_intermediate_ad_ad_id_date_time on table phpads_data_intermediate_ad
success creating index phpads_data_intermediate_ad_zone_id_date_time on table phpads_data_intermediate_ad
success creating index phpads_data_intermediate_ad_date_time on table phpads_data_intermediate_ad
success creating index phpads_data_intermediate_ad_interval_start on table phpads_data_intermediate_ad
success creating index phpads_data_summary_ad_hourly_date_time on table phpads_data_summary_ad_hourly
success creating index phpads_data_summary_ad_hourly_ad_id_date_time on table phpads_data_summary_ad_hourly
#! error creating index phpads_data_summary_ad_hourly_zone_id_date_time on table phpads_data_summary_ad_hourly _doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE INDEX phpads_data_summary_ad_hourly_zone_id_date_time ON phpads_data_summary_ad_hourly (zone_id, date_time)]
[Native code: 1072]
[Native message: Key column 'date_time' doesn't exist in table]

#! error adding constraint zone_id_date_time
#! UPGRADE FAILED: tables_core_538
to version: 538
timing: destructive
target database: **********
table prefix: phpads_
successfully initialised DB Upgrade
verifying destructive changes
verifying/creating destructive tasklist
#! TASKLIST CREATION FAILED: tables_core_538
#! Failure while upgrading schemas


 All   Comments   Work Log   Change History   FishEye   Crucible   Builds      Sort Order: Ascending order - Click to sort in descending order
Error communicating with FishEye: java.io.IOException: https://developer.openx.org/fisheye/api/rest/query returned 503 Service Temporarily Unavailable