How to fix network config error

Troubleshooting
1

I have a personal NAS with ASRock C2550D4I motherboard. It got three network jack (one for admin and the other two are regular network). I was toying with network bonding using config files. I gave up on it because the bonded interface only has 100Mb connection. Rockstor now has this error message:

Error!

  update or delete on table "storageadmin_networkconnection"

violates foreign key constraint “connection_id_refs_id_61d432b3” on
table “storageadmin_ethernetconnection"
DETAIL: Key (id)=(1) is still referenced from table
"storageadmin_ethernetconnection”.

    If you need more help on this issue, email us at support@rockstor.com with the following information:
    The error message: "update or delete on table

“storageadmin_networkconnection” violates foreign key constraint
"connection_id_refs_id_61d432b3" on table
"storageadmin_ethernetconnection"
DETAIL: Key (id)=(1) is still referenced from table
"storageadmin_ethernetconnection".
"A step by step description of the actions leading up to the error.Download the tarred and zipped server logs by clicking here, and attach it to the email.

What can I do to clean up the db?

Thanks

2

You may be able to use nmcli to delete the manually added/broken connections.

If you are willing, can you use the web-ui to configure bonding and let us know if you have any feedback. btw, you might want to wait for the 3.8-13.16 update coming up in a few hours. It has a network related fix.

3

Thank you very much. Will try the command

I definitely will try the bonding feature in the new version

4

deleted the connections and rebooted twice, then it worked :slight_smile:
Thanks a lot for your help Suman