Jump to content

High processor utilization in 6.8


Recommended Posts

Hi all,

We use Daminion Teams server 6.7 2250 in our productive server, it works well.

But in the test server we tried the 6.8 2333 version, and it always uses at least 50% of processor time (see attached jpeg file).

What is the ftsloader.exe? In 6.7 I cannot see it in the running processes.

Happy new year everybody!

Miklos

daminion_memory.jpg

Link to post
Share on other sites

In addition to the high proc utilization:

The Postgresql server log files in C:\ProgramData\PostgreSQL\Data\pg_log continously growth, in the last month (since 2020.12.11) it's size reaches the 40 GB!

A log file contains the next endlessly:

    on conflict on constraint content_pkey

    do update set text = $2, fts = to_tsvector($2), modifiedtime = now()
2021-01-01 09:36:09 CET ERROR:  syntax error at or near "on" at character 102
2021-01-01 09:36:09 CET STATEMENT:  insert into content (id_mediaItem, text, fts, modifiedtime) values ($1, $2, to_tsvector($2), now())

    on conflict on constraint content_pkey

    do update set text = $2, fts = to_tsvector($2), modifiedtime = now()
2021-01-01 09:36:09 CET ERROR:  syntax error at or near "on" at character 102
2021-01-01 09:36:09 CET STATEMENT:  insert into content (id_mediaItem, text, fts, modifiedtime) values ($1, $2, to_tsvector($2), now())

    on conflict on constraint content_pkey

    do update set text = $2, fts = to_tsvector($2), modifiedtime = now()
2021-01-01 09:36:10 CET ERROR:  syntax error at or near "on" at character 102
2021-01-01 09:36:10 CET STATEMENT:  insert into content (id_mediaItem, text, fts, modifiedtime) values ($1, $2, to_tsvector($2), now())

Miklos

 

 

Link to post
Share on other sites

Hi all,

There are log files on the next place:

C:\ProgramData\Daminion Software\Daminion Server\Logs\Netcatalog

In the errors.txt file in it I can see the next:

2021-01-12 15:13:46,093 [STP SmartThreadPool Thread #45] ERROR PicaJet.Daminion.Service.Utils.ReadMetadataCommand [(null)] - Error: (2263462)
PicaJet.Daminion.Common.AccessDeniedException: User with current role cannot create new indexed tag value
   a következő helyen: PicaJet.Daminion.Service.Utils.AccessRightsHelper.CheckCreateIndexedTagValue(Guid indexedTagGuid, Boolean isLocal, IDatabaseEnvironment dbEnvironment, DbFactory dbFactory, DbCommandHelper dbCommandHelper) hely: C:\DaminionAutoGit\code\Service.Utils.Uni\Helper\AccessRightsHelper.cs, sor: 61
   a következő helyen: PicaJet.Daminion.Service.Utils.CreateIndexedTagValueCommand.Start(DbConnection connection) hely: C:\DaminionAutoGit\code\Service.Utils.Uni\Command\CreateIndexedTagValueCommand.cs, sor: 62
   a következő helyen: PicaJet.Daminion.Service.Utils.ReadMetadataCommand.Process(DbConnection connection, Int64 mediaItemId) hely: C:\DaminionAutoGit\code\Service.Utils.Uni\Command\ReadMetadataCommand.cs, sor: 261
   a következő helyen: PicaJet.Daminion.Service.Utils.ReadMetadataCommand.Start(DbConnection connection) hely: C:\DaminionAutoGit\code\Service.Utils.Uni\Command\ReadMetadataCommand.cs, sor: 63
   a következő helyen: PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() hely: C:\DaminionAutoGit\code\Service.Utils.Uni\DatabaseCommand.cs, sor: 102
   a következő helyen: PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() hely: C:\DaminionAutoGit\code\Service.Utils.Uni\DatabaseCommand.cs, sor: 50

but obviously there is no C:\DaminionAutoGit folder on my drive.....

 

Miklos

 

Link to post
Share on other sites
  • 2 weeks later...

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...