 |
hogarius
Adept
Joined: 29 Jan 2003
Posts: 221
Location: islands.genesismuds.org
|
 Posted: Sun Nov 18, 2007 2:14 am
[2.12] Database out of memory error
|
This works in v. 1.34, but not in version 2.12. I'm running XP Pro SP 2, Athlon 1000MHz processor, maxed out at 512 MB memory.
My mud has wanted posters that players can read to obtain information about criminals that the players can apprehend.
If you read a poster, then see a Non-Player Character that fits the description, you can accuse the "perp" by name and earn a cash and notoriety award.
I have a database set up that picks up the "vital statistics" from the wanted posters.
When I see a perp, I DESCRIBE him or her to see his or her description.
The database trigger extracts the vital statistics from the description of the perp and #SAYS the name that I should use to have him or her apprehended.
In version 2.12 (also versions 2.10 and 2.11), when I try to get the description of the perp I see,
MUD's output window halts for about 90 seconds, and then an Out of Memory error appears.
I can press ESC to resume MUD output, but the Out of Memory error still appears.
Here is the trigger that creates the database record in my "Perps" database when I read a poster:
| Code: |
<trigger name="BoardInfo" priority="940" id="94">
<pattern><![CDATA[Police are asking for your help to bring &{Perp.FirstName} &{Perp.LastName} to justice *. &{Perp.Pronoun} appears to be in %w &%w{Perp.AgeRange} &%w{Perp.AgeDecade}%p standing about &%d{Perp.HFt} feet and &%d{Perp.HIn} inch* tall with %w &{Perp.Build} build. %w has %w &{Perp.Fitness} fitness level, with a weight of about &%d{Perp.Weight} pounds. %w skin is &{Perp.SkinTone}. %w eyes are &{Perp.EyeColor}, and %w has &{Perp.Hair} hair.]]></pattern>
<value>#if (@Perp.Pronoun="He") {#var Perp.Gender "M"} {#var Perp.Gender "F"}
#switch @Perp.AgeDecade
"teens" {#var Perp.AgeNum "10's"}
"twenties" {#var Perp.AgeNum "20's"}
"thirties" {#var Perp.AgeNum "30's"}
"forties" {#var Perp.AgeNum "40's"}
"fifties" {#var Perp.AgeNum "50's"}
"sixties" {#var Perp.AgeNum "60's"}
"seventies" {#var Perp.AgeNum "70's"}
"eighties" {#var Perp.AgeNum "80's"}
"nineties" {#var Perp.AgeNum "90's"}
</value>
<trigger>
<pattern>^* was recently seen &{Perp.Location}.$</pattern>
</trigger>
<trigger>
<pattern>^%w is to be considered &{Perp.ThreatLevel}%p$</pattern>
<value><![CDATA[#var Duplicate (%query(&FirstName=@Perp.FirstName && &LastName=@Perp.LastName))
#if @Duplicate
{#dbput @Duplicate {Location=@Perp.Location}}
#if !@Duplicate
{#new Perps @Perp}
#wait 250]]></value>
</trigger>
</trigger>
|
Here is the trigger I use to get the description of a perp that I see on the street.
| Code: |
<trigger name="StudySuspect" priority="1010" id="101">
<pattern>You look carefully at %w &{Suspect.Adjective} &{Suspect.ManWoman} ...</pattern>
<trigger>
<pattern><![CDATA[&{Suspect.Pronoun} appears to be in %w &{Suspect.AgeRange} &{Suspect.AgeDecade}, standing about &%d{Suspect.HFt} feet and &%d{Suspect.HIn} inch* tall with %w &{Suspect.Build} build. %w has %w &{Suspect.Fitness} fitness level, with a weight of about &%d{Suspect.Weight} pounds. %w skin is &{Suspect.SkinTone}. %w eyes are &{Suspect.EyeColor}, and %w has &{Suspect.Hair} hair.]]></pattern>
</trigger>
<trigger>
<pattern>%w appears to be &{Suspect.ThreatLevel}.</pattern>
<value><![CDATA[SuspectMatch=%query((@Suspect.Weight=&Weight&&@Suspect.HFt=&HFt&&@Suspect.HIn=&HIn&&@Suspect.AgeRange=&AgeRange&&@Suspect.AgeDecade=&AgeDecade),"Perps")]]></value>
</trigger>
<trigger>
<pattern>^A*.$</pattern>
<value><![CDATA[#if @SuspectMatch<>""
{#dbget @SuspectMatch;#say "Match:";#sayprompt &FirstName &LastName}]]></value>
</trigger>
</trigger>
|
And here is some relevant text from the mud output window.
| Code: |
[French Quarter, Cul de Sac]
Underneath a canopy of flame trees, crisp water bubbles from a marble fountain which earns the Fountainbleu Park its name. A row of hibiscus surrounds a luxuriant swath of grass, where women sit on blankets as they watch laughing children play a rambunctious game of tag. Off to one side, barely visible above a ring of scarlet bougainvillea, a young man sits strumming a guitar and singing softly to a fresh-faced girl. You also see a signpost with some stuff on it.
Obvious paths: northwest, southeast.
>read sign all
[Start Of List.]
Reading a shiny card you see:
--==**** Wanted: Kelly Brophy ****==--
Police are asking for your help to bring Kelly Brophy to justice for the crime of jaywalking. She appears to be in her late seventies, standing about 6 feet and 4 inches tall with an average build. She has a very high fitness level, with a weight of about 191 pounds. Her skin is creamy. Her eyes are strange black, and she has ash brown side-ponytailed hair.
She was last seen wearing a gaudy plastic jacket, a drawstring skirt, a pair of striking kiwi green high heels, and a trendy hemp necklace.
Kelly Brophy was recently seen near the Rue des Barbares in French Quarter.
She is to be considered not at all dangerous.
Reading a soggy paper you see:
--==**** Wanted: Steven Lynch ****==--
Police are asking for your help to bring Steven Lynch to justice for the crime of public intoxication. He appears to be in his early forties, standing about 5 feet and 5 inches tall with a husky build. He has a low fitness level, with a weight of about 203 pounds. His skin is ruddy. His eyes are coffee, and he has dark blonde cropped hair.
He was last seen wearing a black leather jacket with several zippered pockets, a pair of tan flare-leg bellbottoms, a pair of red canvas high-tops, and a gaudy purple and orange fanny pack.
Steven Lynch was recently seen near the Dirt Path.
He is to be considered not at all dangerous.
Reading a stained notice you see:
--==**** Wanted: Etta Wallace ****==--
Police are asking for your help to bring Etta Wallace to justice for the crime of jaywalking. She appears to be in her mid seventies, standing about 6 feet and 1 inch tall with a trim build. She has a very high fitness level, with a weight of about 176 pounds. Her skin is ruddy. Her eyes are stormy grey, and she has golden blonde pigtailed hair.
She was last seen wearing a smooth black silk dress shirt, a pair of puce polyester bellbottoms, a pair of sexy black stilettos with ankle straps, and a pair of brown horn-rimmed bifocals.
Etta Wallace was recently seen near the Rue des Barbares in French Quarter.
She is to be considered not at all dangerous.
Reading a soggy flyer you see:
--==**** Wanted: Anthony Pryor ****==--
Police are asking for your help to bring Anthony Pryor to justice for the crime of public intoxication. He appears to be in his late forties, standing about 5 feet and 1 inch tall with a trim build. He has a very low fitness level, with a weight of about 146 pounds. His skin is chocolate. His eyes are blue, and he has midnight black wavy hair.
He was last seen wearing a shiny lime green soccer jersey, a pair of brown corduroy shorts, a pair of classic brown cowboy boots, and a tall white chef hat.
Anthony Pryor was recently seen near the Dirt Path.
He is to be considered not at all dangerous.
Reading a ugly card you see:
--==**** Wanted: Abu Picardi ****==--
Police are asking for your help to bring Abu Picardi to justice for the crime of public vulgarity. He appears to be in his mid teens, standing about 6 feet and 3 inches tall with a thin build. He has a very low fitness level, with a weight of about 159 pounds. His skin is freckled. His eyes are slate, and he has midnight black unkempt hair.
He was last seen wearing a black t-shirt with "Just Say NO to Chavez!" printed on it in white letters, a Scottish-style tartan kilt, a pair of sturdy black knee-high combat boots, and a stormy-hued mood ring.
Abu Picardi was recently seen near the Hidden Path in French Quarter.
He is to be considered not at all dangerous.
Done!
>nw
[French Quarter, Cul de Sac]
Underneath a canopy of stately silver birches sits a colonial French house surrounded by an ornate wrought iron fence. Flower boxes brimming with hibiscus line the shuttered windows, and a verdant garden blooms brightly in a clearing to one side of the house. On the prim, white porch a cat lolls in a pool of dappled sunlight. A warm aroma of fresh-baked bread floats through the open windows on the first floor, where gingham curtains flutter in the breeze. You also see crumbling steps.
Obvious paths: north, southeast.
>n
[French Quarter, Cul de Sac]
In the narrow field surrounded by silver birch trees, a blanket of yellow celandines lays thick upon the ground. Purple and white crocus blossoms bob their heads over a thin creek curling through the field. Shafts of delicious sunlight streak through the transparent leaves of the birches, and brightly glint upon the water as it peaks atop rocks lying in the creek bed. Overhead, birds fly in lazy circles and light on branches, their chirping voices filling the field with lilting song. You also see a small gate at the end of a meandering path.
Obvious paths: north, south.
>n
[French Quarter, Cul de Sac]
An ornately carved wooden pipe hangs from the awning of the tobacco shop and sways as visitors pass through the shop's door. From inside pours the rich scent of flavored tobacco, the smells of cherry, vanilla and smoke mingling in the air. Neat potted flowers stand in a row under the window, where boxes of imported cigarettes and silver lighters sit on display. You also see a door.
Obvious paths: south, northeast.
>ne
[French Quarter, Cul de Sac]
Newspapers flutter from display racks lining the front of the kiosque, their pages rustling noisily as they whip in the breeze. An old woman stands thumbing through the morning edition, her market basket sitting on the ground between her feet. She nods conversationally to the manager of the kiosque standing outside the front door, grey smears of newsprint streaked across his canvas apron.
Obvious paths: north, southwest.
>read kio all
[Start Of List.]
Reading a huge paper you see:
--==**** Wanted: Cade Wagner ****==--
Police are asking for your help to bring Cade Wagner to justice for the crime of animal cruelty. He appears to be in his mid fifties, standing about 5 feet and 6 inches tall with a husky build. He has a very low fitness level, with a weight of about 215 pounds. His skin is ruddy. His eyes are green, and he has golden blonde tangled hair.
He was last seen wearing a smooth black silk dress shirt, a pair of ripped jeans, a pair of light blue canvas sneakers, and an expensive brown leather satchel.
Cade Wagner was recently seen near La Blague a Tabac.
He is to be considered not at all dangerous.
Reading a soggy flyer you see:
--==**** Wanted: Dominique Turner ****==--
Police are asking for your help to bring Dominique Turner to justice for the crime of pimping. She appears to be in her early forties, standing about 5 feet and 8 inches tall with a trim build. She has a high fitness level, with a weight of about 159 pounds. Her skin is freckled. Her eyes are strange black, and she has ice blonde French-braided hair.
She was last seen wearing a bulky orange life vest over a soaking wet t-shirt, a natty grey knee-length twill skirt, a pair of leather walking sandals, and a pair of wire-rimmed eyeglasses.
Dominique Turner was recently seen near the Avenue du Graces in French Quarter.
She is to be considered not at all dangerous.
Reading a rumpled card you see:
--==**** Wanted: Larry Gates ****==--
Police are asking for your help to bring Larry Gates to justice for the crime of animal cruelty. He appears to be in his early forties, standing about 6 feet and 1 inch tall with a trim build. He has a very high fitness level, with a weight of about 186 pounds. His skin is pasty. His eyes are blue-gray, and he has copper wild hair.
He was last seen wearing a shiny black rayon shirt, a pair of torn sweatpants, a pair of fringed moccasins, and a gaudy purple and orange fanny pack.
Larry Gates was recently seen near the Avenue du Graces in French Quarter.
He is to be considered not at all dangerous.
Done!
>n
e
[French Quarter, Avenue du Graces]
Grey apartments stand on both sides of the street, their fronts crowded with narrow wrought iron balconies. Laundry flaps from the railings on several floors, while gauzy curtains billow through the open windows higher up. Old men gathered on the stoop of one building smoke their cigarettes and talk with animated gestures, their voices rising to drown out the noise of passing cars. You also see the entrance to the French Graces Apartments and the Avenue du Graces apartment building.
Obvious paths: south, east.
>
[French Quarter, Avenue du Graces]
Patches of dried earth glare through holes in the cobblestone pavement. Unkempt trees lean toward the buckled sidewalk, their encroaching limbs causing pedestrians to step from the curb into the littered gutter. Several feet away stands a black iron fence, its twisted posts dotted with patches of sickly orange rust. You also see an imposing blackened titanium gate leading down a twisting lane to a looming gothic mansion, a narrow red door and a paved walk.
Obvious paths: east, west.
>
An odd-looking woman just walked in.
>describe wo [NOTE: OUT OF MEMORY ERROR OCCURS AT THIS POINT]
You look carefully at an odd-looking woman ...
She appears to be in her early forties, standing about 5 feet and 8 inches tall with a trim build. She has a high fitness level, with a weight of about 159 pounds. Her skin is freckled. Her eyes are strange black, and she has ice blonde French-braided hair.
She is wearing a bulky orange life vest over a soaking wet t-shirt, a natty grey knee-length twill skirt, a pair of leather walking sandals, and a pair of wire-rimmed eyeglasses.
She appears to be not at all dangerous.
She is holding nothing.
An odd-looking woman has no wounds.
>
|
I'd greatly appreciate any help or advice. |
|
|
|
|
Tech
GURU
Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA
|
Posted: Mon Nov 19, 2007 10:13 am
|
I tried this and didn't get an error. Granted I didn't bother setting up a the DB either. So couple of questions...
How many records do you have in your perp and suspect databases? Do you get this error on a blank database? Do you get it when you study perps, or study suspects?
Do you have the correct database open and loaded? Is the database window open? |
|
_________________
Asati di tempari! |
 |
|
|
hogarius
Adept
Joined: 29 Jan 2003
Posts: 221
Location: islands.genesismuds.org
|
Posted: Mon Nov 19, 2007 12:42 pm
|
It's just one database, named Perps. "Suspect" is a single database variable with fields that correspond to the Perp records.
I get the error when I "study" a suspect and try to match the data with a record in the Perp database.
Reading the posters into the database works fine; the problem comes in when I see a actual suspect
and try to match the suspect's info with a Perp record. (See the line I added above in capital letters
in the MUD output that shows where the error occurs.)
I also have routines that delete out individual Perp records when they are apprehended by myself or someone else,
and I have a "clean" routine that removes all Perp records before I do a session of bounty hunting.
Maximum number of records in the database is 30 or so.
I have an alias that turns the database routines on, and I manually open the database after I run that alias.
I may try deleting and recreating the database, if I have the opportunity. |
|
|
|
|
Tech
GURU
Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA
|
Posted: Mon Nov 19, 2007 4:07 pm
|
PM or email me your databases and I'll take a closer look at it. It may be something specific to query or the database file itself.
|
|
_________________
Asati di tempari! |
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
