Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Unable to copy or move issues between projects

web-app

Hi,

I'm evaluating Gemini 3.0.4 and I'm not able to copy or move issues between projects. Everytime I get a timeout. I searched the forum and found a setting to set the timeout=0, but then it just endless waits to complete. I'm using SQL2005 and I see 2 Gemini Processes, one blocking the other. I have to manually kill the SQL processes to be able to work again.

Thanks, Erik

-----------------------------------------------------------------------------------------------

 

could not execute query [ SELECT this.userid as userid560, this.username as username560, this.firstname as firstname560, this.surname as surname560, this.pwd as pwd560, this.emailaddress as emailadd6560, this.roles as roles560, this.created as created560, this.lastupdated as lastupda9560, this.ResetPWD as ResetPWD560, this.active as active560, this.comment as comment560, this.tstamp as tstamp560, this.firstname + ' ' + this.surname as formula150_ FROM geminiusers this WHERE this.username = ? ] Positional parameters: 0 ev [SQL: SELECT this.userid as userid560, this.username as username560, this.firstname as firstname560, this.surname as surname560, this.pwd as pwd560, this.emailaddress as emailadd6560, this.roles as roles560, this.created as created560, this.lastupdated as lastupda9560, this.ResetPWD as ResetPWD560, this.active as active560, this.comment as comment560, this.tstamp as tstamp560,

17/09/2008 23:12:55 at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results) at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List() at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, ISession x45b53be31e53d68b, Object[] xdbd7e0681bb13f72) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) at CounterSoft.Gemini.DataProvider.xcaaeca374ab161a3.x48e77a23dc9d1a1d(String x3f2fceb8eec5afb3) at CounterSoft.Gemini.Business.Users.GetUser(String strUserName) NHibernate

Erik
· 1
Erik
Replies (11)
helpful
0
not helpful

Can you use SQL profiler to check the statment executing? We can not seem to replicate this issue.

Check that your database is not full.

Or send us a zipped backup of your database (support at countersoft dot com)


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thanks for your reply

The requested trace file is on its way...


Erik
· 1
Erik
helpful
0
not helpful

This is the last command at the first SQL PID:

exec spexecutesql N'INSERT INTO geminiissuehistory (issueid, projectid, history, username, visibility, visibilitymembertype) VALUES (@p0, @p1, @p2, @p3, @p4, @p5); select
SCOPEIDENTITY()',N'@p0 int,@p1 int,@p2 nvarchar(12),@p3 nvarchar(12),@p4 int,@p5 int',@p0=871,@p1=2,@p2=N'Issue copied',@p3=N'Erik Vegting',@p4=1,@p5=1

And this one is being executed at the other SQL PID.

exec spexecutesql N'SELECT this.historyid as historyid500, this.issueid as issueid500, this.projectid as projectid500, this.history as history500, this.username as
username50
0, this.visibility as visibility500, this.visibilitymembertype as visibili7500, this.created as created500_ FROM geminiissuehistory this WHERE
this.issueid = @p0 ORDER BY this.created desc',N'@p0 int',@p0=868

This last command is being timed out after 30 seconds when I delete the timeout=0, otherwise it remains open untill I abort it manually.


Erik
· 1
Erik
helpful
0
not helpful

Looks to me that it's a race condition --> trying to insert and select the same table at the same time. Sometimes it works, but at our server it mostly doesn't work and the two statements block each other


Erik
· 1
Erik
helpful
0
not helpful

Did you set NHibernate to use SQL 2005 dialect?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Tried both with SQL2005 and SQL2000 dialect. (the last tests where with SQL2000 however).

 


Erik
· 1
Erik
helpful
0
not helpful

Is it possible to send us the database?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I'm happy to send you the database, but it is just the sample database you provide.


Erik
· 1
Erik
helpful
0
not helpful

Please send it anyway along with the issue id you are trying to move (and to where).

It seems like a database setting issue as all is done within 1 transaction.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi

I just installed a fresh database on my SQL Express (using SQL Server standard before) and could reproduce this error. You'll find the database with steps to reproduce in your inbox.

Thanks for your support!

Erik


Erik
· 1
Erik
helpful
0
not helpful

Ok, we have followed your steps and have recreated the bug.

Will be fixed for the next release: http://gemini.countersoft.com/Default.aspx?p=2&i=1891

Thank you for pointing it out.


Saar Cohen
· 5000
Saar Cohen