This is what I receive: If I did it correctly. mysql> SELECT * FROM request; +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+ | id | stateid | userid | laststateid | logid | forimaging | test | preload | start | end | daterequested | datemodified | checkuser | +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+ | 1 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-29 10:19:42 | 2015-04-29 11:19:42 | 2015-04-29 10:19:42 | NULL | 1 | | 2 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-29 10:25:54 | 2015-04-29 11:25:54 | 2015-04-29 10:25:54 | NULL | 1 | | 3 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-29 10:36:29 | 2015-04-29 11:36:29 | 2015-04-29 10:36:29 | NULL | 1 | | 4 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-29 21:13:30 | 2015-04-29 22:13:30 | 2015-04-29 21:13:30 | NULL | 1 | | 5 | 14 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-30 07:34:47 | 2015-04-30 08:34:47 | 2015-04-30 07:34:47 | NULL | 1 | | 6 | 14 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-30 10:47:19 | 2015-04-30 11:47:19 | 2015-04-30 10:47:19 | NULL | 1 | | 7 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-04-30 11:20:29 | 2015-04-30 12:20:29 | 2015-04-30 11:20:29 | NULL | 1 | | 19 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-05-01 09:31:56 | 2015-05-01 10:31:56 | 2015-05-01 09:31:56 | NULL | 1 | | 22 | 10 | 1 | 16 | 0 | 0 | 0 | 0 | 2015-05-01 19:20:32 | 2015-05-01 20:20:32 | 2015-05-01 19:20:32 | NULL | 1 | +----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+-----------+ 9 rows in set (0.00 sec)
On Mon, May 4, 2015 at 10:26 AM, Aaron Peeler <[email protected]> wrote: > Yes, you will need to look at the request table in the database. > > Either using phpmyadmin or via the mysql cmdline. > > Aaron > > On Fri, May 1, 2015 at 3:02 PM, Elwin Litchfield <[email protected]> > wrote: > > There isn't any failed reservations or reservations in the Current > > Reservations tab. Is there another place I should be looking? > > > > Thanks. > > > > Lewis > > > > On Fri, May 1, 2015 at 1:29 PM, Josh Thompson <[email protected]> > > wrote: > >> > >> -----BEGIN PGP SIGNED MESSAGE----- > >> Hash: SHA1 > >> > >> Elwin, > >> > >> > > >> > |12:44:32|3671|25:25|new|new.pm: > computer_not_being_used(783)|Xen3Cent6VCLw1 > >> > |is NOT available, it is assigned to an existing imaging reservation: > >> > >> This makes me think you probably have an existing, failed imaging > >> reservation > >> still in your database. If you are not currently trying to create any > >> images, > >> you can delete any existing imaging reservations out of your database. > >> Those > >> would have request.stateid or request.laststateid set to 16 (image). > >> > >> Josh > >> - -- > >> - ------------------------------- > >> Josh Thompson > >> VCL Developer > >> North Carolina State University > >> > >> my GPG/PGP key can be found at pgp.mit.edu > >> > >> All electronic mail messages in connection with State business which > >> are sent to or received by this account are subject to the NC Public > >> Records Law and may be disclosed to third parties. > >> -----BEGIN PGP SIGNATURE----- > >> Version: GnuPG v2 > >> > >> iEYEARECAAYFAlVDt/kACgkQV/LQcNdtPQOgjwCeNkzBcz+u1wmASdNknW/0c8IP > >> oWUAn1pyfRsTtpa7bUFw+QRvUC8Dxs5i > >> =H0mO > >> -----END PGP SIGNATURE----- > >> > > > > > > -- > Aaron Peeler > Program Manager > Virtual Computing Lab > NC State University > > All electronic mail messages in connection with State business which > are sent to or received by this account are subject to the NC Public > Records Law and may be disclosed to third parties. >
