search

akaunting / docker

Docker Image for Akaunting
https://github.com/akaunting/akaunting
GNU General Public License v3.0
182 stars 85 forks source link

Fix installation issue #104

Closed sevannerse closed 9 months ago

sevannerse commented 9 months ago

This PR solves the exception that gives the message Not able to create a new user.. The issues given below probably will be solved as well. https://github.com/akaunting/docker/issues/101 https://github.com/akaunting/docker/issues/102

wstack-dev commented 9 months ago

Hello,

I appreciate the suggestions provided earlier, but unfortunately, I'm still encountering the same issue with Akaunting when trying to create a new company. The process seems to halt with an error at the user creation step.

This issue occurs after executing the docker-compose.yml. Additionally, I've noticed that sometimes, when restarting the Apache server, it seems to try to do something but ends up entering the same error loop.

Here's the sequence of events leading up to the error:


akaunting       | Setting locale en-US
akaunting       | Creating database tables
akaunting       | Connecting to database akaunting@akaunting-db:3306
akaunting       | Creating company
akaunting       | 
akaunting       | In CreateCompany.php line 61:
akaunting       |                                   
akaunting       |   Not able to create a new user.  
akaunting       |                                   
akaunting       |

It consistently fails at CreateCompany.php line 61 with the message "Not able to create a new user."

I have double-checked the database connection settings and ensured that the akaunting-db is accessible and properly configured. Despite this, the error persists.

Could this be related to a specific configuration within Akaunting, or is it possible there's an underlying issue with database permissions or user roles?

Any further insights or troubleshooting steps would be immensely helpful.

Thank you once again for your time and assistance.

sevannerse commented 9 months ago

Hello,

Could you please give it a try with the below command? You should remove previous volumes in order to ensure making a fresh installation. AKAUNTING_SETUP=true docker compose -f docker-compose.yml up -d --build

wstack-dev commented 9 months ago

Hello, I performed a clean installation using the suggested command, but the bug still appeared. I will leave the terminal with its logs.

Build process completed successfully
Installing '/usr/local/lib/php/extensions/no-debug-non-zts-20210902/redis.so'
install ok: channel://pecl.php.net/redis-6.0.2
configuration option "php_ini" is not set to php.ini location
You should add "extension=redis.so" to php.ini
Removing intermediate container d9e1102aafed
 ---> a1bf130b17db
Step 8/12 : RUN curl -Lo /tmp/akaunting.zip 'https://akaunting.com/download.php?version=latest&utm_source=docker&utm_campaign=developers'
 ---> Running in f72f5ea45393
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
100 61.9M  100 61.9M    0     0  29.3M      0  0:00:02  0:00:02 --:--:-- 41.8M
Removing intermediate container f72f5ea45393
 ---> 7dba8ce11351
Step 9/12 : COPY files/akaunting-v.sh /usr/local/bin/akaunting-v.sh
 ---> 5ecdc8e8c225
Step 10/12 : COPY files/html /var/www/html
 ---> 6c6b59662ca1
Step 11/12 : ENTRYPOINT ["/usr/local/bin/akaunting-v.sh"]
 ---> Running in 2fa4ee9763b2
Removing intermediate container 2fa4ee9763b2
 ---> 87a29fd9a92f
Step 12/12 : CMD ["--start"]
 ---> Running in 28d65de1caa4
Removing intermediate container 28d65de1caa4
 ---> 2038b294d418

Successfully built 2038b294d418
Successfully tagged docker_akaunting:latest
Creating akaunting-db ... done
Creating akaunting    ... done
Attaching to akaunting-db, akaunting
akaunting-db    | 2023-11-21 12:17:13+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.3+maria~ubu2204 started.
akaunting-db    | 2023-11-21 12:17:14+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
akaunting-db    | 2023-11-21 12:17:14+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.3+maria~ubu2204 started.
akaunting       | Enabling module rewrite.
akaunting       | To activate the new configuration, you need to run:
akaunting       |   service apache2 restart
akaunting-db    | 2023-11-21 12:17:14+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
akaunting-db    | 2023-11-21 12:17:14 0 [Note] Starting MariaDB 11.1.3-MariaDB-1:11.1.3+maria~ubu2204 source revision 0f5613a25f27b8034645226a48c2dc1aa4562281 as process 1
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Number of transaction pools: 1
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
akaunting-db    | 2023-11-21 12:17:14 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Using liburing
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Completed initialization of buffer pool
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: End of log at LSN=1289699
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Opened 3 undo tablespaces
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: log sequence number 1289699; transaction id 2225
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
akaunting-db    | 2023-11-21 12:17:14 0 [Note] Plugin 'FEEDBACK' is disabled.
akaunting-db    | 2023-11-21 12:17:14 0 [Note] Plugin 'wsrep-provider' is disabled.
akaunting-db    | 2023-11-21 12:17:14 0 [Note] Server socket created on IP: '0.0.0.0'.
akaunting-db    | 2023-11-21 12:17:14 0 [Note] Server socket created on IP: '::'.
akaunting-db    | 2023-11-21 12:17:14 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
akaunting-db    | 2023-11-21 12:17:14 0 [Note] InnoDB: Buffer pool(s) load completed at 231121 12:17:14
akaunting-db    | 2023-11-21 12:17:14 0 [Note] mariadbd: ready for connections.
akaunting-db    | Version: '11.1.3-MariaDB-1:11.1.3+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
akaunting       | Setting locale en-US
akaunting       | Creating database tables
akaunting       | Connecting to database akaunting@akaunting-db:3306
akaunting       | Creating company
akaunting       | 
akaunting       | In CreateCompany.php line 61:
akaunting       |                                   
akaunting       |   Not able to create a new user.  
akaunting       |                                   
akaunting       |

Resto del log pastebin

docker-compose

version: '3.7'

services:

  akaunting:
    container_name: akaunting
    image: docker.io/akaunting/akaunting:latest
    build:
      context: .
    ports:
      - 9797:80
    volumes:
      - akaunting-data:/var/www/html
    restart: unless-stopped
    env_file:
      - env/run.env
    environment:
      - AKAUNTING_SETUP
    depends_on:
      - akaunting-db

  akaunting-db:
    container_name: akaunting-db
    image: mariadb
    volumes:
      - akaunting-db:/var/lib/mysql
    restart: unless-stopped
    env_file:
      - env/db.env

volumes:
  akaunting-data:
  akaunting-db:

If there's anything else you need, feel free to ask. Thank you for your cooperation, and have a great day

wstack-dev commented 9 months ago

Additional Information:

I deleted the database and then recreated it manually. After making a request to the port, the database was reconstructed, but on the first use, the user view loaded with an "Oops" message. I navigated to the login page at "auth/login", and again, encountered an "Oops" message.

I checked the tables, and they are all empty without any data.

After removing the prefix, this issue appeared:

Module rewrite already enabled
Setting locale en-US
Creating database tables
Connecting to database akaunting@akaunting-db:3306

In Connection.php line 822:

  SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`tpd_me  
  dia` (errno: 121 "Duplicate key on write or update") (Connection: mysql, SQ  
  L: alter table `tpd_media` add constraint `original_media_id` foreign key (  
  `original_media_id`) references `tpd_media` (`id`) on delete set null)       

In Connection.php line 580:

  SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`tpd_me  
  dia` (errno: 121 "Duplicate key on write or update")                         

Setting locale en-US
Creating database tables
Connecting to database akaunting@akaunting-db:3306

In Connection.php line 822:

  SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`2nl_me  
  dia` (errno: 121 "Duplicate key on write or update") (Connection: mysql, SQ  
  L: alter table `2nl_media` add constraint `original_media_id` foreign key (  
  `original_media_id`) references `2nl_media` (`id`) on delete set null)       

In Connection.php line 580:

  SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`2nl_me  
  dia` (errno: 121 "Duplicate key on write or update")

Slds

wstack-dev commented 9 months ago

I will also provide the MariaDB log for further insights into this problem

root@localhost:/home/docker/akaunting/docker# docker logs aa87
2023-11-21 14:32:51+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.3+maria~ubu2204 started.
2023-11-21 14:32:51+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-21 14:32:51+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.3+maria~ubu2204 started.
2023-11-21 14:32:52+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2023-11-21 14:32:52 0 [Note] Starting MariaDB 11.1.3-MariaDB-1:11.1.3+maria~ubu2204 source revision 0f5613a25f27b8034645226a48c2dc1aa4562281 as process 1
2023-11-21 14:32:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-11-21 14:32:52 0 [Note] InnoDB: Number of transaction pools: 1
2023-11-21 14:32:52 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-11-21 14:32:52 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-11-21 14:32:52 0 [Note] InnoDB: Using liburing
2023-11-21 14:32:52 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-11-21 14:32:52 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-21 14:32:52 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-11-21 14:32:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=57415320
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-88.ibd' with space ID 4772. Another data file called ./akaunting/fss_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-88.ibd' with space ID 4772. Another data file called ./akaunting/fss_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-88.ibd' with space ID 4772. Another data file called ./akaunting/fss_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4781. Another data file called ./akaunting/cik_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4781. Another data file called ./akaunting/cik_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4781. Another data file called ./akaunting/cik_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4804. Another data file called ./akaunting/cik_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4804. Another data file called ./akaunting/cik_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4804. Another data file called ./akaunting/cik_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4811. Another data file called ./akaunting/cik_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4811. Another data file called ./akaunting/cik_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4811. Another data file called ./akaunting/cik_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4814. Another data file called ./akaunting/cik_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4814. Another data file called ./akaunting/cik_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4814. Another data file called ./akaunting/cik_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4817. Another data file called ./akaunting/cik_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4817. Another data file called ./akaunting/cik_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4817. Another data file called ./akaunting/cik_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4821. Another data file called ./akaunting/cik_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4821. Another data file called ./akaunting/cik_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4821. Another data file called ./akaunting/cik_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4827. Another data file called ./akaunting/cik_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4827. Another data file called ./akaunting/cik_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4827. Another data file called ./akaunting/cik_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4828. Another data file called ./akaunting/cik_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4828. Another data file called ./akaunting/cik_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4828. Another data file called ./akaunting/cik_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4832. Another data file called ./akaunting/cik_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4832. Another data file called ./akaunting/cik_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4832. Another data file called ./akaunting/cik_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4842. Another data file called ./akaunting/cik_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4842. Another data file called ./akaunting/cik_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8a.ibd' with space ID 4842. Another data file called ./akaunting/cik_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4851. Another data file called ./akaunting/kw5_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4851. Another data file called ./akaunting/kw5_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4851. Another data file called ./akaunting/kw5_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4874. Another data file called ./akaunting/kw5_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4874. Another data file called ./akaunting/kw5_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4874. Another data file called ./akaunting/kw5_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4881. Another data file called ./akaunting/kw5_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4881. Another data file called ./akaunting/kw5_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4881. Another data file called ./akaunting/kw5_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4884. Another data file called ./akaunting/kw5_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4884. Another data file called ./akaunting/kw5_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4884. Another data file called ./akaunting/kw5_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4887. Another data file called ./akaunting/kw5_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4887. Another data file called ./akaunting/kw5_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4887. Another data file called ./akaunting/kw5_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4891. Another data file called ./akaunting/kw5_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4891. Another data file called ./akaunting/kw5_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4891. Another data file called ./akaunting/kw5_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4897. Another data file called ./akaunting/kw5_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4897. Another data file called ./akaunting/kw5_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4897. Another data file called ./akaunting/kw5_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4898. Another data file called ./akaunting/kw5_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4898. Another data file called ./akaunting/kw5_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4898. Another data file called ./akaunting/kw5_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4902. Another data file called ./akaunting/kw5_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4902. Another data file called ./akaunting/kw5_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4902. Another data file called ./akaunting/kw5_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4912. Another data file called ./akaunting/kw5_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4912. Another data file called ./akaunting/kw5_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8c.ibd' with space ID 4912. Another data file called ./akaunting/kw5_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4921. Another data file called ./akaunting/vwx_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4921. Another data file called ./akaunting/vwx_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4921. Another data file called ./akaunting/vwx_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4944. Another data file called ./akaunting/vwx_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4944. Another data file called ./akaunting/vwx_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4944. Another data file called ./akaunting/vwx_notifications.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4951. Another data file called ./akaunting/vwx_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4951. Another data file called ./akaunting/vwx_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4951. Another data file called ./akaunting/vwx_role_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4954. Another data file called ./akaunting/vwx_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4954. Another data file called ./akaunting/vwx_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4954. Another data file called ./akaunting/vwx_user_permissions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4957. Another data file called ./akaunting/vwx_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4957. Another data file called ./akaunting/vwx_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4957. Another data file called ./akaunting/vwx_user_roles.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4961. Another data file called ./akaunting/vwx_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4961. Another data file called ./akaunting/vwx_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4961. Another data file called ./akaunting/vwx_sessions.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4967. Another data file called ./akaunting/vwx_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4967. Another data file called ./akaunting/vwx_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4967. Another data file called ./akaunting/vwx_user_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4968. Another data file called ./akaunting/vwx_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4968. Another data file called ./akaunting/vwx_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4968. Another data file called ./akaunting/vwx_companies.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4972. Another data file called ./akaunting/vwx_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4972. Another data file called ./akaunting/vwx_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4972. Another data file called ./akaunting/vwx_user_dashboards.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4982. Another data file called ./akaunting/vwx_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4982. Another data file called ./akaunting/vwx_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-8e.ibd' with space ID 4982. Another data file called ./akaunting/vwx_items.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-90.ibd' with space ID 4991. Another data file called ./akaunting/jsr_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-90.ibd' with space ID 4991. Another data file called ./akaunting/jsr_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: Ignoring data file './akaunting/#sql-alter-1-90.ibd' with space ID 4991. Another data file called ./akaunting/jsr_mediables.ibd exists with the same space ID.
2023-11-21 14:32:52 0 [Note] InnoDB: End of log at LSN=67063957
2023-11-21 14:32:52 0 [Note] InnoDB: To recover: 3161 pages
2023-11-21 14:32:52 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-11-21 14:32:52 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-11-21 14:32:52 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-11-21 14:32:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-11-21 14:32:52 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-11-21 14:32:52 0 [Note] InnoDB: log sequence number 67063957; transaction id 1630998
2023-11-21 14:32:52 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-11-21 14:32:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-21 14:32:52 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-11-21 14:32:52 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-11-21 14:32:52 0 [Note] Server socket created on IP: '::'.
2023-11-21 14:32:52 0 [Note] InnoDB: Buffer pool(s) load completed at 231121 14:32:52
2023-11-21 14:32:52 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-11-21 14:32:52 0 [Note] mariadbd: ready for connections.
Version: '11.1.3-MariaDB-1:11.1.3+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution