Skip to Content
4
Former Member
Aug 06, 2014 at 03:01 PM

mysql init issue, permission denied

366 Views

Hey @all

Im facing a weird issue with the initialization on mysql db. mid of development (sprint5) out of the blue i had strange errors during the initialization.

Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ CREATE TABLE regions ( hjmpTS BIGINT, TypePkString BIGINT, OwnerPkString BIGINT, modifiedTS DATETIME, createdTS DATETIME, PK BIGINT, activeflag TINYINT(1), isocode VARCHAR(255) NULL, countrypk BIGINT, p_isocodeshort VARCHAR(255) NULL, aCLTS BIGINT DEFAULT 0, propTS BIGINT DEFAULT 0, PRIMARY KEY (PK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin]; SQL state [HY000]; error code [7]; Error on rename of '.\hybris_msg#sql-58bc_15.frm' to '.\hybris_msg\prodsforprodcarcomprels.frm' (Errcode: 13 - Permission denied); nested exception is java.sql.BatchUpdateException: Error on rename of '.\hybris_msg#sql-58bc_15.frm' to '.\hybris_msg\prodsforprodcarcomprels.frm' (Errcode: 13 - Permission denied)

SOLUTION

however we were not exactly able to say what caused the problem but after multiple wiping database and changing innoDB configs and disabling local AV-Guard the initialization run again.

It worked before perfect with Kaspersky so no clue what changed, but if anyone facing the same problem hope this helps.

regards

Joel