Ah. I inserted the row into a different tablespace :-). I will
update dbsetup to add a row for ID 0.
Charles
On Nov 19, 2006, at 11:11 AM, Charles Lee wrote:
> Did you manually insert the row of ID 0 like I did?
>
> Charles
>
>
>
> On Nov 19, 2006, at 8:41 AM, Young Lee wrote:
>
>> Charles,
>>
>> I copied the insert statement a created a xx.sql file. I get a FK
>> violation on parent_id.
>>
>> youngl[hq] $ psql hq<xx.sql
>> ERROR: insert or update on table "eam_alert_definition" violates
>> foreign key constraint "fk97540784cb32abfe"
>> DETAIL: Key (parent_id)=(0) is not present in table
>> "eam_alert_definition".
>>
>> - Young
>>
>> Charles Lee wrote:
>>> I should point out that I had inserted a row of ID 0 manually
>>> when I thought that this might be the case, restarted the server,
>>> and the stacktrace that I sent was after doing all that.
>>>
>>> Charles
>>>
>>>
>>> On Nov 18, 2006, at 11:24 PM, Young Lee wrote:
>>>
>>>> See below
>>>>
>>>> Charles Lee wrote:
>>>>> When I try to create a resource type alert, I get the following
>>>>> stacktrace:
>>>>>
>>>>> 22:45:13,280 WARN [JDBCExceptionReporter] SQL Error: 0,
>>>>> SQLState: null
>>>>> 22:45:13,280 ERROR [JDBCExceptionReporter] Batch entry 0 insert
>>>>> into EAM_ALERT_DEFINITION (VERSION_COL, NAME, CTIME, MTIME,
>>>>> PARENT_ID, DESCRIPTION, PRIORITY, APPDEF_ID, APPDEF_TYPE,
>>>>> ENABLED, FREQUENCY_TYPE, COUNT, RANGE, WILL_RECOVER,
>>>>> NOTIFY_FILTERED, CONTROL_FILTERED, ACT_ON_TRIGGER_ID, DELETED,
>>>>> ID) values (0, 'Platform Available', 1163918713120,
>>>>> 1163918713120, 0, '', 2, 10012, 1, '1', 0, 1, 0, '0', '0', '0',
>>>>> NULL, '0', 10061) was aborted. Call getNextException to see
>>>>> the cause.
>>>>> 22:45:13,281 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
>>>>> 22:45:13,281 ERROR [JDBCExceptionReporter] ERROR: insert or
>>>>> update on table "eam_alert_definition" violates foreign key
>>>>> constraint "fk97540784cb32abfe"
>>>> I believe the stack trace is caused by an attempt to set
>>>> PARENT_ID to 0. Hibernate creates a FK on parent_id now.
>>>>>
>>>>> However, executing the SQL directly works just fine. Any ideas?
>>>>>
>>>>> Also, can we get our sequences to not increment by 10?
>>>> will take care of this.
>>>>>
>>>>> Charles
>>>>>
>>>>>
>>>>>
>>>
>