Closed vipere closed 11 years ago
Caused by: java.sql.BatchUpdateException: Duplicate entry '-983' for key 'PRIMARY'
That negative number is worrisome. Are you sure the values in the table hibernate_sequences are correct? What is the type of the next_hi_value column?
sequence_next_hi_value is of type int(11) I've set the values using COALESCE(ceil(max(id) / 1000 + 2), 1) so should be good. The values in hibernate_sequences are positive, though the tables themselves have keys ranging from about -1000 to 4000
Feeds started updating again, like in the previous issue #301, and even though the sequence_next_hi_value of FEEDENTRIES was changed from 6 to 1006, new entries are inserted to the FEEDENTRIES table with negative ID's of about -700.
And the error is back, at least now its for a positive value
Caused by: java.sql.BatchUpdateException: Duplicate entry '6' for key 'PRIMARY'
The values were incremented again by 1000. Here's the table:
+---------------------+------------------------+
| sequence_name | sequence_next_hi_value |
+---------------------+------------------------+
| APPLICATIONSETTINGS | 3 |
| FEEDCATEGORIES | 4 |
| FEEDENTRIES | 2006 |
| FEEDENTRYCONTENTS | 2006 |
| FEEDENTRYSTATUSES | 2007 |
| FEEDS | 3 |
| FEEDSUBSCRIPTIONS | 4 |
| USERROLES | 3 |
| USERS | 3 |
| USERSETTINGS | 3 |
+---------------------+------------------------+
I didn't reset 1006 to the correct value since it would just change again..
Having the same issue. Some of my feeds do not update. I am using commafeed.com
Same here.. can we manually update it? :(
This has been brought up before, and I've tried the suggestions but none helped. Running the latest version of commafeed, the feeds stopped updating.
The values in the table hibernate_sequences are set as required, but I noticed that after running commafeed the rows FEEDENTRIES/FEEDENTRYCONTENTS/FEEDENTRYSTATUSES get incremented from say X to 1000+X for some reason.
The log is full of errors like below: