The Ultimate Guide to High Availability with MariaDB

Comments - The table have issue. select is empty but can't insert more data

4 years, 6 months ago Hoang Bang
Re: The table have issue. select is empty but can't insert more data
This comment has the status of 'removed' and can only be seen by you.

Hi Gilfillan, I have 2 table: ./aggr.exe -D LAN64 -M ags -S DAILY -T WEEKLY -r yes -l /opt/vs/vscommon/webroot/logs -s "2020-06-07" -e "2020-06-14"

CREATE TABLE `table2` ( `DSID` INT(11) NOT NULL, `PollingPeriod` INT(11) NOT NULL, `MinPeriod` INT(11) NOT NULL DEFAULT '120', `Enabled` TINYINT(4) NOT NULL DEFAULT '1', `Version` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`DSID`), CONSTRAINT `FK_Table2Table1DSID` FOREIGN KEY (`DSID`) REFERENCES `table1` (`DSID`) ON DELETE CASCADE ) COLLATE='latin1_swedish_ci' ENGINE=InnoDB

CREATE TABLE "table1" ( "DSID" INT NOT NULL, "Dataset" VARCHAR(8) NOT NULL, "Collector" VARCHAR(32) NULL DEFAULT NULL, "resType" INT NOT NULL, "StatTablePrefix" VARCHAR(8) NULL DEFAULT NULL, "datasetDescription" VARCHAR(80) NULL DEFAULT NULL, "datasetWeight" INT NOT NULL DEFAULT '0', "typeGroupID" INT NULL DEFAULT NULL, "summarySectionTitle" VARCHAR(128) NULL DEFAULT ' ', "DatasetType" TINYINT NULL DEFAULT NULL, "NoAutoInsert" BIT NOT NULL DEFAULT b'0', "NoAutoName" BIT NOT NULL DEFAULT b'0', "SpeedUnit" VARCHAR(8) NULL DEFAULT NULL, "AggrOrder" INT NULL DEFAULT '2', "PrimaryTrend" VARCHAR(32) NULL DEFAULT NULL, "ShortDescription" VARCHAR(16) NULL DEFAULT NULL, "QueryViewFlag" BIT NOT NULL DEFAULT b'0', "ResourceDSID" INT NULL DEFAULT NULL, "ConfigData" BIT NOT NULL DEFAULT b'0', "devAddrType" INT NOT NULL DEFAULT '0', PRIMARY KEY ("DSID") )

- The table1 storage some configuration information - After TRUNCATE TABLE the table2. I immediately inserted additional data for this table. but the DUP PRIMARY KEY error is reported. although when I SELECT TABLE and the result returns no lines. But I think somewhere in the database still caches the data cache of this table

I want to ask what is the problem with table2? Can we check what is happening in table2? And how to solve the problem?

Thanks, Bang Hoang

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.