by scopor » Wed Jun 18, 2014 9:00 am
Thank you DomeDan. The server is online. I tried upgrading another Vicibox and I was able to get past the issue. So I will double check whether a firewall rule is blocking the upgrade. I saw quite a few errors while doing the sql 2.4 and 2.6 upgrade so I am not sure if I missed something or whether the error is normal.
de_2.6.sql': Table 'vicidial_dial_log_archive' already exists
ERROR 1061 (42000) at line 65 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'vddla'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 73 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'voicemail_greeting'
ERROR 1060 (42S21) at line 75 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'voicemail_greeting'
ERROR 1060 (42S21) at line 77 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'allow_voicemail_greeting'
ERROR 1060 (42S21) at line 78 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'audio_store_purge'
ERROR 1060 (42S21) at line 80 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'audio_store_purge'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 84 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'svn_revision'
ERROR 1060 (42S21) at line 86 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'svn_revision'
ERROR 1060 (42S21) at line 87 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'svn_info'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 91 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'pause_after_next_call'
ERROR 1060 (42S21) at line 92 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'owner_populate'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1050 (42S01) at line 96 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_qc_agent_log' already exists
ERROR 1050 (42S01) at line 119 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_comments' already exists
ERROR 1050 (42S01) at line 136 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_configuration' already exists
ERROR 1050 (42S01) at line 143 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_lists_custom' already exists
ERROR 1060 (42S21) at line 150 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'qc_result_type'
ERROR 1062 (23000) at line 152 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCPASS' for key 'PRIMARY'
ERROR 1062 (23000) at line 153 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCFAIL' for key 'PRIMARY'
ERROR 1062 (23000) at line 154 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCCANCEL' for key 'PRIMARY'
ERROR 1062 (23000) at line 156 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCFAIL' for key 'PRIMARY'
ERROR 1062 (23000) at line 158 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'qc_database_version' for key 'name'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 165 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'queuemetrics_socket'
ERROR 1060 (42S21) at line 166 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'queuemetrics_socket_url'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1050 (42S01) at line 170 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_call_time_holidays' already exists
ERROR 1060 (42S21) at line 182 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'ct_holidays'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 187 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'expiration_date'
ERROR 1060 (42S21) at line 189 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'use_other_campaign_dnc'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 193 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'enhanced_disconnect_logging'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1050 (42S01) at line 203 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_email_list' already exists
ERROR 1050 (42S01) at line 230 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_email_accounts' already exists
ERROR 1050 (42S01) at line 253 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'inbound_email_attachments' already exists
ERROR 1050 (42S01) at line 266 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_email_log' already exists
ERROR 1060 (42S21) at line 281 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'allow_emails'
ERROR 1060 (42S21) at line 283 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'allow_emails'
ERROR 1060 (42S21) at line 285 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'group_handling'
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1060 (42S21) at line 288 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'agentcall_email'
ERROR 1060 (42S21) at line 289 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'modify_email_accounts'
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1061 (42000) at line 295 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'pvmid'
ERROR 1061 (42000) at line 296 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'pdpn'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 300 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'content_transfer_encoding'
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1060 (42S21) at line 308 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'amd_inbound_group'
ERROR 1060 (42S21) at line 309 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'amd_callmenu'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 313 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'level_8_disable_add'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 317 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 318 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 319 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1060 (42S21) at line 320 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1060 (42S21) at line 321 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'uniqueid'
ERROR 1060 (42S21) at line 322 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'uniqueid'
ERROR 1060 (42S21) at line 324 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 325 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 326 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1060 (42S21) at line 327 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1061 (42000) at line 329 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'vddllid'
ERROR 1061 (42000) at line 330 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'vdcllid'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 334 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'caller_code'
ERROR 1060 (42S21) at line 335 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'caller_code'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1050 (42S01) at line 339 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_report_log' already exists
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 356 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'lata_type'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1060 (42S21) at line 360 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'survey_wait_sec'
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Are these errors normal? I read through the upgrade document as well as the svn trunk upgrade post.