[ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
Article ID: 247656
Updated On:
Products
Issue/Introduction
2022-08-05T18:08:05.496718Z 326 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:09:25.509740Z 318 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:10:20.192918Z 327 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:11:46.678873Z 0 [Note] [MY-011953] [InnoDB] Page cleaner took 4798ms to flush 353 and evict 0 pages
2022-08-05T18:11:52.551594Z 292 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:11:52.719022Z 0 [Note] [MY-011953] [InnoDB] Page cleaner took 4040ms to flush 64 and evict 0 pages
2022-08-05T18:18:06.522267Z 331 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:18:35.979599Z 326 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:23:19.207209Z 330 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:24:51.473522Z 330 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:29:51.856178Z 332 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:32:09.338315Z 331 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:32:52.806256Z 342 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:35:44.443490Z 352 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:35:51.782136Z 333 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:37:44.450166Z 354 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:39:53.379064Z 344 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:40:02.238758Z 333 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:40:42.663813Z 352 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:43:37.817239Z 362 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:44:39.904287Z 361 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:44:55.866599Z 359 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:45:26.288416Z 360 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:47:36.060305Z 366 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:47:43.589277Z 370 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:48:07.725791Z 374 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:48:49.802529Z 373 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:49:26.703509Z 362 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:56:26.606074Z 377 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:57:16.853176Z 358 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:57:18.477996Z 375 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T18:58:06.136411Z 381 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:01:22.469944Z 384 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:03:01.323159Z 358 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:05:18.638238Z 386 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:06:44.840289Z 373 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:15:49.544574Z 385 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:16:12.727725Z 391 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:17:19.628130Z 383 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:17:39.053155Z 377 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:18:06.507070Z 396 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:21:37.850589Z 393 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:21:43.874751Z 398 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:34:38.402749Z 413 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:37:36.944634Z 404 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:40:05.103681Z 403 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:48:13.910332Z 403 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:51:49.440850Z 427 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:52:53.214623Z 418 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:52:57.224626Z 0 [Note] [MY-011953] [InnoDB] Page cleaner took 4678ms to flush 46 and evict 0 pages
2022-08-05T19:56:40.287769Z 418 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T19:57:03.270593Z 395 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T20:01:43.472538Z 494 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T20:04:37.307603Z 492 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
2022-08-05T20:11:20.232310Z 494 [ERROR] [MY-013132] [Server] The table 'tempparentlist1' is full!
Environment
Release : 21.2
Component : DX NetOps Performance Management General
Resolution
tempparentlist1 is using memory engine type so we need increase the memory engine type values to 1G
mysql> set global max_heap_table_size = 1073741824;
mysql> set global tmp_table_size = 1073741824;
Need to exit and re-enter mysql to check values applied.
You will also need to update the /etc/my.cnf and add these lines to preserve the values.
add this under [mysqld] section of the /etc/my.cnf
max_heap_table_size = 1073741824
tmp_table_size = 1073741824
Feedback
