Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

This login session: $13.76, but for you $11.88.

devel / comp.databases.ingres / Restarting Ingres

SubjectAuthor
* Restarting IngresSteve
`* Re: [Info-ingres] Restarting IngresMartin Bowes
 `* Re: [Info-ingres] Restarting IngresSteve
  +- Re: [Info-ingres] Restarting IngresPaul White
  +- Re: [Info-ingres] Restarting IngresMartin Bowes
  `- Re: [Info-ingres] Restarting IngresAdrian Williamson

1
Restarting Ingres

<48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a0c:a99c:: with SMTP id a28mr14320178qvb.33.1623597283407; Sun, 13 Jun 2021 08:14:43 -0700 (PDT)
X-Received: by 2002:a05:6830:2ea:: with SMTP id r10mr10371680ote.264.1623597283171; Sun, 13 Jun 2021 08:14:43 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!tr3.eu1.usenetexpress.com!feeder.usenetexpress.com!tr2.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Sun, 13 Jun 2021 08:14:42 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=120.17.238.217; posting-account=uL8iyAoAAABmcpUSs5hxN0c_ls8MZOL5
NNTP-Posting-Host: 120.17.238.217
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com>
Subject: Restarting Ingres
From: s.anders...@gmail.com (Steve)
Injection-Date: Sun, 13 Jun 2021 15:14:43 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 9
 by: Steve - Sun, 13 Jun 2021 15:14 UTC

Hi folks

Where I work I restart the prod and DR Ingres installations on a weekly basis. I do this out of tradition, rather than because there is some noticeable improvement in restarting Ingres.

At times during COVID I have restarted DR less and there has been no issue.

Interested to know how often others restart their prod and/or DR installations. Are there any recommendations regarding this?

Thanks
Steve

Re: [Info-ingres] Restarting Ingres

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

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 13 Jun 2021 11:48:03 -0500
Return-Path: <martin.bowes@ndph.ox.ac.uk>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: martin.b...@ndph.ox.ac.uk (Martin Bowes)
To: Steve <s.anderson.au@gmail.com>, "info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org>
Date: Sun, 13 Jun 2021 16:47:40 +0000
References: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com>
In-Reply-To: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com>
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-WatchGuard-AntiVirus: part scanned. clean action=allow
Subject: Re: [Info-ingres] Restarting Ingres
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.37.1623602863.1681.info-ingres@lists.planetingres.org>
Lines: 31
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-3uDfekskMzleIOCeLvMFDjCAIr4Nepa7lGTddKmIcicX6+c5pl7skPAWTe3euHnNfE6j6yhEhjihkmV!i19vOFqyowCyi7u0uOA0CSXm6kCQxqZynVutKK7SZJFwG1KTYZfn073smatQCrOW6AojaF1GZzAE!MRrkCJZT0+ie8XD3+I51PA==
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: 3154
 by: Martin Bowes - Sun, 13 Jun 2021 16:47 UTC

Hi Steve,

We tend to restart only when the situation demands. This means we would normally achieve uptime measured in months. I've not seen a compelling argument to stop and restart more often than that.

Marty

-----Original Message-----
From: Steve <s.anderson.au@gmail.com>
Sent: 13 June 2021 16:15
To: info-ingres@lists.planetingres.org
Subject: [Info-ingres] Restarting Ingres

Hi folks

Where I work I restart the prod and DR Ingres installations on a weekly basis. I do this out of tradition, rather than because there is some noticeable improvement in restarting Ingres.

At times during COVID I have restarted DR less and there has been no issue.

Interested to know how often others restart their prod and/or DR installations. Are there any recommendations regarding this?

Thanks
Steve
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

Re: [Info-ingres] Restarting Ingres

<027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:2119:: with SMTP id l25mr12125116qkl.81.1623641297849;
Sun, 13 Jun 2021 20:28:17 -0700 (PDT)
X-Received: by 2002:a9d:7f8e:: with SMTP id t14mr12013223otp.49.1623641297557;
Sun, 13 Jun 2021 20:28:17 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Sun, 13 Jun 2021 20:28:17 -0700 (PDT)
In-Reply-To: <mailman.37.1623602863.1681.info-ingres@lists.planetingres.org>
Injection-Info: google-groups.googlegroups.com; posting-host=120.17.4.90; posting-account=uL8iyAoAAABmcpUSs5hxN0c_ls8MZOL5
NNTP-Posting-Host: 120.17.4.90
References: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com> <mailman.37.1623602863.1681.info-ingres@lists.planetingres.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com>
Subject: Re: [Info-ingres] Restarting Ingres
From: s.anders...@gmail.com (Steve)
Injection-Date: Mon, 14 Jun 2021 03:28:17 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Steve - Mon, 14 Jun 2021 03:28 UTC

On Monday, June 14, 2021 at 2:48:09 AM UTC+10, Martin Bowes wrote:

> We tend to restart only when the situation demands. This means we would normally achieve uptime measured in months. I've not seen a compelling argument to stop and restart more often than that.

Thanks Marty.

Can I ask what situations, apart from patching or upgrading, might cause you to restart Ingres?

Steve

Re: [Info-ingres] Restarting Ingres

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

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!npeer.as286.net!npeer-ng0.as286.net!peer02.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 13 Jun 2021 23:12:02 -0500
Return-Path: <shift7solutions@gmail.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20161025;
h=x-gm-message-state:reply-to:subject:to:references:from:message-id
:date:user-agent:mime-version:in-reply-to:content-transfer-encoding
:content-language;
bh=WICeeBDXgBrCZIHStpr47iDY2GN1Xjq4HWfDuzBUI8U=;
b=kiW5rE3QENO1TK2fO+wh/Zr2vgQndS3nGhVR1BPExYVUZUf3w6d3lEIUpuuxpYBWNy
+nL3TkrWKEUVUykIXAEhMLXhmAKkYvnZ8j5kQWx0rNpcaBpjQP4UL6cYq0jyN+bdPnR5
1cRIUMN4HqespLrY1MEa2BClBurcpoo1EP9mjz+Pd9i3oB8whF8uBucpY5i2jcehIfkO
10awGdyzvtIKXbUJaOCkrXrH2uG1Jc11PF7zd+Ks8Y7WUUH2OfgnPx72Nl4AbH3xFlww
aZM3nvWlwEtHPG+5w0GyLmPMKwBFMbEIs/MC7TuBc+UJX1HH2F3B0flNcfLiMReKqRTv
LN1Q==
X-Gm-Message-State: AOAM530ql9IsnxTvPQDtWUlMHYj3X/TJaW1UlHIE5K+b0IyN8yCSVhS5
9URSE5Ou6oXgrmjAb4Pj3qYODpY2KoF+7Q==
X-Google-Smtp-Source: ABdhPJzgxKFOBej7eSGJ06wjakGfSR449kdvMt1mjkfNxOL4R4FPKUbn8Gie7yB2xil//7spPziWxQ==
X-Received: by 2002:a17:90b:3654:: with SMTP id
nh20mr13165001pjb.120.1623643893732;
Sun, 13 Jun 2021 21:11:33 -0700 (PDT)
Reply-To: paul.white@shift7solutions.com.au
To: info-ingres@lists.planetingres.org
References: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com>
<mailman.37.1623602863.1681.info-ingres@lists.planetingres.org>
<027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com>
From: paul.wh...@shift7solutions.com.au (Paul White)
Date: Mon, 14 Jun 2021 14:11:29 +1000
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: <027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Subject: Re: [Info-ingres] Restarting Ingres
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.38.1623643899.1681.info-ingres@lists.planetingres.org>
Lines: 33
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-xjtVNabgRhCsOZ9NulFqKE3pflMV/Ea7cDXduqM4nTTpFvlb1IdS0+gKezvI3MC4LLBAzenoZf/i1gJ!nrK60tLiRIL57VOWQqlNi7gmc5+sz2FwJJxHYnC6hXl9uzMWxTOXhAcdkIwzBKVW7B7MUrnMDtsI!7OLoHBZ7rH7+PCotUg8JBg==
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: 4689
X-Received-Bytes: 4899
 by: Paul White - Mon, 14 Jun 2021 04:11 UTC

Hi Steve,

Our client's MS Windows installations are restarted every 1 to 3 months
due to OS patches and hosting provider requirements. I think the longest
continues runtime on one server was about 2 years.

The Linux/Unix servers get a restart about once a year since Ingres
supports 24x7 operations. Generally I don't patch the OS on these
servers. They run for 4 to 5 years trouble free then are migrated to new
Infrastructure/OS together with a major Ingres upgrade.   The longest
runtime I recall was about 2 years on a Solaris V880.

The DR / replication servers are restarted more often for testing purposes.

Exceptional outages occur when a power pole is knocked down, UPS fails
or the computer room air conditioner fails.

Paul

On 14/06/2021 1:28 pm, Steve wrote:
> On Monday, June 14, 2021 at 2:48:09 AM UTC+10, Martin Bowes wrote:
>
>> We tend to restart only when the situation demands. This means we would normally achieve uptime measured in months. I've not seen a compelling argument to stop and restart more often than that.
> Thanks Marty.
>
> Can I ask what situations, apart from patching or upgrading, might cause you to restart Ingres?
>
> Steve
> _______________________________________________
> Info-ingres mailing list
> Info-ingres@lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres

Re: [Info-ingres] Restarting Ingres

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

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Mon, 14 Jun 2021 01:30:03 -0500
Return-Path: <martin.bowes@ndph.ox.ac.uk>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: martin.b...@ndph.ox.ac.uk (Martin Bowes)
To: Steve <s.anderson.au@gmail.com>, "info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org>
Date: Mon, 14 Jun 2021 06:29:15 +0000
References: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com>
<mailman.37.1623602863.1681.info-ingres@lists.planetingres.org>
<027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com>
In-Reply-To: <027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com>
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-WatchGuard-AntiVirus: part scanned. clean action=allow
Subject: Re: [Info-ingres] Restarting Ingres
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.39.1623652158.1681.info-ingres@lists.planetingres.org>
Lines: 30
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-cywcfOefzUtIwXnsVnu3I9u6Bhan5JTwzbwEzwCBOHGLfeoEvxrGKXK9u5ERQ52GlLiJpKmAs/+JXyK!ihWtobZsA2p60BPVI0JOQ21nn/glQa1E2ZkYfr0b1xhQsebzHoZuHHGXyDaSrW7KnnQbQosSfMSB!TlCVn03oke2QDKWnjqvLHg==
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: 3359
 by: Martin Bowes - Mon, 14 Jun 2021 06:29 UTC

We very occasionally get a situation which we call a stuck lock list where a session has exited but the lock list remains. The only way out is to restart the installation. It is rare, and I would guess of the 50+ installations that we field, that such an event would happened just a few times annually.

Marty

-----Original Message-----
From: Steve <s.anderson.au@gmail.com>
Sent: 14 June 2021 04:28
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] Restarting Ingres

On Monday, June 14, 2021 at 2:48:09 AM UTC+10, Martin Bowes wrote:

> We tend to restart only when the situation demands. This means we would normally achieve uptime measured in months. I've not seen a compelling argument to stop and restart more often than that.

Thanks Marty.

Can I ask what situations, apart from patching or upgrading, might cause you to restart Ingres?

Steve
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

Re: [Info-ingres] Restarting Ingres

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

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!paganini.bofh.team!news.dns-netz.com!news.freedyn.net!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!tr2.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.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, 14 Jun 2021 03:14: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.w...@rationalcommerce.com (Adrian Williamson)
To: "'Martin Bowes'" <martin.bowes@ndph.ox.ac.uk>, "'Steve'" <s.anderson.au@gmail.com>, <info-ingres@lists.planetingres.org>
References: <48e20fc2-4d8e-47a1-b809-01722913cd0fn@googlegroups.com> <mailman.37.1623602863.1681.info-ingres@lists.planetingres.org> <027b2016-bcf2-40a7-a41f-8327945cff29n@googlegroups.com> <7f03ebb9456f4f13897c8ce9695cb8e3@ndph.ox.ac.uk>
In-Reply-To: <7f03ebb9456f4f13897c8ce9695cb8e3@ndph.ox.ac.uk>
Date: Mon, 14 Jun 2021 09:12:28 +0100
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQFE8z3QZR5yad5fReUXy3QN8SF6jAKfn0NIAhDNKN0BkQMgjKwF9c9g
Content-Language: en-gb
X-Provags-ID: V03:K1:lxz8OYlPatWYFMHEpoDMQozbY4tFtsyx1mFNhccgZbqz8Jcz6et 6kSqS67qs9zV9ZYGNuGeAXNtgOKAk40D/u9QnFAFU6pm3v0rw2+v8EqLb3c7N+dOW/vW77i CAKQB8ISet6Wa0oAIexPNtjY0Q2bX1hL2/BlIY+rcM41m1PbidoKIv2cPTQg1BSgkT0tOwK EJjlj+cnZ7jEoUnyy1SpA==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:/VxIivFkOww=:JCmCsRrjm1I0KRZ5hj0hN2 nr/ZJ+hS5rwyrLmcZzchKriW908g37uAHV2JCtE7zNVI0Rp6OR3/CkiSL70W+HltGLejAx2/1 1kzvjbMOP/BOVj5PS9F8rGbgJl5bxU5zg+bfNnIqlBLQZ5wZXrfO/XjQEvUJzDN+oRGH3EEHm 6roCWKiYKMgYKvWEGnth/WFhVDjRgc8O3sigfwzc/lrREYNxY+yBRbKjSvfWRZ/ZHBOkZRbho pG8zQvZ5ATjFa4E4NBKsw2vT+Dmlf4zRKGucC/4LwHx+zzAFioKIbDQvyROkSh10DUd2Jj2l9 UpqqGHWsAVGV6kN4D4sQMygo7Dz7BLv6R7gX25LF1Mp2kIc2E4HXDnzsDEis41JgbsL4DGcip rTI7FbAS2KI51HNx4uQvBVxZHDmHpOhHJWQbI5/ezQyikJtf+VqyjV1UkxunXqWo1BqJKtA+9 7+iEQe2lmE8bvhMRamY5C0MePlM2VmqSPtFA52lglAoTz1109TVv2zJto/gFuuEWN/7zFHD2H jSRQRnRZ1VAp/KXWtrvCbe8Hep75qlPATVJGxo8bHVC
Subject: Re: [Info-ingres] Restarting Ingres
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.40.1623658353.1681.info-ingres@lists.planetingres.org>
Lines: 67
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-eJpY0TaWvS3DTSHbzgUyfVIPpylAl5NxM/eaeBn7nozxZdVn6hFOWNhHSKDMLaU0Tul3WXhyiC/5SUU!hW6Crui1I8IoDNeUbawPlWx2eC8fKh9i9AU8hXusr/7FXIapSxm9UiQCHpMLOASlfoX9GG1+Fcdf!T1X2cZKxb0fLXu7fGPlfrQ==
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: 5661
 by: Adrian Williamson - Mon, 14 Jun 2021 08:12 UTC

Hi,

I have one customer where we reboot the Windows server each week (it is
one box solution : OpenROAD & Ingres running on Terminal Services ) .

I do that as it means that any minor leaks from any software do not
snowball.

Not that I've witnessed memory leaks, but it gives me the warm feeling that
it reboots itself rather than me getting a call out cause the server has
stopped.

Gives me the illusion of being in control.

Twelve years now and no outages.*

Cheers

Adrian

*Well apart from when the 'employees' of the Multinational services company
which runs the infrastructure decide to just pull the power on the VM
causing ''The last shutdown was unexpected' message to appear in the event
log. We have educated them to the benefits of an orderly shutdown on
windows.

-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org
<info-ingres-bounces@lists.planetingres.org> On Behalf Of Martin Bowes
Sent: 14 June 2021 07:29
To: Steve <s.anderson.au@gmail.com>; info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] Restarting Ingres

We very occasionally get a situation which we call a stuck lock list where a
session has exited but the lock list remains. The only way out is to restart
the installation. It is rare, and I would guess of the 50+ installations
that we field, that such an event would happened just a few times annually.

Marty

-----Original Message-----
From: Steve <s.anderson.au@gmail.com>
Sent: 14 June 2021 04:28
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] Restarting Ingres

On Monday, June 14, 2021 at 2:48:09 AM UTC+10, Martin Bowes wrote:

> We tend to restart only when the situation demands. This means we would
normally achieve uptime measured in months. I've not seen a compelling
argument to stop and restart more often than that.

Thanks Marty.

Can I ask what situations, apart from patching or upgrading, might cause you
to restart Ingres?

Steve
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor