# Unexpected upgrade of Continua's Database

**URL:** https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111
**Category:** Discussion
**Created:** [September 2, 2021, 7:14am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111 "2021-09-02T07:14:07Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![sa\_thomaslohrum](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@sa\_thomaslohrum](https://www.finalbuilder.com/forums/u/sa_thomaslohrum)
#### Post date: [September 2, 2021, 7:14am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/1 "2021-09-02T07:14:07Z")

</div>

Hi,

we upgraded to node.js 14 LTS Version on our buildserver, coming from node.js 10 LTS. Before that we stopped the Continua Service. The install required a reboot. To our surprise Continua upgraded its (PostgreSQL) database, when the system started. The system runs fine, so far. Any ideas why this happened?

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [September 2, 2021, 7:23am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/2 "2021-09-02T07:23:14Z")

</div>

Hi Thomas,

Where did you see that Continua upgraded it’s database? What version was it and what version is it now? Only the installer includes code to upgrade the database.

---

<div class="post-metadata">

### Author: ![sa\_thomaslohrum](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@sa\_thomaslohrum](https://www.finalbuilder.com/forums/u/sa_thomaslohrum)
#### Post date: [September 2, 2021, 7:27am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/3 "2021-09-02T07:27:02Z")

</div>

I had my browser open and was able to observer Continua’s startup process there. We are running the latest version of Continua.

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [September 2, 2021, 7:30am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/4 "2021-09-02T07:30:33Z")

</div>

I think you are referring to the database structure migration which does work on server start up, but that should only run once for each new version of Continua CI. Each database migration is recorded in the `versioninfo` table in the database.

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [September 2, 2021, 7:36am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/5 "2021-09-02T07:36:12Z")

</div>

If there are no new database migrations to run then you will still see the following migration messages on start up:

```auto
5:32:58 PM : Starting service Continua version 9999.0.0.9999. 834ms
5:32:59 PM : Initialising service. 155ms
5:32:59 PM : Migrating database. 132ms
5:32:59 PM : Initialising database migrations..... 404ms
5:33:00 PM : Using connection string #######. 22ms
5:33:00 PM : Running database migrations..... 1s 281ms
5:33:01 PM : Database migrations completed.
5:33:01 PM : Database migration done. 4ms

```

---

<div class="post-metadata">

### Author: ![sa\_thomaslohrum](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@sa\_thomaslohrum](https://www.finalbuilder.com/forums/u/sa_thomaslohrum)
#### Post date: [September 2, 2021, 7:43am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/6 "2021-09-02T07:43:32Z")

</div>

I can connect to the db server, but querying data is not possible, as i get a socket error.

“could not send data to server: Socket is not connected (0x00002749/10057) could not send SSL negotiation packet: Socket is not connected (0x00002749/10057)”.

As often, when start chasing one issue, you end up with other/more trouble ☹

---

<div class="post-metadata">

### Author: ![sa\_thomaslohrum](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@sa\_thomaslohrum](https://www.finalbuilder.com/forums/u/sa_thomaslohrum)
#### Post date: [September 2, 2021, 7:55am UTC](https://www.finalbuilder.com/forums/t/unexpected-upgrade-of-continuas-database/7111/7 "2021-09-02T07:55:48Z")

</div>

Googeling, this can be related to the server configuration using localhost or maybe not using the latest pgAdmin tool. I stop chasing the issue here, as Continua runs fine. Thanks for your help anyway!
