Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

Progress means replacing a theory that is wrong with one more subtly wrong.

devel / comp.databases.ingres / [Info-ingres] E_DM9387_INDEX_UPDATE_ERROR because of II_TIMEZONE_NAME

SubjectAuthor
o [Info-ingres] E_DM9387_INDEX_UPDATE_ERROR because of II_TIMEZONE_NAMEAdrian Williamson

1
[Info-ingres] E_DM9387_INDEX_UPDATE_ERROR because of II_TIMEZONE_NAME

<mailman.67.1627334113.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=99&group=comp.databases.ingres#99

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!2.eu.feeder.erje.net!feeder.erje.net!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!tr2.eu1.usenetexpress.com!feeder.usenetexpress.com!tr2.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Mon, 26 Jul 2021 16:16:03 -0500
Return-Path: <adrian.williamson@rationalcommerce.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: adrian.williamson@rationalcommerce.com (Adrian Williamson)
To: <info-ingres@lists.planetingres.org>
Date: Mon, 26 Jul 2021 22:15:09 +0100
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AdeCYKCZe2J9tOkVS4Sml2TRptormw==
Content-Language: en-gb
X-Provags-ID: V03:K1:JUQOaPVarqFVsgwpGYo6/Yhs3+UFcgoPdGMTVS8V/SSDAOpRaNA SkUBpPRp6A7RKzZidMJiwt1SCpkKzonsSJlZoPledWssA6PxjiVPypbxWEny4gU4fZIPrGD V+6vnwFSwuEb3XSm1o4dBdwe3NDftSiClb0NyQdWPmjlVasXR7PwA6Ubdc3qgFLVsjWZIuQ FXi6hAYcy13Tr+mZiuyug==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:cZ0dVd/E/uI=:py7BnbpP0x5F0eKhtU7rJF Cs+TJ7hWEUUZhU3xTMxqo4TU6c+0x50oYDjtaSlDFDbB0pMtQSqJGLcHVqyt+31NiUZcCY51d 0X+LWPHqM8poEQRMcw26WtVncKLkFztj13gm1vrN3mvDyX6QRMotue0Ee8UrmFNY2YQzRPo2Y gmUKnIsk2dyQXOXEDovqADw5p7yLvkPEZeBCD6wIjwM41akFy7JtwsPknnEqyUNQB4AxvNgn6 aBSe61J53/RIjb7UvI9MhWUMr9rCO7DbtT2RnXjMuqyo+iCTCsRoZ4yMWNt0TQsiBMk46BAlL rIgzpUlkICZuSQz76CydCUegPvT/dFximDNbPG/JmheoqNIaMLXO8+Z+S8fxF0AQq6XJCEVL3 ONDxBqLElFjkz8fk91q7MGgLsJp8xep3yHfEiMu+XZIBGD2BUNegEZS4p4H3lVxSSvtIQBArE sjpsHJTximWjtm5a61/6GygA8B+0MpHqa0Dv0otczibG4VV5VMX17W5VnHEvTGa8KRmKcsGd8 njeRB2zgrucvYQRZMYrUbDp1IrNSLPpa2WtKmngmfzSDYWP5ANRKLtAiOFM0w/9uiOqhnQcjP SqJer0cuEisgJGidGzS2Q1R3V3Q50p7eAfMZvbXuKCFEc9j5aBVWuU8sbg3wNjvP5nJLbV3XA ST070gvVI17XpzLBrTb5Rc9xwy9SOrV7UXzoM67mAWqfEJOA0nAOKiqIMcLCnd2lO/Tq1Mr1u T6e2RaAN5Vsv8NE86GS2ZPOi+Kpd7XYD7F5OFnVME6NHyJ78Qmv//iXC3CZqy/pGzEwZgkXxb /5UbWXIl25ZYnfDqsrY3O6R9JwjyQBnuo/+UtM8/mkS6+1JIoH8EcmQq0OhbqbztqV5WnHofn BMS4o5N3+ZTsK069991g==
Subject: [Info-ingres] E_DM9387_INDEX_UPDATE_ERROR because of II_TIMEZONE_NAME
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.67.1627334113.1681.info-ingres@lists.planetingres.org>
Lines: 51
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-ngWEEf5BsOE4ZKID9XJNILKFyvcqJnT32A6Gc9+PyWNeJ7qh0W49cSBDkTACk6EFhzVBGp+jSOIU32V!fppWh7Gcvr6ht5yOy1GZAbQA7YICB1cHuIrVGuST2cZrfQkZ699L3ninpjL6isyWgVljJLb0kBG9!73IF/hY/GH1d+CnGFqMIlQ==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 4985
 by: Adrian Williamson - Mon, 26 Jul 2021 21:15 UTC

Hi,

I've this OR6.2 program that deletes data from an Ingres 11 database on the same Windows 2012 R2 host.

As Ingres 11 and OR6.2 don't (or did not ) play nice (Ingres Net issues as far as I recall) they are on separate installations on the host.

For a very specific multi-row (28 rows) delete that looks like this:

Delete from relevant_date where case_id = 700431

The OpenROAD (and the SQL prompt using the same OR6.2 vnode) causes this error when deleting a record:

E_DM0056_NOPART NOPART Btree error.
E_DM9385_NO_INDEX_TUPLE Cannot locate secondary index row for base table row at TID 15373.
E_DM9386_SEC_INDEX_ERROR Error updating secondary index ,relevant_date_idx, for change to base table row at TID 15373.
E_DM9387_INDEX_UPDATE_ERROR Update failed due to inability to update secondary index table.

The relevant_date_idx is a secondary index on a date column in the relevant_date table.

In the OR6.2 installation the II_TIMEZONE_NAME was set to GMT and in Ingres 11 UNITED-KINGDOM

Setting the OR6.2 to UNITED_KINGDOM makes it all work.

The row in question under GMT gives the index column date as '21/10/1999 00:00:00' but under UNITED-KINGDOM looks like '21/10/1999 01:00:00'.

I settle for working, understanding is a luxury that few of my clients are willing to pay for.

But there is a part of me that thinks - "Is that by design that it looks to compare the key values and the TID/TIDP when deleting from the primary table?"

I figured that this is some kind of adult stuff that us kiddies just don’t get.

Thoughts?

Cheers

Adrian

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor