Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Error when you drop sequence vulnnxtid

Description

Running install -dis I got the following exception

vulnnxtid-sequence::seth failed. Error: Error executing SQL DROP SEQUENCE IF EXISTS vulnnxtid: ERROR: syntax error at or near "EXISTS"

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Antonio Russo June 28, 2015 at 11:55 AM

commit 79aaa427eedc09d0d56940b5d8e7487f72992d60
Author: Antonio <rssntn67@yahoo.it>
Date: Sun Jun 28 11:53:56 2015 -0400

https://opennms.atlassian.net/browse/NMS-7764#icft=NMS-7764: Error when you drop sequence vulnnxtid

Remove ";" at the end of ssql fixes the problem

MacBook-Pro-di-Antonio-Russo:opennms antonio$ git push
Counting objects: 61, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (8/8), done.
Writing objects: 100% (9/9), 825 bytes | 0 bytes/s, done.
Total 9 (delta 4), reused 0 (delta 0)
To git@github.com:OpenNMS/opennms.git
f2839c5..79aaa42 develop -> develop

Antonio Russo June 28, 2015 at 11:47 AM

drop the db before running install -dis

Antonio Russo June 28, 2015 at 11:44 AM

I guess you only need to remove ";" from the sql statement

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

PagerDuty

Created June 28, 2015 at 11:41 AM
Updated June 29, 2015 at 2:24 PM
Resolved June 28, 2015 at 11:55 AM

Flag notifications