ravening opened a new issue #3801: updateIpaddress api for free IP address throws DB exception URL: https://github.com/apache/cloudstack/issues/3801 <!-- Verify first that your issue/request is not already reported on GitHub. Also test if the latest release and master branch are affected too. Always add information AFTER of these HTML comments, but no need to delete the comments. --> ##### ISSUE TYPE <!-- Pick one below and delete the rest --> * Bug Report ##### COMPONENT NAME <!-- Categorize the issue, e.g. API, VR, VPN, UI, etc. --> ~~~ API ~~~ ##### CLOUDSTACK VERSION <!-- New line separated list of affected versions, commit ID for issues on master branch. --> ~~~ 4.14 ~~~ ##### CONFIGURATION <!-- Information about the configuration if relevant, e.g. basic network, advanced networking, etc. N/A otherwise --> ##### OS / ENVIRONMENT <!-- Information about the environment if relevant, N/A otherwise --> OS doesnt matter. It can be either zones with securitygroup enabled or disabled ##### SUMMARY <!-- Explain the problem/feature briefly --> Updating the free IP address in a network throws DB exception as accountid is -1 ##### STEPS TO REPRODUCE <!-- For bugs, show exactly how to reproduce the problem, using a minimal test-case. Use Screenshots if accurate. For new features, show how the feature would be used. --> <!-- Paste example playbooks or commands between quotes below --> ~~~ list publicipaddresses id=7429d851-f572-459e-bbc0-43367d33ca19 listall=true forvirtualnetwork=true allocatedonly=false update ipaddress id=7429d851-f572-459e-bbc0-43367d33ca19 ~~~ <!-- You can also paste gist.github.com links for larger files --> ##### EXPECTED RESULTS <!-- What did you expect to happen when running the steps above? --> ~~~ NO exception should be thrown and update should happen if the values are proper ~~~ ##### ACTUAL RESULTS <!-- What actually happened? --> <!-- Paste verbatim command output between quotes below --> ~~~ Error 530: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@3611d3d0: INSERT INTO event (event.type, event.state, event.description, event.created, event.user_id, event.account_id, event.domain_id, event.level, event.start_id, event.parameters, event.uuid, event.archived, event.display) VALUES (_binary'NET.IPUPDATE', 'Scheduled', _binary'Updating IP address with ID=9', '2020-01-10 15:46:21', 2, -1, 0, _binary'INFO', 0, null, _binary'cebfb803-3315-43f7-b295-690c5019916d', 0, 1) ~~~
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
