Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

While performing an insert update query, I received the error message could not generate a new key… the range is too small, what should I do?

April 26, 2017Error insert key message Performing query received

0

10 Posted

While performing an insert update query, I received the error message could not generate a new key… the range is too small, what should I do?

1 Answer

0

10 Posted

The node keys in Timber are doubles. This allows Timber to insert a new node by assigning a key that lies between the two existing node keys. Unfortunately, after many updates, the available space (due to the precision of the doubles — which is worse with larger numbers) may be exhausted. In this case, the update query will be aborted, and the device is left unchanged. Currently, Timber does not support renumbering of keys on the fly and the device (and indices) will need to be recreated if this error message occurs during a required insert query. Unfortunatley, the easiest way to do this is to dump the (Timber) device to an XML file and reload it (and any indices).