[Spce-user] Script ngcp-reset-db need to be fixed

[Marco Teixeira]

Hello,

Trying to re-initialize the database for a 4.5.6 CE box, upgraded from 4.1,
and failing with the following errors:
===
Applying revision script
/usr/share/ngcp-db-schema/db_scripts/diff/15151_not_replicated.up: ERROR
1007 (HY000) at line 7: Can't create database 'stats'; database exists
failed. :(
Please resolve the problem and run ngcp-update-db-schema again.
=
==

Manually deleted that table and re-run, yields another error:

===
Applying revision script
/usr/share/ngcp-db-schema/db_scripts/diff/15255.up: done
Applying revision script
/usr/share/ngcp-db-schema/db_scripts/diff/15256_not_replicated.up: ERROR
1007 (HY000) at line 3: Can't create database 'rtcengine'; database exists
failed. :(
Please resolve the problem and run ngcp-update-db-schema again.
===

Manually deleted that table and re-run, yields another error:


===
Applying revision script
/usr/share/ngcp-db-schema/db_scripts/diff/15268.up: done
Applying revision script
/usr/share/ngcp-db-schema/db_scripts/diff/15269_not_replicated.up: ERROR
1007 (HY000) at line 3: Can't create database 'fileshare'; database exists
failed. :(
===

And finally, it worked. That script needs a review...

​
---
Best regards
Marco
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20171025/e2dcfabc/attachment.html>