Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

3.6.6 Upgrade issue #132

Closed
pdxmaverick opened this issue Feb 7, 2014 · 2 comments · Fixed by #403
Closed

3.6.6 Upgrade issue #132

pdxmaverick opened this issue Feb 7, 2014 · 2 comments · Fixed by #403

Comments

@pdxmaverick
Copy link

Unexpected Error on https://portal.nwax.net/ixp/switch/list

Upgraded to 3.6.6 from working 3.6.5
1954 git fetch
1955 git checkout v3.6.6

Added mysql

mysql> select * from switch
-> ;
+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
| id | infrastructure | cabinetid | vendorid | name | hostname | ipv4addr | ipv6addr | snmppasswd | switchtype | model | active | os | osDate | osVersion | serialNumber | lastPolled | notes |
+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
| 1 | 1 | 1 | 13 | ex4500 | ex4500.nwax.net | 10.99.9.21 | | XxXxX | 1 | Unknown | 1 | Unknown | NULL | Unknown | NULL | 2014-02-01 01:08:12 | |
| 3 | 1 | 1 | 13 | ptk-fabric-nwax-1 | ptk-fabric-nwax-1.nwax.net | 10.99.9.22 | | XxXxX | 1 | ex4500-40f | 1 | JUNOS | 2013-06-14 01:37:19 | 12.3R3.4 | NULL | 2014-02-06 15:32:48 | |
| 4 | 1 | 2 | 1 | lpt-fabric-nwax-1 | lpt-fabric-nwax-1 | 10.99.9.31 | | XxXxX | 1 | C29xx Stacking | 1 | IOS | NULL | 12.2(58)SE2 | NULL | 2014-02-06 15:31:53 | |
+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
3 rows in set (0.00 sec)

2014-02-07T10:42:23-08:00 DEBUG (7) [184.76.92.213]: ErrorController::errorAction()
2014-02-07T10:42:23-08:00 ERR (3) [184.76.92.213]:


****************************** EXCEPTIONS *******************************


--------------------------- EXCEPTION --------------------------

Message: [Semantical Error] line 0, col 413 near 'serialNumber': Error: Class Entities\Switcher has no field or association named serialNumber
Line: 49
File: /usr/share/php/Doctrine/ORM/Query/QueryException.php

Trace:
#0 /usr/share/php/Doctrine/ORM/Query/Parser.php(429): Doctrine\ORM\Query\QueryException::semanticalError('line 0, col 413...', Object(Doctrine\ORM\Query\QueryException))
#1 /usr/share/php/Doctrine/ORM/Query/Parser.php(645): Doctrine\ORM\Query\Parser->semanticalError('Class Entities...', Array)
#2 /usr/share/php/Doctrine/ORM/Query/Parser.php(240): Doctrine\ORM\Query\Parser->_processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement))
#3 /usr/share/php/Doctrine/ORM/Query/Parser.php(304): Doctrine\ORM\Query\Parser->getAST()
#4 /usr/share/php/Doctrine/ORM/Query.php(233): Doctrine\ORM\Query\Parser->parse()
#5 /usr/share/php/Doctrine/ORM/Query.php(245): Doctrine\ORM\Query->_parse()
#6 /usr/share/php/Doctrine/ORM/AbstractQuery.php(737): Doctrine\ORM\Query->_doExecute()
#7 /usr/share/php/Doctrine/ORM/AbstractQuery.php(538): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#8 /usr/local/ixp/application/controllers/SwitchController.php(156): Doctrine\ORM\AbstractQuery->getResult()
#9 /usr/local/ixp/library/OSS-Framework.git/OSS/Controller/Action/Trait/Doctrine2Frontend.php(190): SwitchController->listGetData()
#10 /usr/local/ixp/library/Zend/Controller/Action.php(516): IXP_Controller_Frontend->listAction()
#11 /usr/local/ixp/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('listAction')
#12 /usr/local/ixp/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /usr/local/ixp/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#14 /usr/local/ixp/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#15 /usr/local/ixp/public/index.php(85): Zend_Application->run()
#16 {main}

Array
(
[0] => Array
(
[file] => /usr/local/ixp/library/OSS-Framework.git/OSS/Controller/Trait/Error.php
[line] => 78
[function] => compact_debug_backtrace
[class] => OSS_Debug
)

[1] => Array
    (
        [file] => /usr/local/ixp/library/Zend/Controller/Action.php
        [line] => 516
        [function] => errorAction
        [class] => ErrorController
    )

[2] => Array
    (
        [file] => /usr/local/ixp/library/Zend/Controller/Dispatcher/Standard.php
        [line] => 308
        [function] => dispatch
        [class] => Zend_Controller_Action
    )

[3] => Array
    (
        [file] => /usr/local/ixp/library/Zend/Controller/Front.php
        [line] => 954
        [function] => dispatch
        [class] => Zend_Controller_Dispatcher_Standard
    )

[4] => Array
    (
        [file] => /usr/local/ixp/library/Zend/Application/Bootstrap/Bootstrap.php
        [line] => 97
        [function] => dispatch
        [class] => Zend_Controller_Front
    )

[5] => Array
    (
        [file] => /usr/local/ixp/library/Zend/Application.php
        [line] => 366
        [function] => run
        [class] => Zend_Application_Bootstrap_Bootstrap
    )

[6] => Array
    (
        [file] => /usr/local/ixp/public/index.php
        [line] => 85
        [function] => run
        [class] => Zend_Application
    )

)


HTTP_HOST : portal.nwax.net
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:26.0) Gecko/20100101 Firefox/26.0
HTTP_COOKIE: oss_prefs={"iLength":50,"cdrs_period":"d","cdrs_settings":"hidden","cdrs_dataTables":true}; IXP_Manager=ouvb9g5g1jv0g5o4qf2bsmh0r2
REMOTE_PORT: 53613
REQUEST_METHOD: GET
REQUEST_URI: /ixp/switch/list

@barryo
Copy link
Member

barryo commented Feb 7, 2014

Did you follow the upgrade instructions?

https://github.com/inex/IXP-Manager/wiki/Installation-09-Upgrading-IXP-Manager

Specifically did you restart memcached? And did you update the submodules?

 - Barry

Sent from my phone, please excuse my brevity. 

-------- Original message --------
From: Brian Thompson notifications@github.com
Date:07/02/2014 18:43 (GMT+00:00)
To: inex/IXP-Manager IXP-Manager@noreply.github.com
Subject: [IXP-Manager] 3.6.6 Upgrade issue (#132)
Unexpected Error on https://portal.nwax.net/ixp/switch/list

Upgraded to 3.6.6 from working 3.6.5
1954 git fetch
1955 git checkout v3.6.6

Added mysql

mysql> select * from switch
-> ;
+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
| id | infrastructure | cabinetid | vendorid | name | hostname | ipv4addr | ipv6addr | snmppasswd | switchtype | model | active | os | osDate | osVersion | serialNumber | lastPolled | notes |
+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
| 1 | 1 | 1 | 13 | ex4500 | ex4500.nwax.net | 10.99.9.21 | | XxXxX | 1 | Unknown | 1 | Unknown | NULL | Unknown | NULL | 2014-02-01 01:08:12 | |
| 3 | 1 | 1 | 13 | ptk-fabric-nwax-1 | ptk-fabric-nwax-1.nwax.net | 10.99.9.22 | | XxXxX | 1 | ex4500-40f | 1 | JUNOS | 2013-06-14 01:37:19 | 12.3R3.4 | NULL | 2014-02-06 15:32:48 | |
| 4 | 1 | 2 | 1 | lpt-fabric-nwax-1 | lpt-fabric-nwax-1 | 10.99.9.31 | | XxXxX | 1 | C29xx Stacking | 1 | IOS | NULL | 12.2(58)SE2 | NULL | 2014-02-06 15:31:53 | |
+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
3 rows in set (0.00 sec)

2014-02-07T10:42:23-08:00 DEBUG (7) [184.76.92.213]: ErrorController::errorAction()
2014-02-07T10:42:23-08:00 ERR (3) [184.76.92.213]:

****************************** EXCEPTIONS *******************************

--------------------------- EXCEPTION --------------------------

Message: [Semantical Error] line 0, col 413 near 'serialNumber': Error: Class Entities\Switcher has no field or association named serialNumber
Line: 49
File: /usr/share/php/Doctrine/ORM/Query/QueryException.php

Trace:

#0 /usr/share/php/Doctrine/ORM/Query/Parser.php(429): Doctrine\ORM\Query\QueryException::semanticalError('line 0, col 413...', Object(Doctrine\ORM\Query\QueryException))
#1 /usr/share/php/Doctrine/ORM/Query/Parser.php(645): Doctrine\ORM\Query\Parser->semanticalError('Class Entities...', Array)
#2 /usr/share/php/Doctrine/ORM/Query/Parser.php(240): Doctrine\ORM\Query\Parser->processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement))
#3 /usr/share/php/Doctrine/ORM/Query/Parser.php(304): Doctrine\ORM\Query\Parser->getAST()
#4 /usr/share/php/Doctrine/ORM/Query.php(233): Doctrine\ORM\Query\Parser->parse()
#5 /usr/share/php/Doctrine/ORM/Query.php(245): Doctrine\ORM\Query->parse()
#6 /usr/share/php/Doctrine/ORM/AbstractQuery.php(737): Doctrine\ORM\Query->doExecute()
#7 /usr/share/php/Doctrine/ORM/AbstractQuery.php(538): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#8 /usr/local/ixp/application/controllers/SwitchController.php(156): Doctrine\ORM\AbstractQuery->getResult()
#9 /usr/local/ixp/library/OSS-Framework.git/OSS/Controller/Action/Trait/Doctrine2Frontend.php(190): SwitchController->listGetData()
#10 /usr/local/ixp/library/Zend/Controller/Action.php(516): IXPController_Frontend->listAction()
#11 /usr/local/ixp/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('listAction')
#12 /usr/local/ixp/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /usr/local/ixp/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#14 /usr/local/ixp/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#15 /usr/local/ixp/public/index.php(85): Zend_Application->run()
#16 {main}

Array
(
[0] => Array
(
[file] => /usr/local/ixp/library/OSS-Framework.git/OSS/Controller/Trait/Error.php
[line] => 78
[function] => compact_debug_backtrace
[class] => OSS_Debug
)

[1] => Array
(
[file] => /usr/local/ixp/library/Zend/Controller/Action.php
[line] => 516
[function] => errorAction
[class] => ErrorController
)

[2] => Array
(
[file] => /usr/local/ixp/library/Zend/Controller/Dispatcher/Standard.php
[line] => 308
[function] => dispatch
[class] => Zend_Controller_Action
)

[3] => Array
(
[file] => /usr/local/ixp/library/Zend/Controller/Front.php
[line] => 954
[function] => dispatch
[class] => Zend_Controller_Dispatcher_Standard
)

[4] => Array
(
[file] => /usr/local/ixp/library/Zend/Application/Bootstrap/Bootstrap.php
[line] => 97
[function] => dispatch
[class] => Zend_Controller_Front
)

[5] => Array
(
[file] => /usr/local/ixp/library/Zend/Application.php
[line] => 366
[function] => run
[class] => Zend_Application_Bootstrap_Bootstrap
)

[6] => Array
(
[file] => /usr/local/ixp/public/index.php
[line] => 85
[function] => run
[class] => Zend_Application
)
)

HTTP_HOST : portal.nwax.net
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:26.0) Gecko/20100101 Firefox/26.0
HTTP_COOKIE: oss_prefs={"iLength":50,"cdrs_period":"d","cdrs_settings":"hidden","cdrs_dataTables":true}; IXP_Manager=ouvb9g5g1jv0g5o4qf2bsmh0r2
REMOTE_PORT: 53613
REQUEST_METHOD: GET
REQUEST_URI: /ixp/switch/list


Reply to this email directly or view it on GitHub.

@pdxmaverick
Copy link
Author

Damn it JIM!!!

Thanks @barryo

Yes that fixed it

Brian Thompson
Senior Infrastructure Engineer // Senior Second Guesser

Direct: 503.943.6779
Mobile: 503.707.9018 // Twitter: iovation
www.iovation.com http://www.iovation.com/

On Fri, Feb 7, 2014 at 11:21 AM, barryo notifications@github.com wrote:

Did you follow the upgrade instructions?

https://github.com/inex/IXP-Manager/wiki/Installation-09-Upgrading-IXP-Manager

Specifically did you restart memcached? And did you update the submodules?

  • Barry

Sent from my phone, please excuse my brevity.

-------- Original message --------
From: Brian Thompson < notifications@github.com>
Date:07/02/2014 18:43 (GMT+00:00)
To: inex/IXP-Manager IXP-Manager@noreply.github.com
Subject: [IXP-Manager] 3.6.6 Upgrade issue (#132)
Unexpected Error on https://portal.nwax.net/ixp/switch/list

Upgraded to 3.6.6 from working 3.6.5
1954 git fetch
1955 git checkout v3.6.6

Added mysql

mysql> select * from switch
-> ;

+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
| id | infrastructure | cabinetid | vendorid | name | hostname | ipv4addr
| ipv6addr | snmppasswd | switchtype | model | active | os | osDate |
osVersion | serialNumber | lastPolled | notes |

+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
| 1 | 1 | 1 | 13 | ex4500 | ex4500.nwax.net | 10.99.9.21 | | XxXxX | 1 |
Unknown | 1 | Unknown | NULL | Unknown | NULL | 2014-02-01 01:08:12 | |
| 3 | 1 | 1 | 13 | ptk-fabric-nwax-1 | ptk-fabric-nwax-1.nwax.net |
10.99.9.22 | | XxXxX | 1 | ex4500-40f | 1 | JUNOS | 2013-06-14 01:37:19 |
12.3R3.4 | NULL | 2014-02-06 15:32:48 | |
| 4 | 1 | 2 | 1 | lpt-fabric-nwax-1 | lpt-fabric-nwax-1 | 10.99.9.31 | |
XxXxX | 1 | C29xx Stacking | 1 | IOS | NULL | 12.2(58)SE2 | NULL |
2014-02-06 15:31:53 | |

+----+----------------+-----------+----------+-------------------+----------------------------+------------+----------+------------+------------+----------------+--------+---------+---------------------+-------------+--------------+---------------------+-------+
3 rows in set (0.00 sec)

2014-02-07T10:42:23-08:00 DEBUG (7) [184.76.92.213]:
ErrorController::errorAction()
2014-02-07T10:42:23-08:00 ERR (3) [184.76.92.213]:

****************************** EXCEPTIONS *******************************

--------------------------- EXCEPTION --------------------------

Message: [Semantical Error] line 0, col 413 near 'serialNumber': Error:
Class Entities\Switcher has no field or association named serialNumber
Line: 49
File: /usr/share/php/Doctrine/ORM/Query/QueryException.php

Trace:

#0 /usr/share/php/Doctrine/ORM/Query/Parser.php(429):
Doctrine\ORM\Query\QueryException::semanticalError('line 0, col 413...',
Object(Doctrine\ORM\Query\QueryException))
#1 /usr/share/php/Doctrine/ORM/Query/Parser.php(645):
Doctrine\ORM\Query\Parser->semanticalError('Class Entities...', Array)
#2 /usr/share/php/Doctrine/ORM/Query/Parser.php(240):
Doctrine\ORM\Query\Parser->processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement))
#3 /usr/share/php/Doctrine/ORM/Query/Parser.php(304):
Doctrine\ORM\Query\Parser->getAST()
#4 /usr/share/php/Doctrine/ORM/Query.php(233):
Doctrine\ORM\Query\Parser->parse()
#5 /usr/share/php/Doctrine/ORM/Query.php(245): Doctrine\ORM\Query->parse()
#6 /usr/share/php/Doctrine/ORM/AbstractQuery.php(737):
Doctrine\ORM\Query->doExecute()
#7 /usr/share/php/Doctrine/ORM/AbstractQuery.php(538):
Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#8 /usr/local/ixp/application/controllers/SwitchController.php(156):
Doctrine\ORM\AbstractQuery->getResult()
#9
/usr/local/ixp/library/OSS-Framework.git/OSS/Controller/Action/Trait/Doctrine2Frontend.php(190):
SwitchController->listGetData()
#10 /usr/local/ixp/library/Zend/Controller/Action.php(516):
IXPController_Frontend->listAction()
#11 /usr/local/ixp/library/Zend/Controller/Dispatcher/Standard.php(308):
Zend_Controller_Action->dispatch('listAction')
#12 /usr/local/ixp/library/Zend/Controller/Front.php(954):
Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http),
Object(Zend_Controller_Response_Http))
#13 /usr/local/ixp/library/Zend/Application/Bootstrap/Bootstrap.php(97):
Zend_Controller_Front->dispatch()
#14 /usr/local/ixp/library/Zend/Application.php(366):
Zend_Application_Bootstrap_Bootstrap->run()
#15 /usr/local/ixp/public/index.php(85): Zend_Application->run()
#16 {main}

Array
(
[0] => Array
(
[file] =>
/usr/local/ixp/library/OSS-Framework.git/OSS/Controller/Trait/Error.php
[line] => 78
[function] => compact_debug_backtrace
[class] => OSS_Debug
)

[1] => Array
(
[file] => /usr/local/ixp/library/Zend/Controller/Action.php
[line] => 516
[function] => errorAction
[class] => ErrorController
)

[2] => Array
(
[file] => /usr/local/ixp/library/Zend/Controller/Dispatcher/Standard.php
[line] => 308
[function] => dispatch
[class] => Zend_Controller_Action
)

[3] => Array
(
[file] => /usr/local/ixp/library/Zend/Controller/Front.php
[line] => 954
[function] => dispatch
[class] => Zend_Controller_Dispatcher_Standard
)

[4] => Array
(
[file] => /usr/local/ixp/library/Zend/Application/Bootstrap/Bootstrap.php
[line] => 97
[function] => dispatch
[class] => Zend_Controller_Front
)

[5] => Array
(
[file] => /usr/local/ixp/library/Zend/Application.php
[line] => 366
[function] => run
[class] => Zend_Application_Bootstrap_Bootstrap
)

[6] => Array
(
[file] => /usr/local/ixp/public/index.php
[line] => 85
[function] => run
[class] => Zend_Application
)
)

HTTP_HOST : portal.nwax.net
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:26.0)
Gecko/20100101 Firefox/26.0
HTTP_COOKIE:
oss_prefs={"iLength":50,"cdrs_period":"d","cdrs_settings":"hidden","cdrs_dataTables":true};
IXP_Manager=ouvb9g5g1jv0g5o4qf2bsmh0r2
REMOTE_PORT: 53613
REQUEST_METHOD: GET
REQUEST_URI: /ixp/switch/list

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHubhttps://github.com//issues/132#issuecomment-34490302
.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants