Tasks for creating database records are accumulating, records are being created for a very long time

[Lyxiz]

Page on which it happened

index.php?page=tasks

Steps to reproduce

1. I add several new records to the database one by one
2. Up to 23 tasks for creating new elements accumulate and after that an error appears when trying to add a new element "error_item_currently_being_updated"
3. In the task manager, the list of unfinished tasks is already almost 2 hours to create an item.

Expected behaviour

The creation task should be completed in no more than 5 minutes (or complete the execution in a few seconds (ideally))

Actual behaviour

Tasks for creating new items do not take hours to complete.

Server configuration

Operating system: Linux teampass 6.8.0-49-generic #49-Ubuntu SMP PREEMPT_DYNAMIC Mon Nov 4 02:06:24 UTC 2024 x86_64

Web server: Apache/2.4.58 (Ubuntu)

Database: 8.0.40-0ubuntu0.24.04.1

PHP version: 8.3.10

Teampass version: 3.1.3.1

Teampass configuration variables:

'activate_expiration' => '0'
'admin_2fa_required' => '0'
'agses_authentication_enabled' => '0'
'allow_import' => '1'
'allow_print' => '1'
'anyone_can_modify' => '0'
'anyone_can_modify_bydefault' => '0'
'api' => '0'
'api_token_duration' => '60'
'bck_script_filename' => 'bck_teampass'
'bck_script_passkey' => '<removed>'
'bck_script_path' => '/var/www/html/teampass/backups'
'clean_orphan_objects_task' => 'daily;03:15'
'clipboard_life_duration' => '15'
'copy_to_clipboard_small_icons' => '1'
'cpassman_dir' => '/var/www/html/teampass'
'cpassman_url' => 'https://<anonym_url>'
'create_item_without_password' => '0'
'custom_login_text' => 'АКС'
'custom_logo' => ''
'date_format' => 'd/m/Y'
'default_language' => 'russian'
'default_session_expiration_time' => '10080'
'delay_item_edition' => '15'
'disable_show_forgot_pwd_link' => '0'
'duo' => '0'
'duo_failmode' => 'secure'
'duo_host' => '<removed>'
'duo_ikey' => '<removed>'
'duo_skey' => '<removed>'
'duplicate_folder' => '1'
'duplicate_item' => '1'
'email_auth_pwd' => '<removed>'
'email_auth_username' => '<removed>'
'email_debug_level' => '0'
'email_from' => '<removed>'
'email_from_name' => 'TeamPass AKS'
'email_port' => '465'
'email_security' => 'ssl'
'email_server_url' => 'teampass.aks-belgorod.ru'
'email_smtp_auth' => '1'
'email_smtp_server' => '<removed>'
'enable_ad_user_auto_creation' => '0'
'enable_ad_users_with_ad_groups' => '0'
'enable_attachment_encryption' => '1'
'enable_delete_after_consultation' => '0'
'enable_email_notification_on_item_shown' => '0'
'enable_email_notification_on_user_pw_change' => '1'
'enable_favourites' => '1'
'enable_http_request_login' => '1'
'enable_kb' => '1'
'enable_massive_move_delete' => '1'
'enable_personal_saltkey_cookie' => '0'
'enable_pf_feature' => '1'
'enable_refresh_task_last_execution' => '1'
'enable_send_email_on_user_login' => '0'
'enable_server_password_change' => '0'
'enable_sts' => '0'
'enable_suggestion' => '1'
'enable_tasks_log' => '0'
'enable_tasks_manager' => '1'
'enable_user_can_create_folders' => '1'
'encryptClientServer' => '1'
'favicon' => 'https://<anonym_url>/favicon.ico'
'files_with_defuse' => 'done'
'ga_reset_by_user' => ''
'ga_website_name' => 'TeamPass AKS'
'get_tp_info' => '1'
'google_authentication' => '1'
'highlight_favorites' => '0'
'highlight_selected' => '1'
'insert_manual_entry_item_history' => '0'
'item_creation_templates' => '1'
'item_duplicate_in_same_folder' => '0'
'item_extra_fields' => '1'
'items_ops_job_frequency' => '5'
'items_statistics_job_frequency' => '10'
'last_cron_exec' => '1734075721'
'ldap_and_local_authentication' => '0'
'ldap_bdn' => ''
'ldap_dn_additional_user_dn' => ''
'ldap_group_object_filter' => ''
'ldap_group_objectclasses_attibute' => 'top,groupofuniquenames'
'ldap_guid_attibute' => 'objectguid'
'ldap_hosts' => '<removed>'
'ldap_mode' => '0'
'ldap_new_user_is_administrated_by' => '0'
'ldap_password' => '<removed>'
'ldap_port' => '389'
'ldap_ssl' => '0'
'ldap_tls' => '0'
'ldap_tls_certifacte_check' => 'LDAP_OPT_X_TLS_NEVER'
'ldap_type' => 'ActiveDirectory'
'ldap_user_attribute' => '0'
'ldap_user_dn_attribute' => ''
'ldap_user_object_filter' => ''
'ldap_username' => ''
'limited_search_default' => '0'
'log_accessed' => '1'
'log_connections' => '1'
'maintenance_mode' => '0'
'manager_edit' => '1'
'manager_move_item' => '1'
'max_latest_items' => '10'
'maximum_number_of_items_to_treat' => '100'
'maximum_session_expiration_time' => '10080'
'mfa_for_roles' => ''
'migration_to_2127' => 'done'
'nb_bad_authentication' => '5'
'nb_items_by_query' => 'auto'
'number_of_used_pw' => '3'
'number_users_build_cache_tree' => '10'
'oauth2_client_appname' => 'Login with Azure'
'oauth2_client_endpoint' => '<removed>'
'oauth2_client_id' => '<removed>'
'oauth2_client_scopes' => 'openid,profile,email'
'oauth2_client_secret' => '<removed>'
'oauth2_client_token' => '<removed>'
'oauth2_enabled' => '0'
'offline_key_level' => '48'
'onthefly-backup-key' => '<removed>'
'onthefly-restore-key' => '<removed>'
'otv_expiration_period' => '3'
'otv_is_enabled' => '1'
'password_overview_delay' => '4'
'path_to_files_folder' => '/var/tp/files'
'path_to_upload_folder' => '/var/tp/upload'
'personal_saltkey_cookie_duration' => '31'
'personal_saltkey_security_level' => '50'
'proxy_ip' => '<removed>'
'proxy_port' => ''
'purge_temporary_files_task' => 'daily;02:00'
'pw_life_duration' => '0'
'pwd_default_length' => '15'
'pwd_maximum_length' => '40'
'rebuild_config_file' => ''
'rebuild_config_file_task' => 'saturday;07:00'
'reload_cache_table_task' => 'sunday;12:00'
'restricted_to' => '0'
'restricted_to_roles' => '0'
'richtext' => '0'
'roles_allowed_to_print' => '0'
'roles_allowed_to_print_select' => '[4]'
'saltkey_ante_2127' => 'none'
'secure_display_image' => '1'
'send_mail_on_user_login' => '0'
'send_statistics_items' => 'stat_country;stat_users;stat_items;stat_items_shared;stat_folders;stat_folders_shared;stat_admins;stat_managers;stat_ro;stat_mysqlversion;stat_phpversion;stat_teampassversion;stat_languages;stat_kb;stat_suggestion;stat_customfields;stat_api;stat_2fa;stat_agses;stat_duo;stat_ldap;stat_syslog;stat_stricthttps;stat_fav;stat_pf;'
'send_stats' => '0'
'send_stats_time' => '1717077780'
'sending_emails_job_frequency' => '1'
'settings_offline_mode' => '0'
'settings_tree_counters' => '0'
'show_description' => '1'
'show_item_data' => '1'
'show_last_items' => '1'
'show_only_accessible_folders' => '1'
'subfolder_rights_as_parent' => '1'
'syslog_enable' => '0'
'syslog_host' => '<removed>'
'syslog_port' => '514'
'task_maximum_run_time' => '300'
'tasks_log_retention_delay' => '30'
'tasks_manager_refreshing_period' => '20'
'teampass_version' => '3.1.3'
'time_format' => 'H:i:s'
'timestamp' => '1734075756'
'timezone' => 'Europe/Moscow'
'tree_counters' => '0'
'upgrade_timestamp' => '1733822856'
'upload_all_extensions_file' => '0'
'upload_docext' => 'doc,docx,dotx,xls,xlsx,xltx,rtf,csv,txt,pdf,ppt,pptx,pot,dotx,xltx'
'upload_imageresize_height' => '720'
'upload_imageresize_options' => '1'
'upload_imageresize_options_input' => ''
'upload_imageresize_quality' => '90'
'upload_imageresize_width' => '1280'
'upload_imagesext' => 'jpg,jpeg,gif,png'
'upload_maxfilesize' => '10mb'
'upload_otherext' => 'sql,xml'
'upload_pkgext' => '7z,rar,tar,zip'
'upload_zero_byte_file' => '0'
'url_to_files_folder' => 'http://teampass.aks-belgorod.ru/files'
'use_md5_password_as_salt' => '0'
'user_keys_job_frequency' => '5'
'users_personal_folder_task' => 'daily;03:00'
'utf8_enabled' => '1'

Updated from an older Teampass or fresh install:

Client configuration

Browser: Chrome - 131.0.0.0

Operating system: Windows - 64bits

Logs

Web server error log

 -  ()

Teampass 10 last system errors

Log from the web-browser developer console (CTRL + SHIFT + i)

Insert the log here and especially the answer of the query that failed.

[nilsteampassnet]

@Lyxiz
I believe you have àtask that is not finished for any reason.

In table teampass_background_subtasks, find the entry that has is_in_process = 1 and subtask_in_progress = 1.
Set both to 0 and wait for the cron to run.

[Lyxiz]

Hi!
The problem was in the cron configuration - the standard path to php did not work, I replaced it with /usr/bin/php8.3 (the current one used by teampass) and manually entered it into the cron task. I think the problem occurred after upgrading the php version to 8.4.