l.miklos Posted December 31, 2020 Report Share Posted December 31, 2020 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 Quote Link to comment Share on other sites More sharing options...
Daria Kotilainen Posted January 3, 2021 Report Share Posted January 3, 2021 Hi Miklos, how many documents do you have? It seems that Daminion's fulll-text search engine is analyzing the documents to make them searchable. Kind regards Daria Quote Link to comment Share on other sites More sharing options...
l.miklos Posted January 4, 2021 Author Report Share Posted January 4, 2021 Hi Daria, In my test server I have more than 60K pictures, these are only jpg-s. In productive server there are more than 110 K jpg-s and this works well. Can I switch off the full text search? Miklos Quote Link to comment Share on other sites More sharing options...
Daria Kotilainen Posted January 8, 2021 Report Share Posted January 8, 2021 Hi Miklos, Let me please clarify this and I will get back to you asap Kind regards, Daria Quote Link to comment Share on other sites More sharing options...
l.miklos Posted January 12, 2021 Author Report Share Posted January 12, 2021 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 Quote Link to comment Share on other sites More sharing options...
l.miklos Posted January 13, 2021 Author Report Share Posted January 13, 2021 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 Quote Link to comment Share on other sites More sharing options...
Daria Kotilainen Posted January 13, 2021 Report Share Posted January 13, 2021 Hi Miklos, Is this the test catalog? It seems that the user with restricted permissions was trying to create new tag values. Let me get my colleagues to take a look at the previous logs Daria Quote Link to comment Share on other sites More sharing options...
Daria Kotilainen Posted January 13, 2021 Report Share Posted January 13, 2021 Miklos, would it be possible to send us a backup or, better, schedule a remote session with you? Please send me an email with your open slots. We are in GMT-6, so if it would be possible connect after 2 p m your time, i would be great Daria Quote Link to comment Share on other sites More sharing options...
l.miklos Posted January 13, 2021 Author Report Share Posted January 13, 2021 Hi Daria, I tried with admin user only. Miklos Quote Link to comment Share on other sites More sharing options...
l.miklos Posted January 22, 2021 Author Report Share Posted January 22, 2021 Just to clarify this: upgrading the PostgreSQL server from 9.3 to 12 solved the problem. Miklos Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.