Error: 500

[krishnapriya]

Hello,

When I tried to add a field to Account entity, It gives me error-



2018-01-18 09:49:25 38c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-01-18 9:49:25 908 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-18 9:49:25 908 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-18 9:49:25 908 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-18 9:49:25 908 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-01-18 9:49:25 908 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-01-18 9:49:25 908 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-01-18 9:49:25 908 [Note] InnoDB: Using generic crc32 instructions
2018-01-18 9:49:25 908 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-01-18 9:49:25 908 [Note] InnoDB: Completed initialization of buffer pool
2018-01-18 9:49:25 908 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-18 9:49:25 908 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 79669999 in the ib_logfiles!
2018-01-18 9:49:25 908 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-01-18 9:49:26 908 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-18 9:49:26 908 [Note] InnoDB: Waiting for purge to start
2018-01-18 9:49:26 908 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 79669999
2018-01-18 9:49:26 13580 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-18 9:49:26 908 [Note] Plugin 'FEEDBACK' is disabled.
2018-01-18 9:49:26 908 [Note] Server socket created on IP: '::'.
2018-01-18 9:49:26 908 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.26-MariaDB' socket: '' port: 3306 mariadb.org binary distribution


This is what I saw in mysql_error_log.

Tried updating innodb_buffer_pool_size = 128M in my.ini.

Still this error happens.

Please help.

Thanks.

[krishnapriya]

And this happened only with Account entity. For other entities I can still add fields without any error

[krishnapriya]

Tried to add column directly in phpmyadmin, gives me error-



Same column I tried to add in other tables, but gives no error.

[krishnapriya]

Removed 3 columns from account and tried adding again, it worked for upto 3 columns, after that error message started to come.

Its like restricting number of columns or memory in mysql.

Please help with this issue.