Error 42Y55
Hi, I am getting the ij drop table tableName; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName' because it does not exist. ij exit But, the table exists. I verified using sys.systables. what could be the reason. I am using netbeans to generate hibernate mappings. I also open command windows for server and another for connecting through ij apart from netbeans. I closed netbeans. I restarted the server. Tried to drop the table. Still I am getting the same error. any body please help. -- Yours Sincerely, Sridhar
Re: Error 42Y55
Perhaps you want to use: drop table tableName On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha devatha.srid...@gmail.comwrote: Hi, I am getting the ij drop table tableName; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName' because it does not exist. ij exit But, the table exists. I verified using sys.systables. what could be the reason. I am using netbeans to generate hibernate mappings. I also open command windows for server and another for connecting through ij apart from netbeans. I closed netbeans. I restarted the server. Tried to drop the table. Still I am getting the same error. any body please help. -- Yours Sincerely, Sridhar
Re: Checking if a db is open without actually opening it
Donald McLean wrote: The easiest thing would probably be to look for the lock file. Need to do it across the network, so that won't be easy. Thanks for the suggestion though! -- Alan Burlison --
Error 42Y55
Hi, I set up network derby server on my local machine(win xp pro sp3). I started the server in one command window. I started accessing the data base from another command window using ij. I am not using embedded mode. I have a table in my schema. I am unable to drop it. ERROR 42Y55: 'DROP TABLE' cannot be performed on 'currentassets' because it does not exist. How can I create a database in a different directory other than home directoy. i am unable to start the network server using derbyrun.jar and derbynet.jar I am only able to start the database using batch file. Please help. I am unable to retain the responses in my inbox. bye sridhar -- Yours Sincerely, Devatha Sridhar
Re: Checking if a db is open without actually opening it
hi donald mclean and alan burlison, thank you for your help. may god do good to you all. whatever you said abt this error is correct. removing lock file helped me. but. please anybody answer my remaining questions. it would be great help. I suggest adding these solutions to documentation files like getting started guide, reference manuals , developer guide will help reduce the mailing list traffic. On Sat, Jul 4, 2009 at 12:52 PM, Alan Burlison alan.burli...@sun.comwrote: Donald McLean wrote: The easiest thing would probably be to look for the lock file. Need to do it across the network, so that won't be easy. Thanks for the suggestion though! -- Alan Burlison -- -- Yours Sincerely, Devatha Sridhar
error 42Y55
hi, I set up network derby server on my local machine(win xp pro sp3). I started the server in one command window. I started accessing the data base from another command window using ij. I am not using embedded mode. I have few tables in my schema. *I am unable to drop only one user table.* *But, i am able to drop all other user tables.* ERROR 42Y55: 'DROP TABLE' cannot be performed on 'currentassets' because it does not exist. How can I create a database in a different directory other than home directoy. i am unable to start the network server using derbyrun.jar and derbynet.jar I am only able to start the database using batch file. I am unable to retain the responses in my inbox. Please help. -- Yours Sincerely, Sridhar
Re: Error 42Y55
Peter Ondruška wrote: Perhaps you want to use: drop table tableName On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha devatha.srid...@gmail.com mailto:devatha.srid...@gmail.com wrote: Hi, I am getting the ij drop table tableName; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName' because it does not exist. The default schema corresponds to the name of the user that connected (or APP if there is no user). Perhaps your table is in a different schema. If you created the table as USER1 and are now connected as USER2, you may want to try ij drop table USER1.TABLENAME; Kathey
Re: Checking if a db is open without actually opening it
sridhar devatha wrote: whatever you said abt this error is correct. removing lock file helped me. Please never remove the lock file or any file under the database directory manually. Removing the lock file will allow dual boot which will corrupt your database. Kathey
Re: locking problem
Robert J. Carr rjc...@gmail.com writes: Hi Jeff- It initially happened in 10.3.2.1, but I just updated to 10.5.1.1 and the same problem exists. And I may have mentioned in the original post it was a table lock, and I don't know if I misread it initially or if something changed when I updated derby, but it seems to be a row lock. Here's a condensed version of the lock trace: java.sql.SQLException: A lock could not be obtained within the time requested. The lockTable dump is: XID |TYPE |MODE |LOCKCOUNT |LOCKNAME |STATE |TABLENAME *** The following row is the victim *** 5222 |ROW|X|0 |(2,38) |WAIT |SG_TRACKS *** The above row is the victim *** 5104 |ROW|S|1 |(2,38) |GRANT |SG_TRACKS 5104 |TABLE |IS |1 |Tablelock |GRANT |SG_TRACKS 5222 |TABLE |IX |2 |Tablelock |GRANT |SG_TRACKS If you run with derby.language.logStatementText=true you'll be able to find in derby.log which statements a transaction with a particular XID has executed. This may help you track down the runaway transaction that's holding onto the shared row lock. -- Knut Anders
Re: Checking if a db is open without actually opening it
Kathey Marsden wrote: Please never remove the lock file or any file under the database directory manually. Removing the lock file will allow dual boot which will corrupt your database. On a slightly related note, I'm struggling to get replication to work, getting an error when I start up the slave: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE09, SQLERRMC: Cannot start replication slave mode for database 'opensolaris'. The database has already been booted. [XRE09] It hasn't - I started the slave with no database directory at all, so there is no way it could be locked. I think this error is because I'm copying everything under the database directory from the master to the slave, and that includes the lock files. The replication documents just say to freeze the master and then 'Copy the database to the slave location', I think they need to be more explicit about exactly what files need to be copied from the master to the slave. -- Alan Burlison --
Re: locking problem
Thanks Knut ... that's the exact sort of thing I was looking for. I'll test it next week and post a follow-up then. On Sat, Jul 4, 2009 at 12:04 PM, Knut Anders Hatlenknut.hat...@sun.com wrote: Robert J. Carr rjc...@gmail.com writes: Hi Jeff- It initially happened in 10.3.2.1, but I just updated to 10.5.1.1 and the same problem exists. And I may have mentioned in the original post it was a table lock, and I don't know if I misread it initially or if something changed when I updated derby, but it seems to be a row lock. Here's a condensed version of the lock trace: java.sql.SQLException: A lock could not be obtained within the time requested. The lockTable dump is: XID |TYPE |MODE |LOCKCOUNT |LOCKNAME |STATE |TABLENAME *** The following row is the victim *** 5222 |ROW |X |0 |(2,38) |WAIT |SG_TRACKS *** The above row is the victim *** 5104 |ROW |S |1 |(2,38) |GRANT |SG_TRACKS 5104 |TABLE |IS |1 |Tablelock |GRANT |SG_TRACKS 5222 |TABLE |IX |2 |Tablelock |GRANT |SG_TRACKS If you run with derby.language.logStatementText=true you'll be able to find in derby.log which statements a transaction with a particular XID has executed. This may help you track down the runaway transaction that's holding onto the shared row lock. -- Knut Anders
