故障报告

1. 问题（故障）描述

CREATE TABLE IF NOT EXISTS hana_history.%s  (
    id int(11) NOT NULL AUTO_INCREMENT,
    table_name varchar(255),
    dataacct int(11) NULL DEFAULT NULL,
    batch_num int(11) NULL DEFAULT NULL,
    status boolean NULL DEFAULT NULL,
    PRIMARY KEY (id)
    );

创建表时报错：

inotify cannot be used, reverting to polling: Too many open files

2. 问题（故障）原因

3. 解决

修改sysctl.conf

fs.inotify.max_user_watches=1048576
fs.inotify.max_user_instances=1048576

4. 参考