Re: Creating a Baseyear Cache

Hana,

Thank you very much!!!

It seems to work now.

Lefteris
----- Original Message -----
From: "Hana Sevcikova" <hana_at_cs.washington.edu>
To: "Lefteris Samartzis" <left_at_citycable.ch>
Cc: <users_at_urbansim.org>
Sent: Monday, December 04, 2006 5:09 PM
Subject: Re: Creating a Baseyear Cache

> Lefteris,
>
> Set the field PARENT_DATABASE_URL to NULL. There is an endless iteration
> loop, since the database points to itself as parent.
>
> Hana
>
>
> On Mon, 4 Dec 2006, Lefteris Samartzis wrote:
>
>> Dear UrbanSim users,
>>
>> I am trying to create a baseyear cache from a MySql database in order to
>> launch a simulation for the first time. For now, I am just trying to run
>> a simulation using the same file and database structure as in the Eugene
>> tutorial, but with data from my new application city to keep things
>> simple.
>>
>> I have tried to create the baseyear cache using create_baseyear_cache in
>> the directory opus_core/tools, but I've run into some problems. As a
>> result, I wonder if I am doing something wrong and wonder if this is the
>> right way to create the database cache from a MySql database?
>>
>> Here is a description of what I have done and the the problems I am
>> having:
>>
>> First, I exported the baseyear cache of the modified Eugene database to
>> MySql using export_cache_to_mysql.py in eugene/tools. I exported it in a
>> database called eugene.
>>
>> Second, I changed the baseline.py configuration file in order to include
>> the link to the MySql database eugene.
>>
>> Third, I used the command :
>>
>> python create_baseyear_cache eugene.configs.baseline
>>
>>
>> At first, I received an error that the table 'scenario_information' was
>> missing. I created this table and added the requested field
>> 'PARENT_DATABASE_URL' with the value 'jdbc:mysql://localhost/eugene'
>>
>> When I tried to run create_baseyear_cache again, the following errors
>> were returned:
>>
>> ...
>> File
>> "C:\Python24\Lib\site-packages\opus_core\store\scenario_database.py",
>> line 94, in _create_table_mapping
>> self._create_table_mapping(next_database_name)
>> File
>> "C:\Python24\Lib\site-packages\opus_core\store\scenario_database.py",
>> line 94, in _create_table_mapping
>> self._create_table_mapping(next_database_name)
>> File
>> "C:\Python24\Lib\site-packages\opus_core\store\scenario_database.py",
>> line 94, in _create_table_mapping
>> self._create_table_mapping(next_database_name)
>> File
>> "C:\Python24\Lib\site-packages\opus_core\store\scenario_database.py",
>> line 70, in _create_table_mapping
>> cursor.execute(sql)
>> File "C:\Python24\Lib\site-packages\MySQLdb\cursors.py", line 163, in
>> execute
>> self.errorhandler(self, exc, value)
>> File "C:\Python24\Lib\site-packages\MySQLdb\connections.py", line 35, in
>> defaulterrorhandler
>> raise errorclass, errorvalue
>> RuntimeError: maximum recursion depth exceeded
>> >>> Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out
>> of sync; you can't run this command now") in <bound method
>> Cursor.__del__ of <MySQLdb.cursors.Cursor object at 0x0278F850>> ignored
>>
>> I use MySql 5.0 on Windows XP. Any help that anyone could provide would
>> be most appreciated.
>>
>> Thanks and all the best,
>> Lefteris
>>
Received on Mon Dec 04 2006 - 08:19:31 PST