Jump to content

Connections not properly closed in 7.0.0.2433


Recommended Posts

Hi,

after upgrading to the recent 7.0 I observe have these problems:

  • closing a client takes up to a minutes
  • when restarting the client apllication it takes several minutes until I can connect to the catalog again, because the maximum number of connections has been reached.

Considering the new interface I would like to revert a previous version. Is there a way to do so?

Best regards,
Volker

Link to post
Share on other sites

Hi Volker, 

 

Please restart Daminion server to drop the connections. 

You can also switch to the dark move via View menu. 

 

Please let em know if you created the backup of the catalog prior to the upgrade? In this case, yes, you can revert to the previous version without any issues. 

 

Daria

Link to post
Share on other sites

Thank you for your reply, Daria.

After restarting Daminion server the behaviour is unchanged: closing a client takes a very long time and starting the client doesn't work, because the connection limit has been reached.

 

The dark view is working partially; just the thumbnail windows is affected.

 

Volker

Link to post
Share on other sites

When closing the client application I can see a very high CPU usage on the server with one or two of the Postgres processes. In the logs there are lots of syntax errors reported:

 

ERROR 2021-04-07 21:51:08,175 FtsLoader.RecurrentTask [3] - Npgsql.PostgresException (0x80004005): 42601: Syntaxfehler bei »on«
   bei Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<<DoReadMessage>g__ReadMessageLong|0>d.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<<DoReadMessage>g__ReadMessageLong|0>d.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei System.Threading.Tasks.ValueTask`1.get_Result()
   bei Npgsql.NpgsqlDataReader.<NextResult>d__44.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei Npgsql.NpgsqlDataReader.NextResult()
   bei Npgsql.NpgsqlCommand.<ExecuteReaderAsync>d__102.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei Npgsql.NpgsqlCommand.<ExecuteNonQuery>d__92.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
   bei Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:Zeile 2797.
   bei Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:Zeile 568.
   bei FtsLoader.CatalogRepository.<>c__DisplayClass12_0.<SaveContent>b__0(IDbConnection connection) in C:\DaminionAutoGit\code\FtsLoader\src\FtsLoader\CatalogRepository.cs:Zeile 79.
   bei FtsLoader.Repository.UsingConnection[T](Func`2 func) in C:\DaminionAutoGit\code\FtsLoader\src\FtsLoader\Repository.cs:Zeile 20.
   bei FtsLoader.CatalogRepository.SaveContent(Int64 mediaItemId, String content) in C:\DaminionAutoGit\code\FtsLoader\src\FtsLoader\CatalogRepository.cs:Zeile 78.
   bei FtsLoader.RecurrentTask.RunAsync(ITask currentTask, IServiceProvider scopeServiceProvider, CancellationToken cancellationToken) in C:\DaminionAutoGit\code\FtsLoader\src\FtsLoader\RecurrentTask.cs:Zeile 72.
  Exception data:
    Severity: FEHLER
    SqlState: 42601
    MessageText: Syntaxfehler bei »on«
    Position: 102
    File: src\backend\parser\scan.l
    Line: 1002
    Routine: scanner_yyerror

 

Link to post
Share on other sites

Hello,

If you use PostgreSQL lower than v. 10, please update it. 

To upgrade your PostgreSQL version, please follow these steps: 

- download PostgreSQL 10 or 12 (https://www.enterprisedb.com/downloads/postgres-postgresql-downloads)
- Create backups of your catalogs in the Daminion server admin panel 
- Stop your current PostgreSQL and manually kill all residual processes if any (in TaskManager)
- Run the installation of PostgreSQL and make sure it is being installed to the port 5432
- Once the installation is done, please double-check that only PostgreSQL is running
- Go to Daminion server admin panel > Catalogs > select a catalog > Actions > Restore and restore the catalogs from the backups you created earlier. 
- Run Daminion server

Let me know if you have any problems with the process.

Kind regards, Kate

Link to post
Share on other sites

Hi Kate,

thank you very much for these detailed instructions. I was able upgrade PostgreSQL without any problems and now the Daminion clients are working flawlessly again 🙂

Is it safe to uninstall the previous database version now?

Best regards,
Volker

  • Like 1
Link to post
Share on other sites
On 4/8/2021 at 11:04 AM, Katerina Karpenko said:

PostgreSQL 10 or 12

Kate, does this mean PostgreSQL is supported and was tested with Daminion? I remember a post where somebody claimed to have seen performance improvements after upgrading to PostgreSQL 12 (or 13?).

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...