I got shmat issues...

**cavedude** · #1 10-21-2007, 10:37 AM

The following changes are needed:

Code:

update items set stackable = 1 where clickeffect = -1 and maxcharges = 1;
update items set stackable = 1 where itemtype in (14,18,28,55,15,19,37,56,17,27,38,53,21);
update items set casttime = casttime_;
update items set stackable = 1 where name like 'Spell:%' and itemtype = 20;
update items set slots = 2097152 where slots = 4194304;

Some more itemtypes were added as being stackable, food/drink consumption is fixed, and many ammo slot items are now fixed. The players on PEQ didn't really find any other bugs with the new table so after this update all should be good. If more updates are needed, however I will post.

**cavedude** · #2 10-22-2007, 12:56 AM

More fixes bard spells and items:

Code:

update items set slots = 2099200 where slots = 4196352;
update items set stackable = 1 where name like 'Song:%' and itemtype = 20;

John Adams · #3 10-23-2007, 01:57 AM

Excellent guys, thank you for bringing this to a conclusion.

Cavedude, are the updates you mentioned in the peq-db svn? If so, I'll just continue to source from there. Thanks again!

**cavedude** · #4 10-23-2007, 02:32 AM

They will be by the end of the day

John Adams · #5 10-23-2007, 03:08 AM

A temporary solution appears to be running this on my Linux FC4 server:

Code:

echo 83886080 > /proc/sys/kernel/shmmax

This sets my current shared memory at 80mb, but when I reboot it will go back to the default 32mb. This is where things get scarey with Linux for me; the perma fix is to change Kernel source and recompile. I have never done this, and I will certainly screw things up

Some general info about making this change permanent (related to installing Ingres, but still informative):

Quote:

3.3. Kernel Parameters
The default settings of the Linux kernel are adequate for a development Ingres environment. For a live system, however, probably to increase the size of the database cache(s), you may want to change the built-in value of the SHMMAX parameter. This parameter sets the maximum size of a shared memory segment. By default, it is 32 Mb which allows for a somewhat lesser buffer cache.

You have two choices to change the value of SHMMAX:

As root, simply echo the new value into /proc/sys/kernel/shmmax:

Code:

#echo 83886080 > /proc/sys/kernel/shmmax

In the example above, we set the value of SHMMAX to 80 Mb. The change takes effect immediately but after a reboot, the original value is restored.

The other possibility is to change SHMMAX's default value in the kernel source (the relevant header file is /usr/src/linux/include/asm/shmparam.h if you have installed the source). In this case, you may also have to modify other parameters in the file, then rebuild the kernel. I suggest you do it only if you know what you are doing. For information on how to configure and compile the kernel see The Linux Kernel HOWTO by Brian Ward.

Source: http://www.linux.com/base/ldp/howto/...TO/sysreq.html

If I figure it out, I'll post it. I cannot imagine I am the only one with this problem... but maybe a newer distro could solve it?

**WildcardX** · #6 10-23-2007, 05:24 AM

I know openSUSE 10.3 doesnt have this problem. Actually its really not a "problem", its just a configuration. But if you are asking if there is a distro that doesnt need to have this configuration adjusted out of the box, then I know openSUSE 10.3 is one that doesn't need to be.

**cavedude** · #7 10-23-2007, 01:54 PM

Grandmaster items:

Code:

update items set slots = 2123776 where slots = 4220928;