Score:0

SQL Error (1114): The table 'global_priv' is full

in flag

I can no longer add users to my database. I only get the error:

SQL Error (1114): The table 'global_priv' is full

I researched this issue, and the my.ini config for innodb_data_file_path did not have a cap. But I also tried setting it to 2GBs, but still to no avail:

innodb_data_file_path=ibdata1:10M:autoextend:max:2048M

I also have plenty of space on the drive mysql is installed on. Aside from that, my global_priv table has a total of 7 rows.

Specifically, I'm using XAMPP 7.4.27 on Windows 10 x64, with MariaDB 10.4.22.

ua flag
"max" is a relic of the old days, when disks were only a few GB. Get rid of that part of the config. Meanwhile, how big is the file `ibdata1`? How much free disk do you have? How big is global_priv (probably in the subdirectory "mysql").
in flag
Thanks for the input, Rick James. ibdata1 is 77MBs, global_priv.frm is only 2KBs, and they're on a drive with 93GBs available, which is why I suspect something else is wrong..
ua flag
Did you restart after changing the `max:`?
in flag
Yes, I restarted after every change.
danblack avatar
dz flag
[out of ram](https://dba.stackexchange.com/questions/198569/the-table-is-full-mariadb)? I can't see anything in the bug report. Try to upgrade to [10.4 latest](https://mariadb.com/kb/en/release-notes-mariadb-104-series/) and otherwise [report a bug](https://jira.mariadb.org)
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.