[Spce-user] Error while upgrading 5.5.6 to 6.5.2

[Rene Krenn]

Clear the intermediate fee csv uplaod table by

 

truncate billing.billing_fees_raw;

 

then re-run missing cmds from 15424.up, ie.

 

alter table billing_fees_raw

  drop index profsrcdesdirtype_idx,

  add column match_mode enum('regex_longest_pattern', 'regex_longest_match',
'prefix', 'exact_destination') not null default 'regex_longest_pattern', 

  add unique key bfr_srcdestdir_idx (billing_profile_id, type, match_mode,
direction, source, destination),

  add key bfr_destsrcdir_idx (billing_profile_id, type, match_mode,
destination, source, direction);

 

finally, register 15424.up in the db-schema table, then the
"update_db_schema" script should be able to skip/continue.

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von
Greg Chlopowiec
Gesendet: Dienstag, 27. November 2018 05:00
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] Error while upgrading 5.5.6 to 6.5.2

 

 

Upgrading Sipwise version 5.5.6 to 6.5.2 but I'm getting following error:

 

Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/15422.up:
done

Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/15424.up:
ERROR 1062 (23000) at line 16: Duplicate entry '10----.-^212612000000.+$'
for key 'bfr_srcdestdir_idx'

failed. :(

Please resolve the problem and run ngcp-update-db-schema again.

ERROR: the step '2.8/ngcp_update_db_schema' failed, upgrade aborted!

 

Need help in resolving this issue. Thank you in advance for all your help.

 
<https://t.sidekickopen72.com/s1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v
4LGBMN7gr-d6d_VdbW63K6Fl2zlZNzW2c3Mwb1k1H6H0?si=6223741096558592&pi=2d7b636c
-43fc-43f4-a166-b5e860d7751d> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181127/cbb8ba80/attachment-0001.html>