Hi, I had POSTed a question(https://groups.google.com/forum/?fromgroups=#!topic/sqlalchemy/vCjrGE9zYwQ) related to session/engine cleanup.
After fixing the engine cleanup. I could see that engine and its associated objects are GCed properly. However process memory is gradually increasing. I am creating and destroying session/engine every 30 secs. SQLAlchemy usage: Every 30 sec following happens. *engine = create_engine(...)* *sn = Session(bind=engine)...* *try:* * sn.merge* * sn.commit* *finally:* * sn.close()* * sn.bind.dispose()* *>>> sn and engine don't have any reference after this point ....* * * * * GC objects after some runs are listed below, Looks like some items are increasing in memory(in BOLD). *Is this some kind of leak ?* <class 'sqlalchemy.util._collections.OrderedDict'>: last:176 curr:198 diff:22 <type 'builtin_function_or_method'>: last:900 curr:914 diff:14 <class 'sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2'>: last:31 curr:38 diff:7 <class 'sqlalchemy.types.NullType'>: last:32 curr:39 diff:7 <type 'instancemethod'>: last:605 curr:627 diff:22 <class 'sqlalchemy.types.Text'>: last:177 curr:254 diff:77 * <class 'sqlalchemy.dialects.postgresql.psycopg2._PGArray'>: last:120 curr:197 diff:77* *<class 'sqlalchemy.sql.expression._BindParamClause'>: last:658 curr:954 diff:296* <class 'sqlalchemy.util._collections.PopulateDict'>: last:60 curr:82 diff:22 <type 'list'>: last:3308 curr:3462 diff:154 <type 'instance'>: last:139 curr:146 diff:7 <class 'sqlalchemy.dialects.postgresql.base.PGTypeCompiler'>: last:31 curr:38 diff:7 <class 'sqlalchemy.dialects.postgresql.psycopg2.PGIdentifierPreparer_psycopg2'>: last:31 curr:38 diff:7 <type 'dict'>: last:10930 curr:12172 diff:1242 <class 'sqlalchemy.dialects.postgresql.psycopg2.PGCompiler_psycopg2'>: last:60 curr:82 diff:22 *<class 'sqlalchemy.types.String'>: last:571 curr:753 diff:182* * <class 'sqlalchemy.types.DateTime'>: last:92 curr:113 diff:21* <type 'weakref'>: last:2204 curr:2582 diff:378 <type 'tuple'>: last:29850 curr:30231 diff:381 <type 'cell'>: last:747 curr:978 diff:231 <class 'sqlalchemy.types.Integer'>: last:52 curr:59 diff:7 <type 'function'>: last:8077 curr:8392 diff:315 Thanks Anoop * * -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/gESaFAd9DHkJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
